metadata: contig_metadata: 30 rows where bioproject = "PRJNA1233317" and tax

30 rows where bioproject = "PRJNA1233317" 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
335606	335606	PRJNA1233317_S_NODE_12661_length_218_cov_1.150943_g12625_i0	PRJNA1233317	12661	218	1.150943	2.50905574	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	303	4.82e-78	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g12625	i0	95.288	0.876146788990826	191	9	88	0	26	216	2483786	2483976	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	191	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
2886493	2886493	PRJNA1233317_S_NODE_10383_length_241_cov_4.840659_g10347_i0	PRJNA1233317	10383	241	4.840659	11.66598819	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g10347	i0	97.51	1.95850622406639	241	6	100	0	1	241	830232	830472	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	472	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
2886561	2886561	PRJNA1233317_S_NODE_4163_length_334_cov_4.760000_g4127_i0	PRJNA1233317	4163	334	4.76	15.8984	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	562	1.18e-155	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g4127	i0	97.561	3.75149700598802	328	8	98	0	1	328	3206719	3206392	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	1253	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
6150008	6150008	PRJNA1233317_S_NODE_7405_length_281_cov_2.459459_g7369_i0	PRJNA1233317	7405	281	2.459459	6.91107979	Flavobacterium	237	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|1608347023\|gb\|MK757666.1\|	239	g7369	i0	100	116.007117437722	281	0	100	0	1	281	1207	927	Flavobacterium sp. strain 816OP8 16S ribosomal RNA gene, partial sequence	blastn	32598	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
7989067	7989067	PRJNA1233317_S_NODE_3287_length_353_cov_4.561224_g3251_i0	PRJNA1233317	3287	353	4.561224	16.10112072	Sphingobacteriaceae bacterium GW460-11-11-14-LB5	1986952	Bacteria	Bacteria	440	6.099999999999998e-119	NTclustered	gi\|1195002891\|gb\|CP021237.1\|	1986952	g3251	i0	89.235	82.5155807365439	353	36	99	2	2	353	4242172	4242523	Sphingobacteriaceae bacterium GW460-11-11-14-LB5, complete genome	blastn	29128	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae		Sphingobacteriaceae bacterium GW460-11-11-14-LB5
9263750	9263750	PRJNA1233317_S_NODE_9628_length_250_cov_3.806283_g9592_i0	PRJNA1233317	9628	250	3.806283	9.5157075	Prevotella melaninogenica	28132	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2028867418\|gb\|CP072361.1\|	28132	g9592	i0	99.2	34.564	250	2	100	0	1	250	1508714	1508963	Prevotella melaninogenica strain F0054 chromosome 1, complete sequence	blastn	8641	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
10539459	10539459	PRJNA1233317_S_NODE_11189_length_232_cov_4.849711_g11153_i0	PRJNA1233317	11189	232	4.849711	11.25132952	Prevotella intermedia	28131	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1276670087\|gb\|CP024728.1\|	28131	g11153	i0	99.569	279.168103448276	232	1	100	0	1	232	274058	273827	Prevotella intermedia strain KCOM 1949 chromosome 2, complete sequence	blastn	64767	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
10539460	10539460	PRJNA1233317_S_NODE_11209_length_232_cov_3.526012_g11173_i0	PRJNA1233317	11209	232	3.526012	8.18034784	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	318	1.8499999999999998e-82	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g11173	i0	91.703	0.987068965517241	229	19	99	0	1	229	3210225	3210453	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	229	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
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
13089281	13089281	PRJNA1233317_S_NODE_15431_length_195_cov_4.647059_g15395_i0	PRJNA1233317	15431	195	4.647059	9.06176505	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	62.1	2.8e-5	NTclustered	gi\|2717309477\|emb\|OZ032149.1\|	336810	g15395	i0	97.222	0.184615384615385	36	1	18	0	107	142	226053	226088	Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1	blastn	36	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
14364671	14364671	PRJNA1233317_S_NODE_8952_length_259_cov_2.415000_g8916_i0	PRJNA1233317	8952	259	2.415	6.25485	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	425	1.21e-114	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g8916	i0	96.498	3.31274131274131	257	9	99	0	3	259	2949500	2949756	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	858	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
15638573	15638573	PRJNA1233317_S_NODE_2693_length_370_cov_3.829582_g2657_i0	PRJNA1233317	2693	370	3.829582	14.1694534	Capnocytophaga sputigena	1019	Bacteria	Bacteria	684	0	NTclustered	gi\|1242548571\|gb\|CP022379.1\|	1019	g2657	i0	100	4.99459459459459	370	0	100	0	1	370	342684	342315	Capnocytophaga sputigena strain D1179 chromosome, complete genome	blastn	1848	684	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
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.
16912750	16912750	PRJNA1233317_S_NODE_5374_length_312_cov_2.652174_g5338_i0	PRJNA1233317	5374	312	2.652174	8.27478288	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	529	1.1099999999999996e-145	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g5338	i0	99.654	88.3717948717949	289	1	93	0	24	312	972801	973089	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	27572	529	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
18187178	18187178	PRJNA1233317_S_NODE_2615_length_372_cov_7.099042_g2579_i0	PRJNA1233317	2615	372	7.099042	26.40843624	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g2579	i0	100	0.0806451612903226	30	0	8	0	293	322	1161409	1161438	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
18187223	18187223	PRJNA1233317_S_NODE_795_length_489_cov_6.816279_g759_i0	PRJNA1233317	795	489	6.816279	33.33160431	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	898	0	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g759	i0	99.796	479.01226993865	489	1	100	0	1	489	669937	670425	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	234237	898	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
19461652	19461652	PRJNA1233317_S_NODE_3956_length_338_cov_5.014337_g3920_i0	PRJNA1233317	3956	338	5.014337	16.94845906	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	584	2.539999999999999e-162	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g3920	i0	97.929	444.452662721893	338	6	100	1	1	338	516980	517316	Pedobacter sp. SL55 chromosome	blastn	150225	584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
24561802	24561802	PRJNA1233317_S_NODE_14300_length_203_cov_3.222222_g14264_i0	PRJNA1233317	14300	203	3.222222	6.54111066	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	326	9.44e-85	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g14264	i0	95.61	332.192118226601	205	6	100	3	1	203	517600	517803	Pedobacter sp. SL55 chromosome	blastn	67435	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
24561887	24561887	PRJNA1233317_S_NODE_9580_length_251_cov_1.906250_g9544_i0	PRJNA1233317	9580	251	1.90625	4.7846875	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	294	3.4200000000000003e-75	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g9544	i0	88.095	3.14342629482072	252	25	100	3	1	251	3760324	3760077	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	789	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
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);;