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=3566 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3566SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3239SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3566 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='araneus' OR junior_species='araneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='araneus' OR species='araneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='araneus' OR species='araneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='araneus' OR junior_species='araneus')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='Sorex' AND (species='araneus' OR species='araneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='isodon' OR junior_species='isodon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='isodon' OR species='isodon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='isodon' OR species='isodon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='isodon' OR junior_species='isodon')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='Sorex' AND (species='isodon' OR species='isodon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')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='Sorex' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='caecutiens' OR junior_species='caecutiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='caecutiens' OR species='caecutiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='caecutiens' OR species='caecutiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='caecutiens' OR junior_species='caecutiens')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='Sorex' AND (species='caecutiens' OR species='caecutiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neomys' AND (species='fodiens' OR species='fodiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')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='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicista' AND (junior_species='betulina' OR junior_species='betulina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sicista' AND (species='betulina' OR species='betulina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sicista' AND (species='betulina' OR species='betulina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicista' AND (junior_species='betulina' OR junior_species='betulina')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='Sicista' AND (species='betulina' OR species='betulina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='glareolus' OR junior_species='glareolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='glareolus' OR species='glareolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myodes' AND (species='glareolus' OR species='glareolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='glareolus' OR junior_species='glareolus')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='Myodes' AND (species='glareolus' OR species='glareolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='rutilus' OR junior_species='rutilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='rutilus' OR species='rutilus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='rutilus' OR junior_species='rutilus')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='Myodes' AND (species='rutilus' OR species='rutilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='agrestis' OR species='agrestis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')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='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')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='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micromys' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micromys' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micromys' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micromys' AND (junior_species='minutus' OR junior_species='minutus')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='Micromys' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3566 The Ecological Register: Malaya Gomsel'ga
Malaya Gomsel'ga
Basic information
Sample name: Malaya Gomsel'ga

Reference: L. A. Bespyatova, E. P. Ieshko, E. V. Ivanter, and S. V. Bugmyrin. 2006. Long-term population dynamics of ixodid ticks and development of tick-borne encephalitis foci under conditions of the middle taiga subzone. Russian Journal of Ecology 37(5):325-329 [ER 3239]
Geography
Country: Russia


Coordinate: 62° 4' N, 33° 55' E
Coordinate basis: stated in text

Geography comments: "near the village of Malaya Gomsel'ga (Kondopozhskii raion of Karelia) located 60 km north of Petrozavodsk"

Environment
Habitat: boreal forest/taiga

Protection: unprotected

Substrate: ground surface

Habitat comments: "taiga"

Methods
Life forms: rodents,other small mammals

Sampling methods: pitfall traps,other traps

Sample size: 880 specimens

Years: 1995 - 2003

Seasons: spring,summer,autumn

Sampling comments: material was collected in "May-August and October 1995-2003"
small mammals were "caught with Gero crush traps arranged in line and with pitfall traps installed in a trench"
no further details are given

Metadata
Sample number: 3566

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-12-23 20:28:03

Modified: 2019-12-23 09:28:03

Abundance distribution
11 species
2 singletons
total count 880
extrapolated richness: 15.2
Fisher's α: 1.771
geometric series k: 0.5457
Hurlbert's PIE: 0.6395
Shannon's H: 1.3097
Good's u: 0.9977
Each square represents a species. Square sizes are proportional to counts.
Register
Sorex araneus303
Sorex isodon10
Sorex minutus24
Sorex caecutiens3
Neomys fodiens1
Sicista betulina31
Myodes glareolus427
"Clethrionomys glareolus"
Myodes rutilus119.5 g
"Clethrionomys rutilus"
Microtus agrestis37
Alexandromys oeconomus4136.5 g
"Microtus oeconomus"
Micromys minutus2
"Microtus minutus"