Schema for knownToSuper
  Database: hg16    Primary Table: knownToSuper    Row Count: 32,542   Data last updated: 2004-05-24
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene BC010913varchar(255) values Known gene ID
superfamily 46458int(11) range Superfamily ID
start 1int(11) range Start of superfamily domain in protein (0 based)
end 146int(11) range End (noninclusive) of superfamily domain
eVal 0float range E value of superfamily assignment

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToSuper.gene)
      hg16.dmBlastTab.query (via knownToSuper.gene)
      hg16.drBlastTab.query (via knownToSuper.gene)
      hg16.dupSpMrna.mrnaID (via knownToSuper.gene)
      hg16.foldUtr3.name (via knownToSuper.gene)
      hg16.foldUtr5.name (via knownToSuper.gene)
      hg16.gnfAtlas2Distance.query (via knownToSuper.gene)
      hg16.gnfAtlas2Distance.target (via knownToSuper.gene)
      hg16.gnfU95Distance.query (via knownToSuper.gene)
      hg16.gnfU95Distance.target (via knownToSuper.gene)
      hg16.hg17Kg.name (via knownToSuper.gene)
      hg16.keggPathway.kgID (via knownToSuper.gene)
      hg16.kgAlias.kgID (via knownToSuper.gene)
      hg16.kgProtAlias.kgID (via knownToSuper.gene)
      hg16.kgXref.kgID (via knownToSuper.gene)
      hg16.knownBlastTab.query (via knownToSuper.gene)
      hg16.knownBlastTab.target (via knownToSuper.gene)
      hg16.knownCanonical.transcript (via knownToSuper.gene)
      hg16.knownGene.name (via knownToSuper.gene)
      hg16.knownGeneLink.name (via knownToSuper.gene)
      hg16.knownGeneMrna.name (via knownToSuper.gene)
      hg16.knownGenePep.name (via knownToSuper.gene)
      hg16.knownIsoforms.transcript (via knownToSuper.gene)
      hg16.knownToEnsembl.name (via knownToSuper.gene)
      hg16.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg16.knownToHInv.name (via knownToSuper.gene)
      hg16.knownToLocusLink.name (via knownToSuper.gene)
      hg16.knownToPfam.name (via knownToSuper.gene)
      hg16.knownToRefSeq.name (via knownToSuper.gene)
      hg16.knownToU133.name (via knownToSuper.gene)
      hg16.knownToU95.name (via knownToSuper.gene)
      hg16.scBlastTab.query (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
BC0109134645811460
AF1104934645821470
BC0155374645811470
AF1818324645811470
BC0278924645801420
AY0344684645811290
V004934645811422.8026e-45
BC0059314645811422.8026e-45
AF2812584645801414.76441e-44
BC0566864645801421.80067e-42

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