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.

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

Table of contents

Previous topic

Database Table rundb_eventlog

Next topic

Database Table rundb_experimentanalysissettings

This Page