   left1 INT,
   left2 INT,
   right1 INT,
-  right2 INT
+  right2 INT,
             
 )  ENGINE=InnoDB DEFAULT CHARSET=latin1;
 


CREATE TABLE QC_split_genes ( 
  genome_db_id int(10) NOT NULL,
  gene_member_stable_id varchar(128),
  seq_member_id int(10) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE short_orth_genes ( 
  genome_db_id int(10) NOT NULL,
  gene_member_stable_id varchar(128) NOT NULL,
  n_species INT NOT NULL,
  n_orth INT NOT NULL,
  avg_cov FLOAT NOT NULL,
            
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

