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=974 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=974SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=668SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=974 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='praedo' OR junior_species='praedo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='praedo' OR species='praedo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='praedo' OR species='praedo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='praedo' OR junior_species='praedo')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='Aphaenogaster' AND (species='praedo' OR species='praedo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='senilis' OR junior_species='senilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='senilis' OR species='senilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='senilis' OR species='senilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='senilis' OR junior_species='senilis')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='Aphaenogaster' AND (species='senilis' OR species='senilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='theryi' OR junior_species='theryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='theryi' OR species='theryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='theryi' OR species='theryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='theryi' OR junior_species='theryii')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='Aphaenogaster' AND (species='theryi' OR species='theryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='picturatus' OR junior_species='picturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Messor' AND (species='picturatus' OR species='picturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Messor' AND (species='picturatus' OR species='picturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='picturatus' OR junior_species='picturatus')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='Messor' AND (species='picturatus' OR species='picturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='vaucheri' OR junior_species='vaucherii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Messor' AND (species='vaucheri' OR species='vaucherii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Messor' AND (species='vaucheri' OR species='vaucherii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='vaucheri' OR junior_species='vaucherii')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='Messor' AND (species='vaucheri' OR species='vaucherii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='capitatus' OR junior_species='capitatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Messor' AND (species='capitatus' OR species='capitatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Messor' AND (species='capitatus' OR species='capitatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='capitatus' OR junior_species='capitatus')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='Messor' AND (species='capitatus' OR species='capitatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='subopacum' OR junior_species='subopacum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='subopacum' OR species='subopacum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='subopacum' OR species='subopacum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='subopacum' OR junior_species='subopacum')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='subopacum' OR species='subopacum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='scutellaris' OR junior_species='scutellaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='scutellaris' OR species='scutellaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='scutellaris' OR species='scutellaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='scutellaris' OR junior_species='scutellaris')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='scutellaris' OR species='scutellaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cataglyphis' AND (junior_species='albicans' OR junior_species='albicans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cataglyphis' AND (species='albicans' OR species='albicans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cataglyphis' AND (species='albicans' OR species='albicans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cataglyphis' AND (junior_species='albicans' OR junior_species='albicans')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='Cataglyphis' AND (species='albicans' OR species='albicans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cataglyphis' AND (junior_species='viatica' OR junior_species='viatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cataglyphis' AND (species='viatica' OR species='viatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cataglyphis' AND (species='viatica' OR species='viatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cataglyphis' AND (junior_species='viatica' OR junior_species='viatica')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='Cataglyphis' AND (species='viatica' OR species='viatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='erigens' OR junior_species='erigens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='erigens' OR species='erigens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='erigens' OR species='erigens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='erigens' OR junior_species='erigens')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='Camponotus' AND (species='erigens' OR species='erigens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campnotus' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campnotus' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campnotus' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campnotus' AND (junior_species='lateralis' OR junior_species='lateralis')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='Campnotus' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='simrothi' OR junior_species='simrothii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinoma' AND (species='simrothi' OR species='simrothii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinoma' AND (species='simrothi' OR species='simrothii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='simrothi' OR junior_species='simrothii')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='simrothi' OR species='simrothii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=974 The Ecological Register: Boutazarte
Boutazarte
Basic information
Sample name: Boutazarte

Reference: A. El Keroumi, K. Naamani, H. Soummane, and A. Dahbi. 2012. Seasonal dynamics of ant community structure in the Moroccan Argan forest. Journal of Insect Science 12(94):1-19 [ER 668]
Geography
Country: Morocco


Coordinate: 31° 20' N, 9° 48' W
Coordinate basis: based on nearby landmark

Geography comments: near Sidi Kaouki (basis of coordinate)

Environment
Habitat: Mediterranean woodland

Substrate: ground surface

WMT: 20.5

CMT: 14.3

MAP: 314.0

Habitat comments: "an arid to semi-arid Mediterranean climate"
CMT, WMT, and MAP based on climate station 60220 (Essaouira)

Methods
Life forms: ants

Sampling methods: pitfall traps

Sample size: 3338 individuals

Years: 2006, 2007

Days: 4

Nets or traps: 70

Net or trap nights: 280

Sampling comments: seven pitfall trees within a 6 m circle around each of 10 trees, each left out for 24 hours during four sampling dates

Metadata
Sample number: 974

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-06-25 21:03:36

Modified: 2014-06-25 11:03:36

Abundance distribution
13 species
0 singletons
total count 3338
extrapolated richness: 14.6
Fisher's α: 1.717
geometric series k: 0.5757
Hurlbert's PIE: 0.4885
Shannon's H: 0.9853
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register