metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB4632" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB4632" and tax_phylum = "Bacteroidota"

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
24287395	24287395	PRJEB4632_P_NODE_860_length_247_cov_0.885057_g822_i0	PRJEB4632	860	247	0.885057	2.18609079	Sphingobacteriia bacterium	2035813	Bacteria	Bacteria	162	2.8899999999999996e-47	NR	MBN8837246.1	2035813	g822	i0	100	0.995951417004049	82	0	99.6	0	1	246	79	160	MBN8837246.1 nitronate monooxygenase [Sphingobacteriia bacterium]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia				Sphingobacteriia bacterium
28226711	28226711	PRJEB4632_P_NODE_786_length_250_cov_0.870056_g748_i0	PRJEB4632	786	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	119	9.68e-33	NR	MBK9285026.1	2021370	g748	i0	63.9	3.984	83	30	99.6	0	249	1	18	100	MBK9285026.1 hypothetical protein [Sphingobacteriaceae bacterium]	diamond	996	120	0.991666666666667	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae		Sphingobacteriaceae bacterium
29212649	29212649	PRJEB4632_P_NODE_789_length_250_cov_0.870056_g751_i0	PRJEB4632	789	250	0.870056	2.17514	Bacteroidota bacterium	1898104	Bacteria	Bacteria	98.6	3.96e-24	NR	MBS1650605.1	1898104	g751	i0	83.1	0.708	59	10	70.8	0	178	2	1	59	MBS1650605.1 DoxX family protein [Bacteroidota bacterium]	diamond	177	98.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29275458	29275458	PRJEB4632_P_NODE_829_length_248_cov_0.880000_g791_i0	PRJEB4632	829	248	0.88	2.1824	Ferruginibacter sp.	1940288	Bacteria	Bacteria	62.8	7.01e-10	NR	HRD43728.1	1940288	g791	i0	38.3	1.93548387096774	81	47	98	1	244	2	88	165	HRD43728.1 hypothetical protein [Ferruginibacter sp.]	diamond	480	62.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
30002041	30002041	PRJEB4632_P_NODE_931_length_243_cov_0.905882_g893_i0	PRJEB4632	931	243	0.905882	2.20129326	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	115	1.2099999999999999e-27	NR	MET0634462.1	1869212	g893	i0	76.8	1.01234567901235	82	18	100	1	1	243	215	296	MET0634462.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	246	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31866560	31866560	PRJEB4632_P_NODE_797_length_250_cov_0.870056_g759_i0	PRJEB4632	797	250	0.870056	2.17514	Bacteroidota bacterium	1898104	Bacteria	Bacteria	87.8	4.78e-19	NR	MEI6489353.1	1898104	g759	i0	61.8	0.816	68	25	80.4	1	5	205	89	156	MEI6489353.1 hypothetical protein [Bacteroidota bacterium]	diamond	204	87.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32563095	32563095	PRJEB4632_P_NODE_759_length_251_cov_0.865169_g721_i0	PRJEB4632	759	251	0.865169	2.17157419	Bacteroidota bacterium	1898104	Bacteria	Bacteria	144	1.02e-39	NR	MBS1637978.1	1898104	g721	i0	77.1	0.99203187250996006	83	19	99.2	0	251	3	198	280	MBS1637978.1 acyl-CoA reductase [Bacteroidota bacterium]	diamond	249	144	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32846168	32846168	PRJEB4632_P_NODE_940_length_243_cov_0.905882_g902_i0	PRJEB4632	940	243	0.905882	2.20129326	Sphingobacteriaceae bacterium	2021370	Bacteria	Bacteria	157	2.78e-47	NR	RYZ92345.1	2021370	g902	i0	100	0.950617283950617	77	0	95.1	0	7	237	61	137	RYZ92345.1 MAG: hypothetical protein EOP47_30425, partial [Sphingobacteriaceae bacterium]	diamond	231	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae		Sphingobacteriaceae 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);;