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=4326 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4326SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3925SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4326 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protechimys' AND (junior_species='lebratierensis' OR junior_species='lebratierensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protechimys' AND (species='lebratierensis' OR species='lebratierensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protechimys' AND (species='lebratierensis' OR species='lebratierensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protechimys' AND (junior_species='lebratierensis' OR junior_species='lebratierensis')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='Protechimys' AND (species='lebratierensis' OR species='lebratierensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caenomeryx' 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='Caenomeryx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caenomeryx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caenomeryx' 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='Caenomeryx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophiomeryx' AND (junior_species='chalaniati' OR junior_species='chalaniatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophiomeryx' AND (species='chalaniati' OR species='chalaniatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophiomeryx' AND (species='chalaniati' OR species='chalaniatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophiomeryx' AND (junior_species='chalaniati' OR junior_species='chalaniatii')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='Lophiomeryx' AND (species='chalaniati' OR species='chalaniatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gelocus' 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='Gelocus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gelocus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gelocus' 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='Gelocus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metriotherium' AND (junior_species='mirabile' OR junior_species='mirabile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metriotherium' AND (species='mirabile' OR species='mirabile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metriotherium' AND (species='mirabile' OR species='mirabile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metriotherium' AND (junior_species='mirabile' OR junior_species='mirabile')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='Metriotherium' AND (species='mirabile' OR species='mirabile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entelodon' 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='Entelodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entelodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entelodon' 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='Entelodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthracotherium' 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='Anthracotherium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthracotherium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthracotherium' 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='Anthracotherium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protaceratherium' AND (junior_species='albigense' OR junior_species='albigense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protaceratherium' AND (species='albigense' OR species='albigense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protaceratherium' AND (species='albigense' OR species='albigense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protaceratherium' AND (junior_species='albigense' OR junior_species='albigense')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='Protaceratherium' AND (species='albigense' OR species='albigense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eggysodon' AND (junior_species='gaudryi' OR junior_species='gaudryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eggysodon' AND (species='gaudryi' OR species='gaudryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eggysodon' AND (species='gaudryi' OR species='gaudryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eggysodon' AND (junior_species='gaudryi' OR junior_species='gaudryii')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='Eggysodon' AND (species='gaudryi' OR species='gaudryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nimravus' AND (junior_species='intermedius' OR junior_species='intermedius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nimravus' AND (species='intermedius' OR species='intermedius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nimravus' AND (species='intermedius' OR species='intermedius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nimravus' AND (junior_species='intermedius' OR junior_species='intermedius')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='Nimravus' AND (species='intermedius' OR species='intermedius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' AND (junior_species='dubius' OR junior_species='dubius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyaenodon' AND (species='dubius' OR species='dubius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyaenodon' AND (species='dubius' OR species='dubius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' AND (junior_species='dubius' OR junior_species='dubius')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='Hyaenodon' AND (species='dubius' OR species='dubius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' AND (junior_species='leptorhyncus' OR junior_species='leptorhyncus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyaenodon' AND (species='leptorhyncus' OR species='leptorhyncus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyaenodon' AND (species='leptorhyncus' OR species='leptorhyncus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' AND (junior_species='leptorhyncus' OR junior_species='leptorhyncus')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='Hyaenodon' AND (species='leptorhyncus' OR species='leptorhyncus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4326 The Ecological Register: Moissac-IV
Moissac-IV
Basic information
Sample name: Moissac-IV

Reference: P.-O. Antoine, G. Métais, M. J. Orliac, S. Peigné, S. Rafay, F. Solé, and M. Vianey-Liaud. 2011. A new late Early Oligocene vertebrate fauna from Moissac, South-West France. Comptes Rendus Palevol 10:239-250 [ER 3925]
Geography
Country: France

State: Occitania


Coordinate: 44.12582° N, 1.134524° E
Coordinate basis: estimated from map

Formation: Middle Garonne Basin

Time interval: Early Oligocene

Zone: MP24

Age basis: zone

Geography comments: Moissac-IV is situated northeast of the town of Moissac, Tarn-et-Garonne two the west of the well-known Phosphorites of Quercy area

Exact coordinates are not provided therefore given coordinates are estimated

Faunal composition indicates a correlation with MP24

Environment
Lithology: sandstone

Taphonomic context: fluvial deposit

Habitat comments: "Consists of a lens of unconsolidated and massive grey fluvial sands"

Most specimens are "complete and well-preserved" with some exhibiting erosion or crushing

Methods
Life forms: carnivores,rodents,ungulates,other large mammals

Sampling methods: quarry

Sample size: 44 specimens

Years: 2007, 2008, 2009, 2010

Sampling comments: 166 identifiable specimens were recovered consisting of 12 terrestrial mammal species

"Several isolated teeth" are described for the following taxa:
Protaceratherium albigense
Eggysodon gaudryi

Metadata
Sample number: 4326

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-07-07 13:59:31

Modified: 2023-07-07 04:17:16

Abundance distribution
12 species
6 singletons
total count 44
extrapolated richness: 35.6
Fisher's α: 5.435
geometric series k: 0.7491
Hurlbert's PIE: 0.6702
Shannon's H: 1.7119
Good's u: 0.8657
Each square represents a species. Square sizes are proportional to counts.
Register