Schema for knownToLocusLink
  Database: hg38    Primary Table: knownToLocusLink    Row Count: 229,391   Data last updated: 2022-05-15
Format description: Map known gene to some other ID
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)
      hg38.keggPathway.locusID (via knownToLocusLink.value)
      hg38.omim2gene.geneId (via knownToLocusLink.value)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)

Sample Rows
 
namevalue
ENST00000633083.16011
ENST00000631997.16011
ENST00000633962.1100130386
ENST00000615646.4653247
ENST00000625471.2653247
ENST00000612920.2653247
ENST00000620127.3653247
ENST00000628976.2653247
ENST00000614336.4102724250
ENST00000612640.4102724250

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