Feature #8725
adapt to database schema rev 2: additional links and info from ncbi, add columns for convenience when querying the database (avoid cross tables querying)
Start date:
08/25/2017
Due date:
% Done:
100%
Estimated time:
History
#1
Updated by Thomas Lacroix over 6 years ago
Updated by - Subject changed from Pipeline rev 471 ; adapt to database schema rev 2 : modify pipeline to deal with additional info in table elements: NCBI_internal_id, NCBI_sourcedb, NCBI_tech, NCBI_geneticcode, NCBI_topology, NCBI_completeness, NCBI_status, NCBI_comment ; also warn if ge to adapt to database schema rev 2: additional links and info from ncbi, add columns for convenience when querying the database (avoid cross tables querying)
-> additional info in table organisms: NCBI_assemblyaccession_IT, NCBI_assemblyname_IT, NCBI_lastupdatedate_IT, NCBI_seqreleasedate_IT, NCBI_isolate_IT, NCBI_speciestaxid_IT, NCBI_biosampleid_IT, NCBI_biosampleaccn_IT, NCBI_list_bioprojectid_IT, NCBI_list_bioprojectaccn_IT, NCBI_assemblyclass_IT, NCBI_assemblystatus_IT
-> additional info in table elements: NCBI_internal_id, NCBI_sourcedb, NCBI_tech, NCBI_geneticcode, NCBI_topology, NCBI_completeness, NCBI_status, NCBI_comment ; also warn if genome status = supppressed