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=3317 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3317SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3055SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3317 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasychone' AND (junior_species='lucullana' OR junior_species='lucullana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasychone' AND (species='lucullana' OR species='lucullana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasychone' AND (species='lucullana' OR species='lucullana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasychone' AND (junior_species='lucullana' OR junior_species='lucullana')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='Dasychone' AND (species='lucullana' OR species='lucullana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polydora' 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='Polydora' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polydora' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polydora' 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='Polydora' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophelina' 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='Ophelina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophelina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophelina' 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='Ophelina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphitrite' 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='Amphitrite' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphitrite' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphitrite' 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='Amphitrite' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nainereis' AND (junior_species='setosa' OR junior_species='setosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nainereis' AND (species='setosa' OR species='setosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nainereis' AND (species='setosa' OR species='setosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nainereis' AND (junior_species='setosa' OR junior_species='setosa')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='Nainereis' AND (species='setosa' OR species='setosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euclymene' AND (junior_species='zonalis' OR junior_species='zonalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euclymene' AND (species='zonalis' OR species='zonalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euclymene' AND (species='zonalis' OR species='zonalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euclymene' AND (junior_species='zonalis' OR junior_species='zonalis')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='Euclymene' AND (species='zonalis' OR species='zonalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lumbriconereis' AND (junior_species='funcalensis' OR junior_species='funcalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lumbriconereis' AND (species='funcalensis' OR species='funcalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lumbriconereis' AND (species='funcalensis' OR species='funcalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lumbriconereis' AND (junior_species='funcalensis' OR junior_species='funcalensis')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='Lumbriconereis' AND (species='funcalensis' OR species='funcalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycinde' AND (junior_species='multidens' OR junior_species='multidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glycinde' AND (species='multidens' OR species='multidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glycinde' AND (species='multidens' OR species='multidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycinde' AND (junior_species='multidens' OR junior_species='multidens')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='Glycinde' AND (species='multidens' OR species='multidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onuphis' AND (junior_species='eremita' OR junior_species='eremita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onuphis' AND (species='eremita' OR species='eremita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onuphis' AND (species='eremita' OR species='eremita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onuphis' AND (junior_species='eremita' OR junior_species='eremita')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='Onuphis' AND (species='eremita' OR species='eremita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perinereis' AND (junior_species='cultrifera' OR junior_species='cultrifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perinereis' AND (species='cultrifera' OR species='cultrifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perinereis' AND (species='cultrifera' OR species='cultrifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perinereis' AND (junior_species='cultrifera' OR junior_species='cultrifera')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='Perinereis' AND (species='cultrifera' OR species='cultrifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perinereis' AND (junior_species='nuntia' OR junior_species='nuntia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perinereis' AND (species='nuntia' OR species='nuntia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perinereis' AND (species='nuntia' OR species='nuntia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perinereis' AND (junior_species='nuntia' OR junior_species='nuntia')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='Perinereis' AND (species='nuntia' OR species='nuntia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Venerupis' AND (junior_species='pullastra' OR junior_species='pullastra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Venerupis' AND (species='pullastra' OR species='pullastra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Venerupis' AND (species='pullastra' OR species='pullastra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Venerupis' AND (junior_species='pullastra' OR junior_species='pullastra')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='Venerupis' AND (species='pullastra' OR species='pullastra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Modiolus' AND (junior_species='auriculatus' OR junior_species='auriculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Modiolus' AND (species='auriculatus' OR species='auriculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Modiolus' AND (species='auriculatus' OR species='auriculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Modiolus' AND (junior_species='auriculatus' OR junior_species='auriculatus')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='Modiolus' AND (species='auriculatus' OR species='auriculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paphia' AND (junior_species='undulata' OR junior_species='undulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paphia' AND (species='undulata' OR species='undulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paphia' AND (species='undulata' OR species='undulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paphia' AND (junior_species='undulata' OR junior_species='undulata')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='Paphia' AND (species='undulata' OR species='undulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paphia' AND (junior_species='textile' OR junior_species='textile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paphia' AND (species='textile' OR species='textile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paphia' AND (species='textile' OR species='textile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paphia' AND (junior_species='textile' OR junior_species='textile')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='Paphia' AND (species='textile' OR species='textile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tellina' 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='Tellina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tellina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tellina' 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='Tellina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balanus' 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='Balanus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Balanus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balanus' 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='Balanus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elasmopus' 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='Elasmopus' AND (species='rapax' OR species='rapax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elasmopus' AND (species='rapax' OR species='rapax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elasmopus' 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='Elasmopus' AND (species='rapax' OR species='rapax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodius' AND (junior_species='exaratus' OR junior_species='exaratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodius' AND (species='exaratus' OR species='exaratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodius' AND (species='exaratus' OR species='exaratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodius' AND (junior_species='exaratus' OR junior_species='exaratus')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='Leptodius' AND (species='exaratus' OR species='exaratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alpheus' 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='Alpheus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alpheus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alpheus' 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='Alpheus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Branchiostoma' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Branchiostoma' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Branchiostoma' AND (species='lanceolata' OR species='lanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Branchiostoma' AND (junior_species='lanceolata' OR junior_species='lanceolata')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='Branchiostoma' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3317 The Ecological Register: Timsah Lake (Station I)
Timsah Lake (Station I)
Basic information
Sample name: Timsah Lake (Station I)

Reference: A. A. M. Belal, M. A. El-Sawy, and M. A. Dar. 2016. The effect of water quality on the distribution of macro-benthic fauna in Western Lagoon and Timsah Lake, Egypt. I. Egyptian Journal of Aquatic Research 42(4):437-448 [ER 3055]
Geography
Country: Egypt


Coordinate: 30° 34' N, 32° 18' E
Coordinate basis: estimated from map

Geography comments: "at the midpoint of Suez Canal at 80 km south of Port Said with surface area of 15 km2"
latitude is incorrectly given as 33ยบ 34' N

Environment
Habitat: lagoon

Protection: unprotected

Substrate: ground surface

Habitat comments: the lake has "variable depth between 3m and about 16m" and "receives freshwater from the Western Lagoon and Ismailia Channel meanwhile the saltwater was from Suez Canal"

Methods
Life forms: crustaceans,clams,other invertebrates

Sample size: 28638 individuals

Sampling comments: "macro-benthic fauna were collected by Van Veen grab with an opening area 0.0288 m2 of seabed... The organisms were identified to species level by exploitation Stereo and compound microscopes"

Metadata
Sample number: 3317

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-05-19 18:30:26

Modified: 2019-05-19 08:35:39

Abundance distribution
21 species
0 singletons
total count 28638
extrapolated richness: 21.2
Fisher's α: 2.219
geometric series k: 0.7423
Hurlbert's PIE: 0.6890
Shannon's H: 1.5802
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register