#include('.compress.php'); print '
'; print '"; $selecao=mysql_select_db("ue_cog",$conexao); if($selecao==0) echo "Conexao ao banco de dados nao estabelecida!
"; //seleciona o a função de determinada categoria para preencher o título $int_funcao=mysql_query("select * from fun where fun='$categoria'"); $funcao=mysql_fetch_row($int_funcao); ///-----------------imprime o título----------------// print '
$funcao[1] - $funcao[2] |
'; print ""; print '
'; echo "COG ID | "; print ''; echo "Definition | "; print'Pk | '; print'A | '; print'B | '; print'Ac | '; print'Fm | '; print'Pb | '; print'Ot | '; //-------------linhas do select para pegar o numero de ests por categoria por bicho------------//// $get_all_cog_num = mysql_query("select distinct(cog_num) as cog_num, descricao from edited_cog_fun_desc where fun = \"$categoria\" and valida != 5"); $pk_seqs =""; $cog_num=""; while ($all_cogs = mysql_fetch_array($get_all_cog_num, MYSQL_ASSOC)) { $cog_num=$all_cogs["cog_num"]; $descricao = $all_cogs["descricao"]; ### Pk $int_pk = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and bac_class<5 and valida != 5"); $int_pk_value = mysql_fetch_row($int_pk); $ue_pk = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num'"); $ue_pk_value = mysql_fetch_row($ue_pk); ## A $int_a = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and bac_class=0 and valida != 5"); $int_a_value = mysql_fetch_row($int_a); $ue_a = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num' and bac_class_d = 0 "); $ue_a_value = mysql_fetch_row($ue_a); ## B $int_b = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and (bac_class>0 and bac_class<5 and valida != 5)"); $int_b_value = mysql_fetch_row($int_b); $ue_b = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num' and bac_class_d>0 "); $ue_b_value = mysql_fetch_row($ue_b); ## Ac $int_ac = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and bac_class = 1 and valida != 5"); $int_ac_value = mysql_fetch_row($int_ac); $ue_ac = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num' and bac_class_d = 1 "); $ue_ac_value = mysql_fetch_row($ue_ac); ## Fm $int_fm = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and bac_class=2 and valida != 5"); $int_fm_value = mysql_fetch_row($int_fm); $ue_fm = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num' and bac_class_d = 2 "); $ue_fm_value = mysql_fetch_row($ue_fm); ## Pb $int_pb = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and bac_class=3 and valida != 5"); $int_pb_value = mysql_fetch_row($int_pb); $ue_pb = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num' and bac_class_d = 3 "); $ue_pb_value = mysql_fetch_row($ue_pb); # Ot $int_ot = mysql_query("select count(distinct(ident)) FROM edited_cog_fun_desc WHERE cog_num='$cog_num' and bac_class=4 and valida != 5"); $int_ot_value = mysql_fetch_row($int_ot); $ue_ot = mysql_query("select count(distinct(recruited)) FROM redund_fun_ok WHERE cog_num='$cog_num' and bac_class_d = 4 "); $ue_ot_value = mysql_fetch_row($ue_ot); //IMPRIME A LINHA DE LINKS NO NCBI print '
"; print "$cog_num"; print ' | '; echo "$descricao | "; echo "$int_pk_value[0] ($ue_pk_value[0]) | ";
echo "$int_a_value[0] ($ue_a_value[0]) | ";
echo "$int_b_value[0] ($ue_b_value[0]) | ";
echo "$int_ac_value[0] ($ue_ac_value[0]) | ";
echo "$int_fm_value[0] ($ue_fm_value[0]) | ";
echo "$int_pb_value[0] ($ue_pb_value[0]) | ";
echo "$int_ot_value[0] ($ue_ot_value[0]) | ";
echo "