File: psql_demo1.sql

package info (click to toggle)
fasta3 36.3.8i.14-Nov-2020-4
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,576 kB
  • sloc: ansic: 77,292; perl: 10,677; python: 2,461; sh: 428; csh: 86; sql: 55; makefile: 40
file content (6 lines) | stat: -rw-r--r-- 373 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
 
seqdb_host seqdb_demo seqdb_user password;
SELECT acc, protein.seq, 'sp|'||acc||'|'||sp_name||' '||descr
 FROM annot INNER JOIN protein USING(prot_id) WHERE annot.db='sp' LIMIT 50000;
SELECT acc, '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';