'; print '

UE-COG - UniRef-Enriched COG Database

'; print '
[BACK] '; print '
'; ### setting passed parameters $categoria = $_REQUEST['categoria']; ### setting db connection $conexao=mysql_connect("localhost","gabriel","biodados"); if ($conexao==0) echo "Conexao ao servidor nao estabelecida!

"; $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 ''; print ''; print""; print '

$funcao[1] - $funcao[2]





'; print'

Legend (Click on numbers to download fastas)

'; print ""; print ''; print ''; print '"; print '"; print''; print''; print''; print''; print''; print''; print''; //-------------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 "'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; }//fecha o while mysql fetch array print '
'; echo "COG ID'; echo "DefinitionPkABAcFmPbOt
"; print "$cog_num"; print '$descricao$int_pk_value[0]
($ue_pk_value[0])
$int_a_value[0]
($ue_a_value[0])
$int_b_value[0]
($ue_b_value[0])
$int_ac_value[0]
($ue_ac_value[0])
$int_fm_value[0]
($ue_fm_value[0])
$int_pb_value[0]
($ue_pb_value[0])
$int_ot_value[0]
($ue_ot_value[0])

[BACK TO MAIN PAGE]

'; ?>