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=3318 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3318SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3056SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3318 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Assiminea' AND (junior_species='succinea' OR junior_species='succinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Assiminea' AND (species='succinea' OR species='succinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Assiminea' AND (species='succinea' OR species='succinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Assiminea' AND (junior_species='succinea' OR junior_species='succinea')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='Assiminea' AND (species='succinea' OR species='succinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sayella' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sayella' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sayella' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sayella' AND (junior_species='fusca' OR junior_species='fusca')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='Sayella' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bulla' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bulla' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bulla' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bulla' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Bulla' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acteocina' AND (junior_species='canaliculata' OR junior_species='canaliculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acteocina' AND (species='canaliculata' OR species='canaliculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acteocina' AND (species='canaliculata' OR species='canaliculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acteocina' AND (junior_species='canaliculata' OR junior_species='canaliculata')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='Acteocina' AND (species='canaliculata' OR species='canaliculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalocardia' AND (junior_species='cuneimeris' OR junior_species='cuneimeris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anomalocardia' AND (species='cuneimeris' OR species='cuneimeris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anomalocardia' AND (species='cuneimeris' OR species='cuneimeris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalocardia' AND (junior_species='cuneimeris' OR junior_species='cuneimeris')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='Anomalocardia' AND (species='cuneimeris' OR species='cuneimeris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parastarte' AND (junior_species='triquetra' OR junior_species='triquetra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parastarte' AND (species='triquetra' OR species='triquetra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parastarte' AND (species='triquetra' OR species='triquetra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parastarte' AND (junior_species='triquetra' OR junior_species='triquetra')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='Parastarte' AND (species='triquetra' OR species='triquetra') 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='Amydalum' AND (junior_species='arborescens' OR junior_species='arborescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amydalum' AND (species='arborescens' OR species='arborescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amydalum' AND (species='arborescens' OR species='arborescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amydalum' AND (junior_species='arborescens' OR junior_species='arborescens')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='Amydalum' AND (species='arborescens' OR species='arborescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mytilopsis' AND (junior_species='sallei' OR junior_species='salleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mytilopsis' AND (species='sallei' OR species='salleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mytilopsis' AND (species='sallei' OR species='salleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mytilopsis' AND (junior_species='sallei' OR junior_species='salleii')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='Mytilopsis' AND (species='sallei' OR species='salleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austromacoma' AND (junior_species='constricta' OR junior_species='constricta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Austromacoma' AND (species='constricta' OR species='constricta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Austromacoma' AND (species='constricta' OR species='constricta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austromacoma' AND (junior_species='constricta' OR junior_species='constricta')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='Austromacoma' AND (species='constricta' OR species='constricta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Musculus' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Musculus' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Musculus' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Musculus' AND (junior_species='lateralis' OR junior_species='lateralis')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='Musculus' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Foreamysia' AND (junior_species='soror' OR junior_species='soror')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Foreamysia' AND (species='soror' OR species='soror') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Foreamysia' AND (species='soror' OR species='soror')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Foreamysia' AND (junior_species='soror' OR junior_species='soror')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='Foreamysia' AND (species='soror' OR species='soror') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptochelia' AND (junior_species='rapax' OR junior_species='rapax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptochelia' AND (species='rapax' OR species='rapax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptochelia' AND (species='rapax' OR species='rapax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptochelia' AND (junior_species='rapax' OR junior_species='rapax')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='Leptochelia' AND (species='rapax' OR species='rapax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypereteone' AND (junior_species='heteropoda' OR junior_species='heteropoda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypereteone' AND (species='heteropoda' OR species='heteropoda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypereteone' AND (species='heteropoda' OR species='heteropoda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypereteone' AND (junior_species='heteropoda' OR junior_species='heteropoda')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='Hypereteone' AND (species='heteropoda' OR species='heteropoda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leitoscoloplos' AND (junior_species='fragilis' OR junior_species='fragilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leitoscoloplos' AND (species='fragilis' OR species='fragilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leitoscoloplos' AND (species='fragilis' OR species='fragilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leitoscoloplos' AND (junior_species='fragilis' OR junior_species='fragilis')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='Leitoscoloplos' AND (species='fragilis' OR species='fragilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laeonereis' AND (junior_species='culveri' OR junior_species='culverii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laeonereis' AND (species='culveri' OR species='culverii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laeonereis' AND (species='culveri' OR species='culverii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laeonereis' AND (junior_species='culveri' OR junior_species='culverii')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='culveri' OR species='culverii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoqueto' 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='Oligoqueto' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligoqueto' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoqueto' 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='Oligoqueto' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3318 The Ecological Register: Celestun Lagoon (rainy season)
Celestun Lagoon (rainy season)
Basic information
Sample name: Celestun Lagoon (rainy season)

Reference: A. Morelos-Villegas, A. R. Condal, and P.-L. Ardisson. 2018. Spatial heterogeneity and seasonal structure of physical factors and benthic species in a tropical coastal lagoon, Celestun, Yucatan Peninsula. Regoinal Studies in Marine Science 22:136-146 [ER 3056]
Geography
Country: Mexico

State: Yucatan


Coordinate: 20° 54' N, 90° 21' W
Coordinate basis: estimated from map

Geography comments: "The inner zone... is shallow (<0.5 m) and scarcely influenced by tides, with low salinity... The soft bottom sediment is a mixture of clay, limestone, sand, and organic matter"

•
Environment
Habitat: lagoon

Protection: unprotected

Substrate: ground surface

Habitat comments: "a karstic coastal lagoon"

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

Sampling methods: sieves

Sample size: 15764 individuals

Years: 1998, 1999

Seasons: wet or monsoon

Sampling comments: "Sampling was carried out seasonally during the 1998–1999 annual cycle. There was one sampling event during each of the dry, rainy, and windy seasons. The sampling was organized into a regular grid of 45 sampling sites distributed across the inner zone of the lagoon. The sampling grid consisted of nine 600–800 m long transects, perpendicular to the coastline, with a distance of 700 m among transects. Five sampling sites were selected per transect, with distances among them ranging from 100 to 250 m and covering the entire transverse section of the lagoon from one margin to the other... Sampling was conducted from a small boat at an average depth of 0.5 m... Two sediment samples were collected at each site with a Birge-Ekman grab (15 x 15 x 15 cm) and then transferred to plastic buckets; one sample was used for the study of macroinfauna... the organisms were separated using a 500-μm mesh sieve"

Metadata
Sample number: 3318

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-05-19 18:52:45

Modified: 2019-05-19 08:52:45

Abundance distribution
17 species
3 singletons
total count 15764
extrapolated richness: 22.0
Fisher's α: 1.882
geometric series k: 0.5659
Hurlbert's PIE: 0.6188
Shannon's H: 1.3452
Good's u: 0.9998
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Assiminea succinea9049
Sayella fusca2816
Bulla occidentalis171
Acteocina canaliculata130
Anomalocardia cuneimeris1978
Parastarte triquetra878
Tagelus plebeius13
Amydalum arborescens6
Mytilopsis sallei1
Austromacoma constricta1
Musculus lateralis2
Foreamysia soror1
Leptochelia rapax322
Hypereteone heteropoda53
Leitoscoloplos fragilis259
Laeonereis culveri22
Oligoqueto sp.62