Schema for knownToLocusLink
  Database: mm10    Primary Table: knownToLocusLink    Row Count: 102,339   Data last updated: 2019-09-20
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000096791.11varchar(255) values Same as name field in known gene
value 22308varchar(255) values Entrez Gene ID (formerly known as LocusLink)

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToLocusLink.name)
      knownGeneV39.ceBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.dmBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.drBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.foldUtr3.name (via knownToLocusLink.name)
      knownGeneV39.foldUtr5.name (via knownToLocusLink.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToLocusLink.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToLocusLink.name)
      knownGeneV39.kgAlias.kgID (via knownToLocusLink.name)
      knownGeneV39.kgColor.kgID (via knownToLocusLink.name)
      knownGeneV39.kgProtAlias.kgID (via knownToLocusLink.name)
      knownGeneV39.kgSpAlias.kgID (via knownToLocusLink.name)
      knownGeneV39.kgTargetAli.qName (via knownToLocusLink.name)
      knownGeneV39.kgXref.kgID (via knownToLocusLink.name)
      knownGeneV39.knownAttrs.kgID (via knownToLocusLink.name)
      knownGeneV39.knownBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.knownBlastTab.target (via knownToLocusLink.name)
      knownGeneV39.knownCanonical.protein (via knownToLocusLink.name)
      knownGeneV39.knownCanonical.transcript (via knownToLocusLink.name)
      knownGeneV39.knownCds.name (via knownToLocusLink.name)
      knownGeneV39.knownGene.name (via knownToLocusLink.name)
      knownGeneV39.knownGeneMrna.name (via knownToLocusLink.name)
      knownGeneV39.knownGenePep.name (via knownToLocusLink.name)
      knownGeneV39.knownIsoforms.transcript (via knownToLocusLink.name)
      knownGeneV39.knownToEnsembl.name (via knownToLocusLink.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToLocusLink.name)
      knownGeneV39.knownToHprd.name (via knownToLocusLink.name)
      knownGeneV39.knownToLocusLink.name (via knownToLocusLink.name)
      knownGeneV39.knownToMrna.name (via knownToLocusLink.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToLocusLink.name)
      knownGeneV39.knownToMupit.name (via knownToLocusLink.name)
      knownGeneV39.knownToPfam.name (via knownToLocusLink.name)
      knownGeneV39.knownToRefSeq.name (via knownToLocusLink.name)
      knownGeneV39.knownToSuper.gene (via knownToLocusLink.name)
      knownGeneV39.knownToTag.name (via knownToLocusLink.name)
      knownGeneV39.knownToU133.name (via knownToLocusLink.name)
      knownGeneV39.knownToU95.name (via knownToLocusLink.name)
      knownGeneV39.knownToVisiGene.name (via knownToLocusLink.name)
      knownGeneV39.knownToWikipedia.name (via knownToLocusLink.name)
      knownGeneV39.mmBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.rnBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.scBlastTab.query (via knownToLocusLink.name)
      knownGeneV39.ucscScop.ucscId (via knownToLocusLink.name)
      mm10.bioCycPathway.kgID (via knownToLocusLink.name)
      mm10.ccdsKgMap.geneId (via knownToLocusLink.name)
      mm10.ceBlastTab.query (via knownToLocusLink.name)
      mm10.dmBlastTab.query (via knownToLocusLink.name)
      mm10.drBlastTab.query (via knownToLocusLink.name)
      mm10.foldUtr3.name (via knownToLocusLink.name)
      mm10.foldUtr5.name (via knownToLocusLink.name)
      mm10.hgBlastTab.query (via knownToLocusLink.name)
      mm10.keggPathway.kgID (via knownToLocusLink.name)
      mm10.kgAlias.kgID (via knownToLocusLink.name)
      mm10.kgColor.kgID (via knownToLocusLink.name)
      mm10.kgProtAlias.kgID (via knownToLocusLink.name)
      mm10.kgProtMap2.qName (via knownToLocusLink.name)
      mm10.kgSpAlias.kgID (via knownToLocusLink.name)
      mm10.kgTargetAli.qName (via knownToLocusLink.name)
      mm10.kgTxInfo.name (via knownToLocusLink.name)
      mm10.kgXref.kgID (via knownToLocusLink.name)
      mm10.knownAttrs.kgID (via knownToLocusLink.name)
      mm10.knownBlastTab.query (via knownToLocusLink.name)
      mm10.knownBlastTab.target (via knownToLocusLink.name)
      mm10.knownCanonical.transcript (via knownToLocusLink.name)
      mm10.knownCds.name (via knownToLocusLink.name)
      mm10.knownGene.name (via knownToLocusLink.name)
      mm10.knownGeneMrna.name (via knownToLocusLink.name)
      mm10.knownGenePep.name (via knownToLocusLink.name)
      mm10.knownIsoforms.transcript (via knownToLocusLink.name)
      mm10.knownToEnsembl.name (via knownToLocusLink.name)
      mm10.knownToKeggEntrez.name (via knownToLocusLink.name)
      mm10.knownToLynx.name (via knownToLocusLink.name)
      mm10.knownToMrna.name (via knownToLocusLink.name)
      mm10.knownToMrnaSingle.name (via knownToLocusLink.name)
      mm10.knownToPfam.name (via knownToLocusLink.name)
      mm10.knownToRefSeq.name (via knownToLocusLink.name)
      mm10.knownToSuper.gene (via knownToLocusLink.name)
      mm10.knownToTag.name (via knownToLocusLink.name)
      mm10.knownToVisiGene.name (via knownToLocusLink.name)
      mm10.knownToWikipedia.name (via knownToLocusLink.name)
      mm10.rnBlastTab.query (via knownToLocusLink.name)
      mm10.scBlastTab.query (via knownToLocusLink.name)
      mm10.ucscScop.ucscId (via knownToLocusLink.name)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)
      mm10.keggPathway.locusID (via knownToLocusLink.value)

Sample Rows
 
namevalue
ENSMUST00000096791.1122308
ENSMUST00000071277.1322308
ENSMUST00000179115.122308
ENSMUST00000099422.422308
ENSMUST00000178970.722308
ENSMUST00000077235.3236082
ENSMUST00000179505.766776
ENSMUST00000178343.166776
ENSMUST00000177783.1100039479
ENSMUST00000177979.1100039499

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