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=2429 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2429SELECT 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=2429 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='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='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=2429 The Ecological Register: Anorana (forest)
Anorana (forest)
Basic information
Sample name: Anorana (forest)

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° 2' S, 48° 1' 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

Substrate: ground surface

MAT: 17.5

WMT: 20.2

CMT: 13.7

MAP: 2300.0

Habitat comments: "rainforest"
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,pitfall traps,hand capture

Sample size: 8689 individuals

Years: 2008 - 2010

Seasons: dry,wet or monsoon

Sampling comments: "investigations in the rainforest were conducted between November, 2008, 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"

Metadata
Sample number: 2429

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-30 14:27:23

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

Abundance distribution
11 species
1 singleton
total count 8689
extrapolated richness: 13.1
Fisher's α: 1.243
geometric series k: 0.4211
Hurlbert's PIE: 0.5280
Shannon's H: 1.0594
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 coustani12
Anopheles gambiae1
Anopheles mascarensis5
Culex annulioris59
Culex antennatus21
Culex argenteopunctatus604
Culex decens1369
Culex giganteus899
Culex pipiens5708
Culex univittatus4
Lutzia tigripes7