create table keyword (
  revision text,
  chromosome text,
  name text collate nocase,
  start integer,
  end integer
);

.separator |

.import 'target/refseq_entry.dat' keyword

create index keyword_index on keyword(name);
create index entry_index on keyword(revision, chromosome, name);





