\set log_error_verbosity terse
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (1,1, 'taxonomy', 'domain', 'domain', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (2,2, 'taxonomy', 'kingdom', 'kingdom', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (3,3, 'taxonomy', 'super phylum', 'super_phylum', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (4,4, 'taxonomy', 'phylum', 'phylum', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (5,5, 'taxonomy', 'sub phylum', 'sub_phylum', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (6,6, 'taxonomy', 'infra phylum', 'infra_phylum', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (7,7, 'taxonomy', 'super cohort - botany', 'super_cohort_botany', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (8,8, 'taxonomy', 'cohort - botany', 'cohort_botany', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (9,9, 'taxonomy', 'sub cohort - botany', 'sub_cohort_botany', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (10,10, 'taxonomy', 'infra cohort - botany', 'infra_cohort_botany', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (11,11, 'taxonomy', 'super class', 'super_class', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (12,12, 'taxonomy', 'class', 'class', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (13,13, 'taxonomy', 'sub class', 'sub_class', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (14,14, 'taxonomy', 'infra class', 'infra_class', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (15,15, 'taxonomy', 'super division', 'super_division', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (16,16, 'taxonomy', 'division', 'division', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (17,17, 'taxonomy', 'sub division', 'sub_division', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (18,18, 'taxonomy', 'infra division', 'infra_division', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (19,19, 'taxonomy', 'super legion', 'super_legion', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (20,20, 'taxonomy', 'legion', 'legion', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (21,21, 'taxonomy', 'sub legion', 'sub_legion', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (22,22, 'taxonomy', 'infra legion', 'infra_legion', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (23,23, 'taxonomy', 'super cohort - zoology', 'super_cohort_zoology', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (24,24, 'taxonomy', 'cohort - zoology', 'cohort_zoology', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (25,25, 'taxonomy', 'sub cohort - zoology', 'sub_cohort_zoology', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (26,26, 'taxonomy', 'infra cohort - zoology', 'infra_cohort_zoology', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (27,27, 'taxonomy', 'super order', 'super_order', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (28,28, 'taxonomy', 'order', 'order', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (29,29, 'taxonomy', 'sub order', 'sub_order', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (30,30, 'taxonomy', 'infra order', 'infra_order', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (31,31, 'taxonomy', 'section - zoology', 'section_zoology', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (32,32, 'taxonomy', 'sub section - zoology', 'sub_section_zoology', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (33,33, 'taxonomy', 'super family', 'super_family', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (34,34, 'taxonomy', 'family', 'family', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (35,35, 'taxonomy', 'sub family', 'sub_family', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (36,36, 'taxonomy', 'infra family', 'infra_family', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (37,37, 'taxonomy', 'super tribe', 'super_tribe', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (38,38, 'taxonomy', 'tribe', 'tribe', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (39,39, 'taxonomy', 'sub tribe', 'sub_tribe', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (40,40, 'taxonomy', 'infra tribe', 'infra_tribe', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (41,41, 'taxonomy', 'genus', 'genus', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (42,42, 'taxonomy', 'sub genus', 'sub_genus', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (43,43, 'taxonomy', 'section - botany', 'section_botany', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (44,44, 'taxonomy', 'sub section - botany', 'sub_section_botany', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (45,45, 'taxonomy', 'serie', 'serie', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (46,46, 'taxonomy', 'sub serie', 'sub_serie', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (47,47, 'taxonomy', 'super species', 'super_species', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (48,48, 'taxonomy', 'species', 'species', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (49,49, 'taxonomy', 'sub species', 'sub_species', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (50,50, 'taxonomy', 'variety', 'variety', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (51,51, 'taxonomy', 'sub variety', 'sub_variety', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (52,52, 'taxonomy', 'form', 'form', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (53,53, 'taxonomy', 'sub form', 'sub_form', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (54,54, 'taxonomy', 'abberans', 'abberans', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (55,55, 'chronostratigraphy', 'eon', 'eon', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (56,56, 'chronostratigraphy', 'era', 'era', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (57,57, 'chronostratigraphy', 'sub era', 'sub_era', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (58,58, 'chronostratigraphy', 'system', 'system', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (59,59, 'chronostratigraphy', 'serie', 'serie', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (60,60, 'chronostratigraphy', 'stage', 'stage', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (61,61, 'chronostratigraphy', 'sub stage', 'sub_stage', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (62,62, 'chronostratigraphy', 'sub level 1', 'sub_level_1', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (63,63, 'chronostratigraphy', 'sub level 2', 'sub_level_2', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (64,64, 'lithostratigraphy', 'group', 'group', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (65,65, 'lithostratigraphy', 'formation', 'formation', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (66,66, 'lithostratigraphy', 'member', 'member', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (67,67, 'lithostratigraphy', 'layer', 'layer', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (68,68, 'lithostratigraphy', 'sub level 1', 'sub_level_1', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (69,69, 'lithostratigraphy', 'sub level 2', 'sub_level_2', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (70,70, 'mineralogy', 'class', 'unit_class', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (71,71, 'mineralogy', 'sub_class', 'unit_sub_class', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (72,72, 'mineralogy', 'series', 'unit_series', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (73,73, 'mineralogy', 'variety', 'unit_variety', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (75,75, 'lithology', 'main group', 'unit_main_group', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (76,76, 'lithology', 'group', 'unit_group', false);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (77,77, 'lithology', 'sub group', 'unit_sub_group', true);
insert into catalogue_levels (id, level_order, level_type, level_name, level_sys_name, optional_level) values (78,78, 'lithology', 'rock', 'unit_rock', false);
insert into possible_upper_levels (level_ref, level_upper_ref) values (1, null);
insert into possible_upper_levels (level_ref, level_upper_ref) values (55, null);
insert into possible_upper_levels (level_ref, level_upper_ref) values (64, null);
insert into possible_upper_levels (level_ref, level_upper_ref) values (70, null);
insert into possible_upper_levels (level_ref, level_upper_ref) values (75, null);
insert into possible_upper_levels (level_ref, level_upper_ref) values (65, null);
insert into possible_upper_levels (level_ref, level_upper_ref) values (2, 1);
insert into possible_upper_levels (level_ref, level_upper_ref) values (3, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (4, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (4, 3);
insert into possible_upper_levels (level_ref, level_upper_ref) values (5, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (6, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (7, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (7, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (7, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (7, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (8, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (8, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (8, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (8, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (8, 7);
insert into possible_upper_levels (level_ref, level_upper_ref) values (9, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (10, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (11, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (12, 11);
insert into possible_upper_levels (level_ref, level_upper_ref) values (13, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (14, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (15, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (16, 15);
insert into possible_upper_levels (level_ref, level_upper_ref) values (17, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (18, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (19, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (20, 19);
insert into possible_upper_levels (level_ref, level_upper_ref) values (21, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (22, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (23, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (24, 23);
insert into possible_upper_levels (level_ref, level_upper_ref) values (25, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (26, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (27, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (28, 27);
insert into possible_upper_levels (level_ref, level_upper_ref) values (29, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (30, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (31, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (32, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (33, 32);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 32);
insert into possible_upper_levels (level_ref, level_upper_ref) values (34, 33);
insert into possible_upper_levels (level_ref, level_upper_ref) values (35, 34);
insert into possible_upper_levels (level_ref, level_upper_ref) values (36, 34);
insert into possible_upper_levels (level_ref, level_upper_ref) values (36, 35);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 32);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 33);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 34);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 35);
insert into possible_upper_levels (level_ref, level_upper_ref) values (37, 36);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 32);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 33);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 34);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 35);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 36);
insert into possible_upper_levels (level_ref, level_upper_ref) values (38, 37);
insert into possible_upper_levels (level_ref, level_upper_ref) values (39, 38);
insert into possible_upper_levels (level_ref, level_upper_ref) values (40, 39);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 2);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 8);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 9);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 10);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 16);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 17);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 18);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 20);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 21);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 22);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 24);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 25);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 26);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 32);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 33);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 34);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 35);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 36);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 38);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 39);
insert into possible_upper_levels (level_ref, level_upper_ref) values (41, 40);
insert into possible_upper_levels (level_ref, level_upper_ref) values (42, 41);
insert into possible_upper_levels (level_ref, level_upper_ref) values (43, 41);
insert into possible_upper_levels (level_ref, level_upper_ref) values (43, 42);
insert into possible_upper_levels (level_ref, level_upper_ref) values (44, 43);
insert into possible_upper_levels (level_ref, level_upper_ref) values (45, 41);
insert into possible_upper_levels (level_ref, level_upper_ref) values (45, 42);
insert into possible_upper_levels (level_ref, level_upper_ref) values (45, 43);
insert into possible_upper_levels (level_ref, level_upper_ref) values (45, 44);
insert into possible_upper_levels (level_ref, level_upper_ref) values (46, 45);
insert into possible_upper_levels (level_ref, level_upper_ref) values (47, 41);
insert into possible_upper_levels (level_ref, level_upper_ref) values (47, 42);
insert into possible_upper_levels (level_ref, level_upper_ref) values (47, 43);
insert into possible_upper_levels (level_ref, level_upper_ref) values (47, 44);
insert into possible_upper_levels (level_ref, level_upper_ref) values (47, 45);
insert into possible_upper_levels (level_ref, level_upper_ref) values (47, 46);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 4);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 5);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 6);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 12);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 13);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 14);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 28);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 29);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 30);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 31);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 32);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 33);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 34);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 35);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 36);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 38);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 39);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 40);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 41);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 42);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 43);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 44);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 45);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 46);
insert into possible_upper_levels (level_ref, level_upper_ref) values (48, 47);
insert into possible_upper_levels (level_ref, level_upper_ref) values (49, 48);
insert into possible_upper_levels (level_ref, level_upper_ref) values (50, 41);
insert into possible_upper_levels (level_ref, level_upper_ref) values (50, 48);
insert into possible_upper_levels (level_ref, level_upper_ref) values (50, 49);
insert into possible_upper_levels (level_ref, level_upper_ref) values (51, 50);
insert into possible_upper_levels (level_ref, level_upper_ref) values (52, 48);
insert into possible_upper_levels (level_ref, level_upper_ref) values (52, 49);
insert into possible_upper_levels (level_ref, level_upper_ref) values (52, 50);
insert into possible_upper_levels (level_ref, level_upper_ref) values (52, 51);
insert into possible_upper_levels (level_ref, level_upper_ref) values (53, 52);
insert into possible_upper_levels (level_ref, level_upper_ref) values (54, 48);
insert into possible_upper_levels (level_ref, level_upper_ref) values (54, 49);
insert into possible_upper_levels (level_ref, level_upper_ref) values (54, 50);
insert into possible_upper_levels (level_ref, level_upper_ref) values (54, 51);
insert into possible_upper_levels (level_ref, level_upper_ref) values (54, 52);
insert into possible_upper_levels (level_ref, level_upper_ref) values (54, 53);
insert into possible_upper_levels (level_ref, level_upper_ref) values (56, 55);
insert into possible_upper_levels (level_ref, level_upper_ref) values (57, 56);
insert into possible_upper_levels (level_ref, level_upper_ref) values (58, 57);
insert into possible_upper_levels (level_ref, level_upper_ref) values (58, 56);
insert into possible_upper_levels (level_ref, level_upper_ref) values (59, 58);
insert into possible_upper_levels (level_ref, level_upper_ref) values (60, 59);
insert into possible_upper_levels (level_ref, level_upper_ref) values (61, 60);
insert into possible_upper_levels (level_ref, level_upper_ref) values (62, 61);
insert into possible_upper_levels (level_ref, level_upper_ref) values (62, 60);
insert into possible_upper_levels (level_ref, level_upper_ref) values (63, 62);
insert into possible_upper_levels (level_ref, level_upper_ref) values (63, 61);
insert into possible_upper_levels (level_ref, level_upper_ref) values (63, 60);
insert into possible_upper_levels (level_ref, level_upper_ref) values (65, 64);
insert into possible_upper_levels (level_ref, level_upper_ref) values (66, 65);
insert into possible_upper_levels (level_ref, level_upper_ref) values (67, 66);
insert into possible_upper_levels (level_ref, level_upper_ref) values (68, 67);
insert into possible_upper_levels (level_ref, level_upper_ref) values (69, 68);
insert into possible_upper_levels (level_ref, level_upper_ref) values (69, 67);
insert into possible_upper_levels (level_ref, level_upper_ref) values (71, 70);
insert into possible_upper_levels (level_ref, level_upper_ref) values (72, 71);
insert into possible_upper_levels (level_ref, level_upper_ref) values (73, 72);
insert into possible_upper_levels (level_ref, level_upper_ref) values (76, 75);
insert into possible_upper_levels (level_ref, level_upper_ref) values (77, 76);
insert into possible_upper_levels (level_ref, level_upper_ref) values (78, 76);
insert into possible_upper_levels (level_ref, level_upper_ref) values (78, 77);
INSERT INTO taxonomy (name, name_indexed, level_ref, status) VALUES ('Eucaryota', 'eucaryota', 1, 'valid');
INSERT INTO taxonomy (name, name_indexed, level_ref, status) VALUES ('Bacteria', 'bacteria', 1, 'valid');
INSERT INTO taxonomy (name, name_indexed, level_ref, status) VALUES ('Archaea', 'archaea', 1, 'valid');
INSERT INTO taxonomy (name, name_indexed, level_ref, status) VALUES ('Virus','virus', 1, 'valid');
INSERT INTO classification_keywords (referenced_relation, record_id, keyword_type, keyword, keyword_indexed) (select 'taxonomy', id, 'GenusOrMonomial', 'Virus', 'virus' from taxonomy where name = 'Virus');
INSERT INTO classification_keywords (referenced_relation, record_id, keyword_type, keyword, keyword_indexed) (select 'taxonomy', id, 'GenusOrMonomial', 'Bacteria', 'bacteria' from taxonomy where name = 'Bacteria');
INSERT INTO classification_keywords (referenced_relation, record_id, keyword_type, keyword, keyword_indexed) (select 'taxonomy', id, 'GenusOrMonomial', 'Eucaryota', 'Eucaryota' from taxonomy where name = 'Eucaryota');
INSERT INTO classification_keywords (referenced_relation, record_id, keyword_type, keyword, keyword_indexed) (select 'taxonomy', id, 'GenusOrMonomial', 'Archaea', 'archaea' from taxonomy where name = 'Archaea');
