Schema for ceBlastTab
  Database: mm9    Primary Table: ceBlastTab    Row Count: 4,955   Data last updated: 2011-04-19
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query uc008pgu.2varchar(255) values Name of sequence in this assembly (query)
target F10F2.1varchar(255) values Name of sequence in other assembly (target)
identity 47.94float range Percent identity
aliLength 1093int(10) unsigned range Length of alignment
mismatch 538int(10) unsigned range Number of mismatches
gapOpen 10int(10) unsigned range Number of gap openings
qStart 1859int(10) unsigned range Start in query (0 based)
qEnd 2936int(10) unsigned range End in query (non-inclusive)
tStart 1413int(10) unsigned range Start in target (0 based)
tEnd 2491int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 998double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
uc008pgu.2F10F2.147.9410935381018592936141324910998
uc008nys.2Y48G1A.530.78965619191496479382.0000000000000003e-120430
uc008phj.2C18B12.431.7224144468285702921e-21100
uc007yhj.1F57C12.5c44.5915437781626152827153401224
uc009eys.1R11D1.836.54104603010201000.0000000154.7
uc008nyr.2Y6B3A.1a43.941443688133401769230156601136
uc008pfz.2ZK507.633.5826517321504151974592e-40162
uc007wxz.1Y47D3A.420.596754191737608226842e-1890.9
uc007xpq.1F40F9.1a35280175335315222953e-37152
uc007xpp.1F40F9.240.43235135169304142442e-37152

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