assaystats
Aggregate summary statistics for each MPD measurement. For example, one row contains the average
heart rate for all male mice measured. Contains one row per MPD numeric phenotypic measurement per sex.
assaystats 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 |
|
| sex | m or f | | no |
|
| nstrains | number of strains tested | int | no |
|
| mean | mean measurement value (mean of strain means) | numeric | no |
|
| median | median measurement value (median of strain means) | numeric | no |
|
| sd | standard deviation | numeric | no |
|
| se | standard error | numeric | no |
|
| cv | coefficient of variation | numeric | no |
|
| min | min measurement value (of strain means) | numeric | no |
|
| max | max measurement value (of strain means) | numeric | no |
|
* 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