Data fields documentation

Please contact us if more information or clarification is needed.

pheno_measures

One row per phenotype measure / trait.
     Column     |          Type          |                                            Description
----------------+------------------------+---------------------------------------------------------------------------------------------------
 measnum        | integer                | MPD measure ID number
 projsym        | character varying(40)  | project / data set identifier 
 mpdsector      | character varying(40)  | analysis paradigm  css=strainsurvey  doutbred=DO  qtla  komp  
 seriestype     | character varying(40)  | if row is for a measure series, gives the type; null for singletons
 varname        | character varying(40)  | short variable name for measure (singletons only, currently null for measure series)
 descrip        | text                   | description of measure or series
 units          | character varying(40)  | unit of measurement
 datatype       | character varying(40)  | 'categorical' or null if numeric
 magnitude      | integer                | order of magnitude used sometimes eg. 3 for mpd:6201 or -3 for mpd:36169
 method         | character varying(80)  | phenotyping procedure / method term 
 intervention   | character varying(80)  | drug, diet, pathogen, or challenge if any 
 paneldesc      | character varying(40)  | the strain panel 
 sextested      | character varying(5)   | m  f  or  both
 ageweeks       | character varying(40)  | age term (animal age at test); 
 granularity    | character varying(80)  | animal= mpd has individual animal data;  strain = mpd has strain means only
 projyear       | character varying(10)  | year of project 
 nstrainstested | integer                | number of strains (or similar) for which data are available
 avgsampsize    | numeric                | average sample size eg. number of mice per analysis group
 labelpre       | character varying(80)  | for series, word(s) appearing before the label, in generated indiv. measure descriptions
 labelpost      | character varying(80)  | for series, word(s) appearing after the label, in generated indiv. measure descriptions
 seriespre      | character varying(80)  | for series, word(s) appearing before the serieslabels
 serieslabels   | text                   | for series, a comma-delimited list of all series labels



strains

One row per strain.
   Column       |          Type          |           Description
----------------+------------------------+--------------------------------------------------------------------------------------------------------------
 strainname     | character varying(128) | current strain nomenclature in <ascii> notation
 vendor         | character varying(40)  | strain vendor code 
 stocknum       | character varying(255) | vendor stock number for the strain
 panel          | character varying(80)  | strain panel that this strain belongs to, if any
 mpd_strainid   | integer                | integer MPD ID for the strain
 straintype     | character varying(20)  | code indicating general strain type; IN = inbred, WDI = wild-derived, RI, etc.
 n_proj         | integer                | number of MPD phenotype projects / data sets involving the strain
 n_snp_datasets | integer                | number of MPD SNP data sets involving the strain
 mpd_shortname  | character varying(128) | if the official strain nomenclature is lengthy MPD uses this shorter name in data displays
 url            | character varying(256) | url of a web page for this strain



animaldatapoints

One row per animal phenotype numeric reading.
  Column   |         Type          |                         Description
-----------+-----------------------+--------------------------------------------------------------
 measnum   | integer               | MPD integer measure ID 
 strainid  | integer               | integer MPD strain ID 
 sex       | character varying(5)  | f or m
 animal_id | character varying(80) | animal identifier as supplied by submitting investigator/lab
 measval   | numeric               | numeric measured value
 zscore    | numeric               | Z-score of animal reading relative to strain/sex mean



strainmeans

One row per strain/sex mean measurement. These are ordinary unadjusted strain means.
  Column   |          Type          |                                     Description
-----------+------------------------+----------------------------------------------------------------------------
 measnum   | integer                | MPD integer measure ID 
 varname   | character varying(80)  | short variable name for the measure 
 strain    | character varying(255) | strain name 
 strainid  | integer                | MPD integer strain ID 
 sex       | character varying(5)   | f or m
 mean      | numeric                | strain/sex average (mean) measured value
 nmice     | integer                | strain/sex number of mice, number of usable observations
 sd        | numeric                | SD associated with the mean
 sem       | numeric                | SEM associated with the mean
 cv        | numeric                | CV (coefficient of variation) associated with the mean
 minval    | numeric                | minima observation / measured value
 maxval    | numeric                | maxima observation / measured value
 zscore    | numeric                | Z-score of the mean relative to the grand mean of all strains studied.