<html>
<head>
<title>ANISEED - Ascidian contributors</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="description" content="This page lists people who contributes to the Aniseed project. If you want to participate to this project, please contact Delphine Dauga at dauga@ibdm.univ-mrs.fr.">
<meta name="keywords" content="Lemaire, Tassy, Daian, Sobral, Dauga, Aniseed project, Ascidian labs, Ciona intestinalis, Halocynthia roretzi, Aniseed, Ciona intestinalis database">
<meta name = "robots" content = "index, follow, all">
<META HTTP-EQUIV="Content-Language" CONTENT="EN">
<style type="text/css">
</style>
</head>

<?php
/*
    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");
//Title before frames_header
print '<title>ANISEED v3.0 - Contributors </title>';

    include("frames_header.php");
?>

<table width="100%" border="0">
<tr>
<td width="50%" valign="top">
    <center>
    <br><font color="#D64242" size="3"><b>ANISEED contributors</b></font><br><br>
    <table width="90%" border="0" cellspacing="0" cellpadding="0">
    <tr align="center" valign="middle"><td><font color="#456898" size="2"><b>Name</b></font></td><td><font color="#456898" size="2"><b>Lab</b></font></td><td><font color="#456898" size="2"><b>In situ records</b></font></td><td><font color="#456898" size="2"><b>Rank</b></font></td></tr><tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>

<?php


	$sql="SELECT count(a.\"AUTHOR_ID\") as score, a.\"AUTHOR_ID\" FROM \"ENTRY_ORIGIN\" a, \"IN_SITU\" b WHERE
	(a.\"BIO_ID\"=b.\"IN_SITU_ID\") and (b.\"CHECKED\"='y') and (b.\"PRIVATE\"='n') GROUP BY a.\"AUTHOR_ID\" ORDER BY score DESC";

	$query=pg_query($c,$sql);
	$rank=0;
	
	while ($row=pg_fetch_array($query))
	{
		$sql2="SELECT \"NAME\", \"SURNAME\", \"MAIL\", \"TEAM\" FROM \"AUTHOR\" WHERE \"AUTHOR_ID\"=".$row["AUTHOR_ID"];
				
		$query2=pg_query($c,$sql2);
		
		while ($row2=pg_fetch_array($query2))
			{
			 print "<tr align=\"center\" valign=\"middle\" >
				<td>
				<a href=\"mailto:".$row2["MAIL"]."\"><font color=\"#000000\" size=\"-1\">".$row2["SURNAME"]." ".$row2["NAME"]."</font></a>
				</td>
				<td><font color=\"#656565\" size=\"-1\">".$row2["TEAM"]."</font></td>
				<td>
				<a href=\"insitu-result.php?author=".$row2["NAME"]."\"><font color=\"#000000\" size=\"-1\">".$row["score"]."</font></a>
				</td>
				<td><font color=\"#656565\" size=\"-1\">".++$rank."</font></td>
				</tr>";
			}

	}
?>
    
    </table>
    </center>
</td>
<td width="50%" valign="top" style="border-left:1px solid black;">

    <center>
    <br><font color="#D64242" size="3"><b>ANISEED annotators</b></font><br><br>
    <table width="90%" border="0" cellspacing="0" cellpadding="0">
    <tr align="center" valign="middle"><td><font color="#456898" size="2"><b>Name</b></font></td><td><font color="#456898" size="2"><b>Lab</b></font></td><td><font color="#456898" size="2"><b>In situ records</b></font></td><td><font color="#456898" size="2"><b>Rank</b></font></td></tr><tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>

<?php


	$sql="SELECT count(a.\"ANNOTATOR_ID\") as score, a.\"ANNOTATOR_ID\" FROM \"ENTRY_ORIGIN\" a, \"IN_SITU\" b WHERE
	(a.\"BIO_ID\"=b.\"IN_SITU_ID\") and (b.\"CHECKED\"='y') and (b.\"PRIVATE\"='n') GROUP BY a.\"ANNOTATOR_ID\" ORDER BY score DESC";

	$query=pg_query($c,$sql);
	$rank=0;
	
	while ($row=pg_fetch_array($query))
	{
	if ($row["score"]==0) break;
		$sql2="SELECT \"NAME\", \"SURNAME\", \"MAIL\", \"TEAM\" FROM \"AUTHOR\" WHERE \"AUTHOR_ID\"='".$row["ANNOTATOR_ID"]."'";

		$query2=pg_query($c,$sql2);
		
		while ($row2=pg_fetch_array($query2))
			{
			 print "<tr align=\"center\" valign=\"middle\" >
				<td>
				<a href=\"mailto:".$row2["MAIL"]."\"><font color=\"#000000\" size=\"-1\">".$row2["SURNAME"]." ".$row2["NAME"]."</font></a>
				</td>
				<td><font color=\"#656565\" size=\"-1\">".$row2["TEAM"]."</font></td>
				<td>
				<a href=\"insitu-result.php?annotator=".$row2["NAME"]."\"><font color=\"#000000\" size=\"-1\">".$row["score"]."</font></a>
				</td>
				<td><font color=\"#656565\" size=\"-1\">".++$rank."</font></td>
				</tr>";
			}

	}
?>
    
    </table>
    </center>
    
<br>
<br>
<center>
<font color="#D64242" size="3"><b>Labs contributors</b></font><br>
<br>
<br>
<A HREF="http://www.ibdm.univ-mrs.fr/index_gb.php" target="_blank">
<font color="#000000" size="3"><b> IBDM </b></font></a>-
<font color="#656565" size="2"><b><u>Patrick Lemaire</u></b></font> 
<br>
<font color="#656565" size="-1">
Campus de Luminy case 907 F-13288 Marseille Cedex 09<br>
Tel +33 491 269600<br>
Fax +33 491 820682<br>
</font>
<br>
<br>
<strong><A HREF="http://www.tokushima-u.ac.jp/" target="_blank">
<font color="#000000" size="3"><b> Tokushima University </b></font></a>-
<font color="#656565" size="2"><b><u>Kazuhiro W. Makabe</u></b></font>
<br>
<font color="#656565" size="-1">
Dept. Integrated Arts and Sciences, Tokushima Univ., Minami-Josanjima 1-1, Tokushima 770-8502, Japan<br>
Tel (088)656-7269 <br>
<br>
<br>

<a href="http://www.cnrs-gif.fr/" target="_blank"><font color="#000000" size="3"><b> CNRS </b>
</font></a>- <font color="#656565" size="2"><b><u>Jean-Stehane Joly</u></b></font>
<br>
<font color="#656565" size="-1">
Institut de Neurobiologie Alfred Fessard (CNRS), Gif-sur-Yvette
</font>

</td>
</tr>
</table>

<br><br><br><br>
<center><font color="#656565" size="-1"><b>&nbsp;&nbsp;&nbsp;Many thanks for contributing to this project.</b></font></center>


<?php
    include("frames_footer.php");
?>