GUS Schema >> DoTS::Similarity

"Table to record Similarities between two identifers in the database (BLAST, FASTA, SIM4 etc)"

column nulls? type description
SIMILARITY_ID no NUMBER(10,0) primary_key Edit
SUBJECT_TABLE_ID no Core::TableInfo (NUMBER(5,0) )"table_id of the subject part of the similarity (ie, the entry from the database)" Edit
SUBJECT_ID no NUMBER(10,0) row_id of the subject Edit
QUERY_TABLE_ID no Core::TableInfo (NUMBER(5,0) )table_id of the query part of the similarity Edit
QUERY_ID no NUMBER(10,0) row_id of the query Edit
SCORE no FLOATscore of the similarity Edit
BIT_SCORE_SUMMARY FLOAT Edit
PVALUE_MANT no FLOATP value mantissa Edit
PVALUE_EXP no NUMBER(6,0) P value exponent Edit
MIN_SUBJECT_START no NUMBER(12,0) minimum location in the subject of the match Edit
MAX_SUBJECT_END no NUMBER(12,0) maximum location in the subject of the match Edit
MIN_QUERY_START no NUMBER(12,0) minimum location in the query of the match Edit
MAX_QUERY_END no NUMBER(12,0) maximum location in the query of the match Edit
NUMBER_OF_MATCHES no NUMBER(5,0) number of spans (HSPs for BLAST) that are involved in this similarity Edit
TOTAL_MATCH_LENGTH no NUMBER(12,0) total length of all the matches Edit
NUMBER_IDENTICAL no NUMBER(12,0) total number of identical matches Edit
NUMBER_POSITIVE no NUMBER(12,0) total number of positives (conservative replacements) Edit
IS_REVERSED no NUMBER(1,0) matches on the reverse strand Edit
READING_FRAME NUMBER(3,0) reading frame of this Similarity 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:

Similarity
     DoTS::ConsistentAlignment
     DoTS::SimilaritySpan
Misc Applications
     DoTS::GeneFeatureSeqOverlap

Subclasses: