metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA752572" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA752572" 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
2004613	2004613	PRJNA752572_P_NODE_155602_length_214_cov_2.480447_g155095_i0	PRJNA752572	155602	214	2.480447	5.30815658	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	364	2.129999999999999e-96	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g155095	i0	97.642	326.957943925234	212	5	99	0	3	214	956769	956558	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	69969	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
2004653	2004653	PRJNA752572_P_NODE_252902_length_168_cov_0.992481_g252395_i0	PRJNA752572	252902	168	0.992481	1.66736808	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	148	1.75e-31	NTclustered	gi\|1958116195\|gb\|CP065012.1\|	1869212	g252395	i0	82.635	9.55952380952381	167	29	99	0	2	168	1553617	1553451	MAG: Chitinophagaceae bacterium isolate Rand_18-Q3-R56-63_BAT3C.147_cln chromosome, complete genome	blastn	1606	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
2004655	2004655	PRJNA752572_P_NODE_257122_length_167_cov_1.000000_g256615_i0	PRJNA752572	257122	167	1	1.67	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	128	2.26e-25	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g256615	i0	80.838	1	167	28	99	4	3	167	30168	30332	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	167	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.
2476746	2476746	PRJNA752572_P_NODE_4422_length_1113_cov_4.832096_g4207_i0	PRJNA752572	4422	1113	4.832096	53.78122848	Prevotella	838	Bacteria	Bacteria	1967	0	NTclustered	gi\|2028843725\|gb\|CP072339.1\|	28133	g4207	i0	98.562	215.238993710692	1113	16	100	0	1	1113	434951	433839	Prevotella nigrescens strain F0109 chromosome 1, complete sequence	blastn	239561	1967	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
4556991	4556991	PRJNA752572_P_NODE_205864_length_185_cov_2.026667_g205357_i0	PRJNA752572	205864	185	2.026667	3.74933395	Barnesiella sp. An22	1965590	Bacteria	Bacteria	150	5.45e-32	NTclustered	gi\|2729058714\|emb\|OZ007014.1\|	1965590	g205357	i0	81.967	191.054054054054	183	27	99	5	3	185	2353092	2352916	MAG: Barnesiella sp. An22 isolate 6737_HOM_CTRL_s26.ctg000031c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	35345	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Barnesiella	Barnesiella sp. An22
5832175	5832175	PRJNA752572_P_NODE_220565_length_178_cov_3.146853_g220058_i0	PRJNA752572	220565	178	3.146853	5.60139834	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g220058	i0	99.438	53.7359550561798	178	1	100	0	1	178	55497	55674	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	9565	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
5832189	5832189	PRJNA752572_P_NODE_249505_length_169_cov_0.985075_g248998_i0	PRJNA752572	249505	169	0.985075	1.66477675	Sphingobacterium sp. PCS056	2931400	Bacteria	Bacteria	110	8.26e-20	NTclustered	gi\|2235334485\|gb\|CP096883.1\|	2931400	g248998	i0	83.193	4.72189349112426	119	20	70	0	36	154	1394219	1394101	Sphingobacterium sp. PCS056 chromosome, complete genome	blastn	798	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. PCS056
7107310	7107310	PRJNA752572_P_NODE_249946_length_169_cov_0.985075_g249439_i0	PRJNA752572	249946	169	0.985075	1.66477675	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	213	6.12e-51	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g249439	i0	89.349	2	169	18	100	0	1	169	1560869	1561037	Lacibacter sp. MH-610 chromosome	blastn	338	213	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
7107317	7107317	PRJNA752572_P_NODE_265446_length_165_cov_1.015385_g264939_i0	PRJNA752572	265446	165	1.015385	1.67538525	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	182	1.6899999999999996e-41	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g264939	i0	89.041	4.83636363636364	146	16	88	0	1	146	1500345	1500490	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	798	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
7107360	7107360	PRJNA752572_P_NODE_92466_length_281_cov_4.077236_g91959_i0	PRJNA752572	92466	281	4.077236	11.45703316	Prevotella nigrescens	28133	Bacteria	Bacteria	503	5.95e-138	NTclustered	gi\|2028840811\|gb\|CP072335.1\|	28133	g91959	i0	98.932	211.256227758007	281	3	100	0	1	281	96295	96015	Prevotella nigrescens strain F0630 chromosome 1, complete sequence	blastn	59363	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
7579322	7579322	PRJNA752572_P_NODE_44986_length_407_cov_9.026882_g44481_i0	PRJNA752572	44986	407	9.026882	36.73940974	Weeksellaceae	2762318	Bacteria	Bacteria	606	6.649999999999998e-169	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g44481	i0	93.612	455.594594594595	407	25	100	1	1	407	131274	131679	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	185427	606	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8381900	8381900	PRJNA752572_P_NODE_246727_length_169_cov_3.701493_g246220_i0	PRJNA752572	246727	169	3.701493	6.25552317	uncultured Hymenobacter sp.	170016	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|307564364\|gb\|HM241115.1\|	170016	g246220	i0	99.408	103.822485207101	169	1	100	0	1	169	331	163	Uncultured Hymenobacter sp. clone LIM57 16S ribosomal RNA gene, partial sequence	blastn	17546	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	uncultured Hymenobacter sp.
8854381	8854381	PRJNA752572_P_NODE_139727_length_226_cov_5.125654_g139220_i0	PRJNA752572	139727	226	5.125654	11.58397804	Weeksellaceae	2762318	Bacteria	Bacteria	375	1.05e-99	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g139220	i0	96.903	504.929203539823	226	3	100	3	1	226	2944475	2944696	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	114114	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
9657147	9657147	PRJNA752572_P_NODE_75668_length_312_cov_11.895307_g75161_i0	PRJNA752572	75668	312	11.895307	37.11335784	Adhaeribacter swui	2086471	Bacteria	Bacteria	532	8.549999999999998e-147	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g75161	i0	97.436	368.602564102564	312	8	100	0	1	312	94378	94067	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	115004	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
9657159	9657159	PRJNA752572_P_NODE_93268_length_280_cov_2.885714_g92761_i0	PRJNA752572	93268	280	2.885714	8.0799992	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	418	2.21e-112	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g92761	i0	93.863	256.378571428571	277	17	99	0	4	280	2977890	2977614	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	71786	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
10932581	10932581	PRJNA752572_P_NODE_14929_length_686_cov_3.772657_g14528_i0	PRJNA752572	14929	686	3.772657	25.88042702	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	907	0	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g14528	i0	91.667	464.058309037901	660	47	96	5	28	685	955322	954669	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	318344	907	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
13482425	13482425	PRJNA752572_P_NODE_162051_length_210_cov_1.508571_g161544_i0	PRJNA752572	162051	210	1.508571	3.1679991	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	255	1.31e-63	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g161544	i0	88.571	1	210	24	100	0	1	210	1553603	1553812	Lacibacter sp. MH-610 chromosome	blastn	210	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
14757534	14757534	PRJNA752572_P_NODE_39252_length_436_cov_9.152120_g38748_i0	PRJNA752572	39252	436	9.15212	39.9032432	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	621	2.5599999999999996e-173	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g38748	i0	92.431	346.646788990826	436	32	100	1	1	436	788356	788790	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	151138	621	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
16031197	16031197	PRJNA752572_P_NODE_230113_length_174_cov_2.489209_g229606_i0	PRJNA752572	230113	174	2.489209	4.33122366	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	139	1.09e-28	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g229606	i0	100	1.72413793103448	75	0	86	0	100	174	65942	65868	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	300	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
16031225	16031225	PRJNA752572_P_NODE_278253_length_161_cov_2.515873_g277746_i0	PRJNA752572	278253	161	2.515873	4.05055553	Segatella oris	28135	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g277746	i0	100	267.211180124224	161	0	100	0	1	161	440593	440753	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	43021	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
16031256	16031256	PRJNA752572_P_NODE_58273_length_358_cov_2.034056_g57766_i0	PRJNA752572	58273	358	2.034056	7.28192048	Prevotella multiformis	282402	Bacteria	Bacteria	521	2.15e-143	NTclustered	gi\|2028862730\|gb\|CP072357.1\|	282402	g57766	i0	93.017	340.72905027933	358	24	100	1	1	358	979465	979821	Prevotella multiformis strain F0096 chromosome 1, complete sequence	blastn	121981	521	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella multiformis
17306699	17306699	PRJNA752572_P_NODE_226234_length_176_cov_1.468085_g225727_i0	PRJNA752572	226234	176	1.468085	2.5838296	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	274	2.9099999999999997e-69	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g225727	i0	95.349	524.971590909091	172	8	98	0	1	172	1234703	1234532	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	92395	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
21131160	21131160	PRJNA752572_P_NODE_18177_length_629_cov_9.941077_g17746_i0	PRJNA752572	18177	629	9.941077	62.52937433	Adhaeribacter swui	2086471	Bacteria	Bacteria	1064	0	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g17746	i0	97.297	312.205087440382	629	13	99	4	1	627	94460	95086	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	196377	1064	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
21131187	21131187	PRJNA752572_P_NODE_239117_length_172_cov_0.963504_g238610_i0	PRJNA752572	239117	172	0.963504	1.65722688	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	128	2.33e-25	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g238610	i0	80.982	0.947674418604651	163	29	94	2	11	172	332824	332663	Lacibacter sp. MH-610 chromosome	blastn	163	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
21131195	21131195	PRJNA752572_P_NODE_254997_length_167_cov_1.825758_g254490_i0	PRJNA752572	254997	167	1.825758	3.04901586	Flavobacterium soyae	2903098	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|2714450175\|gb\|CP150845.1\|	2903098	g254490	i0	97.006	555.011976047904	167	5	100	0	1	167	26244	26410	Flavobacterium soyae strain 55 chromosome, complete genome	blastn	92687	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium soyae
22406032	22406032	PRJNA752572_P_NODE_39838_length_433_cov_3.525126_g39333_i0	PRJNA752572	39838	433	3.525126	15.26379558	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	514	4.44e-141	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g39333	i0	88.372	363.577367205543	430	46	99	4	7	433	955390	955818	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	157429	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
22878956	22878956	PRJNA752572_P_NODE_169598_length_205_cov_1.694118_g169091_i0	PRJNA752572	169598	205	1.694118	3.4729419	Marivirga	869806	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2581937253\|dbj\|AP025329.1\|	1006	g169091	i0	100	0.273170731707317	28	0	14	0	29	56	1626913	1626940	Marivirga tractuosa NBRC 15989 DNA, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Marivirgaceae	Marivirga	Marivirga tractuosa
24955119	24955119	PRJNA752572_P_NODE_143420_length_223_cov_4.654255_g142913_i0	PRJNA752572	143420	223	4.654255	10.37898865	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	176	1.13e-39	NTclustered	gi\|374852692\|dbj\|AP011722.1\|	152509	g142913	i0	81.034	73.2645739910314	232	34	100	7	1	223	20195	19965	Uncultured Bacteroidetes bacterium DNA, fosmid clone: JFF029_C06	blastn	16338	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
24955201	24955201	PRJNA752572_P_NODE_74340_length_315_cov_6.821429_g73833_i0	PRJNA752572	74340	315	6.821429	21.48750135	Adhaeribacter radiodurans	2745197	Bacteria	Bacteria	496	1.1299999999999999e-135	NTclustered	gi\|1885831791\|gb\|CP055153.1\|	2745197	g73833	i0	95.765	360.860317460317	307	13	97	0	9	315	2249373	2249067	Adhaeribacter radiodurans strain KUDC8001 chromosome, complete genome	blastn	113671	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter radiodurans
25428008	25428008	PRJNA752572_P_NODE_13360_length_721_cov_4.731778_g12976_i0	PRJNA752572	13360	721	4.731778	34.11611938	Fluviicola	332102	Bacteria	Bacteria	1146	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g12976	i0	95.304	422.427184466019	724	30	100	3	1	721	1135	1857	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	304570	1146	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
25428027	25428027	PRJNA752572_P_NODE_60460_length_351_cov_2.629747_g59953_i0	PRJNA752572	60460	351	2.629747	9.23041197	Cloacibacterium	501783	Bacteria	Bacteria	610	4.359999999999999e-170	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g59953	i0	98.006	471.680911680912	351	7	100	0	1	351	130469	130819	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	165560	616	0.99025974025974	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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