metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1028258" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1028258" 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
1006179	1006179	PRJNA1028258_P_NODE_74581_length_298_cov_1.550218_g74018_i0	PRJNA1028258	74581	298	1.550218	4.61964964	Astathelohaniidae	2932329	Fungi	Fungi	149	2.31e-43	NR	KAF7683006.1	164912	g74018	i0	68.7	2.97986577181208	99	31	99.7	0	297	1	69	167	KAF7683006.1 60S ribosomal protein L11 [Astathelohania contejeani]	diamond	888	149	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Astathelohaniidae	Astathelohania	Astathelohania contejeani
14193404	14193404	PRJNA1028258_P_NODE_38972_length_405_cov_2.047619_g38409_i0	PRJNA1028258	38972	405	2.047619	8.29285695	Astathelohania contejeani	164912	Fungi	Fungi	76.3	2.64e-14	NR	KAF7683006.1	164912	g38409	i0	72	1.46666666666667	50	14	37	0	404	255	122	171	KAF7683006.1 60S ribosomal protein L11 [Astathelohania contejeani]	diamond	594	76.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Astathelohaniidae	Astathelohania	Astathelohania contejeani
26591582	26591582	PRJNA1028258_P_NODE_157021_length_229_cov_1.737500_g156458_i0	PRJNA1028258	157021	229	1.7375	3.978875	Spraguea lophii 42_11	51541	Fungi	Fungi	47.8	4.49e-4	NR	EPR78516.1	1358809	g156458	i0	37.1	1.68995633187773	62	39	81.2	0	18	203	157	218	EPR78516.1 Chitin/polysaccharide deacetylase [Spraguea lophii 42_110]	diamond	387	47.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Spragueidae	Spraguea	Spraguea lophii
27982685	27982685	PRJNA1028258_P_NODE_5565_length_1019_cov_2.246316_g5238_i0	PRJNA1028258	5565	1019	2.246316	22.88996004	Mitosporidium daphniae	1485682	Fungi	Fungi	69.7	6.12e-9	NR	XP_013239425.1	1485682	g5238	i0	59.6	2.62904808635918	47	19	13.8	0	62	202	247	293	XP_013239425.1 uncharacterized protein DI09_11p10 [Mitosporidium daphniae]	diamond	2679	69.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28993339	28993339	PRJNA1028258_P_NODE_164628_length_228_cov_0.893082_g164065_i0	PRJNA1028258	164628	228	0.893082	2.03622696	Hamiltosporidium tvaerminnensis	1176355	Fungi	Fungi	59.3	8.78e-9	NR	KAK1347178.1	1176355	g164065	i0	38.9	1.85526315789474	72	42	92.1	2	212	3	8	79	KAK1347178.1 DNA-directed RNA polymerase II subunit [Hamiltosporidium tvaerminnensis]	diamond	423	59.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Dubosqiidae	Hamiltosporidium	Hamiltosporidium tvaerminnensis
29710943	29710943	PRJNA1028258_P_NODE_176010_length_225_cov_0.910256_g175447_i0	PRJNA1028258	176010	225	0.910256	2.048076	Pancytospora	1939651	Fungi	Fungi	90.9	7.19e-20	NR	KAI4293015.1	1923975	g175447	i0	56	15.96	75	33	100	0	1	225	4	78	KAI4293015.1 serine/threonine-protein phosphatase 2A catalytic subunit [Pancytospora philotis]	diamond	3591	91.3	0.995618838992333	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora philotis
30003589	30003589	PRJNA1028258_P_NODE_174631_length_225_cov_1.365385_g174068_i0	PRJNA1028258	174631	225	1.365385	3.07211625	Enterocytozoon bieneusi H348	481877	Fungi	Fungi	99	2.9399999999999998e-24	NR	EED44450.1	481877	g174068	i0	54.7	1	75	33	100	1	225	1	8	81	EED44450.1 ubiquitin-conjugating enzyme E2 [Enterocytozoon bieneusi H348]	diamond	225	99	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterocytozoon	Enterocytozoon bieneusi
30666969	30666969	PRJNA1028258_P_NODE_47993_length_366_cov_1.252525_g47430_i0	PRJNA1028258	47993	366	1.252525	4.5842415	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	46.2	0.00526	NR	EJW01660.1	1003232	g47430	i0	26.2	1	122	78	90.2	3	11	340	49	170	EJW01660.1 hypothetical protein EDEG_03792 [Edhazardia aedis USNM 41457]	diamond	366	46.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
32216421	32216421	PRJNA1028258_P_NODE_109338_length_253_cov_1.255435_g108775_i0	PRJNA1028258	109338	253	1.255435	3.17625055	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	89	2.33e-18	NR	OIR57247.1	1866961	g108775	i0	44	2.98814229249012	84	47	99.6	0	253	2	234	317	OIR57247.1 MAG: translation elongation factor 2 [Amphiamblys sp. WSBS2006]	diamond	756	89	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
32311622	32311622	PRJNA1028258_P_NODE_54899_length_343_cov_1.514599_g54336_i0	PRJNA1028258	54899	343	1.514599	5.19507457	Mitosporidium daphniae	1485682	Fungi	Fungi	71.6	2.73e-12	NR	XP_013236389.1	1485682	g54336	i0	47.3	0.795918367346939	91	45	77.8	2	8	274	122	211	XP_013236389.1 uncharacterized protein DI09_9p70 [Mitosporidium daphniae]	diamond	273	71.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae

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