Schema for knownToLocusLink
  Database: hg18    Primary Table: knownToLocusLink    Row Count: 59,950   Data last updated: 2009-03-04
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc004fon.1varchar(255) values Same as name field in known gene
value 55344varchar(255) values Entrez Gene ID (formerly known as LocusLink)

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToLocusLink.name)
      hg18.ccdsKgMap.geneId (via knownToLocusLink.name)
      hg18.ceBlastTab.query (via knownToLocusLink.name)
      hg18.dmBlastTab.query (via knownToLocusLink.name)
      hg18.drBlastTab.query (via knownToLocusLink.name)
      hg18.foldUtr3.name (via knownToLocusLink.name)
      hg18.foldUtr5.name (via knownToLocusLink.name)
      hg18.gnfAtlas2Distance.query (via knownToLocusLink.name)
      hg18.gnfAtlas2Distance.target (via knownToLocusLink.name)
      hg18.gnfU95Distance.query (via knownToLocusLink.name)
      hg18.gnfU95Distance.target (via knownToLocusLink.name)
      hg18.humanHprdP2P.query (via knownToLocusLink.name)
      hg18.humanHprdP2P.target (via knownToLocusLink.name)
      hg18.humanVidalP2P.query (via knownToLocusLink.name)
      hg18.humanVidalP2P.target (via knownToLocusLink.name)
      hg18.humanWankerP2P.query (via knownToLocusLink.name)
      hg18.humanWankerP2P.target (via knownToLocusLink.name)
      hg18.keggPathway.kgID (via knownToLocusLink.name)
      hg18.kgAlias.kgID (via knownToLocusLink.name)
      hg18.kgColor.kgID (via knownToLocusLink.name)
      hg18.kgProtAlias.kgID (via knownToLocusLink.name)
      hg18.kgProtMap2.qName (via knownToLocusLink.name)
      hg18.kgSpAlias.kgID (via knownToLocusLink.name)
      hg18.kgTargetAli.qName (via knownToLocusLink.name)
      hg18.kgTxInfo.name (via knownToLocusLink.name)
      hg18.kgXref.kgID (via knownToLocusLink.name)
      hg18.knownBlastTab.query (via knownToLocusLink.name)
      hg18.knownBlastTab.target (via knownToLocusLink.name)
      hg18.knownCanonToDecipher.name (via knownToLocusLink.name)
      hg18.knownCanonical.protein (via knownToLocusLink.name)
      hg18.knownCanonical.transcript (via knownToLocusLink.name)
      hg18.knownGene.name (via knownToLocusLink.name)
      hg18.knownGeneMrna.name (via knownToLocusLink.name)
      hg18.knownGenePep.name (via knownToLocusLink.name)
      hg18.knownIsoforms.transcript (via knownToLocusLink.name)
      hg18.knownToAllenBrain.name (via knownToLocusLink.name)
      hg18.knownToDecipher.name (via knownToLocusLink.name)
      hg18.knownToEnsembl.name (via knownToLocusLink.name)
      hg18.knownToGnf1h.name (via knownToLocusLink.name)
      hg18.knownToGnfAtlas2.name (via knownToLocusLink.name)
      hg18.knownToHInv.name (via knownToLocusLink.name)
      hg18.knownToHprd.name (via knownToLocusLink.name)
      hg18.knownToKeggEntrez.name (via knownToLocusLink.name)
      hg18.knownToMupit.name (via knownToLocusLink.name)
      hg18.knownToPfam.name (via knownToLocusLink.name)
      hg18.knownToRefSeq.name (via knownToLocusLink.name)
      hg18.knownToSuper.gene (via knownToLocusLink.name)
      hg18.knownToTreefam.name (via knownToLocusLink.name)
      hg18.knownToU133.name (via knownToLocusLink.name)
      hg18.knownToU133Plus2.name (via knownToLocusLink.name)
      hg18.knownToU95.name (via knownToLocusLink.name)
      hg18.knownToVisiGene.name (via knownToLocusLink.name)
      hg18.mmBlastTab.query (via knownToLocusLink.name)
      hg18.rnBlastTab.query (via knownToLocusLink.name)
      hg18.scBlastTab.query (via knownToLocusLink.name)
      hg18.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)
      hg18.keggPathway.locusID (via knownToLocusLink.value)
      hg18.omim2gene.geneId (via knownToLocusLink.value)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
uc004fon.155344
uc004foo.155344
uc004fop.155344
uc004fou.16473
uc004fov.16473
uc004fpa.11438
uc004fpb.11438
uc004fpc.11438
uc004fpd.11438
uc010nvt.11438

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