Schema for knownToTag
  Database: hg38    Primary Table: knownToTag    Row Count: 617,511   Data last updated: 2023-08-22
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type description
name ENST00000000233.10varchar(255) primary ID
value CCDSvarchar(255) associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToTag.name)
      hg38.ccdsKgMap.geneId (via knownToTag.name)
      hg38.ceBlastTab.query (via knownToTag.name)
      hg38.dmBlastTab.query (via knownToTag.name)
      hg38.drBlastTab.query (via knownToTag.name)
      hg38.foldUtr3.name (via knownToTag.name)
      hg38.foldUtr5.name (via knownToTag.name)
      hg38.gnfAtlas2Distance.query (via knownToTag.name)
      hg38.gnfAtlas2Distance.target (via knownToTag.name)
      hg38.gnfU95Distance.query (via knownToTag.name)
      hg38.gnfU95Distance.target (via knownToTag.name)
      hg38.humanHprdP2P.query (via knownToTag.name)
      hg38.humanHprdP2P.target (via knownToTag.name)
      hg38.humanVidalP2P.query (via knownToTag.name)
      hg38.humanVidalP2P.target (via knownToTag.name)
      hg38.humanWankerP2P.query (via knownToTag.name)
      hg38.humanWankerP2P.target (via knownToTag.name)
      hg38.keggPathway.kgID (via knownToTag.name)
      hg38.kgAlias.kgID (via knownToTag.name)
      hg38.kgColor.kgID (via knownToTag.name)
      hg38.kgProtAlias.kgID (via knownToTag.name)
      hg38.kgSpAlias.kgID (via knownToTag.name)
      hg38.kgTargetAli.qName (via knownToTag.name)
      hg38.kgXref.kgID (via knownToTag.name)
      hg38.knownAttrs.kgID (via knownToTag.name)
      hg38.knownBlastTab.query (via knownToTag.name)
      hg38.knownBlastTab.target (via knownToTag.name)
      hg38.knownCanonical.transcript (via knownToTag.name)
      hg38.knownCds.name (via knownToTag.name)
      hg38.knownGene.name (via knownToTag.name)
      hg38.knownGeneMrna.name (via knownToTag.name)
      hg38.knownGenePep.name (via knownToTag.name)
      hg38.knownIsoforms.transcript (via knownToTag.name)
      hg38.knownToEnsembl.name (via knownToTag.name)
      hg38.knownToGnfAtlas2.name (via knownToTag.name)
      hg38.knownToHprd.name (via knownToTag.name)
      hg38.knownToKeggEntrez.name (via knownToTag.name)
      hg38.knownToLocusLink.name (via knownToTag.name)
      hg38.knownToLynx.name (via knownToTag.name)
      hg38.knownToMrna.name (via knownToTag.name)
      hg38.knownToMrnaSingle.name (via knownToTag.name)
      hg38.knownToMupit.name (via knownToTag.name)
      hg38.knownToNextProt.name (via knownToTag.name)
      hg38.knownToPfam.name (via knownToTag.name)
      hg38.knownToRefSeq.name (via knownToTag.name)
      hg38.knownToSuper.gene (via knownToTag.name)
      hg38.knownToU133.name (via knownToTag.name)
      hg38.knownToU95.name (via knownToTag.name)
      hg38.knownToVisiGene.name (via knownToTag.name)
      hg38.knownToWikipedia.name (via knownToTag.name)
      hg38.mmBlastTab.query (via knownToTag.name)
      hg38.rnBlastTab.query (via knownToTag.name)
      hg38.scBlastTab.query (via knownToTag.name)
      hg38.ucscScop.ucscId (via knownToTag.name)
      knownGeneV39.bioCycPathway.kgID (via knownToTag.name)
      knownGeneV39.ceBlastTab.query (via knownToTag.name)
      knownGeneV39.dmBlastTab.query (via knownToTag.name)
      knownGeneV39.drBlastTab.query (via knownToTag.name)
      knownGeneV39.foldUtr3.name (via knownToTag.name)
      knownGeneV39.foldUtr5.name (via knownToTag.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToTag.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToTag.name)
      knownGeneV39.kgAlias.kgID (via knownToTag.name)
      knownGeneV39.kgColor.kgID (via knownToTag.name)
      knownGeneV39.kgProtAlias.kgID (via knownToTag.name)
      knownGeneV39.kgSpAlias.kgID (via knownToTag.name)
      knownGeneV39.kgTargetAli.qName (via knownToTag.name)
      knownGeneV39.kgXref.kgID (via knownToTag.name)
      knownGeneV39.knownAttrs.kgID (via knownToTag.name)
      knownGeneV39.knownBlastTab.query (via knownToTag.name)
      knownGeneV39.knownBlastTab.target (via knownToTag.name)
      knownGeneV39.knownCanonical.protein (via knownToTag.name)
      knownGeneV39.knownCanonical.transcript (via knownToTag.name)
      knownGeneV39.knownCds.name (via knownToTag.name)
      knownGeneV39.knownGene.name (via knownToTag.name)
      knownGeneV39.knownGeneMrna.name (via knownToTag.name)
      knownGeneV39.knownGenePep.name (via knownToTag.name)
      knownGeneV39.knownIsoforms.transcript (via knownToTag.name)
      knownGeneV39.knownToEnsembl.name (via knownToTag.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToTag.name)
      knownGeneV39.knownToHprd.name (via knownToTag.name)
      knownGeneV39.knownToLocusLink.name (via knownToTag.name)
      knownGeneV39.knownToMrna.name (via knownToTag.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToTag.name)
      knownGeneV39.knownToMupit.name (via knownToTag.name)
      knownGeneV39.knownToPfam.name (via knownToTag.name)
      knownGeneV39.knownToRefSeq.name (via knownToTag.name)
      knownGeneV39.knownToSuper.gene (via knownToTag.name)
      knownGeneV39.knownToTag.name (via knownToTag.name)
      knownGeneV39.knownToU133.name (via knownToTag.name)
      knownGeneV39.knownToU95.name (via knownToTag.name)
      knownGeneV39.knownToVisiGene.name (via knownToTag.name)
      knownGeneV39.knownToWikipedia.name (via knownToTag.name)
      knownGeneV39.mmBlastTab.query (via knownToTag.name)
      knownGeneV39.rnBlastTab.query (via knownToTag.name)
      knownGeneV39.scBlastTab.query (via knownToTag.name)
      knownGeneV39.ucscScop.ucscId (via knownToTag.name)

Sample Rows
 
namevalue
ENST00000000233.10CCDS
ENST00000000233.10Ensembl_canonical
ENST00000000233.10MANE_Select
ENST00000000233.10appris_principal_1
ENST00000000233.10basic
ENST00000000233.10overlapping_locus
ENST00000000412.8CCDS
ENST00000000412.8Ensembl_canonical
ENST00000000412.8MANE_Select
ENST00000000412.8appris_principal_1

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