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=2222 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2222SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2191SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2222 ORDER BY register_no ASCSELECT 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='taeniorhynchus' OR junior_species='taeniorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='taeniorhynchus' OR species='taeniorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='taeniorhynchus' OR species='taeniorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='taeniorhynchus' OR junior_species='taeniorhynchus')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='taeniorhynchus' OR species='taeniorhynchus') 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='Sabethes' AND (junior_species='albiprivus' OR junior_species='albiprivus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sabethes' AND (species='albiprivus' OR species='albiprivus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethes' AND (species='albiprivus' OR species='albiprivus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='albiprivus' OR junior_species='albiprivus')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='albiprivus' OR species='albiprivus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2222 The Ecological Register: Duque de Caxias
Duque de Caxias
Basic information
Sample name: Duque de Caxias

Sample aka: Guanabara Bay

Reference: A. S. de Souza, M. S. Couri, and L. Florindo. 2012. The impact of industrial anthropization on mosquito (Diptera, Culicidae) communities in mangrove areas of Guanabara Bay (Rio de Janeiro, Brazil). Neotropical Entomology 41:68-73 [ER 2191]
Geography
Country: Brazil

State: Rio de Janeiro


Coordinate: 22° 43' 26" S, 43° 14' 19" W
Coordinate basis: stated in text as range

•
Environment
Habitat: mangrove

Altered habitat: disturbed forest

Substrate: ground surface

WMT: 27.0

CMT: 20.0

MAP: 1200.0

Habitat comments: "mangrove... used for residue disposal since the 1970s... plant poverty is evident... It has many anthropic activities like smoke, odors, machine traffic, and residual gas burn in flairs"
climate data are for Niterói on "the eastern coast of Guanabara Bay" and are from de Souza et al. (2015, Atmospheric Research)

Methods
Life forms: mosquitoes

Sites: 4

Sampling methods: no design,baited

Sample size: 361 individuals

Years: 2003, 2004

Sampling comments: "we collected in four points... They were separated from each other by approximately 200 m, except point 4, which was 800 m from point 1... Adult culicids were collected monthly from May 2003 to April 2004... An aspiration tube was used to collect the adults as they tried to land on the skin of the collector, which was efficient to collect females"

Metadata
Sample number: 2222

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-13 20:17:40

Modified: 2016-12-17 11:05:04

Abundance distribution
4 species
1 singleton
total count 361
extrapolated richness: 5.5
Fisher's α: 0.630
geometric series k: 0.1538
Hurlbert's PIE: 0.3786
Shannon's H: 0.6738
Good's u: 0.9972
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aedes scapularis275
Aedes taeniorhynchus70
Psorophora ferox1
Sabethes albiprivus15