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=1554 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1554SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1048SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1554 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caelostomus' AND (junior_species='cribratus' OR junior_species='cribratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caelostomus' AND (species='cribratus' OR species='cribratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caelostomus' AND (species='cribratus' OR species='cribratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caelostomus' AND (junior_species='cribratus' OR junior_species='cribratus')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='Caelostomus' AND (species='cribratus' OR species='cribratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dactalyleurys' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dactalyleurys' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dactalyleurys' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dactalyleurys' AND (junior_species='n.' OR junior_species='n.')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='Dactalyleurys' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplocolpodes' AND (junior_species='perrieri' OR junior_species='perrierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplocolpodes' AND (species='perrieri' OR species='perrierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplocolpodes' AND (species='perrieri' OR species='perrierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplocolpodes' AND (junior_species='perrieri' OR junior_species='perrierii')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='Haplocolpodes' AND (species='perrieri' OR species='perrierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebia' 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='Lebia' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lebia' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebia' 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='Lebia' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebia' 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='Lebia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lebia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebia' 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='Lebia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liagonum' AND (junior_species='hova' OR junior_species='hova')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liagonum' AND (species='hova' OR species='hova') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liagonum' AND (species='hova' OR species='hova')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liagonum' AND (junior_species='hova' OR junior_species='hova')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='Liagonum' AND (species='hova' OR species='hova') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liagonum' AND (junior_species='subsolanum' OR junior_species='subsolanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liagonum' AND (species='subsolanum' OR species='subsolanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liagonum' AND (species='subsolanum' OR species='subsolanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liagonum' AND (junior_species='subsolanum' OR junior_species='subsolanum')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='Liagonum' AND (species='subsolanum' OR species='subsolanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lobocolpodes' AND (junior_species='murex' OR junior_species='murex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lobocolpodes' AND (species='murex' OR species='murex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lobocolpodes' AND (species='murex' OR species='murex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lobocolpodes' AND (junior_species='murex' OR junior_species='murex')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='Lobocolpodes' AND (species='murex' OR species='murex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madecassina' 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='Madecassina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Madecassina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madecassina' 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='Madecassina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microcheila' AND (junior_species='denticollis' OR junior_species='denticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microcheila' AND (species='denticollis' OR species='denticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microcheila' AND (species='denticollis' OR species='denticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microcheila' AND (junior_species='denticollis' OR junior_species='denticollis')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='Microcheila' AND (species='denticollis' OR species='denticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='isakae' OR junior_species='isakae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='isakae' OR species='isakae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='isakae' OR species='isakae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='isakae' OR junior_species='isakae')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='Neocolpodes' AND (species='isakae' OR species='isakae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='leptoterus' OR junior_species='leptoterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='leptoterus' OR species='leptoterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='leptoterus' OR species='leptoterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='leptoterus' OR junior_species='leptoterus')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='Neocolpodes' AND (species='leptoterus' OR species='leptoterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='micaauri' OR junior_species='micaaurii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='micaauri' OR species='micaaurii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='micaauri' OR species='micaaurii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='micaauri' OR junior_species='micaaurii')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='Neocolpodes' AND (species='micaauri' OR species='micaaurii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='parenthesis' OR junior_species='parenthesis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='parenthesis' OR species='parenthesis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='parenthesis' OR species='parenthesis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='parenthesis' OR junior_species='parenthesis')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='Neocolpodes' AND (species='parenthesis' OR species='parenthesis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='sublaevis' OR junior_species='sublaevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='sublaevis' OR species='sublaevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='sublaevis' OR species='sublaevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='sublaevis' OR junior_species='sublaevis')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='Neocolpodes' AND (species='sublaevis' OR species='sublaevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='tanalensis' OR junior_species='tanalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='tanalensis' OR species='tanalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='tanalensis' OR species='tanalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='tanalensis' OR junior_species='tanalensis')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='Neocolpodes' AND (species='tanalensis' OR species='tanalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='vagus' OR junior_species='vagus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='vagus' OR species='vagus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='vagus' OR species='vagus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='vagus' OR junior_species='vagus')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='Neocolpodes' AND (species='vagus' OR species='vagus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocolpodes' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' AND (junior_species='n.' OR junior_species='n.')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='Neocolpodes' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' 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='Neocolpodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' 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='Neocolpodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' 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='Neocolpodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocolpodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocolpodes' 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='Neocolpodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notocolpodes' AND (junior_species='hylonomus' OR junior_species='hylonomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notocolpodes' AND (species='hylonomus' OR species='hylonomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notocolpodes' AND (species='hylonomus' OR species='hylonomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notocolpodes' AND (junior_species='hylonomus' OR junior_species='hylonomus')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='Notocolpodes' AND (species='hylonomus' OR species='hylonomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thysanotus' 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='Thysanotus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thysanotus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thysanotus' 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='Thysanotus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichillinus' AND (junior_species='dactyleuryoides' OR junior_species='dactyleuryoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichillinus' AND (species='dactyleuryoides' OR species='dactyleuryoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichillinus' AND (species='dactyleuryoides' OR species='dactyleuryoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichillinus' AND (junior_species='dactyleuryoides' OR junior_species='dactyleuryoides')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='Trichillinus' AND (species='dactyleuryoides' OR species='dactyleuryoides') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1554 The Ecological Register: Ranomafana National Park (February)
Ranomafana National Park (February)
Basic information
Sample name: Ranomafana National Park (February)

Reference: J. Rainio. 2013. Seasonal variation of carabid beetle (Coleoptera: Carabidae) abundance and diversity in Ranomafana National Park, Madagascar. Journal of Entomology and Zoology Studies 1(5):92-98 [ER 1048]
Geography
Country: Madagascar

State: Fianarantsoa


Coordinate: 21° 13' 30" S, 47° 27' 30" E
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges given in the text

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: national/state park

Substrate: ground surface

Disturbance: selective logging

WMT: 20.0

CMT: 14.0

MAP: 2750.0

Habitat comments: sites are in "(1) intact montane primary forest (Valohoaka), (2) slightly selectively logged montane primary forest (Vatoharanana), and (3) 18 year prior the study partly selectively logged secondary forest (Talatakely)"
MAP 1500 to 4000 mm

Methods
Life forms: ground beetles

Sampling methods: no design,hand capture

Sample size: 255 individuals

Years: 2005

Sampling comments: "Carabids were collected by hand using several methods, including beating trees and bushes, gathering dead leaves from bushes, and turning stones and decaying logs"

Metadata
Sample number: 1554

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-17 09:23:46

Modified: 2015-05-16 23:23:46

Abundance distribution
23 species
5 singletons
total count 255
extrapolated richness: 35.1
Fisher's α: 6.130
geometric series k: 0.8497
Hurlbert's PIE: 0.9137
Shannon's H: 2.6695
Good's u: 0.9805
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Caelostomus (Alocothorax) cribratus1
Dactalyleurys n. sp. 11
Haplocolpodes perrieri7
Lebia (Metalebia) madagascariensis12
Lebia sp. 35
Liagonum hova10
Liagonum subsolanum9
Lobocolpodes murex32
Madecassina sp. Tanala4
Microcheila denticollis2
Neocolpodes isakae1
Neocolpodes leptoterus7
Neocolpodes micaauri1
Neocolpodes parenthesis18
Neocolpodes sublaevis24
Neocolpodes tanalensis1
Neocolpodes vagus17
Neocolpodes n. sp. 118
Neocolpodes sp. 111
Neocolpodes sp. 22
Notocolpodes hylonomus36
Thysanotus sp. 12
Trichillinus (Mallopelmus) dactyleuryoides34