-
Notifications
You must be signed in to change notification settings - Fork 2
Completed Tables
See issue #2, but all is well.
The BioGRID entry is entered from the SQL source. The other entries, well entry currently only FlyBase, is snagged from IMS2.tag and IMS2.tag_category tables where tag_category.category_name=='Source'.
Pulling user_id and interaction_quantition_addeddate from the IMS2.interaction_matrix table, it's kind of a guess but it better then nothing. Defaulting interaction_quantitation_status to active.
Populated with IMS2.interaction_quantitation_type, table name change to be consistent with plural names.
Populated this with distinct items from IMS2.interactions.interactor_[AB].id, which I assume are all proteins. This will need to be revisited as there is no quick.participant_type table yet.
All the PTM tables are imported!
Skipping both items produced in issue #5. Also setting all ptm_status to experimental as that is not stored in IMS.
As IMS2.ptm_sources has no status column defaulted all items to active.
Populated with items from IMS2.modifications table, set default status to active.
As the IMS2.ptm_relationships table has no user_id setting I set it to 1, the IMS_SERVICESCRIPT account.
Loading IMS2.ptms.ptm_status into this table.
Loading IMS2.ptms.ptm_notes into this table.
Rows in IMS2.projects that are open and being stated as public. There are no projects that are not open.
user_id=13 is present in the IMS2 table, but not in the IMS2 users table. Skipped.
See issues #3, and #4.
Import entries have been reported is issue #2.
Imported from the IMS2.pubmed_queries table. As the renamed table doesn't have PubMed IDs in it the few hundred items not in the publication table have to be inserted there.
As there is no data from IMS2 to go here so I created this table in the publications.sql file.
The same apart from column renaming.