Animalia > Chordata > Actinopterygii > Lophiiformes > Lophiidae > Lophius > Lophius americanus
 

Lophius americanus (Monkfish; Goosefish; American angler; American goosefish)

Language: Chinese; Danish; French; German; Italian; Mandarin Chinese; Polish; Portuguese; Russian; Spanish; Swedish

Wikipedia Abstract

Lophius americanus is a goosefish in the family Lophiidae, also called all-mouth, American anglerfish, bellows-fish, devil-fish, headfish, molligut, satchel-mouth, or wide-gape. It is native to the eastern coast of North America.
View Wikipedia Record: Lophius americanus

Attributes

Adult Weight [1]  27.40 lbs (12.43 kg)
Maximum Longevity [3]  30 years
Migration [2]  Migratory

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Florida Keys National Marine Sanctuary IV 2387149 Florida, United States

Prey / Diet

Citharichthys arctifrons (Gulf Stream flounder)[4]
Dichelopandalus leptocerus (bristled longbeak)[4]
Doryteuthis pealeii (longfin inshore squid)[4]
Hippoglossina oblonga (Fourspot flounder)[4]
Hippoglossoides platessoides (American dab)[5]
Lepophidium profundorum (Fawn cusk-eel)[4]
Leucoraja erinacea (common skate)[4]
Lophius americanus (Monkfish)[4]
Merluccius bilinearis (Whiting)[4]
Myoxocephalus octodecemspinosus (Sea raven)[5]
Ophichthus cruentifer (Snake eel)[4]
Peprilus triacanthus (Sheephead)[4]
Pholis gunnellus (Tissy)[4]
Pseudopleuronectes americanus (rough flounder)[4]
Urophycis chuss (Squirrel hake)[4]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Alosa sapidissima (American shad)1
Amblyraja radiata (Starry ray)2
Brosme brosme (Tusk)1
Carcharhinus obscurus (Whaler shark)1
Carcharhinus plumbeus (Thickskin shark)2
Carcharhinus signatus (Shark)1
Carcharias taurus (Spotted sand tiger shark)1
Cynoscion arenarius (Sand seatrout)1
Cynoscion nothus (Silver weakfish)1
Dipturus batis (Blue skate)1
Dipturus laevis (Barndoor skate)1
Gadus morhua (rock cod)3
Hippoglossina oblonga (Fourspot flounder)2
Hippoglossus stenolepis (Pacific halibut)3
Isurus oxyrinchus (Short-finned mako)2
Lamna nasus (Porbeagle shark)1
Lepophidium profundorum (Fawn cusk-eel)1
Leucoraja erinacea (common skate)2
Leucoraja garmani (Freckled skate)1
Leucoraja ocellata (Winter skate)1
Malacoraja senta (Smooth skate)1
Menticirrhus saxatilis (Northern kingfish)1
Morone saxatilis (Striper bass)1
Myoxocephalus octodecemspinosus (Sea raven)1
Paralichthys dentatus (fluke)1
Phalacrocorax auritus (Double-crested Cormorant)3
Phalacrocorax carbo (Great Cormorant)1
Pomatomus saltatrix (Tailor run)3
Prionace glauca (Tribon blou)1
Raja eglanteria (Clearnose skate)1
Rhizoprionodon terraenovae (Atlantic sharp-nosed shark)1
Rhomboplites aurorubens (Vermillion snapper)1
Saurida brasiliensis (Brazilian lizardfish)1
Scomberomorus cavalla (Spanish mackerel)1
Scophthalmus aquosus (brill)2
Sebastes fasciatus (Acadian redfish)1
Seriola dumerili (Yellow tail)1
Sphyrna zygaena (Smooth hammerhead shark)1
Squalus acanthias (Common spiny)1
Squatina dumeril (Atlantic angelshark)1
Stenotomus chrysops (Scup)1
Synodus foetens (Soapfish)1
Thunnus thynnus (horse mackerel)2
Trichiurus lepturus (Atlantic Cutlassfish)1
Triglops murrayi (Moustache sculpin)1
Urophycis chuss (Squirrel hake)2
Urophycis tenuis (White hake)3
Xiphias gladius (Swordfish)2

Predators

Galeocerdo cuvier (Tiger-shark)[5]
Lophius americanus (Monkfish)[4]
Prionace glauca (Tribon blou)[6]

Consumers

Parasitized by 
Anisakis simplex[7]
Derogenes varicus[7]
Progonus muelleri[7]
Pseudoterranova decipiens[7]
Stephanostomum baccatum[7]

Distribution

Atlantic Ocean; Atlantic, Northwest; Atlantic, Western Central; Canada; Southeast U.S. Continental Shelf; USA (contiguous states); Western Atlantic: Quebec in Canada to northeastern Florida in USA, but uncommon in nearshore waters south of North Carolina, USA.;

Photos

Citations

