transmart.deapp contains 563 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
de_chromosomal_region	chromosome	varchar	2	√		null
de_chromosomal_region	cytoband	varchar	100	√		null
de_chromosomal_region	end_bp	int8	19	√		null
de_chromosomal_region	gene_id	int8	19	√		null
de_chromosomal_region	gene_symbol	varchar	100	√		null
de_chromosomal_region	gpl_id	varchar	50	√		null
de_chromosomal_region	num_probes	int4	10	√		null
de_chromosomal_region	organism	varchar	200	√		null
de_chromosomal_region	region_id	bigserial	19		√	nextval('deapp.de_chromo_region_id_seq'::regclass)
de_chromosomal_region	region_name	varchar	100	√		null
de_chromosomal_region	start_bp	int8	19	√		null
de_concept_visit	concept_cd	varchar	50
de_concept_visit	sourcesystem_cd	varchar	50	√		null
de_concept_visit	visit_name	varchar	100
de_encounter_level	concept_id	varchar	500	√		null
de_encounter_level	link_type	varchar	50	√		null
de_encounter_level	study_id	varchar	50	√		null
de_encounter_type	encounter_num	numeric	38	√		null
de_encounter_type	link_type	varchar	50	√		null
de_encounter_type	link_value	varchar	200	√		null
de_encounter_type	study_id	varchar	200	√		null
de_gene_info	chrom	varchar	40	√		null
de_gene_info	chrom_start	int4	10	√		null
de_gene_info	chrom_stop	int4	10	√		null
de_gene_info	entrez_id	int4	10	√		null
de_gene_info	gene_info_id	serial	10		√	nextval('deapp.de_gene_info_gene_info_id_seq'::regclass)
de_gene_info	gene_name	varchar	255	√		null
de_gene_info	gene_source_id	int4	10			1
de_gene_info	gene_symbol	varchar	255
de_gene_info	strand	int2	5	√		null
de_gene_source	gene_source_id	int4	10
de_gene_source	gene_source_name	varchar	255
de_gene_source	release_date	timestamp	29,6	√		null
de_gene_source	url	varchar	255	√		null
de_gene_source	version	varchar	32	√		null
de_gpl_info	annotation_date	timestamp	29,6	√		null
de_gpl_info	gene_annotation_id	varchar	50	√		null
de_gpl_info	genome_build	varchar	20	√		null	E.g., hg19.
de_gpl_info	marker_type	varchar	100	√		null	E.g., Gene Expression, RNASEQ_TRANSCRIPT.
de_gpl_info	organism	varchar	100	√		null	Organism the platform applies to. E.g., Human.
de_gpl_info	platform	varchar	50				Primary key. Platform id. E.g., GPL1000, GPL96, RNASEQ_TRANSCRIPT_PLATFORM.
de_gpl_info	release_nbr	varchar	50	√		null
de_gpl_info	title	varchar	500	√		null	Title of the platform. E.g., microarray test data, rnaseq transcript level test data.
de_metabolite_annotation	biochemical_name	varchar	200
de_metabolite_annotation	biomarker_id	varchar	200	√		null
de_metabolite_annotation	gpl_id	varchar	50
de_metabolite_annotation	hmdb_id	varchar	50	√		null
de_metabolite_annotation	id	int8	19
de_metabolite_sub_pathways	gpl_id	varchar	50
de_metabolite_sub_pathways	id	int8	19
de_metabolite_sub_pathways	sub_pathway_name	varchar	200
de_metabolite_sub_pathways	super_pathway_id	int8	19	√		null
de_metabolite_sub_pway_metab	metabolite_id	int8	19
de_metabolite_sub_pway_metab	sub_pathway_id	int8	19
de_metabolite_super_pathways	gpl_id	varchar	50
de_metabolite_super_pathways	id	int8	19
de_metabolite_super_pathways	super_pathway_name	varchar	200	√		null
de_mrna_annotation	de_mrna_annotation_id	int8	19
de_mrna_annotation	gene_id	int8	19	√		null
de_mrna_annotation	gene_symbol	varchar	100	√		null
de_mrna_annotation	gpl_id	varchar	100	√		null
de_mrna_annotation	organism	varchar	200	√		null
de_mrna_annotation	probe_id	varchar	100	√		null
de_mrna_annotation	probeset_id	int8	19	√		null
de_obs_enroll_days	days_since_enroll	float8	17,17	√		null
de_obs_enroll_days	encounter_num	int8	19	√		null
de_obs_enroll_days	study_id	varchar	200	√		null
de_pathway	description	varchar	510	√		null
de_pathway	externalid	varchar	100	√		null
de_pathway	id	int8	19
de_pathway	name	varchar	300	√		null
de_pathway	pathway_uid	varchar	200	√		null
de_pathway	source	varchar	100	√		null
de_pathway	type	varchar	100	√		null
de_pathway	user_id	int8	19	√		null
de_pathway_gene	gene_id	varchar	200	√		null
de_pathway_gene	gene_symbol	varchar	200	√		null
de_pathway_gene	id	int8	19
de_pathway_gene	pathway_id	numeric	131089	√		null
de_protein_annotation	biomarker_id	varchar	200	√		null
de_protein_annotation	chromosome	varchar	5	√		null
de_protein_annotation	end_bp	int8	19	√		null
de_protein_annotation	gpl_id	varchar	50
de_protein_annotation	id	bigserial	19		√	nextval('deapp.protein_annotation_id'::regclass)
de_protein_annotation	organism	varchar	200	√		null
de_protein_annotation	peptide	varchar	200
de_protein_annotation	start_bp	int8	19	√		null
de_protein_annotation	uniprot_id	varchar	200	√		null
de_protein_annotation	uniprot_name	varchar	200	√		null
de_qpcr_mirna_annotation	gpl_id	varchar	20	√		null
de_qpcr_mirna_annotation	id_ref	varchar	100	√		null
de_qpcr_mirna_annotation	mirna_id	varchar	100	√		null
de_qpcr_mirna_annotation	mirna_symbol	varchar	100	√		null
de_qpcr_mirna_annotation	organism	varchar	200	√		null
de_qpcr_mirna_annotation	probe_id	varchar	100	√		null
de_qpcr_mirna_annotation	probeset_id	numeric	38
de_rbm_annotation	antigen_name	varchar	200
de_rbm_annotation	gene_id	varchar	200	√		null
de_rbm_annotation	gene_symbol	varchar	50	√		null
de_rbm_annotation	gpl_id	varchar	50
de_rbm_annotation	id	int8	19
de_rbm_annotation	uniprot_id	varchar	50	√		null
de_rbm_annotation	uniprot_name	varchar	200	√		null
de_rbm_data_annotation_join	annotation_id	int8	19
de_rbm_data_annotation_join	data_id	int8	19
de_rc_snp_info	alt	varchar	1000	√		null
de_rc_snp_info	amino_acid_change	varchar	100	√		null
de_rc_snp_info	chrom	varchar	4	√		null
de_rc_snp_info	clinsig	varchar	100	√		null
de_rc_snp_info	codon_change	varchar	1000	√		null
de_rc_snp_info	disease	varchar	500	√		null
de_rc_snp_info	effect	varchar	100	√		null
de_rc_snp_info	entrez_id	varchar	50	√		null
de_rc_snp_info	exon_id	varchar	100	√		null
de_rc_snp_info	exon_intron	varchar	50	√		null
de_rc_snp_info	functional_class	varchar	100	√		null
de_rc_snp_info	gene_biotype	varchar	100	√		null
de_rc_snp_info	gene_info	varchar	1000	√		null
de_rc_snp_info	gene_name	varchar	50	√		null
de_rc_snp_info	gmaf	varchar	10	√		null
de_rc_snp_info	hg_version	varchar	10	√		null
de_rc_snp_info	impact	varchar	50	√		null
de_rc_snp_info	pos	int8	19	√		null
de_rc_snp_info	recombination_map	numeric	18,6	√		null
de_rc_snp_info	recombination_rate	numeric	18,6	√		null
de_rc_snp_info	ref	varchar	1000	√		null
de_rc_snp_info	regulome_score	varchar	10	√		null
de_rc_snp_info	rs_id	varchar	50	√		null
de_rc_snp_info	snp_info_id	bigserial	19		√	nextval('deapp.de_rc_snp_info_seq'::regclass)
de_rc_snp_info	strand	varchar	1	√		null
de_rc_snp_info	transcript_id	varchar	100	√		null
de_rc_snp_info	variation_class	varchar	24	√		null
de_rnaseq_annotation	gene_id	varchar	50	√		null
de_rnaseq_annotation	gene_symbol	varchar	50	√		null
de_rnaseq_annotation	gpl_id	varchar	50	√		null
de_rnaseq_annotation	organism	varchar	30	√		null
de_rnaseq_annotation	probeset_id	int8	19	√		null
de_rnaseq_annotation	transcript_id	varchar	50	√		null
de_rnaseq_transcript_annot	chromosome	varchar	2	√		null
de_rnaseq_transcript_annot	end_bp	int8	19	√		null
de_rnaseq_transcript_annot	gpl_id	varchar	50
de_rnaseq_transcript_annot	id	int8	19
de_rnaseq_transcript_annot	ref_id	varchar	50
de_rnaseq_transcript_annot	start_bp	int8	19	√		null
de_rnaseq_transcript_annot	transcript	varchar	100	√		null
de_rnaseq_transcript_data	assay_id	int8	19				Primary key. Id used to link highdim data to assays in the de_subject_sample_mapping table.
de_rnaseq_transcript_data	log_normalized_readcount	float8	17,17	√		null	Log projection.
de_rnaseq_transcript_data	normalized_readcount	float8	17,17	√		null	Normalized projection.
de_rnaseq_transcript_data	readcount	int8	19	√		null	Base count.
de_rnaseq_transcript_data	transcript_id	int8	19				Id of the transcript, linking to id in de_rnaseq_transcript_annot.
de_rnaseq_transcript_data	zscore	float8	17,17	√		null	Zscore projection.
de_sample_snp_data	copy_number	float8	17,17	√		null
de_sample_snp_data	sample_id	varchar	50	√		null
de_sample_snp_data	snp_calls	varchar	4	√		null
de_sample_snp_data	snp_name	varchar	100	√		null
de_saved_comparison	comparison_id	int8	19
de_saved_comparison	query_id1	int8	19	√		null
de_saved_comparison	query_id2	int8	19	√		null
de_snp_calls_by_gsm	gsm_num	varchar	100	√		null
de_snp_calls_by_gsm	patient_num	int8	19	√		null
de_snp_calls_by_gsm	snp_calls	varchar	4	√		null
de_snp_calls_by_gsm	snp_name	varchar	100	√		null
de_snp_calls_by_gsm	trial_name	varchar	20	√		null
de_snp_copy_number	chrom	varchar	2	√		null
de_snp_copy_number	chrom_pos	int8	19	√		null
de_snp_copy_number	copy_number	int2	5	√		null
de_snp_copy_number	patient_num	int8	19	√		null
de_snp_copy_number	snp_name	varchar	50	√		null
de_snp_copy_number	trial_name	varchar	20	√		null
de_snp_data_by_patient	chrom	varchar	16	√		null
de_snp_data_by_patient	data_by_patient_chr	text	2147483647	√		null
de_snp_data_by_patient	patient_num	int8	19	√		null
de_snp_data_by_patient	ped_by_patient_chr	text	2147483647	√		null
de_snp_data_by_patient	snp_data_by_patient_id	int8	19
de_snp_data_by_patient	snp_dataset_id	int8	19	√		null
de_snp_data_by_patient	trial_name	varchar	255	√		null
de_snp_data_by_probe	a1	varchar	4000	√		null
de_snp_data_by_probe	a1_clob	text	2147483647	√		null
de_snp_data_by_probe	a2	varchar	4000	√		null
de_snp_data_by_probe	a2_clob	text	2147483647	√		null
de_snp_data_by_probe	bio_asy_geno_platform_probe_id	int8	19	√		null
de_snp_data_by_probe	c_a1_a1	numeric	131089	√		null
de_snp_data_by_probe	c_a1_a2	numeric	131089	√		null
de_snp_data_by_probe	c_a2_a2	numeric	131089	√		null
de_snp_data_by_probe	c_nocall	numeric	131089	√		null
de_snp_data_by_probe	created_by	varchar	30	√		null
de_snp_data_by_probe	created_date	date	13	√		null
de_snp_data_by_probe	data_by_probe	text	2147483647	√		null
de_snp_data_by_probe	dose_by_probe_blob	text	2147483647	√		null
de_snp_data_by_probe	genotype_probe_annotation_id	int8	19	√		null
de_snp_data_by_probe	gps_by_probe_blob	text	2147483647	√		null
de_snp_data_by_probe	gt_probability_threshold	numeric	131089	√		null
de_snp_data_by_probe	gts_by_probe_blob	text	2147483647	√		null
de_snp_data_by_probe	impute_quality	numeric	131089	√		null
de_snp_data_by_probe	maf	numeric	131089	√		null
de_snp_data_by_probe	minor_allele	varchar	2	√		null
de_snp_data_by_probe	modified_by	varchar	30	√		null
de_snp_data_by_probe	modified_date	date	13	√		null
de_snp_data_by_probe	probe_id	int8	19	√		null
de_snp_data_by_probe	probe_name	varchar	255	√		null
de_snp_data_by_probe	snp_data_by_probe_id	int8	19
de_snp_data_by_probe	snp_id	int8	19	√		null
de_snp_data_by_probe	snp_name	varchar	255	√		null
de_snp_data_by_probe	trial_name	varchar	255	√		null
de_snp_data_dataset_loc	location	int8	19	√		null
de_snp_data_dataset_loc	snp_data_dataset_loc_id	int8	19
de_snp_data_dataset_loc	snp_dataset_id	int8	19	√		null
de_snp_data_dataset_loc	trial_name	varchar	255	√		null
de_snp_gene_map	entrez_gene_id	varchar	50	√		null
de_snp_gene_map	gene_name	varchar	50	√		null
de_snp_gene_map	snp_id	int8	19	√		null
de_snp_gene_map	snp_name	varchar	50	√		null
de_snp_info	chrom	varchar	16	√		null
de_snp_info	chrom_pos	int8	19	√		null
de_snp_info	name	varchar	255	√		null
de_snp_info	snp_info_id	int8	19
de_snp_info_hg19_mv	chrom	varchar	4	√		null
de_snp_info_hg19_mv	exon_intron	varchar	50	√		null
de_snp_info_hg19_mv	pos	int8	19	√		null
de_snp_info_hg19_mv	recombination_rate	numeric	18,6	√		null
de_snp_info_hg19_mv	regulome_score	varchar	10	√		null
de_snp_info_hg19_mv	rs_id	varchar	50	√		null
de_snp_info_hg19_mv	rsgene	varchar	50	√		null
de_snp_probe	probe_name	varchar	255	√		null
de_snp_probe	snp_id	int8	19	√		null
de_snp_probe	snp_name	varchar	255	√		null
de_snp_probe	snp_probe_id	int8	19
de_snp_probe	vendor_name	varchar	255	√		null
de_snp_probe_sorted_def	chrom	varchar	16	√		null
de_snp_probe_sorted_def	num_probe	int8	19	√		null
de_snp_probe_sorted_def	platform_name	varchar	255	√		null
de_snp_probe_sorted_def	probe_def	text	2147483647	√		null
de_snp_probe_sorted_def	snp_id_def	text	2147483647	√		null
de_snp_probe_sorted_def	snp_probe_sorted_def_id	int8	19
de_snp_subject_sorted_def	assay_id	int8	19	√		null
de_snp_subject_sorted_def	bio_assay_platform_id	int8	19	√		null
de_snp_subject_sorted_def	patient_num	int8	19	√		null
de_snp_subject_sorted_def	patient_position	int4	10	√		null
de_snp_subject_sorted_def	snp_subject_sorted_def_id	int8	19
de_snp_subject_sorted_def	subject_id	varchar	255	√		null
de_snp_subject_sorted_def	trial_name	varchar	255	√		null
de_subject_acgh_data	assay_id	int8	19
de_subject_acgh_data	chip	float8	17,17	√		null	log2ratio
de_subject_acgh_data	flag	int2	5	√		null	call -2:homloss, -1:loss, 0:normal, 1:gain, 2:amp
de_subject_acgh_data	partition_id	numeric	131089	√		null
de_subject_acgh_data	patient_id	int8	19	√		null
de_subject_acgh_data	probamp	float8	17,17	√		null
de_subject_acgh_data	probgain	float8	17,17	√		null
de_subject_acgh_data	probhomloss	float8	17,17	√		null
de_subject_acgh_data	probloss	float8	17,17	√		null
de_subject_acgh_data	probnorm	float8	17,17	√		null
de_subject_acgh_data	region_id	int8	19
de_subject_acgh_data	segmented	float8	17,17	√		null	segmented log2ratio
de_subject_acgh_data	trial_name	varchar	50	√		null
de_subject_metabolomics_data	assay_id	int8	19	√		null
de_subject_metabolomics_data	log_intensity	float8	17,17
de_subject_metabolomics_data	metabolite_annotation_id	int8	19	√		null
de_subject_metabolomics_data	partition_id	numeric	131089	√		null
de_subject_metabolomics_data	patient_id	int8	19	√		null
de_subject_metabolomics_data	raw_intensity	float8	17,17
de_subject_metabolomics_data	subject_id	varchar	100	√		null
de_subject_metabolomics_data	trial_name	varchar	200	√		null
de_subject_metabolomics_data	trial_source	varchar	200	√		null
de_subject_metabolomics_data	zscore	float8	17,17
de_subject_microarray_data	assay_id	int8	19				Id used to link highdim data to assays in the de_subject_sample_mapping table.
de_subject_microarray_data	log_intensity	float8	17,17	√		null	Log projection.
de_subject_microarray_data	new_log	float8	17,17	√		null
de_subject_microarray_data	new_raw	float8	17,17	√		null
de_subject_microarray_data	new_zscore	float8	17,17	√		null
de_subject_microarray_data	partition_id	numeric	131089	√		null
de_subject_microarray_data	patient_id	int8	19	√		null	The patient id linking to the patient_dimension.
de_subject_microarray_data	probeset_id	int8	19
de_subject_microarray_data	raw_intensity	float8	17,17	√		null	Raw projection.
de_subject_microarray_data	sample_id	int8	19	√		null
de_subject_microarray_data	subject_id	varchar	50	√		null
de_subject_microarray_data	trial_name	varchar	50	√		null	Name of the trial. E.g., SHARED_HD_CONCEPTS_STUDY_C_PR. Not used.
de_subject_microarray_data	trial_source	varchar	200	√		null
de_subject_microarray_data	zscore	float8	17,17	√		null	Zscore projection.
de_subject_microarray_data_new	assay_id	int8	19	√		null
de_subject_microarray_data_new	log_intensity	float8	17,17	√		null
de_subject_microarray_data_new	patient_id	int8	19	√		null
de_subject_microarray_data_new	probeset_id	int8	19	√		null
de_subject_microarray_data_new	raw_intensity	float8	17,17	√		null
de_subject_microarray_data_new	trial_name	varchar	50	√		null
de_subject_microarray_data_new	trial_source	varchar	200	√		null
de_subject_microarray_data_new	zscore	float8	17,17	√		null
de_subject_microarray_logs	assay_id	int8	19	√		null
de_subject_microarray_logs	gene_symbol	varchar	50	√		null
de_subject_microarray_logs	log_intensity	numeric	131089	√		null
de_subject_microarray_logs	patient_id	int8	19	√		null
de_subject_microarray_logs	probeset	varchar	50	√		null
de_subject_microarray_logs	pvalue	float8	17,17	√		null
de_subject_microarray_logs	raw_intensity	numeric	131089	√		null
de_subject_microarray_logs	refseq	varchar	50	√		null
de_subject_microarray_logs	subject_id	varchar	20	√		null
de_subject_microarray_logs	timepoint	varchar	30	√		null
de_subject_microarray_logs	trial_name	varchar	15	√		null
de_subject_microarray_med	assay_id	int8	19	√		null
de_subject_microarray_med	gene_symbol	varchar	50	√		null
de_subject_microarray_med	log_intensity	numeric	131089	√		null
de_subject_microarray_med	mean_intensity	numeric	131089	√		null
de_subject_microarray_med	median_intensity	numeric	131089	√		null
de_subject_microarray_med	patient_id	int8	19	√		null
de_subject_microarray_med	probeset	varchar	50	√		null
de_subject_microarray_med	pvalue	float8	17,17	√		null
de_subject_microarray_med	raw_intensity	numeric	131089	√		null
de_subject_microarray_med	refseq	varchar	50	√		null
de_subject_microarray_med	stddev_intensity	numeric	131089	√		null
de_subject_microarray_med	subject_id	varchar	20	√		null
de_subject_microarray_med	timepoint	varchar	30	√		null
de_subject_microarray_med	trial_name	varchar	15	√		null
de_subject_microarray_med	zscore	float8	17,17	√		null
de_subject_mirna_data	assay_id	numeric	18
de_subject_mirna_data	log_intensity	numeric	131089	√		null
de_subject_mirna_data	partition_id	numeric	131089	√		null
de_subject_mirna_data	patient_id	numeric	18	√		null
de_subject_mirna_data	probeset_id	numeric	38
de_subject_mirna_data	raw_intensity	numeric	131089	√		null
de_subject_mirna_data	trial_name	varchar	50	√		null
de_subject_mirna_data	trial_source	varchar	200	√		null
de_subject_mirna_data	zscore	numeric	18,9	√		null
de_subject_protein_data	assay_id	numeric	131089	√		null
de_subject_protein_data	component	varchar	100	√		null
de_subject_protein_data	gene_id	varchar	200	√		null
de_subject_protein_data	gene_symbol	varchar	100	√		null
de_subject_protein_data	intensity	numeric	131089	√		null
de_subject_protein_data	log_intensity	numeric	131089	√		null
de_subject_protein_data	partition_id	numeric	131089	√		null
de_subject_protein_data	patient_id	numeric	38	√		null
de_subject_protein_data	protein_annotation_id	int8	19	√		null
de_subject_protein_data	subject_id	varchar	100	√		null
de_subject_protein_data	trial_name	varchar	50	√		null
de_subject_protein_data	zscore	numeric	131089	√		null
de_subject_proteomics_data	assay_id	int8	19	√		null
de_subject_proteomics_data	component	varchar	100	√		null
de_subject_proteomics_data	gene_id	int8	19	√		null
de_subject_proteomics_data	gene_symbol	varchar	100	√		null
de_subject_proteomics_data	intensity	int8	19	√		null
de_subject_proteomics_data	partition_id	numeric	131089	√		null
de_subject_proteomics_data	patient_id	int8	19	√		null
de_subject_proteomics_data	protein_annotation_id	int8	19	√		null
de_subject_proteomics_data	subject_id	varchar	100	√		null
de_subject_proteomics_data	trial_name	varchar	15	√		null
de_subject_proteomics_data	zscore	int8	19	√		null
de_subject_rbm_data	antigen_name	varchar	100	√		null
de_subject_rbm_data	assay_id	int8	19	√		null
de_subject_rbm_data	concept_cd	varchar	100	√		null
de_subject_rbm_data	data_uid	varchar	100	√		null
de_subject_rbm_data	gene_id	int4	10	√		null
de_subject_rbm_data	gene_symbol	varchar	100	√		null
de_subject_rbm_data	id	int8	19
de_subject_rbm_data	log_intensity	numeric	131089	√		null
de_subject_rbm_data	mean_intensity	numeric	131089	√		null
de_subject_rbm_data	median_intensity	numeric	131089	√		null
de_subject_rbm_data	n_value	int8	19	√		null
de_subject_rbm_data	normalized_value	float8	17,17	√		null
de_subject_rbm_data	partition_id	numeric	131089	√		null
de_subject_rbm_data	patient_id	int8	19	√		null
de_subject_rbm_data	rbm_panel	varchar	50	√		null
de_subject_rbm_data	stddev_intensity	numeric	131089	√		null
de_subject_rbm_data	timepoint	varchar	100	√		null
de_subject_rbm_data	trial_name	varchar	100	√		null
de_subject_rbm_data	unit	varchar	50	√		null
de_subject_rbm_data	value	float8	17,17	√		null
de_subject_rbm_data	zscore	float8	17,17	√		null
de_subject_rna_data	assay_id	int8	19	√		null
de_subject_rna_data	log_intensity	float8	17,17	√		null
de_subject_rna_data	partition_id	numeric	131089	√		null
de_subject_rna_data	patient_id	int8	19	√		null
de_subject_rna_data	probeset_id	varchar	200	√		null
de_subject_rna_data	raw_intensity	float8	17,17	√		null
de_subject_rna_data	trial_name	varchar	50	√		null
de_subject_rna_data	trial_source	varchar	200	√		null
de_subject_rna_data	zscore	float8	17,17	√		null
de_subject_rnaseq_data	assay_id	int8	19
de_subject_rnaseq_data	log_normalized_readcount	float8	17,17	√		null
de_subject_rnaseq_data	normalized_readcount	float8	17,17	√		null
de_subject_rnaseq_data	partition_id	int8	19	√		null
de_subject_rnaseq_data	patient_id	int8	19	√		null
de_subject_rnaseq_data	readcount	int8	19	√		null
de_subject_rnaseq_data	region_id	int8	19
de_subject_rnaseq_data	trial_name	varchar	50	√		null
de_subject_rnaseq_data	trial_source	varchar	200	√		null
de_subject_rnaseq_data	zscore	float8	17,17	√		null
de_subject_sample_mapping	assay_id	int8	19				Used as primary key of this table (although it is not an actual primary key and there is not even a proper index for this column). This key is references by high dimensional data tables, like de_subject_microarray_data and de_rnaseq_transcript_data.
de_subject_sample_mapping	assay_uid	varchar	100	√		null
de_subject_sample_mapping	category_cd	varchar	1000	√		null
de_subject_sample_mapping	concept_code	varchar	1000	√		null	Refers to concept_cd in concept_dimension. E.g., CTHD:HD:EXPLUNG.
de_subject_sample_mapping	data_uid	varchar	100	√		null
de_subject_sample_mapping	gpl_id	varchar	50	√		null	Id of the GPL platform for this sample. Links to de_gpl_info table.
de_subject_sample_mapping	omic_patient_id	int8	19	√		null
de_subject_sample_mapping	omic_patient_num	int8	19	√		null
de_subject_sample_mapping	omic_source_study	varchar	200	√		null
de_subject_sample_mapping	partition_id	numeric	131089	√		null
de_subject_sample_mapping	patient_id	int8	19	√		null	The patient id linking the patient_dimension. Should not be empty, although it is nullable.
de_subject_sample_mapping	patient_uid	varchar	50	√		null
de_subject_sample_mapping	platform	varchar	50	√		null
de_subject_sample_mapping	platform_cd	varchar	50	√		null
de_subject_sample_mapping	rbm_panel	varchar	50	√		null
de_subject_sample_mapping	sample_cd	varchar	200	√		null	Code to distinguish different samples for the same patient.
de_subject_sample_mapping	sample_id	int8	19	√		null
de_subject_sample_mapping	sample_type	varchar	100	√		null
de_subject_sample_mapping	sample_type_cd	varchar	50	√		null
de_subject_sample_mapping	site_id	varchar	100	√		null
de_subject_sample_mapping	source_cd	varchar	200	√		null
de_subject_sample_mapping	subject_id	varchar	100	√		null	Corresponds to a part of the sourcesystem_cd column of patient_dimension. The patient_id column should be used for properly referencing patients.
de_subject_sample_mapping	subject_type	varchar	100	√		null
de_subject_sample_mapping	timepoint	varchar	100	√		null
de_subject_sample_mapping	timepoint_cd	varchar	50	√		null
de_subject_sample_mapping	tissue_type	varchar	100	√		null
de_subject_sample_mapping	tissue_type_cd	varchar	50	√		null
de_subject_sample_mapping	trial_name	varchar	30	√		null	Name of the trial this sample is part of. Not used.
de_subject_snp_dataset	concept_cd	varchar	255	√		null
de_subject_snp_dataset	dataset_name	varchar	255	√		null
de_subject_snp_dataset	paired_dataset_id	int8	19	√		null
de_subject_snp_dataset	patient_gender	varchar	1	√		null
de_subject_snp_dataset	patient_num	int8	19	√		null
de_subject_snp_dataset	platform_name	varchar	255	√		null
de_subject_snp_dataset	sample_type	varchar	255	√		null
de_subject_snp_dataset	subject_id	varchar	255	√		null
de_subject_snp_dataset	subject_snp_dataset_id	int8	19
de_subject_snp_dataset	timepoint	varchar	255	√		null
de_subject_snp_dataset	trial_name	varchar	255	√		null
de_two_region_event	cga_type	varchar	500	√		null	deletion, inversion, duplication,... Type from http://cgatools.sourceforge.net/docs/1.8.0/cgatools-command-line-reference.html#junctions2events
de_two_region_event	soap_class	varchar	500	√		null	inter/intra chromosomal inversion/translocation: https://sourceforge.net/p/soapfuse/wiki/classification-of-fusions.for.SOAPfuse/
de_two_region_event	two_region_event_id	bigserial	19		√	nextval('deapp.de_two_region_event_seq'::regclass)
de_two_region_event_gene	effect	varchar	500	√		null	effect of the event on the gene: FUSION, CONTAINED, DISRUPTED, ...
de_two_region_event_gene	event_id	int8	19
de_two_region_event_gene	gene_id	varchar	50				HUGO gene identifier
de_two_region_event_gene	two_region_event_gene_id	bigserial	19		√	nextval('deapp.de_two_region_event_gene_seq'::regclass)
de_two_region_junction	assay_id	int8	19	√		null
de_two_region_junction	down_chr	varchar	50				chromosome of down stream fusion partner
de_two_region_junction	down_end	int8	19				end of down stream junction
de_two_region_junction	down_pos	int8	19				location of down stream junction point
de_two_region_junction	down_strand	bpchar	1	√		null	strand of down stream junction, 1 for +, 0 for -
de_two_region_junction	external_id	int8	19	√		null
de_two_region_junction	is_in_frame	bool	1	√		null	whether junction is frame-shift or in-frame-shift
de_two_region_junction	two_region_junction_id	bigserial	19		√	nextval('deapp.de_two_region_junction_seq'::regclass)
de_two_region_junction	up_chr	varchar	50				chromosome of up stream fusion partner
de_two_region_junction	up_end	int8	19				end of up stream junction
de_two_region_junction	up_pos	int8	19				location of up stream fusion partner's junction point
de_two_region_junction	up_strand	bpchar	1	√		null	strand of up stream junction, 1 for +, 0 for -
de_two_region_junction_event	base_freq	float8	17,17	√		null	frequency in the baseline set of genomes for the junction
de_two_region_junction_event	event_id	int8	19	√		null
de_two_region_junction_event	junction_id	int8	19	√		null
de_two_region_junction_event	pairs_end	int4	10	√		null	number of mate pairs that support the fusion and whose one end spans the fusion
de_two_region_junction_event	pairs_junction	int4	10	√		null	number of spanning mate pairs where one end spans a fusion
de_two_region_junction_event	pairs_span	int4	10	√		null	number of spanning mate pairs
de_two_region_junction_event	reads_counter	int4	10	√		null	number of reads that contradict the fusion by mapping to only one of the chromosomes
de_two_region_junction_event	reads_junction	int4	10	√		null	number of reads spanning the junction
de_two_region_junction_event	reads_span	int4	10	√		null	number of reads in the whole span
de_two_region_junction_event	two_region_junction_event_id	bigserial	19		√	nextval('deapp.de_two_rgn_junction_event_seq'::regclass)
de_variant_dataset	dataset_id	varchar	50
de_variant_dataset	datasource_id	varchar	200	√		null
de_variant_dataset	etl_date	date	13	√		null
de_variant_dataset	etl_id	varchar	20	√		null
de_variant_dataset	genome	varchar	50
de_variant_dataset	gpl_id	varchar	50	√		null
de_variant_dataset	metadata_comment	text	2147483647	√		null
de_variant_dataset	variant_dataset_type	varchar	50	√		null
de_variant_metadata	dataset_id	varchar	50	√		null
de_variant_metadata	de_variant_metadata_id	serial	10		√	nextval('deapp.de_variant_metadata_seq'::regclass)
de_variant_metadata	key	varchar	255	√		null
de_variant_metadata	value	text	2147483647	√		null
de_variant_population_data	chr	varchar	50	√		null
de_variant_population_data	dataset_id	varchar	50	√		null
de_variant_population_data	float_value	float8	17,17	√		null
de_variant_population_data	info_index	int4	10	√		0
de_variant_population_data	info_name	varchar	100	√		null
de_variant_population_data	integer_value	int8	19	√		null
de_variant_population_data	pos	int8	19	√		null
de_variant_population_data	text_value	varchar	4000	√		null
de_variant_population_data	variant_population_data_id	bigserial	19		√	nextval('deapp.de_variant_population_data_seq'::regclass)
de_variant_population_info	dataset_id	varchar	50	√		null
de_variant_population_info	description	text	2147483647	√		null
de_variant_population_info	info_name	varchar	100	√		null
de_variant_population_info	number	varchar	10	√		null
de_variant_population_info	type	varchar	30	√		null
de_variant_population_info	variant_population_info_id	bigserial	19		√	nextval('deapp.de_variant_population_info_seq'::regclass)
de_variant_subject_detail	alt	varchar	500	√		null
de_variant_subject_detail	chr	varchar	50	√		null
de_variant_subject_detail	dataset_id	varchar	50	√		null
de_variant_subject_detail	filter	varchar	50	√		null
de_variant_subject_detail	format	varchar	500	√		null
de_variant_subject_detail	info	varchar	10000	√		null
de_variant_subject_detail	pos	int8	19	√		null
de_variant_subject_detail	qual	varchar	100	√		null
de_variant_subject_detail	ref	varchar	500	√		null
de_variant_subject_detail	rs_id	varchar	50	√		null
de_variant_subject_detail	variant_subject_detail_id	bigserial	19		√	nextval('deapp.de_variant_subject_detail_seq'::regclass)
de_variant_subject_detail	variant_value	text	2147483647	√		null
de_variant_subject_idx	dataset_id	varchar	50	√		null
de_variant_subject_idx	position	int8	19	√		null
de_variant_subject_idx	subject_id	varchar	50	√		null
de_variant_subject_idx	variant_subject_idx_id	bigserial	19		√	nextval('deapp.de_variant_subject_idx_seq'::regclass)
de_variant_subject_summary	allele1	int4	10	√		null
de_variant_subject_summary	allele2	int4	10	√		null
de_variant_subject_summary	assay_id	int8	19	√		null	Reference to de_subject_sample_mapping
de_variant_subject_summary	chr	varchar	50	√		null
de_variant_subject_summary	dataset_id	varchar	50
de_variant_subject_summary	pos	int8	19	√		null
de_variant_subject_summary	reference	bool	1	√		null	This column contains a flag whether this subject has a reference value on this variant, or not.
de_variant_subject_summary	rs_id	varchar	500	√		null
de_variant_subject_summary	subject_id	varchar	50
de_variant_subject_summary	variant	varchar	1000	√		null
de_variant_subject_summary	variant_format	varchar	100	√		null
de_variant_subject_summary	variant_subject_summary_id	bigserial	19		√	nextval('deapp.de_variant_subject_summary_seq'::regclass)
de_variant_subject_summary	variant_type	varchar	100	√		null
de_variant_summary_detail_gene	allele1	int4	10	√		null
de_variant_summary_detail_gene	allele2	int4	10	√		null
de_variant_summary_detail_gene	alt	varchar	500	√		null
de_variant_summary_detail_gene	assay_id	int8	19	√		null
de_variant_summary_detail_gene	chr	varchar	50	√		null
de_variant_summary_detail_gene	dataset_id	varchar	50	√		null
de_variant_summary_detail_gene	filter	varchar	50	√		null
de_variant_summary_detail_gene	format	varchar	500	√		null
de_variant_summary_detail_gene	gene_id	varchar	4000	√		null
de_variant_summary_detail_gene	gene_name	varchar	4000	√		null
de_variant_summary_detail_gene	info	varchar	10000	√		null
de_variant_summary_detail_gene	pos	int8	19	√		null
de_variant_summary_detail_gene	qual	varchar	100	√		null
de_variant_summary_detail_gene	ref	varchar	500	√		null
de_variant_summary_detail_gene	reference	bool	1	√		null
de_variant_summary_detail_gene	rs_id	varchar	500	√		null
de_variant_summary_detail_gene	subject_id	varchar	50	√		null
de_variant_summary_detail_gene	variant	varchar	1000	√		null
de_variant_summary_detail_gene	variant_format	varchar	100	√		null
de_variant_summary_detail_gene	variant_subject_summary_id	int8	19	√		null
de_variant_summary_detail_gene	variant_type	varchar	100	√		null
de_variant_summary_detail_gene	variant_value	text	2147483647	√		null
de_xtrial_child_map	concept_cd	varchar	50
de_xtrial_child_map	manually_mapped	int8	19	√		null
de_xtrial_child_map	parent_cd	int8	19
de_xtrial_child_map	study_id	varchar	50	√		null
de_xtrial_parent_names	across_path	varchar	500	√		null
de_xtrial_parent_names	manually_created	int8	19	√		null
de_xtrial_parent_names	parent_cd	int8	19
deapp_annotation	annotation_type	varchar	50	√		null
deapp_annotation	annotation_value	varchar	100	√		null
deapp_annotation	gene_id	int8	19	√		null
deapp_annotation	gene_symbol	varchar	200	√		null
haploview_data	affection_status	int2	5	√		null
haploview_data	chromosome	varchar	10	√		null
haploview_data	father_id	int4	10	√		null
haploview_data	gene	varchar	50	√		null
haploview_data	i2b2_id	int8	19	√		null
haploview_data	jnj_id	varchar	30	√		null
haploview_data	mother_id	int4	10	√		null
haploview_data	release	int2	5	√		null
haploview_data	release_date	timestamp	29,6	√		null
haploview_data	sex	int2	5	√		null
haploview_data	snp_data	text	2147483647	√		null
haploview_data	trial_name	varchar	50	√		null
kegg	gene_id	varchar	20	√		null
kegg	gene_symbol	varchar	20	√		null
kegg	pathway	varchar	20	√		null
kegg_data	gene	varchar	200	√		null
kegg_data	gene_id	varchar	20	√		null
kegg_data	pathway	varchar	100	√		null
kegg_def	descr	varchar	500	√		null
kegg_def	pathway	varchar	100	√		null
ricerca	sample_id	varchar	100	√		null
ricerca	subject_id	varchar	20	√		null