Database Table rundb_plannedexperiment¶
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.
Lifecycle¶
Created by user in the Torrent Browser Planning tab.
Referenced by¶
Schema¶
| 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 |