Attributes / relations provided by 1de 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 2Riede, Klaus (2004) Global Register of Migratory Species - from Global to Regional Scales. Final Report of the R&D-Projekt 808 05 081. 330 pages + CD-ROM 3Frimpong, 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. 4Food and Ontogenetic Shifts in Feeding of the Goosefish, Lophius Americanus, Michael P. Armstrong, John A. Musick, and James A. Colvocoresses, J. Northw. Atl. Fish. Sci., Vol. 18: 99–103 5Food of Northwest Atlantic Fishes and Two Common Species of Squid, Ray E. Bowman, Charles E. Stillwell, William L. Michaels, and Marvin D. Grosslein, NOAA Technical Memorandum NMFS-NE-155 (2000) 6A Quantitative Assessment of the Diet of the Blue Shark (Prionace glauca) off Nova Scotia, Canada, Meaghen E. McCord and Steven E. Campana, J. Northw. Atl. Fish. Sci., Vol. 32: 57-63 7Gibson, D. I., Bray, R. A., & Harris, E. A. (Compilers) (2005). Host-Parasite Database of the Natural History Museum, London
Images provided by Google Image Search
Abstract provided by DBpedia licensed under a Creative Commons License
Weather provided by NOAA METAR Data Access
(default) 40 queries took 49 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` = 666188 LIMIT 1112
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (666188) 441
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (666188) 331
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (666188) ORDER BY `Taxalink`.`location` DESC 001
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` = (666188) 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` = (666188) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 001
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` = 666188 AND `EcoregionTaxa`.`ecoregion_id` = `TaxaEcoregions`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcoregions`.`name` ASC 002
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` = 666188 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` = 666188 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` = 666188 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` = 666188 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` = 666188 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` = 26853242 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` = 666188 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 001
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 666188 AND d.group_id = dg.id ORDER BY dg.distribution881
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 666188 ORDER BY s.name001
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 666188 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language17171
18SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 666188110
19SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 666188 AND pa.geo_id = g.id ORDER BY pa.name111
20SELECT `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` = 666188 ORDER BY `Consumer`.`name` ASC 881
21SELECT `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 (2299758, 905639, 659306, 666188, 659409, 2622017, 2299767, 914904) 881
22SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (659306, 659409, 666188, 905639, 914904, 2299758, 2299767, 2622017) 19192
23SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (659306, 659409, 666188, 905639, 914904, 2299758, 2299767, 2622017) 18181
24SELECT `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` = 666188 ORDER BY `Provider`.`name` ASC 15152
25SELECT `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 (667665, 1061958, 1050868, 642870, 660997, 662023, 626322, 666188, 659059, 661144, 660507, 659402, 661234, 618791, 659132) 15151
26SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (618791, 626322, 642870, 659059, 659132, 659402, 660507, 660997, 661144, 661234, 662023, 666188, 667665, 1050868, 1061958) 79792
27SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (618791, 626322, 642870, 659059, 659132, 659402, 660507, 660997, 661144, 661234, 662023, 666188, 667665, 1050868, 1061958) 28281
28SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 666188 ORDER BY name48481
29SELECT `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 (659533, 626283, 658877, 659234, 659236, 659239, 666139, 666676, 659671, 626251, 626263, 666146, 642870, 666173, 684837, 658907, 662023, 626322, 626323, 626293, 685298, 659372, 659065, 661144, 659945, 828994, 828992, 659091, 659409, 667426, 659433, 659103, 667470, 658963, 659438, 667506, 660050, 659468, 666295, 666306, 659475, 660657, 676110, 667622, 667800, 659132, 659133, 666341) 48482
30SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (626251, 626263, 626283, 626293, 626322, 626323, 642870, 658877, 658907, 658963, 659065, 659091, 659103, 659132, 659133, 659234, 659236, 659239, 659372, 659409, 659433, 659438, 659468, 659475, 659533, 659671, 659945, 660050, 660657, 661144, 662023, 666139, 666146, 666173, 666295, 666306, 666341, 666676, 667426, 667470, 667506, 667622, 667800, 676110, 684837, 685298, 828992, 828994) 4774778
31SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (626251, 626263, 626283, 626293, 626322, 626323, 642870, 658877, 658907, 658963, 659065, 659091, 659103, 659132, 659133, 659234, 659236, 659239, 659372, 659409, 659433, 659438, 659468, 659475, 659533, 659671, 659945, 660050, 660657, 661144, 662023, 666139, 666146, 666173, 666295, 666306, 666341, 666676, 667426, 667470, 667506, 667622, 667800, 676110, 684837, 685298, 828992, 828994) 1781782
32SELECT `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, 26929202, 26929209, 26939428) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922057,26929202,26929209,26939428) ASC 662
33SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 114858, 111274, 113297, 113303, 2045298) 551
34SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 111274, 113297, 113303, 2045298) 001
35SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
36SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (1442, 4668, 1444, 1214, 1342, 1496, 1029) 771
37SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1019) 110
38SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
39SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1007) 110
40SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110