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=1242 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1242SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=868SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1242 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammomys' AND (junior_species='obesus' OR junior_species='obesus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psammomys' AND (species='obesus' OR species='obesus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psammomys' AND (species='obesus' OR species='obesus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammomys' AND (junior_species='obesus' OR junior_species='obesus')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='Psammomys' AND (species='obesus' OR species='obesus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meriones' AND (junior_species='shawi' OR junior_species='shawii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meriones' AND (species='shawi' OR species='shawii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meriones' AND (species='shawi' OR species='shawii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meriones' AND (junior_species='shawi' OR junior_species='shawii')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='Meriones' AND (species='shawi' OR species='shawii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbillus' AND (junior_species='pyramidium' OR junior_species='pyramidium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerbillus' AND (species='pyramidium' OR species='pyramidium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerbillus' AND (species='pyramidium' OR species='pyramidium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbillus' AND (junior_species='pyramidium' OR junior_species='pyramidium')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='Gerbillus' AND (species='pyramidium' OR species='pyramidium') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1242 The Ecological Register: R’milia
R’milia
Basic information
Sample name: R’milia

Reference: E. Fichet-Calvet, I. Jomaa, R. Ben Ismail, and R. W. Ashford. 2003. Leishmania major infection in the fat sand rat Psammomys obesus in Tunisia: interaction of host and parasite populations. Annals of Tropical Medicine & Parasitology 97(6):593-603 [ER 868]
Geography
Country: Tunisia


Coordinate: 35° 46' N, 9° 36' E
Coordinate basis: stated in text

Geography comments: "40km south of Sidi Bouzid"

•
Environment
Habitat: desert/xeric shrubland

Altered habitat: cropland

Substrate: ground surface

MAP: 360.0

Habitat comments: "the edge of a sebcha — an area of ‘succulent halophytic steppe’... traversed by earth bunds some 2 m high, constructed for flood control, between which were cultivated plots of wheat, separated by bands of natural vegetation"

Methods
Life forms: rodents

Sampling methods: line transect,cage traps

Sample size: 608 individuals

Years: 1995 - 1997

Sampling comments: an unclear number of "pincer traps" and "wire-mesh cage traps" arrayed in trap lines of unclear spacing
all P. obesus individuals were killed

Metadata
Sample number: 1242

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-17 10:00:07

Modified: 2015-02-16 23:00:07

Abundance distribution
3 species
1 singleton
total count 608
extrapolated richness: 4.9
Fisher's α: 0.411
geometric series k: 0.0408
Hurlbert's PIE: 0.0244
Shannon's H: 0.0750
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Psammomys obesus600
Meriones shawi7
Gerbillus pyramidium1