Your flagged measurements
Home     Contact     About     FAQ     News     SNPs     Downloads     Preferences     MPD search:
Database table: strains


MPD data model / schema     Download center    

strains

Contains one row for every mouse strain referenced in MPD data.

strains has the following fields:

Field nameDescriptionData type*Null allowed?Key status
idunique MPD id number identifying strainintno primary key;
fnamestrain name formatted in HTMLno  
anamestrain name using ascii notationno secondary key;
prigroupMPD priority strain group (A, B, C, or D) that the strain is inyes (indicates no priority group)  
vendorvendor supplying the strainyes (unresolved strains)  
 
    J=JAX Cr=Charles River Tac=Taconic Hsd=Harlan
   
stocknumvendor's stock numberyes (unresolved strains)  
straintypestrain type codeyes (unresolved strains) foreign key on straintypes
straingenaltcode describing genomic alteration if anyyes (unresolved strains) foreign key on straingenalt
resolved"y" if strain resolved to an exact vendor and stock numberyes (indicates not resolved)  
commentmisc remarksyes  
festcodemap to MGI Festing web page namesyes for strains not mapping to Festing  
fullfnameif nonnull, this indicates that fname/aname is an abbreviated strain name used in MPD for convenience; fullfname is the official nomenclature.yes  
jaxavljax-mice availability level (updated by dba at reg. intervals)yes, for strains not available from jax-mice  
 
    Level1, Level2, Level3, Level4, Repos, ReCryo, OnHold
   

Notes

    The public download (strains.dat) uses some different fields and field names. It contains: 1) strainname (same as aname above); 2) longname (same as fullfname above); 3) mpd id (same as id); 4) prigroup; 5) vendor; 6) stocknum; 7) typecode (same as straintype); 8) genaltcode (same as straingenalt); 9) ndatasets which is a count of the number of datasets the strain is involved in.

Data example



* 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       Citing       Units & abbreviations       Change Log       News       Links       Usage terms & conditions
© Copyright 2009 Mouse Phenome Project and
The Jackson Laboratory
Leading the search for tomorrow's cures