metadata: contig_metadata: 4 rows where bioproject = "PRJNA854078", tax_kingdom = "Fungi" and tax

4 rows where bioproject = "PRJNA854078", tax_kingdom = "Fungi" and tax_phylum = "Zoopagomycota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
9769675	9769675	PRJNA854078_P_NODE_1088_length_918_cov_2.822485_g920_i0	PRJNA854078	1088	918	2.822485	25.9104123	Fungi	4751	Fungi	Fungi	156	1.23e-42	NR	OMJ27699.1	133412	g920	i0	48.5	4.21241830065359	167	79	52.3	2	917	438	58	224	OMJ27699.1 Ras-related protein Rab-5C [Smittium culicis]	diamond	3867	156	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
26738066	26738066	PRJNA854078_P_NODE_10481_length_291_cov_0.912844_g10269_i0	PRJNA854078	10481	291	0.912844	2.65637604	Massospora cicadina	348617	Fungi	Fungi	72.4	1.24e-12	NR	KAI0234037.1	348617	g10269	i0	40.5	0.814432989690722	79	47	81.4	0	31	267	119	197	KAI0234037.1 Ceramide synthase 5, partial [Massospora cicadina]	diamond	237	72.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina
27402812	27402812	PRJNA854078_P_NODE_7683_length_339_cov_1.657895_g7471_i0	PRJNA854078	7683	339	1.657895	5.62026405	Entomophthora muscae	34485	Fungi	Fungi	148	3.2399999999999992e-40	NR	KAJ9071923.1	34485	g7471	i0	63.9	5.85840707964602	108	37	95.6	1	325	2	36	141	KAJ9071923.1 hypothetical protein DSO57_1032484 [Entomophthora muscae]	diamond	1986	148	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
29802246	29802246	PRJNA854078_P_NODE_11731_length_275_cov_1.500000_g11519_i0	PRJNA854078	11731	275	1.5	4.125	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	64.7	1.04e-9	NR	KAI9293383.1	1314799	g11519	i0	35.1	1.21090909090909	111	51	99.3	3	2	274	809	918	KAI9293383.1 hypothetical protein K502DRAFT_293809 [Neoconidiobolus thromboides FSU 785]	diamond	333	64.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;