metadata: contig_metadata: 8 rows where bioproject = "PRJNA980585", tax_kingdom = "Fungi" and tax

8 rows where bioproject = "PRJNA980585", tax_kingdom = "Fungi" 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
8607747	8607747	PRJNA980585_P_NODE_38387_length_256_cov_1.683060_g38133_i0	PRJNA980585	38387	256	1.68306	4.3086336	Trachipleistophora hominis	72359	Fungi	Fungi	93.2	1.95e-21	NR	ELQ75495.1	72359	g38133	i0	71.2	2.07421875	59	17	69.1	0	3	179	132	190	ELQ75495.1 60S ribosomal protein L11, partial [Trachipleistophora hominis]	diamond	531	93.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Trachipleistophora	Trachipleistophora hominis
13708553	13708553	PRJNA980585_P_NODE_43211_length_250_cov_0.870056_g42957_i0	PRJNA980585	43211	250	0.870056	2.17514	Mitosporidium daphniae	1485682	Fungi	Fungi	134	2.32e-37	NR	XP_013238674.1	1485682	g42957	i0	74.4	2.928	82	21	98.4	0	3	248	103	184	XP_013238674.1 ribosomal protein L15 [Mitosporidium daphniae]	diamond	732	134	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
15297365	15297365	PRJNA980585_P_NODE_60672_length_241_cov_0.916667_g60418_i0	PRJNA980585	60672	241	0.916667	2.20916747	Nosema bombycis CQ1	578461	Fungi	Fungi	80.9	5.12e-16	NR	EOB13635.1	578461	g60418	i0	80.5	2.57676348547718	41	8	51	0	118	240	36	76	EOB13635.1 Serine/threonine-protein phosphatase PP2A-2 catalytic subunit [Nosema bombycis CQ1]	diamond	621	80.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
25181139	25181139	PRJNA980585_P_NODE_4840_length_573_cov_1.858000_g4586_i0	PRJNA980585	4840	573	1.858	10.64634	Heterosporis sp. NBDP-2013a	1289055	Fungi	Fungi	75	1.21e-8	NTclustered	gi\|448278458\|gb\|KC137554.1\|	1289055	g4586	i0	95.652	0.0802792321116928	46	2	8	0	492	537	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	46	75	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Heterosporis	Heterosporis sp. NBDP-2013a
30026326	30026326	PRJNA980585_P_NODE_46831_length_248_cov_0.880000_g46577_i0	PRJNA980585	46831	248	0.88	2.1824	Pancytospora philotis	1923975	Fungi	Fungi	68.2	4.42e-11	NR	KAI4291937.1	1923975	g46577	i0	40.7	0.979838709677419	81	47	98	1	1	243	730	809	KAI4291937.1 DNA polymerase delta subunit 1 [Pancytospora philotis]	diamond	243	68.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora philotis
31321634	31321634	PRJNA980585_P_NODE_11535_length_399_cov_0.938650_g11281_i0	PRJNA980585	11535	399	0.93865	3.7452135	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	132	1.28e-33	NR	EJW02613.1	1003232	g11281	i0	50	0.962406015037594	128	58	96.2	1	13	396	188	309	EJW02613.1 hypothetical protein EDEG_02987 [Edhazardia aedis USNM 41457]	diamond	384	132	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
31574951	31574951	PRJNA980585_P_NODE_60196_length_241_cov_0.916667_g59942_i0	PRJNA980585	60196	241	0.916667	2.20916747	Nosema granulosis	83296	Fungi	Fungi	54.7	2.25e-6	NR	KAF9764206.1	83296	g59942	i0	60.5	1.18257261410788	43	17	53.5	0	240	112	491	533	KAF9764206.1 DNA replication licensing factor MCM7 [Nosema granulosis]	diamond	285	54.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
32775898	32775898	PRJNA980585_P_NODE_28540_length_283_cov_2.928571_g28286_i0	PRJNA980585	28540	283	2.928571	8.28785593	Nematocida homosporus	1912981	Fungi	Fungi	43.5	0.00763	NR	XP_051346056.1	1912981	g28286	i0	46.9	0.519434628975265	49	26	51.9	0	80	226	20	68	XP_051346056.1 dynein light chain LC8-type [Nematocida homosporus]	diamond	147	43.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida homosporus

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