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=2633 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2633SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2418SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2633 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occitanomys' AND (junior_species='alcalai' OR junior_species='alcalaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Occitanomys' AND (species='alcalai' OR species='alcalaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Occitanomys' AND (species='alcalai' OR species='alcalaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occitanomys' AND (junior_species='alcalai' OR junior_species='alcalaii')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='alcalai' OR species='alcalaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraethomys' 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='Paraethomys' AND (species='meini' OR species='meinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraethomys' AND (species='meini' OR species='meinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraethomys' 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='Paraethomys' AND (species='meini' OR species='meinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanomys' AND (junior_species='dubari' OR junior_species='dubarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanomys' AND (species='dubari' OR species='dubarii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanomys' AND (species='dubari' OR species='dubarii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanomys' AND (junior_species='dubari' OR junior_species='dubarii')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='Stephanomys' AND (species='dubari' OR species='dubarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apocricetus' 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='Apocricetus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apocricetus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apocricetus' 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='Apocricetus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruscinomys' AND (junior_species='schaubi' OR junior_species='schaubii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ruscinomys' AND (species='schaubi' OR species='schaubii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruscinomys' AND (species='schaubi' OR species='schaubii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruscinomys' AND (junior_species='schaubi' OR junior_species='schaubii')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='Ruscinomys' AND (species='schaubi' OR species='schaubii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='truci' OR junior_species='trucii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eliomys' AND (species='truci' OR species='trucii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eliomys' AND (species='truci' OR species='trucii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='truci' OR junior_species='trucii')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='Eliomys' AND (species='truci' OR species='trucii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' 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='Eliomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eliomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' 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='Eliomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='vireti' OR junior_species='viretii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscardinus' AND (species='vireti' OR species='viretii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscardinus' AND (species='vireti' OR species='viretii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='vireti' OR junior_species='viretii')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='vireti' OR species='viretii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' 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='Heteroxerus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' 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='Heteroxerus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' 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='Myotis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' 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='Myotis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='fossilis' OR junior_species='fossilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miniopterus' AND (species='fossilis' OR species='fossilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miniopterus' AND (species='fossilis' OR species='fossilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='fossilis' OR junior_species='fossilis')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='Miniopterus' AND (species='fossilis' OR species='fossilis') ORDER BY year,last_namesSELECT 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='Parasorex' AND (junior_species='ibericus' OR junior_species='ibericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parasorex' AND (species='ibericus' OR species='ibericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parasorex' AND (species='ibericus' OR species='ibericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parasorex' AND (junior_species='ibericus' OR junior_species='ibericus')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='Parasorex' AND (species='ibericus' OR species='ibericus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2633 The Ecological Register: ACB MB
ACB MB
Basic information
Sample name: ACB MB

Sample aka: Almenara MB

Reference: S. Mansino, V. D. Crespo, M. Lázaro, F. J. Ruiz-Sánchez, J. Abella, and P. Montoya. 2016. Fossil micromammals of the early Pliocene locality of Almenara MB: biostratigraphical and palaeoecological implications. Spanish Journal of Palaeontology 31(2):253-270 [ER 2418]
Geography
Country: Spain

State: Castellón


Coordinate: 39° 45' N, 0° 14' W
Coordinate basis: based on nearby landmark

Time interval: Early Pliocene

Zone: MN14

Age basis: zone

Geography comments: "in the vicinity of the locality of Almenara" (coordinate based on Almenara)
"MN14... earliest Ruscinian"

Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: "fissure infilling": shown in Fig. 2 to be from a horizon of "clays"

Methods
Life forms: bats,rodents,other small mammals

Sampling methods: screenwash

Sample size: 93 specimens

Years: 2007

Sampling comments: "we extracted 250 kg of sediment" (almost certainly meaning the sample was screenwashed)

Metadata
Sample number: 2633

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-21 19:22:16

Modified: 2023-09-11 10:29:44

Abundance distribution
13 species
5 singletons
total count 93
extrapolated richness: 24.3
Fisher's α: 4.111
geometric series k: 0.7532
Hurlbert's PIE: 0.8288
Shannon's H: 2.0644
Good's u: 0.9462
Each square represents a species. Square sizes are proportional to counts.
Register