GeneX Development Supported By
|
GeneX-2.0 DB: ExperimentSet Table
|
GeneX-2.0 DB: ExperimentSet Table
|
| Table Type | Inherits | Comment |
| DATA | Identifiable | 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 Name | Full Name | Data Type | Not NULL | Comment |
| analysis_description | Analysis Description | text | false | high level description of how experiment was analyzed |
| biology_description | Biology Description | text | false | gives the intended purpose of the experiment |
| cit_fk | Primary Citation | int | false | publication in which experiment was described |
| es_pk | Accession Number | serial | false | |
| local_accession | Local Accession Number | char128 | false | id of experiment in submitter's database |
| provider_con_fk | Data Provider | int | false | 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_type | Quantity Series Type | char128 | false | controlled vocab, only appropriate for quantity series |
| release_date | Release Date | datetime | false | |
| treatment_type | Treatment Type | char128 | false | controlled vocab |
| Primary Key Information |
| Column Name |
| es_pk |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| cit_fk | Citation | cit_pk | ONE_TO_ONE |
| provider_con_fk | Contact | con_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| name |
| Index Information |
| Name | Column Name |
|