Mac binaries

[jabaws.git] / website / archive / binaries / mac / src / fasta34 / mysql_demo1.sql

diff --git a/website/archive/binaries/mac/src/fasta34/mysql_demo1.sql b/website/archive/binaries/mac/src/fasta34/mysql_demo1.sql
new file mode 100644 (file)
index 0000000..92522d6
--- /dev/null
+++ b/website/archive/binaries/mac/src/fasta34/mysql_demo1.sql
@@ -0,0 +1,6 @@
+xdb.wrplab seqdb_demo wrplab gstmu;
+SELECT acc, protein.seq, sp_name
+ FROM annot INNER JOIN protein USING(prot_id) WHERE annot.db='sp' LIMIT 50000;
+SELECT acc, concat('sp|',acc,'|',sp_name,' ',descr) FROM annot WHERE acc='#' AND db='sp';
+SELECT acc,protein.seq FROM protein INNER JOIN annot USING(prot_id)
+ WHERE annot.acc='#' AND db='sp';