[Gusdev-gusdev] Proposed Transmembrane Feature

[Ed R. <ero...@ug...>]

We need a definition for the new (3.5) Transmembrane Feature
View _immediately_ for the cryptodb project.  All we need are
5 aliased fields in a standard dots.AAFeatureImp subclassed
view.  I want to propose the following, which meets our needs.
 If anyone wants to add any more aliased views to this, please
feel free to do so.  If there are any problems with this,
please post those also.

-Ed


  create view dots.TransMembraneAAFeature as
	select	aa_feature_id,
		aa_sequence_id,
		feature_name_id,
		parent_id,
		na_feature_id,
		subclass_view,
		sequence_ontology_id,
		description,
		pfam_entry_id,
		motif_aa_sequence_id,
		repeat_type_id,
		external_database_release_id,
		source_id,
		prediction_algorithm_id,
		is_predicted,
		review_status_id,
		int1 as length,
		string1 as expected_aa,
		string2 as first_60,
		int2 as predicted_helices,
                int3 as topology
	from DoTS.AaFeatureImp
-----------------
Ed Robinson
Center for Tropical and Emerging Global Diseases
University of Georgia, Athens, GA 30602
ero...@ug.../(706)542.1447/254.8883