YoGa Tools

Help Page

If you want further informations on YoGa Tools you can read our report :
English Version - French Version

Here is the design of our database which would help you to create your own complex queries :

And finally some examples of complex queries :

SELECT count(go.goid),go.goid,go.godesc,go.goec
FROM `term`,go
WHERE term.goid=go.goid  AND term.term_type="molecular_function"
GROUP BY go.goid
ORDER BY count(go.goid) DESC;

This query will count the number of occurences of each GOAC within our database and display every information available

SELECT
COUNT(go.goid) AS effectif,go.goid,godesc,go.goec
FROM go,transcripts,term
WHERE go.trid=transcripts.trid AND go.goid=term.goid AND term.term_type="molecular_function" AND godesc!="molecular_function"
GROUP BY goid
HAVING COUNT(go.goid)>=10
ORDER BY COUNT(go.goid) DESC;

Same as above but with more constraints and the use of HAVING

SELECT transcripts.trid, transcripts.gnid, go.goid, go.godesc, term.term_type, go.goec, prosite.proid, pattern.prodesc
FROM transcripts,go,prosite,term,pattern
WHERE transcripts.trid="ENST00000001146" AND go.trid=transcripts.trid AND prosite.trid=transcripts.trid AND go.goid=term.goid;

This query will display TAC, GAC and every information available about ontology and domains for the transcript ENST00000001146.
However, readibility will be increased if two queries were made : one for ontologies and one for domains.

SELECT ONE.*
FROM go,
	(
	SELECT transcripts.trid
	FROM go,transcripts
	WHERE go.goid="GO:0009986" AND go.trid=transcripts.trid
	) AS ONE
WHERE goid="GO:0005887" AND go.trid=ONE.trid;

This query will display TAC sharing GO:0009986 and GO:0005887

SELECT TWO.*
FROM go,
	(
	SELECT ONE.*
	FROM go,
		(
		SELECT transcripts.trid
		FROM go,transcripts
		WHERE go.goid="GO:0009986" AND go.trid=transcripts.trid
		) AS ONE
	WHERE goid="GO:0005887" AND go.trid=ONE.trid
	) AS TWO
WHERE goid="GO:0007165" AND go.trid=TWO.trid

This query will display TAC sharing GO:0009986 and GO:0005887 and GO:0007165