the following content is metadata for a bacteria genome sequencing data in json format,…
- User
the following content is metadata for a bacteria genome sequencing data in json format, you need to extract information below from it and output in 2 rows tab-delimited format:
accession number species name strain name isolate or collection date in yyyy-mm-dd format geographic information of islateion host name mlsty type serotype xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx
1st row is column name, and xxxx is corresponding information in 2nd row.
Don't add any comments or explaining to output. If the appropriate information is not available, use "N/A" substitution; if the date has month or day, just print available information; if the host name is not available but this bacteria is a vaccine, then use "vaccine" as the host name' #'if geographic information of islateion not avaiable, you can try to guess from submitter
{'accession': 'GCA_947038755.1', 'assembly_info': {'assembly_level': 'Contig', 'assembly_method': 'SPAdes', 'assembly_name': '21S01212', 'assembly_status': 'current', 'assembly_type': 'haploid', 'bioproject_accession': 'PRJEB56391', 'bioproject_lineage': [{'bioprojects': [{'accession': 'PRJEB56391', 'title': 'Erysipelothrix rhusiopathiae in stranded harbor porpoises in the Netherlands'}]}], 'biosample': {'accession': 'SAMEA111417886', 'attributes': [{'name': 'ENA-CHECKLIST', 'value': 'ERC000011'}, {'name': 'ENA-FIRST-PUBLIC', 'value': '2023-01-10'}, {'name': 'ENA-LAST-UPDATE', 'value': '2023-01-10'}, {'name': 'External Id', 'value': 'SAMEA111417886'}, {'name': 'INSDC center alias', 'value': 'UTRECHT UNIVERSITY'}, {'name': 'INSDC center name', 'value': 'UTRECHT UNIVERSITY'}, {'name': 'INSDC first public', 'value': '2023-01-10T00:18:17Z'}, {'name': 'INSDC last update', 'value': '2023-01-10T00:18:17Z'}, {'name': 'INSDC status', 'value': 'public'}, {'name': 'Submitter Id', 'value': '21S01212'}, {'name': 'collection_date', 'value': '2021'}, {'name': 'geo_loc_name', 'value': 'Netherlands'}, {'name': 'isolation_source', 'value': 'porpoise'}, {'name': 'sample_name', 'value': '21S01212'}, {'name': 'scientific_name', 'value': 'Erysipelothrix rhusiopathiae'}], 'description': {'comment': 'Illumina Sequencing of 21S01212', 'organism': {'organism_name': 'Erysipelothrix rhusiopathiae', 'tax_id': 1648}, 'title': 'Illumina Sequencing of 21S01212'}, 'last_updated': '2023-04-12T14:42:53.000', 'models': ['Generic'], 'owner': {'name': 'EBI'}, 'package': 'Generic.1.0', 'publication_date': '2023-01-10T00:00:00.000', 'sample_ids': [{'db': 'SRA', 'value': 'ERS13511526'}], 'status': {'status': 'live', 'when': '2023-01-12T08:23:38.707'}, 'submission_date': '2023-01-11T08:08:22.073'}, 'paired_assembly': {'accession': 'GCF_947038755.1', 'annotation_name': 'GCF_947038755.1-RS_2024_05_02', 'status': 'current'}, 'release_date': '2023-01-12', 'sequencing_tech': 'ILLUMINA', 'submitter': 'UTRECHT UNIVERSITY'}, 'assembly_stats': {'contig_l50': 4, 'contig_n50': 128835, 'gc_count': '642223', 'gc_percent': 36, 'genome_coverage': '200.0x', 'number_of_component_sequences': 43, 'number_of_contigs': 43, 'total_sequence_length': '1771762', 'total_ungapped_length': '1771762'}, 'average_nucleotide_identity': {'best_ani_match': {'ani': 99.61, 'assembly': 'GCA_000160815.2', 'assembly_coverage': 95.15, 'category': 'type', 'organism_name': 'Erysipelothrix rhusiopathiae', 'type_assembly_coverage': 96.53}, 'category': 'category_na', 'comment': 'na', 'match_status': 'species_match', 'submitted_ani_match': {'ani': 99.61, 'assembly': 'GCA_000160815.2', 'assembly_coverage': 95.15, 'category': 'type', 'organism_name': 'Erysipelothrix rhusiopathiae ATCC 19414', 'type_assembly_coverage': 96.53}, 'submitted_organism': 'Erysipelothrix rhusiopathiae', 'submitted_species': 'Erysipelothrix rhusiopathiae', 'taxonomy_check_status': 'OK'}, 'checkm_info': {'checkm_marker_set': 'Erysipelothrix', 'checkm_marker_set_rank': 'genus', 'checkm_species_tax_id': 1648, 'checkm_version': 'v1.2.2', 'completeness': 93.76, 'completeness_percentile': 72.85068, 'contamination': 1.43}, 'current_accession': 'GCA_947038755.1', 'organism': {'infraspecific_names': {'isolate': '21S01212'}, 'organism_name': 'Erysipelothrix rhusiopathiae', 'tax_id': 1648}, 'paired_accession': 'GCF_947038755.1', 'source_database': 'SOURCE_DATABASE_GENBANK', 'wgs_info': {'master_wgs_url': 'https://www.ncbi.nlm.nih.gov/nuccore/CAMQWY000000000.1', 'wgs_contigs_url': 'https://www.ncbi.nlm.nih.gov/Traces/wgs/CAMQWY01', 'wgs_project_accession': 'CAMQWY01'}}
- Assistant
accession number species name strain name isolate or collection date in yyyy-mm-dd format geographic information of islateion host name mlsty type serotype GCA_947038755.1 Erysipelothrix rhusiopathiae 21S01212 2021 Netherlands porpoise N/A N/A