metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA906294" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA906294" 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
1248619	1248619	PRJNA906294_P_NODE_206221_length_250_cov_0.870056_g202105_i0	PRJNA906294	206221	250	0.870056	2.17514	Rhodothermus	29548	Bacteria	Bacteria	294	3.41e-75	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g202105	i0	89.655	301.78	232	22	92	2	21	250	3095004	3094773	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	75445	294	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
2162411	2162411	PRJNA906294_P_NODE_177722_length_278_cov_1.082927_g173606_i0	PRJNA906294	177722	278	1.082927	3.01053706	Myroides odoratimimus	76832	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|969868918\|gb\|CP013690.1\|	76832	g173606	i0	96.97	0.377697841726619	33	0	12	1	34	65	13512	13480	Myroides odoratimimus strain PR63039 chromosome, complete genome	blastn	105	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
2163074	2163074	PRJNA906294_P_NODE_204982_length_251_cov_0.865169_g200866_i0	PRJNA906294	204982	251	0.865169	2.17157419	Algoriphagus sanaruensis	1727163	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|1006702952\|gb\|CP012836.1\|	1727163	g200866	i0	98.406	288.569721115538	251	4	100	0	1	251	1802892	1803142	Algoriphagus sanaruensis strain M8-2 chromosome, complete genome	blastn	72431	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sanaruensis
3437249	3437249	PRJNA906294_P_NODE_156143_length_303_cov_1.547826_g152027_i0	PRJNA906294	156143	303	1.547826	4.68991278	Cnuella takakiae	1302690	Bacteria	Bacteria	483	8.45e-132	NTclustered	gi\|959494853\|ref\|NR_133730.1\|	1302690	g152027	i0	95.38	98.7293729372937	303	14	100	0	1	303	131	433	Cnuella takakiae strain RG1-1 16S ribosomal RNA, partial sequence	blastn	29915	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Cnuella	Cnuella takakiae
5989220	5989220	PRJNA906294_P_NODE_125565_length_352_cov_1.279570_g121449_i0	PRJNA906294	125565	352	1.27957	4.5040864	Hymenobacter monticola	1705399	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g121449	i0	100	0.0852272727272727	30	0	9	0	31	60	1058100	1058129	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
5989840	5989840	PRJNA906294_P_NODE_151985_length_309_cov_1.122881_g147869_i0	PRJNA906294	151985	309	1.122881	3.46970229	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	235	2.67e-57	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g147869	i0	83.396	362.68284789644	265	32	83	10	1	258	171814	171555	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	112069	235	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5989994	5989994	PRJNA906294_P_NODE_158405_length_300_cov_1.493392_g154289_i0	PRJNA906294	158405	300	1.493392	4.480176	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	431	3.07e-116	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g154289	i0	92.642	260.346666666667	299	22	99	0	1	299	4832810	4832512	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	78104	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
5990736	5990736	PRJNA906294_P_NODE_191085_length_264_cov_1.476440_g186969_i0	PRJNA906294	191085	264	1.47644	3.8978016	Flavobacterium gilvum	1492737	Bacteria	Bacteria	231	2.89e-56	NTclustered	gi\|1078660911\|gb\|CP017479.1\|	1492737	g186969	i0	82.51	2.85606060606061	263	46	99	0	2	264	1468352	1468614	Flavobacterium gilvum strain EM1308 chromosome, complete genome	blastn	754	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium gilvum
7265040	7265040	PRJNA906294_P_NODE_169866_length_286_cov_2.093897_g165750_i0	PRJNA906294	169866	286	2.093897	5.98854542	uncultured Flexibacteraceae bacterium	239735	Bacteria	Bacteria	407	4.9e-109	NTclustered	gi\|242124334\|gb\|FJ608195.1\|	239735	g165750	i0	92.334	86.8671328671329	287	20	100	2	1	286	657	372	Uncultured Flexibacteraceae bacterium clone MFC69 16S ribosomal RNA gene, partial sequence	blastn	24844	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		uncultured Flexibacteraceae bacterium
7267909	7267909	PRJNA906294_P_NODE_86646_length_463_cov_1.843590_g82532_i0	PRJNA906294	86646	463	1.84359	8.5358217	Myroides phaeus	702745	Bacteria	Bacteria	839	0	NTclustered	gi\|1787534517\|gb\|CP047050.1\|	702745	g82532	i0	99.352	711.215982721382	463	3	100	0	1	463	201295	201757	Myroides phaeus strain 18QD1AZ29W chromosome, complete genome	blastn	329293	839	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides phaeus
8540888	8540888	PRJNA906294_P_NODE_215987_length_246_cov_0.890173_g211871_i0	PRJNA906294	215987	246	0.890173	2.18982558	Bacteroidales bacterium	2030927	Bacteria	Bacteria	246	9.5e-61	NTclustered	gi\|2621706017\|emb\|OY764079.1\|	2030927	g211871	i0	85.081	344.211382113821	248	30	99	7	1	244	2516439	2516195	MAG: Bacteroidales bacterium isolate db5b4c7c-2a0e-4d21-a2ad-7e45facec811 genome assembly, chromosome: 1	blastn	84676	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
9815075	9815075	PRJNA906294_P_NODE_178748_length_277_cov_0.985294_g174632_i0	PRJNA906294	178748	277	0.985294	2.72926438	Niabella yanshanensis	577386	Bacteria	Bacteria	252	2.34e-62	NTclustered	gi\|2636479872\|gb\|CP139960.1\|	577386	g174632	i0	83.63	538.584837545126	281	33	98	13	1	272	1092896	1092620	Niabella yanshanensis strain HAMBI_3031 chromosome, complete genome	blastn	149188	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella yanshanensis
9815126	9815126	PRJNA906294_P_NODE_180788_length_274_cov_2.955224_g176672_i0	PRJNA906294	180788	274	2.955224	8.09731376	Prevotella herbatica	2801997	Bacteria	Bacteria	472	1.63e-128	NTclustered	gi\|1996220562\|dbj\|AP024484.1\|	2801997	g176672	i0	97.81	263.649635036496	274	5	99	1	2	274	279630	279357	Prevotella herbatica WR041 DNA, complete genome	blastn	72240	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella herbatica
10176856	10176856	PRJNA906294_P_NODE_147108_length_316_cov_1.111111_g142992_i0	PRJNA906294	147108	316	1.111111	3.51111076	Flavobacteriaceae	49546	Bacteria	Bacteria	518	2.4299999999999998e-142	NTclustered	gi\|2636494101\|gb\|CP139975.1\|	256	g142992	i0	96.215	407.018987341772	317	11	100	1	1	316	483457	483141	Myroides odoratus strain HAMBI_1923 chromosome, complete genome	blastn	128618	520	0.996153846153846	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratus
11089912	11089912	PRJNA906294_P_NODE_142749_length_322_cov_1.562249_g138633_i0	PRJNA906294	142749	322	1.562249	5.03044178	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	446	1.1899999999999999e-120	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g138633	i0	91.641	203.285714285714	323	25	100	2	1	322	1743479	1743158	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	65458	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
11091687	11091687	PRJNA906294_P_NODE_218749_length_245_cov_0.895349_g214633_i0	PRJNA906294	218749	245	0.895349	2.19360505	Cloacibacterium normanense	237258	Bacteria	Bacteria	401	1.9099999999999994e-107	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g214633	i0	96.311	3.98367346938775	244	9	99	0	1	244	2041822	2041579	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	976	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
12365834	12365834	PRJNA906294_P_NODE_163110_length_294_cov_1.755656_g158994_i0	PRJNA906294	163110	294	1.755656	5.16162864	uncultured Saccharicrinis sp.	1618115	Bacteria	Bacteria	472	1.7699999999999998e-128	NTclustered	gi\|2621785463\|emb\|OY781921.1\|	1618115	g158994	i0	95.578	350.656462585034	294	13	100	0	1	294	2929069	2928776	MAG: uncultured Saccharicrinis sp. isolate 044d8e91-df83-4d29-87ff-5f2b71dcf37c genome assembly, chromosome: 1	blastn	103093	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Saccharicrinis	uncultured Saccharicrinis sp.
13641728	13641728	PRJNA906294_P_NODE_218731_length_245_cov_0.895349_g214615_i0	PRJNA906294	218731	245	0.895349	2.19360505	Chryseobacterium sp. PMSZPI	1033900	Bacteria	Bacteria	333	7.049999999999999e-87	NTclustered	gi\|2894512347\|gb\|CP178384.1\|	1033900	g214615	i0	91.358	0.991836734693878	243	21	99	0	1	243	627356	627114	Chryseobacterium sp. PMSZPI chromosome, complete genome	blastn	243	333	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. PMSZPI
14002038	14002038	PRJNA906294_P_NODE_100271_length_415_cov_1.309942_g96156_i0	PRJNA906294	100271	415	1.309942	5.4362593	Flavihumibacter	1004301	Bacteria	Bacteria	638	2.4099999999999996e-178	NTclustered	gi\|2198890466\|gb\|CP092334.1\|	2838156	g96156	i0	94.458	287.925301204819	415	22	100	1	1	415	88766	89179	Flavihumibacter rivuli strain IMCC34838 chromosome, complete genome	blastn	119489	643	0.992223950233281	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter rivuli
14002403	14002403	PRJNA906294_P_NODE_168911_length_287_cov_3.266355_g164795_i0	PRJNA906294	168911	287	3.266355	9.37443885	Chitinophagaceae	563835	Bacteria	Bacteria	479	1.0299999999999996e-130	NTclustered	gi\|570743502\|gb\|CP007035.1\|	929713	g164795	i0	97.834	257.452961672474	277	6	97	0	1	277	2224659	2224383	Niabella soli DSM 19437, complete genome	blastn	73889	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella soli
15276408	15276408	PRJNA906294_P_NODE_181392_length_274_cov_1.218905_g177276_i0	PRJNA906294	181392	274	1.218905	3.3397997	Bacteroidaceae	815	Bacteria	Bacteria	501	2.08e-137	NTclustered	gi\|2625468065\|gb\|CP139161.1\|	817	g177276	i0	99.635	18.9051094890511	274	1	100	0	1	274	2293771	2293498	Bacteroides fragilis strain ZY0804 chromosome, complete genome	blastn	5180	501	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
16189040	16189040	PRJNA906294_P_NODE_139993_length_326_cov_3.932806_g135877_i0	PRJNA906294	139993	326	3.932806	12.82094756	Myroides phaeus	702745	Bacteria	Bacteria	597	3.139999999999999e-166	NTclustered	gi\|1787534517\|gb\|CP047050.1\|	702745	g135877	i0	99.693	663.812883435583	326	1	100	0	1	326	199339	199664	Myroides phaeus strain 18QD1AZ29W chromosome, complete genome	blastn	216403	597	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides phaeus
21650316	21650316	PRJNA906294_P_NODE_116397_length_371_cov_2.063758_g112282_i0	PRJNA906294	116397	371	2.063758	7.65654218	Hymenobacter	89966	Bacteria	Bacteria	656	0	NTclustered	gi\|1844056603\|gb\|CP053538.1\|	2735321	g112282	i0	98.649	261.768194070081	370	5	99	0	1	370	244942	244573	Hymenobacter taeanensis strain TS19 chromosome, complete genome	blastn	97116	656	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter taeanensis
21650955	21650955	PRJNA906294_P_NODE_46937_length_739_cov_2.204204_g43048_i0	PRJNA906294	46937	739	2.204204	16.28906756	Spirosoma	107	Bacteria	Bacteria	835	0	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g43048	i0	87.149	324.263870094723	747	83	100	13	1	739	1502309	1501568	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	239631	837	0.997610513739546	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
23840045	23840045	PRJNA906294_P_NODE_210259_length_248_cov_0.880000_g206143_i0	PRJNA906294	210259	248	0.88	2.1824	Parabacteroides goldsteinii	328812	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|2777523482\|dbj\|AP031410.1\|	328812	g206143	i0	96.774	10.2459677419355	248	8	100	0	1	248	3806046	3805799	Parabacteroides goldsteinii f09 DNA, complete genome	blastn	2541	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides goldsteinii
23840107	23840107	PRJNA906294_P_NODE_213119_length_247_cov_0.885057_g209003_i0	PRJNA906294	213119	247	0.885057	2.18609079	Muribaculum intestinale	1796646	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|1208465567\|gb\|CP021421.1\|	1796646	g209003	i0	96.356	3	247	9	100	0	1	247	255871	255625	Muribaculum intestinale strain YL27 chromosome	blastn	741	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Muribaculum	Muribaculum intestinale
23840501	23840501	PRJNA906294_P_NODE_230279_length_241_cov_0.916667_g226163_i0	PRJNA906294	230279	241	0.916667	2.20916747	Bacteroides caecimuris	1796613	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|2235377421\|gb\|CP096969.1\|	1796613	g226163	i0	97.49	3.96680497925311	239	5	99	1	3	241	1573560	1573323	Bacteroides caecimuris strain I48 chromosome	blastn	956	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caecimuris
24200130	24200130	PRJNA906294_P_NODE_206259_length_250_cov_0.870056_g202143_i0	PRJNA906294	206259	250	0.870056	2.17514	Parabacteroides	375288	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2098161568\|gb\|CP081906.1\|	328812	g202143	i0	100	516.06	250	0	100	0	1	250	154684	154933	Parabacteroides goldsteinii strain BFG-241 chromosome, complete genome	blastn	129015	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides goldsteinii
25475111	25475111	PRJNA906294_P_NODE_191260_length_264_cov_1.251309_g187144_i0	PRJNA906294	191260	264	1.251309	3.30345576	Hymenobacter	89966	Bacteria	Bacteria	455	1.57e-123	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g187144	i0	97.727	278.784090909091	264	6	100	0	1	264	272950	273213	Hymenobacter sp. DG01 chromosome, complete genome	blastn	73599	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01

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