<html>
<head>
<title>ANISEED - Ascidian articles present in Aniseed</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="description" content="This page will list all the ascidian articles that are described in Aniseed. Currently, there are 120 Ciona intestinalis articles in the Ciona intestinalis database.">
<meta name="keywords" content="Lemaire, Tassy, Daian, Dauga, Sobral, Khoueiry, Aniseed, Ciona intestinalis, Ciona intestinalis articles, Ascidian articles, Ascidian publication, Ciona publication.">
<meta name = "robots" content = "index, follow, all">
<META HTTP-EQUIV="Content-Language" CONTENT="EN">
<style type="text/css">
</style>
</head>

<?
/*
    ANISEED, NISEED System and Database
    Copyright (C) 2007 Olivier Tassy, Fabrice Daian, Patrick Lemaire

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.

*/
include ("connection.php");
include ("frames_header.php");

?>
<font color="#D64242" size="3"><b>Articles in the database</b></font><br><br>

<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center"><font color="#456898" size="2"><b>Title</b></font></td><td align="center"><font color="#456898" size="2"><b>Journal</b></font></td><td align="center"><font color="#456898" size="2"><b>Authors</b></font></td><td align="center"><font color="#456898" size="2"><b>Aniseed data</b></font></td><td align="center"><font color="#456898" size="2"><b>Pubmed</b></font></td></tr>
<?
//Recuperer les abstract de tous les articles present dans la databse

$requete="SELECT distinct \"PUBMED_ID\",\"PAPER\",\"TITLE\",\"AUTHORS\" from \"REFERENCE\" where \"BIO_ID\" in (select \"IN_SITU_ID\" from \"IN_SITU\" where \"CHECKED\"='y' and \"PRIVATE\"='n')";
//$requete="SELECT distinct ref.\"PUBMED_ID\",ref.\"PAPER\",ref.\"TITLE\",ref.\"AUTHORS\",ish.\"PRIVATE\",ish.\"CHECKED\" from \"REFERENCE\" ref, \"IN_SITU\" ish where ref.\"BIO_ID\" in (select \"IN_SITU_ID\" from \"IN_SITU\") and ish.\"IN_SITU_ID\"=ref.\"BIO_ID\"";


//$requete="SELECT \"ARTICLE_ID\",\"PUBMED_ID\",\"PAPER\",\"TITLE\",\"AUTHORS\" from \"ARTICLE\" where \"PRIVATE\"='n' and \"CHECKED\"='y'";


$stmt=pg_query($c,$requete);
print "<center><em><b>".pg_num_rows($stmt)." </b> public articles are in the database</center></em><br>";

while ($row=pg_fetch_array($stmt))
{
$pmid=$row["PUBMED_ID"];
$paper=$row["PAPER"];
$title=$row["TITLE"];
$auteur=$row["AUTHORS"];


$requete0="SELECT \"ARTICLE_ID\" from \"ARTICLE\" where \"PUBMED_ID\"='$pmid'";
$stmt0=pg_query($c,$requete0);
$row0=pg_fetch_array($stmt0);

$article_id=$row0["ARTICLE_ID"];

// $private=$row["PRIVATE"];
// $checked=$row["CHECKED"];

$contents="";



if (strlen($pmid)==0) continue;



 print "<td style=\"border-top:1px solid black;\" valign=\"center\"><font color=\"#656565\" size=\"-2\">$title</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" ><font color=\"#656565\" size=\"-2\">$paper</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" ><font color=\"#656565\" size=\"-2\">$auteur</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" align=\"center\"><font color=\"#656565\" size=\"-2\">

<a href=\"view-article.php?id=$article_id\"><img src=\"pictures/mini-aniseed.jpg\" border=\"0\"></a>
<!--<a href=\"biblio.php?pmid=$pmid\"><img src=\"pictures/mini-aniseed.jpg\" border=\"0\"></a>-->

</td><td style=\"border-top:1px solid black;\" valign=\"center\" align=\"center\"><font color=\"#656565\" size=\"-2\"><a href=\"http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Retrieve&list_uids=$pmid&dopt=Abstract\"><font color=\"#000000\" size=\"-2\"><img src=\"pictures/mini-pubmed.jpg\" border=\"0\"></a></font></td>";


print "</tr>";

}

print "</table>";



?>
<br><br>

<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center"><font color="#456898" size="2"><b>Title</b></font></td><td align="center"><font color="#456898" size="2"><b>Journal</b></font></td><td align="center"><font color="#456898" size="2"><b>Authors</b></font></td><td align="center"><font color="#456898" size="2"><b>Aniseed data</b></font></td><td align="center"><font color="#456898" size="2"><b>Pubmed</b></font></td></tr>
<?
////////////////////////////////

$requete="
SELECT distinct \"PUBMED_ID\",\"PAPER\",\"TITLE\",\"AUTHORS\" from \"REFERENCE\" where \"BIO_ID\" in (select \"IN_SITU_ID\" from \"IN_SITU\")
EXCEPT
SELECT distinct \"PUBMED_ID\",\"PAPER\",\"TITLE\",\"AUTHORS\" from \"REFERENCE\" where \"BIO_ID\" in (select \"IN_SITU_ID\" from \"IN_SITU\" where \"CHECKED\"='y' and \"PRIVATE\"='n')
";

$stmt=pg_query($c,$requete);
print "<center><em><b>".pg_num_rows($stmt)." </b> articles are being entered and will be available soon.</center></em><br>";

while ($row=pg_fetch_array($stmt))
{
$pmid=$row["PUBMED_ID"];
$paper=$row["PAPER"];
$title=$row["TITLE"];
$auteur=$row["AUTHORS"];

// $private=$row["PRIVATE"];
// $checked=$row["CHECKED"];

$contents="";



if (strlen($pmid)==0) continue;



 print "<td style=\"border-top:1px solid black;\" valign=\"center\"><font color=\"#656565\" size=\"-2\">$title</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" ><font color=\"#656565\" size=\"-2\">$paper</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" ><font color=\"#656565\" size=\"-2\">$auteur</font></td><td style=\"border-top:1px solid black;\" valign=\"center\" align=\"center\"><font color=\"#656565\" size=\"-2\">Available soon</td><td style=\"border-top:1px solid black;\" valign=\"center\" align=\"center\"><font color=\"#656565\" size=\"-2\"><a href=\"http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed&cmd=Retrieve&list_uids=$pmid&dopt=Abstract\"><font color=\"#000000\" size=\"-2\"><img src=\"pictures/mini-pubmed.jpg\" border=\"0\"></a></font></td>";


print "</tr>";

}

print "</table>";











print "</table>";

include ("frames_footer.php");
?>