metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA285816" 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
371918	371918	PRJNA285816_S_NODE_14681_length_201_cov_1.901316_g14579_i0	PRJNA285816	14681	201	1.901316	3.82164516	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	311	2.61e-80	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g14579	i0	94.527	246.925373134328	201	11	100	0	1	201	2977890	2977690	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	49632	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
371922	371922	PRJNA285816_S_NODE_14921_length_200_cov_1.834437_g14819_i0	PRJNA285816	14921	200	1.834437	3.668874	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	364	1.96e-96	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g14819	i0	99.5	498.39	200	1	100	0	1	200	668861	669060	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	99678	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
1646753	1646753	PRJNA285816_S_NODE_18282_length_186_cov_1.525547_g18180_i0	PRJNA285816	18282	186	1.525547	2.83751742	Prevotella nigrescens	28133	Bacteria	Bacteria	305	1.11e-78	NTclustered	gi\|2028845652\|gb\|CP072341.1\|	702439	g18180	i0	96.237	209.069892473118	186	7	100	0	1	186	39969	39784	Prevotella nigrescens F0103 chromosome 1, complete sequence	blastn	38887	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
1646820	1646820	PRJNA285816_S_NODE_24942_length_168_cov_0.873950_g24840_i0	PRJNA285816	24942	168	0.87395	1.468236	Rufibacter radiotolerans	1379910	Bacteria	Bacteria	65.8	1.81e-6	NTclustered	gi\|887498678\|gb\|CP010777.1\|	1379910	g24840	i0	95.122	0.244047619047619	41	2	24	0	1	41	4756210	4756250	Rufibacter sp. DG31D, complete genome	blastn	41	65.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter radiotolerans
2334350	2334350	PRJNA285816_S_NODE_10522_length_226_cov_2.920904_g10420_i0	PRJNA285816	10522	226	2.920904	6.60124304	Weeksellaceae	2762318	Bacteria	Bacteria	401	1.7299999999999993e-107	NTclustered	gi\|2653363380\|gb\|CP142423.1\|	59733	g10420	i0	98.673	496.41592920354	226	3	100	0	1	226	1097571	1097346	Chryseobacterium scophthalmum strain JUb44 chromosome	blastn	112190	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
2334420	2334420	PRJNA285816_S_NODE_7062_length_265_cov_2.013889_g6960_i0	PRJNA285816	7062	265	2.013889	5.33680585	Sediminibacterium	504481	Bacteria	Bacteria	361	3.539999999999999e-95	NTclustered	gi\|2874254166\|emb\|OY970398.1\|	866510	g6960	i0	96.759	175.207547169811	216	7	82	0	1	216	3591075	3591290	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.c.2 genome assembly, chromosome: 1	blastn	46430	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
2922585	2922585	PRJNA285816_S_NODE_16063_length_195_cov_1.109589_g15961_i0	PRJNA285816	16063	195	1.109589	2.16369855	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	150	5.81e-32	NTclustered	gi\|2556925782\|gb\|CP129489.1\|	2021391	g15961	i0	82.32	20.8717948717949	181	24	91	6	1	177	895328	895152	MAG: Flavobacteriales bacterium isolate cMAG.7 chromosome, complete genome	blastn	4070	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
4199148	4199148	PRJNA285816_S_NODE_24164_length_169_cov_0.866667_g24062_i0	PRJNA285816	24164	169	0.866667	1.46466723	Flavobacterium covae	2906076	Bacteria	Bacteria	279	5.95e-71	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g24062	i0	98.137	385.467455621302	161	1	95	2	1	160	2807219	2807060	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	65144	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
4887126	4887126	PRJNA285816_S_NODE_7804_length_254_cov_53.092683_g7702_i0	PRJNA285816	7804	254	53.092683	134.85541482	Aquirufa	2676247	Bacteria	Bacteria	425	1.18e-114	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g7702	i0	96.85	340.98031496063	254	8	100	0	1	254	360872	361125	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	86609	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
5475477	5475477	PRJNA285816_S_NODE_26725_length_165_cov_1.344828_g26623_i0	PRJNA285816	26725	165	1.344828	2.2189662	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	206	1e-48	NTclustered	gi\|2874253714\|emb\|OY969556.1\|	152509	g26623	i0	89.157	75.8909090909091	166	17	100	1	1	165	171216	171381	MAG: uncultured Bacteroidetes bacterium isolate MFD09286.bin.c.1 genome assembly, chromosome: 1	blastn	12522	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
6161948	6161948	PRJNA285816_S_NODE_20225_length_180_cov_1.030534_g20123_i0	PRJNA285816	20225	180	1.030534	1.8549612	Capnocytophaga	1016	Bacteria	Bacteria	300	4.94e-77	NTclustered	gi\|2797268018\|gb\|CP162011.1\|	327575	g20123	i0	96.685	252.294444444444	181	4	100	2	1	180	420215	420394	Capnocytophaga leadbetteri strain F0087 isolate D204 chromosome, complete genome	blastn	45413	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
7437042	7437042	PRJNA285816_S_NODE_14766_length_201_cov_1.289474_g14664_i0	PRJNA285816	14766	201	1.289474	2.59184274	Flavobacterium	237	Bacteria	Bacteria	267	5.73e-67	NTclustered	gi\|2496343437\|gb\|CP092332.1\|	1306518	g14664	i0	95.266	390.497512437811	169	6	84	2	34	201	1184716	1184883	Flavobacterium keumense strain K3R-10 chromosome, complete genome	blastn	78490	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium keumense
7437052	7437052	PRJNA285816_S_NODE_16426_length_193_cov_2.923611_g16324_i0	PRJNA285816	16426	193	2.923611	5.64256923	Mucilaginibacter	423349	Bacteria	Bacteria	217	5.5799999999999996e-52	NTclustered	gi\|1721675146\|gb\|CP042437.1\|	862126	g16324	i0	94.326	216.502590673575	141	8	73	0	53	193	1842718	1842858	Mucilaginibacter ginsenosidivorax strain KHI28 chromosome, complete genome	blastn	41785	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginsenosidivorax
8025202	8025202	PRJNA285816_S_NODE_15467_length_198_cov_1.046980_g15365_i0	PRJNA285816	15467	198	1.04698	2.0730204	Fluviicola taffensis	191579	Bacteria	Bacteria	289	1.1999999999999999e-73	NTclustered	gi\|327317519\|gb\|CP002542.1\|	755732	g15365	i0	92.929	9.29292929292929	198	14	100	0	1	198	3878551	3878354	Fluviicola taffensis DSM 16823 chromosome, complete genome	blastn	1840	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
13125757	13125757	PRJNA285816_S_NODE_16351_length_194_cov_1.075862_g16249_i0	PRJNA285816	16351	194	1.075862	2.08717228	Mucilaginibacter sp. 21P	2778902	Bacteria	Bacteria	331	1.92e-86	NTclustered	gi\|2071726690\|gb\|CP063061.1\|	2778902	g16249	i0	97.906	364.680412371134	191	4	98	0	4	194	468743	468553	Mucilaginibacter sp. 21P chromosome, complete genome	blastn	70748	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. 21P
13125884	13125884	PRJNA285816_S_NODE_26051_length_166_cov_1.324786_g25949_i0	PRJNA285816	26051	166	1.324786	2.19914476	Prevotella intermedia	28131	Bacteria	Bacteria	211	2.17e-50	NTclustered	gi\|1276666115\|gb\|CP024725.1\|	28131	g25949	i0	92.105	216.879518072289	152	9	90	3	1	150	111011	110861	Prevotella intermedia strain KCOM 2838 chromosome 1, complete sequence	blastn	36002	211	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
13126005	13126005	PRJNA285816_S_NODE_8911_length_241_cov_1.729167_g8809_i0	PRJNA285816	8911	241	1.729167	4.16729247	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	97.1	9.88e-16	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g8809	i0	88.889	1.44398340248963	81	5	33	4	155	233	2303333	2303411	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	348	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
13812548	13812548	PRJNA285816_S_NODE_29871_length_160_cov_2.189189_g29769_i0	PRJNA285816	29871	160	2.189189	3.5027024	root	1	Root_unresolved	Root_unresolved	291	2.5799999999999998e-74	NTclustered	gi\|2679196903\|dbj\|AP029375.1\|	28125	g29769	i0	99.375	102.9875	160	1	100	0	1	160	1319047	1319206	Prevotella bivia TOH-2715 DNA, chromosome 1, complete sequence	blastn	16478	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
14401083	14401083	PRJNA285816_S_NODE_29112_length_162_cov_1.495575_g29010_i0	PRJNA285816	29112	162	1.495575	2.4228315	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	233	4.49e-57	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g29010	i0	92.593	181.098765432099	162	12	100	0	1	162	2012952	2012791	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	29338	233	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
15674655	15674655	PRJNA285816_S_NODE_17053_length_191_cov_1.098592_g16951_i0	PRJNA285816	17053	191	1.098592	2.09831072	uncultured Bacteroidia bacterium	1129257	Bacteria	Bacteria	195	2.5799999999999997e-45	NTclustered	gi\|2308952747\|emb\|OX044357.1\|	1129257	g16951	i0	87.719	88.0575916230366	171	15	88	5	1	168	2405275	2405108	MAG: uncultured Bacteroidia bacterium isolate B_MB356 genome assembly, chromosome: B_MB356_contig-1	blastn	16819	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				uncultured Bacteroidia bacterium
15674783	15674783	PRJNA285816_S_NODE_27473_length_164_cov_1.356522_g27371_i0	PRJNA285816	27473	164	1.356522	2.22469608	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	108	2.88e-19	NTclustered	gi\|2621786308\|emb\|OY782766.1\|	2053594	g27371	i0	78.698	136.80487804878	169	31	100	3	1	164	2572354	2572186	MAG: Prolixibacteraceae bacterium isolate 5a39d30b-952b-42cf-b5cf-364178b4285b genome assembly, chromosome: 1	blastn	22436	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
16949219	16949219	PRJNA285816_S_NODE_10514_length_226_cov_4.146893_g10412_i0	PRJNA285816	10514	226	4.146893	9.37197818	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	346	8.24e-91	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g10412	i0	94.273	237.650442477876	227	12	100	1	1	226	2978656	2978882	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	53709	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
16949427	16949427	PRJNA285816_S_NODE_2654_length_411_cov_1.784530_g2552_i0	PRJNA285816	2654	411	1.78453	7.3344183	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	721	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g2552	i0	98.297	345.116788321168	411	7	100	0	1	411	2978320	2978730	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	141843	721	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
20185208	20185208	PRJNA285816_S_NODE_3116_length_380_cov_5.199396_g3014_i0	PRJNA285816	3116	380	5.199396	19.7577048	Arsenicibacter	1914260	Bacteria	Bacteria	675	0	NTclustered	gi\|27530731\|dbj\|AB074612.1\|	152509	g3014	i0	98.684	96.9131578947368	380	5	100	0	1	380	78	457	Uncultured Bacteroidetes bacterium gene for 16S rRNA, partial cds, clone:APe4_73	blastn	36827	675	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
22735960	22735960	PRJNA285816_S_NODE_23238_length_171_cov_1.139344_g23136_i0	PRJNA285816	23238	171	1.139344	1.94827824	Cytophaga	978	Bacteria	Bacteria	211	2.23e-50	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g23136	i0	91.083	211.368421052632	157	13	92	1	1	157	212	367	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	36144	211	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
22735968	22735968	PRJNA285816_S_NODE_27378_length_164_cov_1.991304_g27276_i0	PRJNA285816	27378	164	1.991304	3.26573856	Chryseobacterium	59732	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|1519576354\|gb\|CP033934.1\|	246	g27276	i0	99.39	480.012195121951	164	1	100	0	1	164	116562	116399	Chryseobacterium balustinum strain KC_1863 chromosome, complete genome	blastn	78722	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium balustinum
23324107	23324107	PRJNA285816_S_NODE_2779_length_402_cov_2.014164_g2677_i0	PRJNA285816	2779	402	2.014164	8.09693928	Chryseolinea soli	2321403	Bacteria	Bacteria	497	4.12e-136	NTclustered	gi\|1481087475\|gb\|CP032382.1\|	2321403	g2677	i0	89.303	365.71144278607	402	36	99	2	1	396	901047	901447	Chryseolinea soli strain KIS68-18 chromosome, complete genome	blastn	147016	497	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea soli
23324138	23324138	PRJNA285816_S_NODE_29639_length_162_cov_0.902655_g29537_i0	PRJNA285816	29639	162	0.902655	1.4623011	Prevotella melaninogenica	28132	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g29537	i0	100	227.172839506173	162	0	100	0	1	162	698973	699134	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	36802	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
23324184	23324184	PRJNA285816_S_NODE_6239_length_279_cov_1.717391_g6137_i0	PRJNA285816	6239	279	1.717391	4.79152089	Prevotella intermedia	28131	Bacteria	Bacteria	470	5.99e-128	NTclustered	gi\|965692493\|dbj\|AP014597.1\|	28131	g6137	i0	97.133	228.4229390681	279	7	100	1	1	279	1259667	1259944	Prevotella intermedia DNA, complete genome, strain: OMA14, chromosome: I	blastn	63730	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
24598039	24598039	PRJNA285816_S_NODE_15960_length_195_cov_2.794521_g15858_i0	PRJNA285816	15960	195	2.794521	5.44931595	Candidatus Fermentibacterota bacterium	2044591	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2874254046\|emb\|OY970370.1\|	2044591	g15858	i0	96.97	0.169230769230769	33	1	17	0	135	167	1435110	1435142	MAG: Candidatus Fermentibacteria bacterium isolate MFD00905.bin.1.36 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Fermentibacterota					Candidatus Fermentibacterota bacterium
24598234	24598234	PRJNA285816_S_NODE_3260_length_372_cov_3.046440_g3158_i0	PRJNA285816	3260	372	3.04644	11.3327568	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	462	1.38e-125	NTclustered	gi\|2556918996\|gb\|CP129487.1\|	2099675	g3158	i0	90.571	318.236559139785	350	32	94	1	15	364	2990280	2990628	MAG: Cyclobacteriaceae bacterium isolate cMAG.9 chromosome, complete genome	blastn	118384	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
25285186	25285186	PRJNA285816_S_NODE_1240_length_587_cov_26.589219_g1148_i0	PRJNA285816	1240	587	26.589219	156.07871553	Fluviicola	332102	Bacteria	Bacteria	928	0	NTclustered	gi\|327317519\|gb\|CP002542.1\|	755732	g1148	i0	95.848	90.2759795570698	578	16	98	6	14	587	2752728	2753301	Fluviicola taffensis DSM 16823 chromosome, complete genome	blastn	52992	928	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis

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