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

11 rows where bioproject = "PRJNA312615", 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
13131587	13131587	PRJNA312615_P_NODE_15771_length_310_cov_1.134100_g15620_i0	PRJNA312615	15771	310	1.1341	3.51571	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.029	NTclustered	gi\|2794961975\|ref\|XM_067867602.1\|	2049356	g15620	i0	100	0.0903225806451613	28	0	9	0	240	267	6243	6216	Monocercomonoides exilis uncharacterized protein (MONOS_14772), mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27264028	27264028	PRJNA312615_P_NODE_41243_length_191_cov_0.922535_g41092_i0	PRJNA312615	41243	191	0.922535	1.76204185	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	65.5	4.3e-11	NR	XP_001323614.1	412133	g41092	i0	52.5	1.91623036649215	61	28	94.2	1	186	7	91	151	XP_001323614.1 GTPase protein [Trichomonas vaginalis G3]	diamond	366	65.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27800935	27800935	PRJNA312615_P_NODE_4264_length_575_cov_23.418251_g4121_i0	PRJNA312615	4264	575	23.418251	134.65494325	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	199	1.68e-61	NR	XP_068360038.1	1144522	g4121	i0	57.2	6.39652173913043	173	74	90.3	0	547	29	5	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	3678	199	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
27895431	27895431	PRJNA312615_P_NODE_42345_length_188_cov_1.438849_g42194_i0	PRJNA312615	42345	188	1.438849	2.70503612	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	63.9	5.9e-10	NR	KAA6403940.1	222440	g42194	i0	50	4.54787234042553	52	26	83	0	175	20	189	240	KAA6403940.1 MAG: putative Exonuclease 1 [Streblomastix strix]	diamond	855	63.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28084881	28084881	PRJNA312615_P_NODE_1005_length_986_cov_4.974386_g912_i0	PRJNA312615	1005	986	4.974386	49.04744596	Giardia intestinalis	5741	Fornicata	other_Eukaryota	51.2	0.00381	NR	ESU43722.1	5741	g912	i0	28.6	0.511156186612576	168	93	48.1	5	891	418	4	154	ESU43722.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	504	51.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28810797	28810797	PRJNA312615_P_NODE_31728_length_217_cov_1.553571_g31577_i0	PRJNA312615	31728	217	1.553571	3.37124907	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	43.5	0.0145	NR	XP_001306049.1	412133	g31577	i0	41.4	1.58986175115207	70	40	95.4	1	10	216	134	203	XP_001306049.1 hypothetical protein TVAGG3_0774660 [Trichomonas vaginalis G3]	diamond	345	43.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
29176225	29176225	PRJNA312615_P_NODE_14489_length_322_cov_9.216117_g14338_i0	PRJNA312615	14489	322	9.216117	29.67589674	root	1	Root_unresolved	Root_unresolved	111	1.59e-29	NR	KAA6379614.1	222440	g14338	i0	58.2	3.34472049689441	91	38	84.8	0	319	47	3	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1077	111	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
31640402	31640402	PRJNA312615_P_NODE_33676_length_211_cov_1.259259_g33525_i0	PRJNA312615	33676	211	1.259259	2.65703649	root	1	Root_unresolved	Root_unresolved	44.7	0.00514	NR	KAJ3426907.1	1746091	g33525	i0	30.8	2.68720379146919	65	45	92.4	0	201	7	262	326	KAJ3426907.1 oxysterol-binding protein [Anaeramoeba flamelloides]	diamond	567	44.7	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31654335	31654335	PRJNA312615_P_NODE_36337_length_204_cov_0.987097_g36186_i0	PRJNA312615	36337	204	0.987097	2.01367788	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	67	6.16e-11	NR	KAJ6226472.1	1746091	g36186	i0	44.9	2.02941176470588	69	32	98.5	2	3	203	169	233	KAJ6226472.1 hypothetical protein M0813_10688 [Anaeramoeba flamelloides]	diamond	414	67	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
32697829	32697829	PRJNA312615_P_NODE_4840_length_545_cov_1.895161_g4694_i0	PRJNA312615	4840	545	1.895161	10.32862745	Hexamita inflata	28002	Fornicata	other_Eukaryota	90.5	2.33e-19	NR	CAK8791145.1	28002	g4694	i0	38.9	0.721100917431193	131	66	72.1	4	93	485	33	149	CAK8791145.1 HINF_096380 [Hexamita inflata]	diamond	393	90.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
32715446	32715446	PRJNA312615_P_NODE_47600_length_175_cov_1.007937_g47449_i0	PRJNA312615	47600	175	1.007937	1.76388975	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.3	0.00437	NR	CAB06038.1	5741	g47449	i0	51.7	4.61142857142857	58	21	90.9	3	16	174	173	228	CAB06038.1 variant-specific surface protein VSP4A1 [Giardia intestinalis]	diamond	807	44.7	0.991051454138702	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis

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