Animalia > Chordata > Actinopterygii > Perciformes > Gobiidae > Gobius > Gobius niger
 

Gobius niger (Black goby)

Synonyms: Gobius brittanicus; Gobius fuliginosus; Gobius iozo; Gobius jozo; Gobius jozo pontica; Gobius longiradiatus; Gobius niger hispanicus; Gobius niger jozo; Gobius niger nigerrimus; Gobius punctulatus
Language: Albanian; Arabic; Catalan; Croatian; Danish; Dutch; Estonian; Finnish; French; German; Greek; Italian; Latvian; Lithuanian; Maltese; Mandarin Chinese; Norwegian; Polish; Portuguese; Romanian; Russian; Serbian; Slovenian; Spanish; Swedish; Turkish

Wikipedia Abstract

The black goby (Gobius niger) is a species of ray-finned fish found in the Eastern Atlantic and Mediterranean Sea and Black Sea. It inhabits estuaries, lagoons, and inshore water over seagrass and algae. It feeds on a variety of invertebrates and sometimes small fish. This species can also be found in the aquarium trade.This fish reaches a maximum length of 18 centimetres (7 in) TL. This fish's neck is scaled and both of its dorsal fins have a black spot on the front end.
View Wikipedia Record: Gobius niger

Attributes

Female Maturity [1]  9 months 22 days
Male Maturity [2]  9 months 22 days
Maximum Longevity [1]  5 years

Ecoregions

