Filtered download for protein glycosylation table (backend)

[ReneRanzinger]

Adjust the download option for the glycosylation table to optional support a list of filters (#1712) to allow users to download the filtered table rather then the complete table.

Dependencies

• 1713

• 1712

• 1817

Blocker for

• 1721

[sujeetvkulkarni]

https://api.tst.glygen.org/data/section_download?query=
{"id":"P14210-1","download_type":"protein_section","section":"glycosylation_reported_with_glycans","format":"csv","compressed":false,
"filters":[{"id":"by_organism","operator":"OR","selected":["Mouse"]}]
}

section_download api needs to support all the respective formats and compressed and not compressed types.

[rykahsay]

Done

API call

$ http POST :8082/data/section_download < tests/examples/data/section_download.protein.glycosylation.json 
HTTP/1.1 200 OK
Connection: close
Content-Length: 1624
Content-Type: text/csv; charset=utf-8
Date: Wed, 23 Oct 2024 18:41:00 GMT
Server: gunicorn

"GlyTouCan Accession","Type","Start Position","End Position","Start Amino Acid","End Amino Acid","Comment","Source Xref DB","Source Xref ID","Source Xref URL","Glycan Image Url"
"G45637XA","O-linked","476","476","Thr","Thr","GlycoSuiteDB  curation notes. Reported structure can be attached to the following: N-294, N-402, T-476, N-566, N-653","PubMed","8407880","https://glygen.org/publication/PubMed/8407880","https://api.glygen.org/glycan/image/G45637XA"

payload examples

$ cat tests/examples/data/section_download.protein.glycosylation.json
{
    "id": "3843b55e7e9d3a631bfca8466c9b9f87",
    "download_type": "protein_section",
    "section": "glycosylation_reported_with_glycans",
    "format": "csv",
    "compressed": false
}

$ cat tests/examples/data/section_download.biomarker.biomarker_component.json
{
   "id":"229ab64b48dcd26065c43df86f7a2a35",
   "download_type":"biomarker_section",
   "section":"biomarker_component",
   "format":"csv",
   "compressed":false
}

$ cat tests/examples/data/section_download.glycan.glycoprotein.json
{
    "id": "b746c1204c426c5d1f97aa781ad1be44",
    "download_type": "glycan_section",
    "section": "glycoprotein",
    "format": "csv",
    "compressed": false
}

$ cat tests/examples/data/section_download.motif.glycans.json
{
    "id": "d562c5c6ff221d0e96e9b660f8b515ac",
    "download_type": "motif_section",
    "section": "glycans",
    "format": "csv",
    "compressed": false
}

$ cat tests/examples/data/section_download.publication.glycosylation.json
{
    "id": "2ea775ce73ccda14366a6af3fab83be6",
    "download_type": "publication_section",
    "section": "glycosylation_reported_with_glycans",
    "format": "csv",
    "compressed": false
}

$ cat tests/examples/data/section_download.site.glycosylation.json
{
    "id": "0ec25147224f19f6115f9ca2e050d5a7",
    "download_type": "site_section",
    "section": "glycosylation",
    "format": "csv",
    "compressed": false
}