Schema for knownToLocusLink
  Database: hg16    Primary Table: knownToLocusLink    Row Count: 36,078   Data last updated: 2004-03-30
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name AK124125varchar(255) values Same as name field in known gene
value 254173varchar(255) values Entrez Gene ID (formerly known as LocusLink)

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToLocusLink.name)
      hg16.dmBlastTab.query (via knownToLocusLink.name)
      hg16.drBlastTab.query (via knownToLocusLink.name)
      hg16.dupSpMrna.mrnaID (via knownToLocusLink.name)
      hg16.foldUtr3.name (via knownToLocusLink.name)
      hg16.foldUtr5.name (via knownToLocusLink.name)
      hg16.gnfAtlas2Distance.query (via knownToLocusLink.name)
      hg16.gnfAtlas2Distance.target (via knownToLocusLink.name)
      hg16.gnfU95Distance.query (via knownToLocusLink.name)
      hg16.gnfU95Distance.target (via knownToLocusLink.name)
      hg16.hg17Kg.name (via knownToLocusLink.name)
      hg16.keggPathway.kgID (via knownToLocusLink.name)
      hg16.kgAlias.kgID (via knownToLocusLink.name)
      hg16.kgProtAlias.kgID (via knownToLocusLink.name)
      hg16.kgXref.kgID (via knownToLocusLink.name)
      hg16.knownBlastTab.query (via knownToLocusLink.name)
      hg16.knownBlastTab.target (via knownToLocusLink.name)
      hg16.knownCanonical.transcript (via knownToLocusLink.name)
      hg16.knownGene.name (via knownToLocusLink.name)
      hg16.knownGeneLink.name (via knownToLocusLink.name)
      hg16.knownGeneMrna.name (via knownToLocusLink.name)
      hg16.knownGenePep.name (via knownToLocusLink.name)
      hg16.knownIsoforms.transcript (via knownToLocusLink.name)
      hg16.knownToEnsembl.name (via knownToLocusLink.name)
      hg16.knownToGnfAtlas2.name (via knownToLocusLink.name)
      hg16.knownToHInv.name (via knownToLocusLink.name)
      hg16.knownToPfam.name (via knownToLocusLink.name)
      hg16.knownToRefSeq.name (via knownToLocusLink.name)
      hg16.knownToSuper.gene (via knownToLocusLink.name)
      hg16.knownToU133.name (via knownToLocusLink.name)
      hg16.knownToU95.name (via knownToLocusLink.name)
      hg16.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)
      hg16.keggPathway.locusID (via knownToLocusLink.value)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)

Sample Rows
 
namevalue
AK124125254173
AK093438254173
AY050570126792
BC015549126792
AK0932396339
BC034304126789
BC00436680772
BC05940964856
BC00354364856
AK094502219293

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