File: exon-views.sql

package info (click to toggle)
libchado-perl 1.31-7
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 44,728 kB
  • sloc: sql: 282,721; xml: 192,553; perl: 25,524; sh: 102; python: 73; makefile: 57
file content (13 lines) | stat: -rw-r--r-- 379 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- requires: so-views

CREATE OR REPLACE VIEW unshared_exon AS
 SELECT
 FROM
  exon AS exon1 INNER JOIN featureloc AS fl1 USING (feature_id),
  exon AS exon2 INNER JOIN featureloc AS fl2 USING (feature_id)
 WHERE
  exon1.feature_id != exon2.feature_id AND
  fl1.srcfeature_id = fl2.srcfeature_id AND
  fl1.fmin = fl2.fmin AND
  fl1.fmax = fl2.fmax AND
  fl1.strand = fl2.strand;