class CreateTblastnJobReports < ActiveRecord::Migration
  def change
    create_table :quorum_tblastn_job_reports do |t|
      t.string :query
      t.integer :query_len
      t.string :hit_id
      t.string :hit_def
      t.string :hit_accession
      t.integer :hit_len
      t.integer :hsp_num
      t.string :hsp_group
      t.integer :bit_score
      t.integer :score
      t.string :evalue
      t.integer :query_from
      t.integer :query_to
      t.integer :hit_from
      t.integer :hit_to
      t.string :query_frame
      t.string :hit_frame
      t.integer :identity
      t.integer :positive
      t.integer :align_len
      t.text :qseq
      t.text :hseq
      t.text :midline
      t.boolean :results

      t.references :tblastn_job

      t.timestamps
    end
  end
end