Schema for jaxOrtholog
  Database: hg16    Primary Table: jaxOrtholog    Row Count: 12,300   Data last updated: 2004-04-29
Format description: Jackson Lab Mouse Orthologs
On download server: MariaDB table dump directory
fieldexampleSQL type info description
humanSymbol MGC17301varchar(255) values Human HUGO Gene Nomenclature Committee symbol
humanBand 12q13.13varchar(255) values Human chromosomal location
mgiId MGI:1918914varchar(255) values Mouse database ID
mouseSymbol 0610006F02Rikvarchar(255) values Mouse human symbol
mouseChr 10varchar(255) values Mouse chromosome
mouseCm syntenicvarchar(255) values Mouse genetic map positionin centimorgans
mouseBand D3varchar(255) values Mouse chromosome band, if any

Connected Tables and Joining Fields
        hg16.atlasOncoGene.locusSymbol (via jaxOrtholog.humanSymbol)
      hg16.kgAlias.alias (via jaxOrtholog.humanSymbol)
      hg16.kgXref.geneSymbol (via jaxOrtholog.humanSymbol)
      hg16.refFlat.geneName (via jaxOrtholog.humanSymbol)
      hgFixed.refLink.name (via jaxOrtholog.humanSymbol)
      visiGene.gene.name (via jaxOrtholog.humanSymbol)
      hgFixed.refLink.name (via jaxOrtholog.mouseSymbol)
      visiGene.gene.name (via jaxOrtholog.mouseSymbol)

Sample Rows
 
humanSymbolhumanBandmgiIdmouseSymbolmouseChrmouseCmmouseBand
MGC1730112q13.13MGI:19189140610006F02Rik10syntenicD3
MGC319611q12.3MGI:19140860610006I08Rik19syntenicA
MGC1304511q13.1MGI:19155730610006K04Rik19syntenicN/A
APR-32p23.3MGI:19189180610007C21Rik5syntenicN/A
CGI-11912q14.1-q15MGI:19154620610007H07Rik10syntenicN/A
LOC569599q22.33MGI:19235010610007P08Rik13syntenicB3
PSFL15q22.1MGI:19155680610008A10Rik9syntenicD
LOC5627017q25.3MGI:19140900610008N23Rik113.40N/A
HPRP8BP1p35.1MGI:19138350610009C03Rik4syntenicD3
MGC296317p13.3MGI:19132980610009E20Rik11syntenicB4

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.