-- drop table if exists new_table;

create table new_table 
as 
        (
                select sequence_start,sequence_stop 
                from intergenic_and_experimental_results 
                where reading_direction = 'f'
        )
        union all 
        (
                select sequence_start,sequence_stop 
                from intergenic_and_experimental_results 
                where reading_direction = 'r' 
        )
        order by reading_direction, sequence_start
;