metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_clade = "FCB group"

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
10539555	10539555	PRJNA1233317_S_NODE_7889_length_274_cov_1.702326_g7853_i0	PRJNA1233317	7889	274	1.702326	4.66437324	Pedobacter sp. ASV28	2795123	Bacteria	Bacteria	190	5.84e-60	NR	WP_199121307.1	2795123	g7853	i0	100	0.996350364963504	91	0	99.6	0	273	1	27	117	WP_199121307.1 DUF2911 domain-containing protein [Pedobacter sp. ASV28]	diamond	273	190	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. ASV28
15638639	15638639	PRJNA1233317_S_NODE_8193_length_269_cov_5.809524_g8157_i0	PRJNA1233317	8193	269	5.809524	15.62761956	Pedobacter sp.	1411316	Bacteria	Bacteria	163	3.1e-47	NR	WP_308849909.1	1411316	g8157	i0	95.2	0.936802973977695	84	4	93.7	0	252	1	183	266	WP_308849909.1 thiamine-phosphate kinase [Pedobacter sp.]	diamond	252	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp.
26756051	26756051	PRJNA1233317_S_NODE_10761_length_237_cov_4.112360_g10725_i0	PRJNA1233317	10761	237	4.11236	9.7462932	Flavobacterium supellecticarium	2565924	Bacteria	Bacteria	151	1.78e-40	NR	WP_136401836.1	2565924	g10725	i0	98.7	0.987341772151899	78	1	98.7	0	235	2	49	126	WP_136401836.1 efflux RND transporter permease subunit [Flavobacterium supellecticarium]	diamond	234	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium supellecticarium
26883095	26883095	PRJNA1233317_S_NODE_3521_length_348_cov_3.806228_g3485_i0	PRJNA1233317	3521	348	3.806228	13.24567344	Prevotella sp. CAG:1	59823	Bacteria	Bacteria	228	5.319999999999999e-72	NR	CCZ11782.1	1262919	g3485	i0	99.1	0.991379310344828	115	1	99.1	0	3	347	200	314	CCZ11782.1 putative uncharacterized protein [Prevotella sp. CAG:1092]	diamond	345	228	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. CAG:1092
27736471	27736471	PRJNA1233317_S_NODE_7724_length_276_cov_3.898618_g7688_i0	PRJNA1233317	7724	276	3.898618	10.76018568	Xylanibacter ruminicola	839	Bacteria	Bacteria	174	4.34e-53	NR	MBE6265512.1	839	g7688	i0	98.9	0.989130434782609	91	1	98.9	0	3	275	95	185	MBE6265512.1 hypothetical protein [Xylanibacter ruminicola]	diamond	273	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Xylanibacter	Xylanibacter ruminicola
27767949	27767949	PRJNA1233317_S_NODE_13524_length_210_cov_2.019868_g13488_i0	PRJNA1233317	13524	210	2.019868	4.2417228	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	41.2	0.0311	NR	WP_078678899.1	1756149	g13488	i0	45.8	0.685714285714286	48	23	68.6	2	63	206	56	100	WP_078678899.1 hypothetical protein [Elizabethkingia bruuniana]	diamond	144	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
29914978	29914978	PRJNA1233317_S_NODE_2291_length_382_cov_1.879257_g2255_i0	PRJNA1233317	2291	382	1.879257	7.17876174	Pedobacter sp. ASV28	2795123	Bacteria	Bacteria	142	5.98e-37	NR	WP_199117342.1	2795123	g2255	i0	97.4	0.596858638743455	76	2	59.7	0	234	7	1	76	WP_199117342.1 beta-N-acetylhexosaminidase [Pedobacter sp. ASV28]	diamond	228	142	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. ASV28
29996880	29996880	PRJNA1233317_S_NODE_10751_length_237_cov_5.634831_g10715_i0	PRJNA1233317	10751	237	5.634831	13.35454947	Bacteroidales	171549	Bacteria	Bacteria	99.4	2.47e-24	NR	WP_036910796.1	171552	g10715	i0	86.8	2.67088607594937	53	7	67.1	0	160	2	1	53	WP_036910796.1 MULTISPECIES: RNA polymerase sigma factor [Prevotellaceae]	diamond	633	99.8	0.995991983967936	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae
30799313	30799313	PRJNA1233317_S_NODE_15654_length_194_cov_2.096296_g15618_i0	PRJNA1233317	15654	194	2.096296	4.06681424	Prevotella histicola JCM 15637 = DNF	470565	Bacteria	Bacteria	42.4	0.00571	NR	KGF27978.1	1236504	g15618	i0	45.8	0.742268041237113	48	24	74.2	1	144	1	6	51	KGF27978.1 hypothetical protein HMPREF2132_04570 [Prevotella histicola JCM 15637 = DNF00424]	diamond	144	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella histicola
30926055	30926055	PRJNA1233317_S_NODE_2234_length_383_cov_5.688272_g2198_i0	PRJNA1233317	2234	383	5.688272	21.78608176	Hoylesella pleuritidis	407975	Bacteria	Bacteria	246	1.44e-75	NR	WP_273176660.1	407975	g2198	i0	96.9	1.98955613577023	127	4	99.5	0	382	2	30	156	WP_273176660.1 family 20 glycosylhydrolase [Hoylesella pleuritidis]	diamond	762	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella pleuritidis
31956340	31956340	PRJNA1233317_S_NODE_3677_length_344_cov_5.143860_g3641_i0	PRJNA1233317	3677	344	5.14386	17.6948784	Prevotellaceae	171552	Bacteria	Bacteria	55.5	3.62e-6	NR	WP_315380410.1	840	g3641	i0	78.1	1.09011627906977	32	7	27.9	0	240	145	310	341	WP_315380410.1 radical SAM peptide maturase [Hoylesella loescheii]	diamond	375	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella loescheii
32209654	32209654	PRJNA1233317_S_NODE_4598_length_326_cov_5.636704_g4562_i0	PRJNA1233317	4598	326	5.636704	18.37565504	Bacteroides	816	Bacteria	Bacteria	182	9.49e-51	NR	WP_287827516.1	29523	g4562	i0	100	1.98773006134969	108	0	99.4	0	325	2	819	926	WP_287827516.1 efflux RND transporter permease subunit [Bacteroides sp.]	diamond	648	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
32317713	32317713	PRJNA1233317_S_NODE_11419_length_230_cov_2.140351_g11383_i0	PRJNA1233317	11419	230	2.140351	4.9228073	Cecembia rubra	1485585	Bacteria	Bacteria	157	3.98e-45	NR	WP_106568644.1	1485585	g11383	i0	100	0.991304347826087	76	0	99.1	0	230	3	112	187	WP_106568644.1 DUF4249 family protein [Cecembia rubra]	diamond	228	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia rubra

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