Skip to main content
Schema for knownToLocusLink
  Database: mm39    Primary Table: knownToLocusLink    Row Count: 398,694   Data last updated: 2026-07-12
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000511732.1varchar(255) values Same as name field in known gene
value 66776varchar(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)
      mm39.bioCycPathway.kgID (via knownToLocusLink.name)
      mm39.ceBlastTab.query (via knownToLocusLink.name)
      mm39.dmBlastTab.query (via knownToLocusLink.name)
      mm39.drBlastTab.query (via knownToLocusLink.name)
      mm39.foldUtr3.name (via knownToLocusLink.name)
      mm39.foldUtr5.name (via knownToLocusLink.name)
      mm39.hgBlastTab.query (via knownToLocusLink.name)
      mm39.kgAlias.kgID (via knownToLocusLink.name)
      mm39.kgColor.kgID (via knownToLocusLink.name)
      mm39.kgProtAlias.kgID (via knownToLocusLink.name)
      mm39.kgSpAlias.kgID (via knownToLocusLink.name)
      mm39.kgTargetAli.qName (via knownToLocusLink.name)
      mm39.kgXref.kgID (via knownToLocusLink.name)
      mm39.knownAttrs.kgID (via knownToLocusLink.name)
      mm39.knownBlastTab.query (via knownToLocusLink.name)
      mm39.knownBlastTab.target (via knownToLocusLink.name)
      mm39.knownCanonical.transcript (via knownToLocusLink.name)
      mm39.knownCds.name (via knownToLocusLink.name)
      mm39.knownGene.name (via knownToLocusLink.name)
      mm39.knownGeneMrna.name (via knownToLocusLink.name)
      mm39.knownIsoforms.transcript (via knownToLocusLink.name)
      mm39.knownToEnsembl.name (via knownToLocusLink.name)
      mm39.knownToMrna.name (via knownToLocusLink.name)
      mm39.knownToMrnaSingle.name (via knownToLocusLink.name)
      mm39.knownToMupit.name (via knownToLocusLink.name)
      mm39.knownToNextProt.name (via knownToLocusLink.name)
      mm39.knownToPfam.name (via knownToLocusLink.name)
      mm39.knownToRefSeq.name (via knownToLocusLink.name)
      mm39.knownToSuper.gene (via knownToLocusLink.name)
      mm39.knownToTag.name (via knownToLocusLink.name)
      mm39.knownToVisiGene.name (via knownToLocusLink.name)
      mm39.knownToWikipedia.name (via knownToLocusLink.name)
      mm39.rnBlastTab.query (via knownToLocusLink.name)
      mm39.scBlastTab.query (via knownToLocusLink.name)
      mm39.ucscScop.ucscId (via knownToLocusLink.name)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
ENSMUST00000511732.166776
ENSMUST00000511735.166776
ENSMUST00000511733.166776
ENSMUST00000511734.166776
ENSMUST00000511738.166776
ENSMUST00000511737.166776
ENSMUST00000511736.166776
ENSMUST00000179505.866776
ENSMUST00000558924.166776
ENSMUST00000511740.166776

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