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)=130) AND ((Families.Order)= 'Siluriformes') AND ((Species.Genus) = 'Sperata') And ((FAMILIES.Class)='Actinopterygii') ORDER BY species.genus, species.species Fish Identification
Other identification tools | FishBase

Fish Identification: Find Species

Class: Actinopterygii
Order: Siluriformes
Family: Bagridae Bagrid catfishes

Genus: Sperata

(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



4 species in
(see list below)
Export file

1 of 1 Jump to:

Photo by WWF / Vidthayanon, C.

Asia
Max. Length 180 cm NG
Sperata acicularis Ferraris & Runge, 1999

Photo by WWF / Vidthayanon, C.
 
Sperata acicularis
[]

Photo by JJPhoto

Asia
Max. Length 180 cm TL
Sperata aor (Hamilton, 1822)

Photo by JJPhoto
 
Sperata aor
[Long-whiskered catfish]
No picture found
Asia

 
Sperata aorella
[]

Photo by Hasan, M.E.

Asia
Max. Length 150 cm TL
Sperata seenghala (Sykes, 1839)

Photo by Hasan, M.E.
 
Sperata seenghala
[Giant river-catfish]



4 species

Sort by: Species Length Year
1 of 1 Jump to:
Export file
Scientific Name English Name Distribution Max. Length (cm) Year
Sperata acicularis Asia 180 NG 1999
Sperata aor Long-whiskered catfish Asia 180 TL 1822
Sperata aorella Asia 1858
Sperata seenghala Giant river-catfish Asia 150 TL 1839



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