CINXE.COM

<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'> <html> <head>  <title>SchemaSpy - pub.mgd</title> <link rel=stylesheet href='schemaSpy.css' type='text/css'> <meta HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=ISO-8859-1'> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript' SRC='jquery.js'></SCRIPT> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript' SRC='schemaSpy.js'></SCRIPT> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript'> $(function(){ associate($('#showTables'), $('.tbl')); associate($('#showViews'), $('.view')); jQuery.fn.alternateRowColors = function() { $('tbody tr:visible').each(function(i) { if (i % 2 == 0) { $(this).removeClass('even').addClass('odd'); } else { $(this).removeClass('odd').addClass('even'); } }); return this; }; $('#showTables, #showViews').click(function() { $('table.dataTable').alternateRowColors(); }); $('table.dataTable').alternateRowColors(); }) </SCRIPT> </head> <body> <TABLE WIDTH="100%" BORDER=0 CELLPADDING=0 CELLSPACING=0> <TR> <TD WIDTH="100%"> <TABLE WIDTH="100%" BORDER=0 CELLPADDING=0 CELLSPACING=0> <TR> <TD WIDTH="20%" VALIGN="center" ALIGN="left"> <A HREF="http://www.informatics.jax.org/" border=0><IMG SRC="http://www.informatics.jax.org/webshare/images/mgi_logo.jpg" BORDER=0 HEIGHT="70" WIDTH="160" ALT="Mouse Genome Informatics"></A> </TD> <TD WIDTH="60%" ALIGN="center" VALIGN="center" BGCOLOR="#ffffff"> Schema Browser </TD> <TD WIDTH="20%" VALIGN="center" ALIGN="center" BGCOLOR="#ffffff">   </TD> </TR> <TR> <TD COLSPAN=3 style="background-color:#0000ff;">  Mouse Genome Informatics </TD> </TR> <TR> <TD> <CENTER> <A HREF="http://www.informatics.jax.org/" vlink="#0000ff">MGI Home</A>    <a href="http://www.informatics.jax.org/mgihome/help/help.shtml" vlink="#0000ff">Help</A> </CENTER> </TD> </TR> </TABLE> </TD> </TR> <TR><TD> </TD></TR> </TABLE> <table id='headerHolder' cellspacing='0' cellpadding='0'><tr><td> <div id='header'> <ul> <li id='current'><a href='index.html' title='All tables and views in the schema'>Tables</a></li> <li><a href='relationships.html' title='Diagram of table relationships'>Relationships</a></li> <li><a href='utilities.html' title='View of tables with neither parents nor children'>Utility Tables</a></li> <li><a href='constraints.html' title='Useful for diagnosing error messages that just give constraint name or number'>Constraints</a></li> <li><a href='columns.byTable.html' title="All of the columns in the schema">Columns</a></li> </ul> </div> </td></tr></table> <div class='content' style='clear:both;'> <table width='100%' border='0' cellpadding='0'> <tr> <td class='heading' valign='middle'>SchemaSpy Analysis of pub.mgd</td> <td class='heading' align='right' valign='top' title='John Currier - Creator of Cool Tools'>Generated by <a href='http://schemaspy.sourceforge.net' target='_blank'>SchemaSpy</a></td> </tr> </table> <table width='100%'> <tr><td class='container'> Generated by <a href='http://schemaspy.sourceforge.net' target='_blank'>SchemaSpy</a> on Mon Sep 11 06:12 EDT 2023 </td></tr> <tr> <td class='container'>Database Type: PostgreSQL - 12.10 </td> <td class='container' align='right' valign='top' rowspan='3'> <a href='http://sourceforge.net' target='_blank'><img src='http://sourceforge.net/sflogo.php?group_id=137197&type=1' alt='SourceForge.net' border='0' height='31' width='88'></a> <div style="margin-right: 2pt;"> <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td> </tr> <tr> <td class='container'> <a href='pub.mgd.xml' title='XML Representation'>XML Representation</a> <a href='insertionOrder.txt' title='Useful for loading data into a database'>Insertion Order</a> <a href='deletionOrder.txt' title='Useful for purging data from a database'>Deletion Order</a> (for database loading/purging scripts)</td> </tr> </table> <div class='indent'> <label for='showTables'><input type='checkbox' id='showTables' checked>Tables</label> <label for='showViews'><input type='checkbox' id='showViews' checked>Views</label> <label for='showComments'><input type=checkbox checked id='showComments'>Comments</label> <table class='dataTable' border='1' rules='groups'> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup class='comment'> <thead align='left'> <tr> <th valign='bottom'>Table / View</th> <th align='right' valign='bottom'>Children</th> <th align='right' valign='bottom'>Parents</th> <th align='right' valign='bottom'>Columns</th> <th align='right' valign='bottom'>Rows</th> <th class='comment' align='left' valign='bottom'>Comments</th> </tr> </thead> <tbody> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/acc_accession.html'>acc_accession</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>33,823,535</td> <td class='comment detail'>Master Accession table; stores all internal (MGI) and external accession numbers for any accessionable object. Each accession number has a prefix (non-numeric) part and a numeric part. Accession numbers are assigned to a specific object (_Object_key) within a specific data set (_MGIType_key), to a specific logical database (_LogicalDB_key). Accession numbers which are designated as private (1) are not dispalyed or searchable via the Web. Preferred accession numbers are the *primary* accession numbers for a given object. See ACC_AccessionMax, ACC_AccessionReference.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/acc_accessionmax.html'>acc_accessionmax</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>2</td> <td class='comment detail'>Stores the current maximum numeric part for the "J:" and "MGI:" prefixes. Set maximum field to 0 when initializing a new record. When a new ACC_Accession record is added, maxNumericPart is incremented and ACC_Accession.numericPart is assigned that value. See ACC_Accession.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/acc_accessionreference.html'>acc_accessionreference</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>9,073,422</td> <td class='comment detail'>Accession Reference table; A record in this table is the reference for a specific Accession number. See ACC_Accession.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/acc_actualdb.html'>acc_actualdb</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>82</td> <td class='comment detail'>Defines physical location, by URL, of an external data resource. Used to dynamically construct HTML links for the Web interface. Detail table of ACC_LogicalDB.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/acc_logicaldb.html'>acc_logicaldb</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>167</td> <td class='comment detail'>Defines a logical entity to which to attach accession numbers. Examples include: Sequence DB, MGI, RIKEN, etc.. After a logical entity is defined, multiple URLs (actual database objects) may be attached to the logical object. Master table of ACC_ActualDB.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/acc_mgitype.html'>acc_mgitype</a></td> <td class='detail' align='right'>21</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>36</td> <td class='comment detail'>Controlled vocabulary table of all accessionable object types in the system. Accessionable objects will be assigned MGI accession numbers during inserts. See ACC_Accession.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/acc_view.html'>acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>21</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_acc_view.html'>all_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_allele.html'>all_allele</a></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>21</td> <td class='detail' align='right'>769,801</td> <td class='comment detail'>A record in this table represents one Allele. An Allele is any of the alternative forms of a gene occupying a given locus; any one of several mutational forms of a gene. In MGI, allelic variants are associated with phenotypes. See ALL_Marker_Assoc. A transgenic Allele will contain a Strain of Origin, and a new Strain can then be bred from this trangene. This new Strain will be associated with the transgenic allele (see PRB_Strain, PRB_Strain_Marker). For example, see TR11000/MMRRC/UC-Davis. For example: MGI:4847055/Tg(Foxi2-EGFP)HX217Gsat, strain of origin: FVB/NTac. New Strain: MGI:5003868/STOCK Tg(Foxi2-EGFP)HX217Gsat/Mmucd associated with MGI:5003868/Tg(Foxi2-EGFP)HX217Gsat via PRB_Strain/PRB_Strain_Marker.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_allele_cellline.html'>all_allele_cellline</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>842,879</td> <td class='comment detail'>A record in this table represents the association between an Allele and a Cell Line. The type of Cell Line associated with the Allele depends on the Allele Type. See ALL_CellLine.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_allele_cellline_view.html'>all_allele_cellline_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>23</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_allele_driver_view.html'>all_allele_driver_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_allele_mutation.html'>all_allele_mutation</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>713,255</td> <td class='comment detail'>A record in this table represents the Molecular Mutation for a specific Allele. An Allele can have 0 or more Molecular Mutations.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_allele_mutation_view.html'>all_allele_mutation_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_allele_subtype_view.html'>all_allele_subtype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_allele_view.html'>all_allele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>34</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_annot_view.html'>all_annot_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_cellline.html'>all_cellline</a></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>957,910</td> <td class='comment detail'>A record in this table represents a parental or a mutant ES Cell Line.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_cellline_acc_view.html'>all_cellline_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_cellline_derivation.html'>all_cellline_derivation</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>3,152</td> <td class='comment detail'>A record in this table represents the Derivation of a Cell Line. See ALL_CellLine.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_cellline_derivation_view.html'>all_cellline_derivation_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>27</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_cellline_view.html'>all_cellline_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>26</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_cre_cache.html'>all_cre_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>24</td> <td class='detail' align='right'>62,804</td> <td class='comment detail'>A record in this table represents the cached values of a Cre Allele (that may/may not contain Assay information). See ALL_Allele, GXD_Assay, allcacheload/allelecrecache.csh.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_genotype_view.html'>all_genotype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_knockout_cache.html'>all_knockout_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>257</td> <td class='comment detail'>A record in this table represents a Deltagen or Lexicon knockout.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_label.html'>all_label</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>1,491,917</td> <td class='comment detail'>A record in this table represents an Allele Label (current symbol, current name, synonym). This table is a cache table of all "labels" for a given Allele...representing the different ways in which a user may search for a particular Allele. This table is loaded via the alllabelload product.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_summary_view.html'>all_summary_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_summarybymarker_view.html'>all_summarybymarker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/all_summarybyreference_view.html'>all_summarybyreference_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_variant.html'>all_variant</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>8,868</td> <td class='comment detail'>A record in this table represents a variant for an allele. An allele can have multiple variants. Each variant will eventually have two records in this table -- one for reported data and the other for curated data.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/all_variant_sequence.html'>all_variant_sequence</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>11,082</td> <td class='comment detail'>A record in this table represents a sequence associated with a variant.n have multiple variants. Since each variant will have two records in ALL_Variant_Variant (one a source record, the other a curated record), there will be sequence records associated with both types of variant records.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_acc_view.html'>bib_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_all_view.html'>bib_all_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>22</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_associateddata_view.html'>bib_associateddata_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_books.html'>bib_books</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>319</td> <td class='comment detail'>A record in this table represents the Book attributes of a BIB_Refs record. This table is only populated if BIB_Refs.refType = BOOK.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_citation_cache.html'>bib_citation_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>332,736</td> <td class='comment detail'>A record in this table represents a unique Reference. This table is a cache table of all References in MGI. This table is loaded via the mgicacheload product. See mgicacheload/bibcitation.csh.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_goxref_view.html'>bib_goxref_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_notes.html'>bib_notes</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>25,897</td> <td class='comment detail'>A record in this table represents a Reference note.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_refs.html'>bib_refs</a></td> <td class='detail' align='right'>35</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>332,736</td> <td class='comment detail'>A record in this table represents a journal article, book or personal communication.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_status_view.html'>bib_status_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_summary_view.html'>bib_summary_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>30</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/bib_view.html'>bib_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>24</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_workflow_data.html'>bib_workflow_data</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>0</td> <td class='comment detail'>A record in this table represents Reference information needed by the Triage Workflow process</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_workflow_relevance.html'>bib_workflow_relevance</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>0</td> <td class='comment detail'>A record in this table represents the Relevance of a Reference by User over time</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_workflow_status.html'>bib_workflow_status</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>0</td> <td class='comment detail'>A record in this table represents the Group/Status of a Reference by User over time</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/bib_workflow_tag.html'>bib_workflow_tag</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>0</td> <td class='comment detail'>A record in this table represents a distinct Tag associated with a Reference</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/crs_cross.html'>crs_cross</a></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>19</td> <td class='detail' align='right'>4,491</td> <td class='comment detail'>Controlled vocabulary table for all Mapping Cross descriptions. See MLD_Matrix, CRS_Matrix.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/crs_matrix.html'>crs_matrix</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>28,009</td> <td class='comment detail'>Defines a row in a Matrix of a Mapping Panel Cross.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/crs_progeny.html'>crs_progeny</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>3,610</td> <td class='comment detail'>Defines Progeny for Mapping Panel Cross. See CRS_Matrix, CRS_References, CRS_Typings.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/crs_references.html'>crs_references</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>7,596</td> <td class='comment detail'>Defines References used in Mapping Panel Cross. See CRS_Matrix, CRS_Progeny, CRS_Typings.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/crs_typings.html'>crs_typings</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>63,596</td> <td class='comment detail'>Defines haplotype typings for Mapping Panel Cross. See CRS_Matrix, CRS_Progeny, CRS_References.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/dag_closure.html'>dag_closure</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>1,850,004</td> <td class='comment detail'>A record in this table represents an ancestor/descendent pair within a DAG. It caches data for performance reasons. Two common queries of a DAG are: 1. retrieve all the descendents of a node 2. retrieve all the ancestors of a node This table provides a mechanism for performing such queries within one SQL statement.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/dag_dag.html'>dag_dag</a></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>45</td> <td class='comment detail'>A record in this table represents a specific DAG.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/dag_edge.html'>dag_edge</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>219,186</td> <td class='comment detail'>A record in this table represents an edge of a DAG, the relationship between 2 nodes.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/dag_label.html'>dag_label</a></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>24</td> <td class='comment detail'>A record in this table represents a "label" for a Node or an Edge. A "label" is an attribute of the Note or Edge which may be specific to a given DAG. A "label" is not necessarily something which is printed.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/dag_node.html'>dag_node</a></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>140,300</td> <td class='comment detail'>A record in this table represents a specific Node within a DAG. The _Object_key/DAG_DAG._MGIType_key combination identifies the specific Node object. In the case of a GO DAG, this is a specific Vocabulary Term. The DAG_DAG._MGIType_key identifies the type of object (a Vocabulary Term) and the _Object_key identifies the object itself.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/dag_node_view.html'>dag_node_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/go_tracking.html'>go_tracking</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>109,235</td> <td class='comment detail'>A record in this table represents the GO Tracking history for a specific Gene (_Marker_key).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_allelegenotype.html'>gxd_allelegenotype</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>160,123</td> <td class='comment detail'>A record in this table represents the association between an Allele, a Genotype and a Marker. This is a cache table which is derived from GXD_AllelePair.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_allelepair.html'>gxd_allelepair</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>124,668</td> <td class='comment detail'>Defines Allele Pair for Genotype object. Each pair specifies two alleles, both of which must be associated with the same marker. Allele Pairs may be homozygous, heterzygous or hemizygous. For hemizygous Allele Pairs, Allele 2 is null. See GXD_Genotype.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_allelepair_view.html'>gxd_allelepair_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>20</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_antibody.html'>gxd_antibody</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>17,250</td> <td class='comment detail'>Defines an accessionable Antibody object. An antibody is a protein produced by cells of the immune system that binds to an antigen.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibody_acc_view.html'>gxd_antibody_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibody_view.html'>gxd_antibody_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>22</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_antibodyalias.html'>gxd_antibodyalias</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>1,010</td> <td class='comment detail'>Antibody synonyms. See GXD_Antibody.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibodyalias_view.html'>gxd_antibodyalias_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibodyaliasref_view.html'>gxd_antibodyaliasref_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibodyantigen_view.html'>gxd_antibodyantigen_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>25</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_antibodymarker.html'>gxd_antibodymarker</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>17,769</td> <td class='comment detail'>Defines relationship between Antibodies and Markers. Antibodies can recognize the product of one or more markers. See GXD_Antibody.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibodymarker_view.html'>gxd_antibodymarker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_antibodyprep.html'>gxd_antibodyprep</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>30,227</td> <td class='comment detail'>Defines the Antibody preparation for an expression assay. The Antibody preparation specifies the antibody and detection system used. The detection is a combination of a Secondary Antibody and a labelling material. See GXD_Assay, GXD_Antibody, GXD_Secondary, GXD_Label.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antibodyprep_view.html'>gxd_antibodyprep_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_antigen.html'>gxd_antigen</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>12,141</td> <td class='comment detail'>Defines an accessionable Antigen object. An antigen is a protein or fragment of a protein derived from a specific source.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antigen_acc_view.html'>gxd_antigen_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antigen_summary_view.html'>gxd_antigen_summary_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_antigen_view.html'>gxd_antigen_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>23</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_assay.html'>gxd_assay</a></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>132,158</td> <td class='comment detail'>A record in this table represents the high level definition of a Gene Expression experiment; the type of Assay, the Reference, the Marker of interest, the Probe used to detect the Marker or Reporter Gene, the Antibody used to detect the Marker or Reporter Gene, the Reporter Gene, and the Image Pane. A Reporter Gene is a benign gene which is knocked-in to report the expression of the mouse gene. It is only applicable when Assay Type is "In situ reporter (knock in)", "In situ reporter (transgenic)" and "Recombinase reporter". These three assay types may use a nucleotide probe (has a Probe Prep), an antibody (has an Antibody Prep) or direct detection (has neither a Probe Prep nor an Antibody prep). Not all records in this table are in the GXD_Expression table. Assay Type "In situ reporter (transgenic)" assays are excluded because they do not examine the expression of endogenous genes. Assay Type "Recombinase reporter" assays are excluded because they do not examine gene expression. See GXD_Specimen, GXD_GelLane.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_assay_acc_view.html'>gxd_assay_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_assay_allele_view.html'>gxd_assay_allele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_assay_dltemplate_view.html'>gxd_assay_dltemplate_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_assay_view.html'>gxd_assay_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>26</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_assaynote.html'>gxd_assaynote</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>47,241</td> <td class='comment detail'>Assay Notes. An Assay may have 0 more notes.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_assaytype.html'>gxd_assaytype</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>10</td> <td class='comment detail'>Controlled vocabulary table for all Assay types. Includes Not Applicable (-2) and Not Specified (-1). See GXD_Assay.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_expression.html'>gxd_expression</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>22</td> <td class='detail' align='right'>2,000,464</td> <td class='comment detail'>A cache table of redundant Assay results whose purpose is to make the most common kinds of queries more efficient. Primarily used by the Web interface. Loaded by a stored procedure which is executed from the GXD_Assay insert/update triggers. See GXD_Assay.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_gelband.html'>gxd_gelband</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>388,257</td> <td class='comment detail'>Defines a Gel Band for a given Gel Lane and Gel Row. A band is assigned a strength. See GXD_GelLane, GXD_GelRow.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_gelband_view.html'>gxd_gelband_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_gellane.html'>gxd_gellane</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>352,140</td> <td class='comment detail'>Defines a Gel Lane. A Gel Assay is represented as a 2-D matrix with some number of columns (GXD_GelLane) and some number of rows (GXD_GelRow, GXD_GelBand). Lanes have sequence numbers for ordering and labels to describe lane content. The information associated with a Gel Lane corresponds to the way the gel was prepared in the lab. Source material is derived from one or more tissues in an animal. Tissues are described through reference to the anatomical dictionary. Animals are described via their genotype, age and sex. Minimal information is recorded for control lanes. See GXD_Assay, GXD_Genotype, GXD_GelLaneStructure, GXD_GelRNAType.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_gellane_view.html'>gxd_gellane_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>20</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_gellanestructure.html'>gxd_gellanestructure</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>317,514</td> <td class='comment detail'>Defines a relationship between a Gel Lane and an Anatomical Structure. A Gel Lane can correspond to one or more Anatomical Structures. See GXD_GelLane, VOC_Term_EMAPA.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_gellanestructure_view.html'>gxd_gellanestructure_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_gelrow.html'>gxd_gelrow</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>55,572</td> <td class='comment detail'>Defines a Gel Row. A Gel Row corresponds to a particular size of band (GXD_GelBand) and includes attributes for size, units and optional notes. Band sizes are automatically sorted in decreasing order via the Editorial Interface. See GXD_GelLane, GXD_GelBand.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_gelrow_view.html'>gxd_gelrow_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_genotype.html'>gxd_genotype</a></td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>96,729</td> <td class='comment detail'>Defines Genotype of animal used for Gel Lane or Specimen using Strain information. See GXD_GelLane, GXD_Specimen, GXD_AllelePair.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_genotype_acc_view.html'>gxd_genotype_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_genotype_dataset_view.html'>gxd_genotype_dataset_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_genotype_summary_view.html'>gxd_genotype_summary_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>18</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_genotype_view.html'>gxd_genotype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_genotypeannotheader_view.html'>gxd_genotypeannotheader_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htexperiment.html'>gxd_htexperiment</a></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>21</td> <td class='detail' align='right'>52,673</td> <td class='comment detail'>A record in this table represents one high-througput expression experiment. There can be zero or more samples per experiment (GXD_HTSample) and zero or more experiment variables (GXD_ExperimentVariable). Many other experiment attributes are stored as properties (MGI_Property), as notes (MGI_Note), and as accession IDs (ACC_Accession).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htexperimentvariable.html'>gxd_htexperimentvariable</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>55,103</td> <td class='comment detail'>A record in this table represents one curator-identified experiment variable for an experiment. Each experiment (GXD_HTExperiment) can have zero or more expression variables associated with it.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htrawsample.html'>gxd_htrawsample</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>1,829,483</td> <td class='comment detail'>A record in this table represents one high-througput expression raw sample. There can be zero or more raw samples per experiment (GXD_HTExperiment) Many other raw experiment attributes are stored as key:value pairs (MGI_KeyValue)</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htsample.html'>gxd_htsample</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>143,635</td> <td class='comment detail'>A record in this table represents one curated sample for a high-throughput expression experiment (GXD_HTExperiment). Each sample can have accession IDs (ACC_Accession), associated organisms (GXD_HTSampleOrganism), notes (MGI_Note), properties (MGI_Property), and a genotype (GXD_Genotype).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htsample_rnaseq.html'>gxd_htsample_rnaseq</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>110,642,286</td> <td class='comment detail'>A record in this table represents an experiment/sample/gene combination</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htsample_rnaseqcombined.html'>gxd_htsample_rnaseqcombined</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>36,724,708</td> <td class='comment detail'>A record in this table represents a gene/RNASeqSet combination</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htsample_rnaseqset.html'>gxd_htsample_rnaseqset</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>706</td> <td class='comment detail'>A record in this table represents a distinct experiment/age/organism/sex/emapa/stage/genotype/note set/cluster as generated from GXD_HTSample via rnaseqload</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htsample_rnaseqset_cache.html'>gxd_htsample_rnaseqset_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>36,724,708</td> <td class='comment detail'>A join table to provide easy access to RNASeqSet and RNASeqSet_Combined data</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_htsample_rnaseqsetmember.html'>gxd_htsample_rnaseqsetmember</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>2,127</td> <td class='comment detail'>A record in this table represents a GXD_HTSample member of the GXD_HTSample_RNASeqSet</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_index.html'>gxd_index</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>269,745</td> <td class='comment detail'>A record in this table represents a GXD "index" relationship between a Reference and a Marker. Precusor to fully coding a GXD paper. All records in the GXD Index may or may not be entered into the GXD Assay table. See GXD_Index_Stages.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_index_stages.html'>gxd_index_stages</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>615,810</td> <td class='comment detail'>A record in this table represents the Assays and Stages present in a given Index (Reference/Marker pair). See GXD_Index.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_index_summaryby_view.html'>gxd_index_summaryby_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_index_view.html'>gxd_index_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_insituresult.html'>gxd_insituresult</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>1,565,117</td> <td class='comment detail'>Defines an In Situ Specimen Result. For each Specimen defined, one or more results can be recorded. Each result contains the anatomical structure(s), signal strength, pattern of expression within the structure(s) and optional notes. One or more Image Panes may also be associated with a result. See GXD_Specimen, GXD_InSituResultImage, GXD_ISResultStructure.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_insituresult_view.html'>gxd_insituresult_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_insituresultimage.html'>gxd_insituresultimage</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>1,470,460</td> <td class='comment detail'>Defines relationship between an In Situ Result and an Image Pane. One In Situ Result can have one or more Image Panes associated with it. See GXD_InSituResult, GXD_ImagePane.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_isresultcelltype.html'>gxd_isresultcelltype</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>14,081</td> <td class='comment detail'>Defines relationship between an In Situ Result and a Cell Type. One In Situ Result can have one or more Cell Types associated with it. See GXD_InSituResult</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_isresultcelltype_view.html'>gxd_isresultcelltype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_isresultimage_view.html'>gxd_isresultimage_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>19</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_isresultstructure.html'>gxd_isresultstructure</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>1,682,870</td> <td class='comment detail'>Defines relationship between an In Situ Result and an Anatomical Structure. One In Situ Result can have one or more Anatomical Structures associated with it. See GXD_InSituResult, VOC_Term_EMAPA.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_isresultstructure_view.html'>gxd_isresultstructure_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_probeprep.html'>gxd_probeprep</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>95,542</td> <td class='comment detail'>Defines the Probe preparation for an expression assay. The Probe preparation specifies the probe used, final type (DNA, RNA) and the label used to visualize the probe. See GXD_Assay, PRB_Probe, GXD_ProbeSense, GXD_Label, GXD_LabelCoverage, GXD_Visualization.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_probeprep_view.html'>gxd_probeprep_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_specimen.html'>gxd_specimen</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>526,764</td> <td class='comment detail'>Defines an In Situ Assay Specimen. A Specimen is described in terms of its genotype, sex, age and the methods used to prepare the sample. If multiple animals within one reference have identical genotypes and preparation procedures, then they can be collectively represented by a single Specimen object. See GXD_Assay, GXD_EmbeddingMethod, GXD_FixationMethod, GXD_Genotype.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/gxd_specimen_view.html'>gxd_specimen_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>20</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/gxd_theilerstage.html'>gxd_theilerstage</a></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>28</td> <td class='comment detail'>Defines the Theiler Stages, one for each developmental stage defined in the Theiler system. Each stage has a "stage" attribute, which is an integer from 1 to 28, an approximate mapping to DPC values, and a short description of the main anatomical developments for the stage. See VOC_Term_EMAPA.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/img_image.html'>img_image</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>342,097</td> <td class='comment detail'>A record in this table represents a full size or thumbnail Image. If the X dimension (width) and Y dimension (height) are non-null, then an Image file is associated with the Image (via the PIX accession ID).</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_image_acc_view.html'>img_image_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_image_summary2_view.html'>img_image_summary2_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_image_summarybyreference_view.html'>img_image_summarybyreference_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>19</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_image_view.html'>img_image_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>22</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/img_imagepane.html'>img_imagepane</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>584,966</td> <td class='comment detail'>A record in this table represents an Image Pane. An Image hast at least one Image Pane.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/img_imagepane_assoc.html'>img_imagepane_assoc</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>22,395</td> <td class='comment detail'>A record in this table represents an association between an Image Pane and an MGI Object (allele, genotype). At most one association for a given MGI object can be primary.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_imagepane_assoc_view.html'>img_imagepane_assoc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_imagepaneallele_view.html'>img_imagepaneallele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_imagepanegenotype_view.html'>img_imagepanegenotype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/img_imagepanegxd_view.html'>img_imagepanegxd_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/map_coord_collection.html'>map_coord_collection</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>13</td> <td class='comment detail'>A record in this table represents one Coordinate Map Collection; an ordered set of Coordinate Maps. A Coordinate Map Colllection can contain Coordinate Maps of different Map Types.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/map_coord_feature.html'>map_coord_feature</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>2,240,086</td> <td class='comment detail'>A record in this table represents a feature on a coordinate map (MAP_Coordinate).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/map_coordinate.html'>map_coordinate</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>259</td> <td class='comment detail'>A record in this table represents one Coordinate Map; a set of Coordinate Map Features of the specified Units for the specified Object. The Object can be an MGI object (Chromosome or Sequence), or a non-MGI object (in which case the _Object_key and _MGIType_key are null). A Coordinate Map can belong to at most one Collection.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/map_gm_coord_feature_view.html'>map_gm_coord_feature_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_dbinfo.html'>mgi_dbinfo</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>1</td> <td class='comment detail'>This table has one and only one record which contains information about the database such as the public version name, the product name, the last time the database was dumped.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_keyvalue.html'>mgi_keyvalue</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>28,913,433</td> <td class='comment detail'>A record in this table represents ordered key-value pairs (strings), associated with an object of a specific MGI Type.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_note.html'>mgi_note</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>3,005,544</td> <td class='comment detail'>A record in this table represents a Note of a specific type (_NoteType_key) for a specific object (_Object_key) of a specific object type (_Object_key) with a specific privacy setting.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_allele_view.html'>mgi_note_allele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_allelevariant_view.html'>mgi_note_allelevariant_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_derivation_view.html'>mgi_note_derivation_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_genotype_view.html'>mgi_note_genotype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_image_view.html'>mgi_note_image_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_marker_view.html'>mgi_note_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_probe_view.html'>mgi_note_probe_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_strain_view.html'>mgi_note_strain_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_note_vocevidence_view.html'>mgi_note_vocevidence_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_notetype.html'>mgi_notetype</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>45</td> <td class='comment detail'>A record in this table represents a Note Type.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_notetype_strain_view.html'>mgi_notetype_strain_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_organism.html'>mgi_organism</a></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>110</td> <td class='comment detail'>A record in this table represents an Organism.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_organism_allele_view.html'>mgi_organism_allele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_organism_antigen_view.html'>mgi_organism_antigen_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_organism_marker_view.html'>mgi_organism_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_organism_mgitype.html'>mgi_organism_mgitype</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>238</td> <td class='comment detail'>A record in this table represents the relationship between an Organism and a MGI Type; what Organisms are valid for a given MGI Type. An Organism can be associated with one or more MGI Types. This enables us to generate a list of Organisms by MGI Type. Examples are Orthology, Molecular Segment , GXD Antigen, GXD Antibody, Sequence, Marker.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_organism_mgitype_view.html'>mgi_organism_mgitype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_organism_probe_view.html'>mgi_organism_probe_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_property.html'>mgi_property</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>277,300</td> <td class='comment detail'>A record in this table represents ordered properties, or name-value pairs, of a specific Property Type, for any object defined in ACC_MGIType</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_propertytype.html'>mgi_propertytype</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>1</td> <td class='comment detail'>A record in this table represents a Property Type from a specific VOcabulary for a specific Object Type</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_refassoctype.html'>mgi_refassoctype</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>25</td> <td class='comment detail'>A record in this table represents a Reference Association Type (e.g. General, Original).</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_reference_allele_view.html'>mgi_reference_allele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>19</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_reference_allelevariant_view.html'>mgi_reference_allelevariant_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_reference_antibody_view.html'>mgi_reference_antibody_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_reference_assoc.html'>mgi_reference_assoc</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>7,199,111</td> <td class='comment detail'>A record in this table repesents an association between a Reference of a specific type (_RefAssocType_key, e.g. Original) and a specific database object (_Object_key, e.g. Sequence A12345 ) of a specific object type (_MGIType_key, e.g., Sequence, Marker/Sequence Association).</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_reference_marker_view.html'>mgi_reference_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>20</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_reference_strain_view.html'>mgi_reference_strain_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>19</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_relationship.html'>mgi_relationship</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>4,798,810</td> <td class='comment detail'>A record in this table represents a relationship, of a particular category, between any two objects with an MGI Type. For example a relationship between two Markers or a relationship between an Allele and a Marker. See MGI_Relationship_Category</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_relationship_category.html'>mgi_relationship_category</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>12</td> <td class='comment detail'>A record in this table defines a category (type) of relationship between two objects, allowing us to encapsulate data that is standard across all relationships of this type. See MGI_Relationship</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_relationship_fear_view.html'>mgi_relationship_fear_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>27</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_relationship_markerqtlcandidate_view.html'>mgi_relationship_markerqtlcandidate_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_relationship_markerqtlinteraction_view.html'>mgi_relationship_markerqtlinteraction_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_relationship_markertss_view.html'>mgi_relationship_markertss_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>23</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_relationship_property.html'>mgi_relationship_property</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>27,146,046</td> <td class='comment detail'>A record in this table represents ordered properties, or name-value pairs, for a relationship See MGI_Relationship</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_set.html'>mgi_set</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>16</td> <td class='comment detail'>A record in this table represents a Set.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_setmember.html'>mgi_setmember</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>1,667</td> <td class='comment detail'>A record in this table represents the ordered member of a specific Set.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_setmember_emapa.html'>mgi_setmember_emapa</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>0</td> <td class='comment detail'>A record in this table represents the EMAPA info of a specific Set Member.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_synonym.html'>mgi_synonym</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>914,922</td> <td class='comment detail'>A record in this table repesents a Synonym of a specific type (_SynonymType_key, e.g. Exact) and a specific database object (_Object_key, e.g. Marker Kit ) of a specific object type (_MGIType_key, e.g., Marker). The Synonym may also have a Reference associated with it.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_synonym_allele_view.html'>mgi_synonym_allele_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_synonym_musmarker_view.html'>mgi_synonym_musmarker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>18</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_synonym_strain_view.html'>mgi_synonym_strain_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_synonymtype.html'>mgi_synonymtype</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>27</td> <td class='comment detail'>A record in this table represents a Synonym Type (e.g. Exact) for a specific Object Type. The Object may be of a specific Organism (for example, Marker, Mouse).</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_synonymtype_strain_view.html'>mgi_synonymtype_strain_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_translation.html'>mgi_translation</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>4,486</td> <td class='comment detail'>A record in this table represents the Translation between a "bad name" and the corresponding MGI object (the "good name") of a specific Translation Type.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_translationtype.html'>mgi_translationtype</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>18</td> <td class='comment detail'>A record in this table represents a Translation Type.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mgi_user.html'>mgi_user</a></td> <td class='detail' align='right'>198</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>314</td> <td class='comment detail'>A record in this table represents a valid MGI user login.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mgi_user_active_view.html'>mgi_user_active_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_assay_types.html'>mld_assay_types</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>79</td> <td class='comment detail'>Controlled vocabulary table for all Mapping Assays. Includes a blank (-1) Assay, which is used like a "Not Specified" vocabulary record. See MLD_Expt_Marker.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_concordance.html'>mld_concordance</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>11,827</td> <td class='comment detail'>Defines Concordance values for Hybrid Experiment. The Concordance table contains results for either Markers or Chromosomes. Concordance values are stored as integers which represent the number of Hybrid cells recording the presence/absence of a particular Marker/Chromosome in the Concordance table vs. the presence/absence of the Marker being tested for linkage: -/- (neither present), -/+ (linkage Marker present), +/- (Marker/Chromosome present), +/+ (both present). Detail of MLD_Hybrid.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_contig.html'>mld_contig</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>2,054</td> <td class='comment detail'>Defines CONTIG Experiment for MIT Physical Mapping data. Each Contig has a name and an indication (minLink) of the minimum number of common hits required to assemble YACs into the Contig. For the MIT data, the value in this field is either 1 or 2. Each Contig is labelled with the minimum and maximum cM position of markers within the Contig. When printing the Contigs for a chromosome, the Contigs should be ordered by the mincm field. The Contig tables are loaded via a load script and there is no Editorial Interface for modifying this data. See MLD_ContigProbe, MLD_Hit, PRB_Probe.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_contigprobe.html'>mld_contigprobe</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>14,342</td> <td class='comment detail'>Defines the STS order within a Contig. A Contig can have one or more Probes/STS's associated with it. Detail of MLD_Contig, PRB_Probe.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_expt_marker.html'>mld_expt_marker</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>759,397</td> <td class='comment detail'>Defines relationship between an Experiment and a Marker reported for that Experiment. An Experiment may have one or more Markers associated with it. See MLD_Expts.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mld_expt_marker_view.html'>mld_expt_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>22</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_expt_notes.html'>mld_expt_notes</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>15,178</td> <td class='comment detail'>Mapping experiment notes.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mld_expt_view.html'>mld_expt_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_expts.html'>mld_expts</a></td> <td class='detail' align='right'>18</td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>24,051</td> <td class='comment detail'>Defines a Mapping Experiment for a specific Reference. A Reference may have one or more Experiments associated with it. Each Experiment within a specific Reference is assigned an Experiment Type and and Experiment Tag value (CROSS-1). The currently supported Experiment Types are: CONTIG, CROSS, FISH, HYBRID, IN SITU, MAP, RI, TEXT.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_fish.html'>mld_fish</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>1,429</td> <td class='comment detail'>Defines FISH (Fluorescence In Situ Hybridization) Experiment. FISH Experiments use fluorescein tags to detect the hybridization of probes with metaphase chromosomes. This suggests the chromosome and band assignment of the marker to which the probe hybrdizes. Master of MLD_FISH_Region.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_fish_region.html'>mld_fish_region</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>77</td> <td class='comment detail'>Defines number of single and double signal hits by chromosomal region for a specific FISH Experiment. Detail of MLD_FISH.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_hit.html'>mld_hit</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>50,872</td> <td class='comment detail'>Defines hits between Probes and Targets for MIT Physical Mapping data. Each Probe and each Target is a Molecular Segment in PRB_Probe. Each hit is associated with an Experiment. In the case of MIT data, each _Probe_key points to an STS, and each _Target_key points to a YAC. Detail of MLD_Expts, PRB_Probe.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_hybrid.html'>mld_hybrid</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>651</td> <td class='comment detail'>Defines HYBRID Experiment; stores the band assignment determined by the experiment. Master for MLD_Concordance.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_insitu.html'>mld_insitu</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>449</td> <td class='comment detail'>Defines IN SITU Experiment. In Situ Experiments use a DNA or RNA probe to detect the presence of the complementary DNA sequence in cloned bacterial or cultured eukaryotic cells. This suggests the chromosome and band assignment of the marker to which the probe hybridizes. Master of MLD_ISRegion.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_isregion.html'>mld_isregion</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>2,523</td> <td class='comment detail'>Defines number of grain counts by chromosomal region for a specific In Situ Experiment. Detail of MLD_InSitu.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_matrix.html'>mld_matrix</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>6,925</td> <td class='comment detail'>Defines CROSS Experiment. Cross Experiments may use a well-defined Cross or a one-time only mating of two strains. The Editorial Interface constructs the female and male genotypes based on the number of Markers used in the Experiment and the allele abbreviations designated for the Cross. See MLD_MC2point, MLC_MCDataList, CRS_Cross.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_mc2point.html'>mld_mc2point</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>10,047</td> <td class='comment detail'>Defines 2 Point data for Cross Experiments. 2 Point data records typing of animals for specified pairs of Markers. Detail of MLD_Matrix.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_mcdatalist.html'>mld_mcdatalist</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>30,247</td> <td class='comment detail'>Defines Haplotype data for Cross Experiments. Haplotype data records haplotypes and number of offspring for Experimental Markers designated as having Haplotype data (MLD_Expt_Marker.matrixData = 1). Detail of MLD_Matrix.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_notes.html'>mld_notes</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>1,664</td> <td class='comment detail'>Mapping Notes for a specific Reference.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_ri.html'>mld_ri</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>3,501</td> <td class='comment detail'>Defines RI (Recombinant Inbred and Recombinant Congenic) Experiment. RI Experiments use well-defined recombinant inbred and recombinant congenic strains to provide linkage mapping information. See MLD_RI2Point, MLD_RIData, RI_RISet.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_ri2point.html'>mld_ri2point</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>524</td> <td class='comment detail'>Defines 2 Point data for RI Experiments. 2 Point data records typing of animals for specified pairs of Markers and specified RI Sets. Detail of MLD_RI.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_ridata.html'>mld_ridata</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>12,779</td> <td class='comment detail'>Defines Haplotype data for RI Experiments. Haplotype data records strain distribution pattern for Experimental Markers for each animal in the RI set. Detail of MLD_RI.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mld_statistics.html'>mld_statistics</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>27,147</td> <td class='comment detail'>Defines Statistics generated from Haplotype and 2 Point data. Generated automatically based on Experiment Type (CROSS or RI) and Cross Type (if Experiment is a CROSS). See MLD_Expts.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_acc_view.html'>mrk_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_accnoref_view.html'>mrk_accnoref_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_accref1_view.html'>mrk_accref1_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>21</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_accref2_view.html'>mrk_accref2_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>21</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_biotypemapping.html'>mrk_biotypemapping</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>191</td> <td class='comment detail'>Translations : raw biotype->feature type/MCV, raw biotype->marker type</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_chromosome.html'>mrk_chromosome</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>364</td> <td class='comment detail'>A record in this table represents an ordered Chromosome for the specified Organism (Species). See MRK_Marker.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_cluster.html'>mrk_cluster</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>62,796</td> <td class='comment detail'>A record in this table defines a relationship between a set of markers. This table was designed to represent Homology clusters to allow multiple markers per organism to be in a cluster and has been generalized by including a cluster type, a source and an accession ID See MRK_Marker</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_clustermember.html'>mrk_clustermember</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>185,964</td> <td class='comment detail'>A record in this table defines an ordered set of members of a marker cluster. See MRK_Cluster</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_current.html'>mrk_current</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>747,982</td> <td class='comment detail'>Defines relationship between a Marker and its Current Symbol(s). A Marker may have one or more current symbols associated with it. Usually there is only one current symbol for a marker. But, if a marker is split, then each of the new symbols will be assigned as a current symbol of the split symbol. See MRK_Marker.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_current_view.html'>mrk_current_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_do_cache.html'>mrk_do_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>12,521</td> <td class='comment detail'>A record in this table represents the cached value of a mouse genotype/DO annotation or a human marker/DO annotation. See mrkcacheload/mrkdo.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_history.html'>mrk_history</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>817,702</td> <td class='comment detail'>A record in this table represents a nomenclature event in the life of a Marker. A nomenclature event is defined by the event itself (rename, merge, split, etc.), the reason for the event, date of the event, reference (J:).</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_history_view.html'>mrk_history_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>24</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_label.html'>mrk_label</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>3,881,155</td> <td class='comment detail'>A record in this table represents the cached value of a label (name, synonym, symbol) for a Marker. Examples: [priority = 1, label type = "MS", label name = "current symbol"], [priority = 2, label = "MN", label name = "current name"]. See mrkcacheload/mrklabel.csh for complete list.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_location_cache.html'>mrk_location_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>18</td> <td class='detail' align='right'>939,133</td> <td class='comment detail'>A record in this table represents the cached value of a Marker and its genetic and physical location. See mrkcacheload/mrklocation.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_marker.html'>mrk_marker</a></td> <td class='detail' align='right'>41</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>1,326,818</td> <td class='comment detail'>A record in this table represents a Marker (gene, dna segment, complex/cluster). Mouse Markers have MGI Accession IDs. Non-mouse Markers (human, rat, etc.) are also stored in this table.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_marker_view.html'>mrk_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>20</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_mcv_cache.html'>mrk_mcv_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>2,639,910</td> <td class='comment detail'>A record in this table represents the cached value of a Marker and its Feature Types. See MRK_Marker. See mrkcacheload/mrkmcv.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_mcv_count_cache.html'>mrk_mcv_count_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>65</td> <td class='comment detail'>A cache of the current number of markers annotated to a given Feature Type Vocab Term (formerly known as Marker Category Vocabulary)</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_mouse_view.html'>mrk_mouse_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>22</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_notes.html'>mrk_notes</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>13,682</td> <td class='comment detail'>A record in this table represents a note for a Marker.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_reference.html'>mrk_reference</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>2,317,020</td> <td class='comment detail'>A record in this table represents a unique association between a Marker and a Reference. This is a cache table that is rebuilt nightly by the mrkcacheload product. It represents a union of unique Marker/Reference associations from all data sets in MGI (Expression, Mapping, Alleles, GO Annotations, etc.).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_status.html'>mrk_status</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>3</td> <td class='comment detail'>Controlled vocabulary table for all Marker Statuses (approved, withdrawn). See MRK_Marker.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_strainmarker.html'>mrk_strainmarker</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>745,689</td> <td class='comment detail'>A record in this table represents a Strain/Marker relationship</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_summary_view.html'>mrk_summary_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/mrk_summarybyreference_view.html'>mrk_summarybyreference_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/mrk_types.html'>mrk_types</a></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='comment detail'>Controlled vocabulary table for all Marker Types. See MRK_Marker.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_acc_view.html'>prb_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_accref_view.html'>prb_accref_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_alias.html'>prb_alias</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>99,922</td> <td class='comment detail'>Defines synonyms for Probe names referred to in a specific Reference. See PRB_Reference, PRB_Probe.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_allele.html'>prb_allele</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>64,247</td> <td class='comment detail'>Defines relationship between an RFLV (marker/endonuclease pair), an allele "symbol", and a fragment size. See PRB_RFLV, PRB_Allele_Strain, PRB_Reference.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_allele_strain.html'>prb_allele_strain</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>138,903</td> <td class='comment detail'>Defines relationship between a defined RFLV Allele (PRB_Allele) and a Strain. An RFLV Allele may have one or more Strains associated with it. See PRB_Allele, PRB_RFLV, PRB_Strain.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_marker.html'>prb_marker</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>1,117,827</td> <td class='comment detail'>Defines relationship between a Probe and a Marker. Relationship values: H = hybridizes to, E = encodes, A = amplifies, M = MIT Physical Mapping data, P = putative (ESTs). A Probe can have one or more Markers associated with it. See PRB_Probe, MRK_Marker.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_marker_view.html'>prb_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_notes.html'>prb_notes</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>76,339</td> <td class='comment detail'>A record in this table represents a note for a Molecular Segment.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_probe.html'>prb_probe</a></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>2,207,657</td> <td class='comment detail'>Defines an accessionable Molecular Segment object. Master table for all Molecular Segments: Single-stranded DNA or RNA molecules of specific base sequence, labeled either radioactively or immunologically, that are used to detect the complementary base sequence by hybridization. Master for PRB_Marker, PRB_Reference.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_probe_view.html'>prb_probe_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>25</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_ref_notes.html'>prb_ref_notes</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>1,957</td> <td class='comment detail'>A record in this table represents a note for a Molecular Segment Reference.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_reference.html'>prb_reference</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>2,911,099</td> <td class='comment detail'>Defines relationship between a Probe and a Reference. A Probe may have one or more References associated with it. Accession numbers can be associated with Probes using the Reference object in conjunction with the ACC_AccessionReference table. See PRB_Probe.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_rflv.html'>prb_rflv</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>22,683</td> <td class='comment detail'>Defines a relationship between a Marker and an Endonuclease for a specific Probe Reference. Variations exist between individuals in DNA fragment sizes cut by specific restriction enzymes; polymorphic sequences that result in RFLPs are used as markers on both physical maps and genetic linkage maps. RFLPs are usually caused by mutation at a cutting site. Detail of PRB_Reference.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_source.html'>prb_source</a></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>19</td> <td class='detail' align='right'>85,511</td> <td class='comment detail'>Defines the biological context from which a Probe is derived, e.g., species, strain, tissue, etc. Some sources are well-defined "libraries". Every Probe has one and only one Source. See PRB_Probe.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_source_acc_view.html'>prb_source_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_source_view.html'>prb_source_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>30</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_strain.html'>prb_strain</a></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>89,555</td> <td class='comment detail'>A record in this table represents a unique strain or genetic background. Accession IDs for Strains (MGI, JRS, EMMA, MMRC, etc.) are stored in the ACC_Accession table.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_strain_acc_view.html'>prb_strain_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_strain_attribute_view.html'>prb_strain_attribute_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_strain_genotype.html'>prb_strain_genotype</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>20,897</td> <td class='comment detail'>A record in this table represents a Strain/Genotype association. An association is qualified using the _Qualifier_key. A Strain can have 0 or more Genotypes associated with it.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_strain_genotype_view.html'>prb_strain_genotype_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_strain_marker.html'>prb_strain_marker</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>79,202</td> <td class='comment detail'>A record in this table represents a Strain/Marker/Allele association. An associations is qualified using the _Qualifier_key. A Strain can have 0 or more Marker/Allele pairs associated with it. A Strain may be created as the result of a mutation (transgenic allele), in which case the transgenic allele is associated with the newly bred Strain using this table. For example: MGI:4847055/Tg(Foxi2-EGFP)HX217Gsat, strain of origin: FVB/NTac. New Strain: MGI:5003868/STOCK Tg(Foxi2-EGFP)HX217Gsat/Mmucd associated with MGI:5003868/Tg(Foxi2-EGFP)HX217Gsat via PRB_Strain/PRB_Strain_Marker.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_strain_marker_view.html'>prb_strain_marker_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_strain_needsreview_view.html'>prb_strain_needsreview_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/prb_strain_view.html'>prb_strain_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/prb_tissue.html'>prb_tissue</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>590</td> <td class='comment detail'>Controlled vocabulary table for all Tissues. Includes Not Applicable (-2) and Not Specified (-1).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/ri_riset.html'>ri_riset</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>40</td> <td class='comment detail'>A record in this table represents the definition of a Recombinant Inbred Strain.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/ri_summary.html'>ri_summary</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>9,583</td> <td class='comment detail'>A record in this table represents the RI haplotypes for a given RI Set and a given Marker.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/ri_summary_expt_ref.html'>ri_summary_expt_ref</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>12,716</td> <td class='comment detail'>A record in this table defines the Experiment and Reference for an RI Summary record. There is one or more RI_Summary_Expt_Ref records per RI_Summary record.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_allele_assoc.html'>seq_allele_assoc</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>745,030</td> <td class='comment detail'>A record in this table represents the association between an Allele and a Sequence.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_coord_cache.html'>seq_coord_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>1,995,038</td> <td class='comment detail'>A record in this table represents the Sequence coordinate for an Assembly Sequence. See seqcacheload/seqcoord.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_genemodel.html'>seq_genemodel</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>1,219,596</td> <td class='comment detail'>A record in this table represents additional information about Gene Model Sequences.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_genetrap.html'>seq_genetrap</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>906,842</td> <td class='comment detail'>A row in this table represents additional information about Gene Trap sequences.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_marker_cache.html'>seq_marker_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>18</td> <td class='detail' align='right'>2,529,411</td> <td class='comment detail'>A record in this table represents the cached value of the annotation between a mouse Marker and a Sequence. See seqcacheload/seqmarker.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_probe_cache.html'>seq_probe_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>2,166,128</td> <td class='comment detail'>A record in this table represents the cached value of the annotation between a mouse Molecular Segment and a Sequence. See seqcacheload/seqprobe.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_sequence.html'>seq_sequence</a></td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>18</td> <td class='detail' align='right'>14,414,647</td> <td class='comment detail'>A record in this table represents a specific Sequence object.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/seq_sequence_acc_view.html'>seq_sequence_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_sequence_assoc.html'>seq_sequence_assoc</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>212,974</td> <td class='comment detail'>A record in this table represents the association between two Sequences objects. For example, a Gene Model Sequence can be associated with its protein or transcript sequence.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_sequence_raw.html'>seq_sequence_raw</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>14,414,647</td> <td class='comment detail'>A record in this table represents the raw attributes of a Sequence.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/seq_source_assoc.html'>seq_source_assoc</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>14,414,647</td> <td class='comment detail'>A record in this table represents the relationship between a Sequence and a Molecular Source (PRB_Source).</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/seq_summary_view.html'>seq_summary_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>17</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_allele_cache.html'>voc_allele_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>440,559</td> <td class='comment detail'>A record in this table represents the cached value of the association between an Allele and an Annotation Type. The Annotation Types are VOC_AnnotType: 1002:Mammalian Phentype/Genotype, 1020:DO/Genotype. The cache is loaded from mgicacheload/vocallele.csh which calls stored procedures in pgmgddbschema/procedure (VOC_Allele_Cache, VOC_GO_Cache, VOC_Marker_Cache).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_annot.html'>voc_annot</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>7</td> <td class='detail' align='right'>3,497,353</td> <td class='comment detail'>A record in this table represents the Annotation between a Vocabulary Term and an Object of type specified by the Annotation Type. There is one Annotation per Object/Term/Annotation Type/isNot. See VOC_AnnotType.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_annot_count_cache.html'>voc_annot_count_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>85,056</td> <td class='comment detail'>A record in this table represents a cached value of the number of objects (of a given type) with annotations (of a given type) to a given vocabulary term.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_annot_view.html'>voc_annot_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_annotheader.html'>voc_annotheader</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>217,832</td> <td class='comment detail'>A record in this table represents the unique use of a Header term for a specific annotated Object of a specific Annotation Type. A set of records grouped by Annot Type/Object represents the ordered list of Header terms for an annotated Object of a specific Annotation Type.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_annottype.html'>voc_annottype</a></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>21</td> <td class='comment detail'>A record in this table defines an Annotation Type. Each Annotation instance specifies its type (VOC_Annot). An Annotation Type specifies an Object type (_MGIType_key), the Vocabulary to which an Object of that type is being annotated (_Vocab_key), and the Evidence Vocabulary (_EvidenceVocab_key) used to annotate the Object of the specified type. An Object which is to be annotated (a Marker or a Genotype) is an accessionable object which requires an entry in ACC_MGIType.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_evidence.html'>voc_evidence</a></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>9</td> <td class='detail' align='right'>3,046,166</td> <td class='comment detail'>A record in this table represents one evidence statement which supports one Annotation. There can be one or more Evidence records per Annotation. Although the schema supports zero or more Evidence records per Annotation, editorially at least one Evidence record is required per Annotation.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_evidence_property.html'>voc_evidence_property</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>10</td> <td class='detail' align='right'>3,647,657</td> <td class='comment detail'>A record in this table represents the association between an Annotation Evidence record and a Property. This stores the contextual data of a particular Annotation row. Each stanza that occurs in a given Annotation experiment (row) is stored as separate contextual data within the Annotation experiment. Each individual stanza is treated as a distinct contextual set of data that is associated with the proper Annotation row.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_evidence_view.html'>voc_evidence_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>16</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_go_cache.html'>voc_go_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>47,614</td> <td class='comment detail'>A record in this table represents the cached value of the GO Terms, the GO DAG and GO accession ids. See mgicacheload/vocgo.csh.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_marker_cache.html'>voc_marker_cache</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>4,061,465</td> <td class='comment detail'>A record in this table represents a cached value of the association between a Marker, a Term and an Annotation Type. The Annotation Types are VOC_AnnotType: 1000:GO/Marker, 1003:InterPro/Marker, 1002:Mammalian Phenotype/Genotype, 1020:DO/Genotype, 1022:DO/Human Marker, 1007:PIRSF/Marker. The cache is loaded from mgicacheload/vocmarker.csh which refers to stored procedues in mgddbschema/procedure (VOC_Cache_Markers, VOC_Cache_Anatomy_Markers, VOC_Cache_MP_Markers, VOC_Cache_DO_Markers, VOC_Cache_Other_Markers).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_term.html'>voc_term</a></td> <td class='detail' align='right'>122</td> <td class='detail' align='right'>3</td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>258,245</td> <td class='comment detail'>A record in this table represents a Vocabulary Term for a specific Vocabulary. There is one big bucket of Terms for each Vocabulary. A Term can appear in 0 or more DAGS within the same Vocabulary. Remember that a Term is an accessionable object, so there is a corresponding entry for this table in ACC_MGIType.</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_term_acc_view.html'>voc_term_acc_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>14</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_term_emapa.html'>voc_term_emapa</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>7,982</td> <td class='comment detail'>A record in this table represents additional information about EMAPA (abstract mouse) structured vocabulary terms. Each term has a starting and ending Theiler stage and a default parent (or null if root term). See VOC_Term._Vocab_key = 90</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_term_emaps.html'>voc_term_emaps</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>35,964</td> <td class='comment detail'>A record in this table represents additional information about EMAPS (Theiler stage specific) structured vocabulary terms. Each term has a Theiler stage, an EMAPA term and a default parent (or null if root term). See VOC_Term._Vocab_key = 91</td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_term_repqualifier_view.html'>voc_term_repqualifier_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>12</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_term_view.html'>voc_term_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>15</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_termfamily_view.html'>voc_termfamily_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>13</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='view' valign='top'> <td class='detail'><a href='tables/voc_termfamilyedges_view.html'>voc_termfamilyedges_view</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'></td> <td class='detail' align='right'>5</td> <td class='detail' align='right'>view</td> <td class='comment detail'></td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_vocab.html'>voc_vocab</a></td> <td class='detail' align='right'>11</td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>8</td> <td class='detail' align='right'>168</td> <td class='comment detail'>A record in this table represents a Vocabulary. Different versions of the same Vocabulary are represented by records with different names (as in GO 1.0, GO 2.0, etc).</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/voc_vocabdag.html'>voc_vocabdag</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>2</td> <td class='detail' align='right'>4</td> <td class='detail' align='right'>44</td> <td class='comment detail'>A record in this table represents an ownership relationship of a Vocabulary over a DAG. A Vocabulary can have many DAGS, but a DAG can belong to at most one Vocabulary.</td> </tr> <tr class='tbl' valign='top'> <td class='detail'><a href='tables/wks_rosetta.html'>wks_rosetta</a></td> <td class='detail' align='right'></td> <td class='detail' align='right'>1</td> <td class='detail' align='right'>6</td> <td class='detail' align='right'>64</td> <td class='comment detail'>A record in this table represents the relationship between a Marker in the WK Silvers book and a Marker in MGI.</td> </tr> <tr> <td class='detail'> </td> <td class='detail'> </td> <td class='detail'> </td> <td class='detail'> </td> <td class='detail'> </td> <td class='comment detail'> </td> </tr> <tr class='tbl'> <td class='detail'>176 Tables</td> <td class='detail'> </td> <td class='detail'> </td> <td class='detail' align='right'>1,588</td> <td class='detail' align='right'>412,468,659</td> <td class='comment detail'> </td> </tr> <tr class='view'> <td class='detail'>126 Views</td> <td class='detail'> </td> <td class='detail'> </td> <td class='detail' align='right'>1,816</td> <td class='detail'> </td> <td class='comment detail'> </td> </tr> </table> </div> </body> </html>