['Zinc'])) { if($nrow == NULL) { $data .= "; Zinc = " . $Zinc . " [" . $Zinc_l95 .", ". $Zinc_u95. "] mg/100g (wet weight); "; } else { $data .= "; Zinc = " . $Zinc . " [" . $Zinc_l95 .", ". $Zinc_u95. "] mg/100g (wet weight); based on nutrient studies."; } } } } return $data; } // [END] Modified by VCAgbay 05/14/21 //Begin Add 06/21/17 Shelumiel Ortiz function getGlobi($speccode){ global $conn; $queryglobi = "SELECT globi.speccode, globi.database FROM globi WHERE globi.SpecCode=$speccode AND globi.database='FB'"; $result = $conn->query( $queryglobi ); $row = $result->fetch_assoc(); if ( isset($row['speccode'])) { $globi = "http://www.globalbioticinteractions.org/?interactionType=interactsWith&sourceTaxon=FBC%3AFB%3ASpecCode%3A"; $globi .= urlencode($speccode); $outputglobi = "GloBI"; } else{ $outputglobi = "GloBI"; } return $outputglobi; } //End Add 06/21/17 Shelumiel Ortiz //mod by Mbactong Feb 2 2018 Additional Internet Sources function getGomexsi($speccode){ global $conn; $queryGomexsi = "SELECT Gomexsi.speccode, Gomexsi.database FROM Gomexsi WHERE Gomexsi.SpecCode=$speccode AND Gomexsi.database='FB'"; $result = $conn->query( $queryGomexsi ); $row = $result->fetch_assoc(); if ( isset($row['speccode']) ) { $Gomexsi = "http://gomexsi.tamucc.edu/query-database/taxonomic/?subjectName=FBC%3AFB%3ASpecCode%3A" . $speccode . "&allInteractions=on&findPrey=on&filterPrey=&findPredators=on&filterPredators=&serviceType=rest&action=rhm_data_query"; $Gomexsi .= urlencode($speccode); $outputGomexsi = " GoMexSI (interaction data) | "; } else{ $outputGomexsi = ""; } return $outputGomexsi; } //mod by Mbactong Feb 2 2018 Additional Internet Sources //Begin ADD 07/05/2017 Shelumiel Ortiz function getRLS($genus,$species,$speccode) { //$rls = "http://www.reeflifesurvey.com/species/"; //$rls .= urlencode($genus . "-" . $species); //$curl = curl_init(); //curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE); //curl_setopt($curl, CURLOPT_HEADER, false); //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //curl_setopt($curl, CURLOPT_URL, $rls); //curl_setopt($curl, CURLOPT_REFERER, $rls); //curl_setopt($curl, CURLOPT_RETURNTRANSFER, TRUE); //curl_setopt($curl, CURLOPT_USERAGENT,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13'); //$str = curl_exec($curl); //curl_close($curl); // Create a DOM object //$html_rls = new simple_html_dom(); // Load HTML from a string //$html_rls->load($str); //$htmlrls = file_get_html('$rls'); //$outputrls = "Reef Life Survey"; //foreach($html_rls->find('div[id=mainsliderwrapper]') as $atagrls){ // if ($atagrls != null){ // $outputrls = "".$outputrls.""; // break; // } // } //return $outputrls; global $conn; $queryrls = "SELECT SPECIES.DemersPelag FROM SPECIES WHERE SPECIES.SpecCode=$speccode"; $resultrls = $conn->query( $queryrls ); $rowrls = $resultrls->fetch_assoc(); if ( $rowrls['DemersPelag'] == "reef-associated" ) { $rls = "http://www.reeflifesurvey.com/species/"; $rls .= urlencode($genus . "-" . $species); $outputrls = ""."Reef Life Survey".""; } else { $outputrls = "Reef Life Survey"; } return $outputrls; } //End ADD 07/05/2017 Shelumiel Ortiz //Begin ADD 08/09/17 Shelumiel Ortiz function getCitesRefNum() { global $conn; $qrycites = "SELECT Distinct stocks.CITES_Ref FROM stocks where stocks.CITES_Ref IS not NULL"; $resultcites = $conn->query( $qrycites ); $rowcites = $resultcites->fetch_assoc(); $citesrefnum = $rowcites['CITES_Ref']; return $citesrefnum; } function getEstimates($speccode/*, $row_tempprefmin, $row_tempprefmean, $row_tempprefmax, $row_ncells */) { global $conn; $qryestimates = "SELECT TempPrefMin, TempPrefMean, TempPrefMax, nCells FROM estimate where estimate.SpecCode=$speccode"; $resultestimates = $conn->query( $qryestimates ); $rowestimates = $resultestimates->fetch_assoc(); if(isset($rowestimates['TempPrefMin'])){$row_tempprefmin = $rowestimates['TempPrefMin'];} else{$row_tempprefmin = "";} if(isset($rowestimates['TempPrefMean'])){$row_tempprefmean = $rowestimates['TempPrefMean'];} else{$row_tempprefmean = "";} if(isset($rowestimates['TempPrefMax'])){$row_tempprefmax = $rowestimates['TempPrefMax'];} else{$row_tempprefmax = "";} if(isset($rowestimates['nCells'])){$row_ncells = $rowestimates['nCells'];} else{$row_ncells = "";} $Estimatesarray = array($row_tempprefmin, $row_tempprefmax, $row_tempprefmean, $row_ncells); if(!empty($Estimatesarray)){return $Estimatesarray;} else {return NULL;} } //End ADD 08/09/17 Shelumiel Ortiz //Begin Mod 10/16/17 Shelumiel Ortiz function getCMSDetail($speccode){ global $conn; $qry = "SELECT stocks.CMS, species.genus, species.species FROM stocks INNER JOIN Species ON species.speccode = Stocks.SpecCode where stocks.CMS IS not NULL and stocks.SpecCode = $speccode"; //return $qry; $result = $conn->query( $qry ); $row = $result->fetch_assoc(); if(isset($row['genus']) AND isset($row['species'])){ $link = "https://www.cms.int/en/species/" . $row['genus'] ."-". $row['species']; } if(isset($row['CMS'])){ if ($row['CMS'] == 'Appendix I') { return "Appendix I: Endangered migratory species"; } else if ($row['CMS'] == 'Appendix II') { return "Appendix II: Migratory species conserved through agreements"; } else if ($row['CMS'] == 'Appendix I & II') { return "Appendix I & II: Endangered migratory species conserved through agreements"; } } else { return 'Not Evaluated'; } } //End Mod 10/16/17 Shelumiel Ortiz function getSpawningAgg ($speccode){ global $conn; $qry = "SELECT SpawnAggID from spawnagg where SpecCode = $speccode "; $detail_result = $conn->query($qry); return $detail_result->num_rows; } function checkImageDisplay ($speccode) { global $conn; if ( !is_numeric($speccode) ) return FALSE; $query = "SELECT PicPreferredName, PicPreferredNameM, PicPreferredNameF, PicPreferredNameJ FROM species WHERE species.SpecCode = $speccode"; $result = $conn->query( $query ); $data = NULL; if ( is_object($result) ) { $row = $result->fetch_assoc(); if ( !empty($row['PicPreferredName']) ){return TRUE;} else{return FALSE;} } } function RegenerationTime($speccode) { global $conn; $query = "Select estimate.Median_T, estimate.lcl_T, estimate.ucl_T, estimate.n_T, species.FamCode From estimate Right Join species ON estimate.SpecCode = species.SpecCode WHERE species.SpecCode = $speccode"; $result = $conn->query($query); while ($row = $result->fetch_assoc()) { if ( $row['Median_T'] != NULL ){ if($row['n_T'] > 3){ $data = " Generation time: " . number_format($row['Median_T'], 1) . " (" . number_format($row['lcl_T'], 1) . " - " . number_format($row['ucl_T'], 1) . ") years. Estimated as median ln(3)/K based on " . $row['n_T'] . " growth studies.";} else{ $data = " Generation time: " . number_format($row['Median_T'], 1) . " ( na - na) years. Estimated as median ln(3)/K based on " . $row['n_T'] . " growth studies."; } //$data = "Prior r = " . $row['prior_r'] . ", 2 SD range = ". $row['l2SD_r']." - " . number_format($row[u2SD_r], 2) . ", log(r) = " . round(log($row['prior_r']),2) . ", SD log(r) = " . $row['sdlog_r'] . ", " . $row['Comment_r']; } } if(isset($data)){return $data;} else{return NULL;} }//end of function RegenerationTime($speccode) function getFishipedia($speccode){ global $conn; $querygetFishipedia = "SELECT stocks.FishipediaID FROM stocks WHERE stocks.SpecCode=$speccode"; $result = $conn->query( $querygetFishipedia ); $row = $result->fetch_assoc(); if ( isset($row['FishipediaID'])) { $Fishipedia = "http://www.fishipedia.fr" . $row['FishipediaID']; //$Fishipedia .= urlencode($speccode); $outputFishipedia = "Fishipedia"; } else{ $outputFishipedia = "Fishipedia"; } return $outputFishipedia; } function getSocotra($speccode){ global $conn; $querygetSocotra = "SELECT stocks.SocotraAtlasID FROM stocks WHERE stocks.SpecCode=$speccode"; $result = $conn->query( $querygetSocotra ); $row = $result->fetch_assoc(); if ( isset($row['SocotraAtlasID'])) { $Socotra = "http://socotra.senckenberg.de/FishAtlas/SocotraFishGuide.html?id=" . $row['SocotraAtlasID']; //$Fishipedia .= urlencode($speccode); $outputSocotra = "Socotra Atlas"; } else{ $outputSocotra = "Socotra Atlas"; } return $outputSocotra; } function getAforo ($speccode){ global $conn; $qry = "SELECT AFORO_ID from stocks where SpecCode = $speccode "; $detail_result = $conn->query($qry); $row = $detail_result->fetch_assoc(); if ( isset($row['AFORO_ID'])){ return "AFORO (otoliths)";} else{return "AFORO (otoliths)";} } ?> Reference Summary - Gon, O., 1999
Details for Gon, O., 1999
 
Citation Gon, O., 1999. Epigonidae. Deepwater cardinalfishes. p. 2611-2613. In K.E. Carpenter and V.H. Niem (eds.) FAO species identification guide for fishery purposes. The living marine resources of the Western Central Pacific. Volume 4. Bony fishes part 2 (Mugilidae to Carangidae). FAO, Rome.
DOI / ISBN
Paper URL http://www.fao.org/docrep/009/w7191e/w7191e00.HTM
Ref. No. 40513
Language English
Usage used in part
Remarks
Find this reference in Google Scholar | Scirus | Species used from this reference
(e.g. oophagy)
Back to Search
Comments & Corrections
cfm script by eagbayani, 12/10/04 ,  php script by rolavides, 09/05/08 ,  last modified by vagbay 06/22/22