corrstrong
Correlation coefficients between all possible
combinations of two numeric MPD measurements. Only those pairs having a best
pearson of magnitude 0.5 or better are retained.
Measurement pairs are correlated based on strain/sex means. Contains one row per measurement pair / sex.
corrstrong has the following fields:
| Field name | Description | Data type* | Null allowed? | Key status |
| measnum1 | measurement 1 | int | no |
primary key;
foreign key on measurements
|
| measnum2 | measurement 2 | int | no |
secondary key;
foreign key on measurements
|
| sex | m or f | | no |
|
| nstrains | number of strains in common between meas1 and meas2 | int | no |
|
| abspearson | absolute value pearson, helpful with certain retrievals | numeric | no |
|
| pearson | pearson correlation coefficient, linear vs. linear | numeric | no |
|
| spearman | spearman correlation coefficient | numeric | no |
|
| recipflag | 1 or 0. Each meas pair appears twice; select where recipflag = 0 to get unique list | | no |
|
Notes
The 'corrweak' table uses this same format.
* 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