GUS Schema >> DoTS::SimilaritySpan

Table to record the specifics for each span (HSP) in a similarity

column nulls? type description
SIMILARITY_SPAN_ID no NUMBER(10,0) primary_key Edit
SIMILARITY_ID no DoTS::Similarity (NUMBER(10,0) )foreign key to Similarity Edit
MATCH_LENGTH no NUMBER(12,0) length of the match Edit
NUMBER_IDENTICAL no NUMBER(12,0) number of identical matches Edit
NUMBER_POSITIVE no NUMBER(12,0) number of postives allowing for conservative replacements Edit
SCORE no FLOATscore of this span Edit
BIT_SCORE FLOAT Edit
PVALUE_MANT no FLOATP value mantissa Edit
PVALUE_EXP no NUMBER(6,0) P value exponent Edit
SUBJECT_START NUMBER(12,0) position in subject where this match starts Edit
SUBJECT_END NUMBER(12,0) position in subject where this match ends Edit
QUERY_START NUMBER(12,0) position in query where this match starts Edit
QUERY_END NUMBER(12,0) position in query there this match ends Edit
IS_REVERSED no NUMBER(1,0) if true then this match is on the reverse strand Edit
READING_FRAME NUMBER(3,0) reading frame of the match if relevant (BLASTX etc) Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Subclasses: