Schema for knownToLocusLink
  Database: rn3    Primary Table: knownToLocusLink    Row Count: 6,054   Data last updated: 2004-06-01
Format description: Map known gene to some other ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name U72620varchar(255) values Same as name field in known gene
value 25157varchar(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)
      rn3.dmBlastTab.query (via knownToLocusLink.name)
      rn3.drBlastTab.query (via knownToLocusLink.name)
      rn3.dupSpMrna.mrnaID (via knownToLocusLink.name)
      rn3.gnfAtlas2Distance.query (via knownToLocusLink.name)
      rn3.gnfAtlas2Distance.target (via knownToLocusLink.name)
      rn3.hgBlastTab.query (via knownToLocusLink.name)
      rn3.keggPathway.kgID (via knownToLocusLink.name)
      rn3.kgAlias.kgID (via knownToLocusLink.name)
      rn3.kgProtAlias.kgID (via knownToLocusLink.name)
      rn3.kgSpAlias.kgID (via knownToLocusLink.name)
      rn3.kgXref.kgID (via knownToLocusLink.name)
      rn3.knownBlastTab.query (via knownToLocusLink.name)
      rn3.knownBlastTab.target (via knownToLocusLink.name)
      rn3.knownCanonical.transcript (via knownToLocusLink.name)
      rn3.knownGene.name (via knownToLocusLink.name)
      rn3.knownGeneLink.name (via knownToLocusLink.name)
      rn3.knownGeneMrna.name (via knownToLocusLink.name)
      rn3.knownGenePep.name (via knownToLocusLink.name)
      rn3.knownIsoforms.transcript (via knownToLocusLink.name)
      rn3.knownToEnsembl.name (via knownToLocusLink.name)
      rn3.knownToGnfAtlas2.name (via knownToLocusLink.name)
      rn3.knownToPfam.name (via knownToLocusLink.name)
      rn3.knownToRefSeq.name (via knownToLocusLink.name)
      rn3.knownToSuper.gene (via knownToLocusLink.name)
      rn3.scBlastTab.query (via knownToLocusLink.name)
      hgFixed.refLink.locusLinkId (via knownToLocusLink.value)
      knownGeneV39.knownToLocusLink.value (via knownToLocusLink.value)
      rn3.keggPathway.locusID (via knownToLocusLink.value)

Sample Rows
 
namevalue
U7262025157
D3795129721
M6525129721
U3705825264
AF361476114490
U15425207121
BC062039116465
U68272116465
J0272029221
U7878854410

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