GeneX-2.0 DB: ExperimentSet Table
GeneX-2.0 DB: ExperimentSet Table
Table TypeInheritsComment
DATAIdentifiable The ExperimentSet table groups a set of PhysicalBioAssay rows into a coherent collection representing a conceptually related set of treatments (e.g. time series or quantity series) of the same genetic elements. In its standard use, all PhysicalBioAssays belonging to a single ExperimentSet will derive from the same ArrayDesign and will have been assayed by the same group. However, there may be cases in which virtual ExperimentSets may be created to link PhysicalBioAssays that illustrate some interesting relationship, even though they do not meet these criteria.

Column Information
Column NameFull NameData TypeNot NULLComment
analysis_descriptionAnalysis Descriptiontextfalse high level description of how experiment was analyzed
biology_descriptionBiology Descriptiontextfalse gives the intended purpose of the experiment
cit_fkPrimary Citationintfalse publication in which experiment was described
es_pkAccession Numberserialfalse
local_accessionLocal Accession Numberchar128false id of experiment in submitter's database
provider_con_fkData Providerintfalse the researcher that provided the experiment info it is important to destinquish between this and the rw_groupname because if data is imported from another DB then the owner of the data will not be the individual that submitted it.
quantity_series_typeQuantity Series Typechar128falsecontrolled vocab, only appropriate for quantity series
release_dateRelease Datedatetimefalse
treatment_typeTreatment Typechar128falsecontrolled vocab

Primary Key Information
Column Name
es_pk

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
cit_fkCitationcit_pkONE_TO_ONE
provider_con_fkContactcon_pkMANY_TO_ONE

Unique Column Information
Column Names
name

Index Information
NameColumn Name