GUS Schema >> DoTS::AssemblySNP

Table to record information about SNPs found in Assemblies

column nulls? type description
ASSEMBLY_SNP_ID no NUMBER(10,0) primary_key Edit
NA_SEQUENCE_ID no DoTS::NASequence (NUMBER(10,0) )relation to the Assembly table Edit
NUM_A no NUMBER(8,0) number of A bases in this column Edit
NUM_C no NUMBER(8,0) number of C bases in this column Edit
NUM_G no NUMBER(8,0) number of G bases in this column Edit
NUM_T no NUMBER(8,0) number of T bases in this column Edit
NUM_OTHER no NUMBER(8,0) numbe of other bases (such as N) in this column Edit
NUC_1 no CHARACTER(1) predominant nucleotide (ACGTN) Edit
NUC_2 CHARACTER(1) second most prevalent nucleotide Edit
NUC_3 CHARACTER(1) third most prevalent nucleotide Edit
NUC_4 CHARACTER(1) fourth most prevalent nucleotide Edit
NUM_NUC_1 no NUMBER(8,0) number of most prevalent nucleotide Edit
NUM_NUC_2 NUMBER(8,0) number of second most prevalent nucleotide Edit
NUM_NUC_3 NUMBER(8,0) number of third most prevalent nucleotide Edit
NUM_NUC_4 NUMBER(8,0) number of fourth most prevalent nucleotide Edit
FRAction_NUC_1 no FLOATfraction that represents the most prevalent nucleotide (number most prevalent / Assembly depth) Edit
NUM_DISTINCT_ACGT no NUMBER(1,0) number of distinct different nuclotides at this position Edit
ASSEMBLY_DEPTH no NUMBER(5,0) depth (number of sequences at this position Edit
ASSEMBLY_POSITION no NUMBER(8,0) position in the assembly (including gaps) of this SNP Edit
CONSENSUS_POSITION no NUMBER(8,0) position in the consensus sequence of this SNP 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: