Skip to main content
Schema for knownToLocusLink
  Database: hg38    Primary Table: knownToLocusLink    Row Count: 584,958   Data last updated: 2026-07-16
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type description
name ENST00000839853.1varchar(255) Same as name field in known gene
value 105379565varchar(255) Entrez Gene ID (formerly known as LocusLink)

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToLocusLink.name)
      hg38.ccdsKgMap.geneId (via knownToLocusLink.name)
      hg38.ceBlastTab.query (via knownToLocusLink.name)
      hg38.dmBlastTab.query (via knownToLocusLink.name)
      hg38.drBlastTab.query (via knownToLocusLink.name)
      hg38.foldUtr3.name (via knownToLocusLink.name)
      hg38.foldUtr5.name (via knownToLocusLink.name)
      hg38.gnfAtlas2Distance.query (via knownToLocusLink.name)
      hg38.gnfAtlas2Distance.target (via knownToLocusLink.name)
      hg38.gnfU95Distance.query (via knownToLocusLink.name)
      hg38.gnfU95Distance.target (via knownToLocusLink.name)
      hg38.humanHprdP2P.query (via knownToLocusLink.name)
      hg38.humanHprdP2P.target (via knownToLocusLink.name)
      hg38.humanVidalP2P.query (via knownToLocusLink.name)
      hg38.humanVidalP2P.target (via knownToLocusLink.name)
      hg38.humanWankerP2P.query (via knownToLocusLink.name)
      hg38.humanWankerP2P.target (via knownToLocusLink.name)
      hg38.keggPathway.kgID (via knownToLocusLink.name)
      hg38.kgAlias.kgID (via knownToLocusLink.name)
      hg38.kgColor.kgID (via knownToLocusLink.name)
      hg38.kgProtAlias.kgID (via knownToLocusLink.name)
      hg38.kgSpAlias.kgID (via knownToLocusLink.name)
      hg38.kgTargetAli.qName (via knownToLocusLink.name)
      hg38.kgXref.kgID (via knownToLocusLink.name)
      hg38.knownAttrs.kgID (via knownToLocusLink.name)
      hg38.knownBlastTab.query (via knownToLocusLink.name)
      hg38.knownBlastTab.target (via knownToLocusLink.name)
      hg38.knownCanonical.transcript (via knownToLocusLink.name)
      hg38.knownCds.name (via knownToLocusLink.name)
      hg38.knownGene.name (via knownToLocusLink.name)
      hg38.knownGeneMrna.name (via knownToLocusLink.name)
      hg38.knownGenePep.name (via knownToLocusLink.name)
      hg38.knownIsoforms.transcript (via knownToLocusLink.name)
      hg38.knownToEnsembl.name (via knownToLocusLink.name)
      hg38.knownToGnfAtlas2.name (via knownToLocusLink.name)
      hg38.knownToHprd.name (via knownToLocusLink.name)
      hg38.knownToKeggEntrez.name (via knownToLocusLink.name)
      hg38.knownToLynx.name (via knownToLocusLink.name)
      hg38.knownToMrna.name (via knownToLocusLink.name)
      hg38.knownToMrnaSingle.name (via knownToLocusLink.name)
      hg38.knownToMupit.name (via knownToLocusLink.name)
      hg38.knownToNextProt.name (via knownToLocusLink.name)
      hg38.knownToPfam.name (via knownToLocusLink.name)
      hg38.knownToRefSeq.name (via knownToLocusLink.name)
      hg38.knownToSuper.gene (via knownToLocusLink.name)
      hg38.knownToTag.name (via knownToLocusLink.name)
      hg38.knownToU133.name (via knownToLocusLink.name)
      hg38.knownToU95.name (via knownToLocusLink.name)
      hg38.knownToVisiGene.name (via knownToLocusLink.name)
      hg38.knownToWikipedia.name (via knownToLocusLink.name)
      hg38.mmBlastTab.query (via knownToLocusLink.name)
      hg38.rnBlastTab.query (via knownToLocusLink.name)
      hg38.scBlastTab.query (via knownToLocusLink.name)
      hg38.ucscScop.ucscId (via knownToLocusLink.name)
      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)
      hg38.keggPathway.locusID (via knownToLocusLink.value)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
ENST00000839853.1105379565
ENST00000633083.16011
ENST00000631997.16011
ENST00000633962.1100130386
ENST00000844181.1105379525
ENST00000844182.1105379525
ENST00000844183.1105379525
ENST00000844179.1105379525
ENST00000783551.1102724813
ENST00000783552.1102724813

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