metadata: contig_metadata: 6 rows where bioproject = "PRJNA688931", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA688931", 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
26733700	26733700	PRJNA688931_P_NODE_1281_length_991_cov_4.174098_g1156_i0	PRJNA688931	1281	991	4.174098	41.36531118	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	197	4.0299999999999995e-57	NR	EJW04030.1	1003232	g1156	i0	39.1	0.929364278506559	307	166	91.7	6	982	74	3	292	EJW04030.1 CMGC/CDK/CDC2 protein kinase [Edhazardia aedis USNM 41457]	diamond	921	197	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
26840927	26840927	PRJNA688931_P_NODE_1341_length_972_cov_4.681473_g1211_i0	PRJNA688931	1341	972	4.681473	45.50391756	Eukaryota	2759	Fungi	Fungi	197	2.2999999999999997e-57	NR	EJW04030.1	1003232	g1211	i0	37.6	3.78703703703704	306	172	93.5	8	959	51	4	293	EJW04030.1 CMGC/CDK/CDC2 protein kinase [Edhazardia aedis USNM 41457]	diamond	3681	197	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
27050737	27050737	PRJNA688931_P_NODE_12342_length_297_cov_1.354839_g12129_i0	PRJNA688931	12342	297	1.354839	4.02387183	Nosema bombycis CQ1	578461	Fungi	Fungi	44.3	0.00252	NR	EOB11701.1	578461	g12129	i0	30.3	0.666666666666667	66	46	66.7	0	293	96	13	78	EOB11701.1 Transcription initiation factor IIA subunit 2 [Nosema bombycis CQ1]	diamond	198	44.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
27714542	27714542	PRJNA688931_P_NODE_38604_length_166_cov_0.880342_g38391_i0	PRJNA688931	38604	166	0.880342	1.46136772	Mitosporidium daphniae	1485682	Fungi	Fungi	61.6	2.88e-9	NR	XP_013238970.1	1485682	g38391	i0	59.6	3.07228915662651	57	21	99.4	1	165	1	330	386	XP_013238970.1 catalase [Mitosporidium daphniae]	diamond	510	61.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28661448	28661448	PRJNA688931_P_NODE_5947_length_451_cov_1.634328_g5735_i0	PRJNA688931	5947	451	1.634328	7.37081928	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	87	8.31e-17	NR	OIR57626.1	1866961	g5735	i0	33.1	1.82926829268293	136	88	89.1	2	445	44	20	154	OIR57626.1 MAG: histone-binding protein RBBP4 [Amphiamblys sp. WSBS2006]	diamond	825	87	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
30335478	30335478	PRJNA688931_P_NODE_29872_length_186_cov_1.102190_g29659_i0	PRJNA688931	29872	186	1.10219	2.0500734	Tubulinosema ratisbonensis	291195	Fungi	Fungi	52	9.42e-6	NR	RVD91651.1	291195	g29659	i0	44.3	0.983870967741935	61	34	98.4	0	3	185	931	991	RVD91651.1 DNA topoisomerase II [Tubulinosema ratisbonensis]	diamond	183	52	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Tubulinosema	Tubulinosema ratisbonensis

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