GeneX Development Supported By
|
GeneX-2.0 DB: HotSpots Table
|
GeneX-2.0 DB: HotSpots Table
|
| Table Type | Inherits | Comment |
| LINKING | none | 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 Name | Full Name | Data Type | Not NULL | Comment |
| es_fk | es_fk | int | true | |
| rep_fk | rep_fk | int | true | |
| threshold_type | threshold_type | char128 | false | 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 Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| es_fk | ExperimentSet | es_pk | LINKING_TABLE |
| rep_fk | Reporter | rep_pk | LINKING_TABLE |
| Unique Column Information |
| Column Names |
| rep_fk es_fk |
| Index Information |
| Name | Column Name |
| es_fk | hotspots_es_fk |
| rep_fk | hotspots_rep_fk |
|