Schema for knownToLocusLink
  Database: hg19    Primary Table: knownToLocusLink    Row Count: 251,850   Data last updated: 2024-08-23
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000785042.1_1varchar(255) values Same as name field in known gene
value 149992varchar(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.knownCanonToDecipher.name (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.knownToDecipher.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)
      hg19.omim2gene.geneId (via knownToLocusLink.value)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
ENST00000785042.1_1149992
ENST00000507941.1_2149992
ENST00000785041.1_1149992
ENST00000785040.1_1149992
ENST00000785036.1_1149992
ENST00000785038.1_1149992
ENST00000785039.1_1149992
ENST00000785037.1_1149992
ENST00000447861.6_7149992
ENST00000785034.1_1149992

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