1)
dotaz pro vyber z phobia do tabulky phobius vyber:

create table phobius_vyber 
select id_p, ft, ft_tm, ft_sig from phobius 
where (ft_tm = 0 and ft_sig = 1) or 
      (ft_tm = 1 and ft_sig = 0) or 
      (ft_tm = 1 and ft_sig = 1);

2)
dotaz pro prunik elm motivu a vybranych proteinu na tm a sig:
ELM:

select phobius_vyber.id_p, phobius_vyber.ft_tm, phobius_vyber.ft_sig,
            count_elm.id_mot, count_elm.cnt, motif_elm.motif, motif_elm.motif_des
from phobius_vyber, count_elm, motif_elm 
where phobius_vyber.id_p = count_elm.id_p and count_elm.id_mot = motif_elm.id_mot 
order by id_p;

uprava, kdyz uz mam skorovani hotovy:

TYR:

select phobius_vyber.id_p, phobius_vyber.ft_tm, phobius_vyber.ft_sig, 
            score_tyr.id_tyr, score_tyr.soucet, motif_tyr.motif, motif_tyr.motif_des
from phobius_vyber, score_tyr, motif_tyr 
where phobius_vyber.id_p = score_tyr.id_p and score_tyr.id_tyr= motif_tyr.id_tyr 
order by id_p;

spravny prunik:

select id_p, ft_tm, ft_sig, id_tyr, soucet 
from phobius_vyber left join score_tyr using(id_p);

3)
skorovani:

select count_elm.id_p, count_elm.id_mot, count_elm.cnt, 
            count_elm.cnt* motif_elm.score as soucet 
from count_elm, motif_elm 
where count_elm.id_mot = motif_elm.id_mot;

update skorovani - vytvorim prechodnou tabulku s hodnotami score pro jednotlive motivy v jednotlivych proteinech:

ELM:

create table score_elm 
select count_elm.id_p, count_elm.id_mot, count_elm.cnt, 
       motif_elm.score, count_elm.cnt*motif_elm.score as soucet 
from count_elm, motif_elm 
where count_elm.id_mot = motif_elm.id_mot;

TYR:

create table score_tyr 
select count_tyr.id_p, count_tyr.id_tyr, count_tyr.cnt, 
       motif_tyr.score, count_tyr.cnt*motif_tyr.score as soucet 
from count_tyr, motif_tyr 
where count_tyr.id_tyr = motif_tyr.id_tyr;

dotaz pro celkove skore daneho proteinu spocitane pro vsechny motivy uvnitr proteinu:

select id_p, SUM(soucet) as suma from score_elm group by id_p;