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=1556 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1556SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1050SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1556 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='arcensis' OR junior_species='arcensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='arcensis' OR species='arcensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='arcensis' OR species='arcensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='arcensis' OR junior_species='arcensis')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='Carabus' AND (species='arcensis' OR species='arcensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='billbergi' OR junior_species='billbergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='billbergi' OR species='billbergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='billbergi' OR species='billbergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='billbergi' OR junior_species='billbergii')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='Carabus' AND (species='billbergi' OR species='billbergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='hummeli' OR junior_species='hummelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='hummeli' OR species='hummelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='hummeli' OR species='hummelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='hummeli' OR junior_species='hummelii')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='Carabus' AND (species='hummeli' OR species='hummelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='canaliculatus' OR junior_species='canaliculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='canaliculatus' OR species='canaliculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='canaliculatus' OR species='canaliculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='canaliculatus' OR junior_species='canaliculatus')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='Carabus' AND (species='canaliculatus' OR species='canaliculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='fortipes' OR junior_species='fortipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecilus' AND (species='fortipes' OR species='fortipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecilus' AND (species='fortipes' OR species='fortipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='fortipes' OR junior_species='fortipes')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='Poecilus' AND (species='fortipes' OR species='fortipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='interruptus' OR junior_species='interruptus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='interruptus' OR species='interruptus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='interruptus' OR species='interruptus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='interruptus' OR junior_species='interruptus')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='Pterostichus' AND (species='interruptus' OR species='interruptus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='adstrictus' OR junior_species='adstrictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='adstrictus' OR species='adstrictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='adstrictus' OR species='adstrictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='adstrictus' OR junior_species='adstrictus')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='Pterostichus' AND (species='adstrictus' OR species='adstrictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='dilutipes' OR junior_species='dilutipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='dilutipes' OR species='dilutipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='dilutipes' OR species='dilutipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='dilutipes' OR junior_species='dilutipes')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='Pterostichus' AND (species='dilutipes' OR species='dilutipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='montanus' OR junior_species='montanus')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='Pterostichus' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='dauricus' OR junior_species='dauricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='dauricus' OR species='dauricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='dauricus' OR species='dauricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='dauricus' OR junior_species='dauricus')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='Pterostichus' AND (species='dauricus' OR species='dauricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='eximius' OR junior_species='eximius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='eximius' OR species='eximius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='eximius' OR species='eximius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='eximius' OR junior_species='eximius')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='Pterostichus' AND (species='eximius' OR species='eximius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curtonotus' AND (junior_species='hyperboreus' OR junior_species='hyperboreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curtonotus' AND (species='hyperboreus' OR species='hyperboreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curtonotus' AND (species='hyperboreus' OR species='hyperboreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curtonotus' AND (junior_species='hyperboreus' OR junior_species='hyperboreus')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='Curtonotus' AND (species='hyperboreus' OR species='hyperboreus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1556 The Ecological Register: Indola River (biotope 1)
Indola River (biotope 1)
Basic information
Sample name: Indola River (biotope 1)

Reference: L. T. Khobrakova. 2008. Ground-beetle (Coleoptera, Carabidae) assemblages in the forest-steppe of the southern Vitim Plateau. Entomological Review 87(2):313-324 [ER 1050]
Geography
Country: Russia

State: Buryatia


Coordinate: 52° 31' N, 111° 32' E
Coordinate basis: based on political unit

Geography comments: "in Eravninskaya (Sosnovoozerskaya) Depression in the south of Vitim Plateau in the valley of the Indola River near its flow into Lake Bolshaya Eravna... 12 km to the west from Sosnovo-Ozerskoe Village (Eravninsk District, Buryatia)" (coordinate based on Yeravninsky District)
altitude 950 to 1520 m

•
Environment
Habitat: boreal forest/taiga

Substrate: ground surface

Habitat comments: "entirely in the taiga zone... completely covered with larch (Larix daurica) forests, excluding its southern part, where forest-steppe areas are found"
this site is within "taiga of intramountain depressions"

Methods
Life forms: ground beetles

Sites: 1

Sampling methods: no design,pitfall traps

Sample size: 503 individuals

Years: 2004

Days: 113

Seasons: spring,summer,autumn

Nets or traps: 10

Net or trap nights: 1130

Sampling comments: "Samples were taken once per week"

Metadata
Sample number: 1556

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-17 16:41:42

Modified: 2015-05-17 06:41:42

Abundance distribution
12 species
1 singleton
total count 503
extrapolated richness: 14.3
Fisher's α: 2.209
geometric series k: 0.6276
Hurlbert's PIE: 0.8210
Shannon's H: 1.9963
Good's u: 0.9980
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Carabus arcensis conciliator23
Carabus billbergi37
Carabus hummeli48
Carabus canaliculatus82
Poecilus fortipes9
Pterostichus interruptus35
Pterostichus adstrictus9
Pterostichus dilutipes63
Pterostichus montanus1
Pterostichus dauricus168
Pterostichus eximius26
Curtonotus hyperboreus2