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

31 rows where analysis = "blastn", bioproject = "PRJNA781427" 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
760625	760625	PRJNA781427_P_NODE_41341_length_354_cov_3.590747_g40459_i0	PRJNA781427	41341	354	3.590747	12.71124438	Bacteroides faecium	2715212	Bacteria	Bacteria	416	1.03e-111	NTclustered	gi\|1828977791\|gb\|CP050831.1\|	2715212	g40459	i0	88.056	432.175141242938	360	31	100	12	1	354	2421533	2421180	Bacteroides faecium strain CBA7301 chromosome, complete genome	blastn	152990	416	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides faecium
762069	762069	PRJNA781427_P_NODE_97181_length_241_cov_0.875000_g96297_i0	PRJNA781427	97181	241	0.875	2.10875	Flavobacterium sp. N2270	2986831	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|2324023718\|gb\|CP110005.1\|	2986831	g96297	i0	96.68	6	241	8	100	0	1	241	1780029	1779789	Flavobacterium sp. N2270 chromosome, complete genome	blastn	1446	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2270
2036897	2036897	PRJNA781427_P_NODE_49962_length_319_cov_1.252033_g49079_i0	PRJNA781427	49962	319	1.252033	3.99398527	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	496	1.15e-135	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g49079	i0	94.937	280.401253918495	316	16	99	0	4	319	4832801	4832486	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	89448	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
3313255	3313255	PRJNA781427_P_NODE_94083_length_242_cov_0.911243_g93199_i0	PRJNA781427	94083	242	0.911243	2.20520806	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g93199	i0	100	0.115702479338843	28	0	12	0	187	214	3730019	3729992	Hymenobacter sp. DG01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
3313336	3313336	PRJNA781427_P_NODE_97343_length_237_cov_2.731707_g96459_i0	PRJNA781427	97343	237	2.731707	6.47414559	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	82.4	2.71e-11	NTclustered	gi\|2919513563\|emb\|OZ238267.1\|	1871037	g96459	i0	94.34	0.949367088607595	53	3	22	0	178	230	2431960	2431908	MAG: Flavobacteriaceae bacterium isolate 09b6b137-068c-45fe-842c-bd307207bc05 genome assembly, chromosome: 1	blastn	225	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
3763630	3763630	PRJNA781427_P_NODE_61603_length_283_cov_1.100000_g60719_i0	PRJNA781427	61603	283	1.1	3.113	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	1.56e-4	NTclustered	gi\|2625661431\|gb\|CP139247.1\|	1004	g60719	i0	100	0.226148409893993	32	0	11	0	177	208	405243	405274	Chitinophaga sancti strain HSF-01 chromosome, complete genome	blastn	64	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sancti
4588491	4588491	PRJNA781427_P_NODE_24944_length_475_cov_1.422886_g24065_i0	PRJNA781427	24944	475	1.422886	6.7587085	Flavobacterium indicum	312277	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g24065	i0	100	0.0589473684210526	28	0	6	0	290	317	475784	475757	Flavobacterium indicum GPTSA100-9 complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
5040128	5040128	PRJNA781427_P_NODE_52884_length_309_cov_1.152542_g52001_i0	PRJNA781427	52884	309	1.152542	3.56135478	Sphingobacterium	28453	Bacteria	Bacteria	473	5.199999999999999e-129	NTclustered	gi\|2306435172\|gb\|CP094931.1\|	34087	g52001	i0	94.268	410.375404530744	314	11	99	5	3	309	228615	228302	Sphingobacterium faecium strain WB1 chromosome, complete genome	blastn	126806	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium faecium
5863562	5863562	PRJNA781427_P_NODE_22345_length_507_cov_2.341014_g21468_i0	PRJNA781427	22345	507	2.341014	11.86894098	Phocaeicola paurosaccharolyticus	732242	Bacteria	Bacteria	893	0	NTclustered	gi\|1371569451\|gb\|MG428882.1\|	732242	g21468	i0	98.422	99.8481262327416	507	8	100	0	1	507	221	727	Bacteroides paurosaccharolyticus strain H_90 16S ribosomal RNA gene, partial sequence	blastn	50623	893	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola paurosaccharolyticus
5865177	5865177	PRJNA781427_P_NODE_82505_length_247_cov_1.327586_g81621_i0	PRJNA781427	82505	247	1.327586	3.27913742	Adhaeribacter radiodurans	2745197	Bacteria	Bacteria	401	1.9199999999999992e-107	NTclustered	gi\|1885831791\|gb\|CP055153.1\|	2745197	g81621	i0	95.951	276.898785425101	247	10	100	0	1	247	2249767	2249521	Adhaeribacter radiodurans strain KUDC8001 chromosome, complete genome	blastn	68394	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter radiodurans
7139679	7139679	PRJNA781427_P_NODE_59686_length_288_cov_1.074419_g58802_i0	PRJNA781427	59686	288	1.074419	3.09432672	Runella rosea	2259595	Bacteria	Bacteria	494	3.68e-135	NTclustered	gi\|1430388288\|gb\|CP030850.1\|	2259595	g58802	i0	97.569	286.21875	288	7	100	0	1	288	4136465	4136752	Runella rosea strain HYN0085 chromosome, complete genome	blastn	82431	494	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella rosea
7139850	7139850	PRJNA781427_P_NODE_66006_length_271_cov_2.393939_g65122_i0	PRJNA781427	66006	271	2.393939	6.48757469	Flavobacterium channae	2897181	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g65122	i0	100	691.911439114391	271	0	100	0	1	271	487274	487544	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	187508	501	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
8414840	8414840	PRJNA781427_P_NODE_85087_length_246_cov_0.890173_g84203_i0	PRJNA781427	85087	246	0.890173	2.18982558	Weeksellaceae bacterium	2823802	Bacteria	Bacteria	296	9.3e-76	NTclustered	gi\|2488203225\|emb\|OX460916.1\|	2823802	g84203	i0	88.525	330.081300813008	244	28	99	0	3	246	4790	4547	Weeksellaceae bacterium strain MIP2422 genome assembly, chromosome: MIP2422_c1	blastn	81200	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium
9688800	9688800	PRJNA781427_P_NODE_3008_length_1615_cov_1.822309_g2717_i0	PRJNA781427	3008	1615	1.822309	29.43029035	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	54.7	0.046	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g2717	i0	100	0.0179566563467492	29	0	2	0	1410	1438	2565353	2565381	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
9689699	9689699	PRJNA781427_P_NODE_64788_length_275_cov_1.059406_g63904_i0	PRJNA781427	64788	275	1.059406	2.9133665	Allomuricauda sp. R78024	3093867	Bacteria	Bacteria	479	9.78e-131	NTclustered	gi\|2845100162\|gb\|CP138995.1\|	3093867	g63904	i0	98.182	1.69818181818182	275	4	100	1	1	275	3704544	3704271	Allomuricauda sp. R78024 chromosome, complete genome	blastn	467	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Allomuricauda	Allomuricauda sp. R78024
13515196	13515196	PRJNA781427_P_NODE_69611_length_262_cov_1.439153_g68727_i0	PRJNA781427	69611	262	1.439153	3.77058086	Allomuricauda sp. R78024	3093867	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|2845100162\|gb\|CP138995.1\|	3093867	g68727	i0	100	41.9274809160305	262	0	100	0	1	262	1516752	1516491	Allomuricauda sp. R78024 chromosome, complete genome	blastn	10985	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Allomuricauda	Allomuricauda sp. R78024
14789261	14789261	PRJNA781427_P_NODE_42792_length_348_cov_1.094545_g41910_i0	PRJNA781427	42792	348	1.094545	3.8090166	Dyadobacter sandarakinus	2747268	Bacteria	Bacteria	473	5.94e-129	NTclustered	gi\|1986777041\|gb\|CP056775.1\|	2747268	g41910	i0	91.379	285.304597701149	348	27	99	3	1	347	868294	868639	Dyadobacter sandarakinus strain Q3-56 chromosome, complete genome	blastn	99286	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sandarakinus
16064008	16064008	PRJNA781427_P_NODE_74913_length_251_cov_0.865169_g74029_i0	PRJNA781427	74913	251	0.865169	2.17157419	uncultured Acetobacteroides sp.	1760811	Bacteria	Bacteria	191	4.62e-44	NTclustered	gi\|2621786297\|emb\|OY782755.1\|	1760811	g74029	i0	83.099	16.1115537848606	213	33	84	3	5	216	1541593	1541383	MAG: uncultured Acetobacteroides sp. isolate 434020b9-23a9-4dd8-b579-1c311cde560b genome assembly, chromosome: 1	blastn	4044	191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Acetobacteroides	uncultured Acetobacteroides sp.
17339301	17339301	PRJNA781427_P_NODE_58414_length_291_cov_1.412844_g57530_i0	PRJNA781427	58414	291	1.412844	4.11137604	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	472	1.75e-128	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g57530	i0	96.194	263.725085910653	289	9	99	2	1	289	4832388	4832102	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	76744	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
17340088	17340088	PRJNA781427_P_NODE_89874_length_244_cov_0.900585_g88990_i0	PRJNA781427	89874	244	0.900585	2.1974274	Balneola sp.	2024824	Bacteria	Bacteria	130	9.88e-26	NTclustered	gi\|2021960826\|gb\|CP051255.1\|	2024824	g88990	i0	88.288	0.454918032786885	111	10	45	3	1	110	2815125	2815233	MAG: Balneola sp. isolate EhC07 chromosome	blastn	111	130	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
18612996	18612996	PRJNA781427_P_NODE_69695_length_262_cov_1.222222_g68811_i0	PRJNA781427	69695	262	1.222222	3.20222164	Balneola sp.	2024824	Bacteria	Bacteria	174	4.8899999999999997e-39	NTclustered	gi\|2021960826\|gb\|CP051255.1\|	2024824	g68811	i0	78.764	0.988549618320611	259	55	99	0	3	261	3666580	3666838	MAG: Balneola sp. isolate EhC07 chromosome	blastn	259	174	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
19887851	19887851	PRJNA781427_P_NODE_54856_length_302_cov_1.397380_g53973_i0	PRJNA781427	54856	302	1.39738	4.2200876	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	501	2.32e-137	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g53973	i0	96.7	260.5	303	7	100	2	1	302	2237631	2237331	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	78671	501	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19887934	19887934	PRJNA781427_P_NODE_57936_length_293_cov_0.959091_g57052_i0	PRJNA781427	57936	293	0.959091	2.81013663	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	446	1.07e-120	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g57052	i0	94.218	76.3378839590444	294	14	100	2	1	293	172749	172458	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	22367	446	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19888235	19888235	PRJNA781427_P_NODE_69876_length_261_cov_2.271277_g68992_i0	PRJNA781427	69876	261	2.271277	5.92803297	Segatella copri	165179	Bacteria	Bacteria	477	3.3099999999999986e-130	NTclustered	gi\|2784148841\|gb\|CP156891.1\|	165179	g68992	i0	99.617	298.766283524904	261	1	100	0	1	261	2511061	2510801	Segatella copri strain HDC01 chromosome 1	blastn	77978	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
19888721	19888721	PRJNA781427_P_NODE_89256_length_244_cov_0.900585_g88372_i0	PRJNA781427	89256	244	0.900585	2.1974274	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	385	1.91e-102	NTclustered	gi\|2647208394\|gb\|CP141191.1\|	259	g88372	i0	95.082	3	244	12	100	0	1	244	1057638	1057881	Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome	blastn	732	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
19888781	19888781	PRJNA781427_P_NODE_91876_length_243_cov_0.905882_g90992_i0	PRJNA781427	91876	243	0.905882	2.20129326	Tenacibaculum polynesiense	3137857	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2733082284\|emb\|OZ040189.1\|	3137857	g90992	i0	96.97	0.135802469135802	33	1	14	0	14	46	3182425	3182393	Tenacibaculum sp. 190130A14a isolate ena-SAMPLE-TAB-13-05-2024-13:56:06:370-140306 genome assembly, chromosome: T190130A14A	blastn	33	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum polynesiense
21163827	21163827	PRJNA781427_P_NODE_65657_length_272_cov_2.020101_g64773_i0	PRJNA781427	65657	272	2.020101	5.49467472	Pontibacter sp.	1895908	Bacteria	Bacteria	470	5.81e-128	NTclustered	gi\|1878348171\|gb\|MT795756.1\|	1895908	g64773	i0	97.794	101.404411764706	272	6	100	0	1	272	452	181	Pontibacter sp. strain BT310 16S ribosomal RNA gene, partial sequence	blastn	27582	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter sp.
21164565	21164565	PRJNA781427_P_NODE_94137_length_242_cov_0.911243_g93253_i0	PRJNA781427	94137	242	0.911243	2.20520806	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	147	9.72e-31	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g93253	i0	96.591	21.5206611570248	88	3	36	0	155	242	1549492	1549579	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	5208	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
21614131	21614131	PRJNA781427_P_NODE_64497_length_275_cov_2.891089_g63613_i0	PRJNA781427	64497	275	2.891089	7.95049475	Parabacteroides	375288	Bacteria	Bacteria	357	4.78e-94	NTclustered	gi\|2032883667\|gb\|CP072229.1\|	46503	g63613	i0	90.182	392.861818181818	275	25	99	2	1	274	36067	36340	Parabacteroides merdae strain CL06T03C08 chromosome, complete genome	blastn	108037	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides merdae
22439015	22439015	PRJNA781427_P_NODE_81538_length_248_cov_0.880000_g80654_i0	PRJNA781427	81538	248	0.88	2.1824	Psychroserpens ponticola	2932268	Bacteria	Bacteria	359	1.18e-94	NTclustered	gi\|2441525218\|gb\|CP116221.1\|	2932268	g80654	i0	92.742	49.133064516129	248	18	100	0	1	248	84864	85111	Psychroserpens ponticola strain MSW6 chromosome, complete genome	blastn	12185	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroserpens	Psychroserpens ponticola
24988351	24988351	PRJNA781427_P_NODE_90080_length_244_cov_0.900585_g89196_i0	PRJNA781427	90080	244	0.900585	2.1974274	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g89196	i0	100	0.118852459016393	29	0	12	0	135	163	3864587	3864559	Flavobacterium sp. TR2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2

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