Export Combined Data

How it works:

Select parameters from Complete Blood Count, HLQ, INTERPRETIVE, and/or OMICS data (Metabolomics, Proteomics, Metagenomics, Microbiome)
Choose export options (format, join strategy, Complete Blood Count format)
Preview combined data before downloading
Export as CSV or TAB-delimited file

Join Strategy:

Inner Join (only participants in ALL selected tables)

Left Join (all participants, NULLs for missing)

Filter by Cohort:Filter participants by study cohort

Complete Blood Count Format:

Wide (one row per participant, tests as columns)

Long (multiple rows per participant)

Export Format:

Will be selected on preview page

	UniProt ID
	Fold Change
	P-Value
	Collection Date
	Study ID
Proteins (11) Select specific proteins to export
	Adiponectin
	Albumin
	C-Reactive Protein
	Ferritin
	Hemoglobin A1c
	IGF-1
	Immunoglobulin G
	Insulin
	Interleukin-6
	Leptin
	Transferrin

	Sample ID
	Sample Type
	Taxonomic Rank
	Sequencing Technology
	Instrument Model
	Collection Date
	Study ID
Taxa (13) Select specific taxa to export
	Actinobacteria
	Akkermansia
	Bacteroides
	Bacteroidetes
	Bifidobacterium
	Blautia
	Faecalibacterium
	Firmicutes
	Prevotella
	Proteobacteria
	Roseburia
	Ruminococcus
	Verrucomicrobia

Direct Columns
	Participant ID
	Study ID
	Questionnaire Completed At
	Age
	Sex
	Living Alone
	General Health
	Takes Supplements
	Supplement Count
	Age (SDC)
	Sex (SDC)
	Living Alone Status
Questionnaire Columns 281 columns available
	CMMI_ADM_QX_COMPLETION
	CMMI_DIS_ACUTE_FAIL_EVER
	CMMI_DIS_ADDICTION_DISORDER_EVER
	CMMI_DIS_ALZHEIMER_EVER
	CMMI_DIS_ANGINA_EVER
	CMMI_DIS_ANKYLOSING_SPONDYLITIS_EVER
	CMMI_DIS_ANXIETY_DIS_EVER
	CMMI_DIS_ANXIETY_EVER
	CMMI_DIS_ARRHYTHMIA_EVER
	CMMI_DIS_ARTHRITIS_EVER
	CMMI_DIS_ARTHRITIS_OA_EVER
	CMMI_DIS_ARTHRITIS_OTHER_EVER
	CMMI_DIS_ARTHRITIS_RA_EVER
	CMMI_DIS_ARTHRITIS_TYPE_OTSP
	CMMI_DIS_ASTHMA_EVER
	CMMI_DIS_ATRIAL_EVER
	CMMI_DIS_BIPOLAR_DIS_EVER
	CMMI_DIS_BONES_EVER
	CMMI_DIS_CANCER_EVER
	CMMI_DIS_CARDIO_EVER
	CMMI_DIS_CB_EVER
	CMMI_DIS_CELIAC_EVER
	CMMI_DIS_CHD_EVER
	CMMI_DIS_CHRONIC_FAIL_EVER
	CMMI_DIS_CH_EVER
	CMMI_DIS_COPD_EVER

	Study ID
	HMDB ID
	Concentration Unit
	Below LOD
	Date of Measurement
	Operator
	Run ID
	Experimental Method
	Experimental Conditions
	Storage Conditions
	Internal Sample ID
Metabolites (1795) Select specific metabolites to export
	1,3-Diaminopropane
	1,3-Dimethyluric Acid
	1-Methylguanosine
	1-Methylinosine
	1-Methylnicotinamide
	1-Methyluric acid
	1H-Indole-4-carboxaldehyde
	2,5-Furandicarboxylic acid
	2-Aminopimelic acid
	2-Hydroxy-2-methylbutyric acid
	2-Hydroxy-3-methylvaleric acid+2-hydroxy-4-methylpentanoic acid
	2-Hydroxybutyric acid
	2-Hydroxyisobutyric acid
	2-Hydroxyisovaleric acid
	2-Hydroxyphenylacetic acid
	2-Isopropylmalic acid
	2-Methylbutyrlglycine
	2-Methylglutaric acid
	2-Oxoadipic acid
	2-Oxoisocaproic acid
	2-Phenylpropionic acid
	2-hydroxyglutaric acid
	2-oxovaleric acid
	3,4-Dihydroxybutyric acid
	3-(3-Hydroxyphenyl)-3-hydroxypropanoic acid
	3-Aminobutyric acid
	3-Aminoisobutyric acid
	3-Carboxy-4-methyl-5-propyl-2-furanpropionic acid