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=2250 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2250SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2212SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2250 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='maculates' OR junior_species='maculates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='maculates' OR species='maculates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='maculates' OR species='maculates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='maculates' OR junior_species='maculates')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='maculates' OR species='maculates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='stephensi' OR junior_species='stephensii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='stephensi' OR species='stephensii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='stephensi' OR species='stephensii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='stephensi' OR junior_species='stephensii')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='stephensi' OR species='stephensii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='annularis' OR junior_species='annularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='annularis' OR species='annularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='annularis' OR species='annularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='annularis' OR junior_species='annularis')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='annularis' OR species='annularis') 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='theileri' OR junior_species='theilerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='theileri' OR species='theilerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='theileri' OR species='theilerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='theileri' OR junior_species='theilerii')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='theileri' OR species='theilerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='shortii' OR junior_species='shorti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='shortii' OR species='shorti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='shortii' OR species='shorti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='shortii' OR junior_species='shorti')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='shortii' OR species='shorti') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2250 The Ecological Register: District Upper Dir (water)
District Upper Dir (water)
Basic information
Sample name: District Upper Dir (water)

Reference: M. ud Din and I. Ali Khan. 2015. Species composition, relative abundance and habitats of mosquito fauna of District Upper Dir, Khyber Pakhtunkhwa-Pakistan. Journal of Entomology and Zoology Studies 3(5):447-450 [ER 2212]
Geography
Country: Pakistan

State: Khyber Pakhtunkhwa


Coordinate: 35° 6' 51" N, 72° 1' 59" E
Coordinate basis: stated in text

Geography comments: "District Upper Dir" and specifically "Barawal, Sheringal, Wari and Dir City"

•
Environment
Habitat: temperate coniferous forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

MAT: 15.3

WMT: 25.4

CMT: 4.4

MAP: 700.0

Habitat comments: "The climate of Upper Dir is cold and damp. Its mountains are usually covered with snow and receives snow fall in the months of December, January and February... temperature varies from -6 ºC to 38 ºC" (presumably meaning daily extremes, not monthly means)
habitat is a guess, could be broadleaf/mixed
MAP stated in text
MAT, CMT, and WMT are for Dir and are from Awan (2002, The Climate and Flood Risk Poential of Northern Areas of Pakistan)

Methods
Life forms: mosquitoes

Sites: 4

Sampling methods: other nets,light traps,hand capture

Sample size: 278 individuals

Years: 2014

Seasons: spring,summer,autumn

Sampling comments: "The research study was conducted from April to November 2014... The mosquitoes were collected by means of hand net, aspirator and light trap... Outdoor collection was made from plants, water habitats and water-containing automobile tires"

Metadata
Sample number: 2250

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-09-04 09:58:29

Modified: 2020-01-14 07:33:13

Abundance distribution
6 species
0 singletons
total count 278
extrapolated richness: 6.2
Fisher's α: 1.080
geometric series k: 0.6397
Hurlbert's PIE: 0.7780
Shannon's H: 1.6095
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Anopheles maculates56
Anopheles stephensi22
Anopheles annularis71
Culex quinquefasciatus84
Culex theileri36
Aedes shortii9