Schema for knownToLocusLink
  Database: hg17    Primary Table: knownToLocusLink    Row Count: 34,773   Data last updated: 2005-06-04
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_018390varchar(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
        hg17.bioCycPathway.kgID (via knownToLocusLink.name)
      hg17.ccdsKgMap.geneId (via knownToLocusLink.name)
      hg17.ceBlastTab.query (via knownToLocusLink.name)
      hg17.dmBlastTab.query (via knownToLocusLink.name)
      hg17.drBlastTab.query (via knownToLocusLink.name)
      hg17.dupSpMrna.mrnaID (via knownToLocusLink.name)
      hg17.foldUtr3.name (via knownToLocusLink.name)
      hg17.foldUtr5.name (via knownToLocusLink.name)
      hg17.gladHumESDistance.query (via knownToLocusLink.name)
      hg17.gladHumESDistance.target (via knownToLocusLink.name)
      hg17.gnfAtlas2Distance.query (via knownToLocusLink.name)
      hg17.gnfAtlas2Distance.target (via knownToLocusLink.name)
      hg17.gnfU95Distance.query (via knownToLocusLink.name)
      hg17.gnfU95Distance.target (via knownToLocusLink.name)
      hg17.humanHprdP2P.query (via knownToLocusLink.name)
      hg17.humanHprdP2P.target (via knownToLocusLink.name)
      hg17.humanVidalP2P.query (via knownToLocusLink.name)
      hg17.humanVidalP2P.target (via knownToLocusLink.name)
      hg17.humanWankerP2P.query (via knownToLocusLink.name)
      hg17.humanWankerP2P.target (via knownToLocusLink.name)
      hg17.keggPathway.kgID (via knownToLocusLink.name)
      hg17.kgAlias.kgID (via knownToLocusLink.name)
      hg17.kgProtAlias.kgID (via knownToLocusLink.name)
      hg17.kgSpAlias.kgID (via knownToLocusLink.name)
      hg17.kgTargetAli.qName (via knownToLocusLink.name)
      hg17.kgXref.kgID (via knownToLocusLink.name)
      hg17.knownBlastTab.query (via knownToLocusLink.name)
      hg17.knownBlastTab.target (via knownToLocusLink.name)
      hg17.knownCanonical.transcript (via knownToLocusLink.name)
      hg17.knownExpDistance.query (via knownToLocusLink.name)
      hg17.knownExpDistance.target (via knownToLocusLink.name)
      hg17.knownGene.name (via knownToLocusLink.name)
      hg17.knownGeneLink.name (via knownToLocusLink.name)
      hg17.knownGeneMrna.name (via knownToLocusLink.name)
      hg17.knownGenePep.name (via knownToLocusLink.name)
      hg17.knownIsoforms.transcript (via knownToLocusLink.name)
      hg17.knownToAllenBrain.name (via knownToLocusLink.name)
      hg17.knownToEnsembl.name (via knownToLocusLink.name)
      hg17.knownToGnf1h.name (via knownToLocusLink.name)
      hg17.knownToGnfAtlas2.name (via knownToLocusLink.name)
      hg17.knownToHInv.name (via knownToLocusLink.name)
      hg17.knownToHprd.name (via knownToLocusLink.name)
      hg17.knownToKeggEntrez.name (via knownToLocusLink.name)
      hg17.knownToPfam.name (via knownToLocusLink.name)
      hg17.knownToRefSeq.name (via knownToLocusLink.name)
      hg17.knownToSuper.gene (via knownToLocusLink.name)
      hg17.knownToU133.name (via knownToLocusLink.name)
      hg17.knownToU133Plus2.name (via knownToLocusLink.name)
      hg17.knownToU95.name (via knownToLocusLink.name)
      hg17.knownToVisiGene.name (via knownToLocusLink.name)
      hg17.mmBlastTab.query (via knownToLocusLink.name)
      hg17.rankProp.query (via knownToLocusLink.name)
      hg17.rankProp.target (via knownToLocusLink.name)
      hg17.rnBlastTab.query (via knownToLocusLink.name)
      hg17.scBlastTab.query (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)
      hg17.keggPathway.locusID (via knownToLocusLink.value)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
NM_01839055344
NM_0004516473
NM_0068836473
NM_0021833563
AK02339280161
NM_0050888227
L034268227
BC0281518227
NM_004043438
BC001620438

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