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=825 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=825SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=466SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=825 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmodus' AND (junior_species='rotundus' OR junior_species='rotundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmodus' AND (species='rotundus' OR species='rotundus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmodus' AND (junior_species='rotundus' OR junior_species='rotundus')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='Desmodus' AND (species='rotundus' OR species='rotundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='soricina' OR junior_species='soricina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glossophaga' AND (species='soricina' OR species='soricina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='soricina' OR junior_species='soricina')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='Glossophaga' AND (species='soricina' OR species='soricina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophostoma' AND (junior_species='brasiliense' OR junior_species='brasiliense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophostoma' AND (species='brasiliense' OR species='brasiliense') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophostoma' AND (junior_species='brasiliense' OR junior_species='brasiliense')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='Lophostoma' AND (species='brasiliense' OR species='brasiliense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophostoma' AND (junior_species='silvicolum' OR junior_species='silvicolum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophostoma' AND (species='silvicolum' OR species='silvicolum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophostoma' AND (junior_species='silvicolum' OR junior_species='silvicolum')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='Lophostoma' AND (species='silvicolum' OR species='silvicolum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micronycteris' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micronycteris' AND (species='megalotis' OR species='megalotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micronycteris' AND (junior_species='megalotis' OR junior_species='megalotis')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='Micronycteris' AND (species='megalotis' OR species='megalotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllostomus' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='discolor' OR junior_species='discolor')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='Phyllostomus' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trinycteris' AND (junior_species='nicefori' OR junior_species='niceforii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trinycteris' AND (species='nicefori' OR species='niceforii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trinycteris' AND (species='nicefori' OR species='niceforii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trinycteris' AND (junior_species='nicefori' OR junior_species='niceforii')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='Trinycteris' AND (species='nicefori' OR species='niceforii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='perspicillata' OR junior_species='perspicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carollia' AND (species='perspicillata' OR species='perspicillata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='perspicillata' OR junior_species='perspicillata')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='Carollia' AND (species='perspicillata' OR species='perspicillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinophylla' AND (junior_species='fischerae' OR junior_species='fischerae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinophylla' AND (species='fischerae' OR species='fischerae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinophylla' AND (species='fischerae' OR species='fischerae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinophylla' AND (junior_species='fischerae' OR junior_species='fischerae')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='Rhinophylla' AND (species='fischerae' OR species='fischerae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinophylla' AND (junior_species='pumilio' OR junior_species='pumilio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinophylla' AND (species='pumilio' OR species='pumilio') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinophylla' AND (junior_species='pumilio' OR junior_species='pumilio')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='Rhinophylla' AND (species='pumilio' OR species='pumilio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='cinereus' OR junior_species='cinereus')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='Artibeus' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='planirostris' OR junior_species='planirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='planirostris' OR species='planirostris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='planirostris' OR junior_species='planirostris')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='Artibeus' AND (species='planirostris' OR species='planirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='brachycephalus' OR junior_species='brachycephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrrhinus' AND (species='brachycephalus' OR species='brachycephalus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='brachycephalus' OR junior_species='brachycephalus')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='Platyrrhinus' AND (species='brachycephalus' OR species='brachycephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='incarum' OR junior_species='incarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrrhinus' AND (species='incarum' OR species='incarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrrhinus' AND (species='incarum' OR species='incarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='incarum' OR junior_species='incarum')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='Platyrrhinus' AND (species='incarum' OR species='incarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='bilobatum' OR junior_species='bilobatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroderma' AND (species='bilobatum' OR species='bilobatum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='bilobatum' OR junior_species='bilobatum')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='Uroderma' AND (species='bilobatum' OR species='bilobatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='magnirostrum' OR junior_species='magnirostrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroderma' AND (species='magnirostrum' OR species='magnirostrum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='magnirostrum' OR junior_species='magnirostrum')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='Uroderma' AND (species='magnirostrum' OR species='magnirostrum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=825
Reference:L. J. C. Costa, F. A. G. Andrade, W. Uieda, L. F. A. Martorelli, A. P. A. G. Kataoka, and M. E. B. Fernandes. 2013. Serological investigation of rabies virus neutralizing antibodies in bats captured in the eastern Brazilian Amazon. Transactions of the Royal Society of Tropical Medicine and Hygiene107(11):684-689 [ER 466]
Habitat comments: "dominated by Amazon rainforest, mangroves and marshlands" and specifically "areas of upland forest" or "over bodies of water" or "in open fields (close to fruit trees and livestock, whenever possible" (satellite photos suggest the landscape is mostly agricultural)
climate based on station 82191 (Belém)
"hot and humid throughout the year, with two well-defined seasons, a rainy season, between January and August, and a dry season between September and December"
Methods
Life forms: bats
Sampling methods: no design,mist nets
Sample size: 74 captures or sightings
Years: 2009
Days: 4
Nets or traps: 10
Net or trap nights: 40
Sampling comments: most bats were released
ten nets deployed for two nights each in two seasons = 40 net nights
Metadata
Sample number: 825
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-04-18 10:01:44
Modified: 2014-04-24 06:26:16
Abundance distribution
16 species
8 singletons
total count 74
extrapolated richness: 42.8
Fisher's α: 6.279
geometric series k: 0.8069
Hurlbert's PIE: 0.8212
Shannon's H: 2.1227
Good's u: 0.8930
Each square represents a species. Square sizes are proportional to counts.