Schema for knownToEnsembl
  Database: rn3    Primary Table: knownToEnsembl    Row Count: 7,199   Data last updated: 2004-05-28
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name AF347030varchar(255) values primary ID
value ENSRNOT00000019941.2varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToEnsembl.name)
      knownGeneV39.ceBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.dmBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.drBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.foldUtr3.name (via knownToEnsembl.name)
      knownGeneV39.foldUtr5.name (via knownToEnsembl.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToEnsembl.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToEnsembl.name)
      knownGeneV39.kgAlias.kgID (via knownToEnsembl.name)
      knownGeneV39.kgColor.kgID (via knownToEnsembl.name)
      knownGeneV39.kgProtAlias.kgID (via knownToEnsembl.name)
      knownGeneV39.kgSpAlias.kgID (via knownToEnsembl.name)
      knownGeneV39.kgTargetAli.qName (via knownToEnsembl.name)
      knownGeneV39.kgXref.kgID (via knownToEnsembl.name)
      knownGeneV39.knownAttrs.kgID (via knownToEnsembl.name)
      knownGeneV39.knownBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.knownBlastTab.target (via knownToEnsembl.name)
      knownGeneV39.knownCanonical.protein (via knownToEnsembl.name)
      knownGeneV39.knownCanonical.transcript (via knownToEnsembl.name)
      knownGeneV39.knownCds.name (via knownToEnsembl.name)
      knownGeneV39.knownGene.name (via knownToEnsembl.name)
      knownGeneV39.knownGeneMrna.name (via knownToEnsembl.name)
      knownGeneV39.knownGenePep.name (via knownToEnsembl.name)
      knownGeneV39.knownIsoforms.transcript (via knownToEnsembl.name)
      knownGeneV39.knownToEnsembl.name (via knownToEnsembl.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToEnsembl.name)
      knownGeneV39.knownToHprd.name (via knownToEnsembl.name)
      knownGeneV39.knownToLocusLink.name (via knownToEnsembl.name)
      knownGeneV39.knownToMrna.name (via knownToEnsembl.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToEnsembl.name)
      knownGeneV39.knownToMupit.name (via knownToEnsembl.name)
      knownGeneV39.knownToPfam.name (via knownToEnsembl.name)
      knownGeneV39.knownToRefSeq.name (via knownToEnsembl.name)
      knownGeneV39.knownToSuper.gene (via knownToEnsembl.name)
      knownGeneV39.knownToTag.name (via knownToEnsembl.name)
      knownGeneV39.knownToU133.name (via knownToEnsembl.name)
      knownGeneV39.knownToU95.name (via knownToEnsembl.name)
      knownGeneV39.knownToVisiGene.name (via knownToEnsembl.name)
      knownGeneV39.knownToWikipedia.name (via knownToEnsembl.name)
      knownGeneV39.mmBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.rnBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.scBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.ucscScop.ucscId (via knownToEnsembl.name)
      rn3.dmBlastTab.query (via knownToEnsembl.name)
      rn3.drBlastTab.query (via knownToEnsembl.name)
      rn3.dupSpMrna.mrnaID (via knownToEnsembl.name)
      rn3.gnfAtlas2Distance.query (via knownToEnsembl.name)
      rn3.gnfAtlas2Distance.target (via knownToEnsembl.name)
      rn3.hgBlastTab.query (via knownToEnsembl.name)
      rn3.keggPathway.kgID (via knownToEnsembl.name)
      rn3.kgAlias.kgID (via knownToEnsembl.name)
      rn3.kgProtAlias.kgID (via knownToEnsembl.name)
      rn3.kgSpAlias.kgID (via knownToEnsembl.name)
      rn3.kgXref.kgID (via knownToEnsembl.name)
      rn3.knownBlastTab.query (via knownToEnsembl.name)
      rn3.knownBlastTab.target (via knownToEnsembl.name)
      rn3.knownCanonical.transcript (via knownToEnsembl.name)
      rn3.knownGene.name (via knownToEnsembl.name)
      rn3.knownGeneLink.name (via knownToEnsembl.name)
      rn3.knownGeneMrna.name (via knownToEnsembl.name)
      rn3.knownGenePep.name (via knownToEnsembl.name)
      rn3.knownIsoforms.transcript (via knownToEnsembl.name)
      rn3.knownToGnfAtlas2.name (via knownToEnsembl.name)
      rn3.knownToLocusLink.name (via knownToEnsembl.name)
      rn3.knownToPfam.name (via knownToEnsembl.name)
      rn3.knownToRefSeq.name (via knownToEnsembl.name)
      rn3.knownToSuper.gene (via knownToEnsembl.name)
      rn3.scBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.knownToEnsembl.value (via knownToEnsembl.value)
      rn3.ensGene.name (via knownToEnsembl.value)
      rn3.ensGeneXref.transcript_name (via knownToEnsembl.value)
      rn3.ensGtp.transcript (via knownToEnsembl.value)
      rn3.ensPep.name (via knownToEnsembl.value)
      rn3.ensTranscript.transcript_name (via knownToEnsembl.value)

Sample Rows
 
namevalue
AF347030ENSRNOT00000019941.2
U72620ENSRNOT00000030329.1
D37951ENSRNOT00000015131.2
M65251ENSRNOT00000015131.2
U37058ENSRNOT00000016215.2
AF361476ENSRNOT00000016244.2
U15425ENSRNOT00000037550.1
BC062039ENSRNOT00000016286.2
U68272ENSRNOT00000016286.2
AJ555485ENSRNOT00000016354.2

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