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=2443 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2443SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2306SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2443 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='crinifer' OR junior_species='crinifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='crinifer' OR species='crinifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='crinifer' OR species='crinifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='crinifer' OR junior_species='crinifer')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='crinifer' OR species='crinifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='hastatus/oligopistus' OR junior_species='hastatus/oligopistus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='hastatus/oligopistus' OR species='hastatus/oligopistus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='hastatus/oligopistus' OR species='hastatus/oligopistus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='hastatus/oligopistus' OR junior_species='hastatus/oligopistus')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='hastatus/oligopistus' OR species='hastatus/oligopistus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='hortator' OR junior_species='hortator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='hortator' OR species='hortator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='hortator' OR species='hortator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='hortator' OR junior_species='hortator')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='hortator' OR species='hortator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='scapularis' OR junior_species='scapularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='scapularis' OR species='scapularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='scapularis' OR species='scapularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='scapularis' OR junior_species='scapularis')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='scapularis' OR species='scapularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='serratus' OR junior_species='serratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='serratus' OR species='serratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='serratus' OR species='serratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='serratus' OR junior_species='serratus')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='serratus' OR species='serratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='serratus/nubilus' OR junior_species='serratus/nubilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='serratus/nubilus' OR species='serratus/nubilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='serratus/nubilus' OR species='serratus/nubilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='serratus/nubilus' OR junior_species='serratus/nubilus')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='serratus/nubilus' OR species='serratus/nubilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='bellator' OR junior_species='bellator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='bellator' OR species='bellator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='bellator' OR species='bellator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='bellator' OR junior_species='bellator')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='bellator' OR species='bellator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='cruzii' OR junior_species='cruzi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='cruzii' OR species='cruzi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='cruzii' OR species='cruzi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='cruzii' OR junior_species='cruzi')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='cruzii' OR species='cruzi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='chrysonotum' OR junior_species='chrysonotum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='chrysonotum' OR species='chrysonotum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='chrysonotum' OR species='chrysonotum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='chrysonotum' OR junior_species='chrysonotum')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='Coquillettidia' AND (species='chrysonotum' OR species='chrysonotum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='venezuelensis' OR junior_species='venezuelensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='venezuelensis' OR species='venezuelensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='venezuelensis' OR species='venezuelensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='venezuelensis' OR junior_species='venezuelensis')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='Coquillettidia' AND (species='venezuelensis' OR species='venezuelensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='eduardoi' OR junior_species='eduardoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='eduardoi' OR species='eduardoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='eduardoi' OR species='eduardoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='eduardoi' OR junior_species='eduardoii')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='eduardoi' OR species='eduardoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='nigripalpus' OR junior_species='nigripalpus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='nigripalpus' OR species='nigripalpus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='nigripalpus' OR species='nigripalpus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='nigripalpus' OR junior_species='nigripalpus')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='nigripalpus' OR species='nigripalpus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='akritos' OR junior_species='akritos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='akritos' OR species='akritos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='akritos' OR species='akritos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='akritos' OR junior_species='akritos')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='akritos' OR species='akritos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='aureonotatus' OR junior_species='aureonotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='aureonotatus' OR species='aureonotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='aureonotatus' OR species='aureonotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='aureonotatus' OR junior_species='aureonotatus')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='aureonotatus' OR species='aureonotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='faurani' OR junior_species='fauranii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='faurani' OR species='fauranii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='faurani' OR species='fauranii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='faurani' OR junior_species='fauranii')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='faurani' OR species='fauranii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Atratus' OR junior_species='Atratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='Atratus' OR species='Atratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='Atratus' OR species='Atratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Atratus' OR junior_species='Atratus')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='Atratus' OR species='Atratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Coronator' OR junior_species='Coronator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='Coronator' OR species='Coronator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='Coronator' OR species='Coronator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Coronator' OR junior_species='Coronator')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='Coronator' OR species='Coronator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Pilosus' OR junior_species='Pilosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='Pilosus' OR species='Pilosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='Pilosus' OR species='Pilosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Pilosus' OR junior_species='Pilosus')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='Pilosus' OR species='Pilosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pedroi' OR junior_species='pedroii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='pedroi' OR species='pedroii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pedroi' OR species='pedroii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pedroi' OR junior_species='pedroii')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='pedroi' OR species='pedroii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='ribeirensis' OR junior_species='ribeirensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='ribeirensis' OR species='ribeirensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='ribeirensis' OR species='ribeirensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='ribeirensis' OR junior_species='ribeirensis')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='ribeirensis' OR species='ribeirensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='sacchettae' OR junior_species='sacchettae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='sacchettae' OR species='sacchettae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='sacchettae' OR species='sacchettae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='sacchettae' OR junior_species='sacchettae')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='sacchettae' OR species='sacchettae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Melanoconion' OR junior_species='Melanoconion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='Melanoconion' OR species='Melanoconion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='Melanoconion' OR species='Melanoconion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='Melanoconion' OR junior_species='Melanoconion')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='Melanoconion' OR species='Melanoconion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='zeteki' OR junior_species='zetekii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='zeteki' OR species='zetekii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='zeteki' OR species='zetekii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='zeteki' OR junior_species='zetekii')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='zeteki' OR species='zetekii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='durhamii' OR junior_species='durhami')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limatus' AND (species='durhamii' OR species='durhami') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limatus' AND (species='durhamii' OR species='durhami')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='durhamii' OR junior_species='durhami')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='Limatus' AND (species='durhamii' OR species='durhami') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='flavisetosus' OR junior_species='flavisetosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limatus' AND (species='flavisetosus' OR species='flavisetosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limatus' AND (species='flavisetosus' OR species='flavisetosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='flavisetosus' OR junior_species='flavisetosus')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='Limatus' AND (species='flavisetosus' OR species='flavisetosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='titillans' OR junior_species='titillans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mansonia' AND (species='titillans' OR species='titillans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mansonia' AND (species='titillans' OR species='titillans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='titillans' OR junior_species='titillans')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='titillans' OR species='titillans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='ferox' OR junior_species='ferox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorophora' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorophora' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='ferox' OR junior_species='ferox')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='Psorophora' AND (species='ferox' OR species='ferox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Runchomyia' AND (junior_species='reversa' OR junior_species='reversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Runchomyia' AND (species='reversa' OR species='reversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Runchomyia' AND (species='reversa' OR species='reversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Runchomyia' AND (junior_species='reversa' OR junior_species='reversa')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='Runchomyia' AND (species='reversa' OR species='reversa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='purpureus' OR junior_species='purpureus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sabethes' AND (species='purpureus' OR species='purpureus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethes' AND (species='purpureus' OR species='purpureus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='purpureus' OR junior_species='purpureus')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='Sabethes' AND (species='purpureus' OR species='purpureus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='calosomata' OR junior_species='calosomata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='calosomata' OR species='calosomata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='calosomata' OR species='calosomata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='calosomata' OR junior_species='calosomata')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='calosomata' OR species='calosomata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='ditaenionota' OR junior_species='ditaenionota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='ditaenionota' OR species='ditaenionota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='ditaenionota' OR species='ditaenionota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='ditaenionota' OR junior_species='ditaenionota')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='ditaenionota' OR species='ditaenionota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='geometrica' OR junior_species='geometrica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='geometrica' OR species='geometrica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='geometrica' OR species='geometrica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='geometrica' OR junior_species='geometrica')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='geometrica' OR species='geometrica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='nataliae' OR junior_species='nataliae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='nataliae' OR species='nataliae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='nataliae' OR species='nataliae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='nataliae' OR junior_species='nataliae')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='nataliae' OR species='nataliae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2443 The Ecological Register: Cananéia (trap A)
Cananéia (trap A)
Basic information
Sample name: Cananéia (trap A)

Reference: L. S. M. Chaves, G. Z. Laporta, and M. A. M. Sallum. 2014. Effectiveness of Mosquito Magnet in preserved area on the coastal Atlantic Rainforest: implication for entomological surveillance. Journal of Medical Entomology 51(5):915-924 [ER 2306]
Geography
Country: Brazil

State: Säo Paulo


Coordinate: 25° 0' 53" S, 47° 55' 36" W
Coordinate basis: stated in text

Geography comments: "in the mainland area of the municipality of Cananéia"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 21.2

WMT: 24.5

CMT: 7.8

MAP: 2270.0

Habitat comments: in "a well-preserved portion of the Atlantic Forest... the Ribeira Valley climate is Cwa, i.e., subtropical humid with a moderately dry winter and a warm humid summer"
climate data are for the Cananéia region and are from Schaeffer-Novelli et al. (1990)

Methods
Life forms: mosquitoes

Sites: 1

Sampling methods: no design,baited,light traps

Sample size: 1322 individuals

Years: 2010, 2011

Days: 36

Nets or traps: 1

Net or trap nights: 36

Sampling comments: "Mosquito collections were conducted monthly over the course of 1 yr" and the trap was "left running for 6 h per day... totaling 18 h per month... we evaluated a CDC-LT, (CDC-A), and MMI... with CO2 plus Lurex3"; sampling was from "December 2010 to November 2011"

Metadata
Sample number: 2443

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-30 16:29:57

Modified: 2016-12-30 05:29:57

Abundance distribution
34 species
11 singletons
total count 1322
extrapolated richness: 62.1
Fisher's α: 6.366
geometric series k: 0.8176
Hurlbert's PIE: 0.6340
Shannon's H: 1.6444
Good's u: 0.9917
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aedes crinifer1
Aedes hastatus/oligopistus1
Aedes hortator6
Aedes scapularis13
Aedes serratus62
Aedes serratus/nubilus66
Anopheles bellator8
Anopheles cruzii15
Coquillettidia chrysonotum163
Coquillettidia venezuelensis1
Culex eduardoi3
Culex nigripalpus1
Culex (Culex) spp.4
Culex akritos1
Culex aureonotatus2
Culex faurani1
Culex (Melanoconion) Atratus Group1
Culex (Culex) Coronator Group1
Culex (Melanoconion) Pilosus Group2
Culex pedroi28
Culex ribeirensis19
Culex sacchettae768
Culex (Melanoconion) Melanoconion Section112
Culex zeteki2
Limatus durhamii4
Limatus flavisetosus6
Mansonia titillans1
Psorophora ferox4
Runchomyia reversa2
Sabethes purpureus1
Uranotaenia calosomata12
Uranotaenia ditaenionota1
Uranotaenia geometrica7
Uranotaenia nataliae3