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

9 rows where bioproject = "PRJDB9741", 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
5113419	5113419	PRJDB9741_P_NODE_4765_length_293_cov_2.045082_g4449_i0	PRJDB9741	4765	293	2.045082	5.99209026	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	60.2	1.62e-4	NTclustered	gi\|2794965319\|ref\|XM_067866530.1\|	2049356	g4449	i0	97.143	0.238907849829352	35	1	12	0	259	293	258	224	Monocercomonoides exilis putative 40S ribosomal protein S26-1 (MONOS_13796), mRNA	blastn	70	60.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
26779400	26779400	PRJDB9741_P_NODE_18801_length_180_cov_1.503817_g18484_i0	PRJDB9741	18801	180	1.503817	2.7068706	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	63.9	3.67e-10	NR	KAJ3438019.1	1746091	g18484	i0	50	0.966666666666667	58	29	96.7	0	175	2	63	120	KAJ3438019.1 EXOSOME COMPLEX EXONUCLEASE RIBOSOMAL RNA PROCESSING PROTEIN [Anaeramoeba flamelloides]	diamond	174	63.9	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
26779408	26779408	PRJDB9741_P_NODE_4581_length_301_cov_2.674603_g4265_i0	PRJDB9741	4581	301	2.674603	8.05055503	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	92	8.5e-21	NR	XP_068360038.1	1144522	g4265	i0	50	3.78737541528239	94	47	93.7	0	298	17	84	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	1140	92	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28826429	28826429	PRJDB9741_P_NODE_37488_length_162_cov_0.902655_g37171_i0	PRJDB9741	37488	162	0.902655	1.4623011	root	1	Root_unresolved	Root_unresolved	63.2	7.54e-10	NR	BAC98826.1	63628	g37171	i0	63.3	3.85185185185185	49	18	90.7	0	14	160	134	182	BAC98826.1 enolase [Trichonympha agilis]	diamond	624	63.2	1	Eukaryota	Metamonada	Parabasalia	Trichonymphida	Trichonymphidae	Trichonympha	Trichonympha agilis
29053763	29053763	PRJDB9741_P_NODE_18428_length_181_cov_1.143939_g18111_i0	PRJDB9741	18428	181	1.143939	2.07052959	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	42	0.0312	NR	KAJ3425143.1	1746091	g18111	i0	38.8	0.812154696132597	49	25	72.9	1	180	49	37	85	KAJ3425143.1 tripartite motif-containing 59-related [Anaeramoeba flamelloides]	diamond	147	42	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31169722	31169722	PRJDB9741_P_NODE_10235_length_206_cov_1.299363_g9918_i0	PRJDB9741	10235	206	1.299363	2.67668778	Giardia intestinalis	5741	Fornicata	other_Eukaryota	46.6	9.83e-4	NR	ESU43468.1	5741	g9918	i0	39.7	0.91747572815534	63	30	90.3	2	16	201	313	368	ESU43468.1 Variant-specific surface protein [Giardia intestinalis]	diamond	189	46.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31290363	31290363	PRJDB9741_P_NODE_42475_length_154_cov_2.914286_g42158_i0	PRJDB9741	42475	154	2.914286	4.48800044	Hexamitidae	5739	Fornicata	other_Eukaryota	52.4	4.5e-7	NR	TNJ30202.1	5742	g42158	i0	57.9	1.4025974025974	38	16	74	0	114	1	6	43	TNJ30202.1 Ribosomal protein S21 [Giardia muris]	diamond	216	52.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
32087282	32087282	PRJDB9741_P_NODE_26638_length_168_cov_1.285714_g26321_i0	PRJDB9741	26638	168	1.285714	2.15999952	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	41.6	0.0326	NR	XP_068350105.1	1144522	g26321	i0	38	0.892857142857143	50	26	89.3	1	168	19	162	206	XP_068350105.1 Ras-related protein YPTC6 [Tritrichomonas foetus]	diamond	150	41.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
32807811	32807811	PRJDB9741_P_NODE_3740_length_344_cov_2.325424_g3424_i0	PRJDB9741	3740	344	2.325424	7.99945856	root	1	Root_unresolved	Root_unresolved	110	4.19e-29	NR	KAA6379614.1	222440	g3424	i0	57.1	4.63953488372093	91	39	79.4	0	339	67	3	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1596	110	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix

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