[Gusdev-gusdev] dots.rnatype view definition

[Deborah P. <pi...@pc...>]

Ed Robinson noticed another feature with a faulty definition so being in 
the mode I have modified the SQL and this will be used in our instance 
of GUS and in GUS 3.5:

SELECT na_feature_id,
na_sequence_id,
subclass_view,
name
sequence_ontology_id,
parent_id,
external_database_release_id,
source_id,
prediction_algorithm_id,
is_predicted,
review_status_id,
string1 as anticodon,
string2 as citation,
string3 as codon,
string4 as evidence,
string5 as function,
string6 as gene,
string7 as label,
string8 as map,
string9 as partial,
string10 as product,
string11 as pseudo,
string12 as standard_name,
string13 as usedin,
tinyint1 as is_partial,
tinyint2 as is_pseudo,
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 = 'RNAType' WITH CHECK OPTION