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

9 rows where analysis = "diamond", bioproject = "PRJNA719595" and tax_phylum = "Gemmatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
12188798	12188798	PRJNA719595_P_NODE_9330_length_242_cov_0.923077_g9295_i0	PRJNA719595	9330	242	0.923077	2.23384634	FCB group	1783270	Bacteria	Bacteria	100	1.27e-22	NR	HEV8400734.1	2448054	g9295	i0	66.7	4.52479338842975	72	24	89.3	0	23	238	558	629	HEV8400734.1 GNAT family N-acetyltransferase [Gemmatimonadales bacterium]	diamond	1095	101	0.99009900990099	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
13463202	13463202	PRJNA719595_P_NODE_7351_length_250_cov_0.881356_g7316_i0	PRJNA719595	7351	250	0.881356	2.20339	FCB group	1783270	Bacteria	Bacteria	106	1.53e-27	NR	MBA3585577.1	2026742	g7316	i0	92	3.6	50	4	60	0	101	250	1	50	MBA3585577.1 alpha/beta hydrolase [Gemmatimonadota bacterium]	diamond	900	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
19836427	19836427	PRJNA719595_P_NODE_8856_length_244_cov_0.912281_g8821_i0	PRJNA719595	8856	244	0.912281	2.22596564	Pseudogemmatithrix	3237678	Bacteria	Bacteria	91.7	1.63e-19	NR	MCC7003936.1	2026741	g8821	i0	77.8	3.95901639344262	54	12	66.4	0	83	244	1	54	MCC7003936.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Gemmatimonadaceae bacterium]	diamond	966	92.4	0.992424242424242	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28504778	28504778	PRJNA719595_P_NODE_6587_length_253_cov_0.866667_g6552_i0	PRJNA719595	6587	253	0.866667	2.19266751	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	99.8	1.75e-22	NR	HSK20400.1	2910168	g6552	i0	65	1.92094861660079	80	28	94.9	0	253	14	301	380	HSK20400.1 mechanosensitive ion channel family protein [Longimicrobiales bacterium]	diamond	486	99.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
28767798	28767798	PRJNA719595_P_NODE_8507_length_246_cov_0.901734_g8472_i0	PRJNA719595	8507	246	0.901734	2.21826564	Roseisolibacter	2093335	Bacteria	Bacteria	113	6.61e-27	NR	WP_284351320.1	2014610	g8472	i0	63.8	2.95121951219512	80	29	97.6	0	240	1	88	167	WP_284351320.1 ABC transporter permease [Roseisolibacter agri]	diamond	726	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
28978553	28978553	PRJNA719595_P_NODE_7788_length_248_cov_0.891429_g7753_i0	PRJNA719595	7788	248	0.891429	2.21074392	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	148	3.46e-39	NR	HEX4682909.1	2026741	g7753	i0	87.8	2.9758064516129	82	10	99.2	0	246	1	852	933	HEX4682909.1 PDZ domain-containing protein [Gemmatimonadaceae bacterium]	diamond	738	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30431615	30431615	PRJNA719595_P_NODE_6833_length_252_cov_0.871508_g6798_i0	PRJNA719595	6833	252	0.871508	2.19620016	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	173	6.23e-50	NR	HVQ47397.1	2448054	g6798	i0	100	24	84	0	100	0	252	1	152	235	HVQ47397.1 serine/threonine-protein kinase [Gemmatimonadales bacterium]	diamond	6048	173	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30747197	30747197	PRJNA719595_P_NODE_8494_length_246_cov_0.901734_g8459_i0	PRJNA719595	8494	246	0.901734	2.21826564	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	85.9	7.07e-18	NR	MDQ3997310.1	2026742	g8459	i0	58.4	0.939024390243902	77	31	93.9	1	232	2	2	77	MDQ3997310.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	231	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30999979	30999979	PRJNA719595_P_NODE_8234_length_247_cov_0.896552_g8199_i0	PRJNA719595	8234	247	0.896552	2.21448344	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	84.7	6.57e-17	NR	HUP88371.1	2910168	g8199	i0	51.9	1.97975708502024	81	39	98.4	0	247	5	252	332	HUP88371.1 hypothetical protein [Longimicrobiales bacterium]	diamond	489	84.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium

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