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

9 rows where bioproject = "PRJNA520845", 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
14522263	14522263	PRJNA520845_P_NODE_94552_length_382_cov_1.310680_g93053_i0	PRJNA520845	94552	382	1.31068	5.0067976	Mitosporidium daphniae	1485682	Fungi	Fungi	80.5	1.67e-10	NTclustered	gi\|1378896647\|gb\|MF278562.1\|	1485682	g93053	i0	78.261	2.63612565445026	138	20	35	7	231	362	6918	6785	Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	1007	80.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
22168494	22168494	PRJNA520845_P_NODE_270398_length_206_cov_3.263158_g268899_i0	PRJNA520845	270398	206	3.263158	6.72210548	Nosema bombycis	27978	Fungi	Fungi	52.8	0.018	NTclustered	gi\|1108981751\|gb\|KX769814.1\|	27978	g268899	i0	100	0.135922330097087	28	0	14	0	92	119	656	629	Nosema bombycis isolate ZJ1 SAS-6 centriolar assembly protein (SAS-6) gene, complete cds	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
27456713	27456713	PRJNA520845_P_NODE_217963_length_250_cov_1.451977_g216464_i0	PRJNA520845	217963	250	1.451977	3.6299425	Mitosporidium daphniae	1485682	Fungi	Fungi	51.2	8.85e-6	NR	XP_013239141.1	1485682	g216464	i0	73.1	0.888	26	7	31.2	0	211	134	99	124	XP_013239141.1 translation initiation factor eIF1A-like protein [Mitosporidium daphniae]	diamond	222	51.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
30677464	30677464	PRJNA520845_P_NODE_268873_length_235_cov_2.104938_g267374_i0	PRJNA520845	268873	235	2.104938	4.9466043	Mitosporidium daphniae	1485682	Fungi	Fungi	72.4	1.16e-12	NR	XP_013239145.1	1485682	g267374	i0	49.4	3	77	39	98.3	0	3	233	99	175	XP_013239145.1 uncharacterized protein DI09_140p40 [Mitosporidium daphniae]	diamond	705	72.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
30993624	30993624	PRJNA520845_P_NODE_248294_length_244_cov_1.801170_g246795_i0	PRJNA520845	248294	244	1.80117	4.3948548	Pancytospora epiphaga	1938578	Fungi	Fungi	45.1	0.00308	NR	KAI5170909.1	1938578	g246795	i0	46.3	0.885245901639344	41	22	50.4	0	6	128	22	62	KAI5170909.1 large subunit ribosomal protein L19e [Pancytospora epiphaga]	diamond	216	45.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora epiphaga
31562852	31562852	PRJNA520845_P_NODE_154996_length_299_cov_2.486726_g153497_i0	PRJNA520845	154996	299	2.486726	7.43531074	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	51.6	5.76e-5	NR	EJW01836.1	1003232	g153497	i0	36.6	0.933110367892977	93	52	92.3	3	298	23	1697	1783	EJW01836.1 hypothetical protein EDEG_03682 [Edhazardia aedis USNM 41457]	diamond	279	51.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
32037234	32037234	PRJNA520845_P_NODE_89598_length_392_cov_1.708464_g88099_i0	PRJNA520845	89598	392	1.708464	6.69717888	Mitosporidium daphniae	1485682	Fungi	Fungi	147	2e-40	NR	XP_013236520.1	1485682	g88099	i0	59.7	3.9719387755102	129	49	98	2	390	7	119	245	XP_013236520.1 60S ribosomal protein L5-2 [Mitosporidium daphniae]	diamond	1557	147	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
32084063	32084063	PRJNA520845_P_NODE_134238_length_322_cov_2.004016_g132739_i0	PRJNA520845	134238	322	2.004016	6.45293152	Nematocida	586132	Fungi	Fungi	50.1	2.08e-4	NR	XP_067543783.1	1805483	g132739	i0	39.8	1.54658385093168	83	43	70.8	4	321	94	173	255	XP_067543783.1 transformer-2 protein [Nematocida displodere]	diamond	498	50.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida displodere
32132297	32132297	PRJNA520845_P_NODE_81598_length_411_cov_1.520710_g80099_i0	PRJNA520845	81598	411	1.52071	6.2501181	Pancytospora philotis	1923975	Fungi	Fungi	51.2	2.63e-4	NR	KAI4293155.1	1923975	g80099	i0	52.3	1.13868613138686	44	21	32.1	0	375	244	630	673	KAI4293155.1 hypothetical protein PAPHI01_2429 [Pancytospora philotis]	diamond	468	51.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora philotis

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