Schema for mmBlastTab
  Database: sacCer2    Primary Table: mmBlastTab    Row Count: 2,244   Data last updated: 2011-04-19
Format description: Blast alignments of Mouse genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query YMR315Wvarchar(255) values Name of sequence in this assembly (query)
target uc009gvj.1varchar(255) values Name of sequence in other assembly (target)
identity 27.16float range Percent identity
aliLength 243int(10) unsigned range Length of alignment
mismatch 148int(10) unsigned range Number of mismatches
gapOpen 11int(10) unsigned range Number of gap openings
qStart 3int(10) unsigned range Start in query (0 based)
qEnd 235int(10) unsigned range End in query (non-inclusive)
tStart 2int(10) unsigned range Start in target (0 based)
tEnd 227int(10) unsigned range End in target (non-inclusive)
eValue 0.0000006double range Expectation value
bitScore 52.8double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR315Wuc009gvj.127.1624314811323522270.000000652.8
YMR314Wuc009jhy.153.192351072023402331e-64243
YMR311Cuc007yxe.126.8514995456201111500.0000445.8
YMR309Cuc009jrw.130.62552345122567943298575e-58223
YHR072W-Auc008lor.160.34582300580580.0000000000000772.8
YMR308Cuc007uzz.129.481038677182010281910322.0000000000000001e-106385
YMR304Wuc007ycw.129.811154611293811726810434e-123440
YMR296Cuc007qnk.134.39471258783551474702e-72270
YMR293Cuc007ezn.134.87433247943457674842e-57220
YMR288Wuc007azx.150.9891843247197138613040879

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