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=882 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=882SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=513SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=882 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='rufipes' OR species='rufipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='rufipes' OR species='rufipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='rufipes' OR junior_species='rufipes')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='Pachycondyla' AND (species='rufipes' OR species='rufipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontoponera' AND (junior_species='transversa' OR junior_species='transversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontoponera' AND (species='transversa' OR species='transversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontoponera' AND (species='transversa' OR species='transversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontoponera' AND (junior_species='transversa' OR junior_species='transversa')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='Odontoponera' AND (species='transversa' OR species='transversa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='macaoensis' OR junior_species='macaoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='macaoensis' OR species='macaoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='macaoensis' OR species='macaoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='macaoensis' OR junior_species='macaoensis')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='Crematogaster' AND (species='macaoensis' OR species='macaoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='ferrarii' OR junior_species='ferrari')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='ferrarii' OR species='ferrari') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='ferrarii' OR species='ferrari')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='ferrarii' OR junior_species='ferrari')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='Crematogaster' AND (species='ferrarii' OR species='ferrari') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='pharaonis' OR junior_species='pharaonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='pharaonis' OR species='pharaonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='pharaonis' OR species='pharaonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='pharaonis' OR junior_species='pharaonis')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='Monomorium' AND (species='pharaonis' OR species='pharaonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='chinensis' OR junior_species='chinensis')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='Monomorium' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhoptromyrmex' AND (junior_species='wroughtonii' OR junior_species='wroughtoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhoptromyrmex' AND (species='wroughtonii' OR species='wroughtoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhoptromyrmex' AND (species='wroughtonii' OR species='wroughtoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhoptromyrmex' AND (junior_species='wroughtonii' OR junior_species='wroughtoni')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='Rhoptromyrmex' AND (species='wroughtonii' OR species='wroughtoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='spathifera' OR junior_species='spathifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='spathifera' OR species='spathifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='spathifera' OR species='spathifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='spathifera' OR junior_species='spathifera')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='Pheidole' AND (species='spathifera' OR species='spathifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='yeensis' OR junior_species='yeensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='yeensis' OR species='yeensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='yeensis' OR species='yeensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='yeensis' OR junior_species='yeensis')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='Pheidole' AND (species='yeensis' OR species='yeensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='pieli' OR junior_species='pielii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='pieli' OR species='pielii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='pieli' OR species='pielii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='pieli' OR junior_species='pielii')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='Pheidole' AND (species='pieli' OR species='pielii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='geei' OR junior_species='geeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinoma' AND (species='geei' OR species='geeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinoma' AND (species='geei' OR species='geeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='geei' OR junior_species='geeii')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='Tapinoma' AND (species='geei' OR species='geeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='proxima' OR junior_species='proxima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyrhachis' AND (species='proxima' OR species='proxima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='proxima' OR species='proxima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='proxima' OR junior_species='proxima')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='Polyrhachis' AND (species='proxima' OR species='proxima') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=882 The Ecological Register: Yayi Town (plot IV)
Yayi Town (plot IV)
Basic information
Sample name: Yayi Town (plot IV)

Reference: Z. Lu, Y. Chen, Q. Li, S. Wang, C. Liu, and W. Zhang. 2012. Effect of population of Kerria yunnanensis on diversity of ground dwelling ant. Acta Ecologica Sinica 32(19):6195-6202 [ER 513]
Geography
Country: China

State: Yunnan


Coordinate: 23° 14' N, 101° 43' E
Coordinate basis: stated in text

Geography comments: "Yayi Town, Mojiang County, Yunnan Province": exact coordinate given by Chen et al. (2011, Bulletin of Insectology)
elevation somewhere between 900 and 1500 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

MAT: 18.2

MAP: 1800.0

Habitat comments: no information given; habitat is a guess based on climate and latitude
climate data for this exact site based on Chen et al. (2011, Bulletin of Insectology): precip 1500 to 2100 mm

Methods
Life forms: ants

Site length: 100

Site width: 100

Sampling methods: quadrat,pitfall traps

Sample size: 197 individuals

Years: 2009, 2010

Nets or traps: 120

Net or trap nights: 240

Sampling comments: two 50 m transects placed within a 100 x 100 m plot with five pitfall traps on each transect; traps were left out for 48 hours once every two weeks over a period of six months (i.e., 12 times)
the other three plots were (apparently) stocked with scale insects

Metadata
Sample number: 882

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-28 17:21:50

Modified: 2014-04-28 07:25:57

Abundance distribution
12 species
3 singletons
total count 197
extrapolated richness: 18.8
Fisher's α: 2.815
geometric series k: 0.6770
Hurlbert's PIE: 0.7774
Shannon's H: 1.7988
Good's u: 0.9848
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Pachycondyla rufipes2
Odontoponera transversa26
Crematogaster macaoensis5
Crematogaster ferrarii3
Monomorium pharaonis8
Monomorium chinensis44
Rhoptromyrmex wroughtonii1
Pheidole spathifera15
Pheidole yeensis73
Pheidole pieli18
Tapinoma geei1
Polyrhachis proxima1