Schema for knownToGnfAtlas2
  Database: hg38    Primary Table: knownToGnfAtlas2    Row Count: 144,307   Data last updated: 2022-05-15
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name ENST00000361899.2varchar(255) values primary ID
value gnf1h00654_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000361899.2gnf1h00654_at
ENST00000615646.4207752_x_at
ENST00000625471.2207752_x_at
ENST00000612920.2207752_x_at
ENST00000620127.3207752_x_at
ENST00000628976.2207752_x_at
ENST00000614336.4212854_x_at
ENST00000612640.4212854_x_at
ENST00000612198.3204166_at
ENST00000631948.1204166_at

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