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=1551 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1551SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1045SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1551 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothorax' AND (junior_species='morbillosus' OR junior_species='morbillosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothorax' AND (species='morbillosus' OR species='morbillosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothorax' AND (species='morbillosus' OR species='morbillosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothorax' AND (junior_species='morbillosus' OR junior_species='morbillosus')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='Macrothorax' AND (species='morbillosus' OR species='morbillosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurycarabus' AND (junior_species='famini' OR junior_species='faminii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurycarabus' AND (species='famini' OR species='faminii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurycarabus' AND (species='famini' OR species='faminii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurycarabus' AND (junior_species='famini' OR junior_species='faminii')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='Eurycarabus' AND (species='famini' OR species='faminii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='andalusia' OR junior_species='andalusia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nebria' AND (species='andalusia' OR species='andalusia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nebria' AND (species='andalusia' OR species='andalusia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='andalusia' OR junior_species='andalusia')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='Nebria' AND (species='andalusia' OR species='andalusia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='geminatus' OR junior_species='geminatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='geminatus' OR species='geminatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='geminatus' OR species='geminatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='geminatus' OR junior_species='geminatus')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='Notiophilus' AND (species='geminatus' OR species='geminatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Broscus' AND (junior_species='politus' OR junior_species='politus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Broscus' AND (species='politus' OR species='politus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Broscus' AND (species='politus' OR species='politus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Broscus' AND (junior_species='politus' OR junior_species='politus')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='Broscus' AND (species='politus' OR species='politus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='fuscipes' OR junior_species='fuscipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='fuscipes' OR species='fuscipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='fuscipes' OR species='fuscipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='fuscipes' OR junior_species='fuscipes')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='Calathus' AND (species='fuscipes' OR species='fuscipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acinopus' AND (junior_species='megacephalus' OR junior_species='megacephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acinopus' AND (species='megacephalus' OR species='megacephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acinopus' AND (species='megacephalus' OR species='megacephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acinopus' AND (junior_species='megacephalus' OR junior_species='megacephalus')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='Acinopus' AND (species='megacephalus' OR species='megacephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontocarus' AND (junior_species='tricuspidatus' OR junior_species='tricuspidatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontocarus' AND (species='tricuspidatus' OR species='tricuspidatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontocarus' AND (species='tricuspidatus' OR species='tricuspidatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontocarus' AND (junior_species='tricuspidatus' OR junior_species='tricuspidatus')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='Odontocarus' AND (species='tricuspidatus' OR species='tricuspidatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='opacus' OR junior_species='opacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophonus' AND (species='opacus' OR species='opacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophonus' AND (species='opacus' OR species='opacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='opacus' OR junior_species='opacus')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='Ophonus' AND (species='opacus' OR species='opacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='pumilio' OR junior_species='pumilio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophonus' AND (species='pumilio' OR species='pumilio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophonus' AND (species='pumilio' OR species='pumilio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='pumilio' OR junior_species='pumilio')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='Ophonus' AND (species='pumilio' OR species='pumilio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='rotundatus' OR junior_species='rotundatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophonus' AND (species='rotundatus' OR species='rotundatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophonus' AND (species='rotundatus' OR species='rotundatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='rotundatus' OR junior_species='rotundatus')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='Ophonus' AND (species='rotundatus' OR species='rotundatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parophonus' AND (junior_species='antoinei' OR junior_species='antoineii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parophonus' AND (species='antoinei' OR species='antoineii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parophonus' AND (species='antoinei' OR species='antoineii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parophonus' AND (junior_species='antoinei' OR junior_species='antoineii')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='Parophonus' AND (species='antoinei' OR species='antoineii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parophonus' AND (junior_species='planicollis' OR junior_species='planicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parophonus' AND (species='planicollis' OR species='planicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parophonus' AND (species='planicollis' OR species='planicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parophonus' AND (junior_species='planicollis' OR junior_species='planicollis')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='Parophonus' AND (species='planicollis' OR species='planicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ditomus' AND (junior_species='sphaerocephalus' OR junior_species='sphaerocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ditomus' AND (species='sphaerocephalus' OR species='sphaerocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ditomus' AND (species='sphaerocephalus' OR species='sphaerocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ditomus' AND (junior_species='sphaerocephalus' OR junior_species='sphaerocephalus')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='Ditomus' AND (species='sphaerocephalus' OR species='sphaerocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='tenebrosus' OR junior_species='tenebrosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='tenebrosus' OR species='tenebrosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='tenebrosus' OR species='tenebrosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='tenebrosus' OR junior_species='tenebrosus')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='Harpalus' AND (species='tenebrosus' OR species='tenebrosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licinus' AND (junior_species='punctatulus' OR junior_species='punctatulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Licinus' AND (species='punctatulus' OR species='punctatulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licinus' AND (species='punctatulus' OR species='punctatulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licinus' AND (junior_species='punctatulus' OR junior_species='punctatulus')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='Licinus' AND (species='punctatulus' OR species='punctatulus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1551 The Ecological Register: El Khroub
El Khroub
Basic information
Sample name: El Khroub

Reference: Y. Saouache and S. Doumandji. 2014. La faune carabique d'une zone cultivee dans une region semi-aride du nord est de l'Algerie. AFPP - Dixième Conférence Internationale sur les Ravageurs en Agriculture [ER 1045]
Geography
Country: Algeria


Coordinate: 36° 26' N, 6° 7' E
Coordinate basis: stated in text

Geography comments: southeast of Constantine at El Khroub

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

Habitat comments: an "herbaceous" and semiarid environment near cereal fields

Methods
Life forms: ground beetles

Sampling methods: line transect,pitfall traps,hand capture

Sample size: 60 individuals

Years: 1997

Nets or traps: 10

Sampling comments: 10 traps placed in a line and spaced 5 m apart and checked once a month through the calendar year, with trapping supplemented by hand captures

Metadata
Sample number: 1551

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-16 15:45:37

Modified: 2015-05-16 05:45:37

Abundance distribution
16 species
5 singletons
total count 60
extrapolated richness: 33.8
Fisher's α: 7.139
geometric series k: 0.8312
Hurlbert's PIE: 0.8684
Shannon's H: 2.3696
Good's u: 0.9189
Each square represents a species. Square sizes are proportional to counts.
Register