metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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
28142602	28142602	PRJNA1120060_P_NODE_1734945_length_283_cov_3.876190_g1716937_i0	PRJNA1120060	1734945	283	3.87619	10.9696177	Nosema granulosis	83296	Fungi	Fungi	43.9	0.0221	NR	KAF9762011.1	83296	g1716937	i0	37.5	0.593639575971731	56	35	59.4	0	190	23	83	138	KAF9762011.1 Transposon Tf2-11 polyprotein [Nosema granulosis]	diamond	168	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
28679412	28679412	PRJNA1120060_P_NODE_192687_length_473_cov_3.120000_g176299_i0	PRJNA1120060	192687	473	3.12	14.7576	Vairimorpha ceranae BRL	40302	Fungi	Fungi	45.8	0.0107	NR	EEQ81190.1	578460	g176299	i0	37.3	0.47568710359408	75	44	45.7	2	436	221	1	75	EEQ81190.1 hypothetical protein NCER_102536 [Vairimorpha ceranae BRL01]	diamond	225	45.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha ceranae
29058981	29058981	PRJNA1120060_P_NODE_2910528_length_243_cov_2.717647_g2892435_i0	PRJNA1120060	2910528	243	2.717647	6.60388221	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	42.7	0.0351	NR	OQS54043.1	646526	g2892435	i0	30.6	0.888888888888889	72	44	81.5	1	35	232	41	112	OQS54043.1 hypothetical protein EHP00_1697 [Enterocytozoon hepatopenaei]	diamond	216	42.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
29469581	29469581	PRJNA1120060_P_NODE_803630_length_320_cov_1.469636_g785742_i0	PRJNA1120060	803630	320	1.469636	4.7028352	Mitosporidium daphniae	1485682	Fungi	Fungi	43.5	0.0417	NR	XP_013238320.1	1485682	g785742	i0	36.7	0.5625	60	37	56.3	1	42	221	66	124	XP_013238320.1 uncharacterized protein DI09_24p140 [Mitosporidium daphniae]	diamond	180	43.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
29996171	29996171	PRJNA1120060_P_NODE_236251_length_447_cov_4.411765_g219497_i0	PRJNA1120060	236251	447	4.411765	19.72058955	Opisthokonta	33154	Fungi	Fungi	74.7	7.31e-14	NR	ADZ95639.1	27978	g219497	i0	38.7	2.75167785234899	106	54	71.1	1	64	381	1	95	ADZ95639.1 40S ribosomal protein S31, partial [Nosema bombycis]	diamond	1230	74.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
30510792	30510792	PRJNA1120060_P_NODE_1666813_length_286_cov_2.854460_g1648812_i0	PRJNA1120060	1666813	286	2.85446	8.1637556	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	51.6	4.85e-5	NR	OIR58534.1	1866961	g1648812	i0	52.3	1.70979020979021	44	21	46.2	0	178	47	432	475	OIR58534.1 MAG: uncharacterized protein A8A55_0683 [Amphiamblys sp. WSBS2006]	diamond	489	51.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
30922172	30922172	PRJNA1120060_P_NODE_2244774_length_263_cov_2.278947_g2226720_i0	PRJNA1120060	2244774	263	2.278947	5.99363061	Vairimorpha ceranae BRL	40302	Fungi	Fungi	72.8	2.05e-13	NR	EEQ81299.1	578460	g2226720	i0	61.6	0.832699619771863	73	28	83.3	0	219	1	80	152	EEQ81299.1 hypothetical protein NCER_102335 [Vairimorpha ceranae BRL01]	diamond	219	72.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha ceranae
31079915	31079915	PRJNA1120060_P_NODE_1986215_length_273_cov_2.480000_g1968187_i0	PRJNA1120060	1986215	273	2.48	6.7704	Pseudoloma neurophilia	146866	Fungi	Fungi	50.8	2.99e-5	NR	KRH93961.1	146866	g1968187	i0	31.3	0.912087912087912	83	56	91.2	1	257	9	70	151	KRH93961.1 putative transposable element, partial [Pseudoloma neurophilia]	diamond	249	50.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
31808115	31808115	PRJNA1120060_P_NODE_3533117_length_204_cov_4.671756_g3514990_i0	PRJNA1120060	3533117	204	4.671756	9.53038224	Pseudoloma neurophilia	146866	Fungi	Fungi	42	0.0396	NR	KRH94446.1	146866	g3514990	i0	43.6	0.573529411764706	39	19	52.9	1	44	151	137	175	KRH94446.1 hypothetical protein M153_2560002935 [Pseudoloma neurophilia]	diamond	117	42	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
32281390	32281390	PRJNA1120060_P_NODE_1109499_length_311_cov_2.920168_g1091564_i0	PRJNA1120060	1109499	311	2.920168	9.08172248	Pancytospora philotis	1923975	Fungi	Fungi	58.2	3.27e-7	NR	KAI4292185.1	1923975	g1091564	i0	52.8	1.0225080385852101	53	25	51.1	0	132	290	749	801	KAI4292185.1 hypothetical protein PAPHI01_1459, partial [Pancytospora philotis]	diamond	318	58.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora philotis
32345177	32345177	PRJNA1120060_P_NODE_1800759_length_281_cov_1.168269_g1782747_i0	PRJNA1120060	1800759	281	1.168269	3.28283589	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	43.9	0.0236	NR	OIR56906.1	1866961	g1782747	i0	46.2	0.555160142348754	52	16	42.7	3	247	128	170	221	OIR56906.1 MAG: uncharacterized protein A8A55_2342 [Amphiamblys sp. WSBS2006]	diamond	156	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
32534457	32534457	PRJNA1120060_P_NODE_1147939_length_311_cov_2.424370_g1130004_i0	PRJNA1120060	1147939	311	2.42437	7.5397907	Enteropsectra breve	1912989	Fungi	Fungi	63.5	2.68e-9	NR	KAI5155156.1	1912989	g1130004	i0	67.3	1.41800643086817	49	16	47.3	0	3	149	73	121	KAI5155156.1 hypothetical protein ENBRE01_3496, partial [Enteropsectra breve]	diamond	441	63.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve

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