Schema for knownToNextProt
  Database: hg38    Primary Table: knownToNextProt    Row Count: 47,975   Data last updated: 2023-08-23
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 ENST00000322209.5varchar(255) values primary ID
value NX_A0A024RBG1varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000322209.5NX_A0A024RBG1
ENST00000390247.2NX_A0A075B6H7
ENST00000633250.1NX_A0A075B6H7
ENST00000390278.3NX_A0A075B6H8
ENST00000390282.2NX_A0A075B6H9
ENST00000390283.2NX_A0A075B6I0
ENST00000390284.2NX_A0A075B6I1
ENST00000390286.3NX_A0A075B6I3
ENST00000390287.2NX_A0A075B6I4
ENST00000390291.2NX_A0A075B6I6

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