SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=2436 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2436SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2303SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2436 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='harrisoni' OR junior_species='harrisonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='harrisoni' OR species='harrisonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='harrisoni' OR species='harrisonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='harrisoni' OR junior_species='harrisonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aedes' AND (species='harrisoni' OR species='harrisonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='metallicus' OR junior_species='metallicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='metallicus' OR species='metallicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='metallicus' OR species='metallicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='metallicus' OR junior_species='metallicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aedes' AND (species='metallicus' OR species='metallicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aedes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='azaniae' OR junior_species='azaniae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='azaniae' OR species='azaniae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='azaniae' OR species='azaniae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='azaniae' OR junior_species='azaniae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='azaniae' OR species='azaniae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='buxtoni' OR junior_species='buxtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='buxtoni' OR species='buxtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='buxtoni' OR species='buxtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='buxtoni' OR junior_species='buxtonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='buxtoni' OR species='buxtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='dancalicus' OR junior_species='dancalicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='dancalicus' OR species='dancalicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='dancalicus' OR species='dancalicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='dancalicus' OR junior_species='dancalicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='dancalicus' OR species='dancalicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='keniensis' OR junior_species='keniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='keniensis' OR species='keniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='keniensis' OR species='keniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='keniensis' OR junior_species='keniensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='keniensis' OR species='keniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='gambiae' OR junior_species='gambiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='gambiae' OR species='gambiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='gambiae' OR species='gambiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='gambiae' OR junior_species='gambiae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='gambiae' OR species='gambiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='rhodiensis' OR junior_species='rhodiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='rhodiensis' OR species='rhodiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='rhodiensis' OR species='rhodiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='rhodiensis' OR junior_species='rhodiensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='rhodiensis' OR species='rhodiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='salabii' OR junior_species='salabi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='salabii' OR species='salabi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='salabii' OR species='salabi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='salabii' OR junior_species='salabi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='salabii' OR species='salabi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='smithii' OR junior_species='smithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='smithii' OR species='smithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='smithii' OR species='smithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='smithii' OR junior_species='smithi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='smithii' OR species='smithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='welcomei' OR junior_species='welcomeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='welcomei' OR species='welcomeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='welcomei' OR species='welcomeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='welcomei' OR junior_species='welcomeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='welcomei' OR species='welcomeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anopheles' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culicinae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culicinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culicinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culicinae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culicinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='annulioris' OR junior_species='annulioris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='annulioris' OR species='annulioris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='annulioris' OR species='annulioris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='annulioris' OR junior_species='annulioris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='annulioris' OR species='annulioris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='antennatus' OR junior_species='antennatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='antennatus' OR species='antennatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='antennatus' OR species='antennatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='antennatus' OR junior_species='antennatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='antennatus' OR species='antennatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='cinerellus' OR junior_species='cinerellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='cinerellus' OR species='cinerellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='cinerellus' OR species='cinerellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='cinerellus' OR junior_species='cinerellus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='cinerellus' OR species='cinerellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='cinereus' OR species='cinereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Decens' OR junior_species='Decens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='Decens' OR species='Decens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='Decens' OR species='Decens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Decens' OR junior_species='Decens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='Decens' OR species='Decens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='horridus' OR junior_species='horridus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='horridus' OR species='horridus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='horridus' OR species='horridus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='horridus' OR junior_species='horridus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='horridus' OR species='horridus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='nebulosus' OR junior_species='nebulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='nebulosus' OR species='nebulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='nebulosus' OR species='nebulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='nebulosus' OR junior_species='nebulosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='nebulosus' OR species='nebulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens' OR junior_species='pipiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='pipiens' OR species='pipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pipiens' OR species='pipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens' OR junior_species='pipiens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='pipiens' OR species='pipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='quinquefasciatus' OR junior_species='quinquefasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='quinquefasciatus' OR species='quinquefasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='quinquefasciatus' OR species='quinquefasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='quinquefasciatus' OR junior_species='quinquefasciatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='quinquefasciatus' OR species='quinquefasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='rubinotus' OR junior_species='rubinotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='rubinotus' OR species='rubinotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='rubinotus' OR species='rubinotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='rubinotus' OR junior_species='rubinotus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='rubinotus' OR species='rubinotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Culex' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpagomyia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpagomyia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpagomyia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpagomyia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harpagomyia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mansonia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mansonia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mansonia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='chorleyi' OR junior_species='chorleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='chorleyi' OR species='chorleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='chorleyi' OR species='chorleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='chorleyi' OR junior_species='chorleyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uranotaenia' AND (species='chorleyi' OR species='chorleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='mashoaensis' OR junior_species='mashoaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='mashoaensis' OR species='mashoaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='mashoaensis' OR species='mashoaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='mashoaensis' OR junior_species='mashoaensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uranotaenia' AND (species='mashoaensis' OR species='mashoaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uranotaenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2436 The Ecological Register: Gouléako and Tåi
Gouléako and Tåi
Basic information
Sample name: Gouléako and Tåi

Reference: S. Junglen, A. Kurth, P.-L. Quan, H. Ellerbrok, G. Pauli, A. Nitsche, C. Nunn, S. M. Rich, W. I. Lipkin, T. Briese, and F. H. Leendertz. 2009. Examining landscape factors influencing relative distribution of mosquito genera and frequency of virus infection. EcoHealth 6:239-249 [ER 2303]
Geography
Country: Ivory Coast


Coordinate: 5.85° N, -7.43° W
Coordinate basis: stated in text as range

Geography comments: two villages, Gouléako and Tåi, outside the park (coordinates are median values)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

MAT: 25.9

MAP: 1893.0

Habitat comments: presumably an inhabited area because plantations were also sampled
climate data based on sample 366

Methods
Life forms: mosquitoes

Sites: 2

Sampling methods: no design,baited,light traps

Sample size: 1013 individuals

Years: 2004

Days: 3

Sampling comments: "Adult mosquitoes were collected with CDC miniature light and gravid traps... between February and June 2004. Alternating Octanol, carbon dioxide-producing hand heaters, and unwashed socks were used as attractants for the light traps... Water was mixed with sugar (5 spoons per liter) at least 24 h before use to act as an attractant in the gravid traps... Traps were installed for 3 days at each sampling point"

Metadata
Sample number: 2436

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-30 15:04:08

Modified: 2020-01-14 07:46:12

Abundance distribution
31 species
3 singletons
total count 1013
extrapolated richness: 40.8
Fisher's α: 6.046
geometric series k: 0.8235
Hurlbert's PIE: 0.8291
Shannon's H: 2.2795
Good's u: 0.9970
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aedes harrisoni12
Aedes metallicus7
Aedes sp.2
Anopheles azaniae3
Anopheles buxtoni2
Anopheles dancalicus5
Anopheles keniensis5
Anopheles gambiae68
Anopheles obscurus7
Anopheles rhodiensis rubicolus4
Anopheles salabii12
Anopheles smithii1
Anopheles welcomei erepens1
Anopheles sp.158
Culicinae indet.39
Culex annulioris13
Culex antennatus29
Culex cinerellus16
Culex cinereus2
Culex Decens Complex4
Culex horridus5
Culex nebulosus339
Culex pipiens6
Culex quinquefasciatus85
Culex rubinotus5
Culex sp.140
Harpagomyia sp.10
Mansonia africana1
Uranotaenia chorleyi8
Uranotaenia mashoaensis19
Uranotaenia sp.5