$group's genelist
";
echo "
";
if($genefamily == "TF" )
{
echo "
";
echo "Order | Member | Pfam | Best_hit | Description |
";
$sql="SELECT * from TF WHERE family='$group'";
$query = mysql_query($sql,$con);
$result=array();
$i=0;
while($result=mysql_fetch_row($query))
{$i++;
echo "$i | $result[2] | $result[3] | $result[4] | $result[5] |
";
}
echo "
";
}
if($genefamily == "PK" )
{
echo "
";
echo "Order | Member | Pfam | Best_hit | Description |
";
$sql="SELECT * from PK WHERE family='$group'";
$query = mysql_query($sql,$con);
$result=array();
$i=0;
while($result=mysql_fetch_row($query))
{$i++;
echo "$i | $result[1] | $result[2] | $result[3] | $result[4] |
";
}
echo "
";
}
if($genefamily == "Ubs" )
{
echo "
";
echo "Order | Member | Pfam | Best_hit | Description |
";
$sql="SELECT * from Ubs WHERE family='$group'";
$query = mysql_query($sql,$con);
$result=array();
$i=0;
while($result=mysql_fetch_row($query))
{$i++;
echo "$i | $result[1] | $result[2] | $result[3] | $result[4] |
";
}
echo "
";
}
if($genefamily == "CAZy" )
{
echo "
";
echo "Order | Member | Pfam | Best_hit | Description |
";
$sql="SELECT * from CAZy WHERE family='$group'";
$query = mysql_query($sql,$con);
$result=array();
$i=0;
while($result=mysql_fetch_row($query))
{$i++;
echo "$i | $result[1] | $result[2] | $result[3] | $result[4] |
";
}
echo "
";
}
if($genefamily == "P450" )
{
echo "
";
echo "Member | P450 ID | Pfam | best hit | Description | Network |
";
$sql="SELECT * from P450 WHERE family like '%$group%'";
$query = mysql_query($sql,$con);
$result=array();
while($result=mysql_fetch_row($query))
{
echo "$result[1] | $result[0] | $result[2] | $result[3] | $result[4] | Network | ";
}
echo "
";
}
if($genefamily == "EAR" )
{
echo "
";
echo "Order | Member | Pfam | Best_hit | Description |
";
$sql="SELECT * from EAR WHERE family='$group'";
$query = mysql_query($sql,$con);
$result=array();
$i=0;
while($result=mysql_fetch_row($query))
{$i++;
echo "$i | $result[2] | $result[3] | $result[4] | $result[5] |
";
}
echo "
";
}
?>