SELECT DISTINCT SPECIES.Genus AS ResultField1, SPECIES.Species AS ResultField2, SPECIES.Author AS ResultField3, SPECIES.FBname AS ResultField4, SPECIES.FamCode AS ResultField5, SPECIES.SpecCode AS ID_Field, SPECIES.Length AS ResultField6, SPECIES.LTypeMaxM AS ResultField7, SPECIES.LengthFemale AS ResultField20, SPECIES.LTypeMaxF AS ResultField21, synonyms.year, FAMILIES.CommonName, FAMILIES.Family FROM (SPECIES LEFT JOIN synonyms ON SPECIES.SpecCode = synonyms.SpecCode) INNER JOIN FAMILIES ON SPECIES.FamCode = FAMILIES.FamCode WHERE (FAMILIES.FamCode =SPECIES.FamCode) AND (synonyms.valid <> 0) And ((FAMILIES.FamCode)=375) AND ((Families.Order)= 'Perciformes') AND ((Species.Genus) = 'Limnichthys') And ((FAMILIES.Class)='Actinopterygii') ORDER BY species.genus, species.species Fish Identification
Other identification tools | FishBase

Fish Identification: Find Species

Class: Actinopterygii
Order: Perciformes
Family: Creediidae Sandburrowers

Genus: Limnichthys

(See list of species below)

Select Class:     Select Order:   
Select Family: Subfamily:     Select Genus:

Select Ocean (marine/brackish) or Continent (freshwater):
Select a country:
Only include species occuring above: m

Total number of spines in dorsal and anal fins (optional).      Enter total length (TL) and maximum body depth (BD)

Show family drawings / Hide family drawings

6 species in
(see list below)
Export file

1 of 1 Jump to:

Photo by Randall, J.E.

Western Pacific
Max. Length 5 cm TL
Limnichthys fasciatus Waite, 1904

Photo by Randall, J.E.
Limnichthys fasciatus
[Barred sand burrower]

Photo by Bogorodsky, S.V.

Western Indian Ocean
Max. Length 2.2 cm SL
Limnichthys marisrubri Fricke & Golani, 2012

Photo by Bogorodsky, S.V.
Limnichthys marisrubri

Photo by Winterbottom, R.

Max. Length 3.5 cm TL
Limnichthys nitidus Smith, 1958

Photo by Winterbottom, R.
Limnichthys nitidus
[Sand submarine]
No picture found
Northwest Pacific
Max. Length 2.3 cm SL

Limnichthys orientalis
No picture found
Southwest Pacific
Max. Length 7.2 cm TL

Limnichthys polyactis
No picture found
Southwest Pacific

Limnichthys rendahli

6 species

Sort by: Species Length Year
1 of 1 Jump to:
Export file
Scientific Name English Name Distribution Max. Length (cm) Year
Limnichthys fasciatus Barred sand burrower Western Pacific 5 TL 1904
Limnichthys marisrubri Western Indian Ocean 2.2 SL 2012
Limnichthys nitidus Sand submarine Indo-Pacific 3.5 TL 1958
Limnichthys orientalis Northwest Pacific 2.3 SL 1999
Limnichthys polyactis Tommyfish Southwest Pacific 7.2 TL 1978
Limnichthys rendahli Southwest Pacific 1958

Other identification tools in FishBase

Quick Identification
Identification keys
Identification by morphometrics
Identification by pictures:
          If you already know the Family, go to Search FishBase, select Family and click on 'Identification by pictures' to display all available pictures in FishBase for the family.

          If you already know the Country, go to
Search FishBase, select Country and click on 'Identification by pictures' to display all available pictures in FishBase for the country.

          If you already know the Ecosystem, go to
Search FishBase, select Ecosystem and click on 'Identification by pictures' to display all available pictures in FishBase for the ecosystem.
cfm script by eagbayani, 30.11.04, ,  php script by cmilitante, 05/11/2010 ,  last modified by cmilitante, 14/03/2013