GUS Schema >> DoTS::Assembly (subclass of DoTS::NASequence )

The Assembly view of NASequenceImp stores information and consensus sequences generated by assembling EST and mRNA sequences using the cap4 algorithm (Paracel).

Light yellow rows indicate columns provided from the superclass.

column nulls? type description
NA_SEQUENCE_ID no NUMBER(10,0) Primary Key Edit
SEQUENCE_VERSION no NUMBER(3,0) Edit
SUBCLASS_VIEW no STRING(30) Edit
SEQUENCE_TYPE_ID DoTS::SequenceType (NUMBER(4,0) ) Edit
SEQUENCE_ONTOLOGY_ID SRes::SequenceOntology (NUMBER(10,0) ) Edit
TAXON_ID SRes::Taxon (NUMBER(12,0) ) Edit
SEQUENCE CLOB Edit
LENGTH NUMBER(12,0) Edit
A_COUNT NUMBER(12,0) Edit
C_COUNT NUMBER(12,0) Edit
G_COUNT NUMBER(12,0) Edit
T_COUNT NUMBER(12,0) Edit
OTHER_COUNT NUMBER(12,0) Edit
DESCRIPTION STRING(2000) Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) ) Edit
SOURCE_NA_SEQUENCE_ID DoTS::NASequence (NUMBER(10,0) ) Edit
SEQUENCE_PIECE_ID DoTS::SequencePiece (NUMBER(10,0) ) Edit
SEQUENCING_CENTER_CONTACT_ID SRes::Contact (NUMBER(12,0) ) Edit
FULL_LENGTH_CDS NUMBER(3,0) Edit
ASSEMBLY_CONSISTENCY NUMBER(10,0) Consistency of the assembly by scoring each column where consistency = number of majority nucleotide / total number in columnnormalized over length of assembly where depth > 1 Edit
CONTAINS_MRNA NUMBER(1,0) set to 1 if >= 1 contained AssemblySequence is of sequence type "mRNA" Edit
NUMBER_OF_CONTAINED_SEQUENCES NUMBER(12,0) The number of sequences contained in the Assembly Edit
NOTES STRING(255) Edit
GAPPED_CONSENSUS CLOBconsensus sequence including the gaps inserted by cap4 Edit
QUALITY_VALUES CLOBstring of quality values assigned by cap4 Edit

Child tables:

Subclasses: