psql_demo_pv.sql

序列对齐 Compare a protein sequence to a protein sequence database or a DNA sequence to a DNA sequenc

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, 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';