Expsample
Links the biological samples analyzed in an experiment to the assay reagent, protocol and results via the experiment sample record.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| expsample_accession | varchar(15) | Primary key | |
| description | varchar(4000) | Free text to expand upon details | |
| experiment_accession | varchar(15) | Foreign key reference to EXPERIMENT table | experiment.experiment_accession |
| name | varchar(200) | Name or identifier | |
| result_schema | varchar(50) | Standardized value in LK_RESULT_SCHEMA | lk_expsample_result_schema.name |
| upload_result_status | varchar(20) | Upload result status | |
| workspace_id | int(11) | Foreign key reference to WORKSPACE table | workspace.workspace_id |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | expsample_accession | BTREE |
| idx_expsample_experiment | experiment_accession | BTREE |
| idx_expsample_workspace | workspace_id | BTREE |
| fk_expsample_2 | result_schema | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| elisa_result | expsample_accession | expsample | expsample_accession |
| elispot_result | expsample_accession | expsample | expsample_accession |
| expsample_2_biosample | expsample_accession | expsample | expsample_accession |
| expsample_2_file_info | expsample_accession | expsample | expsample_accession |
| expsample_2_reagent | expsample_accession | expsample | expsample_accession |
| expsample_2_treatment | expsample_accession | expsample | expsample_accession |
| expsample_mbaa_detail | expsample_accession | expsample | expsample_accession |
| expsample_public_repository | expsample_accession | expsample | expsample_accession |
| fcs_analyzed_result | expsample_accession | expsample | expsample_accession |
| fcs_header | expsample_accession | expsample | expsample_accession |
| hai_result | expsample_accession | expsample | expsample_accession |
| hla_typing_result | expsample_accession | expsample | expsample_accession |
| kir_typing_result | expsample_accession | expsample | expsample_accession |
| mass_spectrometry_result | expsample_accession | expsample | expsample_accession |
| neut_ab_titer_result | expsample_accession | expsample | expsample_accession |
| pcr_result | expsample_accession | expsample | expsample_accession |