Table Index

SequenceMatch


Records a result of a computation of the degree of match between two sequences.
Sequences are either both Proteins or both Subsequences.

Columns

Column MySQL Type Oracle Type Nullable Description
QueryWID BIGINT NUMBER No WID of the Protein or Subsequence being matched
MatchWID BIGINT NUMBER No WID of the Protein or Subsequence matched against QueryWID
ComputationWID BIGINT NUMBER No WID of the Computation that describes the procedure used to determine the match
EValue DOUBLE NUMBER Yes Roughly, the log-probability of this match occurring; see http://www.ncbi.nlm.nih.gov/BLAST/tutorial/Altschul-1.html
PValue DOUBLE NUMBER Yes 1 - e^(-E), where E is EValue
PercentIdentical FLOAT NUMBER Yes Percentage of residues in the two molecules that are identical
PercentSimilar FLOAT NUMBER Yes Percentage of residues in the two molecules that are similar
Rank SMALLINT NUMBER Yes Ordinal rank of Query molecule with other matches (1 is best)
Length INT NUMBER Yes The length of the match between the two molecules
QueryStart INT NUMBER Yes Start of the matching region in Query
QueryEnd INT NUMBER Yes End of the matching region in Query
MatchStart INT NUMBER Yes Start of the matching region in Match
MatchEnd INT NUMBER Yes End of the matching region in Match

Denormalized References

Column References
QueryWID Protein : WID
QueryWID Subsequence : WID
MatchWID Protein : WID
MatchWID Subsequence : WID

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
SM_QUERYWID QueryWID
SM_MATCHWID MatchWID
SM_COMPUTATIONWID ComputationWID
SM_EVALUE EValue
SM_PVALUE PValue
SM_PIDENTICAL PercentIdentical
SM_PSIMILAR PercentSimilar
SM_RANK Rank
SM_LENGTH Length
SM_QSTART_QEND QueryStart, QueryEnd
SM_QEND QueryEnd
SM_MSTART_MEND MatchStart,MatchEnd
SM_MEND MatchEnd