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=2566 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2566SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2384SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2566 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='uenayae' OR junior_species='uenayae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galerix' AND (species='uenayae' OR species='uenayae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galerix' AND (species='uenayae' OR species='uenayae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='uenayae' OR junior_species='uenayae')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='Galerix' AND (species='uenayae' OR species='uenayae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schizogalerix' AND (junior_species='evae' OR junior_species='evae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schizogalerix' AND (species='evae' OR species='evae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schizogalerix' AND (species='evae' OR species='evae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schizogalerix' AND (junior_species='evae' OR junior_species='evae')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='Schizogalerix' AND (species='evae' OR species='evae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanodon' AND (junior_species='burkarti' OR junior_species='burkartii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmanodon' AND (species='burkarti' OR species='burkartii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desmanodon' AND (species='burkarti' OR species='burkartii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanodon' AND (junior_species='burkarti' OR junior_species='burkartii')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='Desmanodon' AND (species='burkarti' OR species='burkartii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Soricidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' AND (junior_species='indet.' OR junior_species='indet.')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='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotonidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochotonidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotonidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotonidae' AND (junior_species='indet.' OR junior_species='indet.')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='Ochotonidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steneofiber' AND (junior_species='eseri' OR junior_species='eserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steneofiber' AND (species='eseri' OR species='eserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steneofiber' AND (species='eseri' OR species='eserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steneofiber' AND (junior_species='eseri' OR junior_species='eserii')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='Steneofiber' AND (species='eseri' OR species='eserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Debruijnia' AND (junior_species='arpati' OR junior_species='arpatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Debruijnia' AND (species='arpati' OR species='arpatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Debruijnia' AND (species='arpati' OR species='arpatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Debruijnia' AND (junior_species='arpati' OR junior_species='arpatii')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='Debruijnia' AND (species='arpati' OR species='arpatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetodon' AND (junior_species='kasapligili' OR junior_species='kasapligilii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetodon' AND (species='kasapligili' OR species='kasapligilii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cricetodon' AND (species='kasapligili' OR species='kasapligilii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetodon' AND (junior_species='kasapligili' OR junior_species='kasapligilii')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='Cricetodon' AND (species='kasapligili' OR species='kasapligilii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' 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='Eumyarion' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' 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='Eumyarion' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='orhani' OR junior_species='orhanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyarion' AND (species='orhani' OR species='orhanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='orhani' OR species='orhanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='orhani' OR junior_species='orhanii')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='orhani' OR species='orhanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='intercentralis' OR junior_species='intercentralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyarion' AND (species='intercentralis' OR species='intercentralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='intercentralis' OR species='intercentralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='intercentralis' OR junior_species='intercentralis')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='intercentralis' OR species='intercentralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mirabella' 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='Mirabella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mirabella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mirabella' 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='Mirabella' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='doukasi' OR junior_species='doukasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='doukasi' OR species='doukasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='doukasi' OR species='doukasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='doukasi' OR junior_species='doukasii')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='Democricetodon' AND (species='doukasi' OR species='doukasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallaris' AND (junior_species='zappai' OR junior_species='zappaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vallaris' AND (species='zappai' OR species='zappaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vallaris' AND (species='zappai' OR species='zappaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallaris' AND (junior_species='zappai' OR junior_species='zappaii')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='Vallaris' AND (species='zappai' OR species='zappaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='engesseri' OR junior_species='engesserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='engesseri' OR species='engesserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='engesseri' OR species='engesserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='engesseri' OR junior_species='engesserii')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='Glirudinus' AND (species='engesseri' OR species='engesserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='galitopouli' OR junior_species='galitopoulii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glis' AND (species='galitopouli' OR species='galitopoulii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glis' AND (species='galitopouli' OR species='galitopoulii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='galitopouli' OR junior_species='galitopoulii')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='Glis' AND (species='galitopouli' OR species='galitopoulii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='fissurae' OR junior_species='fissurae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='fissurae' OR species='fissurae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='fissurae' OR species='fissurae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='fissurae' OR junior_species='fissurae')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='Palaeosciurus' AND (species='fissurae' OR species='fissurae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2566 The Ecological Register: Sabuncubeli
Sabuncubeli
Basic information
Sample name: Sabuncubeli

Reference: H. de Bruijn, S. Mayda, L. van den Hoek Ostende, T. Kaya, and G. Sarac. 2006. Small mammals from the Early Miocene of Sabuncubeli (Manisa, S.W. Anatolia, Turkey). Beiträge zur Paläontologie 30:57-87 [ER 2384]
Geography
Country: Turkey


Coordinate: 38° 35' N, 27° 19' E
Coordinate basis: based on nearby landmark

Formation: Sabuncubeli

Time interval: Early Miocene

Zone: MN3

Unit number: 1

Unit order: below to above

Ma: 19

Geography comments: "along the forest road that leads from the main road between Manisa and Bornova to the village of Sarnic" (coordinate is the midpoint of coordinates for Manisa and Bornova)
"in the lower part of MN 3" (i.e., roughly 19 Ma)
stratigraphically below Bornova 183 within the Sabuncubeli Formation (not the Soma Formation, see Bilgin et al. 2019)

Environment
Substrate: ground surface

Lithology: mudstone

Habitat comments: "grey coloured sandy mud rocks of the lower part of the Soma Formation"

Methods
Life forms: rodents,other small mammals

Sampling methods: screenwash

Sample size: 430 specimens

Years: 1998, 2000 - 2004

Sampling comments: "wet screening of the matrix on a 0.5 mm mesh... not all the fine fraction could be sorted... A second collection (SBb) from the same level, but some twenty five metres to the East of the original site was made in 2005 from the fine grained upper part of the fossiliferous bed... The concentrate of this second collection has been sorted to the 0.8 mm fraction"
unspecified "large mammals" are also present
revised counts of the rodents based on an augmented sample are given by Bilgin et al. (2019), but new counts for the remaining small mammals are not given, so the original ones are used here

Metadata
Sample number: 2566

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-16 21:16:14

Modified: 2023-09-13 07:11:28

Abundance distribution
17 species
2 singletons
total count 430
extrapolated richness: 21.2
Fisher's α: 3.535
geometric series k: 0.7508
Hurlbert's PIE: 0.8687
Shannon's H: 2.2860
Good's u: 0.9953
Each square represents a species. Square sizes are proportional to counts.
Register