Schema for knownToNextProt
  Database: hg19    Primary Table: knownToNextProt    Row Count: 33,152   Data last updated: 2014-03-19
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 uc001fas.4varchar(255) values primary ID
value NX_A0A183varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToNextProt.name)
      hg19.ceBlastTab.query (via knownToNextProt.name)
      hg19.dmBlastTab.query (via knownToNextProt.name)
      hg19.drBlastTab.query (via knownToNextProt.name)
      hg19.foldUtr3.name (via knownToNextProt.name)
      hg19.foldUtr5.name (via knownToNextProt.name)
      hg19.gnfAtlas2Distance.query (via knownToNextProt.name)
      hg19.gnfAtlas2Distance.target (via knownToNextProt.name)
      hg19.gnfU95Distance.query (via knownToNextProt.name)
      hg19.gnfU95Distance.target (via knownToNextProt.name)
      hg19.humanHprdP2P.query (via knownToNextProt.name)
      hg19.humanHprdP2P.target (via knownToNextProt.name)
      hg19.humanVidalP2P.query (via knownToNextProt.name)
      hg19.humanVidalP2P.target (via knownToNextProt.name)
      hg19.humanWankerP2P.query (via knownToNextProt.name)
      hg19.humanWankerP2P.target (via knownToNextProt.name)
      hg19.keggPathway.kgID (via knownToNextProt.name)
      hg19.kgAlias.kgID (via knownToNextProt.name)
      hg19.kgColor.kgID (via knownToNextProt.name)
      hg19.kgProtAlias.kgID (via knownToNextProt.name)
      hg19.kgProtMap2.qName (via knownToNextProt.name)
      hg19.kgSpAlias.kgID (via knownToNextProt.name)
      hg19.kgTargetAli.qName (via knownToNextProt.name)
      hg19.kgTxInfo.name (via knownToNextProt.name)
      hg19.kgXref.kgID (via knownToNextProt.name)
      hg19.knownAttrs.kgID (via knownToNextProt.name)
      hg19.knownBlastTab.query (via knownToNextProt.name)
      hg19.knownBlastTab.target (via knownToNextProt.name)
      hg19.knownCanonToDecipher.name (via knownToNextProt.name)
      hg19.knownCanonical.transcript (via knownToNextProt.name)
      hg19.knownCds.name (via knownToNextProt.name)
      hg19.knownGene.name (via knownToNextProt.name)
      hg19.knownGeneMrna.name (via knownToNextProt.name)
      hg19.knownGenePep.name (via knownToNextProt.name)
      hg19.knownGeneTxMrna.name (via knownToNextProt.name)
      hg19.knownGeneTxPep.name (via knownToNextProt.name)
      hg19.knownIsoforms.transcript (via knownToNextProt.name)
      hg19.knownToAllenBrain.name (via knownToNextProt.name)
      hg19.knownToDecipher.name (via knownToNextProt.name)
      hg19.knownToEnsembl.name (via knownToNextProt.name)
      hg19.knownToGnfAtlas2.name (via knownToNextProt.name)
      hg19.knownToHInv.name (via knownToNextProt.name)
      hg19.knownToHprd.name (via knownToNextProt.name)
      hg19.knownToKeggEntrez.name (via knownToNextProt.name)
      hg19.knownToLocusLink.name (via knownToNextProt.name)
      hg19.knownToLynx.name (via knownToNextProt.name)
      hg19.knownToMrna.name (via knownToNextProt.name)
      hg19.knownToMrnaSingle.name (via knownToNextProt.name)
      hg19.knownToMupit.name (via knownToNextProt.name)
      hg19.knownToPfam.name (via knownToNextProt.name)
      hg19.knownToRefSeq.name (via knownToNextProt.name)
      hg19.knownToSuper.gene (via knownToNextProt.name)
      hg19.knownToTag.name (via knownToNextProt.name)
      hg19.knownToTreefam.name (via knownToNextProt.name)
      hg19.knownToU133.name (via knownToNextProt.name)
      hg19.knownToU133Plus2.name (via knownToNextProt.name)
      hg19.knownToU95.name (via knownToNextProt.name)
      hg19.knownToVisiGene.name (via knownToNextProt.name)
      hg19.knownToWikipedia.name (via knownToNextProt.name)
      hg19.mmBlastTab.query (via knownToNextProt.name)
      hg19.rnBlastTab.query (via knownToNextProt.name)
      hg19.scBlastTab.query (via knownToNextProt.name)
      hg19.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
uc001fas.4NX_A0A183
uc021ozj.1NX_A0A183
uc002vds.3NX_A0AUZ9
uc003ehv.4NX_A0AV02
uc003gvc.2NX_A0AV96
uc003gvg.1NX_A0AV96
uc011bys.1NX_A0AV96
uc003vur.4NX_A0AVF1
uc003vus.2NX_A0AVF1
uc003vut.2NX_A0AVF1

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