dnasequencingrun

Table info.

Title DNA Sequencing Run
Description DNA Sequencing Run

Fields

Name Type Required Index Hidden On form Title Pick list Description
DNASequencingRunID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
Number1 float(20,10) Number1 number1
Number2 float(20,10) Number2 number2
Number3 float(20,10) Number3 number3
Ordinal int(11) Ordinal ordinal
PCRCocktailPrimer bit(1) PCR cocktail primer pcrCocktailPrimer
PCRForwardPrimerCode varchar(32) Forward primer code pcrForwardPrimerCode
PCRPrimerName varchar(32) Name pcrPrimerName
PCRPrimerSequence5_3 varchar(64) Sequence 5?3 Pcr Primer Sequence5_3
PCRReversePrimerCode varchar(32) Reverse primer code pcrReversePrimerCode
ReadDirection varchar(16) Read direction readDirection
Remarks text Remarks remarks
RunDate date Run date runDate
ScoreFileName varchar(32) Score file name scoreFileName
SequenceCocktailPrimer bit(1) Seq. cocktail primer sequenceCocktailPrimer
SequencePrimerCode varchar(32) Code Sequence Primer Code
SequencePrimerName varchar(32) Name Sequence Primer Name
SequencePrimerSequence5_3 varchar(64) Sequence 5?3 Sequence Primer Sequence5_3
Text1 varchar(32) Text1 text1
Text2 varchar(32) Text2 text2
Text3 varchar(64) Text3 text3
TraceFileName varchar(32) Trace file name traceFileName
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
YesNo3 bit(1) Yes No3 yesNo3
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
DNASequenceID int(11) MUL
RunByAgentID int(11) MUL
PreparedByAgentID int(11) MUL
GeneSequence text Gene Sequence geneSequence
DryadDOI varchar(256) Dryad DOI dryadDOI
SRAExperimentID varchar(64) SRA Experiment ID sraExperimentID
SRARunID varchar(64) SRA Run ID sraRunID
SRASubmissionID varchar(64) SRA Submission ID sraSubmissionID
DNAPrimerID int(11) MUL

Indexes

Name Fields Unique Nullable
FK2AF6F9D6265FB168 DNASequenceID
FK2AF6F9D65327F942 ModifiedByAgentID
FK2AF6F9D67699B003 CreatedByAgentID
FK2AF6F9D6851BDBC0 RunByAgentID
FK2AF6F9D68C3587CC DNAPrimerID
FK2AF6F9D6D76CA4E PreparedByAgentID
FKDNASEQRUNPREPBYAGT PreparedByAgentID
FKDNASEQRUNRUNBYAGT RunByAgentID
PRIMARY DNASequencingRunID

One-to-many relationships

Name Field Related table Related field
FKD0DAEB1678F036AA DNASequencingRunID dnasequencerunattachment DnaSequencingRunID
FK24CEBD78F036AA DNASequencingRunID dnasequencingruncitation DNASequencingRunID

Many-to-one relationships

Name Field Related table Related field
FK2AF6F9D6265FB168 DNASequenceID dnasequence DnaSequenceID
FK2AF6F9D65327F942 ModifiedByAgentID agent AgentID
FK2AF6F9D67699B003 CreatedByAgentID agent AgentID
FK2AF6F9D6851BDBC0 RunByAgentID agent AgentID
FK2AF6F9D68C3587CC DNAPrimerID dnaprimer DNAPrimerID
FK2AF6F9D6D76CA4E PreparedByAgentID agent AgentID
FKDNASEQRUNPREPBYAGT PreparedByAgentID agent AgentID
FKDNASEQRUNRUNBYAGT RunByAgentID agent AgentID