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

9 rows where analysis = "diamond", bioproject = "PRJNA1047551" 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
16312261	16312261	PRJNA1047551_S_NODE_10613_length_164_cov_1.744186_g10486_i0	PRJNA1047551	10613	164	1.744186	2.86046504	Flavobacteriales	200644	Bacteria	Bacteria	80.5	6.1e-16	NR	WP_026715613.1	206041	g10486	i0	94.7	21.5487804878049	38	2	69.5	0	163	50	464	501	WP_026715613.1 aldehyde dehydrogenase family protein [Flavobacterium gelidilacus]	diamond	3534	80.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium gelidilacus
21851490	21851490	PRJNA1047551_S_NODE_4338_length_228_cov_1.880829_g4211_i0	PRJNA1047551	4338	228	1.880829	4.28829012	Epilithonimonas hominis	420404	Bacteria	Bacteria	160	7.67e-47	NR	WP_312752462.1	420404	g4211	i0	98.7	0.986842105263158	75	1	98.7	0	226	2	115	189	WP_312752462.1 GLPGLI family protein [Epilithonimonas hominis]	diamond	225	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas hominis
26623652	26623652	PRJNA1047551_S_NODE_2821_length_273_cov_8.890756_g2694_i0	PRJNA1047551	2821	273	8.890756	24.27176388	Plebeiobacterium marinum	2992111	Bacteria	Bacteria	74.7	2.84e-13	NR	WP_301198584.1	2992111	g2694	i0	76.7	7.12087912087912	43	10	47.3	0	15	143	432	474	WP_301198584.1 adenosylhomocysteinase [Plebeiobacterium marinum]	diamond	1944	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Plebeiibacterium	Plebeiibacterium marinum
26749962	26749962	PRJNA1047551_S_NODE_2461_length_290_cov_1.717647_g2334_i0	PRJNA1047551	2461	290	1.717647	4.9811763	Vicingaceae bacterium	2832346	Bacteria	Bacteria	84	1.82e-18	NR	GIV42731.1	2832346	g2334	i0	86.7	0.46551724137931	45	6	46.6	0	1	135	74	118	GIV42731.1 MAG: 50S ribosomal protein L18 [Vicingaceae bacterium]	diamond	135	84	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Vicingaceae		Vicingaceae bacterium
27224734	27224734	PRJNA1047551_S_NODE_2143_length_308_cov_3.205128_g2016_i0	PRJNA1047551	2143	308	3.205128	9.87179424	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	43.9	0.0121	NR	MDD7303957.1	2049047	g2016	i0	33.8	0.720779220779221	74	49	72.1	0	30	251	65	138	MDD7303957.1 transcriptional repressor [Prevotellaceae bacterium]	diamond	222	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
27319849	27319849	PRJNA1047551_S_NODE_4743_length_220_cov_2.513514_g4616_i0	PRJNA1047551	4743	220	2.513514	5.5297308	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.1	0.02	NR	MFA5301768.1	2030927	g4616	i0	36.7	0.818181818181818	60	36	79.1	1	31	204	71	130	MFA5301768.1 helix-turn-helix domain-containing protein [Bacteroidales bacterium]	diamond	180	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28669548	28669548	PRJNA1047551_S_NODE_8787_length_176_cov_1.446809_g8660_i0	PRJNA1047551	8787	176	1.446809	2.54638384	Pseudomonadati	3379134	Bacteria	Bacteria	85.5	8.39e-18	NR	WP_167898895.1	1647582	g8660	i0	72.4	13.7045454545455	58	16	98.9	0	175	2	35	92	WP_167898895.1 iron-containing alcohol dehydrogenase [Wenyingzhuangia aestuarii]	diamond	2412	85.9	0.9953434225844	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Wenyingzhuangia	Wenyingzhuangia aestuarii
29498368	29498368	PRJNA1047551_S_NODE_12630_length_154_cov_2.075630_g12503_i0	PRJNA1047551	12630	154	2.07563	3.1964702	Epilithonimonas hominis	420404	Bacteria	Bacteria	100	5.3e-24	NR	WP_312752462.1	420404	g12503	i0	100	0.993506493506494	51	0	99.4	0	153	1	55	105	WP_312752462.1 GLPGLI family protein [Epilithonimonas hominis]	diamond	153	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas hominis
31038548	31038548	PRJNA1047551_S_NODE_4595_length_223_cov_1.441489_g4468_i0	PRJNA1047551	4595	223	1.441489	3.21452047	Flavobacteriaceae	49546	Bacteria	Bacteria	110	4.3200000000000005e-27	NR	WP_371455778.1	283736	g4468	i0	67.1	5.77130044843049	73	23	98.2	1	2	220	106	177	WP_371455778.1 bifunctional methionine sulfoxide reductase B/A protein [Leeuwenhoekiella aequorea]	diamond	1287	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Leeuwenhoekiella	Leeuwenhoekiella aequorea

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