Postgres database: iondb
Postgres table: rundb_plannedexperiment
Planned experiment description data model.
Note: Use this table (not other tables in the related tables list) if you are doing LIMS integration.
Created by user in the Torrent Browser Planning tab.
Field | Type | Description |
---|---|---|
adapter | String (up to 256) | adapter |
applicationGroup | ApplicationGroup (ForeignKey) | the related rundb.ApplicationGroup row |
autoName | String (up to 512) | autoName |
categories | String (up to 64) | categories |
chipBarcode | String (up to 64) | chipBarcode |
controlSequencekitname | String (up to 512) | controlSequencekitname |
cycles | Integer | cycles |
date | Date (with time) | date |
expName | String (up to 128) | expName |
get_sample_count | Integer | None |
id | Integer | ID |
irworkflow | String (up to 1024) | irworkflow |
isFavorite | Boolean (Either True or False) | isFavorite |
isPlanGroup | Boolean (Either True or False) | isPlanGroup |
isReusable | Boolean (Either True or False) | isReusable |
isReverseRun | Boolean (Either True or False) | isReverseRun |
isSystem | Boolean (Either True or False) | isSystem |
isSystemDefault | Boolean (Either True or False) | isSystemDefault |
latestEAS | ExperimentAnalysisSettings (ForeignKey) | the related rundb.ExperimentAnalysisSettings row |
libkit | String (up to 512) | libkit |
libraryReadLength | Positive integer | libraryReadLength |
metaData | Text | metaData |
pairedEndLibraryAdapterName | String (up to 512) | pairedEndLibraryAdapterName |
parentPlan | PlannedExperiment (ForeignKey) | the related rundb.PlannedExperiment row |
planDisplayedName | String (up to 512) | planDisplayedName |
planExecuted | Boolean (Either True or False) | planExecuted |
planExecutedDate | Date (with time) | planExecutedDate |
planGUID | String (up to 512) | planGUID |
planName | String (up to 512) | planName |
planPGM | String (up to 128) | planPGM |
planShortID | String (up to 5) | planShortID |
planStatus | String (up to 512) | planStatus |
preAnalysis | Boolean (Either True or False) | preAnalysis |
reverse_primer | String (up to 128) | reverse primer |
runMode | String (up to 64) | runMode |
runType | String (up to 512) | runType |
runname | String (up to 255) | runname |
sampleGrouping | SampleGroupType_CV (ForeignKey) | the related rundb.SampleGroupType_CV row |
samplePrepKitName | String (up to 512) | samplePrepKitName |
sampleSet | SampleSet (ForeignKey) | the related rundb.SampleSet row |
sampleSet_planIndex | Positive integer | sampleSet planIndex |
sampleSet_planTotal | Positive integer | sampleSet planTotal |
sampleSet_uid | String (up to 512) | sampleSet uid |
sampleTubeLabel | String (up to 512) | sampleTubeLabel |
seqKitBarcode | String (up to 64) | seqKitBarcode |
storageHost | String (up to 128) | storageHost |
storage_options | String (up to 200) | storage options |
templatingKitBarcode | String (up to 64) | templatingKitBarcode |
templatingKitName | String (up to 512) | templatingKitName |
templatingSize | String (up to 64) | templatingSize |
usePostBeadfind | Boolean (Either True or False) | usePostBeadfind |
usePreBeadfind | Boolean (Either True or False) | usePreBeadfind |
username | String (up to 128) | username |