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

30 rows where bioproject = "PRJNA1088503" 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
194536	194536	PRJNA1088503_P_NODE_10661_length_174_cov_2.241379_g10289_i0	PRJNA1088503	10661	174	2.241379	3.89999946	Cloacibacterium caeni	2004710	Bacteria	Bacteria	305	1.02e-78	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g10289	i0	98.276	2	174	3	100	0	1	174	692669	692496	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	348	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
1469065	1469065	PRJNA1088503_P_NODE_10022_length_190_cov_133.273292_g9650_i0	PRJNA1088503	10022	190	133.273292	253.2192548	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	287	4.11e-73	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g9650	i0	98.182	1.73684210526316	165	2	87	1	1	165	959004	958841	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	330	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
1469105	1469105	PRJNA1088503_P_NODE_4602_length_393_cov_28123.673077_g4239_i0	PRJNA1088503	4602	393	28123.673077	110526.03519261	Chryseobacterium oryzae	2929799	Bacteria	Bacteria	584	2.999999999999999e-162	NTclustered	gi\|2216362202\|gb\|CP094529.1\|	2929799	g4239	i0	97.647	10.4554707379135	340	8	87	0	19	358	1038673	1038334	Chryseobacterium oryzae strain ADR-1 chromosome, complete genome	blastn	4109	584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium oryzae
4021176	4021176	PRJNA1088503_P_NODE_8704_length_224_cov_48352.687179_g8332_i0	PRJNA1088503	8704	224	48352.687179	108310.01928096	Cloacibacterium normanense	237258	Bacteria	Bacteria	289	1.39e-73	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g8332	i0	93.782	3.41517857142857	193	10	85	2	34	224	2641985	2641793	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	765	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
5297343	5297343	PRJNA1088503_P_NODE_8665_length_225_cov_54136.341837_g8293_i0	PRJNA1088503	8665	225	54136.341837	121806.76913325	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	78.7	3.3e-10	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g8293	i0	94.231	0.231111111111111	52	2	23	1	10	61	2317831	2317881	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	52	78.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
6572355	6572355	PRJNA1088503_P_NODE_10086_length_188_cov_117.622642_g9714_i0	PRJNA1088503	10086	188	117.622642	221.13056696	Cloacibacterium normanense	237258	Bacteria	Bacteria	287	4.06e-73	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g9714	i0	98.765	3.4468085106383	162	1	86	1	27	188	866702	866542	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	648	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
9945694	9945694	PRJNA1088503_P_NODE_9568_length_202_cov_35483.375723_g9196_i0	PRJNA1088503	9568	202	35483.375723	71676.41896046	Cloacibacterium	501783	Bacteria	Bacteria	265	2.08e-66	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g9196	i0	94.253	4.74257425742574	174	9	86	1	30	202	2648692	2648519	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	958	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
12948204	12948204	PRJNA1088503_P_NODE_5251_length_354_cov_32514.449231_g4879_i0	PRJNA1088503	5251	354	32514.449231	115101.15027774	Cloacibacterium normanense	237258	Bacteria	Bacteria	551	2.709999999999999e-152	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g4879	i0	97.523	3.65536723163842	323	7	91	1	33	354	2251347	2251669	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1294	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14223227	14223227	PRJNA1088503_P_NODE_10712_length_172_cov_1780.937063_g10340_i0	PRJNA1088503	10712	172	1780.937063	3063.21174836	Cloacibacterium normanense	237258	Bacteria	Bacteria	250	4.7699999999999995e-62	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g10340	i0	97.931	2.52325581395349	145	2	84	1	1	144	853255	853399	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	434	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14223230	14223230	PRJNA1088503_P_NODE_1292_length_797_cov_11461.386719_g1142_i0	PRJNA1088503	1292	797	11461.386719	91347.25215043	Flavobacterium eburneipallidum	3003263	Bacteria	Bacteria	575	3.839999999999999e-159	NTclustered	gi\|2493280413\|gb\|CP114291.2\|	3003263	g1142	i0	83.654	2.43789209535759	624	89	77	10	42	657	2393869	2393251	Flavobacterium eburneipallidum strain IMCC36793 chromosome, complete genome	blastn	1943	575	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium eburneipallidum
14223243	14223243	PRJNA1088503_P_NODE_2812_length_541_cov_18135.347656_g2525_i0	PRJNA1088503	2812	541	18135.347656	98112.23081896	Cloacibacterium caeni	2004710	Bacteria	Bacteria	872	0	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g2525	i0	97.642	7.71349353049908	509	11	94	1	34	541	1492225	1492733	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	4173	872	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
16771533	16771533	PRJNA1088503_P_NODE_7594_length_259_cov_38237.052174_g7222_i0	PRJNA1088503	7594	259	38237.052174	99033.96513066	Cloacibacterium caeni	2004710	Bacteria	Bacteria	359	1.24e-94	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g7222	i0	95.536	2.54826254826255	224	10	86	0	3	226	2586549	2586772	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	660	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
21419521	21419521	PRJNA1088503_P_NODE_10017_length_190_cov_1494.652174_g9645_i0	PRJNA1088503	10017	190	1494.652174	2839.8391306	Flavobacterium	237	Bacteria	Bacteria	243	9.02e-60	NTclustered	gi\|2447257787\|gb\|CP092822.1\|	1454066	g9645	i0	92.814	86.7789473684211	167	12	88	0	24	190	1590636	1590802	Flavobacterium sp. WW92 chromosome, complete genome	blastn	16488	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WW92
23146694	23146694	PRJNA1088503_P_NODE_7919_length_248_cov_40178.863014_g7547_i0	PRJNA1088503	7919	248	40178.863014	99643.58027472	Cloacibacterium caeni	2004710	Bacteria	Bacteria	220	5.81e-53	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g7547	i0	98.4	2.4758064516129	125	2	50	0	34	158	468645	468521	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	614	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
23146702	23146702	PRJNA1088503_P_NODE_8879_length_219_cov_159.900000_g8507_i0	PRJNA1088503	8879	219	159.9	350.181	Cloacibacterium caeni	2004710	Bacteria	Bacteria	246	8.28e-61	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g8507	i0	91.209	3.74429223744292	182	14	88	2	28	208	728566	728746	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	820	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
24420328	24420328	PRJNA1088503_P_NODE_11080_length_164_cov_867.377778_g10708_i0	PRJNA1088503	11080	164	867.377778	1422.49955592	Cloacibacterium caeni	2004710	Bacteria	Bacteria	244	2.1e-60	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g10708	i0	99.259	0.823170731707317	135	1	82	0	29	163	2450541	2450407	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	135	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
24420392	24420392	PRJNA1088503_P_NODE_7280_length_269_cov_45358.891667_g6908_i0	PRJNA1088503	7280	269	45358.891667	122015.41858423	Cloacibacterium caeni	2004710	Bacteria	Bacteria	411	3.529999999999999e-110	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6908	i0	98.291	2.60966542750929	234	4	87	0	3	236	1279513	1279280	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	702	411	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
27478323	27478323	PRJNA1088503_P_NODE_10943_length_167_cov_2.471014_g10571_i0	PRJNA1088503	10943	167	2.471014	4.12659338	Bacteroidia bacterium	2044936	Bacteria	Bacteria	108	1.53e-26	NR	MFP5439710.1	2044936	g10571	i0	87.3	0.988023952095808	55	7	98.8	0	3	167	170	224	MFP5439710.1 WD40/YVTN/BNR-like repeat-containing protein [Bacteroidia bacterium]	diamond	165	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
27510023	27510023	PRJNA1088503_P_NODE_9203_length_211_cov_58517.571429_g8831_i0	PRJNA1088503	9203	211	58517.571429	123472.07571519	Chryseobacterium sp.	1871047	Bacteria	Bacteria	76.6	2.55e-14	NR	MBO6200460.1	1871047	g8831	i0	88.6	1.25118483412322	44	5	62.6	0	80	211	26	69	MBO6200460.1 preprotein translocase subunit SecA [Chryseobacterium sp.]	diamond	264	76.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
28109666	28109666	PRJNA1088503_P_NODE_5205_length_357_cov_2.012195_g4833_i0	PRJNA1088503	5205	357	2.012195	7.18353615	Sphingobacterium alkalisoli	1874115	Bacteria	Bacteria	92.4	5.46e-19	NR	WP_188876220.1	1874115	g4833	i0	79.3	0.487394957983193	58	12	48.7	0	355	182	1190	1247	WP_188876220.1 hypothetical protein [Sphingobacterium alkalisoli]	diamond	174	92.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium alkalisoli
28267510	28267510	PRJNA1088503_P_NODE_9706_length_198_cov_56410.307692_g9334_i0	PRJNA1088503	9706	198	56410.307692	111692.40923016	Flavobacterium kayseriense	2764714	Bacteria	Bacteria	92.8	4.350000000000001e-21	NR	WP_187011251.1	2764714	g9334	i0	94.2	0.787878787878788	52	3	78.8	0	11	166	2	53	WP_187011251.1 Rossmann-like and DUF2520 domain-containing protein [Flavobacterium kayseriense]	diamond	156	92.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium kayseriense
28615070	28615070	PRJNA1088503_P_NODE_7067_length_276_cov_43638.716599_g6695_i0	PRJNA1088503	7067	276	43638.716599	120442.85781324	Flavobacterium yafengii	3041253	Bacteria	Bacteria	151	3.96e-40	NR	WP_282731570.1	3041253	g6695	i0	93.8	2.64130434782609	81	5	88	0	276	34	395	475	WP_282731570.1 TonB-dependent receptor [Flavobacterium yafengii]	diamond	729	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium yafengii
28709881	28709881	PRJNA1088503_P_NODE_10927_length_167_cov_1858.666667_g10555_i0	PRJNA1088503	10927	167	1858.666667	3103.97333389	Cloacibacterium normanense	237258	Bacteria	Bacteria	90.5	1.98e-19	NR	WP_104794462.1	237258	g10555	i0	97.8	0.826347305389222	46	1	82.6	0	140	3	868	913	WP_104794462.1 hypothetical protein [Cloacibacterium normanense]	diamond	138	90.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
29341301	29341301	PRJNA1088503_P_NODE_11529_length_155_cov_1.634921_g11157_i0	PRJNA1088503	11529	155	1.634921	2.53412755	Flavobacterium rivuli	498301	Bacteria	Bacteria	93.6	3.0600000000000003e-21	NR	WP_035641797.1	498301	g11157	i0	88	2.92258064516129	50	6	96.8	0	1	150	135	184	WP_035641797.1 glycoside hydrolase family 43 protein [Flavobacterium rivuli]	diamond	453	93.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium rivuli
29909723	29909723	PRJNA1088503_P_NODE_1891_length_669_cov_15001.240625_g1679_i0	PRJNA1088503	1891	669	15001.240625	100358.29978125	Flavobacterium sp.	239	Bacteria	Bacteria	408	2.5e-142	NR	MDO8316601.1	239	g1679	i0	94.9	0.959641255605381	214	11	96	0	644	3	43	256	MDO8316601.1 hypothetical protein [Flavobacterium sp.]	diamond	642	408	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30889046	30889046	PRJNA1088503_P_NODE_10714_length_172_cov_830.958042_g10342_i0	PRJNA1088503	10714	172	830.958042	1429.24783224	Cloacibacterium sp.	1913682	Bacteria	Bacteria	60.1	2.1e-9	NR	WP_374361274.1	1913682	g10342	i0	96.6	0.505813953488372	29	1	50.6	0	114	28	30	58	WP_374361274.1 lipocalin family protein [Cloacibacterium sp.]	diamond	87	60.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium sp.
30983980	30983980	PRJNA1088503_P_NODE_7714_length_255_cov_1159.473451_g7342_i0	PRJNA1088503	7714	255	1159.473451	2956.65730005	Cloacibacterium sp.	1913682	Bacteria	Bacteria	60.1	1.3e-9	NR	MBP8085460.1	1913682	g7342	i0	86.7	0.352941176470588	30	4	35.3	0	210	121	40	69	MBP8085460.1 hypothetical protein [Cloacibacterium sp.]	diamond	90	60.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium sp.
31394878	31394878	PRJNA1088503_P_NODE_11256_length_160_cov_2.351145_g10884_i0	PRJNA1088503	11256	160	2.351145	3.761832	Flavobacterium turcicum	2764718	Bacteria	Bacteria	108	4.65e-26	NR	WP_166137769.1	2764718	g10884	i0	98.1	0.975	52	1	97.5	0	3	158	100	151	WP_166137769.1 MauE/DoxX family redox-associated membrane protein [Flavobacterium turcicum]	diamond	156	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium turcicum
31458138	31458138	PRJNA1088503_P_NODE_11816_length_150_cov_1.454545_g11444_i0	PRJNA1088503	11816	150	1.454545	2.1818175	Sphingobacteriaceae bacterium	2021370	Bacteria	Bacteria	92	8.2e-21	NR	MDF3077677.1	2021370	g11444	i0	88	3	50	6	100	0	150	1	136	185	MDF3077677.1 exo-alpha-sialidase [Sphingobacteriaceae bacterium]	diamond	450	92	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae		Sphingobacteriaceae bacterium
31647603	31647603	PRJNA1088503_P_NODE_8777_length_222_cov_1223.761658_g8405_i0	PRJNA1088503	8777	222	1223.761658	2716.75088076	Segatella salivae	228604	Bacteria	Bacteria	71.2	1.11e-14	NR	MBF1530192.1	228604	g8405	i0	100	0.486486486486487	36	0	48.6	0	31	138	1	36	MBF1530192.1 thioredoxin [Segatella salivae]	diamond	108	71.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella salivae

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