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=729 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=729SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=389SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=729 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaerephon' AND (junior_species='ansorgei' OR junior_species='ansorgeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaerephon' AND (species='ansorgei' OR species='ansorgeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaerephon' AND (species='ansorgei' OR species='ansorgeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaerephon' AND (junior_species='ansorgei' OR junior_species='ansorgeii')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='Chaerephon' AND (species='ansorgei' OR species='ansorgeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaerephon' AND (junior_species='pumilus' OR junior_species='pumilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaerephon' AND (species='pumilus' OR species='pumilus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaerephon' AND (junior_species='pumilus' OR junior_species='pumilus')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='Chaerephon' AND (species='pumilus' OR species='pumilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epomops' AND (junior_species='franqueti' OR junior_species='franquetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epomops' AND (species='franqueti' OR species='franquetii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epomops' AND (junior_species='franqueti' OR junior_species='franquetii')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='Epomops' AND (species='franqueti' OR species='franquetii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoromicia' AND (junior_species='tenuipinnis' OR junior_species='tenuipinnis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoromicia' AND (species='tenuipinnis' OR species='tenuipinnis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoromicia' AND (species='tenuipinnis' OR species='tenuipinnis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoromicia' AND (junior_species='tenuipinnis' OR junior_species='tenuipinnis')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='Pseudoromicia' AND (species='tenuipinnis' OR species='tenuipinnis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloglossus' AND (junior_species='woermanni' OR junior_species='woermannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaloglossus' AND (species='woermanni' OR species='woermannii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloglossus' AND (junior_species='woermanni' OR junior_species='woermannii')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='Megaloglossus' AND (species='woermanni' OR species='woermannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropteropus' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropteropus' AND (species='pusillus' OR species='pusillus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropteropus' AND (junior_species='pusillus' OR junior_species='pusillus')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='Micropteropus' AND (species='pusillus' OR species='pusillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mops' AND (junior_species='nanulus' OR junior_species='nanulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mops' AND (species='nanulus' OR species='nanulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mops' AND (species='nanulus' OR species='nanulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mops' AND (junior_species='nanulus' OR junior_species='nanulus')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='Mops' AND (species='nanulus' OR species='nanulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myopterus' AND (junior_species='whitleyi' OR junior_species='whitleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myopterus' AND (species='whitleyi' OR species='whitleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myopterus' AND (species='whitleyi' OR species='whitleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myopterus' AND (junior_species='whitleyi' OR junior_species='whitleyii')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='Myopterus' AND (species='whitleyi' OR species='whitleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotophilus' AND (junior_species='dinganii' OR junior_species='dingani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scotophilus' AND (species='dinganii' OR species='dingani') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotophilus' AND (junior_species='dinganii' OR junior_species='dingani')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='Scotophilus' AND (species='dinganii' OR species='dingani') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=729
Reference:H. Leirs, J. N. Mills, J. W. Krebs, J. E. Childs, D. Akaibe, N. Woollen, G. Ludwig, C. J. Peters, and T. G. Ksiazek. 1999. Search for the Ebola virus reservoir in Kikwit, Democratic Republic of the Congo: reflections on a vertebrate collection. Journal of Infectious Diseases179(suppl. 1):S155-S163 [ER 389]
Habitat comments: none given, but presumably not primary forest because sampling was near a mission
MAT, CMT, and WMT for Kikwit given by Reiter et al. 1999 (J Infect Diseases)
Methods
Life forms: bats
Sampling methods: no design,mist nets
Sample size: 188 individuals
Metadata
Sample number: 729
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-04-04 10:54:13
Modified: 2014-04-24 23:21:22
Abundance distribution
9 species
4 singletons
total count 188
extrapolated richness: 17.0
Fisher's α: 1.970
geometric series k: 0.5946
Hurlbert's PIE: 0.7402
Shannon's H: 1.5201
Good's u: 0.9787
Each square represents a species. Square sizes are proportional to counts.