### get variables
#$categ = $_REQUEST['categ'] || die ("no category selected\n [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 "";
?>