sexdiff
Sex difference values for all MPD measurements. For example, it contains
the difference in heart rate between the average for DBA/2J female, and the average for DBA/2J male.
This difference value is normalized except in cases where male & female have opposite sign (+/-) or
where male value is 0 or female value is 0.
Contains one row per numeric MPD phenotypic measurement per strain.
sexdiff 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
|
| difftype | preferred difference to use, either "normdiff" or "diff" | | no |
|
| | normdiff=normalized difference; diff=actual difference | | | |
| normdiff | the normalized sex difference | numeric | no |
|
| rawdiff | the actual difference in measurement units | numeric | no |
|
| nmice | number of female mice and male mice | char[20] | no |
|
| | | | | |
| femaleval | the female strain mean | numeric | no |
|
| maleval | the male strain mean | numeric | no |
|
| zscore | z-score showing how the sex difference compared to other strains tested | numeric | no |
|
Notes
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