dnasequence

Table info.

Title DNA Sequence
Description DNA Sequence

Fields

Name Type Required Index Hidden On form Title Pick list Description
DnaSequenceID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
AmbiguousResidues int(11) Ambiguous Ambiguous residues
BOLDBarcodeID varchar(32) MUL BOLD barcode ID boldBarcodeId
BOLDLastUpdateDate date BOLD last update boldLastUpdateDate
BOLDSampleID varchar(32) MUL BOLD sample ID boldSampleId
BOLDTranslationMatrix varchar(64) BOLD translation matrix boldTranslationMatrix
CompA int(11) Comp A compA
CompC int(11) Comp C compC
CompG int(11) Comp G compG
compT int(11) Comp T compT
GenBankAccessionNumber varchar(32) MUL Genbank accession number Genbank accession number
GeneSequence text Sequence The actual sequence
MoleculeType varchar(32) Molecule type MoleculeType
  • DNA
  • RNA
 moleculeType
Number1 float(20,10) Number1 number1
Number2 float(20,10) Number2 number2
Number3 float(20,10) Number3 number3
Remarks text Remarks remarks
TargetMarker varchar(32) Marker MolecularMarker
  • rbcL
  • matK
  • rpL32-trnL
  • ITS
  • ETS
  • 28S
  • rpb2
  • rpoC1
  • trnL-F
  • psbA-trnH
  • rps4-trnAS
  • rpb1
  • tef1
  • cox3
  • LSU
  • rpoB
  • ITS2
  • ITS and partial LSU
  • nrLSU
  • Unknown
  • partial SSU, ITS and partial LSU
  • nLSU
  • gpd
  • mcm7
 targetMarker
Text1 varchar(32) Text1 text1
Text2 varchar(32) Sample # Sample number
Text3 varchar(64) Text3 text3
TotalResidues int(11) Total residues Total number of residues (sequence length in bp)
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
YesNo3 bit(1) Yes No3 yesNo3
CollectionObjectID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
AgentID int(11) MUL
MaterialSampleID int(11) MUL
ExtractionDate date Extraction Date extractionDate
ExtractionDatePrecision tinyint(4) Extraction Date Precision extractionDatePrecision
SequenceDate date Sequence Date sequenceDate
SequenceDatePrecision tinyint(4) Sequence Date Precision sequenceDatePrecision
ExtractorID int(11) MUL

Indexes

Name Fields Unique Nullable
BOLDBarcodeIDX BOLDBarcodeID
BOLDSampleIDX BOLDSampleID
FK9F42F5D8384B3622 AgentID
FK9F42F5D85327F942 ModifiedByAgentID
FK9F42F5D875E37458 CollectionObjectID
FK9F42F5D87699B003 CreatedByAgentID
FK9F42F5D8A1F7C080 MaterialSampleID
FK9F42F5D8E43B7581 ExtractorID
GenBankAccIDX GenBankAccessionNumber
PRIMARY DnaSequenceID

One-to-many relationships

Name Field Related table Related field
FKFFC2E0FB265FB168 DnaSequenceID dnasequenceattachment DnaSequenceID
FK2AF6F9D6265FB168 DnaSequenceID dnasequencingrun DNASequenceID
FKF0EDCE24265FB168 DnaSequenceID extractor DNASequenceID
FK5D6EE8F4265FB168 DnaSequenceID pcrperson DNASequenceID

Many-to-one relationships

Name Field Related table Related field
FK9F42F5D8384B3622 AgentID agent AgentID
FK9F42F5D85327F942 ModifiedByAgentID agent AgentID
FK9F42F5D875E37458 CollectionObjectID collectionobject CollectionObjectID
FK9F42F5D87699B003 CreatedByAgentID agent AgentID
FK9F42F5D8A1F7C080 MaterialSampleID materialsample MaterialSampleID
FK9F42F5D8E43B7581 ExtractorID agent AgentID