[Go] growth in manual GO annotation

[Chris Mungall]

On Apr 8, 2008, at 9:48 AM, Doug howe wrote:

> Does anyone have, or know how to get, historical stats on the  
> number of
> GO annotations that have been contributed to the GOC over time?  I'm
> looking for the number of non-IEA, non-ND GO annotations that existed
> for each year from 2002-2008.
>
> Midori provided me with the following numbers of GO terms for that
> period if anyone is interested:
> date            total       obsolete
> 1/1/2002    10305    152
> 1/1/2003    13339    383
> 1/1/2004    16771    725
> 1/1/2005    18219    969
> 1/1/2006    20348    992
> 1/1/2007    22928    1011
> 1/1/2008    25758    1137

We have historical go dbs mirrored here - we can open these to GOOSE  
if you like, or you can just request queries.

This is what you're after:

SELECT count(*) AS num_annots
FROM association INNER JOIN evidence ON  
(evidence.association_id=association.id)
WHERE code != 'IEA' AND code != 'ND';
go_old_20030101
num_annots
133699

go_old_20040101
num_annots
386339

go_old_20050101
num_annots
416224

go_old_20060101
num_annots
469107

go_old_20070101
num_annots
489402

go_old_20080101
num_annots
580052


This one may also be informative: the number of terms used directly  
in annotations (all):

SELECT count(DISTINCT term_id) AS num_terms_used_directly
FROM association;
go_old_20030101
num_terms_used_directly
7116

go_old_20040101
num_terms_used_directly
9008

go_old_20050101
num_terms_used_directly
10134

go_old_20060101
num_terms_used_directly
11113

go_old_20070101
num_terms_used_directly
12340

go_old_20080101
num_terms_used_directly
13812



> -Doug
>
> _______________________________________________
> Go mailing list
> Go at geneontology.org
> http://fafner.stanford.edu/mailman/listinfo/go
>