metadata: contig_metadata: 9 rows where bioproject = "PRJNA669701", tax_clade = "Metamonada" and tax

9 rows where bioproject = "PRJNA669701", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"

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
18487725	18487725	PRJNA669701_P_NODE_136515_length_242_cov_2.852071_g136120_i0	PRJNA669701	136515	242	2.852071	6.90201182	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.022	NTclustered	gi\|2794977061\|ref\|XM_067879212.1\|	2049356	g136120	i0	100	0.115702479338843	28	0	12	0	43	70	9132	9159	Monocercomonoides exilis putative Dual specificity phosphatase, catalytic domain (MONOS_8775), partial mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27776764	27776764	PRJNA669701_P_NODE_50584_length_338_cov_1.883019_g50189_i0	PRJNA669701	50584	338	1.883019	6.36460422	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	84	3.94e-16	NR	XP_067779001.1	135588	g50189	i0	52.9	0.603550295857988	68	32	60.4	0	232	29	707	774	XP_067779001.1 coatomer subunit beta'-2-like [Histomonas meleagridis]	diamond	204	84	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
28092274	28092274	PRJNA669701_P_NODE_104025_length_254_cov_2.685083_g103630_i0	PRJNA669701	104025	254	2.685083	6.82011082	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	43.1	0.0322	NR	KAJ3431368.1	1746091	g103630	i0	29.3	0.885826771653543	75	48	82.7	2	37	246	1457	1531	KAJ3431368.1 vps8 subunit of corvet complex [Anaeramoeba flamelloides]	diamond	225	43.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29323594	29323594	PRJNA669701_P_NODE_111469_length_250_cov_0.870056_g111074_i0	PRJNA669701	111469	250	0.870056	2.17514	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	80.9	1.52e-15	NR	KAJ3431672.1	1746091	g111074	i0	52	3.312	75	36	90	0	245	21	1050	1124	KAJ3431672.1 serine/threonine-protein kinase pkga-related [Anaeramoeba flamelloides]	diamond	828	80.9	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29733887	29733887	PRJNA669701_P_NODE_122990_length_246_cov_3.052023_g122595_i0	PRJNA669701	122990	246	3.052023	7.50797658	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	44.3	0.00292	NR	KAA6373859.1	222440	g122595	i0	33.3	2.21951219512195	60	40	73.2	0	22	201	41	100	KAA6373859.1 MAG: hypothetical protein EZS28_030614 [Streblomastix strix]	diamond	546	44.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30681692	30681692	PRJNA669701_P_NODE_106873_length_251_cov_2.595506_g106478_i0	PRJNA669701	106873	251	2.595506	6.51472006	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	77	3.89e-16	NR	KAJ5074286.1	1746090	g106478	i0	43.8	0.956175298804781	80	43	95.6	1	11	250	12	89	KAJ5074286.1 duf614 family protein-related [Anaeramoeba ignava]	diamond	240	77	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30681722	30681722	PRJNA669701_P_NODE_66193_length_303_cov_1.713043_g65798_i0	PRJNA669701	66193	303	1.713043	5.19052029	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	77.4	4.8e-15	NR	XP_067771402.1	135588	g65798	i0	39.6	2.72277227722772	101	58	97	1	302	9	80	180	XP_067771402.1 small GTP-binding protein [Histomonas meleagridis]	diamond	825	77.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
31073187	31073187	PRJNA669701_P_NODE_108135_length_251_cov_0.865169_g107740_i0	PRJNA669701	108135	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	107	2.9299999999999993e-28	NR	KAA6379614.1	222440	g107740	i0	59	3.90836653386454	83	34	99.2	0	249	1	7	89	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	981	107	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
31155553	31155553	PRJNA669701_P_NODE_83675_length_277_cov_2.642157_g83280_i0	PRJNA669701	83675	277	2.642157	7.31877489	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	60.8	2.18e-8	NR	XP_067760658.1	348837	g83280	i0	50	1.42960288808664	66	32	70.4	1	2	196	277	342	XP_067760658.1 Mitogen-activated protein kinase [Spironucleus salmonicida]	diamond	396	60.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida

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