glygener / glygen-issues

Repository for public GlyGen tickets
GNU General Public License v3.0
0 stars 0 forks source link

Edit list_int csv files under generated/misc/ #1798

Closed rykahsay closed 2 days ago

rykahsay commented 3 weeks ago

The list_init API response depends CSV files "generated/misc/list_init_categories.csv" and "generated/misc/list_init_fields.csv" I have initiated that you will start maintain. Please update those files based on the spreadsheet Sujeeet shared and assign back the ticket to me when you are done

$ head generated/misc/list_init_fields.csv
record_type,field_id,field_label,field_order,is_default,is_immutable,category_id_list
protein,uniprot_canonical_ac,UniProtKB Accession,1,true,true,General
protein,mass,Chemical Mass (Da),2,true,false,General
protein,protein_name,UniProtKB Name,3,true,false,General
protein,gene_name,Gene Name,4,true,false,General
protein,organism,Organism,5,true,false,General
protein,refseq_name,RefSeq Name,6,true,false,General
protein,refseq_ac,RefSeq Accession,7,true,false,General
protein,tax_id,Taxonomy ID,8,false,false,General
protein,missing_score,missing_score,9,false,false,General

$ head generated/misc/list_init_categories.csv 
record_type,cat_id,cat_label,cat_order
protein,General,General,1
protein,Biomarkers,Biomarkers,1
protein,Diseases,Diseases,1
protein,Function,Function,1
protein,Glycation,Glycation,1
protein,Glycosylation,Glycosylation,1
protein,Interactions,Interactions,1
protein,Mutagenesis,Mutagenesis,1
protein,Mutagensis,Mutagensis,1
ubhuiyan commented 1 week ago

@rykahsay I have copied a backup file in: /generated/misc/backup_list_innit_2.7/

I have edited list_init_categories.csv and list_init_fields.csv as best as I could. There are some rows for the field_id I was unsure of. I tried looking through api.glygen.org to find the correct values but if you wouldn't mind filling in the ones I couldn't figure out. I'd appreciate it.

I also noticed some fields have similar rows but are different by category_id_list. For any that are similar, I tried to give them the same description. I think I got them all, but there's a chance I missed a few.

Lastly, I noticed some rows had multiple values in category_id_list, so I separated these with a pipe (|).

ubhuiyan commented 4 days ago

@rykahsay You can proceed.