Skip to main content
Schema for knownToLocusLink
  Database: hg19    Primary Table: knownToLocusLink    Row Count: 383,646   Data last updated: 2025-09-29
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000815471.1_1varchar(255) values Same as name field in known gene
value 105372730varchar(255) values Entrez Gene ID (formerly known as LocusLink)

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

Sample Rows
 
namevalue
ENST00000815471.1_1105372730
ENST00000623794.3_3105372730
ENST00000624813.1_1105372730
ENST00000815440.1_2105372730
ENST00000815474.1_1105372730
ENST00000815475.1_1105372730
ENST00000815476.1_1105372730
ENST00000815479.1_1105372730
ENST00000815478.1_1105372730
ENST00000815477.1_1105372730

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