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=558 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=558SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=280SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=558 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='albilabris' OR junior_species='albilabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='albilabris' OR species='albilabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='albilabris' OR species='albilabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='albilabris' OR junior_species='albilabris')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='Boophis' AND (species='albilabris' OR species='albilabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')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='Boophis' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='pyrrhus' OR junior_species='pyrrhus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='pyrrhus' OR species='pyrrhus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='pyrrhus' OR species='pyrrhus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='pyrrhus' OR junior_species='pyrrhus')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='Boophis' AND (species='pyrrhus' OR species='pyrrhus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='aerumnalis' OR junior_species='aerumnalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='aerumnalis' OR species='aerumnalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='aerumnalis' OR species='aerumnalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='aerumnalis' OR junior_species='aerumnalis')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='Mantidactylus' AND (species='aerumnalis' OR species='aerumnalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='betsileanus' OR junior_species='betsileanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='betsileanus' OR species='betsileanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='betsileanus' OR species='betsileanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='betsileanus' OR junior_species='betsileanus')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='Mantidactylus' AND (species='betsileanus' OR species='betsileanus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=558 The Ecological Register: Ifanadiana (tadpoles)
Ifanadiana (tadpoles)
Basic information
Sample name: Ifanadiana (tadpoles)

Reference: M. Vences, Y. Chiari, M. Teschke, R.-D. Randrianiaina, L. Raharivololoniaina, P. Bora, D. R. Vieites, and F. Glaw. 2008. Which frogs are out there? A preliminary evaluation of survey techniques and identification reliability of Malagasy amphibians. Monografie del Museo Regionale di Scienze Naturali Amphibians of Madagascar di Torino 45:233-252 [ER 280]
Geography
Country: Madagascar


Coordinate: 21° 21' 13" S, 47° 36' 28" E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Substrate: water edge

Disturbance: selective logging

MAT: 26.8

MAP: 2000.0

Habitat comments: "a stream in highly degraded low-altitude forest"
climate data are based on Ménard et al. (2010, PNAS) and are for Farafangana

Methods
Life forms: frogs

Sampling methods: no design,hand capture

Sample size: 8 individuals

Metadata
Sample number: 558

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-25 20:40:51

Modified: 2014-07-13 07:19:01

Abundance distribution
5 species
3 singletons
total count 8
extrapolated richness: 21.4
Fisher's α: 5.705
geometric series k: 0.7598
Hurlbert's PIE: 0.7143
Shannon's H: 1.4942
Good's u: 0.6576
Each square represents a species. Square sizes are proportional to counts.
Register