metadata: contig_metadata: 11 rows where bioproject = "PRJEB28062", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJEB28062", tax_clade = "Opisthokonta" 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
2575383	2575383	PRJEB28062_P_NODE_78603_length_381_cov_21.535714_g76241_i0	PRJEB28062	78603	381	21.535714	82.05107034	Capillidium heterosporum	1167838	Fungi	Fungi	370	8.83e-98	NTclustered	gi\|1583106424\|ref\|NC_040967.1\|	1167838	g76241	i0	86.607	4.04724409448819	336	44	88	1	22	356	10760	10425	Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome	blastn	1542	370	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Capillidium	Capillidium heterosporum
5126189	5126189	PRJEB28062_P_NODE_117525_length_266_cov_14.435233_g115162_i0	PRJEB28062	117525	266	14.435233	38.39771978	Smittium simulii	133385	Fungi	Fungi	60.8	1.65e-8	NR	PVU98264.1	133385	g115162	i0	64.6	0.541353383458647	48	17	54.1	0	26	169	229	276	PVU98264.1 hypothetical protein BB561_000038 [Smittium simulii]	diamond	144	60.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium simulii
6402737	6402737	PRJEB28062_P_NODE_33686_length_632_cov_150.640429_g31374_i0	PRJEB28062	33686	632	150.640429	952.04751128	Entomophthora muscae	34485	Fungi	Fungi	375	3.2799999999999995e-99	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g31374	i0	84.675	39.9762658227848	385	49	79	10	223	603	2061	1683	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	25265	375	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
8952125	8952125	PRJEB28062_P_NODE_59028_length_456_cov_27.114883_g56669_i0	PRJEB28062	59028	456	27.114883	123.64386648	Entomophaga aulicae	39303	Fungi	Fungi	335	3.9199999999999984e-87	NTclustered	gi\|1373048\|gb\|U35394.1\|EAU35394	39303	g56669	i0	82.707	51.015350877193	399	48	85	16	59	446	4745	5133	Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes	blastn	23263	335	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophaga	Entomophaga aulicae
21702592	21702592	PRJEB28062_P_NODE_96898_length_324_cov_4.099602_g94536_i0	PRJEB28062	96898	324	4.099602	13.28271048	Entomophthora muscae	34485	Fungi	Fungi	459	1.5299999999999999e-124	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g94536	i0	95.189	55.8858024691358	291	13	90	1	11	301	2281	1992	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	18107	459	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
26646609	26646609	PRJEB28062_P_NODE_126801_length_247_cov_0.885057_g124437_i0	PRJEB28062	126801	247	0.885057	2.18609079	Harpellales	61421	Fungi	Fungi	105	3.45e-27	NR	PVU85474.1	61424	g124437	i0	76.6	2.33198380566802	64	15	77.7	0	246	55	44	107	PVU85474.1 hypothetical protein BB559_007000 [Furculomyces boomerangus]	diamond	576	106	0.990566037735849	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
28233120	28233120	PRJEB28062_P_NODE_115166_length_272_cov_8.000000_g112803_i0	PRJEB28062	115166	272	8	21.76	Entomophthora muscae	34485	Fungi	Fungi	46.2	0.00313	NR	KAJ9065681.1	34485	g112803	i0	47.9	0.529411764705882	48	20	52.9	1	228	85	506	548	KAJ9065681.1 glutamate decarboxylase gad1 [Entomophthora muscae]	diamond	144	46.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
30759982	30759982	PRJEB28062_P_NODE_42454_length_555_cov_18.143154_g40118_i0	PRJEB28062	42454	555	18.143154	100.6945047	Basidiobolus ranarum	34480	Fungi	Fungi	59.3	9.44e-8	NR	KAK9763158.1	34480	g40118	i0	47.4	0.308108108108108	57	30	30.8	0	487	317	19	75	KAK9763158.1 hypothetical protein K7432_010426 [Basidiobolus ranarum]	diamond	171	59.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30848256	30848256	PRJEB28062_P_NODE_52594_length_489_cov_8.132212_g50241_i0	PRJEB28062	52594	489	8.1322120000000009	39.76651668	Zoopagomycota	1913638	Fungi	Fungi	46.2	0.00324	NR	RKP39213.1	215637	g50241	i0	43.1	2.23926380368098	51	29	31.3	0	129	281	7	57	RKP39213.1 hypothetical protein BJ085DRAFT_18658 [Dimargaris cristalligena]	diamond	1095	46.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
31075976	31075976	PRJEB28062_P_NODE_132815_length_233_cov_13.187500_g130451_i0	PRJEB28062	132815	233	13.1875	30.726875	Neoconidiobolus thromboides	76012	Fungi	Fungi	49.3	1.33e-4	NR	QUQ05876.1	76012	g130451	i0	100	0.334763948497854	26	0	33.5	0	211	134	227	252	QUQ05876.1 ATP synthase F0 subunit a [Neoconidiobolus thromboides]	diamond	78	49.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
31360545	31360545	PRJEB28062_P_NODE_41316_length_564_cov_24.610998_g38982_i0	PRJEB28062	41316	564	24.610998	138.80602872	Dispira parvispora	1520584	Fungi	Fungi	54.3	4.58e-6	NR	KAJ1962306.1	1520584	g38982	i0	50	0.287234042553192	54	27	28.7	0	397	236	7	60	KAJ1962306.1 hypothetical protein IWQ62_003571, partial [Dispira parvispora]	diamond	162	54.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira parvispora

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