16S rRNA Refseq V15.21 Genomic RefSeq V9.12

Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
lyang
Post subject: BLAST files  PostPosted: Mar 08, 2012 - 03:33 PM



Joined: Jun 06, 2011
Posts: 10

For HOMD:

SELECT t.seq_id, t.db_uid, t.db_uid_inNCBI
FROM seq_genomes AS s,HOMD_tool_list AS t, HOMD_seqid_taxonid_index AS i
WHERE
t.active = 1
AND t.seq_id = i.seq_id
AND t.tool_type = 'homd'
AND t.seq_id = s.seq_id
AND s.status !='In Progress'
GROUP BY s.seq_id


For NCBI:

SELECT t.seq_id, t.db_uid, t.db_uid_inNCBI
FROM seq_genomes AS s,HOMD_tool_list AS t, HOMD_seqid_taxonid_index AS i
WHERE
t.seq_id = i.seq_id
AND t.tool_type = 'ncbi'
AND t.seq_id = s.seq_id
AND s.flag < 31
AND s.status !='In Progress'
GROUP BY s.seq_id
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
Powered by PNphpBB2 © 2003-2006 The PNphpBB Group
Credits
Copyright 2007-2020 The Forsyth Institute
Hosted on Amazon AWS EC2