Schema for knownToLocusLink
  Database: mm39    Primary Table: knownToLocusLink    Row Count: 195,465   Data last updated: 2024-08-15
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000179505.8varchar(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
ENSMUST00000179505.866776
ENSMUST00000178343.266776
ENSMUST00000179715.2671917
ENSMUST00000115924.3102638047
ENSMUST00000381699.1101055672
ENSMUST00000381700.1101055672
ENSMUST00000381705.1101055672
ENSMUST00000111364.3101055672
ENSMUST00000381702.1101055672
ENSMUST00000381704.1101055672

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