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

Sample Rows
 
namevalue
uc009vfk.1382301
uc009vfo.1380994
uc009vfp.1380994
uc009vfq.1100039810
uc012hsg.1100040022
uc009vgb.1380994
uc009vgc.1380994
uc009vgg.1100040031
uc012hsn.1100040160
uc012hsq.1100040911

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