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=376 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=376SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=169SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=376 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callulops' AND (junior_species='microtis' OR junior_species='microtis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callulops' AND (species='microtis' OR species='microtis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callulops' AND (species='microtis' OR species='microtis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callulops' AND (junior_species='microtis' OR junior_species='microtis')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='Callulops' AND (species='microtis' OR species='microtis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choerophryne' AND (junior_species='proboscidea' OR junior_species='proboscidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choerophryne' AND (species='proboscidea' OR species='proboscidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Choerophryne' AND (species='proboscidea' OR species='proboscidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choerophryne' AND (junior_species='proboscidea' OR junior_species='proboscidea')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='Choerophryne' AND (species='proboscidea' OR species='proboscidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophorbus' 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='Hylophorbus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylophorbus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophorbus' 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='Hylophorbus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophorbus' 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='Hylophorbus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylophorbus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophorbus' 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='Hylophorbus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophorbus' 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='Hylophorbus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylophorbus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophorbus' 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='Hylophorbus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='infrafrenata' OR junior_species='infrafrenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='infrafrenata' OR species='infrafrenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='infrafrenata' OR species='infrafrenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='infrafrenata' OR junior_species='infrafrenata')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='Litoria' AND (species='infrafrenata' OR species='infrafrenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='mucro' OR junior_species='mucro')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='mucro' OR species='mucro') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='mucro' OR species='mucro')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='mucro' OR junior_species='mucro')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='Litoria' AND (species='mucro' OR species='mucro') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='nigropunctata' OR junior_species='nigropunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='nigropunctata' OR species='nigropunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='nigropunctata' OR species='nigropunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='nigropunctata' OR junior_species='nigropunctata')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='Litoria' AND (species='nigropunctata' OR species='nigropunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='pygmaea' OR junior_species='pygmaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='pygmaea' OR species='pygmaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='pygmaea' OR species='pygmaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='pygmaea' OR junior_species='pygmaea')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='Litoria' AND (species='pygmaea' OR species='pygmaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantophryne' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantophryne' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantophryne' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantophryne' AND (junior_species='lateralis' OR junior_species='lateralis')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='Mantophryne' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophryne' AND (junior_species='biroi' OR junior_species='biroii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreophryne' AND (species='biroi' OR species='biroii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreophryne' AND (species='biroi' OR species='biroii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophryne' AND (junior_species='biroi' OR junior_species='biroii')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='Oreophryne' AND (species='biroi' OR species='biroii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophryne' AND (junior_species='hypsiops' OR junior_species='hypsiops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreophryne' AND (species='hypsiops' OR species='hypsiops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreophryne' AND (species='hypsiops' OR species='hypsiops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophryne' AND (junior_species='hypsiops' OR junior_species='hypsiops')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='Oreophryne' AND (species='hypsiops' OR species='hypsiops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophryne' 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='Oreophryne' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreophryne' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophryne' 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='Oreophryne' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymantis' AND (junior_species='papuensis' OR junior_species='papuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platymantis' AND (species='papuensis' OR species='papuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platymantis' AND (species='papuensis' OR species='papuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymantis' AND (junior_species='papuensis' OR junior_species='papuensis')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='Platymantis' AND (species='papuensis' OR species='papuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='arfaki' OR junior_species='arfakii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='arfaki' OR species='arfakii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='arfaki' OR species='arfakii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='arfaki' OR junior_species='arfakii')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='Rana' AND (species='arfaki' OR species='arfakii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='grisea' OR junior_species='grisea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='grisea' OR species='grisea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='grisea' OR species='grisea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='grisea' OR junior_species='grisea')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='Rana' AND (species='grisea' OR species='grisea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='papua' OR junior_species='papua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='papua' OR species='papua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='papua' OR species='papua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='papua' OR junior_species='papua')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='Rana' AND (species='papua' OR species='papua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenophryne' AND (junior_species='cornuta' OR junior_species='cornuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphenophryne' AND (species='cornuta' OR species='cornuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenophryne' AND (species='cornuta' OR species='cornuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenophryne' AND (junior_species='cornuta' OR junior_species='cornuta')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='Sphenophryne' AND (species='cornuta' OR species='cornuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenobatrachus' 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='Xenobatrachus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenobatrachus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenobatrachus' 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='Xenobatrachus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenorhina' AND (junior_species='oxycephala' OR junior_species='oxycephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenorhina' AND (species='oxycephala' OR species='oxycephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenorhina' AND (species='oxycephala' OR species='oxycephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenorhina' AND (junior_species='oxycephala' OR junior_species='oxycephala')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='Xenorhina' AND (species='oxycephala' OR species='oxycephala') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=376 The Ecological Register: Morox
Morox
Basic information
Sample name: Morox

Reference: C. Dahl, S. J. Richards, and V. Novotny. 2013. The Sepik River (Papua New Guinea) is not a dispersal barrier for lowland rain-forest frogs. Journal of Tropical Ecology 29(6):477-483 [ER 169]
Geography
Country: Papua New Guinea


Coordinate: 4° 26' S, 145° 12' E
Coordinate basis: estimated from map

Geography comments: coordinate estimated from map
"40–250 m asl"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 26.0

Habitat comments: "lowland rain forest"

Methods
Life forms: frogs

Sampling methods: no design,hand capture

Sample size: 124 individuals

Years: 2004, 2005

Sampling comments: specimens were photographed

Metadata
Sample number: 376

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-14 10:08:34

Modified: 2014-03-20 02:17:14

Abundance distribution
20 species
5 singletons
total count 124
extrapolated richness: 34.6
Fisher's α: 6.747
geometric series k: 0.8499
Hurlbert's PIE: 0.8999
Shannon's H: 2.5589
Good's u: 0.9601
Each square represents a species. Square sizes are proportional to counts.
Register