[BACK]"); #$type = $_REQUEST['type'] || die ("no type selected\n [BACK]"); #$bclass = $_REQUEST['bclass'] || die ("no bclass selected\n [BACK]"); #$cog_num = $_REQUEST['cog_num'] || die ("no cog_num selected\n [BACK]"); #print "$categ.$type.$bclass.$cog_num
"; $categ = $_REQUEST['categ']; $type = $_REQUEST['type']; $bclass = $_REQUEST['bclass']; $cog_num = $_REQUEST['cog_num']; ### set function function fetch_fasta($mysql_query,$categ,$cog_num,$type,$bclass){ ### 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!

"; $fastas=""; $get_fasta= mysql_query("$mysql_query"); while ($fasta_array = mysql_fetch_array($get_fasta,MYSQL_NUM)){ $fastas .= ">$fasta_array[0]\n".$fasta_array[1]."\n"; } if($fastas!=""){ $filename = $type."_".$bclass."_".$cog_num."_".$categ.".gz"; #print "$fastas"; header("Content-type: encoded/gzip"); header("Content-Decoded-Type: text/plain"); header("Content-Disposition: attachment; filename=\"$filename\""); echo gzencode($fastas, 9); } else { print ''; print '

UE-COG - UniRef-Enriched COG Database

'; print '
[BACK] '; print '
'; if($cog_num){ print "

No sequence selected!\n[BACK]

"; } else{ print "

No sequence selected!\n[BACK]

"; } } } #print ''; #print '

UE-COG - UniRef-Enriched COG Database

'; #print '
[BACK TO MAIN PAGE] '; #print '
'; #### Make select if($type== 'cog'){ if ($bclass == 'pk'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class < 5 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class < 5 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida!=5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'a'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class = 0 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class = 0 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'b'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class >0 and edited_cog_fun_desc.bac_class< 5 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class >0 and edited_cog_fun_desc.bac_class< 5 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'ac'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class = 1 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class = 1 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'fm'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class = 2 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class = 2 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'pb'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class = 3 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class = 3 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'ot'){ if($cog_num){ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.cog_num=\"$cog_num\" and edited_cog_fun_desc.bac_class = 4 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } else{ $query = "select fastas.* FROM edited_cog_fun_desc, fastas WHERE edited_cog_fun_desc.bac_class = 4 and edited_cog_fun_desc.UniProt_ac = fastas.id and edited_cog_fun_desc.fun=\"$categ\" and valida != 5 group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } } elseif($type == 'ue'){ if ($bclass == 'pk'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d < 5 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d < 5 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'a'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d = 0 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d = 0 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'b'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d < 5 and bac_class_d>0 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d < 5 and bac_class_d>0 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'ac'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d = 1 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d = 1 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'fm'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d = 2 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d = 2 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'pb'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d = 3 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d = 3 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } elseif($bclass == 'ot'){ if($cog_num){ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.cog_num=\"$cog_num\" and redund_fun_ok.bac_class_d = 4 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } else{ $query = "select fastas.* FROM redund_fun_ok, fastas WHERE redund_fun_ok.bac_class_d = 4 and redund_fun_ok.recruited = fastas.id and redund_fun_ok.fun=\"$categ\" group by fastas.id"; } fetch_fasta($query,$categ,$cog_num,$type,$bclass); } } #print ""; ?>