[Gmod-schema-cmts] schema/chado/modules/sequence/gff-bridge sequence-gff-views.sql, 1.12, 1.13

[Scott C. <sco...@us...>]

Update of /cvsroot/gmod/schema/chado/modules/sequence/gff-bridge
In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv17962

Modified Files:
	sequence-gff-views.sql 
Log Message:
fixing gff3view so that items without a dbxref for GFF_source will still
get selected


Index: sequence-gff-views.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/sequence/gff-bridge/sequence-gff-views.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** sequence-gff-views.sql	23 Sep 2005 15:42:24 -0000	1.12
--- sequence-gff-views.sql	1 Jun 2006 17:23:22 -0000	1.13
***************
*** 92,128 ****
  
  CREATE OR REPLACE VIEW gff3view (
!   feature_id,
!   ref,
!   source,
!   type,
!   fstart,
!   fend,
!   score,
!   strand,
!   phase,
!   seqlen,
!   name,
!   organism_id
  ) AS
  SELECT
!   f.feature_id   ,
!   sf.name        ,
!   dbx.accession  ,
!   cv.name        ,
!   fl.fmin+1      ,
!   fl.fmax        ,
!   af.significance,
!   fl.strand      ,
!   fl.phase       ,
!   f.seqlen       ,
!   f.name         ,
!   f.organism_id
  FROM feature f
       LEFT JOIN featureloc fl     ON (f.feature_id     = fl.feature_id)
       LEFT JOIN feature sf        ON (fl.srcfeature_id = sf.feature_id)
       LEFT JOIN feature_dbxref fd ON (f.feature_id     = fd.feature_id)
!      LEFT JOIN dbxref dbx        ON (dbx.dbxref_id    = fd.dbxref_id)
       LEFT JOIN cvterm cv         ON (f.type_id        = cv.cvterm_id)
!      LEFT JOIN analysisfeature af ON (f.feature_id    = af.feature_id)
! WHERE dbx.db_id IN (select db_id from db where db.name = 'GFF_source');
  
--- 92,109 ----
  
  CREATE OR REPLACE VIEW gff3view (
!   feature_id, ref, source, type, fstart, fend,
!   score, strand, phase, seqlen, name, organism_id
  ) AS
  SELECT
!   f.feature_id, sf.name, dbx.accession, cv.name,
!   fl.fmin+1, fl.fmax, af.significance, fl.strand,
!   fl.phase, f.seqlen, f.name, f.organism_id
  FROM feature f
       LEFT JOIN featureloc fl     ON (f.feature_id     = fl.feature_id)
       LEFT JOIN feature sf        ON (fl.srcfeature_id = sf.feature_id)
       LEFT JOIN feature_dbxref fd ON (f.feature_id     = fd.feature_id)
!      LEFT JOIN dbxref dbx        ON (dbx.dbxref_id    = fd.dbxref_id 
!          AND dbx.db_id IN (select db_id from db where db.name = 'GFF_source'))
       LEFT JOIN cvterm cv         ON (f.type_id        = cv.cvterm_id)
!      LEFT JOIN analysisfeature af ON (f.feature_id    = af.feature_id);