Schema for knownToSuper
  Database: hg18    Primary Table: knownToSuper    Row Count: 76,787   Data last updated: 2009-03-03
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene uc009vjh.1varchar(255) values Known gene ID
superfamily 81321int(11) range Superfamily ID
start 0int(11) range Start of superfamily domain in protein (0 based)
end 245int(11) range End (noninclusive) of superfamily domain
eVal 0float range E value of superfamily assignment

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToSuper.gene)
      hg18.ccdsKgMap.geneId (via knownToSuper.gene)
      hg18.ceBlastTab.query (via knownToSuper.gene)
      hg18.dmBlastTab.query (via knownToSuper.gene)
      hg18.drBlastTab.query (via knownToSuper.gene)
      hg18.foldUtr3.name (via knownToSuper.gene)
      hg18.foldUtr5.name (via knownToSuper.gene)
      hg18.gnfAtlas2Distance.query (via knownToSuper.gene)
      hg18.gnfAtlas2Distance.target (via knownToSuper.gene)
      hg18.gnfU95Distance.query (via knownToSuper.gene)
      hg18.gnfU95Distance.target (via knownToSuper.gene)
      hg18.humanHprdP2P.query (via knownToSuper.gene)
      hg18.humanHprdP2P.target (via knownToSuper.gene)
      hg18.humanVidalP2P.query (via knownToSuper.gene)
      hg18.humanVidalP2P.target (via knownToSuper.gene)
      hg18.humanWankerP2P.query (via knownToSuper.gene)
      hg18.humanWankerP2P.target (via knownToSuper.gene)
      hg18.keggPathway.kgID (via knownToSuper.gene)
      hg18.kgAlias.kgID (via knownToSuper.gene)
      hg18.kgColor.kgID (via knownToSuper.gene)
      hg18.kgProtAlias.kgID (via knownToSuper.gene)
      hg18.kgProtMap2.qName (via knownToSuper.gene)
      hg18.kgSpAlias.kgID (via knownToSuper.gene)
      hg18.kgTargetAli.qName (via knownToSuper.gene)
      hg18.kgTxInfo.name (via knownToSuper.gene)
      hg18.kgXref.kgID (via knownToSuper.gene)
      hg18.knownBlastTab.query (via knownToSuper.gene)
      hg18.knownBlastTab.target (via knownToSuper.gene)
      hg18.knownCanonical.protein (via knownToSuper.gene)
      hg18.knownCanonical.transcript (via knownToSuper.gene)
      hg18.knownGene.name (via knownToSuper.gene)
      hg18.knownGeneMrna.name (via knownToSuper.gene)
      hg18.knownGenePep.name (via knownToSuper.gene)
      hg18.knownIsoforms.transcript (via knownToSuper.gene)
      hg18.knownToAllenBrain.name (via knownToSuper.gene)
      hg18.knownToEnsembl.name (via knownToSuper.gene)
      hg18.knownToGnf1h.name (via knownToSuper.gene)
      hg18.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg18.knownToHInv.name (via knownToSuper.gene)
      hg18.knownToHprd.name (via knownToSuper.gene)
      hg18.knownToKeggEntrez.name (via knownToSuper.gene)
      hg18.knownToLocusLink.name (via knownToSuper.gene)
      hg18.knownToMupit.name (via knownToSuper.gene)
      hg18.knownToPfam.name (via knownToSuper.gene)
      hg18.knownToRefSeq.name (via knownToSuper.gene)
      hg18.knownToTreefam.name (via knownToSuper.gene)
      hg18.knownToU133.name (via knownToSuper.gene)
      hg18.knownToU133Plus2.name (via knownToSuper.gene)
      hg18.knownToU95.name (via knownToSuper.gene)
      hg18.knownToVisiGene.name (via knownToSuper.gene)
      hg18.mmBlastTab.query (via knownToSuper.gene)
      hg18.rnBlastTab.query (via knownToSuper.gene)
      hg18.scBlastTab.query (via knownToSuper.gene)
      hg18.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
uc009vjh.18132102450
uc001aal.18132102970
uc001aaw.18132103040
uc001abd.18132103040
uc001abw.1477695136192.7e-19
uc001abx.1477693764822.7e-19
uc001aca.1509523826030.0000061
uc001aca.1638253406060.00000019
uc001aca.11018983166050.0000000000084
uc001aca.1509653066040

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