Schema for knownToSuper
  Database: hg38    Primary Table: knownToSuper    Row Count: 353,888   Data last updated: 2023-08-22
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENST00000000233.10varchar(255) values Known gene ID
superfamily 52540int(11) range Superfamily ID
start 5int(11) range Start of superfamily domain in protein (0 based)
end 178int(11) range End (noninclusive) of superfamily domain
eVal 0float range E value of superfamily assignment

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

Sample Rows
 
genesuperfamilystartendeVal
ENST00000000233.105254051780
ENST00000000412.850911291823.8e-37
ENST00000000442.11485081254220
ENST00000000442.1157716751622.3e-33
ENST00000001008.6819012483900.000000000000012
ENST00000001008.6484392744150.000000000057
ENST00000001008.6484522334162.4e-36
ENST00000001008.654534222680
ENST00000001146.748264444900
ENST00000002125.953335414100

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