GUS Schema >> DoTS::AssemblySequenceSNP

table that records the specifics of the putative SNP in this AssemblySequence

column nulls? type description
ASSEMBLY_SEQUENCE_SNP_ID no NUMBER(10,0) primary_key Edit
ASSEMBLY_SEQUENCE_ID no DoTS::AssemblySequence (NUMBER(10,0) )foreign key to AssemblySequence Edit
ASSEMBLY_SNP_ID no DoTS::AssemblySNP (NUMBER(10,0) )foreign key to AssemblySNP Edit
GAPPED_LOCATION no NUMBER(8,0) position in the gapped AssemblySequence of this SNP Edit
NA_SEQUENCE_LOCATION NUMBER(8,0) position in the NASequence from which this AssemblySequence is derived of this SNP Edit
SEQUENCE_CHARACTER no CHARACTER(1) the character at this position in this sequence. Intended to facilitate haplotype identification. 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:

Subclasses: