-- concept-relatedness, tanimoto/cosin
--
select if (A.is_nn>0, "NN", "") as NN,
    A.term_a, A.term_b, round(A.score,3) as zg, 
	if (B.concept_a is not null, B.concept_a, "") as concept_a, 
	if (B.concept_b is not null, B.concept_b, "") as concept_b,
	if (B.found>0, round(B.score,3), "") as cosin, 
    if (B.found>0, round(C.score,3), "") as tani
from full_de_relatedness_survey as A
join full_de_relatedness_survey as B on A.term_a = B.term_a and A.term_b = B.term_b and B.batch = "ZG222-concepts-concepts-unweighted-cosine"
join full_de_relatedness_survey as C on A.term_a = C.term_a and A.term_b = C.term_b and C.batch = "ZG222-concepts-concepts-unweighted-tanimoto"
where A.batch = "ZG222"
order by A.seq
limit 10