Name Countries Ecozone Biome Species Report Climate Land
Use
Central & Western Europe Austria, Belgium, Byelarus, Czech Republic, Denmark, France, Germany, Liechtenstein, Lithuania, Luxembourg, Netherlands, Poland, Russia, Slovakia, Switzerland, Ukraine, United Kingdom Palearctic Temperate Floodplain River and Wetlands    
Northern Baltic Drainages Denmark, Finland, Norway, Russia, Sweden Palearctic Polar Freshwaters    

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Cardigan Bay/ Bae Ceredigion 236876 Wales, United Kingdom
Carmarthen Bay and Estuaries/ Bae Caerfyrddin ac Aberoedd 163340 Wales, United Kingdom
Drigg Coast 3453 England, United Kingdom
Essex Estuaries 114016 England, United Kingdom
Fal and Helford 15785 England, United Kingdom    
Glannau Ynys Gybi/ Holy Island Coast 1147 Wales, United Kingdom  
Karadagskiy Zapovednik Nature Zapovednik 13876 Ukraine  
Loch Creran 3030 Scotland, United Kingdom  
Loch Laxford 3018 Scotland, United Kingdom
Loch nam Madadh 5734 Scotland, United Kingdom
Lyme Bay and Torbay 77215 England, United Kingdom
Margate and Long Sands 160406 England, United Kingdom
Morecambe Bay 151985 England, United Kingdom
Pembrokeshire Marine/ Sir Benfro Forol 341177 Wales, United Kingdom  
Pen Llyn a`r Sarnau/ Lleyn Peninsula and the Sarnau 360832 Wales, United Kingdom
Plymouth Sound and Estuaries 15820 England, United Kingdom
Ruegen   Germany      
Sidmouth to West Bay 2217 England, United Kingdom
South Wight Maritime 49082 England, United Kingdom
Start Point to Plymouth Sound & Eddystone 84204 England, United Kingdom  
Sunart 25320 Scotland, United Kingdom
Taynish and Knapdale Woods 2388 Scotland, United Kingdom
The Vadills 154 Scotland, United Kingdom
The Wash and North Norfolk Coast 266284 England, United Kingdom
Y Fenai a Bae Conwy/ Menai Strait and Conwy Bay 65440 Wales, United Kingdom  

Prey / Diet

Carcinus maenas (green crab)[3]
Glycera fallax[4]
Gobius niger (Black goby)[3]
Microdeutopus gryllotalpa[3]
Pomatoschistus minutus (freckled goby)[3]
Terebellides stroemii[4]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Anguilla anguilla (River eel)1
Ciliata mustela (Rockling)1
Ctenolabrus rupestris (Rock cook)2
Gadus morhua (rock cod)2
Merlangius merlangus (Whiting)2
Myoxocephalus scorpius (Short-spined sea scorpion)1
Platichthys flesus (North Atlantic flounder)1
Pollachius pollachius (Pollock)1
Pollachius virens (Sillock)1
Pomatoschistus microps (Common goby)1
Raja clavata (Roker)1
Raja undulata (Painted ray)1
Somateria mollissima (Common Eider)1
Spinachia spinachia (fifteenspine stickleback)1
Trachurus mediterraneus (Mediterranean scad)1
Trisopterus capelanus (Poor cod)1

Predators

Citharus linguatula (Spotted flounder)[5]
Gobius niger (Black goby)[3]
Liocarcinus depurator (harbour crab)[6]
Necora puber (velvet crab)[7]
Raja undulata (Painted ray)[8]
Serranus cabrilla (Learned rockfich)[4]

Consumers

Parasitized by 
Acanthocephaloides propinquus[9]
Acanthocephalus anguillae[9]
Acanthostomum balthicum[9]
Acanthostomum imbutiformis <Unverified Name>[9]
Anguillicola crassus <Unverified Name>[9]
Anisakis simplex[9]
Aphalloides timmi <Unverified Name>[9]
Ascarophis arctica <Unverified Name>[9]
Asymphylodora demeli[9]
Bothriocephalus scorpii[9]
Cardiocephalus longicollis[9]
Cryptocotyle concava[9]
Cryptocotyle lingua[9]
Cucullanellus minutus <Unverified Name>[9]
Derogenes varicus[9]
Diplostomum spathaceum[9]
Echinorhynchus gadi[9]
Gyrodactylus flesi[9]
Gyrodactylus gussevi <Unverified Name>[9]
Gyrodactylus proterorhini[9]
Helicometra fasciata[9]
Helicometra gobii[9]
Helicometra pulchella[9]
Hysterothylacium auctum <Unverified Name>[9]
Hysterothylacium fabri <Unverified Name>[9]
Lepidapedon elongatum[9]
Lepidapedon microcotyleum <Unverified Name>[9]
Macvicaria alacris[9]
Magnibursatus caudofilamentosa[9]
Podocotyle atomon[9]
Pomphorhynchus laevis[9]
Proctoeces maculatus[9]
Proteocephalus gobiorum <Unverified Name>[9]
Proteocephalus percae[9]
Raphidascaris acus <Unverified Name>[9]
Schistocephalus solidus[9]
Scolex pleuronectis <Unverified Name>[9]
Stephanostomum bicoronatum[9]
Stephanostomum cesticillum[9]

Institutions (Zoos, etc.)

    Maps
Institution Infraspecies / Breed 
Artis Zoo
Budapest Zool.& Botanical Garden
Oceanario de Lisboa
Rotterdam Zoo
Universeum Science Center

Distribution

Eastern Atlantic and Mediterranean Sea: throughout North Africa from Cape Blanc, Mauritania north and eastwards to the Suez Canal; also along the eastern Atlantic coast northwards to Trondheim (Norway) and Baltic Sea. Also known from the Black Sea (Ref. 4646).;

Photos

Citations

Attributes / relations provided by 1Frimpong, E.A., and P. L. Angermeier. 2009. FishTraits: a database of ecological and life-history traits of freshwater fishes of the United States. Fisheries 34:487-495. 2de Magalhaes, J. P., and Costa, J. (2009) A database of vertebrate longevity records and their relation to other life-history traits. Journal of Evolutionary Biology 22(8):1770-1774 3Dietary composition and the potential of food competition between 0-group cod (Gadus morhua L.) and some other fish species in the littoral zone, Karen Fjøsne and Jakob Gjøsæter, ICES Journal of Marine Science, 53: 757–770. 1996 4Feeding habits and trophic levels of Mediterranean fish, Konstantinos I. Stergiou & Vasiliki S. Karpouzi, Reviews in Fish Biology and Fisheries 11: 217–254, 2002 5Feeding behaviour and daily ration of the spotted flounder Citharus linguatula (Osteichthyes: Pleuronectiformes) in the central Tyrrhenian Sea, PAOLO CARPENTIERI, TIZIANA CANTARELLI, FRANCESCO COLLOCA, ALESSANDRO CRISCOLI and GIANDOMENICO ARDIZZONE, Scientia Marina 74(4) December 2010, 659-667 6Feeding ecology of Liocarcinus depurator (Decapoda: Portunidae) in the Ría de Arousa (Galicia, north-west Spain): effects of habitat, season and life history}, J. Freire, Marine Biology (1996) 126: 297-311 7Feeding ecology of the velvet swimming crab Necora puber in mussel raft areas of the Ria de Arousa (Galicia,NW Spain), Juan Freire, Eduardo González-Gurriarán, Mar. Ecol. Prog. Ser. 119: 139-154, 1995 8Ontogenetic dietary shift and feeding strategy of Raja undulata Lacepe&#768;de, 1802 (Chondrichthyes: Rajidae) on the Portuguese continental shelf, Teresa Moura, Ivone FigueIredo, Inês Farias, Bárbara Serra-Pereira, Ana Neves, Maria de Fátima Borges and Leonel Serrano Gordo, Scientia Marina 72(2) June 2008, 311-318 9Gibson, D. I., Bray, R. A., & Harris, E. A. (Compilers) (2005). Host-Parasite Database of the Natural History Museum, London
Ecoregions provided by World Wide Fund For Nature (WWF). WildFinder: Online database of species distributions, ver. 01.06 WWF WildFINDER
Protected Areas provided by GBIF Global Biodiversity Information Facility Biological Inventories of the World's Protected Areas in cooperation between the Information Center for the Environment at the University of California, Davis and numerous collaborators.
Images provided by Google Image Search
Abstract provided by DBpedia licensed under a Creative Commons License
Weather provided by NOAA METAR Data Access
(default) 42 queries took 45 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Edge`.`namecode_id`, `Edge`.`description`, `Edge`.`ED`, `Edge`.`EDGE`, `Edge`.`EDGEsp`, `Edge`.`EDPct`, `Edge`.`EDGEPct`, `Edge`.`id_num`, `Edge`.`edtype`, `Audio`.`namecode_id`, `Audio`.`dbid`, `Audio`.`author`, `Audio`.`url`, `Audio`.`name`, `Sabstract`.`id`, `Sabstract`.`abstract`, `Sabstract`.`wikipage`, `Sabstract`.`database_id`, `Sabstract`.`valid`, `TaxaBreadcrumb`.`id`, `TaxaBreadcrumb`.`trail`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `edges` AS `Edge` ON (`Taxa`.`namecode_id` = `Edge`.`namecode_id`) LEFT JOIN `audios` AS `Audio` ON (`Taxa`.`namecode_id` = `Audio`.`namecode_id`) LEFT JOIN `abstracts` AS `Sabstract` ON (`Taxa`.`namecode_id` = `Sabstract`.`id` AND `Sabstract`.`valid` = 'Y') LEFT JOIN `breadcrumbs` AS `TaxaBreadcrumb` ON (`Taxa`.`parent_id` = `TaxaBreadcrumb`.`id`) LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` = 666157 LIMIT 1111
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (666157) 111
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (666157) 331
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (666157) ORDER BY `Taxalink`.`location` DESC 000
5SELECT `Webcam`.`id`, `Webcam`.`name`, `Webcam`.`camtype`, `Webcam`.`camurl`, `Webcam`.`location_type`, `Webcam`.`location_id`, `Webcam`.`namecode_id`, `Webcam`.`display`, `Webcam`.`last_update`, `Webcam`.`webpageurl`, `Webcam`.`start_hour`, `Webcam`.`end_hour`, `Webcam`.`gmt`, `Webcam`.`feedings`, `Webcam`.`joystick` FROM `webcams` AS `Webcam` WHERE `Webcam`.`namecode_id` = (666157) ORDER BY `Webcam`.`name` ASC 001
6SELECT `Missingrel`.`id`, `Missingrel`.`consumer`, `Missingrel`.`provider`, `Missingrel`.`reltype`, `Missingrel`.`dbid`, `Missingrel`.`trophic`, `Missingrel`.`namecode_id`, `Missingrel`.`namecode_type`, `Missingrel`.`missing_id` FROM `missingrel` AS `Missingrel` WHERE `Missingrel`.`namecode_id` = (666157) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 12121
7SELECT `TaxaEcoregions`.`id`, `TaxaEcoregions`.`name`, `TaxaEcoregions`.`biome_id`, `TaxaEcoregions`.`geo_id`, `TaxaEcoregions`.`country`, `TaxaEcoregions`.`area_h`, `TaxaEcoregions`.`abstract`, `TaxaEcoregions`.`supressnglink`, `TaxaEcoregions`.`er_type`, `EcoregionTaxa`.`taxa_id`, `EcoregionTaxa`.`ecoregion_id` FROM `ecoregions` AS `TaxaEcoregions` JOIN `ecoregion_taxa` AS `EcoregionTaxa` ON (`EcoregionTaxa`.`taxa_id` = 666157 AND `EcoregionTaxa`.`ecoregion_id` = `TaxaEcoregions`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcoregions`.`name` ASC 221
8SELECT `TaxaEmblems`.`id`, `TaxaEmblems`.`abbrev2`, `TaxaEmblems`.`abbrev3`, `TaxaEmblems`.`name`, `TaxaEmblems`.`poltype`, `TaxaEmblems`.`region`, `Emblem`.`id`, `Emblem`.`political_id`, `Emblem`.`namecode_id`, `Emblem`.`etype`, `Emblem`.`sortorder` FROM `politicals` AS `TaxaEmblems` JOIN `emblems` AS `Emblem` ON (`Emblem`.`namecode_id` = 666157 AND `Emblem`.`political_id` = `TaxaEmblems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEmblems`.`name` ASC 001
9SELECT `TaxaEcosystems`.`id`, `TaxaEcosystems`.`name`, `TaxaEcosystems`.`database_id`, `TaxaEcosystems`.`notes`, `EcosysSpecy`.`id`, `EcosysSpecy`.`ecosystem_id`, `EcosysSpecy`.`species_id`, `EcosysSpecy`.`top_consumer`, `EcosysSpecy`.`trophic_level` FROM `ecosystems` AS `TaxaEcosystems` JOIN `ecosys_species` AS `EcosysSpecy` ON (`EcosysSpecy`.`species_id` = 666157 AND `EcosysSpecy`.`ecosystem_id` = `TaxaEcosystems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcosystems`.`name` ASC 001
10SELECT `TaxaHotspots`.`id`, `TaxaHotspots`.`name`, `TaxaHotspots`.`country`, `TaxaHotspots`.`abstract`, `TaxaHotspots`.`link`, `TaxaHotspots`.`geo_id`, `HotspotTaxa`.`hotspot_id`, `HotspotTaxa`.`taxa_id`, `HotspotTaxa`.`endemic` FROM `hotspots` AS `TaxaHotspots` JOIN `hotspot_taxa` AS `HotspotTaxa` ON (`HotspotTaxa`.`taxa_id` = 666157 AND `HotspotTaxa`.`hotspot_id` = `TaxaHotspots`.`id`) WHERE 1 = 1 ORDER BY `TaxaHotspots`.`name` ASC 001
11SELECT `TaxaAzesites`.`id`, `TaxaAzesites`.`name`, `TaxaAzesites`.`country`, `TaxaAzesites`.`mapid`, `TaxaAzesites`.`lat`, `TaxaAzesites`.`lon`, `TaxaAzesites`.`zone`, `TaxaAzesites`.`geo_id`, `AzeTaxa`.`azesite_id`, `AzeTaxa`.`taxa_id` FROM `azesites` AS `TaxaAzesites` JOIN `aze_taxa` AS `AzeTaxa` ON (`AzeTaxa`.`taxa_id` = 666157 AND `AzeTaxa`.`azesite_id` = `TaxaAzesites`.`id`) WHERE 1 = 1 ORDER BY `TaxaAzesites`.`name` ASC 001
12SELECT `TaxaBirdareas`.`id`, `TaxaBirdareas`.`name`, `TaxaBirdareas`.`country`, `TaxaBirdareas`.`zone`, `TaxaBirdareas`.`finalcode`, `TaxaBirdareas`.`area`, `TaxaBirdareas`.`lat`, `TaxaBirdareas`.`lon`, `TaxaBirdareas`.`criteria`, `TaxaBirdareas`.`geo_id`, `TaxaBirdareas`.`kml`, `BirdareaTaxa`.`birdarea_id`, `BirdareaTaxa`.`taxa_id`, `BirdareaTaxa`.`criteria`, `BirdareaTaxa`.`species_id` FROM `birdareas` AS `TaxaBirdareas` JOIN `birdarea_taxa` AS `BirdareaTaxa` ON (`BirdareaTaxa`.`taxa_id` = 666157 AND `BirdareaTaxa`.`birdarea_id` = `TaxaBirdareas`.`id`) WHERE 1 = 1 ORDER BY `TaxaBirdareas`.`name` ASC 001
13SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`parent_id` = 26853214 ORDER BY `Taxa`.`name` ASC 001
14SELECT `Zooinst`.`id`, `Zooinst`.`abbrev`, `Zooinst`.`name`, `Zooinst`.`city`, `Zooinst`.`state`, `Zooinst`.`country`, `Zooinst`.`species_cnt`, `Zooinst`.`specimen_cnt`, `Zooinst`.`url`, `Zooinst`.`lat`, `Zooinst`.`lon`, `Zooinst`.`continent_id`, `Zooinst`.`gmt`, `ZooSpecie`.`id`, `ZooSpecie`.`zooinst_id`, `ZooSpecie`.`taxa_id`, `ZooSpecie`.`infraspecies`, `ZooSpecie`.`males`, `ZooSpecie`.`females`, `ZooSpecie`.`unknown`, `ZooSpecie`.`births`, `ZooSpecie`.`database_id` FROM `zooinsts` AS `Zooinst` LEFT JOIN `zoo_species` AS `ZooSpecie` ON (`ZooSpecie`.`zooinst_id` = `Zooinst`.`id`) WHERE `ZooSpecie`.`taxa_id` = 666157 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 551
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 666157 AND d.group_id = dg.id ORDER BY dg.distribution28281
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 666157 ORDER BY s.name10100
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 666157 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language93931
18SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 666157110
19SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 666157 AND pa.geo_id = g.id ORDER BY pa.name25251
20SELECT e.id, g.gridx, g.gridy, g.climate, g.landuse FROM ecoregions e, geographics g WHERE e.geo_id = g.id AND e.id IN ('PAF404','PAF406')221
21SELECT `Relation`.`id`, `Relation`.`consumer_id`, `Relation`.`provider_id`, `Relation`.`reltype`, `Relation`.`notes`, `Relation`.`database_id`, `Relation`.`trophic`, `Consumer`.`record_id`, `Consumer`.`lsid`, `Consumer`.`name`, `Consumer`.`taxon`, `Consumer`.`parent_id`, `Consumer`.`database_id`, `Consumer`.`namecode_id`, `Consumer`.`english_name_cnt`, `Consumer`.`longevity_cnt`, `Consumer`.`species_cnt`, `Consumer`.`endanger_cnt`, `Consumer`.`link`, `Consumer`.`invasive_cnt`, `Consumer`.`kingdom`, `Consumer`.`image_cnt`, `Consumer`.`relation_cnt`, `Consumer`.`range_dbid`, `Consumer`.`tphylum`, `Consumer`.`tclass`, `Consumer`.`torder`, `Consumer`.`tfamily`, `Consumer`.`scrutiny_date`, `Consumer`.`specialist_id` FROM `relations` AS `Relation` LEFT JOIN `taxa` AS `Consumer` ON (`Relation`.`consumer_id` = `Consumer`.`namecode_id`) WHERE `Relation`.`provider_id` = 666157 ORDER BY `Consumer`.`name` ASC 33332
22SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` IN (3095344, 954890, 2677924, 2299758, 912945, 2300029, 901274, 661777, 2590396, 914837, 905639, 901566, 954898, 666157, 2644378, 2507528, 2511970, 2634602, 2519493, 914300, 2607577, 2519494, 2634601, 1063337, 914720, 954921, 902944, 2680991, 669498, 2500928, 660055, 2651567, 2590401) 33332
23SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (660055, 661777, 666157, 669498, 901274, 901566, 902944, 905639, 912945, 914300, 914720, 914837, 954890, 954898, 954921, 1063337, 2299758, 2300029, 2500928, 2507528, 2511970, 2519493, 2519494, 2590396, 2590401, 2607577, 2634601, 2634602, 2644378, 2651567, 2677924, 2680991, 3095344) 13132
24SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (660055, 661777, 666157, 669498, 901274, 901566, 902944, 905639, 912945, 914300, 914720, 914837, 954890, 954898, 954921, 1063337, 2299758, 2300029, 2500928, 2507528, 2511970, 2519493, 2519494, 2590396, 2590401, 2607577, 2634601, 2634602, 2644378, 2651567, 2677924, 2680991, 3095344) 551
25SELECT `Relation`.`id`, `Relation`.`consumer_id`, `Relation`.`provider_id`, `Relation`.`reltype`, `Relation`.`notes`, `Relation`.`database_id`, `Relation`.`trophic`, `Provider`.`record_id`, `Provider`.`lsid`, `Provider`.`name`, `Provider`.`taxon`, `Provider`.`parent_id`, `Provider`.`database_id`, `Provider`.`namecode_id`, `Provider`.`english_name_cnt`, `Provider`.`longevity_cnt`, `Provider`.`species_cnt`, `Provider`.`endanger_cnt`, `Provider`.`link`, `Provider`.`invasive_cnt`, `Provider`.`kingdom`, `Provider`.`image_cnt`, `Provider`.`relation_cnt`, `Provider`.`range_dbid`, `Provider`.`tphylum`, `Provider`.`tclass`, `Provider`.`torder`, `Provider`.`tfamily`, `Provider`.`scrutiny_date`, `Provider`.`specialist_id` FROM `relations` AS `Relation` LEFT JOIN `taxa` AS `Provider` ON (`Relation`.`provider_id` = `Provider`.`namecode_id`) WHERE `Relation`.`consumer_id` = 666157 ORDER BY `Provider`.`name` ASC 661
26SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` IN (1063329, 960519, 666157, 1059227, 659974, 2472787) 661
27SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (659974, 666157, 960519, 1059227, 1063329, 2472787) 661
28SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (659974, 666157, 960519, 1059227, 1063329, 2472787) 881
29SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000022698, 1000016398, 1000022973, 1000016670, 1000017696, 1000014168, 1000018918, 1000018939, 1000026294, 1000011108, 1000020924, 1000011488) 12121
30SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 666157 ORDER BY name16161
31SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` IN (658847, 659647, 658890, 666146, 658863, 659882, 659961, 658870, 659964, 659973, 667425, 669498, 829388, 660070, 660120, 659509) 16161
32SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (658847, 658863, 658870, 658890, 659509, 659647, 659882, 659961, 659964, 659973, 660070, 660120, 666146, 667425, 669498, 829388) 2382384
33SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (658847, 658863, 658870, 658890, 659509, 659647, 659882, 659961, 659964, 659973, 660070, 660120, 666146, 667425, 669498, 829388) 67671
34SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id` FROM `taxa` AS `Taxa` WHERE `Taxa`.`record_id` IN (26922039, 26922040, 26922057, 26924196, 26926705, 26939278) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922057,26924196,26926705,26939278) ASC 662
35SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 114858, 111274, 113097, 113210, 112037) 661
36SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 111274, 113097, 113210, 112037) 000
37SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
38SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (1444, 1442, 3786, 3483, 2222, 2386, 1815, 2242, 1029) 994
39SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (3998, 1019) 221
40SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 111
41SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1007) 110
42SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110