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=2125 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2125SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2137SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2125 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oulema' AND (junior_species='melanopa' OR junior_species='melanopa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oulema' AND (species='melanopa' OR species='melanopa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oulema' AND (species='melanopa' OR species='melanopa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oulema' AND (junior_species='melanopa' OR junior_species='melanopa')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='Oulema' AND (species='melanopa' OR species='melanopa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptocephala' AND (junior_species='unifasciata' OR junior_species='unifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coptocephala' AND (species='unifasciata' OR species='unifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coptocephala' AND (species='unifasciata' OR species='unifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptocephala' AND (junior_species='unifasciata' OR junior_species='unifasciata')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='Coptocephala' AND (species='unifasciata' OR species='unifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='dahdah' OR junior_species='dahdah')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='dahdah' OR species='dahdah') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='dahdah' OR species='dahdah')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='dahdah' OR junior_species='dahdah')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='Cryptocephalus' AND (species='dahdah' OR species='dahdah') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='peyroni' OR junior_species='peyronii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='peyroni' OR species='peyronii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='peyroni' OR species='peyronii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='peyroni' OR junior_species='peyronii')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='Cryptocephalus' AND (species='peyroni' OR species='peyronii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='bidorsalis' OR junior_species='bidorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='bidorsalis' OR species='bidorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='bidorsalis' OR species='bidorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='bidorsalis' OR junior_species='bidorsalis')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='Cryptocephalus' AND (species='bidorsalis' OR species='bidorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='egerickxi' OR junior_species='egerickxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='egerickxi' OR species='egerickxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='egerickxi' OR species='egerickxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='egerickxi' OR junior_species='egerickxii')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='Cryptocephalus' AND (species='egerickxi' OR species='egerickxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachybrachis' AND (junior_species='jordanicus' OR junior_species='jordanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachybrachis' AND (species='jordanicus' OR species='jordanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachybrachis' AND (species='jordanicus' OR species='jordanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachybrachis' AND (junior_species='jordanicus' OR junior_species='jordanicus')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='Pachybrachis' AND (species='jordanicus' OR species='jordanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachnephorus' AND (junior_species='villosus' OR junior_species='villosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachnephorus' AND (species='villosus' OR species='villosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachnephorus' AND (species='villosus' OR species='villosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachnephorus' AND (junior_species='villosus' OR junior_species='villosus')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='Pachnephorus' AND (species='villosus' OR species='villosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolina' AND (junior_species='sahlbergi' OR junior_species='sahlbergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysolina' AND (species='sahlbergi' OR species='sahlbergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysolina' AND (species='sahlbergi' OR species='sahlbergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolina' AND (junior_species='sahlbergi' OR junior_species='sahlbergii')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='Chrysolina' AND (species='sahlbergi' OR species='sahlbergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marseulia' AND (junior_species='dilativentris' OR junior_species='dilativentris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marseulia' AND (species='dilativentris' OR species='dilativentris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marseulia' AND (species='dilativentris' OR species='dilativentris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marseulia' AND (junior_species='dilativentris' OR junior_species='dilativentris')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='Marseulia' AND (species='dilativentris' OR species='dilativentris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='cruciferae' OR junior_species='cruciferae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllotreta' AND (species='cruciferae' OR species='cruciferae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllotreta' AND (species='cruciferae' OR species='cruciferae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='cruciferae' OR junior_species='cruciferae')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='Phyllotreta' AND (species='cruciferae' OR species='cruciferae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Longitarsus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='albineus' OR junior_species='albineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='albineus' OR species='albineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='albineus' OR species='albineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='albineus' OR junior_species='albineus')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='Longitarsus' AND (species='albineus' OR species='albineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='pellucidus' OR junior_species='pellucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='pellucidus' OR species='pellucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='pellucidus' OR species='pellucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='pellucidus' OR junior_species='pellucidus')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='Longitarsus' AND (species='pellucidus' OR species='pellucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='strangulatus' OR junior_species='strangulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='strangulatus' OR species='strangulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='strangulatus' OR species='strangulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='strangulatus' OR junior_species='strangulatus')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='Longitarsus' AND (species='strangulatus' OR species='strangulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='angusta' OR junior_species='angusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='angusta' OR species='angusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='angusta' OR species='angusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='angusta' OR junior_species='angusta')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='Longitarsus' AND (species='angusta' OR species='angusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='marcida' OR junior_species='marcida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='marcida' OR species='marcida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='marcida' OR species='marcida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='marcida' OR junior_species='marcida')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='Psylliodes' AND (species='marcida' OR species='marcida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='cuprea' OR junior_species='cuprea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='cuprea' OR species='cuprea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='cuprea' OR species='cuprea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='cuprea' OR junior_species='cuprea')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='Psylliodes' AND (species='cuprea' OR species='cuprea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='hyoscyami' OR junior_species='hyoscyamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='hyoscyami' OR species='hyoscyamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='hyoscyami' OR species='hyoscyamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='hyoscyami' OR junior_species='hyoscyamii')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='Psylliodes' AND (species='hyoscyami' OR species='hyoscyamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrosis' AND (junior_species='ventralis' OR junior_species='ventralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochrosis' AND (species='ventralis' OR species='ventralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochrosis' AND (species='ventralis' OR species='ventralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrosis' AND (junior_species='ventralis' OR junior_species='ventralis')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='Ochrosis' AND (species='ventralis' OR species='ventralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='fuscicornis' OR junior_species='fuscicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podagrica' AND (species='fuscicornis' OR species='fuscicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podagrica' AND (species='fuscicornis' OR species='fuscicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='fuscicornis' OR junior_species='fuscicornis')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='Podagrica' AND (species='fuscicornis' OR species='fuscicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='malvae' OR junior_species='malvae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podagrica' AND (species='malvae' OR species='malvae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podagrica' AND (species='malvae' OR species='malvae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='malvae' OR junior_species='malvae')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='Podagrica' AND (species='malvae' OR species='malvae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocassida' AND (junior_species='subferruginea' OR junior_species='subferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypocassida' AND (species='subferruginea' OR species='subferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypocassida' AND (species='subferruginea' OR species='subferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocassida' AND (junior_species='subferruginea' OR junior_species='subferruginea')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='Hypocassida' AND (species='subferruginea' OR species='subferruginea') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2125 The Ecological Register: Evolution Canyon (SFS1)
Evolution Canyon (SFS1)
Basic information
Sample name: Evolution Canyon (SFS1)

Reference: V. Chikatunov, T. Pavlicek, I. Lopatin, and E. Nevo. 2000. Biodiversity and microclimatic divergence of chrysomelid beetles at 'Evolution Canyon', Lower Nahal Oren, Mt Carmel, Israel. Biological Journal of the Linnean Society 69:139-152 [ER 2137]
Geography
Country: Israel


Coordinate: 32° 43' N, 34° 58' E
Coordinate basis: stated in text

Geography comments: "Lower Nahal Oren, Mt Carmel"

Environment
Habitat: Mediterranean woodland

Substrate: branches or trunks

Habitat comments: "a typical Mediterranean valley with a stream which is dry in summer at the bottom" with collection made in a "tropical 'savanna'-like" habitat

Methods
Life forms: leaf beetles

Site area: 0.1

Sampling methods: no design,other nets

Sample size: 81 individuals

Years: 1995 - 1997

Days: 56

Sampling comments: "the collecting area was about 1000 m2 around each station... Beetles were collected... by sweeping with an entomological net, and Cyrtonastes libanensis was collected by pitfall traps... The beetles were collected twice each month from March 1995 to June 1997... We spent the same collecting time (30 minutes) at each station on each collection date" (2 days x 28 months = 56 days)

Metadata
Sample number: 2125

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-07-23 16:43:28

Modified: 2016-07-23 06:43:28

Abundance distribution
23 species
8 singletons
total count 81
extrapolated richness: 50.8
Fisher's α: 10.711
geometric series k: 0.8747
Hurlbert's PIE: 0.8974
Shannon's H: 2.6989
Good's u: 0.9022
Each square represents a species. Square sizes are proportional to counts.
Register