The Halorubrum sp. BOL3-1 Genome

SELECT id, gene_id, name, start, stop, replicon, orientation, (SELECT CONCAT(LOWER(SUBSTRING(primary_sequence, LEAST(start, stop)-20, 20)), '...', LOWER(SUBSTRING(primary_sequence, GREATEST(start, stop)+1, 20))) FROM replicon_sequences WHERE replicon_name = replicon AND organism = 'bol31') AS sequence FROM bol31_annotation_for_web WHERE gene_id IN (17370) ORDER BY gene_id+0 ASC