rkh@csb-dev=> select * from bcl2_zebrafish_v pf WHERE ((pf.bh_name =
'BH1_TP_FN'::text AND pf.bh_score > 21) OR (pf.bh_name = 'BH2_TP_FN'::text
AND pf.bh_score > 13) OR (pf.bh_name = 'BH3_TP_FN'::text AND pf.bh_score >
12) OR (pf.bh_name = 'BH4_1_TP_FN'::text AND pf.bh_score > 22) OR
(pf.bh_name = 'BH4_2_TP_FN'::text AND pf.bh_score > 20) OR (pf.bh_name =
'Bcl-2_TP'::text AND pf.bh_score > 21)) AND known='f';

 known | pseq_id |  bh_name  | bh_start | bh_stop | bh_mstart | bh_mstop | bh_score | bh_eval | tm_start | tm_stop |       alias        |                                                  descr
-------+---------+-----------+----------+---------+-----------+----------+----------+---------+----------+---------+--------------------+---------------------------------------------------------------------------------------------------------
 f     | 6509587 | Bcl-2_TP  |       69 |     167 |         1 |      108 |       51 | 1.9e-12 |      176 |     195 | FGENESH00000051094 | pep:Fgenesh scaffold:ZFISH5:Zv5_scaffold1280:1610045:1616567:-1 transcript:FGENESH00000051094
 f     | 6440639 | Bcl-2_TP  |       62 |     159 |         1 |      108 |       36 | 1.2e-07 |          |         | FGENESH00000070960 | pep:Fgenesh chromosome:ZFISH5:3:28501980:28508253:1 transcript:FGENESH00000070960
 f     | 6440609 | Bcl-2_TP  |       62 |     159 |         1 |      108 |       35 | 1.3e-07 |          |         | FGENESH00000070893 | pep:Fgenesh chromosome:ZFISH5:3:27991859:28001379:1 transcript:FGENESH00000070893
 f     | 5864413 | Bcl-2_TP  |       62 |     159 |         1 |      108 |       33 | 7.5e-07 |      180 |     202 | ENSDARP00000040899 | pep:known chromosome:ZFISH5:3:27991859:27999570:1 gene:ENSDARG00000030881 transcript:ENSDART00000040900
 f     | 5549576 | BH3_TP_FN |      124 |     138 |         1 |       15 |       23 | 0.00053 |          |         | XP_685676          | PREDICTED: similar to developmentally regulated RNA-binding protein 1 [Danio rerio].
 f     | 6462088 | BH3_TP_FN |      124 |     138 |         1 |       15 |       23 | 0.00053 |          |         | FGENESH00000065416 | pep:Fgenesh chromosome:ZFISH5:13:45819368:45878668:-1 transcript:FGENESH00000065416
 f     | 6462089 | BH3_TP_FN |       65 |      79 |         1 |       15 |       23 | 0.00053 |          |         | GENSCAN00000027123 | pep:Genscan chromosome:ZFISH5:13:45836703:45876863:-1 transcript:GENSCAN00000027123
 f     | 5006800 | BH3_TP_FN |       37 |      51 |         1 |       15 |       18 |   0.023 |      130 |     149 | Q5RGV6_BRARE       | Novel protein
 f     | 5006801 | BH3_TP_FN |       37 |      51 |         1 |       15 |       18 |   0.023 |      129 |     148 | Q5RGV7_BRARE       | Novel protein
 f     | 6446065 | BH3_TP_FN |      144 |     158 |         1 |       15 |       18 |   0.023 |          |         | GENSCAN00000013257 | pep:Genscan chromosome:ZFISH5:4:20095936:20101579:1 transcript:GENSCAN00000013257
 f     | 6478868 | BH3_TP_FN |      157 |     171 |         1 |       15 |       18 |    0.02 |          |         | GENSCAN00000040401 | pep:Genscan chromosome:ZFISH5:20:53732101:53738455:-1 transcript:GENSCAN00000040401
 f     | 6478869 | BH3_TP_FN |      157 |     171 |         1 |       15 |       18 |    0.02 |          |         | FGENESH00000082230 | pep:Fgenesh chromosome:ZFISH5:20:53735349:53738455:-1 transcript:FGENESH00000082230
 f     | 5545008 | BH2_TP_FN |      121 |     132 |         1 |       12 |       16 |    0.12 |          |         | XP_685054          | PREDICTED: similar to BCL2-like 12 isoform 1 [Danio rerio].
 f     | 6440560 | BH2_TP_FN |      618 |     629 |         1 |       12 |       16 |    0.12 |          |         | GENSCAN00000000751 | pep:Genscan chromosome:ZFISH5:3:27327661:27353016:-1 transcript:GENSCAN00000000751
 f     | 6440561 | BH2_TP_FN |      606 |     617 |         1 |       12 |       16 |    0.12 |          |         | FGENESH00000062403 | pep:Fgenesh chromosome:ZFISH5:3:27327661:27353016:-1 transcript:FGENESH00000062403
 f     | 6440567 | BH2_TP_FN |      595 |     606 |         1 |       12 |       16 |    0.12 |          |         | GENSCAN00000000732 | pep:Genscan chromosome:ZFISH5:3:27438790:27464191:-1 transcript:GENSCAN00000000732
 f     | 5558259 | BH2_TP_FN |      785 |     796 |         1 |       12 |       14 |    0.42 |          |         | XP_683018          | PREDICTED: similar to BCL2-like 14 isoform 1 [Danio rerio].
 f     | 6456316 | BH2_TP_FN |      178 |     189 |         1 |       12 |       14 |    0.42 |          |         | FGENESH00000051980 | pep:Fgenesh chromosome:ZFISH5:18:15208769:15211880:-1 transcript:FGENESH00000051980
 f     | 6456437 | BH2_TP_FN |      172 |     183 |         1 |       12 |       14 |    0.42 |          |         | FGENESH00000059179 | pep:Fgenesh chromosome:ZFISH5:18:18159983:18163571:1 transcript:FGENESH00000059179
 f     | 6472057 | BH3_TP_FN |      119 |     133 |         1 |       15 |       13 |    0.74 |          |         | FGENESH00000060418 | pep:Fgenesh chromosome:ZFISH5:7:16901308:16902886:-1 transcript:FGENESH00000060418
 f     | 6485651 | BH3_TP_FN |      269 |     283 |         1 |       15 |       13 |    0.77 |          |         | GENSCAN00000042024 | pep:Genscan chromosome:ZFISH5:16:16466424:16495109:-1 transcript:GENSCAN00000042024
 f     | 6485652 | BH3_TP_FN |      215 |     229 |         1 |       15 |       13 |    0.77 |          |         | FGENESH00000078270 | pep:Fgenesh chromosome:ZFISH5:16:16466424:16495109:-1 transcript:FGENESH00000078270
(22 rows)

Time: 3150.415 ms