Schema for ceBlastTab
  Database: sacCer2    Primary Table: ceBlastTab    Row Count: 1,942   Data last updated: 2010-08-19
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query YMR314Wvarchar(255) values Name of sequence in this assembly (query)
target CD4.6varchar(255) values Name of sequence in other assembly (target)
identity 49.36float range Percent identity
aliLength 235int(10) unsigned range Length of alignment
mismatch 116int(10) unsigned range Number of mismatches
gapOpen 2int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 234int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 233int(10) unsigned range End in target (non-inclusive)
eValue 8e-62double range Expectation value
bitScore 233double range Bit score

Connected Tables and Joining Fields
        sacCer2.choExpDistance.query (via ceBlastTab.query)
      sacCer2.choExpDistance.target (via ceBlastTab.query)
      sacCer2.dmBlastTab.query (via ceBlastTab.query)
      sacCer2.drBlastTab.query (via ceBlastTab.query)
      sacCer2.esRegGeneToModule.gene (via ceBlastTab.query)
      sacCer2.esRegGeneToMotif.gene (via ceBlastTab.query)
      sacCer2.esRegUpstreamRegion.name (via ceBlastTab.query)
      sacCer2.hgBlastTab.query (via ceBlastTab.query)
      sacCer2.mmBlastTab.query (via ceBlastTab.query)
      sacCer2.rnBlastTab.query (via ceBlastTab.query)
      sacCer2.sgdAbundance.name (via ceBlastTab.query)
      sacCer2.sgdBlastTab.query (via ceBlastTab.query)
      sacCer2.sgdBlastTab.target (via ceBlastTab.query)
      sacCer2.sgdCanonical.transcript (via ceBlastTab.query)
      sacCer2.sgdDescription.name (via ceBlastTab.query)
      sacCer2.sgdGene.name (via ceBlastTab.query)
      sacCer2.sgdIsoforms.transcript (via ceBlastTab.query)
      sacCer2.sgdLocalization.name (via ceBlastTab.query)
      sacCer2.sgdPep.name (via ceBlastTab.query)
      sacCer2.sgdToName.name (via ceBlastTab.query)
      sacCer2.sgdToPfam.name (via ceBlastTab.query)
      sacCer2.sgdToSwissProt.name (via ceBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR314WCD4.649.362351162023402338e-62233
YMR297WY16B4A.228.9845225815126526156320045e-37152
YMR309CT23D8.427.61641396151748002328201e-59228
YHR072W-AC25A1.656.9582500580580.000000000000170.9
YMR308CC53D5.626.091008695209310657510693e-76283
YMR304WH19N07.2c39.65454223111085531085201e-85315
YMR296CC23H3.4b34.5148125197254644287e-72268
YMR293CY41D4A.633.746027510645834412e-48190
YMR288WT08A11.253.35836384313696848513190845
YMR301CY74C10AR.345.83648333837674296703e-154542

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