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=2499 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2499SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2338SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2499 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asoriculus' AND (junior_species='gibberodon' OR junior_species='gibberodon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asoriculus' AND (species='gibberodon' OR species='gibberodon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asoriculus' AND (species='gibberodon' OR species='gibberodon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asoriculus' AND (junior_species='gibberodon' OR junior_species='gibberodon')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='Asoriculus' AND (species='gibberodon' OR species='gibberodon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deinsdorfia' AND (junior_species='kerkhoffi' OR junior_species='kerkhoffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deinsdorfia' AND (species='kerkhoffi' OR species='kerkhoffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deinsdorfia' AND (species='kerkhoffi' OR species='kerkhoffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deinsdorfia' AND (junior_species='kerkhoffi' OR junior_species='kerkhoffii')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='Deinsdorfia' AND (species='kerkhoffi' OR species='kerkhoffii') 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='Leporidae' 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='Leporidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leporidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporidae' 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='Leporidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='michauxi' OR junior_species='michauxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prolagus' AND (species='michauxi' OR species='michauxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagus' AND (species='michauxi' OR species='michauxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='michauxi' OR junior_species='michauxii')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='Prolagus' AND (species='michauxi' OR species='michauxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliopetaurista' AND (junior_species='dehneli' OR junior_species='dehnelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pliopetaurista' AND (species='dehneli' OR species='dehnelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pliopetaurista' AND (species='dehneli' OR species='dehnelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliopetaurista' AND (junior_species='dehneli' OR junior_species='dehnelii')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='Pliopetaurista' AND (species='dehneli' OR species='dehnelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myomimus' AND (junior_species='maritsensis' OR junior_species='maritsensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myomimus' AND (species='maritsensis' OR species='maritsensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myomimus' AND (species='maritsensis' OR species='maritsensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myomimus' AND (junior_species='maritsensis' OR junior_species='maritsensis')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='Myomimus' AND (species='maritsensis' OR species='maritsensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murinae' 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='Murinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Murinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murinae' 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='Murinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occitanomys' AND (junior_species='adroveri' OR junior_species='adroverii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Occitanomys' AND (species='adroveri' OR species='adroverii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Occitanomys' AND (species='adroveri' OR species='adroverii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occitanomys' AND (junior_species='adroveri' OR junior_species='adroverii')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='Occitanomys' AND (species='adroveri' OR species='adroverii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='gorafensis' OR junior_species='gorafensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='gorafensis' OR species='gorafensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='gorafensis' OR species='gorafensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='gorafensis' OR junior_species='gorafensis')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='Apodemus' AND (species='gorafensis' OR species='gorafensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='dominans' OR junior_species='dominans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='dominans' OR species='dominans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='dominans' OR species='dominans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='dominans' OR junior_species='dominans')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='Apodemus' AND (species='dominans' OR species='dominans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhagapodemus' AND (junior_species='primaevus' OR junior_species='primaevus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhagapodemus' AND (species='primaevus' OR species='primaevus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhagapodemus' AND (species='primaevus' OR species='primaevus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhagapodemus' AND (junior_species='primaevus' OR junior_species='primaevus')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='Rhagapodemus' AND (species='primaevus' OR species='primaevus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micromys' AND (junior_species='steffensi' OR junior_species='steffensii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micromys' AND (species='steffensi' OR species='steffensii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micromys' AND (species='steffensi' OR species='steffensii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micromys' AND (junior_species='steffensi' OR junior_species='steffensii')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='steffensi' OR species='steffensii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesocricetus' AND (junior_species='primitivus' OR junior_species='primitivus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesocricetus' AND (species='primitivus' OR species='primitivus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesocricetus' AND (species='primitivus' OR species='primitivus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesocricetus' AND (junior_species='primitivus' OR junior_species='primitivus')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='Mesocricetus' AND (species='primitivus' OR species='primitivus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliospalax' 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='Pliospalax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pliospalax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliospalax' 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='Pliospalax' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomeriones' AND (junior_species='rhodius' OR junior_species='rhodius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomeriones' AND (species='rhodius' OR species='rhodius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomeriones' AND (species='rhodius' OR species='rhodius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomeriones' AND (junior_species='rhodius' OR junior_species='rhodius')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='Pseudomeriones' AND (species='rhodius' OR species='rhodius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2499 The Ecological Register: Kessani
Kessani
Basic information
Sample name: Kessani

Sample aka: KES

Reference: K. Vasileiadou, G. Konidaris, and G. D. Koufos. 2012. New data on the micromammalian locality of Kessani (Thrace, Greece) at the Mio-Pliocene boundary. Palaeobiodiversity and Palaeoenvironments 92:211-237 [ER 2338]
Geography
Country: Greece


Coordinate: 41.03° N, 25.07° E
Coordinate basis: based on nearby landmark

Time interval: Late Miocene

Zone: MN13

Ma: 5.3

Geography comments: "on the south-western coast of Lake Vistonis" (coordinate based on Nea Kessani)
"best correlated with the latest Turolian/earliest Ruscinian (MN 13/14 boundary" but indicated in Fig. 15 as being just below the boundary

Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: "an argillaceous bed at the upper part of the section"

Methods
Life forms: rodents,other small mammals

Sample size: 112 specimens

Years: 1997

Sampling comments: "The micromammalian material was collected from two different spots of the fossiliferous layer (named KES-1 and KES-2), but later a few more teeth were collected from a third spot (KES-3). These three different spots have a distance of about 2–3 m between them"
collection methods not discussed

Metadata
Sample number: 2499

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-12 20:10:34

Modified: 2017-02-17 02:42:55

Abundance distribution
16 species
1 singleton
total count 112
extrapolated richness: 23.3
Fisher's α: 5.108
geometric series k: 0.7875
Hurlbert's PIE: 0.8353
Shannon's H: 2.2420
Good's u: 0.9915
Each square represents a species. Square sizes are proportional to counts.
Register