File: mysql_demo1.sql

package info (click to toggle)
fasta3 36.3.8i.14-Nov-2020-3
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 7,016 kB
  • sloc: ansic: 77,269; perl: 10,677; python: 2,461; sh: 428; csh: 86; sql: 55; makefile: 40
file content (6 lines) | stat: -rw-r--r-- 347 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
 
seqdb_host seqdb_demo seqdb_user password;
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';