Can we tell when was the last time a feature was annotated?

[almasaeed2010]

Can we tell when was the last time a feature was annotated?

[almasaeed2010]

None of the tables (feature_cvterm, blast_hit_data, analysis) provide a way to find when the last record was created. Also, the importers don't have any indication which organisms they affected so we can't use those hooks either. We might have to just generate an entire site fasta file once every 6 months or something like that. Would that work?

[bradfordcondon]

the chado way to track this is to keep the date in the analysis.

[almasaeed2010]

Right but unfortunately the analysis itself won't change per annotation run. It also won't have information on which organisms to generate data for and which to ignore. It gets even more complicated when importers clear all annotations related to an analysis before reimporting.

[bradfordcondon]

Right but unfortunately the analysis itself won't change per annotation run.

why not? it should.

It also won't have information on which organisms to generate data for and which to ignore.

It will if you create new analyses...

[almasaeed2010]

We are using 1 site-wide analysis for this (1 ips analysis, 1 blast trembl, etc). We then run blast/ips on a fasta file that has all organisms merged into one. (like we did before for ips)