$gene's $network_name |
";
#######Network
$count=0;
if($tab != "PPI"){
echo "
Gene ID | Annotation | Ortholog in Arabidopsis | Arabidopsis Annotation | PCC | MR |
";
$list_analysis="$gene\n";
$query=mysql_query("SELECT * FROM $tab WHERE geneA = '$gene' or geneB = '$gene' order by pcc desc limit 300");
while($result=mysql_fetch_row($query))
{
if($result[0] ==$gene)
{
$query1=mysql_query("SELECT * FROM ortholog_annotation WHERE gene = '$result[1]'");
$result1=mysql_fetch_row($query1);
$query2=mysql_query("SELECT * FROM annotation WHERE gene = '$result[1]'");
$result2=mysql_fetch_row($query2);
$pcc=sprintf("%.2f", $result[2]);
$mr=sprintf("%.2f", $result[3]);
$count++;
if($result1[1]==""){$result1[1]="--";}
if($result1[2]==""){$result1[2]="--";}
if($result2[4]==""){$result2[4]="--";}
echo "$result[1] | $result2[4] | $result1[1] | $result1[2] | $pcc | $mr |
";
$list_analysis.="$result[1]\n";
}
if($result[1] ==$gene)
{
$query1=mysql_query("SELECT * FROM ortholog_annotation WHERE gene = '$result[0]'");
$result1=mysql_fetch_row($query1);
$query2=mysql_query("SELECT * FROM annotation WHERE gene = '$result[0]'");
$result2=mysql_fetch_row($query2);
$pcc=sprintf("%.2f", $result[2]);
$mr=sprintf("%.2f", $result[3]);
$count++;
if($result1[1]==""){$result1[1]="--";}
if($result1[2]==""){$result1[2]="--";}
if($result2[4]==""){$result2[4]="--";}
echo "$result[0] | $result2[4] | $result1[1] | $result1[2] | $pcc | $mr |
";
$list_analysis.="$result[0]\n";
}
}
}
else {
echo "Gene ID | Ortholog(AT) | Annotation |
";
$query=mysql_query("SELECT * FROM $tab WHERE geneA = '$gene' or geneB = '$gene'");
while($result=mysql_fetch_row($query))
{
if($result[0] ==$gene)
{
$query1=mysql_query("SELECT * FROM ortholog_annotation WHERE gene = '$result[1]'");
$result1=mysql_fetch_row($query1);
$count++;
echo "$result[1] | $result1[1] | $result1[3] |
";
}
if($result[1] ==$gene)
{
$query1=mysql_query("SELECT * FROM ortholog_annotation WHERE gene = '$result[0]'");
$result1=mysql_fetch_row($query1);
$mr=sprintf("%.2f", $result[3]);
$count++;
echo "$result[0] | $result1[1] | $result1[3] |
";
}
}
}
?>
print $footer;
?>