summstats
Strain means and associated summary statistics for all MPD measurements. For example, one row
contains the average heart rate for male DBA/2J mice. Contains one row per MPD numeric phenotypic measurement
per strain per sex.
summstats has the following fields:
| Field name | Description | Data type* | Null allowed? | Key status |
| measnum | measnum | int | no |
primary key;
foreign key on measurements
|
| varname | short name | | no |
|
| strain | strain name using ascii notation | | no |
|
| istrain | MPD strain id number | int | no |
secondary key;
foreign key on strains
|
| sex | m, f, or all | | no |
|
| | | | | |
| mean | mean measurement value for the strain/sex | numeric | no |
|
| nmice | number of mice tested for the strain/sex | char[20] | no |
|
| | (generally int but not always.. see mpd22) | | | |
| nmissing | number of missing observations | int | yes |
|
| sd | standard deviation | numeric | yes |
|
| se | standard error | numeric | yes |
|
| cv | coefficient of variation | numeric | yes |
|
| min | lowest measured value for the strain/sex | numeric | yes |
|
| max | highest measured value for the strain/sex | numeric | yes |
|
| logmean | mean measurement value in log space | numeric | yes |
|
| logsd | standard deviation, log space | numeric | yes |
|
| logse | standard error, log space | numeric | yes |
|
| logcv | coefficient of variation, log space | numeric | yes |
|
| zscore | z score for the strain/sex relative to set of strains tested | numeric | no |
|
| logzscore | z score, log space | numeric | yes |
|
Notes
Stats eg. sd, se, cv etc. may not be available where per-animal data were not supplied.
Log stats are computed by applying a log transform to individual animal values.
Log stats not available when there are animal values < 0, or where per-animal data were not supplied.
Strain name is redundant but present for optimization.
* Data types
If no data type is given, varchar[255] may be assumed.
As a guideline, projsyms and measurement varnames should be
short (~30 chars or less) with no embedded spaces.
For fields where a controlled vocabulary is shown, data type / char length
may be inferred from the enumerated vocabulary.
A data type of 'text' indicates text of unlimited length.
Content is stored in files; linkage is by filenames which contain embedded id info,
the particulars of which are up to the application. Data table field contains 1 if
there is text.
|
Suggestion box
Hints