GUS Schema >> DoTS::AssemblySequence

Table to hold the specific information about sequences contained in Assemblies

column nulls? type description
ASSEMBLY_SEQUENCE_ID no NUMBER(10,0) Primary key Edit
ASSEMBLY_NA_SEQUENCE_ID DoTS::NASequence (NUMBER(10,0) )foreign key to the Assembly table Edit
NA_SEQUENCE_ID no DoTS::NASequence (NUMBER(10,0) )foreign key to the ExternalNASequence table...identifies the input sequence Edit
SEQUENCE_START no NUMBER(12,0) position in the ExternalNASequence where the AssemblySequence starts Edit
SEQUENCE_END no NUMBER(12,0) position in the ExternalNASequence where the AssemblySequence ends Edit
QUALITY_START NUMBER(12,0) position in the ExternalNASequence where the cap4 determines the quality sequence starts Edit
QUALITY_END NUMBER(12,0) position in the ExternalNASequence where the cap4 determines the quality sequence ends Edit
ASSEMBLY_OFFSET no NUMBER(12,0) position in the assembly where this AssemblySequence begins Edit
ASSEMBLY_STRAND no NUMBER(1,0) Orientation of this AssemblySequence in the Assembly (0|1) Edit
GAPPED_SEQUENCE CLOB Edit
HAVE_PROCESSED no NUMBER(1,0) This sequence has been processed for assembly Edit
PROCESSED_CATEGORY STRING(50) Category of this processed sequence ('repeat','chimera','low_quality') if not included in an Assembly 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:

Assembly
     DoTS::AssemblySequenceSNP

Subclasses: