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

9 rows where analysis = "diamond", bioproject = "PRJNA971593" and tax_phylum = "Preaxostyla"

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
8597361	8597361	PRJNA971593_P_NODE_6207_length_488_cov_3.718072_g6059_i0	PRJNA971593	6207	488	3.718072	18.14419136	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	198	7.62e-62	NR	KAJ4460954.1	342808	g6059	i0	61.3	5.40368852459016	150	58	92.2	0	454	5	23	172	KAJ4460954.1 putative 40S ribosomal protein S11 [Paratrimastix pyriformis]	diamond	2637	198	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
14020145	14020145	PRJNA971593_P_NODE_5711_length_508_cov_5.443678_g5563_i0	PRJNA971593	5711	508	5.443678	27.65388424	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	85.9	1.69e-17	NR	KAA6370095.1	222440	g5563	i0	45.6	3.05314960629921	114	60	66.7	2	23	361	1	113	KAA6370095.1 MAG: hypothetical protein EZS28_034377 [Streblomastix strix]	diamond	1551	85.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
26810721	26810721	PRJNA971593_P_NODE_28441_length_242_cov_0.911243_g28292_i0	PRJNA971593	28441	242	0.911243	2.20520806	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	1.77e-32	NR	KAA6380283.1	222440	g28292	i0	76.3	12.8925619834711	80	19	99.2	0	2	241	72	151	KAA6380283.1 MAG: putative Casein kinase I [Streblomastix strix]	diamond	3120	130	0.992307692307692	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
29836359	29836359	PRJNA971593_P_NODE_311_length_1695_cov_9.017263_g254_i0	PRJNA971593	311	1695	9.017263	152.84260785	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	98.6	8.89e-18	NR	KAJ4461670.1	342808	g254	i0	22.8	0.692035398230089	391	273	67.6	11	1379	234	102	472	KAJ4461670.1 putative LBP/BPI/CETP family protein [Paratrimastix pyriformis]	diamond	1173	98.6	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29868036	29868036	PRJNA971593_P_NODE_14251_length_319_cov_0.939024_g14102_i0	PRJNA971593	14251	319	0.939024	2.99548656	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	85.1	3.83e-17	NR	KAJ4454700.1	342808	g14102	i0	52.2	0.846394984326019	90	40	83.7	2	269	3	11	98	KAJ4454700.1 putative Gamma-glutamyl hydrolase A [Paratrimastix pyriformis]	diamond	270	85.1	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31005419	31005419	PRJNA971593_P_NODE_13594_length_326_cov_3.043478_g13445_i0	PRJNA971593	13594	326	3.043478	9.92173828	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	113	2.8699999999999997e-30	NR	KAA6379614.1	222440	g13445	i0	58.1	5.80674846625767	93	39	85.6	0	325	47	1	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1893	113	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
31384879	31384879	PRJNA971593_P_NODE_15516_length_304_cov_1.333333_g15367_i0	PRJNA971593	15516	304	1.333333	4.05333232	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	110	2.45e-29	NR	KAA6379614.1	222440	g15367	i0	58.2	2.67434210526316	91	38	89.8	0	302	30	3	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	813	110	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
31954004	31954004	PRJNA971593_P_NODE_16697_length_291_cov_1.766055_g16548_i0	PRJNA971593	16697	291	1.766055	5.13922005	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	56.2	1.71e-7	NR	KAA6352702.1	222440	g16548	i0	34.4	0.989690721649485	96	59	97.9	2	289	5	27	119	KAA6352702.1 MAG: putative vesicle-associated membrane protein [Streblomastix strix]	diamond	288	56.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32239166	32239166	PRJNA971593_P_NODE_26638_length_245_cov_0.895349_g26489_i0	PRJNA971593	26638	245	0.895349	2.19360505	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	47.4	8.61e-4	NR	KAA6373569.1	222440	g26489	i0	38.2	1.86122448979592	76	45	93.1	2	15	242	198	271	KAA6373569.1 MAG: putative Replication protein A 70 kDa DNA-binding subunit, partial [Streblomastix strix]	diamond	456	47.4	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);;