metadata: contig_metadata: 11 rows where bioproject = "PRJNA908278", tax_clade = "Metamonada" and tax

11 rows where bioproject = "PRJNA908278", tax_clade = "Metamonada" and tax_phylum = "Fornicata"

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_phylum	tax_order	tax_family	tax_genus	tax_species
26929485	26929485	PRJNA908278_P_NODE_19862_length_288_cov_1.623256_g19759_i0	PRJNA908278	19862	288	1.623256	4.67497728	Kipferlia bialata	797122	Fornicata	other_Eukaryota	122	1.25e-30	NR	GIQ81472.1	797122	g19759	i0	68.7	3.57291666666667	83	26	86.5	0	30	278	100	182	GIQ81472.1 hypothetical protein KIPB_002433 [Kipferlia bialata]	diamond	1029	122	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
27024318	27024318	PRJNA908278_P_NODE_13922_length_335_cov_1.755725_g13819_i0	PRJNA908278	13922	335	1.755725	5.88167875	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	47.8	0.00193	NR	XP_067766706.1	348837	g13819	i0	50	0.34029850746268703	38	19	34	0	283	170	60	97	XP_067766706.1 Cysteine-rich membrane protein 1 [Spironucleus salmonicida]	diamond	114	47.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
27316547	27316547	PRJNA908278_P_NODE_783_length_1139_cov_6.347092_g728_i0	PRJNA908278	783	1139	6.347092	72.29337788	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.3	6.98e-13	NR	CAK8746233.1	28002	g728	i0	85	0.316066725197542	40	6	10.5	0	1065	946	109	148	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	360	81.3	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27379783	27379783	PRJNA908278_P_NODE_31883_length_245_cov_0.895349_g31780_i0	PRJNA908278	31883	245	0.895349	2.19360505	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.1	8.18e-6	NR	ESU34781.1	5741	g31780	i0	44.1	3.31836734693878	59	29	67.3	2	70	234	323	381	ESU34781.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	813	53.5	0.992523364485981	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
27695589	27695589	PRJNA908278_P_NODE_13724_length_337_cov_1.458333_g13621_i0	PRJNA908278	13724	337	1.458333	4.91458221	Giardia	5740	Fornicata	other_Eukaryota	67	6.13e-11	NR	BAB58891.1	5741	g13621	i0	39.8	1.65578635014837	93	47	74.8	1	335	84	100	192	BAB58891.1 rab-like protein E, partial [Giardia intestinalis]	diamond	558	67.4	0.99406528189911	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
27758757	27758757	PRJNA908278_P_NODE_6504_length_462_cov_1.349614_g6401_i0	PRJNA908278	6504	462	1.349614	6.23521668	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	128	2.33e-32	NR	CAK8746233.1	28002	g6401	i0	53.9	1.5	115	47	74.7	1	345	1	49	157	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	693	128	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29842322	29842322	PRJNA908278_P_NODE_29351_length_248_cov_0.880000_g29248_i0	PRJNA908278	29351	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	46.2	0.00241	NR	ESU40688.1	5741	g29248	i0	38.8	2.35887096774194	49	27	59.3	1	152	6	665	710	ESU40688.1 Variant-specific surface protein [Giardia intestinalis]	diamond	585	46.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30150559	30150559	PRJNA908278_P_NODE_30192_length_247_cov_0.885057_g30089_i0	PRJNA908278	30192	247	0.885057	2.18609079	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	110	5.62e-26	NR	EFO65558.1	658858	g30089	i0	64.2	1.96761133603239	81	29	98.4	0	3	245	772	852	EFO65558.1 Leucyl-tRNA synthetase [Giardia lamblia P15]	diamond	486	110	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30593048	30593048	PRJNA908278_P_NODE_473_length_1335_cov_178.403328_g437_i0	PRJNA908278	473	1335	178.403328	2381.6844288	Giardia intestinalis	5741	Fornicata	other_Eukaryota	62	4.99e-6	NR	XP_001709261.2	5741	g437	i0	32.7	0.934831460674157	208	90	35.5	8	1085	612	35	242	XP_001709261.2 VSP [Giardia intestinalis]	diamond	1248	62	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30751149	30751149	PRJNA908278_P_NODE_18834_length_295_cov_1.297297_g18731_i0	PRJNA908278	18834	295	1.297297	3.82702615	Hexamita inflata	28002	Fornicata	other_Eukaryota	67	3.85e-11	NR	CAK8791373.1	28002	g18731	i0	42.9	1.54576271186441	77	39	78.3	3	232	2	1	72	CAK8791373.1 HINF_029868 [Hexamita inflata]	diamond	456	67	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
32616789	32616789	PRJNA908278_P_NODE_19180_length_292_cov_1.757991_g19077_i0	PRJNA908278	19180	292	1.757991	5.13333372	Giardia muris	5742	Fornicata	other_Eukaryota	60.5	3.52e-8	NR	TNJ28141.1	5742	g19077	i0	33.3	0.955479452054795	93	52	87.3	4	260	6	124	214	TNJ28141.1 High cysteine protein [Giardia muris]	diamond	279	60.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris

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