Database Table rundb_experiment ============================================================================ Postgres database: ``iondb`` Postgres table: ``rundb_experiment`` .. include:: ../manual_database_ref_docs/rundb_experiment.rst Schema ------- +----------------------+----------------------------------+-------------------------------------------+ | 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 | +----------------------+----------------------------------+-------------------------------------------+