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=295 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=295SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=127SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=295 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='theisi' OR junior_species='theisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='theisi' OR species='theisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='theisi' OR species='theisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='theisi' OR junior_species='theisii')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='Neoscona' AND (species='theisi' OR species='theisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gea' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gea' AND (junior_species='sp.' OR junior_species='sp.')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='Gea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linyphiidae' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Linyphiidae' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Linyphiidae' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linyphiidae' AND (junior_species='sp.' OR junior_species='sp.')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='Linyphiidae' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linyphiidae' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Linyphiidae' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Linyphiidae' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linyphiidae' AND (junior_species='sp.' OR junior_species='sp.')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='Linyphiidae' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnaphosa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnaphosa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='sp.' OR junior_species='sp.')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='Gnaphosa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drassodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drassodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='sp.' OR junior_species='sp.')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='Drassodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='terrestris' OR junior_species='terrestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycosa' AND (species='terrestris' OR species='terrestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycosa' AND (species='terrestris' OR species='terrestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='terrestris' OR junior_species='terrestris')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='Lycosa' AND (species='terrestris' OR species='terrestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='nigricans' OR junior_species='nigricans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycosa' AND (species='nigricans' OR species='nigricans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycosa' AND (species='nigricans' OR species='nigricans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='nigricans' OR junior_species='nigricans')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='Lycosa' AND (species='nigricans' OR species='nigricans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycosa' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycosa' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='maculata' OR junior_species='maculata')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='Lycosa' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='birmanica' OR junior_species='birmanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='birmanica' OR species='birmanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='birmanica' OR species='birmanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='birmanica' OR junior_species='birmanica')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='Pardosa' AND (species='birmanica' OR species='birmanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='oakleyi' OR junior_species='oakleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='oakleyi' OR species='oakleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='oakleyi' OR species='oakleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='oakleyi' OR junior_species='oakleyii')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='Pardosa' AND (species='oakleyi' OR species='oakleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evipppa' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evipppa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evipppa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evipppa' AND (junior_species='sp.' OR junior_species='sp.')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='Evipppa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippasa' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippasa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippasa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippasa' AND (junior_species='sp.' OR junior_species='sp.')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='Hippasa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='javanus' OR junior_species='javanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='javanus' OR species='javanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='javanus' OR species='javanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='javanus' OR junior_species='javanus')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='Oxyopes' AND (species='javanus' OR species='javanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='sp.' OR junior_species='sp.')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='Oxyopes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyne' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyne' AND (species='imperialis' OR species='imperialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thyne' AND (species='imperialis' OR species='imperialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyne' AND (junior_species='imperialis' OR junior_species='imperialis')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='Thyne' AND (species='imperialis' OR species='imperialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='paykulli' OR junior_species='paykullii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plexippus' AND (species='paykulli' OR species='paykullii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plexippus' AND (species='paykulli' OR species='paykullii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='paykulli' OR junior_species='paykullii')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='Plexippus' AND (species='paykulli' OR species='paykullii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Binor' AND (junior_species='albobimaculatus' OR junior_species='albobimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Binor' AND (species='albobimaculatus' OR species='albobimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Binor' AND (species='albobimaculatus' OR species='albobimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Binor' AND (junior_species='albobimaculatus' OR junior_species='albobimaculatus')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='Binor' AND (species='albobimaculatus' OR species='albobimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hasarius' AND (junior_species='adansoni' OR junior_species='adansonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hasarius' AND (species='adansoni' OR species='adansonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hasarius' AND (species='adansoni' OR species='adansonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hasarius' AND (junior_species='adansoni' OR junior_species='adansonii')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='Hasarius' AND (species='adansoni' OR species='adansonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='javana' OR junior_species='javana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='javana' OR species='javana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='javana' OR species='javana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='javana' OR junior_species='javana')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='Tetragnatha' AND (species='javana' OR species='javana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='sp.' OR junior_species='sp.')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='Tetragnatha' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomisus' AND (junior_species='elongatus' OR junior_species='elongatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thomisus' AND (species='elongatus' OR species='elongatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thomisus' AND (species='elongatus' OR species='elongatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomisus' AND (junior_species='elongatus' OR junior_species='elongatus')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='Thomisus' AND (species='elongatus' OR species='elongatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomisus' AND (junior_species='cherapunjeus' OR junior_species='cherapunjeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thomisus' AND (species='cherapunjeus' OR species='cherapunjeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thomisus' AND (species='cherapunjeus' OR species='cherapunjeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomisus' AND (junior_species='cherapunjeus' OR junior_species='cherapunjeus')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='Thomisus' AND (species='cherapunjeus' OR species='cherapunjeus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=295 The Ecological Register: Piruwala
Piruwala
Basic information
Sample name: Piruwala

Sample aka: S-1

Reference: H. M. Tahir, A. Butt, M. K. Mukhtar, S. Y. Khan, M. Arshad, and M. M. Ahsan. 2011. Effect of carbofuran on the diversity and mean abundance of ground spiders. African Journal of Biotechnology 10(57):12303-12308 [ER 127]
Geography
Country: Pakistan

State: Punjab


Coordinate: 31° 8' N, 74° 27' E
Coordinate basis: stated in text

Environment
Habitat: forest

Altered habitat: cropland

Substrate: ground surface

Habitat comments: rice field
"Sampling site S-1 was not treated with any insecticides in either study year and treated as control." (p. 12304)

Methods
Life forms: spiders

Sampling methods: no design,pitfall traps

Sample size: 1629 individuals

Years: 2008-2009

Metadata
Sample number: 295

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-04-10 14:57:55

Modified: 2015-02-23 02:54:55

Abundance distribution
23 species
4 singletons
total count 1629
extrapolated richness: 35.0
Fisher's α: 3.792
geometric series k: 0.7293
Hurlbert's PIE: 0.5078
Shannon's H: 1.0301
Good's u: 0.9975
Each square represents a species. Square sizes are proportional to counts.
Register