metadata: contig_metadata: 11 rows where bioproject = "PRJNA811237", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA811237", 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
8461858	8461858	PRJNA811237_S_NODE_30647_length_165_cov_0.879310_g30407_i0	PRJNA811237	30647	165	0.87931	1.4508615	Fungi	4751	Fungi	Fungi	77	9.69e-15	NR	KAK6090315.1	40135	g30407	i0	59.3	2.96363636363636	54	22	98.2	0	2	163	22	75	KAK6090315.1 hypothetical protein P3W45_000672 [Vairimorpha bombi]	diamond	489	77	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha bombi
26999608	26999608	PRJNA811237_S_NODE_11802_length_228_cov_1.910615_g11562_i0	PRJNA811237	11802	228	1.910615	4.3562022	Opisthokonta	33154	Fungi	Fungi	50.8	2.6e-5	NR	XP_065328585.1	6039	g11562	i0	42.4	1.34210526315789	59	34	77.6	0	226	50	130	188	XP_065328585.1 Ras-related protein Rab11 [Vairimorpha necatrix]	diamond	306	51.2	0.9921875	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha necatrix
27212107	27212107	PRJNA811237_S_NODE_32382_length_163_cov_1.271930_g32142_i0	PRJNA811237	32382	163	1.27193	2.0732459	Nematocida major	1912982	Fungi	Fungi	47	4.08e-4	NR	XP_047770507.1	1912982	g32142	i0	42.9	3.62576687116564	42	24	77.3	0	127	2	44	85	XP_047770507.1 threonyl-tRNA synthetase [Nematocida major]	diamond	591	47	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida major
27410985	27410985	PRJNA811237_S_NODE_15623_length_207_cov_1.170886_g15383_i0	PRJNA811237	15623	207	1.170886	2.42373402	Fungi	4751	Fungi	Fungi	45.1	0.00327	NR	ORD98288.1	1081669	g15383	i0	56.7	3.15942028985507	30	13	43.5	0	102	13	159	188	ORD98288.1 AML1 [Hepatospora eriocheir]	diamond	654	45.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Hepatosporidae	Hepatospora	Hepatospora eriocheir
27591564	27591564	PRJNA811237_S_NODE_5384_length_314_cov_1.732075_g5144_i0	PRJNA811237	5384	314	1.732075	5.4387155	Vairimorpha ceranae	40302	Fungi	Fungi	200	9.03e-60	NR	XP_024331810.1	40302	g5144	i0	89.4	38.7515923566879	104	11	99.4	0	3	314	255	358	XP_024331810.1 vacuolar atp synthase subunit b [Vairimorpha ceranae]	diamond	12168	200	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha ceranae
27884312	27884312	PRJNA811237_S_NODE_32645_length_163_cov_0.894737_g32405_i0	PRJNA811237	32645	163	0.894737	1.45842131	Nematocida	586132	Fungi	Fungi	64.7	2.28e-10	NR	XP_051346438.1	1912981	g32405	i0	54.7	6.80981595092025	53	24	97.5	0	160	2	613	665	XP_051346438.1 myosin heavy chain 9/10/11/14 [Nematocida homosporus]	diamond	1110	64.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida homosporus
28452820	28452820	PRJNA811237_S_NODE_24826_length_174_cov_1.224000_g24586_i0	PRJNA811237	24826	174	1.224	2.12976	Fungi	4751	Fungi	Fungi	55.8	3.45e-7	NR	XP_024330626.1	40302	g24586	i0	45.6	3.72413793103448	57	31	98.3	0	3	173	574	630	XP_024330626.1 phospholipid-transporting atpase [Vairimorpha ceranae]	diamond	648	56.2	0.99288256227758	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha ceranae
28822439	28822439	PRJNA811237_S_NODE_30388_length_165_cov_0.879310_g30148_i0	PRJNA811237	30388	165	0.87931	1.4508615	Encephalitozoon cuniculi GB-M1	284813	Fungi	Fungi	45.1	0.00202	NR	NP_597574.1	284813	g30148	i0	58.8	0.618181818181818	34	14	61.8	0	7	108	328	361	NP_597574.1 uncharacterized protein ECU03_0630 [Encephalitozoon cuniculi GB-M1]	diamond	102	45.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Unikaryonidae	Encephalitozoon	Encephalitozoon cuniculi
29810229	29810229	PRJNA811237_S_NODE_20451_length_188_cov_0.978417_g20211_i0	PRJNA811237	20451	188	0.978417	1.83942396	Eukaryota	2759	Fungi	Fungi	72.8	4.53e-13	NR	EED44277.1	481877	g20211	i0	49.2	13.5	59	30	94.1	0	183	7	527	585	EED44277.1 serine/threonine protein kinase [Enterocytozoon bieneusi H348]	diamond	2538	73.2	0.994535519125683	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterocytozoon	Enterocytozoon bieneusi
29864678	29864678	PRJNA811237_S_NODE_3391_length_393_cov_1.258721_g3151_i0	PRJNA811237	3391	393	1.258721	4.94677353	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	121	1.33e-30	NR	EJW04030.1	1003232	g3151	i0	49.2	1.00763358778626	132	65	100	2	1	393	81	211	EJW04030.1 CMGC/CDK/CDC2 protein kinase [Edhazardia aedis USNM 41457]	diamond	396	121	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
30875726	30875726	PRJNA811237_S_NODE_34054_length_162_cov_0.902655_g33814_i0	PRJNA811237	34054	162	0.902655	1.4623011	Vairimorpha necatrix	6039	Fungi	Fungi	51.2	1.24e-5	NR	XP_065329252.1	6039	g33814	i0	46.2	0.962962962962963	52	28	96.3	0	158	3	582	633	XP_065329252.1 protein kinase C-like [Vairimorpha necatrix]	diamond	156	51.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha necatrix

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