Direct querying has been disabled due to misuse. If you need help with a complex query of domain architectures, please contact us.

Direct SQL query

Please don't use this form if you're not familiar with SQL.

Check below for tables structure and examples...
The query must return ONLY dom_prot.protein or protein.name. End your query with ;

Access key:

+------------+       +------------+       +------------+
|  dom_prot  |       |  protein   |       |  taxonomy  |
+============+       +============+       +============+
|  protein   | ====> |   name     |       |   family   |
|  domain    |       |  organism  | ====> |  species   |
|  start     |       +------------+       |  kingdom   |
|  ende      |                            |superkingdom|
+------------+                            |   phylum   |
                                          +------------+


Examples:

SELECT distinct(protein) FROM dom_prot WHERE domain = 'SH3' OR domain = 'SH2' 
AND protein NOT IN (SELECT protein FROM dom_prot WHERE domain = 'TyrKc'); 


SELECT distinct(dom_prot.protein) FROM dom_prot, protein, taxonomy WHERE dom_prot.domain = 'SH2'
AND dom_prot.protein=protein.name AND protein.organism=taxonomy.species AND 
taxonomy.kingdom = 'Metazoa';