Database Table rundb_experiment¶
Postgres database: iondb
Postgres table: rundb_experiment
Experiment description data model.
Lifecycle¶
Each sequencing run has a corresponding rundb_experiment table record. These database items are set by the Crawler process, which monitors directories containing PGM or Proton experiment data and creates a record for each new experiment it finds.
Referenced by¶
Schema¶
| Field | Type | Description |
|---|---|---|
| autoAnalyze | Boolean (Either True or False) | autoAnalyze |
| baselineRun | Boolean (Either True or False) | baselineRun |
| chefChipExpiration1 | String (up to 64) | chefChipExpiration1 |
| chefChipExpiration2 | String (up to 64) | chefChipExpiration2 |
| chefChipType1 | String (up to 64) | chefChipType1 |
| chefChipType2 | String (up to 64) | chefChipType2 |
| chefExtraInfo_1 | String (up to 128) | chefExtraInfo 1 |
| chefExtraInfo_2 | String (up to 128) | chefExtraInfo 2 |
| chefInstrumentName | String (up to 200) | chefInstrumentName |
| chefKitType | String (up to 64) | chefKitType |
| chefLastUpdate | Date (with time) | chefLastUpdate |
| chefLogPath | String (up to 512) | chefLogPath |
| chefLotNumber | String (up to 64) | chefLotNumber |
| chefManufactureDate | String (up to 64) | chefManufactureDate |
| chefMessage | Text | chefMessage |
| chefPackageVer | String (up to 64) | chefPackageVer |
| chefProgress | Floating point number | chefProgress |
| chefReagentID | String (up to 64) | chefReagentID |
| chefReagentsExpiration | String (up to 64) | chefReagentsExpiration |
| chefReagentsLot | String (up to 64) | chefReagentsLot |
| chefReagentsPart | String (up to 64) | chefReagentsPart |
| chefSamplePos | String (up to 64) | chefSamplePos |
| chefSolutionsExpiration | String (up to 64) | chefSolutionsExpiration |
| chefSolutionsLot | String (up to 64) | chefSolutionsLot |
| chefSolutionsPart | String (up to 64) | chefSolutionsPart |
| chefStatus | String (up to 256) | chefStatus |
| chefTipRackBarcode | String (up to 64) | chefTipRackBarcode |
| chipBarcode | String (up to 64) | chipBarcode |
| chipType | String (up to 32) | chipType |
| cycles | Integer | cycles |
| date | Date (with time) | date |
| diskusage | Integer | diskusage |
| displayName | String (up to 128) | displayName |
| expCompInfo | Text | expCompInfo |
| expDir | String (up to 512) | expDir |
| expName | String (up to 128) | expName |
| flows | Integer | flows |
| flowsInOrder | Text | flowsInOrder |
| ftpStatus | String (up to 512) | ftpStatus |
| id | Integer | ID |
| isReverseRun | Boolean (Either True or False) | isReverseRun |
| log | Text | log |
| metaData | Text | metaData |
| notes | String (up to 1024) | notes |
| pgmName | String (up to 64) | pgmName |
| pinnedRepResult | Boolean (Either True or False) | pinned representative result |
| plan | PlannedExperiment (ForeignKey) | the related rundb.PlannedExperiment row |
| platform | String (up to 128) | platform |
| rawdatastyle | String (up to 24) | rawdatastyle |
| reagentBarcode | String (up to 64) | reagentBarcode |
| repResult | Results (ForeignKey) | the related rundb.Results row |
| resultDate | Date (with time) | resultDate |
| reverse_primer | String (up to 128) | reverse primer |
| runMode | String (up to 64) | runMode |
| seqKitBarcode | String (up to 64) | seqKitBarcode |
| sequencekitbarcode | String (up to 512) | sequencekitbarcode |
| sequencekitname | String (up to 512) | sequencekitname |
| star | Boolean (Either True or False) | star |
| status | String (up to 512) | status |
| storageHost | String (up to 128) | storageHost |
| storage_options | String (up to 200) | storage options |
| unique | String (up to 512) | unique |
| usePreBeadfind | Boolean (Either True or False) | usePreBeadfind |
| user_ack | String (up to 24) | user ack |
Table of contents
Previous topic
Next topic
Database Table rundb_experimentanalysissettings