Schema for ceBlastTab
  Database: mm8    Primary Table: ceBlastTab    Row Count: 21,370   Data last updated: 2006-03-13
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB001539varchar(255) values Name of sequence in this assembly (query)
target Y54H5A.1varchar(255) values Name of sequence in other assembly (target)
identity 44.62float range Percent identity
aliLength 437int(10) unsigned range Length of alignment
mismatch 222int(10) unsigned range Number of mismatches
gapOpen 6int(10) unsigned range Number of gap openings
qStart 19int(10) unsigned range Start in query (0 based)
qEnd 446int(10) unsigned range End in query (non-inclusive)
tStart 26int(10) unsigned range Start in target (0 based)
tEnd 453int(10) unsigned range End in target (non-inclusive)
eValue 1e-104double range Expectation value
bitScore 376double 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)
      mm8.affyGnfU74ADistance.query (via ceBlastTab.query)
      mm8.affyGnfU74ADistance.target (via ceBlastTab.query)
      mm8.affyGnfU74BDistance.query (via ceBlastTab.query)
      mm8.affyGnfU74BDistance.target (via ceBlastTab.query)
      mm8.affyGnfU74CDistance.query (via ceBlastTab.query)
      mm8.affyGnfU74CDistance.target (via ceBlastTab.query)
      mm8.ccdsKgMap.geneId (via ceBlastTab.query)
      mm8.dmBlastTab.query (via ceBlastTab.query)
      mm8.drBlastTab.query (via ceBlastTab.query)
      mm8.dupSpMrna.mrnaID (via ceBlastTab.query)
      mm8.foldUtr3.name (via ceBlastTab.query)
      mm8.foldUtr5.name (via ceBlastTab.query)
      mm8.gnfAtlas2Distance.query (via ceBlastTab.query)
      mm8.gnfAtlas2Distance.target (via ceBlastTab.query)
      mm8.hgBlastTab.query (via ceBlastTab.query)
      mm8.keggPathway.kgID (via ceBlastTab.query)
      mm8.kgAlias.kgID (via ceBlastTab.query)
      mm8.kgProtAlias.kgID (via ceBlastTab.query)
      mm8.kgSpAlias.kgID (via ceBlastTab.query)
      mm8.kgTargetAli.qName (via ceBlastTab.query)
      mm8.kgXref.kgID (via ceBlastTab.query)
      mm8.knownBlastTab.query (via ceBlastTab.query)
      mm8.knownBlastTab.target (via ceBlastTab.query)
      mm8.knownCanonical.transcript (via ceBlastTab.query)
      mm8.knownGene.name (via ceBlastTab.query)
      mm8.knownGeneMrna.name (via ceBlastTab.query)
      mm8.knownGenePep.name (via ceBlastTab.query)
      mm8.knownIsoforms.transcript (via ceBlastTab.query)
      mm8.knownToAllenBrain.name (via ceBlastTab.query)
      mm8.knownToEnsembl.name (via ceBlastTab.query)
      mm8.knownToGnfAtlas2.name (via ceBlastTab.query)
      mm8.knownToKeggEntrez.name (via ceBlastTab.query)
      mm8.knownToLocusLink.name (via ceBlastTab.query)
      mm8.knownToPfam.name (via ceBlastTab.query)
      mm8.knownToRefSeq.name (via ceBlastTab.query)
      mm8.knownToSuper.gene (via ceBlastTab.query)
      mm8.knownToVisiGene.name (via ceBlastTab.query)
      mm8.rnBlastTab.query (via ceBlastTab.query)
      mm8.scBlastTab.query (via ceBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
AB001539Y54H5A.144.62437222619446264531e-104376
AB001750F01F1.429.93112052531839353363e-33140
AB001926C30C11.438.16228123142325667769e-39156
AB003147F07A5.721.833712301369387754390.0000000556.2
AB003503H19N07.153.65576211102459345311e-160563
AB005654K08A8.1a52.563121375108416403451e-90330
AB005662ZK1098.10b46.993661526036181911483e-94341
AB006034ZK177.525.7131521371915041904868.000000000000001e-24108
AB006329T22B7.1d54.731485523905351703097e-36148
AB006330T22B7.1d60.281415311472851372781e-37153

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