Schema for knownToLocusLink
  Database: hg38    Primary Table: knownToLocusLink    Row Count: 235,525   Data last updated: 2023-08-22
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000633083.1varchar(255) values Same as name field in known gene
value 6011varchar(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) Note: genome-wide queries are not available for this table.
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
ENST00000633083.16011
ENST00000631997.16011
ENST00000633962.1100130386
ENST00000707299.165265
ENST00000707300.165265
ENST00000707298.165265
ENST00000707301.165265
ENST00000707302.165265
ENST00000707303.165265
ENST00000707304.165265

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