Schema for knownToSuper
  Database: hg19    Primary Table: knownToSuper    Row Count: 334,387   Data last updated: 2024-08-23
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENST00000000233.10_4varchar(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
        hg19.bioCycPathway.kgID (via knownToSuper.gene)
      hg19.ceBlastTab.query (via knownToSuper.gene)
      hg19.dmBlastTab.query (via knownToSuper.gene)
      hg19.drBlastTab.query (via knownToSuper.gene)
      hg19.foldUtr3.name (via knownToSuper.gene)
      hg19.foldUtr5.name (via knownToSuper.gene)
      hg19.gnfAtlas2Distance.query (via knownToSuper.gene)
      hg19.gnfAtlas2Distance.target (via knownToSuper.gene)
      hg19.gnfU95Distance.query (via knownToSuper.gene)
      hg19.gnfU95Distance.target (via knownToSuper.gene)
      hg19.humanHprdP2P.query (via knownToSuper.gene)
      hg19.humanHprdP2P.target (via knownToSuper.gene)
      hg19.humanVidalP2P.query (via knownToSuper.gene)
      hg19.humanVidalP2P.target (via knownToSuper.gene)
      hg19.humanWankerP2P.query (via knownToSuper.gene)
      hg19.humanWankerP2P.target (via knownToSuper.gene)
      hg19.keggPathway.kgID (via knownToSuper.gene)
      hg19.kgAlias.kgID (via knownToSuper.gene)
      hg19.kgColor.kgID (via knownToSuper.gene)
      hg19.kgProtAlias.kgID (via knownToSuper.gene)
      hg19.kgProtMap2.qName (via knownToSuper.gene)
      hg19.kgSpAlias.kgID (via knownToSuper.gene)
      hg19.kgTargetAli.qName (via knownToSuper.gene)
      hg19.kgTxInfo.name (via knownToSuper.gene)
      hg19.kgXref.kgID (via knownToSuper.gene)
      hg19.knownAttrs.kgID (via knownToSuper.gene)
      hg19.knownBlastTab.query (via knownToSuper.gene)
      hg19.knownBlastTab.target (via knownToSuper.gene)
      hg19.knownCanonToDecipher.name (via knownToSuper.gene)
      hg19.knownCanonical.transcript (via knownToSuper.gene)
      hg19.knownCds.name (via knownToSuper.gene)
      hg19.knownGene.name (via knownToSuper.gene)
      hg19.knownGeneMrna.name (via knownToSuper.gene)
      hg19.knownGenePep.name (via knownToSuper.gene)
      hg19.knownGeneTxMrna.name (via knownToSuper.gene)
      hg19.knownGeneTxPep.name (via knownToSuper.gene)
      hg19.knownIsoforms.transcript (via knownToSuper.gene)
      hg19.knownToAllenBrain.name (via knownToSuper.gene)
      hg19.knownToDecipher.name (via knownToSuper.gene)
      hg19.knownToEnsembl.name (via knownToSuper.gene)
      hg19.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg19.knownToHInv.name (via knownToSuper.gene)
      hg19.knownToHprd.name (via knownToSuper.gene)
      hg19.knownToKeggEntrez.name (via knownToSuper.gene)
      hg19.knownToLocusLink.name (via knownToSuper.gene)
      hg19.knownToLynx.name (via knownToSuper.gene)
      hg19.knownToMrna.name (via knownToSuper.gene)
      hg19.knownToMrnaSingle.name (via knownToSuper.gene)
      hg19.knownToMupit.name (via knownToSuper.gene)
      hg19.knownToNextProt.name (via knownToSuper.gene)
      hg19.knownToPfam.name (via knownToSuper.gene)
      hg19.knownToRefSeq.name (via knownToSuper.gene)
      hg19.knownToTag.name (via knownToSuper.gene)
      hg19.knownToTreefam.name (via knownToSuper.gene)
      hg19.knownToU133.name (via knownToSuper.gene)
      hg19.knownToU133Plus2.name (via knownToSuper.gene)
      hg19.knownToU95.name (via knownToSuper.gene)
      hg19.knownToVisiGene.name (via knownToSuper.gene)
      hg19.knownToWikipedia.name (via knownToSuper.gene)
      hg19.mmBlastTab.query (via knownToSuper.gene)
      hg19.rnBlastTab.query (via knownToSuper.gene)
      hg19.scBlastTab.query (via knownToSuper.gene)
      hg19.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.10_45254051780
ENST00000000412.350911291823e-37
ENST00000000442.11_8485081254220
ENST00000000442.11_857716751622.1e-33
ENST00000001008.6_4819012483900.000000000000013
ENST00000001008.6_4484392744150.00000000006
ENST00000001008.6_4484522334162.5e-36
ENST00000001008.6_454534222680
ENST00000001146.7_748264444900
ENST00000002125.9_453335414100

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