metadata: contig_metadata: 9 rows where bioproject = "PRJEB66218" and tax

9 rows where bioproject = "PRJEB66218" and tax_phylum = "Microsporidia"

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_family	tax_genus	tax_species
2684916	2684916	PRJEB66218_P_NODE_98443_length_309_cov_4.471774_g96015_i0	PRJEB66218	98443	309	4.471774	13.81778166	Pleistophora mulleri	249366	Fungi	Fungi	425	1.48e-114	NTclustered	gi\|134147422\|gb\|EF119339.1\|	249366	g96015	i0	91.318	25.1359223300971	311	24	99	3	2	309	3593	3283	Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	7767	425	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Pleistophora	Pleistophora mulleri
10337611	10337611	PRJEB66218_P_NODE_88289_length_331_cov_6.025926_g85862_i0	PRJEB66218	88289	331	6.025926	19.94581506	Ovipleistophora diplostomuri	2023159	Fungi	Fungi	442	1.5799999999999993e-119	NTclustered	gi\|2017842943\|gb\|MW811107.1\|	2023159	g85862	i0	90.801	24.3655589123867	337	22	100	8	1	331	1245	1578	Ovipleistophora diplostomuri isolate 15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	8065	442	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Ovipleistophora	Ovipleistophora diplostomuri
15433316	15433316	PRJEB66218_P_NODE_126213_length_266_cov_4.946341_g123784_i0	PRJEB66218	126213	266	4.946341	13.15726706	Vavraia culicis	103449	Fungi	Fungi	291	4.74e-74	NTclustered	gi\|667636757\|ref\|XR_552273.1\|	948595	g123784	i0	86.667	27.6616541353383	270	26	100	7	1	266	659	396	Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA	blastn	7358	291	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Vavraia	Vavraia culicis
17982661	17982661	PRJEB66218_P_NODE_134655_length_256_cov_20.635897_g132226_i0	PRJEB66218	134655	256	20.635897	52.82789632	Vavraia culicis	103449	Fungi	Fungi	305	1.62e-78	NTclustered	gi\|667636757\|ref\|XR_552273.1\|	948595	g132226	i0	88.281	2	256	29	100	1	1	256	2634	2380	Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA	blastn	512	305	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Vavraia	Vavraia culicis
21808890	21808890	PRJEB66218_P_NODE_19558_length_893_cov_19.365385_g17517_i0	PRJEB66218	19558	893	19.365385	172.93288805	Heterosporis sp. NBDP-2013a	1289055	Fungi	Fungi	75	1.92e-8	NTclustered	gi\|448278458\|gb\|KC137554.1\|	1289055	g17517	i0	95.652	0.105263157894737	46	2	5	0	561	606	2917	2962	Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	94	75	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Heterosporis	Heterosporis sp. NBDP-2013a
25220276	25220276	PRJEB66218_P_NODE_131160_length_260_cov_3.768844_g128731_i0	PRJEB66218	131160	260	3.768844	9.7989944	Glugeidae	36735	Fungi	Fungi	424	4.36e-114	NTclustered	gi\|7161819\|emb\|AJ252951.1\|	103443	g128731	i0	96.85	96.6923076923077	254	7	97	1	8	260	556	809	Loma acerinae 16S rRNA gene	blastn	25140	425	0.997647058823529	Eukaryota	Opisthokonta	Fungi	Microsporidia	Glugeidae	Loma	Loma acerinae
28707983	28707983	PRJEB66218_P_NODE_237307_length_203_cov_0.894366_g234876_i0	PRJEB66218	237307	203	0.894366	1.81556298	Nosema bombycis	27978	Fungi	Fungi	42	0.0405	NR	WGJ64385.1	27978	g234876	i0	54.1	0.54679802955665	37	16	54.7	1	79	189	21	56	WGJ64385.1 ricin B lectin-like protein [Nosema bombycis]	diamond	111	42	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
28739415	28739415	PRJEB66218_P_NODE_206347_length_209_cov_0.878378_g203917_i0	PRJEB66218	206347	209	0.878378	1.83581002	Nematocida sp. AWRm8	1927920	Fungi	Fungi	50.4	4.26e-5	NR	KAI5179627.1	2670343	g203917	i0	56.1	0.588516746411483	41	18	58.9	0	83	205	98	138	KAI5179627.1 hypothetical protein NEOKW01_0090 [Nematocida sp. AWRm80]	diamond	123	50.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm80
31487951	31487951	PRJEB66218_P_NODE_166596_length_229_cov_4.255952_g164166_i0	PRJEB66218	166596	229	4.255952	9.74613008	Anncaliia algerae PRA1	723287	Fungi	Fungi	58.5	2.06e-8	NR	KCZ75641.1	1240240	g164166	i0	40.8	5.94759825327511	71	42	93	0	214	2	14	84	KCZ75641.1 hypothetical protein H311_03378 [Anncaliia algerae PRA109]	diamond	1362	58.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Anncaliia	Anncaliia algerae

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