Subsequence

Contains a contiguous sequence of a nucleic acid molecule. Multiple Subsequences can make up a given NucleicAcid entry.
Contains either the full or partial nucleotide sequence of the nucleic acid molecule stored in NucleicAcid.
Todo: Currently the schema has no way of indicating an approximate position
of this Subsequence on the NucleicAcid as a whole.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse identifier for this Subsequence.
NucleicAcidWID	BIGINT	NUMBER	No	References the containing nucleic acid molecule.
FullSequence	CHAR(1)	CHAR(1)	Yes	'T' if this is the complete sequence of the nucleic acid molecule referenced by NucleicAcidWID, else 'F'.
Sequence	LONGTEXT	CLOB	Yes	Nucleotide sequence of this Subsequence.
Length	INT	NUMBER	Yes	Number of nucleotides (and characters) in Sequence. This value is calculated if it is not explicitely stated in the source dataset
LengthApproximate	VARCHAR	VARCHAR2(10)	Yes	Enumeration; indicates that Length approximates actual Sequence length: 'gt' for greater than, 'lt' for less than, or 'ne' for not equal.
PercentGC	FLOAT	NUMBER	Yes	Percentage of Sequence nucleotides that are either guanine or cytosine. This value is calculated if it is not explicitely stated in the source dataset
Version	VARCHAR	VARCHAR2(30)	Yes	Dataset-specific information to indicate the version of this Subsequence.
DataSetWID	BIGINT	NUMBER	No	Reference to the data set from which the entity came from

Referenced By

Table	Column
Feature	SequenceWID
SequenceMatch	QueryWID
SequenceMatch	MatchWID
RelatedTerm	OtherWID
CitationWIDOtherWID	OtherWID
CommentTable	OtherWID
CrossReference	OtherWID
CrossReference	CrossWID
Description	OtherWID
DBID	OtherWID
SynonymTable	OtherWID
ToolAdvice	OtherWID

Other Constraints

None.

Indexes

Name	Columns
Subsequence_NAWID	NucleicAcidWID
Subsequence_Length	Length
Subsequence_PercentGC	PercentGC
Subsequence_DWID	DATASETWID