erikrikarddaniel / pfitmap

1 stars 0 forks source link

Add accession numbers to protein_count #87

Closed erikrikarddaniel closed 10 years ago

erikrikarddaniel commented 10 years ago

Add new fields to protein_count: selected_accessions and all_accessions. Both arrays of accession numbers in AR's array format.

The difference between the two is that all_accesions contains all accession numbers, including duplicates attached to the same db_sequence object (see issue #101) while selected_accessions contain only those used to calculate the number of entries.

erikrikarddaniel commented 10 years ago

Fixed in 69ef265 by adding two string fields containing comma separated lists of accession numbers. Not ideal but should work in group by selects using the string_agg PostgreSQL function.