sajo-ebi

@ljwh2 the curation app has been deployed in Prod with Email sending for status change code block commented

Analysis has been done but not yet determined why duplication of snp Id happens but changed code to make Data structure not accept duplicate snp , running Purge job to...

@Santhi1901 @ljwh2 based on my investigation the Submission page is not loading due to huge Payload of the AZ submission , the API being called by Curation for loading submission...

The changes have been deployed in Prod as part of Scaling issue fix for Depo Sync , we will optimize further for AZ submission , identified few improvement areas

- Get Location & Region mapping for the Variant . - Get overlapping genes for each location of chromosome. - If no overlapping genes are found then based on chromosome...

@ljwh2 the overlapping genes are the ones which give match for the chromosome position , the Ensembl Id & gene information is retrieved in 2nd step itself , then the...

CHR_ID CHR_POS REPORTED GENE(S) MAPPED_GENE UPSTREAM_GENE_ID DOWNSTREAM_GENE_ID SNP_GENE_IDS UPSTREAM_GENE_DISTANCE DOWNSTREAM_GENE_DISTANCE STRONGEST SNP-RISK ALLELE SNPS 22 41065861 ST13 Y_RNA - ACTBP15 ENSG00000201749 ENSG00000213857 215 8319 rs5758209-T rs5758209 @ljwh2 the above is...

@Santhi1901 can you confirm where are you checking this because in Depo Curation DB I see no traits are mapped to GCST "GCST90091795"

@earlEBI here is the export of Publications in Sandbox https://docs.google.com/spreadsheets/d/1sKZRym7CGbark4ELAlA5hB3ctc9e0jbn06qy5fHFaZc/edit#gid=0

@earlEBI please find attached sheet Pmid with submission Complete status [https://docs.google.com/spreadsheets/d/1rul6CVlSOk72DSTe6MZBdNcCPTxDG__oW8QhJ_y3IAA/edit#gid=0](https://docs.google.com/spreadsheets/d/1rul6CVlSOk72DSTe6MZBdNcCPTxDG__oW8QhJ_y3IAA/edit#gid=0)