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=2430 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2430SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2302SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2430 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='coustani' OR junior_species='coustanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='coustani' OR species='coustanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='coustani' OR species='coustanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='coustani' OR junior_species='coustanii')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='coustani' OR species='coustanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='fuscicolor' OR junior_species='fuscicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='fuscicolor' OR species='fuscicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='fuscicolor' OR species='fuscicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='fuscicolor' OR junior_species='fuscicolor')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='fuscicolor' OR species='fuscicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='arabiensis' OR junior_species='arabiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='arabiensis' OR species='arabiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='arabiensis' OR species='arabiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='arabiensis' OR junior_species='arabiensis')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='arabiensis' OR species='arabiensis') 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='mascarensis' OR junior_species='mascarensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='mascarensis' OR species='mascarensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='mascarensis' OR species='mascarensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='mascarensis' OR junior_species='mascarensis')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='mascarensis' OR species='mascarensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='squamosus/cydippis' OR junior_species='squamosus/cydippis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='squamosus/cydippis' OR species='squamosus/cydippis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='squamosus/cydippis' OR species='squamosus/cydippis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='squamosus/cydippis' OR junior_species='squamosus/cydippis')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='squamosus/cydippis' OR species='squamosus/cydippis') 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='argenteopunctatus' OR junior_species='argenteopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='argenteopunctatus' OR species='argenteopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='argenteopunctatus' OR species='argenteopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='argenteopunctatus' OR junior_species='argenteopunctatus')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='argenteopunctatus' OR species='argenteopunctatus') 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='giganteus' OR junior_species='giganteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='giganteus' OR species='giganteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='giganteus' OR species='giganteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='giganteus' OR junior_species='giganteus')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='giganteus' OR species='giganteus') 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='univittatus' OR junior_species='univittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='univittatus' OR species='univittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='univittatus' OR species='univittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='univittatus' OR junior_species='univittatus')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='univittatus' OR species='univittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lutzia' AND (junior_species='tigripes' OR junior_species='tigripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lutzia' AND (species='tigripes' OR species='tigripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lutzia' AND (species='tigripes' OR species='tigripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lutzia' AND (junior_species='tigripes' OR junior_species='tigripes')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='Lutzia' AND (species='tigripes' OR species='tigripes') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2430 The Ecological Register: Anorana (forest edge)
Anorana (forest edge)
Basic information
Sample name: Anorana (forest edge)

Sample aka: Ambongamarina

Reference: M. C. Tantely, J.-C. Rakotoniaina, E. Tata, L. Andrianaivolambo, D. Fontenille, and N. Elissa. 2012. Modification of Anopheles gambiae distribution at high altitudes in Madagascar. Journal of Vector Ecology 37(2):402-406 [ER 2302]
Geography
Country: Madagascar


Coordinate: 18° 18' 19" S, 48° 0' 21" E
Coordinate basis: stated in text

Geography comments: "in Ambongamarina is 30 km northeast of the city of Anjozorobe"
originally reported latitude of 18°18’44” S, 048°00’98” E includes a typo and is therefore rounded
altitude 1150 to 1345 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: unprotected

Substrate: ground surface

MAT: 17.5

WMT: 20.2

CMT: 13.7

MAP: 2300.0

Habitat comments: "rainforest edge... surrounded by interspersed relics of forest, swamps, and rice fields. The village consists of 39 houses with 204 inhabitants. The main activity is agriculture"
climate data are for Mandraka natural forest and are from Ramananantoandro et al. (2016, Annals of Forest Science)

Methods
Life forms: mosquitoes

Sampling methods: no design,butterfly nets,baited,light traps,pitfall traps,hand capture

Sample size: 17461 individuals

Years: 2008 - 2010

Seasons: dry,wet or monsoon

Sampling comments: the study was between February, 2009 and July 2010 with sampling "every month during the rainy season from November to March, and once in June or July for the dry season... butterfly nets and a backpack were used for daytime catches of imagoes in outdoor and indoor shelters and in Muirhead Thomson (1958) pit traps. This latter is a rectangular pit... CDC- light traps and net traps baited with animals or humans were used for night catches"

Metadata
Sample number: 2430

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-30 14:32:44

Modified: 2020-05-29 10:40:03

Abundance distribution
14 species
1 singleton
total count 17461
extrapolated richness: 15.3
Fisher's α: 1.495
geometric series k: 0.5059
Hurlbert's PIE: 0.7320
Shannon's H: 1.5765
Good's u: 0.9999
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Anopheles coustani4816
Anopheles fuscicolor97
Anopheles arabiensis67
Anopheles gambiae27
Anopheles mascarensis87
Anopheles squamosus/cydippis7035
Culex annulioris11
Culex antennatus1907
Culex argenteopunctatus48
Culex decens139
Culex giganteus737
Culex pipiens326
Culex univittatus2163
Lutzia tigripes1