[Go] growth in manual GO annotation

[Doug howe]

Thanks Chris those are very useful numbers.  If you don't mind running 
two more queries, it won't be necessary to open the older stuff to Goose.
I'd be interested to see:
1.  The number of distinct gene products (across all species) annotated 
on 1/1 of each year from 2002-2008.
2.  The number of distinct species with any GO annotation on 1/1 of each 
year from 2002-2008.

-Thanks!
-Doug


Chris Mungall wrote:
>
> 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
>>
>