View "unison.bcl2_zebrafish_v"
  Column   |       Type       | Modifiers | Description
-----------+------------------+-----------+-------------
 known     | boolean          |           |
 pseq_id   | integer          |           |
 bh_name   | text             |           |
 bh_start  | integer          |           |
 bh_stop   | integer          |           |
 bh_mstart | smallint         |           |
 bh_mstop  | smallint         |           |
 bh_score  | smallint         |           |
 bh_eval   | double precision |           |
 tm_start  | integer          |           |
 tm_stop   | integer          |           |
 alias     | text             |           |
 descr     | text             |           |
View definition:
 SELECT DISTINCT ON (p.score, p.pseq_id, m.name) (EXISTS ( SELECT known_bcl2_overlaps_mv.q_pseq_id
           FROM known_bcl2_overlaps_mv
          WHERE known_bcl2_overlaps_mv.t_pseq_id = a.pseq_id OR known_bcl2_overlaps_mv.q_pseq_id = a.pseq_id AND known_bcl2_overlaps_mv.t_pseq_id IS NULL)) AS known, a.pseq_id, m.name AS bh_name, p."start" AS bh_start, p.stop AS bh_stop, p.mstart AS bh_mstart, p.mstop AS bh_mstop, p.score AS bh_score, p.eval AS bh_eval, t."start" AS tm_start, t.stop AS tm_stop, a.alias, a.descr
   FROM pahmm p
   JOIN pmhmm m ON p.pmodel_id = m.pmodel_id
   JOIN pmsm_pmhmm ms ON m.pmodel_id = ms.pmodel_id AND ms.pmodelset_id = pmodelset_id('Bcl-2 domains'::text)
   JOIN current_annotations_v a ON p.pseq_id = a.pseq_id AND a.tax_id = gs2tax_id('BRARE'::text)
   LEFT JOIN pftmhmm t ON t.pseq_id = a.pseq_id AND t."start" > p.stop
  WHERE p.params_id = params_id('Bcl-2 ls'::text)
  ORDER BY p.score DESC, p.pseq_id, m.name;