metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA734313" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA734313" 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
28883966	28883966	PRJNA734313_S_NODE_868_length_658_cov_15.122750_g780_i0	PRJNA734313	868	658	15.12275	99.507695	Chitinophagales bacterium	2448779	Bacteria	Bacteria	47	0.0365	NR	MFI5172965.1	2448779	g780	i0	21.5	0.78419452887538	172	126	75.7	4	541	44	328	496	MFI5172965.1 RecQ family ATP-dependent DNA helicase [Chitinophagales bacterium]	diamond	516	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
29304655	29304655	PRJNA734313_S_NODE_37349_length_155_cov_2.240741_g37236_i0	PRJNA734313	37349	155	2.240741	3.47314855	FCB group	1783270	Bacteria	Bacteria	71.2	4.31e-13	NR	WP_024990718.1	77768	g37236	i0	64.4	1.74193548387097	45	16	87.1	0	1	135	196	240	WP_024990718.1 glycine rich domain-containing protein [Segatella albensis]	diamond	270	71.6	0.994413407821229	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella albensis
29399390	29399390	PRJNA734313_S_NODE_35909_length_158_cov_2.207207_g35796_i0	PRJNA734313	35909	158	2.207207	3.48738706	Bacteria	2	Bacteria	Bacteria	47	3.72e-4	NR	MBN8827410.1	2035813	g35796	i0	45.1	4.51898734177215	51	28	96.8	0	155	3	364	414	MBN8827410.1 ankyrin repeat domain-containing protein [Sphingobacteriia bacterium]	diamond	714	47.4	0.991561181434599	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia				Sphingobacteriia bacterium
29578441	29578441	PRJNA734313_S_NODE_14610_length_246_cov_1.633166_g14497_i0	PRJNA734313	14610	246	1.633166	4.01758836	Alistipes shahii	328814	Bacteria	Bacteria	64.3	8.35e-10	NR	WP_229104358.1	328814	g14497	i0	50.7	0.817073170731707	67	32	81.7	1	225	25	179	244	WP_229104358.1 leucine-rich repeat protein, partial [Alistipes shahii]	diamond	201	64.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes shahii
30905621	30905621	PRJNA734313_S_NODE_574_length_745_cov_15.302292_g517_i0	PRJNA734313	574	745	15.302292	114.0020754	Bacteroidota bacterium	1898104	Bacteria	Bacteria	327	5.25e-109	NR	MCX6230815.1	1898104	g517	i0	69.2	2.86711409395973	237	72	95.4	1	3	713	90	325	MCX6230815.1 adenosine kinase [Bacteroidota bacterium]	diamond	2136	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32075512	32075512	PRJNA734313_S_NODE_23258_length_193_cov_1.397260_g23145_i0	PRJNA734313	23258	193	1.39726	2.6967118	Bacteroidia bacterium	2044936	Bacteria	Bacteria	44.3	0.00556	NR	MCU0432561.1	2044936	g23145	i0	71.4	0.932642487046632	28	8	43.5	0	178	95	46	73	MCU0432561.1 ankyrin repeat domain-containing protein [Bacteroidia bacterium]	diamond	180	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia 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);;