metadata: contig_metadata: 9 rows where bioproject = "PRJNA1146029", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJNA1146029", 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
290185	290185	PRJNA1146029_P_NODE_4121_length_422_cov_1.805158_g3843_i0	PRJNA1146029	4121	422	1.805158	7.61776676	Fungi	4751	Fungi	Fungi	167	2.43e-50	NR	RKP11106.1	78915	g3843	i0	68.2	6.51184834123223	129	35	91.7	2	418	32	10	132	RKP11106.1 60S ribosomal protein L32 [Thamnocephalis sphaerospora]	diamond	2748	167	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
14319138	14319138	PRJNA1146029_P_NODE_5872_length_362_cov_1.598616_g5594_i0	PRJNA1146029	5872	362	1.598616	5.78698992	Thamnocephalis sphaerospora	78915	Fungi	Fungi	91.7	1.82e-19	NR	RKP10674.1	78915	g5594	i0	48.9	0.729281767955801	88	41	72.9	1	4	267	159	242	RKP10674.1 small subunit ribosomal protein SAe, partial [Thamnocephalis sphaerospora]	diamond	264	91.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
21435592	21435592	PRJNA1146029_P_NODE_9937_length_290_cov_1.419355_g9656_i0	PRJNA1146029	9937	290	1.419355	4.1161295	Kickxellaceae	4862	Fungi	Fungi	150	1.3799999999999999e-43	NR	KAJ1931341.1	61395	g9656	i0	74.4	20.2862068965517	90	22	92.1	1	1	267	119	208	KAJ1931341.1 60S ribosomal protein L7, partial [Linderina pennispora]	diamond	5883	150	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
26595506	26595506	PRJNA1146029_P_NODE_4201_length_418_cov_2.231884_g3923_i0	PRJNA1146029	4201	418	2.231884	9.32927512	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	125	6.72e-34	NR	KXN73393.1	796925	g3923	i0	52	2.64832535885167	123	59	88.3	0	2	370	4	126	KXN73393.1 profilin-2 [Conidiobolus coronatus NRRL 28638]	diamond	1107	125	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
27691653	27691653	PRJNA1146029_P_NODE_16404_length_250_cov_2.451977_g16123_i0	PRJNA1146029	16404	250	2.451977	6.1299425	Fungi	4751	Fungi	Fungi	87.4	3.35e-20	NR	KAI0242418.1	348617	g16123	i0	59.2	6.468	76	31	91.2	0	246	19	19	94	KAI0242418.1 ribosomal protein L36 [Massospora cicadina]	diamond	1617	87.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina
30670817	30670817	PRJNA1146029_P_NODE_5053_length_385_cov_2.714744_g4775_i0	PRJNA1146029	5053	385	2.714744	10.4517644	Smittium culicis	133412	Fungi	Fungi	114	4.55e-30	NR	OMJ15099.1	133412	g4775	i0	59.5	2.46233766233766	79	32	61.6	0	4	240	29	107	OMJ15099.1 60S ribosomal protein L33-A [Smittium culicis]	diamond	948	114	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
30955465	30955465	PRJNA1146029_P_NODE_12574_length_274_cov_1.706468_g12293_i0	PRJNA1146029	12574	274	1.706468	4.67572232	Zancudomyces culisetae	1213189	Fungi	Fungi	120	4.86e-32	NR	OMH86072.1	1213189	g12293	i0	68.9	3.94160583941606	90	28	98.5	0	1	270	29	118	OMH86072.1 60S ribosomal protein L13 [Zancudomyces culisetae]	diamond	1080	120	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
31492854	31492854	PRJNA1146029_P_NODE_4076_length_424_cov_2.193732_g3798_i0	PRJNA1146029	4076	424	2.193732	9.30142368	Ramicandelaber brevisporus	304332	Fungi	Fungi	179	6.669999999999997e-55	NR	KAI8870081.1	304332	g3798	i0	61.3	0.969339622641509	137	53	96.9	0	11	421	2	138	KAI8870081.1 ribosomal protein S19e [Ramicandelaber brevisporus]	diamond	411	179	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
32157177	32157177	PRJNA1146029_P_NODE_9238_length_299_cov_2.637168_g8957_i0	PRJNA1146029	9238	299	2.637168	7.88513232	Entomophthora muscae	34485	Fungi	Fungi	43.5	0.0303	NR	KAJ9088843.1	34485	g8957	i0	34.3	0.702341137123746	70	29	58.2	3	18	191	6	70	KAJ9088843.1 hypothetical protein DSO57_1019120 [Entomophthora muscae]	diamond	210	43.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae

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);;