Table transmart.deapp.de_subject_microarray_data
Table holds microarray data values.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
trial_name varchar 50  √  null Name of the trial. E.g., SHARED_HD_CONCEPTS_STUDY_C_PR. Not used.
probeset_id int8 19
assay_id int8 19 Id used to link highdim data to assays in the de_subject_sample_mapping table.
patient_id int8 19  √  null The patient id linking to the patient_dimension.
sample_id int8 19  √  null
subject_id varchar 50  √  null
raw_intensity float8 17,17  √  null Raw projection.
log_intensity float8 17,17  √  null Log projection.
zscore float8 17,17  √  null Zscore projection.
new_raw float8 17,17  √  null
new_log float8 17,17  √  null
new_zscore float8 17,17  √  null
trial_source varchar 200  √  null
partition_id numeric 131089  √  null

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
assay_id + probeset_id Primary key Asc/Asc de_subject_microarray_data_pk