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=3308 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3308SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3050SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3308 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erodona' AND (junior_species='mactroides' OR junior_species='mactroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erodona' AND (species='mactroides' OR species='mactroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erodona' AND (species='mactroides' OR species='mactroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erodona' AND (junior_species='mactroides' OR junior_species='mactroides')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='Erodona' AND (species='mactroides' OR species='mactroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalliapseudes' AND (junior_species='schubartii' OR junior_species='schubarti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kalliapseudes' AND (species='schubartii' OR species='schubarti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kalliapseudes' AND (species='schubartii' OR species='schubarti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalliapseudes' AND (junior_species='schubartii' OR junior_species='schubarti')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='Kalliapseudes' AND (species='schubartii' OR species='schubarti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromastus' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteromastus' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteromastus' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromastus' AND (junior_species='similis' OR junior_species='similis')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='Heteromastus' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heleobia' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heleobia' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heleobia' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heleobia' AND (junior_species='australis' OR junior_species='australis')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='Heleobia' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephtys' AND (junior_species='fluviatilis' OR junior_species='fluviatilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nephtys' AND (species='fluviatilis' OR species='fluviatilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nephtys' AND (species='fluviatilis' OR species='fluviatilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephtys' AND (junior_species='fluviatilis' OR junior_species='fluviatilis')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='Nephtys' AND (species='fluviatilis' OR species='fluviatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromunna' AND (junior_species='peterseni' OR junior_species='petersenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uromunna' AND (species='peterseni' OR species='petersenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uromunna' AND (species='peterseni' OR species='petersenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromunna' AND (junior_species='peterseni' OR junior_species='petersenii')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='Uromunna' AND (species='peterseni' OR species='petersenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kupellonura' 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='Kupellonura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kupellonura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kupellonura' 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='Kupellonura' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laeonereis' AND (junior_species='acuta' OR junior_species='acuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laeonereis' AND (species='acuta' OR species='acuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laeonereis' AND (species='acuta' OR species='acuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laeonereis' AND (junior_species='acuta' OR junior_species='acuta')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='Laeonereis' AND (species='acuta' OR species='acuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sinelobus' AND (junior_species='stanfordi' OR junior_species='stanfordii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sinelobus' AND (species='stanfordi' OR species='stanfordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sinelobus' AND (species='stanfordi' OR species='stanfordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sinelobus' AND (junior_species='stanfordi' OR junior_species='stanfordii')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='Sinelobus' AND (species='stanfordi' OR species='stanfordii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastylis' AND (junior_species='simpterigiae' OR junior_species='simpterigiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diastylis' AND (species='simpterigiae' OR species='simpterigiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diastylis' AND (species='simpterigiae' OR species='simpterigiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diastylis' AND (junior_species='simpterigiae' OR junior_species='simpterigiae')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='Diastylis' AND (species='simpterigiae' OR species='simpterigiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeromopsis' AND (junior_species='mourei' OR junior_species='moureii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeromopsis' AND (species='mourei' OR species='moureii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeromopsis' AND (species='mourei' OR species='moureii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeromopsis' AND (junior_species='mourei' OR junior_species='moureii')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='Sphaeromopsis' AND (species='mourei' OR species='moureii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nemertina' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nemertina' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nemertina' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nemertina' AND (junior_species='indet.' OR junior_species='indet.')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='Nemertina' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundinea' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundinea' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundinea' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundinea' AND (junior_species='indet.' OR junior_species='indet.')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='Hirundinea' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sigambra' AND (junior_species='grubii' OR junior_species='grubi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sigambra' AND (species='grubii' OR species='grubi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sigambra' AND (species='grubii' OR species='grubi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sigambra' AND (junior_species='grubii' OR junior_species='grubi')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='Sigambra' AND (species='grubii' OR species='grubi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagelus' AND (junior_species='plebeius' OR junior_species='plebeius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tagelus' AND (species='plebeius' OR species='plebeius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tagelus' AND (species='plebeius' OR species='plebeius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagelus' AND (junior_species='plebeius' OR junior_species='plebeius')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='Tagelus' AND (species='plebeius' OR species='plebeius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melita' AND (junior_species='mangrovii' OR junior_species='mangrovi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melita' AND (species='mangrovii' OR species='mangrovi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melita' AND (species='mangrovii' OR species='mangrovi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melita' AND (junior_species='mangrovii' OR junior_species='mangrovi')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='Melita' AND (species='mangrovii' OR species='mangrovi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spio' AND (junior_species='gaucha' OR junior_species='gaucha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spio' AND (species='gaucha' OR species='gaucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spio' AND (species='gaucha' OR species='gaucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spio' AND (junior_species='gaucha' OR junior_species='gaucha')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='Spio' AND (species='gaucha' OR species='gaucha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callinectes' AND (junior_species='danae' OR junior_species='danae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callinectes' AND (species='danae' OR species='danae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callinectes' AND (species='danae' OR species='danae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callinectes' AND (junior_species='danae' OR junior_species='danae')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='Callinectes' AND (species='danae' OR species='danae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3308 The Ecological Register: Pombas Island
Pombas Island
Basic information
Sample name: Pombas Island

Sample aka: Patos Lagoon

Reference: L. C. Rosa and C. E. Bemvenuti. 2006. Temporal variability of the estuarine macrofauna of the Patos Lagoon, Brazil. Revista de Biología Marina y Oceanografía 41(1):1-9 [ER 3050]
Geography
Country: Brazil

State: Rio Grande do Sul


Coordinate: 32° 1' S, 52° 9' W
Coordinate basis: estimated from map

Geography comments: "near the east margin of Pombas Island"

Environment
Habitat: lagoon

Protection: unprotected

Substrate: ground surface

Habitat comments: a "choked lagoon" with "0.5 m of tidal range" and specifically "in a shallow water embayment (ca. 0.8 m of depth)"

Methods
Life forms: crustaceans,clams,snails,other invertebrates

Sampling methods: sieves

Sample size: 38818 individuals

Years: 2001

Sampling comments: "six sites (distant 90 m each other) were established over the greatest linear dimension referred to south-north direction of the island, and were monthly sampled from January to December 2001. At each site, three macrofauna sub-samples were taken using a corer tube (0.008 m² area, 20 cm depth). Biological samples were sieved in situ through a 0.3 mm mesh size"

Metadata
Sample number: 3308

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-05-19 15:31:52

Modified: 2019-05-19 05:31:52

Abundance distribution
18 species
0 singletons
total count 38818
extrapolated richness: 18.8
Fisher's α: 1.804
geometric series k: 0.6154
Hurlbert's PIE: 0.7544
Shannon's H: 1.7001
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register