[Gusdev-gusdev] CpgIslandNAFeature view

[Jonathan S. <js...@pc...>]

I'd like to propose the following for a CpG island view on 
NAFeatureImp.  Comments?

Jonathan Schug


SELECT    na_feature_id,
           na_sequence_id,

	      /* 'CpgIslandNAFeature' */
           subclass_view,

           /* should be internal ID of SO:0000307 */
           sequence_ontology_id,
           name,
           parent_id,
           source_id,
           external_database_release_id,
           prediction_algorithm_id,
           is_predicted,
           review_status_id,

/* number of c or g bases */
int1   as cg_count,

/* redundant: fraction of length that is c or g base */
float1 as cg_fraction,

/* number of cg dinucleotides */
int2   as cpg_count,

/* redundant: fraction of (length - 1) dinucleotides that are cg */
float2 as cpg_fraction,

/* ratio of observed cg dinucs to expected cg dinucs */
float3 as cpg_observed_to_expected_ratio,

/* prediction invocation to get params that is safe from updates. */
int3   as algorithm_invocation_id

/* GUS overhead */
           modification_date,
           user_read,
           user_write,
           group_read,
           group_write,
           other_read,
           other_write,
           row_user_id,
           row_group_id,
           row_project_id,
           row_alg_invocation_id,

FROM NAFeatureImp WHERE subclass_view = 'CpgIslandNAFeature' WITH CHECK 
OPTION