Schema for knownToLocusLink
  Database: mm8    Primary Table: knownToLocusLink    Row Count: 27,636   Data last updated: 2006-03-09
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_030175varchar(255) values Same as name field in known gene
value 78772varchar(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)
      mm8.affyGnfU74ADistance.query (via knownToLocusLink.name)
      mm8.affyGnfU74ADistance.target (via knownToLocusLink.name)
      mm8.affyGnfU74BDistance.query (via knownToLocusLink.name)
      mm8.affyGnfU74BDistance.target (via knownToLocusLink.name)
      mm8.affyGnfU74CDistance.query (via knownToLocusLink.name)
      mm8.affyGnfU74CDistance.target (via knownToLocusLink.name)
      mm8.ccdsKgMap.geneId (via knownToLocusLink.name)
      mm8.ceBlastTab.query (via knownToLocusLink.name)
      mm8.dmBlastTab.query (via knownToLocusLink.name)
      mm8.drBlastTab.query (via knownToLocusLink.name)
      mm8.dupSpMrna.mrnaID (via knownToLocusLink.name)
      mm8.foldUtr3.name (via knownToLocusLink.name)
      mm8.foldUtr5.name (via knownToLocusLink.name)
      mm8.gnfAtlas2Distance.query (via knownToLocusLink.name)
      mm8.gnfAtlas2Distance.target (via knownToLocusLink.name)
      mm8.hgBlastTab.query (via knownToLocusLink.name)
      mm8.keggPathway.kgID (via knownToLocusLink.name)
      mm8.kgAlias.kgID (via knownToLocusLink.name)
      mm8.kgProtAlias.kgID (via knownToLocusLink.name)
      mm8.kgSpAlias.kgID (via knownToLocusLink.name)
      mm8.kgTargetAli.qName (via knownToLocusLink.name)
      mm8.kgXref.kgID (via knownToLocusLink.name)
      mm8.knownBlastTab.query (via knownToLocusLink.name)
      mm8.knownBlastTab.target (via knownToLocusLink.name)
      mm8.knownCanonical.transcript (via knownToLocusLink.name)
      mm8.knownGene.name (via knownToLocusLink.name)
      mm8.knownGeneMrna.name (via knownToLocusLink.name)
      mm8.knownGenePep.name (via knownToLocusLink.name)
      mm8.knownIsoforms.transcript (via knownToLocusLink.name)
      mm8.knownToAllenBrain.name (via knownToLocusLink.name)
      mm8.knownToEnsembl.name (via knownToLocusLink.name)
      mm8.knownToGnfAtlas2.name (via knownToLocusLink.name)
      mm8.knownToKeggEntrez.name (via knownToLocusLink.name)
      mm8.knownToPfam.name (via knownToLocusLink.name)
      mm8.knownToRefSeq.name (via knownToLocusLink.name)
      mm8.knownToSuper.gene (via knownToLocusLink.name)
      mm8.knownToVisiGene.name (via knownToLocusLink.name)
      mm8.rnBlastTab.query (via knownToLocusLink.name)
      mm8.scBlastTab.query (via knownToLocusLink.name)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)
      mm8.keggPathway.locusID (via knownToLocusLink.value)

Sample Rows
 
namevalue
NM_03017578772
NM_001030293236576
NM_153523236219
NM_001037925625360
NM_172505212427
BC100378212427
NM_02786171678
AK00248971678
AK01594667410
NM_02613667410

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