Acrobeles complexus

nematodes.org - Bioinformatics

Nematode & Neglected Genomics
@ The Blaxter Lab, Institute of Evolutionary Biology, School of Biological Sciences, The University of Edinburgh

 University of Edinburgh crest   

jMOTU and Taxonerator SQL queries

Some SQL queries that may be useful for extracting summary data from a taxonerator/jMOTU database. We give some of these in the User Guides, and post others here to illustrate the possibilities.

purpose query
a list of sequences and the taxa they are assigned to SELECT distinct on (seq2motu.seq_name) seq2motu.seq_name, tax_table.motu , tax_table.phylum FROM tax_table,seq2motu WHERE tax_table.motu~'_4bp_MOTU' and tax_table.motu=seq2motu.motu_id GROUP BY tax_table.motu, tax_table.phylum, seq2motu.seq_name ORDER BY seq2motu.seq_name, tax_table.motu, tax_table.phylum ASC;
   
   

 

 

 

 

Website Highlight


Trichuris muris

The parasitic nematode Trichuris muris.
T. muris is a gut parasite of mice, and is used as a research model for the human-parasitic T. trichiura. See NEMBASE4 for analyses of ESTs from this parasite and many other nematodes.

[nematodes.org v4.0] the content of these pages is copyright Mark Blaxter and colleagues. Contact the webmaster if there are problems.