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=1676 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1676SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1150SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1676 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boa' AND (junior_species='constrictor' OR junior_species='constrictor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boa' AND (species='constrictor' OR species='constrictor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boa' AND (species='constrictor' OR species='constrictor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boa' AND (junior_species='constrictor' OR junior_species='constrictor')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='Boa' AND (species='constrictor' OR species='constrictor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='assisi' OR junior_species='assisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epicrates' AND (species='assisi' OR species='assisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epicrates' AND (species='assisi' OR species='assisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='assisi' OR junior_species='assisii')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='Epicrates' AND (species='assisi' OR species='assisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='bifossatus' OR junior_species='bifossatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='bifossatus' OR junior_species='bifossatus')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='Mastigodryas' AND (species='bifossatus' OR species='bifossatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilotes' AND (junior_species='pullatus' OR junior_species='pullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilotes' AND (species='pullatus' OR species='pullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilotes' AND (species='pullatus' OR species='pullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilotes' AND (junior_species='pullatus' OR junior_species='pullatus')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='Spilotes' AND (species='pullatus' OR species='pullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='annulata' OR junior_species='annulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodeira' AND (species='annulata' OR species='annulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodeira' AND (species='annulata' OR species='annulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='annulata' OR junior_species='annulata')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='Leptodeira' AND (species='annulata' OR species='annulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='cearensis' OR junior_species='cearensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apostolepis' AND (species='cearensis' OR species='cearensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apostolepis' AND (species='cearensis' OR species='cearensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='cearensis' OR junior_species='cearensis')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='Apostolepis' AND (species='cearensis' OR species='cearensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='poecilogyrus' OR junior_species='poecilogyrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='poecilogyrus' OR species='poecilogyrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='poecilogyrus' OR species='poecilogyrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='poecilogyrus' OR junior_species='poecilogyrus')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='Liophis' AND (species='poecilogyrus' OR species='poecilogyrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='paucidens' OR junior_species='paucidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='paucidens' OR species='paucidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='paucidens' OR species='paucidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='paucidens' OR junior_species='paucidens')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='Liophis' AND (species='paucidens' OR species='paucidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='viridis' OR junior_species='viridis')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='Liophis' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='trigeminus' OR junior_species='trigeminus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='trigeminus' OR junior_species='trigeminus')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='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodryas' AND (species='nattereri' OR species='nattererii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodryas' AND (species='nattereri' OR species='nattererii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='nattereri' OR junior_species='nattererii')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='Philodryas' AND (species='nattereri' OR species='nattererii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phimophis' AND (junior_species='iglesiasi' OR junior_species='iglesiasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phimophis' AND (species='iglesiasi' OR species='iglesiasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phimophis' AND (species='iglesiasi' OR species='iglesiasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phimophis' AND (junior_species='iglesiasi' OR junior_species='iglesiasii')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='Phimophis' AND (species='iglesiasi' OR species='iglesiasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoboa' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoboa' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='nigra' OR junior_species='nigra')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='Pseudoboa' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psomophis' AND (junior_species='joberti' OR junior_species='jobertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psomophis' AND (species='joberti' OR species='jobertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psomophis' AND (species='joberti' OR species='jobertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psomophis' AND (junior_species='joberti' OR junior_species='jobertii')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='Psomophis' AND (species='joberti' OR species='jobertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' 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='Thamnodynastes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnodynastes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' 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='Thamnodynastes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='merremii' OR junior_species='merremi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenodon' AND (species='merremii' OR species='merremi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenodon' AND (species='merremii' OR species='merremi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='merremii' OR junior_species='merremi')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='Xenodon' AND (species='merremii' OR species='merremi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='ibiboboca' OR junior_species='ibiboboca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='ibiboboca' OR junior_species='ibiboboca')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='Micrurus' AND (species='ibiboboca' OR species='ibiboboca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothropoides' AND (junior_species='lutzi' OR junior_species='lutzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothropoides' AND (species='lutzi' OR species='lutzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothropoides' AND (species='lutzi' OR species='lutzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothropoides' AND (junior_species='lutzi' OR junior_species='lutzii')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='Bothropoides' AND (species='lutzi' OR species='lutzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='durissus' OR junior_species='durissus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='durissus' OR species='durissus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='durissus' OR species='durissus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='durissus' OR junior_species='durissus')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='Crotalus' AND (species='durissus' OR species='durissus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1676 The Ecological Register: Castelo do Piauí
Castelo do Piauí
Basic information
Sample name: Castelo do Piauí

Reference: F. S. Rodrigues and A. L. C. Prudente. 2011. The snake assemblage (Squamata: Serpentes) of a Cerrado-Caatinga transition area in Castelo do Piau, state of Piau, Brazil. Zoologia (Curitiba) 28(4):440-448 [ER 1150]
Geography
Country: Brazil

State: Piauí


Coordinate: 5° 19' 20" S, 41° 33' 9" W
Coordinate basis: stated in text

Geography comments: "in the Municipality of Castelo do Piauí"

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

MAT: 33.6

WMT: 35.0

CMT: 21.8

MAP: 1199.0

Habitat comments: "a transition area between the Caatinga and Cerrado, with a pre- dominance of a low altitude Cerrado Rupestre (rocky grasslands)... dry sub-humid" and specifically "low altitude Cerrado Rupestre... Campo Cerrado (open Cerrado)" and "secondary forest of typical Cerrado"

Methods
Life forms: snakes

Sampling methods: no design,drift fences,pitfall traps,hand capture

Sample size: 77 individuals

Years: 2005, 2006

Days: 77

Seasons: dry,wet or monsoon

Nets or traps: 84

Net or trap nights: 6468

Sampling comments: "a) time constrained search... 2) pitfall traps with drift fences... and 3) incidental encounters... Seven sets of traps were installed in each of the three areas. Each set contained four 60 L buckets, arranged in a “Y” configuration, 10 m apart from one another and connected by 100 cm high drift-fences... the traps remained open during 77 days, spread over four expeditions, two in the dry season and two in the rainy season... Time constrained search... was performed for 38 days in each of the three areas"

Metadata
Sample number: 1676

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-05 09:39:42

Modified: 2020-05-29 10:27:43

Abundance distribution
19 species
5 singletons
total count 77
extrapolated richness: 34.9
Fisher's α: 8.065
geometric series k: 0.8799
Hurlbert's PIE: 0.9188
Shannon's H: 2.6863
Good's u: 0.9361
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Boa constrictor1
Epicrates assisi2
Mastigodryas bifossatus1
Spilotes pullatus1
Leptodeira annulata3
Apostolepis cearensis4
Liophis poecilogyrus9
Liophis paucidens2
Liophis viridis8
Oxyrhopus trigeminus7
Philodryas nattereri10
Phimophis iglesiasi5
Pseudoboa nigra2
Psomophis joberti1
Thamnodynastes sp.8
Xenodon merremii5
Micrurus ibiboboca4
Bothropoides lutzi3
Crotalus durissus1