metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax_clade = "Metamonada"

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
12029968	12029968	PRJNA564013_P_NODE_309810_length_219_cov_4.158228_g306958_i0	PRJNA564013	309810	219	4.158228	9.10651932	root	1	Root_unresolved	Root_unresolved	73.2	4.89e-13	NR	TNJ26987.1	5742	g306958	i0	57.1	7.89041095890411	56	24	76.7	0	44	211	311	366	TNJ26987.1 Kinase, NEK [Giardia muris]	diamond	1728	73.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
26636004	26636004	PRJNA564013_P_NODE_211981_length_295_cov_2.213675_g209130_i0	PRJNA564013	211981	295	2.213675	6.53034125	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	67.8	1.11e-10	NR	KAJ5080693.1	1746090	g209130	i0	44.3	0.986440677966102	97	53	97.6	1	289	2	127	223	KAJ5080693.1 hypothetical protein M0811_13877 [Anaeramoeba ignava]	diamond	291	67.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27332335	27332335	PRJNA564013_P_NODE_56123_length_532_cov_9.375796_g53345_i0	PRJNA564013	56123	532	9.375796	49.87923472	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	105	1.43e-22	NR	KAJ5077882.1	1746090	g53345	i0	41	0.783834586466165	139	82	78.4	0	437	21	3	141	KAJ5077882.1 von willebrand factor a domain-containing protein 5a [Anaeramoeba ignava]	diamond	417	105	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27868780	27868780	PRJNA564013_P_NODE_282905_length_236_cov_9.960000_g280053_i0	PRJNA564013	282905	236	9.96	23.5056	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	43.1	0.0248	NR	XP_068366790.1	1144522	g280053	i0	42.9	0.622881355932203	49	27	62.3	1	198	52	495	542	XP_068366790.1 uncharacterized protein TRFO_16222 [Tritrichomonas foetus]	diamond	147	43.1	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30016193	30016193	PRJNA564013_P_NODE_359271_length_192_cov_3.083969_g356419_i0	PRJNA564013	359271	192	3.083969	5.92122048	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	58.5	1.97e-8	NR	XP_001317232.1	412133	g356419	i0	70	0.625	40	12	62.5	0	17	136	116	155	XP_001317232.1 GTPase, Ras family, Rab subfamily [Trichomonas vaginalis G3]	diamond	120	58.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30693312	30693312	PRJNA564013_P_NODE_134913_length_366_cov_5.567213_g132065_i0	PRJNA564013	134913	366	5.567213	20.37599958	Oxymonadida	66288	Root_unresolved	Root_unresolved	73.6	2.49e-12	NR	KAJ3432654.1	1746091	g132065	i0	35.8	3.22950819672131	109	66	86.9	2	356	39	1236	1343	KAJ3432654.1 c2 calcium-dependent membrane targeting [Anaeramoeba flamelloides]	diamond	1182	73.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31659309	31659309	PRJNA564013_P_NODE_202517_length_304_cov_1.604938_g199666_i0	PRJNA564013	202517	304	1.604938	4.87901152	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	62.8	5.81e-9	NR	KAJ6248922.1	1746091	g199666	i0	44.4	3.48355263157895	90	49	88.8	1	302	33	240	328	KAJ6248922.1 tigger transposable element-derived protein [Anaeramoeba flamelloides]	diamond	1059	62.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31849224	31849224	PRJNA564013_P_NODE_183157_length_322_cov_2.796935_g180307_i0	PRJNA564013	183157	322	2.796935	9.0061307	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	49.3	4.15e-4	NR	KAA6372077.1	222440	g180307	i0	32.3	0.866459627329193	93	50	86.6	1	311	33	45	124	KAA6372077.1 MAG: hypothetical protein EZS28_032396, partial [Streblomastix strix]	diamond	279	49.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32387198	32387198	PRJNA564013_P_NODE_9079_length_1140_cov_22.165894_g7499_i0	PRJNA564013	9079	1140	22.165894	252.6911916	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	67.8	3.96e-8	NR	XP_067776970.1	135588	g7499	i0	49.3	0.363157894736842	69	28	18.2	2	800	594	119	180	XP_067776970.1 DEAD/DEAH box helicase family protein [Histomonas meleagridis]	diamond	414	67.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis

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