Schema for knownToLocusLink
  Database: mm7    Primary Table: knownToLocusLink    Row Count: 26,500   Data last updated: 2005-11-17
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_008483varchar(255) values Same as name field in known gene
value 16779varchar(255) values Entrez Gene ID (formerly known as LocusLink)

Connected Tables and Joining Fields
        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)
      mm7.affyGnfU74ADistance.query (via knownToLocusLink.name)
      mm7.affyGnfU74ADistance.target (via knownToLocusLink.name)
      mm7.affyGnfU74BDistance.query (via knownToLocusLink.name)
      mm7.affyGnfU74BDistance.target (via knownToLocusLink.name)
      mm7.affyGnfU74CDistance.query (via knownToLocusLink.name)
      mm7.affyGnfU74CDistance.target (via knownToLocusLink.name)
      mm7.dmBlastTab.query (via knownToLocusLink.name)
      mm7.drBlastTab.query (via knownToLocusLink.name)
      mm7.dupSpMrna.mrnaID (via knownToLocusLink.name)
      mm7.foldUtr3.name (via knownToLocusLink.name)
      mm7.foldUtr5.name (via knownToLocusLink.name)
      mm7.gnfAtlas2Distance.query (via knownToLocusLink.name)
      mm7.gnfAtlas2Distance.target (via knownToLocusLink.name)
      mm7.hgBlastTab.query (via knownToLocusLink.name)
      mm7.keggPathway.kgID (via knownToLocusLink.name)
      mm7.kgAlias.kgID (via knownToLocusLink.name)
      mm7.kgProtAlias.kgID (via knownToLocusLink.name)
      mm7.kgSpAlias.kgID (via knownToLocusLink.name)
      mm7.kgXref.kgID (via knownToLocusLink.name)
      mm7.knownBlastTab.query (via knownToLocusLink.name)
      mm7.knownBlastTab.target (via knownToLocusLink.name)
      mm7.knownCanonical.transcript (via knownToLocusLink.name)
      mm7.knownGene.name (via knownToLocusLink.name)
      mm7.knownGeneLink.name (via knownToLocusLink.name)
      mm7.knownGeneMrna.name (via knownToLocusLink.name)
      mm7.knownGenePep.name (via knownToLocusLink.name)
      mm7.knownIsoforms.transcript (via knownToLocusLink.name)
      mm7.knownToAllenBrain.name (via knownToLocusLink.name)
      mm7.knownToEnsembl.name (via knownToLocusLink.name)
      mm7.knownToGnfAtlas2.name (via knownToLocusLink.name)
      mm7.knownToKeggEntrez.name (via knownToLocusLink.name)
      mm7.knownToPfam.name (via knownToLocusLink.name)
      mm7.knownToRefSeq.name (via knownToLocusLink.name)
      mm7.knownToVisiGene.name (via knownToLocusLink.name)
      mm7.rnBlastTab.query (via knownToLocusLink.name)
      mm7.scBlastTab.query (via knownToLocusLink.name)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)
      mm7.keggPathway.locusID (via knownToLocusLink.value)

Sample Rows
 
namevalue
NM_00848316779
AK14175166396
AK07985083672
NM_001004153245128
BC086454245128
NM_03074081015
BC05799172465
NM_02824572465
AK16290372465
NM_01112418829

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