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=1573 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1573SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1065SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1573 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidula' AND (junior_species='euryanassa' OR junior_species='euryanassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Placidula' AND (species='euryanassa' OR species='euryanassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Placidula' AND (species='euryanassa' OR species='euryanassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidula' AND (junior_species='euryanassa' OR junior_species='euryanassa')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='Placidula' AND (species='euryanassa' OR species='euryanassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')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='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='naxos' OR junior_species='naxos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='naxos' OR species='naxos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='naxos' OR species='naxos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='naxos' OR junior_species='naxos')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='Astraptes' AND (species='naxos' OR species='naxos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='melanisans' OR species='melanisans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')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='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='amathea' OR species='amathea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='amathea' OR species='amathea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')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='Anartia' AND (species='amathea' OR species='amathea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='besckei' OR junior_species='besckeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='besckei' OR species='besckeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='besckei' OR species='besckeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='besckei' OR junior_species='besckeii')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='Heliconius' AND (species='besckei' OR species='besckeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='thalia' OR junior_species='thalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='thalia' OR species='thalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='thalia' OR species='thalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='thalia' OR junior_species='thalia')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='Actinote' AND (species='thalia' OR species='thalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybdelis' AND (junior_species='phaesyla' OR junior_species='phaesyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybdelis' AND (junior_species='phaesyla' OR junior_species='phaesyla')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='Cybdelis' AND (species='phaesyla' OR species='phaesyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telenassa' AND (junior_species='teletusa' OR junior_species='teletusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telenassa' AND (species='teletusa' OR species='teletusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telenassa' AND (species='teletusa' OR species='teletusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telenassa' AND (junior_species='teletusa' OR junior_species='teletusa')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='Telenassa' AND (species='teletusa' OR species='teletusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tegosa' AND (species='claudina' OR species='claudina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')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='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epityches' AND (species='eupompe' OR species='eupompe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')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='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='philoclea' OR junior_species='philoclea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Episcada' AND (species='philoclea' OR species='philoclea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episcada' AND (species='philoclea' OR species='philoclea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='philoclea' OR junior_species='philoclea')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='Episcada' AND (species='philoclea' OR species='philoclea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynomine' AND (junior_species='myrrhina' OR junior_species='myrrhina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynomine' AND (species='myrrhina' OR species='myrrhina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynomine' AND (species='myrrhina' OR species='myrrhina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynomine' AND (junior_species='myrrhina' OR junior_species='myrrhina')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='Dynomine' AND (species='myrrhina' OR species='myrrhina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='herato' OR junior_species='herato')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='herato' OR species='herato') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='herato' OR species='herato')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='herato' OR junior_species='herato')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='Heliconius' AND (species='herato' OR species='herato') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Biblis' AND (species='hyperia' OR species='hyperia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')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='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='zunilda' OR junior_species='zunilda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='zunilda' OR species='zunilda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='zunilda' OR species='zunilda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='zunilda' OR junior_species='zunilda')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='Doxocopa' AND (species='zunilda' OR species='zunilda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='pergaea' OR junior_species='pergaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurybia' AND (species='pergaea' OR species='pergaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurybia' AND (species='pergaea' OR species='pergaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='pergaea' OR junior_species='pergaea')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='Eurybia' AND (species='pergaea' OR species='pergaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dismorphia' AND (species='astyocha' OR species='astyocha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')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='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectoride' OR junior_species='hectoride')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='hectoride' OR species='hectoride') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='hectoride' OR species='hectoride')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectoride' OR junior_species='hectoride')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='Heraclides' AND (species='hectoride' OR species='hectoride') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='braziliensis' OR species='braziliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')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='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='neocypris' OR species='neocypris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')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='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipotryris' AND (junior_species='euclea' OR junior_species='euclea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipotryris' AND (species='euclea' OR species='euclea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipotryris' AND (species='euclea' OR species='euclea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipotryris' AND (junior_species='euclea' OR junior_species='euclea')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='Hipotryris' AND (species='euclea' OR species='euclea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='syma' OR species='syma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='syma' OR species='syma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')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='Adelpha' AND (species='syma' OR species='syma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='candrena' OR species='candrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')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='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1573 The Ecological Register: Seara
Seara
Basic information
Sample name: Seara

Reference: D. G. Schmidt, L. C. da Costa, A. Elpino-Campos, and E. A. Barp. 2012. Diversidade de borboletas (Lepidoptera) na borda e no interior de um fragmento de mata, no município de Seara - SC. Saúde e Meio Ambiente 1(2):3-15 [ER 1065]
Geography
Country: Brazil

State: Santa Catarina


Coordinate: 27° 9' S, 52° 19' W
Coordinate basis: stated in text

Geography comments: "no perímetro urbano da cidade de Seara"

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: fragment

Substrate: ground surface

MAT: 18.9

MAP: 1954.0

Habitat comments: secondary "Mata Atlãntica"
clearly a small fragment based on the figured satellite photo
climate data are for Chapecó and are from Velasco-Molina (2016, Geoderma)

Methods
Life forms: butterflies

Sampling methods: no design,butterfly nets

Sample size: 274 individuals

Years: 2010, 2011

Sampling comments: "coleta com rrede entomológica"

Metadata
Sample number: 1573

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-20 21:10:48

Modified: 2016-12-13 07:59:16

Abundance distribution
24 species
8 singletons
total count 274
extrapolated richness: 48.4
Fisher's α: 6.332
geometric series k: 0.8185
Hurlbert's PIE: 0.7955
Shannon's H: 2.0636
Good's u: 0.9709
Each square represents a species. Square sizes are proportional to counts.
Register