Observations Output Schema

Field name	Data type	Description
experiment_source_file	string	Source experiment XML file path
specimen_source_file	string	Source specimen XML file path
experiment_id	string	Unique ID hash for experiment
observation_id	string	Unique ID hash for observation
allele_accession_id	string	MGI allele accession ID
gene_accession_id	string	MGI gene accession ID
project_name	string
strain_accession_id	string	MGI strain accession ID
litter_id	string	Specimen litter ID
phenotyping_center	string	Specimen phenotyping center
phenotyping_cons	string	Specimen phenotyping consortium
external_sample_id	string	Specimen ID from the XML file
developmental_stage_name	string	Human readable specimen developmental stage from EFO
developmental_stage_acc	string	EFO id for the specimen developmental stage
datasource_name	string	File datasource, could be IMPC, 3i, MGP or EuroPhenome
age_in_days	integer	Age in days of the specimen on the experiment date
date_of_birth	string	Date of birth of the specimen
metadata	array[string]	Metadata parameters in the " = " form
metadata_group	string	Hash value of the metadata parameters that generate a metadata split
sequence_id	string
experiment_source_id	string	Experiment ID from the XML file
gene_symbol	string	Gene symbol
biological_sample_group	string	Biological sample group for the specimen could be "experimental" or "control"
sex	string	Specimen sex could be "male", "female", "no data"
allele_symbol	string	Allele symbol
production_center	string	Specimen production center
age_in_weeks	integer	Specimen age in weeks on the experiment date
weight	string	Closest specimen weight on the experiment date
weight_date	string	Closest date where the specimen weight was measured
weight_days_old	string	Specimen age on days on the weight measurement date
weight_parameter_stable_id	string	IMPReSS parameter stable ID for the specimen weight measurement
colony_id	string	Specimen colony ID
zygosity	string	Specimen zygosity could be "homozygote", "hemizygote" or "heterozygote"
allelic_composition	string	Specimen allelic composition
pipeline_name	string	IMPReSS pipeline name
pipeline_stable_id	string	IMPReSS pipeline stable ID
procedure_name	string	IMPReSS procedure name
procedure_stable_id	string	IMPReSS procedure stable ID
procedure_group	string	IMPReSS procedure group
parameter_name	string	IMPReSS parameter name
parameter_stable_id	string	IMPReSS parameter stable ID
parameter_status	string
observation_type	string	Observation type could be "categorical", "time_series", "image_record", "unidimensional", "ontological", "text"
data_point	string	Measured value for unidimensional and time series observations
text_value	string	Measured value for text observations
category	string	Measured value for categorical observation
strain_name	string	Specimen strain name
genetic_background	string	Specimen genetic background
date_of_experiment	string	Date of experiment
sub_term_name	array[string]	Measured value for ontological observations: ontology term name
sub_term_id	array[string]	Measured value for ontological observations: ontology term id
sub_term_description	array[string]	Measured value for ontological observations: ontology term description
discrete_point	string	Discrete point for time series observations
time_point	string	Time point for time series observations
download_file_path	string	Download file type for image record observations
file_type	string	File type for image record observations
parameter_association_stable_id	array[string]	Associated parameter stable ID for image record observations
parameter_association_sequence_id	array[string]	Associated parameter sequence ID for image record observations
parameter_association_name	array[string]	Associated parameter name for image record observations
parameter_association_value	array[string]	Associated parameter value for image record observations