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=2534 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2534SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2361SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2534 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogontherium' AND (junior_species='minutum' OR junior_species='minutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogontherium' AND (species='minutum' OR species='minutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogontherium' AND (species='minutum' OR species='minutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogontherium' AND (junior_species='minutum' OR junior_species='minutum')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='Trogontherium' AND (species='minutum' OR species='minutum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='bredai' OR junior_species='bredaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilinus' AND (species='bredai' OR species='bredaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilinus' AND (species='bredai' OR species='bredaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='bredai' OR junior_species='bredaii')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='Spermophilinus' AND (species='bredai' OR species='bredaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albanensia' AND (junior_species='grimmi' OR junior_species='grimmii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albanensia' AND (species='grimmi' OR species='grimmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albanensia' AND (species='grimmi' OR species='grimmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albanensia' AND (junior_species='grimmi' OR junior_species='grimmii')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='Albanensia' AND (species='grimmi' OR species='grimmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylopetes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylopetes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylopetes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylopetes' AND (junior_species='sp.' OR junior_species='sp.')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='Hylopetes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blackia' AND (junior_species='miocaenica' OR junior_species='miocaenica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blackia' AND (species='miocaenica' OR species='miocaenica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blackia' AND (species='miocaenica' OR species='miocaenica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blackia' AND (junior_species='miocaenica' OR junior_species='miocaenica')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='Blackia' AND (species='miocaenica' OR species='miocaenica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='sansaniensis' OR junior_species='sansaniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscardinus' AND (species='sansaniensis' OR species='sansaniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscardinus' AND (species='sansaniensis' OR species='sansaniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='sansaniensis' OR junior_species='sansaniensis')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='Muscardinus' AND (species='sansaniensis' OR species='sansaniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscardinus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscardinus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='sp.' OR junior_species='sp.')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='Muscardinus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirulus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirulus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' AND (junior_species='sp.' OR junior_species='sp.')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='Glirulus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraglirulus' AND (junior_species='werenfelsi' OR junior_species='werenfelsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraglirulus' AND (species='werenfelsi' OR species='werenfelsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraglirulus' AND (species='werenfelsi' OR species='werenfelsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraglirulus' AND (junior_species='werenfelsi' OR junior_species='werenfelsii')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='Paraglirulus' AND (species='werenfelsi' OR species='werenfelsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myoglis' AND (junior_species='meini' OR junior_species='meinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myoglis' AND (species='meini' OR species='meinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myoglis' AND (species='meini' OR species='meinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myoglis' AND (junior_species='meini' OR junior_species='meinii')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='Myoglis' AND (species='meini' OR species='meinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyops' AND (junior_species='oppligeri' OR junior_species='oppligerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomyops' AND (species='oppligeri' OR species='oppligerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomyops' AND (species='oppligeri' OR species='oppligerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyops' AND (junior_species='oppligeri' OR junior_species='oppligerii')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='Eomyops' AND (species='oppligeri' OR species='oppligerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Keramidomys' AND (junior_species='mohleri' OR junior_species='mohlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Keramidomys' AND (species='mohleri' OR species='mohlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Keramidomys' AND (species='mohleri' OR species='mohlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Keramidomys' AND (junior_species='mohleri' OR junior_species='mohlerii')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='Keramidomys' AND (species='mohleri' OR species='mohlerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' 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='Megacricetodon' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' 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='Megacricetodon' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='medius' OR junior_species='medius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyarion' AND (species='medius' OR species='medius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='medius' OR species='medius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='medius' OR junior_species='medius')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='Eumyarion' AND (species='medius' OR species='medius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Collimys' AND (junior_species='dobosi' OR junior_species='dobosii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Collimys' AND (species='dobosi' OR species='dobosii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Collimys' AND (species='dobosi' OR species='dobosii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Collimys' AND (junior_species='dobosi' OR junior_species='dobosii')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='Collimys' AND (species='dobosi' OR species='dobosii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalomys' AND (junior_species='gaudryi' OR junior_species='gaudryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anomalomys' AND (species='gaudryi' OR species='gaudryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anomalomys' AND (species='gaudryi' OR species='gaudryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalomys' AND (junior_species='gaudryi' OR junior_species='gaudryii')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='Anomalomys' AND (species='gaudryi' OR species='gaudryii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2534 The Ecological Register: Felsotarkany 3/2
Felsotarkany 3/2
Basic information
Sample name: Felsotarkany 3/2

Reference: J. Hír. 2004. The Middle Miocene (late Astaracian, MN7-8) rodent fauna of Felsotarkany 3/2 (Hungary). Acta Palaeontologica Romaniae 4:125-136 [ER 2361]
Geography
Country: Hungary


Coordinate: 47.97° N, 20.42° E
Coordinate basis: based on nearby landmark

Time interval: Middle Miocene

Zone: MN7/8

Geography comments: "in an erosional trench 80 m NE from the yard of the wine bottling manufactory 'Vitavin Kft.'." (coordinate based on Felsotarkany)
"late MN 7-8"

Environment
Substrate: ground surface

Habitat comments: no details given

Methods
Life forms: rodents

Sampling methods: screenwash

Sample size: 748 specimens

Years: 2000 - 2002

Sampling comments: "During the last 3 years 8 tones of sediment were washed"

Metadata
Sample number: 2534

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-14 19:08:28

Modified: 2023-09-08 11:54:31

Abundance distribution
16 species
1 singleton
total count 748
extrapolated richness: 18.8
Fisher's α: 2.875
geometric series k: 0.6699
Hurlbert's PIE: 0.6715
Shannon's H: 1.6981
Good's u: 0.9987
Each square represents a species. Square sizes are proportional to counts.
Register