GeneX-2.0 DB: HotSpots Table
GeneX-2.0 DB: HotSpots Table
Table TypeInheritsComment
LINKINGnone The HotSpots table indicates a subset of Reporters whose expression levels changed above a given threshold during the course of an experiment. It can be used to quickly access experiments in which genes of interest seemed to be important. It applies to the processed ratio values derived by comparing levels of expression under treatments to those under control conditions. ??It remains to be seen if this wouldn't better be done as a view. Not doing ??so introduces consistency problems if PhysicalBioAssays are added to ??experiments or values are changed.

Column Information
Column NameFull NameData TypeNot NULLComment
es_fkes_fkinttrue
rep_fkrep_fkinttrue
threshold_typethreshold_typechar128false controlled vocab, specifies the threshold used to select the interesting genes, may further specify if the sense is up-regulation down-regulation or an absolute change above the threshold level

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
es_fkExperimentSetes_pkLINKING_TABLE
rep_fkReporterrep_pkLINKING_TABLE

Unique Column Information
Column Names
rep_fk es_fk

Index Information
NameColumn Name
es_fkhotspots_es_fk
rep_fkhotspots_rep_fk