metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJDB3785" and tax

12 rows where analysis = "diamond", bioproject = "PRJDB3785" 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
7660994	7660994	PRJDB3785_S_NODE_11607_length_224_cov_1.137143_g11454_i0	PRJDB3785	11607	224	1.137143	2.54720032	root	1	Root_unresolved	Root_unresolved	137	1.97e-39	NR	XP_001322019.1	412133	g11454	i0	83.8	15.8571428571429	74	12	99.1	0	2	223	61	134	XP_001322019.1 peptidyl-prolyl cis-trans isomerase protein [Trichomonas vaginalis G3]	diamond	3552	137	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
26874562	26874562	PRJDB3785_S_NODE_8821_length_254_cov_1.141463_g8668_i0	PRJDB3785	8821	254	1.141463	2.89931602	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	50.8	5.81e-5	NR	KAJ3437795.1	1746091	g8668	i0	52.2	1.87795275590551	46	22	54.3	0	254	117	201	246	KAJ3437795.1 lipase [Anaeramoeba flamelloides]	diamond	477	50.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
27121047	27121047	PRJDB3785_S_NODE_4522_length_357_cov_7.269481_g4369_i0	PRJDB3785	4522	357	7.269481	25.95204717	root	1	Root_unresolved	Root_unresolved	114	2.17e-30	NR	KAA6379614.1	222440	g4369	i0	58.1	3.07563025210084	93	39	78.2	0	345	67	1	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1098	114	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
27380311	27380311	PRJDB3785_S_NODE_15923_length_196_cov_0.945578_g15770_i0	PRJDB3785	15923	196	0.945578	1.85333288	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	45.4	0.00184	NR	KAJ3426652.1	1746091	g15770	i0	45.7	0.704081632653061	46	24	70.4	1	168	31	1	45	KAJ3426652.1 elongation factor 1-beta [Anaeramoeba flamelloides]	diamond	138	45.4	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
27632812	27632812	PRJDB3785_S_NODE_7904_length_267_cov_1.389908_g7751_i0	PRJDB3785	7904	267	1.389908	3.71105436	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	68.9	1.35e-11	NR	KAA6375409.1	222440	g7751	i0	50.8	0.730337078651685	65	31	73	1	261	67	9	72	KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix]	diamond	195	68.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
27790706	27790706	PRJDB3785_S_NODE_15124_length_200_cov_1.013245_g14971_i0	PRJDB3785	15124	200	1.013245	2.02649	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	54.7	1.23e-6	NR	KAJ3436513.1	1746091	g14971	i0	56	0.75	50	22	75	0	50	199	5	54	KAJ3436513.1 protein kinase shaggy-related [Anaeramoeba flamelloides]	diamond	150	54.7	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28264024	28264024	PRJDB3785_S_NODE_12986_length_213_cov_1.243902_g12833_i0	PRJDB3785	12986	213	1.243902	2.64951126	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	50.1	6.62e-5	NR	KAJ5078494.1	1746090	g12833	i0	38.1	3.54929577464789	63	34	88.7	2	2	190	1816	1873	KAJ5078494.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava]	diamond	756	50.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28327188	28327188	PRJDB3785_S_NODE_13266_length_211_cov_1.320988_g13113_i0	PRJDB3785	13266	211	1.320988	2.78728468	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	75.5	6.6e-14	NR	KAJ3439022.1	1746091	g13113	i0	51.6	0.909952606635071	64	31	91	0	207	16	347	410	KAJ3439022.1 nucleic acid binding protein [Anaeramoeba flamelloides]	diamond	192	75.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28643248	28643248	PRJDB3785_S_NODE_12327_length_218_cov_1.633136_g12174_i0	PRJDB3785	12327	218	1.633136	3.56023648	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	73.9	4.57e-14	NR	KAJ3432919.1	1746091	g12174	i0	66	8.02293577981651	53	18	72.9	0	3	161	130	182	KAJ3432919.1 40S ribosomal protein S5 [Anaeramoeba flamelloides]	diamond	1749	73.9	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28643262	28643262	PRJDB3785_S_NODE_22487_length_169_cov_1.100000_g22334_i0	PRJDB3785	22487	169	1.1	1.859	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	91.3	2.2400000000000003e-21	NR	KAA6402130.1	222440	g22334	i0	73.2	0.994082840236686	56	15	99.4	0	169	2	92	147	KAA6402130.1 MAG: putative Box H/ACA snoRNP component [Streblomastix strix]	diamond	168	91.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28895556	28895556	PRJDB3785_S_NODE_24528_length_165_cov_0.879310_g24375_i0	PRJDB3785	24528	165	0.87931	1.4508615	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	53.1	2.7e-6	NR	EFO62295.1	658858	g24375	i0	43.8	0.872727272727273	48	23	87.3	1	145	2	394	437	EFO62295.1 VSP [Giardia lamblia P15]	diamond	144	53.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31137983	31137983	PRJDB3785_S_NODE_12155_length_219_cov_4.335294_g12002_i0	PRJDB3785	12155	219	4.335294	9.49429386	Hexamita inflata	28002	Fornicata	other_Eukaryota	86.7	1.14e-20	NR	CAK8746335.1	28002	g12002	i0	72.2	1.47945205479452	54	14	74	1	7	168	1	53	CAK8746335.1 HINF_020184 [Hexamita inflata]	diamond	324	86.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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