";
echo "| Genome name | No. proteins | ";
echo "Description | Date added |
";
// plants: plant, moss_fern, green algae, rhodophyta
$moss = array();
$galgae = array();
$rhodo = array();
//
$diatom = array();
//
$fungi = array();
$vert = array();
// urochordata + cephalochordata
$urochor = array();
//
$echino = array();
$arthro = array();
$nematode = array();
$annelida = array();
$platyhelminthes = array();
$mollusca = array();
$cnidaria = array();
$porifera = array();
$placozoa = array();
// other metazoa
$metazoa = array();
// choanoflagellates
$choanozoa = array();
//
$amoebozoa = array();
// alveolata: ciliates
$alveolata = array();
// stramenopile: (diatom), oomycetes, brown algae
$stramenopile = array();
$haptophyte = array();
// excavata: euglenids
$excavata = array();
echo "| [Land plants] |
";
for ($i=0; $i <$num; $i++){
$row = mysql_fetch_array($result1);
if ($row["taxonomy"] == "plant") {
echo "| " . $row["species"] . " | " . $row["nseq"] .
" | " . $row["description"] . " | " . "" . $row["date"] . " |
";
}
elseif ($row["taxonomy"] == "moss_fern") {
array_push ($moss, $row);
}
elseif ($row["taxonomy"] == "g_algae") {
array_push ($galgae, $row);
}
elseif ($row["taxonomy"] == "rhodophyta") {
array_push ($rhodo, $row);
}
elseif ($row["taxonomy"] == "diatom") {
array_push ($diatom, $row);
}
elseif ($row["taxonomy"] == "fungi") {
array_push ($fungi, $row);
}
elseif ($row["taxonomy"] == "vert") {
array_push ($vert, $row);
}
elseif ($row["taxonomy"] == "urochor") {
array_push ($urochor, $row);
}
elseif ($row["taxonomy"] == "echino") {
array_push ($echino, $row);
}
elseif ($row["taxonomy"] == "arthro") {
array_push ($arthro, $row);
}
elseif ($row["taxonomy"] == "nematode") {
array_push ($nematode, $row);
}
elseif ($row["taxonomy"] == "annelida") {
array_push ($annelida, $row);
}
elseif ($row["taxonomy"] == "mollusca") {
array_push ($mollusca, $row);
}
elseif ($row["taxonomy"] == "cnidaria") {
array_push ($cnidaria, $row);
}
elseif ($row["taxonomy"] == "choanozoa") {
array_push ($choanozoa, $row);
}
elseif ($row["taxonomy"] == "amoebozoa") {
array_push ($amoebozoa, $row);
}
elseif ($row["taxonomy"] == "alveolata") {
array_push ($alveolata, $row);
}
elseif ($row["taxonomy"] == "stramenopile") {
array_push ($stramenopile, $row);
}
elseif ($row["taxonomy"] == "haptophyte") {
array_push ($haptophyte, $row);
}
elseif ($row["taxonomy"] == "excavata") {
array_push ($excavata, $row);
}
elseif ($row["taxonomy"] == "porifera") {
array_push ($porifera, $row);
}
elseif ($row["taxonomy"] == "platyhelminthes") {
array_push ($platyhelminthes, $row);
}
elseif ($row["taxonomy"] == "placozoa") {
array_push ($placozoa, $row);
}
}
mysql_close();
echo "| [Mosses & Ferns] |
";
$num = count($moss);
for ($i=0; $i <$num; $i++){
echo "| " . $moss[$i]["species"] . " | " .
$moss[$i]["nseq"] . " | " . $moss[$i]["description"] . " | " .
"" . $moss[$i]["date"] . " |
";
}
echo "| [Green algae] |
";
$num = count($galgae);
for ($i=0; $i <$num; $i++){
echo "| " . $galgae[$i]["species"] . " | " .
$galgae[$i]["nseq"] . " | " . $galgae[$i]["description"] . " | " .
"" . $galgae[$i]["date"] . " |
";
}
echo "| [Rhodophytes] |
";
$num = count($rhodo);
for ($i=0; $i <$num; $i++){
echo "| " . $rhodo[$i]["species"] . " | " .
$rhodo[$i]["nseq"] . " | " . $rhodo[$i]["description"] . " | " .
"" . $rhodo[$i]["date"] . " |
";
}
echo "| [Fungi] |
";
$num = count($fungi);
for ($i=0; $i <$num; $i++){
echo "| " . $fungi[$i]["species"] . " | " .
$fungi[$i]["nseq"] . " | " . $fungi[$i]["description"] . " | " .
"" . $fungi[$i]["date"] . " |
";
}
echo "| [Vertebrates] |
";
$num = count($vert);
for ($i=0; $i <$num; $i++){
echo "| " . $vert[$i]["species"] . " | " .
$vert[$i]["nseq"] . " | " . $vert[$i]["description"] . " | " .
"" . $vert[$i]["date"] . " |
";
}
echo "| [Urochordates & Cephalochordata] |
";
$num = count($urochor);
for ($i=0; $i <$num; $i++){
echo "| " . $urochor[$i]["species"] . " | " .
$urochor[$i]["nseq"] . " | " . $urochor[$i]["description"] . " | " .
"" . $urochor[$i]["date"] . " |
";
}
echo "| [Echinoderms] |
";
$num = count($echino);
for ($i=0; $i <$num; $i++){
echo "| " . $echino[$i]["species"] . " | " .
$echino[$i]["nseq"] . " | " . $echino[$i]["description"] . " | " .
"" . $echino[$i]["date"] . " |
";
}
echo "| [Arthropodes] |
";
$num = count($arthro);
for ($i=0; $i <$num; $i++){
echo "| " . $arthro[$i]["species"] . " | " .
$arthro[$i]["nseq"] . " | " . $arthro[$i]["description"] . " | " .
"" . $arthro[$i]["date"] . " |
";
}
echo "| [Nematodes] |
";
$num = count($nematode);
for ($i=0; $i <$num; $i++){
echo "| " . $nematode[$i]["species"] . " | " .
$nematode[$i]["nseq"] . " | " . $nematode[$i]["description"] .
" | " . "" . $nematode[$i]["date"] . " |
";
}
echo "| [Annelida] |
";
$num = count($annelida);
for ($i=0; $i <$num; $i++){
echo "| " . $annelida[$i]["species"] . " | " .
$annelida[$i]["nseq"] . " | " . $annelida[$i]["description"] .
" | " . "" . $annelida[$i]["date"] . " |
";
}
echo "| [Platyhelminthes] |
";
$num = count($platyhelminthes);
for ($i=0; $i <$num; $i++){
echo "| " . $platyhelminthes[$i]["species"] . " | " .
$platyhelminthes[$i]["nseq"] . " | " . $platyhelminthes[$i]["description"] .
" | " . "" . $platyhelminthes[$i]["date"] . " |
";
}
echo "| [Mollusca] |
";
$num = count($mollusca);
for ($i=0; $i <$num; $i++){
echo "| " . $mollusca[$i]["species"] . " | " .
$mollusca[$i]["nseq"] . " | " . $mollusca[$i]["description"] .
" | " . "" . $mollusca[$i]["date"] . " |
";
}
echo "| [Cnidaria] |
";
$num = count($cnidaria);
for ($i=0; $i <$num; $i++){
echo "| " . $cnidaria[$i]["species"] . " | " .
$cnidaria[$i]["nseq"] . " | " . $cnidaria[$i]["description"] . " | " .
"" . $cnidaria[$i]["date"] . " |
";
}
echo "| [Porifera] |
";
$num = count($porifera);
for ($i=0; $i <$num; $i++){
echo "| " . $porifera[$i]["species"] . " | " .
$porifera[$i]["nseq"] . " | " . $porifera[$i]["description"] . " | " .
"" . $porifera[$i]["date"] . " |
";
}
echo "| [Placozoa] |
";
$num = count($placozoa);
for ($i=0; $i <$num; $i++){
echo "| " . $placozoa[$i]["species"] . " | " .
$placozoa[$i]["nseq"] . " | " . $placozoa[$i]["description"] . " | " .
"" . $placozoa[$i]["date"] . " |
";
}
// echo "| [Other metazoa] |
";
// $num = count($metazoa);
// for ($i=0; $i <$num; $i++){
// echo "| " . $metazoa[$i]["species"] . " | " .
// $metazoa[$i]["nseq"] . " | " . $metazoa[$i]["description"] . " | " .
// "" . $metazoa[$i]["date"] . " |
";
// }
echo "| [Choanoflagellates] |
";
$num = count($choanozoa);
for ($i=0; $i <$num; $i++){
echo "| " . $choanozoa[$i]["species"] . " | " .
$choanozoa[$i]["nseq"] . " | " . $choanozoa[$i]["description"] . " | " .
"" . $choanozoa[$i]["date"] . " |
";
}
echo "| [Amoebozoa] |
";
$num = count($amoebozoa);
for ($i=0; $i <$num; $i++){
echo "| " . $amoebozoa[$i]["species"] . " | " .
$amoebozoa[$i]["nseq"] . " | " . $amoebozoa[$i]["description"] . " | " .
"" . $amoebozoa[$i]["date"] . " |
";
}
echo "| [Alveolates] |
";
$num = count($alveolata);
for ($i=0; $i <$num; $i++){
echo "| " . $alveolata[$i]["species"] . " | " .
$alveolata[$i]["nseq"] . " | " . $alveolata[$i]["description"] . " | " .
"" . $alveolata[$i]["date"] . " |
";
}
// echo "| [Stramenopiles (Heterokonts): Diatoms] |
";
// $num = count($diatom);
// for ($i=0; $i <$num; $i++){
// echo "| " . $diatom[$i]["species"] . " | " .
// $diatom[$i]["nseq"] . " | " . $diatom[$i]["description"] . " | " .
// "" . $diatom[$i]["date"] . " |
";
// }
echo "| [Stramenopiles (Heterokonts)] |
";
$num = count($stramenopile);
for ($i=0; $i <$num; $i++){
echo "| " . $stramenopile[$i]["species"] . " | " .
$stramenopile[$i]["nseq"] . " | " . $stramenopile[$i]["description"] . " | " .
"" . $stramenopile[$i]["date"] . " |
";
}
echo "| [Haptophyte] |
";
$num = count($haptophyte);
for ($i=0; $i <$num; $i++){
echo "| " . $haptophyte[$i]["species"] . " | " .
$haptophyte[$i]["nseq"] . " | " . $haptophyte[$i]["description"] . " | " .
"" . $haptophyte[$i]["date"] . " |
";
}
echo "| [Excavates] |
";
$num = count($excavata);
for ($i=0; $i <$num; $i++){
echo "| " . $excavata[$i]["species"] . " | " .
$excavata[$i]["nseq"] . " | " . $excavata[$i]["description"] . " | " .
"" . $excavata[$i]["date"] . " |
";
}
?>