Postgres database: iondb
Postgres table: rundb_experiment
Experiment description data model.
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.
Field | Type | Description |
---|---|---|
autoAnalyze | Boolean (Either True or False) | autoAnalyze |
baselineRun | Boolean (Either True or False) | baselineRun |
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 |
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 |