import pandas as pd
from jsonapi_client import Session, Modifier
= 'super-studies/atlanteco/flagship-studies'
atlanteco_endpoint with Session("https://www.ebi.ac.uk/metagenomics/api/v1") as mgnify:
= map(lambda r: r.json, mgnify.iterate(atlanteco_endpoint))
studies = pd.json_normalize(studies)
studies 5] studies[:
type | id | attributes.samples-count | attributes.accession | attributes.bioproject | attributes.is-private | attributes.secondary-accession | attributes.centre-name | attributes.study-abstract | attributes.study-name | attributes.data-origination | attributes.last-update | relationships.biomes.data | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | studies | MGYS00006075 | 159 | MGYS00006075 | PRJEB50073 | False | ERP134625 | EMG | The Third Party Annotation (TPA) assembly was ... | EMG produced TPA metagenomics assembly of PRJE... | SUBMITTED | 2023-09-27T18:43:33 | [{'id': 'root:Environmental:Aquatic:Marine', '... |
1 | studies | MGYS00005780 | 480 | MGYS00005780 | PRJEB45427 | False | ERP129541 | EMG | The Third Party Annotation (TPA) assembly was ... | EMG produced TPA metagenomics assembly of PRJN... | SUBMITTED | 2023-09-27T15:08:51 | [{'id': 'root:Environmental:Aquatic:Marine', '... |
2 | studies | MGYS00006074 | 75 | MGYS00006074 | PRJEB51168 | False | ERP135767 | EMG | The Third Party Annotation (TPA) assembly was ... | EMG produced TPA metagenomics assembly of PRJE... | SUBMITTED | 2022-10-21T19:56:09 | [{'id': 'root:Environmental:Aquatic:Marine', '... |
3 | studies | MGYS00006072 | 130 | MGYS00006072 | PRJEB54918 | False | ERP139784 | EMG | The Third Party Annotation (TPA) assembly was ... | EMG produced TPA metagenomics assembly of PRJN... | SUBMITTED | 2022-10-13T14:03:52 | [{'id': 'root:Environmental:Aquatic:Marine:Oce... |
4 | studies | MGYS00006034 | 971 | MGYS00006034 | PRJEB50181 | False | ERP134737 | EMG | The Third Party Annotation (TPA) assembly was ... | EMG produced TPA metagenomics assembly of PRJN... | SUBMITTED | 2022-10-10T12:22:12 | [{'id': 'root:Environmental:Aquatic:Marine', '... |