Schema for knownToLocusLink
  Database: hg38    Primary Table: knownToLocusLink    Row Count: 326,184   Data last updated: 2024-08-19
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000839853.1varchar(255) values Same as name field in known gene
value 105379565varchar(255) values 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)
      hg38.omim2gene.geneId (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
ENST00000844179.1105379525
ENST00000844182.1105379525
ENST00000844183.1105379525
ENST00000783549.1102724813
ENST00000783551.1102724813

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