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

32 rows where analysis = "blastn", bioproject = "PRJNA760904" 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
742242	742242	PRJNA760904_P_NODE_20121_length_242_cov_0.911243_g20064_i0	PRJNA760904	20121	242	0.911243	2.20520806	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g20064	i0	97.934	54.1363636363636	242	5	100	0	1	242	2486736	2486977	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	13101	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
742248	742248	PRJNA760904_P_NODE_21121_length_234_cov_2.391304_g21064_i0	PRJNA760904	21121	234	2.391304	5.59565136	Bacteroidales bacterium	2030927	Bacteria	Bacteria	182	2.56e-41	NTclustered	gi\|2621784647\|emb\|OY781105.1\|	2030927	g21064	i0	86.228	267.858974358974	167	23	71	0	18	184	46648	46482	MAG: Bacteroidales bacterium isolate 0f0db77d-63af-43ca-a293-a1227edc7b73 genome assembly, chromosome: 1	blastn	62679	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
1204847	1204847	PRJNA760904_P_NODE_10201_length_286_cov_0.943662_g10144_i0	PRJNA760904	10201	286	0.943662	2.69887332	Flavobacterium	237	Bacteria	Bacteria	477	3.679999999999999e-130	NTclustered	gi\|1205046735\|gb\|MF289246.1\|	239	g10144	i0	97.163	114.702797202797	282	8	99	0	1	282	218	499	Flavobacterium sp. strain MMS16-G14 16S ribosomal RNA gene, partial sequence	blastn	32805	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
1204872	1204872	PRJNA760904_P_NODE_21141_length_233_cov_2.837500_g21084_i0	PRJNA760904	21141	233	2.8375	6.611375	Bacteroidota	976	Bacteria	Bacteria	200	7.039999999999998e-47	NTclustered	gi\|470486621\|ref\|NR_076769.1\|	28188	g21084	i0	84.36	365.107296137339	211	25	88	7	1	206	515	722	Capnocytophaga canimorsus strain Cc5 23S ribosomal RNA gene, complete sequence	blastn	85070	202	0.99009900990099	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
2018257	2018257	PRJNA760904_P_NODE_19782_length_242_cov_1.627219_g19725_i0	PRJNA760904	19782	242	1.627219	3.93786998	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	217	7.3e-52	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g19725	i0	82.917	20.5578512396694	240	41	99	0	3	242	75326	75087	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	4975	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
2018304	2018304	PRJNA760904_P_NODE_8782_length_302_cov_2.314410_g8725_i0	PRJNA760904	8782	302	2.31441	6.9895182	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	414	3.11e-111	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g8725	i0	93.238	255.407284768212	281	19	93	0	22	302	1075762	1075482	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	77133	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
2480390	2480390	PRJNA760904_P_NODE_11082_length_278_cov_1.878049_g11025_i0	PRJNA760904	11082	278	1.878049	5.22097622	Myroides	76831	Bacteria	Bacteria	294	3.85e-75	NTclustered	gi\|753770668\|gb\|CP010817.1\|	480520	g11025	i0	86.667	532.561151079137	270	30	96	5	12	278	799346	799080	Myroides profundi strain D25, complete genome	blastn	148052	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides profundi
3293516	3293516	PRJNA760904_P_NODE_1743_length_596_cov_2.189293_g1688_i0	PRJNA760904	1743	596	2.189293	13.04818628	Flavobacterium cerinum	2502784	Bacteria	Bacteria	1018	0	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g1688	i0	97.492	618.751677852349	598	11	100	3	1	596	719063	719658	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	368776	1018	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
3756705	3756705	PRJNA760904_P_NODE_18763_length_244_cov_0.900585_g18706_i0	PRJNA760904	18763	244	0.900585	2.1974274	Dyadobacter	120831	Bacteria	Bacteria	405	1.47e-108	NTclustered	gi\|2257605683\|gb\|CP098806.1\|	2906443	g18706	i0	96.721	204.225409836066	244	6	99	1	1	242	4703764	4703521	Dyadobacter fanqingshengii strain CY399 chromosome, complete genome	blastn	49831	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fanqingshengii
3756711	3756711	PRJNA760904_P_NODE_20023_length_242_cov_0.911243_g19966_i0	PRJNA760904	20023	242	0.911243	2.20520806	Tannerella	195950	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|363406024\|gb\|CP003191.1\|	203275	g19966	i0	100	0.359504132231405	29	0	12	0	96	124	2728933	2728905	Tannerella forsythia 92A2, complete genome	blastn	87	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella forsythia
3756718	3756718	PRJNA760904_P_NODE_2583_length_505_cov_1.111111_g2526_i0	PRJNA760904	2583	505	1.111111	5.61111055	Parabacteroides	375288	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1848637015\|gb\|CP054012.1\|	823	g2526	i0	100	2.15643564356436	31	0	6	0	127	157	2301662	2301632	Parabacteroides distasonis strain FDAARGOS_759 chromosome, complete genome	blastn	1089	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
5845780	5845780	PRJNA760904_P_NODE_11865_length_272_cov_1.236181_g11808_i0	PRJNA760904	11865	272	1.236181	3.36241232	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	372	1.69e-98	NTclustered	gi\|1527177630\|gb\|CP034171.1\|	536441	g11808	i0	91.481	0.992647058823529	270	23	99	0	3	272	1656102	1656371	Chryseobacterium taklimakanense strain H4753 chromosome, complete genome	blastn	270	372	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
7120955	7120955	PRJNA760904_P_NODE_10606_length_282_cov_1.473684_g10549_i0	PRJNA760904	10606	282	1.473684	4.15578888	Chryseobacterium sp. M5	3379128	Bacteria	Bacteria	499	7.729999999999999e-137	NTclustered	gi\|2853920187\|gb\|CP173626.1\|	3379128	g10549	i0	98.582	6.67021276595745	282	4	100	0	1	282	2665922	2665641	Chryseobacterium sp. M5 chromosome, complete genome	blastn	1881	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. M5
8858068	8858068	PRJNA760904_P_NODE_16327_length_248_cov_1.114286_g16270_i0	PRJNA760904	16327	248	1.114286	2.76342928	Weeksellaceae	2762318	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g16270	i0	99.194	553.491935483871	248	2	100	0	1	248	167590	167837	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	137266	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
9670659	9670659	PRJNA760904_P_NODE_15048_length_251_cov_0.865169_g14991_i0	PRJNA760904	15048	251	0.865169	2.17157419	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	250	7.52e-62	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g14991	i0	85.306	7.68127490039841	245	32	97	4	9	251	548088	547846	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	1928	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
9670670	9670670	PRJNA760904_P_NODE_17588_length_246_cov_0.890173_g17531_i0	PRJNA760904	17588	246	0.890173	2.18982558	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g17531	i0	98.374	3	246	4	100	0	1	246	686243	686488	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	738	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
9670717	9670717	PRJNA760904_P_NODE_9448_length_292_cov_2.200913_g9391_i0	PRJNA760904	9448	292	2.200913	6.42666596	Flavobacterium covae	2906076	Bacteria	Bacteria	346	1.11e-90	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g9391	i0	89.247	373.900684931507	279	27	95	3	1	278	565422	565698	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	109179	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
9670724	9670724	PRJNA760904_P_NODE_9828_length_289_cov_1.074074_g9771_i0	PRJNA760904	9828	289	1.074074	3.10407386	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	501	2.21e-137	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g9771	i0	97.931	2.69204152249135	290	5	100	1	1	289	3127217	3126928	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	778	501	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
10133616	10133616	PRJNA760904_P_NODE_828_length_822_cov_1.894526_g778_i0	PRJNA760904	828	822	1.894526	15.57300372	Sphingobacterium	28453	Bacteria	Bacteria	54.7	0.023	NTclustered	gi\|2235481910\|gb\|CP080574.1\|	459529	g778	i0	100	0.0705596107055961	29	0	4	0	5	33	3843957	3843985	Sphingobacterium siyangense strain FTD2 chromosome, complete genome	blastn	58	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium siyangense
11408746	11408746	PRJNA760904_P_NODE_16529_length_248_cov_0.880000_g16472_i0	PRJNA760904	16529	248	0.88	2.1824	Imperialibacter	1649461	Bacteria	Bacteria	252	2.06e-62	NTclustered	gi\|2597771528\|gb\|CP136051.1\|	1324217	g16472	i0	89.848	389.790322580645	197	19	79	1	51	247	4786677	4786482	Imperialibacter roseus strain P4T chromosome, complete genome	blastn	96668	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Imperialibacter	Imperialibacter roseus
12221914	12221914	PRJNA760904_P_NODE_5950_length_355_cov_0.790780_g5893_i0	PRJNA760904	5950	355	0.79078	2.807269	uncultured Flexibacteraceae bacterium	239735	Bacteria	Bacteria	195	5.2699999999999995e-45	NTclustered	gi\|41059282\|gb\|AY509376.1\|	239735	g5893	i0	95.868	42.2394366197183	121	4	34	1	2	122	121	2	Uncultured Flexibacteraceae bacterium clone LiUU-3-145 16S ribosomal RNA gene, partial sequence	blastn	14995	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		uncultured Flexibacteraceae bacterium
13495968	13495968	PRJNA760904_P_NODE_10951_length_279_cov_2.237864_g10894_i0	PRJNA760904	10951	279	2.237864	6.24364056	Capnocytophaga granulosa	45242	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g10894	i0	100	349.906810035842	279	0	100	0	1	279	1523221	1523499	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	97624	516	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
13495977	13495977	PRJNA760904_P_NODE_12231_length_269_cov_1.571429_g12174_i0	PRJNA760904	12231	269	1.571429	4.22714401	Porphyromonas endodontalis	28124	Bacteria	Bacteria	470	5.74e-128	NTclustered	gi\|2099425367\|gb\|CP083629.1\|	28124	g12174	i0	98.141	296.137546468401	269	5	100	0	1	269	202393	202661	Porphyromonas endodontalis strain FDAARGOS_1506 chromosome, complete genome	blastn	79661	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas endodontalis
14771109	14771109	PRJNA760904_P_NODE_12712_length_265_cov_2.213542_g12655_i0	PRJNA760904	12712	265	2.213542	5.8658863	Chryseobacterium oryzae	2929799	Bacteria	Bacteria	219	2.2599999999999998e-52	NTclustered	gi\|2216362202\|gb\|CP094529.1\|	2929799	g12655	i0	81.509	1.99245283018868	265	49	100	0	1	265	1586797	1586533	Chryseobacterium oryzae strain ADR-1 chromosome, complete genome	blastn	528	219	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium oryzae
14771143	14771143	PRJNA760904_P_NODE_18472_length_245_cov_0.895349_g18415_i0	PRJNA760904	18472	245	0.895349	2.19360505	Capnocytophaga granulosa	45242	Bacteria	Bacteria	451	1.87e-122	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g18415	i0	100	336.163265306122	244	0	99	0	1	244	1523486	1523729	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	82360	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
15233468	15233468	PRJNA760904_P_NODE_10952_length_279_cov_2.203883_g10895_i0	PRJNA760904	10952	279	2.203883	6.14883357	Flavobacterium	237	Bacteria	Bacteria	488	1.6499999999999999e-133	NTclustered	gi\|2702476710\|gb\|CP147988.1\|	687844	g10895	i0	98.214	544.433691756272	280	4	100	1	1	279	1014016	1013737	Flavobacterium ginsenosidimutans strain YTB16 chromosome, complete genome	blastn	151897	488	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ginsenosidimutans
16044900	16044900	PRJNA760904_P_NODE_18573_length_244_cov_2.385965_g18516_i0	PRJNA760904	18573	244	2.385965	5.8217546	Chryseobacterium gambrini	373672	Bacteria	Bacteria	392	1.14e-104	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g18516	i0	95.868	17.8032786885246	242	10	99	0	3	244	4153542	4153301	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	4344	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
18593888	18593888	PRJNA760904_P_NODE_10975_length_279_cov_1.495146_g10918_i0	PRJNA760904	10975	279	1.495146	4.17145734	Prevotella bivia	28125	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2515258864\|gb\|CP126676.1\|	28125	g10918	i0	100	3	279	0	100	0	1	279	315411	315689	Prevotella bivia strain PLW0727 chromosome 1, complete sequence	blastn	837	516	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
18593907	18593907	PRJNA760904_P_NODE_13775_length_257_cov_1.673913_g13718_i0	PRJNA760904	13775	257	1.673913	4.30195641	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	473	4.2099999999999996e-129	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g13718	i0	100	263.058365758755	256	0	99	0	1	256	4832185	4832440	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	67606	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
20331393	20331393	PRJNA760904_P_NODE_3016_length_471_cov_2.125628_g2959_i0	PRJNA760904	3016	471	2.125628	10.01170788	Flavobacterium	237	Bacteria	Bacteria	662	0	NTclustered	gi\|2306666110\|emb\|OX336425.1\|	1114861	g2959	i0	99.452	567.787685774947	365	1	100	1	1	364	23988	23624	Flavobacterium collinsii strain TRV642 genome assembly, chromosome: TRV642	blastn	267428	662	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium collinsii
20331402	20331402	PRJNA760904_P_NODE_6296_length_346_cov_2.300366_g6239_i0	PRJNA760904	6296	346	2.300366	7.95926636	Flavobacterium	237	Bacteria	Bacteria	604	1.9999999999999992e-168	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g6239	i0	98.261	562.965317919075	345	6	99	0	2	346	1417853	1418197	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	194786	604	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
23695199	23695199	PRJNA760904_P_NODE_2559_length_507_cov_1.064516_g2502_i0	PRJNA760904	2559	507	1.064516	5.39709612	uncultured Lewinella sp.	352149	Bacteria	Bacteria	477	6.899999999999999e-130	NTclustered	gi\|2621706733\|emb\|OY764692.1\|	352149	g2502	i0	86.031	327.092702169625	451	56	88	7	62	507	47964	47516	MAG: uncultured Lewinella sp. isolate 43be8028-5114-4234-ab34-ebc41a860949 genome assembly, chromosome: 147	blastn	165836	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	uncultured Lewinella sp.

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