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=4405 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4405SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3990SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4405 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheirogaster' AND (junior_species='schafferi' OR junior_species='schafferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cheirogaster' AND (species='schafferi' OR species='schafferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cheirogaster' AND (species='schafferi' OR species='schafferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheirogaster' AND (junior_species='schafferi' OR junior_species='schafferii')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='Cheirogaster' AND (species='schafferi' OR species='schafferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradolichopithecus' AND (junior_species='arvernensis' OR junior_species='arvernensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradolichopithecus' AND (species='arvernensis' OR species='arvernensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paradolichopithecus' AND (species='arvernensis' OR species='arvernensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradolichopithecus' AND (junior_species='arvernensis' OR junior_species='arvernensis')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='Paradolichopithecus' AND (species='arvernensis' OR species='arvernensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='megamastoides' OR junior_species='megamastoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctereutes' AND (species='megamastoides' OR species='megamastoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctereutes' AND (species='megamastoides' OR species='megamastoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='megamastoides' OR junior_species='megamastoides')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='Nyctereutes' AND (species='megamastoides' OR species='megamastoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='thorali' OR junior_species='thoralii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='thorali' OR species='thoralii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meles' AND (species='thorali' OR species='thoralii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='thorali' OR junior_species='thoralii')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='Meles' AND (species='thorali' OR species='thoralii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelidae' 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='Mustelidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustelidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelidae' 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='Mustelidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felidae' 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='Felidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felidae' 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='Felidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felidae' 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='Felidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felidae' 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='Felidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canidae' 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='Canidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canidae' 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='Canidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anancus' AND (junior_species='arvernensis' OR junior_species='arvernensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anancus' AND (species='arvernensis' OR species='arvernensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anancus' AND (species='arvernensis' OR species='arvernensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anancus' AND (junior_species='arvernensis' OR junior_species='arvernensis')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='Anancus' AND (species='arvernensis' OR species='arvernensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='stenonis' OR junior_species='stenonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='stenonis' OR species='stenonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='stenonis' OR species='stenonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='stenonis' OR junior_species='stenonis')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='Equus' AND (species='stenonis' OR species='stenonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacervoceros' AND (junior_species='rhenanus' OR junior_species='rhenanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metacervoceros' AND (species='rhenanus' OR species='rhenanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metacervoceros' AND (species='rhenanus' OR species='rhenanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacervoceros' AND (junior_species='rhenanus' OR junior_species='rhenanus')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='Metacervoceros' AND (species='rhenanus' OR species='rhenanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeotragus' AND (junior_species='inexspectatus' OR junior_species='inexspectatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeotragus' AND (species='inexspectatus' OR species='inexspectatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeotragus' AND (species='inexspectatus' OR species='inexspectatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeotragus' AND (junior_species='inexspectatus' OR junior_species='inexspectatus')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='Palaeotragus' AND (species='inexspectatus' OR species='inexspectatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='aegaea' OR junior_species='aegaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='aegaea' OR species='aegaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='aegaea' OR species='aegaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='aegaea' OR junior_species='aegaea')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='Gazella' AND (species='aegaea' OR species='aegaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='bouvrainae' OR junior_species='bouvrainae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='bouvrainae' OR species='bouvrainae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='bouvrainae' OR species='bouvrainae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='bouvrainae' OR junior_species='bouvrainae')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='Gazella' AND (species='bouvrainae' OR species='bouvrainae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='borbonica' OR junior_species='borbonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='borbonica' OR species='borbonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='borbonica' OR species='borbonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='borbonica' OR junior_species='borbonica')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='Gazella' AND (species='borbonica' OR species='borbonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilopini' 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='Antilopini' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antilopini' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilopini' 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='Antilopini' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazellospira' AND (junior_species='torticornis' OR junior_species='torticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazellospira' AND (species='torticornis' OR species='torticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazellospira' AND (species='torticornis' OR species='torticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazellospira' AND (junior_species='torticornis' OR junior_species='torticornis')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='Gazellospira' AND (species='torticornis' OR species='torticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptobos' 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='Leptobos' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptobos' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptobos' 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='Leptobos' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4405 The Ecological Register: Vatera (F-site)
Vatera (F-site)
Basic information
Sample name: Vatera (F-site)

Reference: J. de Vos, J. van der Made, A. Athanassiou, G. Lyras, P. Y. Sondaar, and M. D. Dermitzakis. 2002. Preliminary note on the Late Pliocene fauna from Vatera (Lesvos, Greece). Annales Géologiques de Pays Helléniques 39(A):37-70 [ER 3990]
Geography
Country: Greece


Coordinate: 39.03° N, 26.19° E
Coordinate basis: estimated from map

Formation: Vatera

Time interval: Early Pleistocene

Zone: MN17

Geography comments: "at the south part of Lesvos Island" (shown on a map as between Vatera and Vrissa, basis of coordinate) and from "within the upper unit of the Vatera Formation" (Lyras and van der Geer 2007)
thought to be "Late Pliocene" by the original authors and "MN 17 (about 2 Ma)" according to Lyras and van der Geer (2007)

•
Environment
Lithology: claystone

Taphonomic context: fluvial deposit

Habitat comments: the formation is "fluvial" and "All fossils were found within the sandy clay layers"

Methods
Life forms: carnivores,primates,ungulates,birds,turtles

Sampling methods: quarry

Sample size: 63 specimens

Years: 1997 - 1999

Sampling comments: "found following the construction of a track" with "in situ" specimens recovered in 1997, 1998, and 1999, with another excavation in 2000 failing to obtain specimens

Metadata
Sample number: 4405

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-12-10 22:15:26

Modified: 2023-12-10 11:15:26

Abundance distribution
18 species
10 singletons
total count 63
extrapolated richness: 50.1
Fisher's α: 8.419
geometric series k: 0.8527
Hurlbert's PIE: 0.8794
Shannon's H: 2.4366
Good's u: 0.8413
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cheirogaster aff. schafferi9
"Chelonia": see Lyras and van der Geer (2007)
Paradolichopithecus arvernensis15
Nyctereutes megamastoides1
Meles thorali1
Mustelidae indet.1
otter-sized
Felidae indet. large1
compared to Lynx issiodorensis and Acinonyx pardinensis
Felidae indet. small1
compared to "a wild cat"
Canidae indet.1
Anancus cf. arvernensis1
Equus cf. stenonis5
Metacervoceros cf. rhenanus5
"Dama cf. rhenana"
Palaeotragus cf. inexspectatus8
"Mitilanotherium cf. inexpectatum": see Athanassiou (2014)
Gazella aegaea1
horn core type A: named by Athanassiou (2002)
Gazella cf. bouvrainae1
horn corn type B
Gazella aff. borbonica4
horn core type C
Antilopini indet.4
horn core type D: "possibly neotragine"
Gazellospira cf. torticornis3
Leptobos sp.1
compared to this genus