Schema for sgdBlastTab
  Database: sacCer3    Primary Table: sgdBlastTab    Row Count: 51,297   Data last updated: 2011-10-06
Format description: Blast alignments of Mouse genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query Q0010varchar(255) values Name of sequence in this assembly (query)
target Q0010varchar(255) values Name of sequence in other assembly (target)
identity 100float range Percent identity
aliLength 128int(10) unsigned range Length of alignment
mismatch 0int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 128int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 128int(10) unsigned range End in target (non-inclusive)
eValue 7e-55double range Expectation value
bitScore 206double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
Q0010Q001010012800012801287e-55206
Q0017Q001710053000530533e-27114
Q0032Q00321008500119611964e-34137
Q0045Q0045100534000534053401020
Q0045Q007010032400032403244e-180625
Q0045Q006596.7924980024902495e-130459
Q0045Q006010081000810813e-40161
Q0045Q005510068000680682e-32135
Q0045Q005010056000560569e-26113
Q0050Q0050100834000834083401664

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