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

Connected Tables and Joining Fields
        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)
      rn3.dmBlastTab.query (via knownToSuper.gene)
      rn3.drBlastTab.query (via knownToSuper.gene)
      rn3.dupSpMrna.mrnaID (via knownToSuper.gene)
      rn3.gnfAtlas2Distance.query (via knownToSuper.gene)
      rn3.gnfAtlas2Distance.target (via knownToSuper.gene)
      rn3.hgBlastTab.query (via knownToSuper.gene)
      rn3.keggPathway.kgID (via knownToSuper.gene)
      rn3.kgAlias.kgID (via knownToSuper.gene)
      rn3.kgProtAlias.kgID (via knownToSuper.gene)
      rn3.kgSpAlias.kgID (via knownToSuper.gene)
      rn3.kgXref.kgID (via knownToSuper.gene)
      rn3.knownBlastTab.query (via knownToSuper.gene)
      rn3.knownBlastTab.target (via knownToSuper.gene)
      rn3.knownCanonical.transcript (via knownToSuper.gene)
      rn3.knownGene.name (via knownToSuper.gene)
      rn3.knownGeneLink.name (via knownToSuper.gene)
      rn3.knownGeneMrna.name (via knownToSuper.gene)
      rn3.knownGenePep.name (via knownToSuper.gene)
      rn3.knownIsoforms.transcript (via knownToSuper.gene)
      rn3.knownToEnsembl.name (via knownToSuper.gene)
      rn3.knownToGnfAtlas2.name (via knownToSuper.gene)
      rn3.knownToLocusLink.name (via knownToSuper.gene)
      rn3.knownToPfam.name (via knownToSuper.gene)
      rn3.knownToRefSeq.name (via knownToSuper.gene)
      rn3.scBlastTab.query (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
X164174645811470
X050804645811470
S822934645811470
BC0585024645811470
AY3903884645811420
AJ24566346458181713.5e-39
AF249673464582083560.00018
AF05152746458871360.0013
M63665464587420.0025
D850354654881401.5e-28

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