psql_demo.sql

来自「序列对齐 Compare a protein sequence to a pr」· SQL 代码 · 共 8 行

@ seqdb_demo seqdb_demo @;
SELECT acc, protein.seq, sp_name
 FROM annot INNER JOIN protein USING(prot_id) WHERE annot.db='sp';
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';