Re: [Gusdev-gusdev] dots.nalocation table

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

This question is a bit more complex than it seems.

All three of these may be necessary for every level of
analysis.  first, was the overall gene prediction/feature
prediction reviewed and how was it algorithmically arrived at?
 Then you can ask the same question about the locations. 
Early locations may be provided by the same algorithm as the
feature, but these may be further defined later and require
their own review annotations.

One thing that I think needs to be addressed, however, is how
these columns appear throughout the schema like mushrooms.  I
have been told that GUS was hyper-normalized when it was first
written to 4N or 5N form, but that is definitely not the case
now.  Why do you want review_status, reviewer and algorithm in
the feature table?  Since these usually will appear in
clusters (i.e. running an algorithm once gives you 500 cases
of the same entry for all three on the same date), shouldn't
we have a table to collect these into an annotation_status
table and just have an FK to an entry in that table for every
table that uses these?  The same goes for other SRes entries
such as taxon, project, etc.

-Ed



---- Original message ----
>Date: Sat, 12 Feb 2005 22:34:03 -0500 (EST)
>From: "Sucheta Tripathy" <su...@vb...>  
>Subject: [Gusdev-gusdev] dots.nalocation table  
>To: Gus...@li...
>
>
>Hi Group,
>
>From community annotation point of view, I was wondering if
it is a good
>idea to have is_reviewed, algorithm_id and reviewer_id in
dots.nalocation
>table.
>
>Since one na_feature_id( a transcript or a gene) may be
having multiple
>sets of nalocations, so one can easily capture them in
nalocation with
>different algorithms and with a reviewed option.
>
>In our application we need several gene calling programs to
have locations
>as well as related information registered.
>
>Sucheta
>
>
>-- 
>Sucheta Tripathy
>Virginia Bioinformatics Institute Phase-I
>Washington street.
>Virginia Tech.
>Blacksburg,VA 24061-0447
>phone:(540)231-8138
>Fax:  (540) 231-2606
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from
real users.
>Discover which products truly live up to the hype. Start
reading now.
>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
-----------------
Ed Robinson
Center for Tropical and Emerging Global Diseases
University of Georgia, Athens, GA 30602
ero...@ug.../(706)542.1447/254.8883