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
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äontologie30: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.