create index identical_idx1 on identical_seq(nref_id_1);

create index identical_idx2 on identical_seq(ordinal);

create index identical_idx3 on identical_seq(nref_id_2);

create index identical_idx4 on identical_seq(taxon_id_2);

create index neighboring_idx1 on neighboring_seq(nref_id_1);

create index neighboring_idx2 on neighboring_seq(ordinal);

create index neighboring_idx3 on neighboring_seq(nref_id_2);

create index neighboring_idx4 on neighboring_seq(taxon_id_2);

create index neighboring_idx5 on neighboring_seq(length_2);

create index neighboring_idx6 on neighboring_seq(score);

create index neighboring_idx7 on neighboring_seq(overlap_length);

create index neighboring_idx8 on neighboring_seq(start_1);

create index neighboring_idx9 on neighboring_seq(end_1);

create index neighboring_idx10 on neighboring_seq(start_2);

create index neighboring_idx11 on neighboring_seq(end_2);

create index organism_idx1 on organism(nref_id);

create index organism_idx2 on organism(ordinal);

create index organism_idx3 on organism(taxon_id);

create index organism_idx4 on organism(name);

create index protein_idx2 on protein(p_name);

create index protein_idx3 on protein(last_updated);

create index protein_idx5 on protein(seq_length);

create index source_idx1 on source(nref_id);

create index source_idx3 on source(p_id);

create index source_idx4 on source(p_name);

create index source_idx5 on source(source);

create index source_idx6 on source(taxon_id);

create index source_idx7 on source(accession);

create index taxonomy_idx1 on taxonomy(nref_id);

create index taxonomy_idx2 on taxonomy(taxon_id);

create index taxonomy_idx3 on taxonomy(species_name);

create index taxonomy_idx4 on taxonomy(common_name);

create index taxonomy_idx5 on taxonomy(lineage);