Schema for knownToEnsembl
  Database: hg16    Primary Table: knownToEnsembl    Row Count: 39,371   Data last updated: 2004-07-14
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 AK097327varchar(255) values primary ID
value ENST00000326734varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToEnsembl.name)
      hg16.dmBlastTab.query (via knownToEnsembl.name)
      hg16.drBlastTab.query (via knownToEnsembl.name)
      hg16.dupSpMrna.mrnaID (via knownToEnsembl.name)
      hg16.foldUtr3.name (via knownToEnsembl.name)
      hg16.foldUtr5.name (via knownToEnsembl.name)
      hg16.gnfAtlas2Distance.query (via knownToEnsembl.name)
      hg16.gnfAtlas2Distance.target (via knownToEnsembl.name)
      hg16.gnfU95Distance.query (via knownToEnsembl.name)
      hg16.gnfU95Distance.target (via knownToEnsembl.name)
      hg16.hg17Kg.name (via knownToEnsembl.name)
      hg16.keggPathway.kgID (via knownToEnsembl.name)
      hg16.kgAlias.kgID (via knownToEnsembl.name)
      hg16.kgProtAlias.kgID (via knownToEnsembl.name)
      hg16.kgXref.kgID (via knownToEnsembl.name)
      hg16.knownBlastTab.query (via knownToEnsembl.name)
      hg16.knownBlastTab.target (via knownToEnsembl.name)
      hg16.knownCanonical.transcript (via knownToEnsembl.name)
      hg16.knownGene.name (via knownToEnsembl.name)
      hg16.knownGeneLink.name (via knownToEnsembl.name)
      hg16.knownGeneMrna.name (via knownToEnsembl.name)
      hg16.knownGenePep.name (via knownToEnsembl.name)
      hg16.knownIsoforms.transcript (via knownToEnsembl.name)
      hg16.knownToGnfAtlas2.name (via knownToEnsembl.name)
      hg16.knownToHInv.name (via knownToEnsembl.name)
      hg16.knownToLocusLink.name (via knownToEnsembl.name)
      hg16.knownToPfam.name (via knownToEnsembl.name)
      hg16.knownToRefSeq.name (via knownToEnsembl.name)
      hg16.knownToSuper.gene (via knownToEnsembl.name)
      hg16.knownToU133.name (via knownToEnsembl.name)
      hg16.knownToU95.name (via knownToEnsembl.name)
      hg16.scBlastTab.query (via knownToEnsembl.name)
      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)
      hg16.ensGene.name (via knownToEnsembl.value)
      hg16.ensGtp.transcript (via knownToEnsembl.value)
      hg16.ensPep.name (via knownToEnsembl.value)
      knownGeneV39.knownToEnsembl.value (via knownToEnsembl.value)

Sample Rows
 
namevalue
AK097327ENST00000326734
BC015393ENST00000326678
AK124125ENST00000309906
AK093438ENST00000309906
AY050570ENST00000326216
BC015549ENST00000326216
AK093239ENST00000338555
BC034304ENST00000304185
BC004366ENST00000343938
BC059409ENST00000322762

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