metadata: contig_metadata: 8 rows where bioproject = "PRJNA1067370" and tax

8 rows where bioproject = "PRJNA1067370" 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
10384136	10384136	PRJNA1067370_P_NODE_40369_length_318_cov_1.257143_g39821_i0	PRJNA1067370	40369	318	1.257143	3.99771474	Spraguea lophii 42_11	51541	Fungi	Fungi	116	3.71e-28	NR	EPR77979.1	1358809	g39821	i0	76.8	5.23584905660377	69	16	65.1	0	209	3	1	69	EPR77979.1 Alpha tubulin [Spraguea lophii 42_110]	diamond	1665	116	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Spragueidae	Spraguea	Spraguea lophii
27067168	27067168	PRJNA1067370_P_NODE_74442_length_258_cov_1.340541_g73893_i0	PRJNA1067370	74442	258	1.340541	3.45859578	Tubulinosema ratisbonensis	291195	Fungi	Fungi	65.5	1.03e-10	NR	RVD90764.1	291195	g73893	i0	53.2	1.09302325581395	47	22	54.7	0	142	2	21	67	RVD90764.1 Rho GTPase [Tubulinosema ratisbonensis]	diamond	282	65.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Tubulinosema	Tubulinosema ratisbonensis
28330489	28330489	PRJNA1067370_P_NODE_79986_length_251_cov_0.865169_g79437_i0	PRJNA1067370	79986	251	0.865169	2.17157419	Mitosporidium daphniae	1485682	Fungi	Fungi	67	6.05e-11	NR	XP_013238026.1	1485682	g79437	i0	55.2	2.11553784860558	67	30	80.1	0	8	208	189	255	XP_013238026.1 40S ribosomal protein S1 [Mitosporidium daphniae]	diamond	531	67	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
29593091	29593091	PRJNA1067370_P_NODE_59030_length_281_cov_1.480769_g58481_i0	PRJNA1067370	59030	281	1.480769	4.16096089	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	79.3	5.84e-15	NR	XP_007604107.1	993615	g58481	i0	53.8	0.854092526690391	80	36	85.4	1	240	1	167	245	XP_007604107.1 uncharacterized protein VICG_00655 [Vittaforma corneae ATCC 50505]	diamond	240	79.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
29782925	29782925	PRJNA1067370_P_NODE_56831_length_285_cov_1.047170_g56282_i0	PRJNA1067370	56831	285	1.04717	2.9844345	Nosema granulosis	83296	Fungi	Fungi	42.7	0.0499	NR	KAF9761457.1	83296	g56282	i0	36.4	0.694736842105263	66	39	66.3	2	193	5	58	123	KAF9761457.1 Gag-Pro-Pol polyprotein [Nosema granulosis]	diamond	198	42.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
30288705	30288705	PRJNA1067370_P_NODE_101652_length_245_cov_0.895349_g101103_i0	PRJNA1067370	101652	245	0.895349	2.19360505	Trachipleistophora hominis	72359	Fungi	Fungi	66.2	1.96e-10	NR	ELQ74587.1	72359	g101103	i0	41.6	1.88571428571429	77	43	94.3	2	231	1	133	207	ELQ74587.1 Ca2+-binding actin-bundling protein (actinin), alpha chain (EF-Hand protein superfamily), partial [Trachipleistophora hominis]	diamond	462	66.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Trachipleistophora	Trachipleistophora hominis
30320484	30320484	PRJNA1067370_P_NODE_12272_length_522_cov_1.893096_g11727_i0	PRJNA1067370	12272	522	1.893096	9.88196112	Vairimorpha bombi	40135	Fungi	Fungi	103	2.5600000000000003e-22	NR	KAK6089767.1	40135	g11727	i0	35.2	3.6551724137931	159	103	91.4	0	502	26	295	453	KAK6089767.1 hypothetical protein P3W45_001269 [Vairimorpha bombi]	diamond	1908	103	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha bombi
31678995	31678995	PRJNA1067370_P_NODE_80717_length_251_cov_0.865169_g80168_i0	PRJNA1067370	80717	251	0.865169	2.17157419	Enterospora canceri	1081671	Fungi	Fungi	123	1.09e-30	NR	ORD94672.1	1081671	g80168	i0	66.3	1.9840637450199201	83	28	99.2	0	251	3	63	145	ORD94672.1 SPB1 [Enterospora canceri]	diamond	498	123	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterospora	Enterospora canceri

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