metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA722925" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA722925" 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
710239	710239	PRJNA722925_S_NODE_1681_length_330_cov_2.740614_g1618_i0	PRJNA722925	1681	330	2.740614	9.0440262	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	527	4.229999999999999e-145	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g1618	i0	96.562	428.387878787879	320	8	97	1	3	322	444195	443879	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	141368	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
1193690	1193690	PRJNA722925_S_NODE_5981_length_188_cov_2.119205_g5918_i0	PRJNA722925	5981	188	2.119205	3.9841054	Capnocytophaga	1016	Bacteria	Bacteria	300	5.210000000000001e-77	NTclustered	gi\|285800015\|gb\|GU409997.1\|	45242	g5918	i0	95.745	100	188	4	100	2	1	188	27	210	Capnocytophaga granulosa clone ATC_A70_33 16S ribosomal RNA gene, partial sequence	blastn	18800	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
2469009	2469009	PRJNA722925_S_NODE_5902_length_189_cov_1.828947_g5839_i0	PRJNA722925	5902	189	1.828947	3.45670983	Flavobacterium	237	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|470481948\|ref\|NR_076504.1\|	986	g5839	i0	100	571.021164021164	189	0	100	0	1	189	1291	1479	Flavobacterium johnsoniae strain UW101 23S ribosomal RNA gene, complete sequence	blastn	107923	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
3261565	3261565	PRJNA722925_S_NODE_3323_length_241_cov_12.225490_g3260_i0	PRJNA722925	3323	241	12.22549	29.4634309	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	272	1.5299999999999999e-68	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g3260	i0	93.889	356.55601659751	180	11	75	0	62	241	442536	442357	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	85930	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
3261574	3261574	PRJNA722925_S_NODE_4663_length_209_cov_1.232558_g4600_i0	PRJNA722925	4663	209	1.232558	2.57604622	Porphyromonas gingivalis	837	Bacteria	Bacteria	302	1.6500000000000001e-77	NTclustered	gi\|2437755982\|gb\|CP116614.1\|	837	g4600	i0	92.788	335.866028708134	208	15	99	0	1	208	1241853	1242060	Porphyromonas gingivalis strain ATCC 49417 chromosome, complete genome	blastn	70196	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
3261600	3261600	PRJNA722925_S_NODE_9263_length_161_cov_1.346774_g9200_i0	PRJNA722925	9263	161	1.346774	2.16830614	Tannerella serpentiformis	712710	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g9200	i0	100	522.024844720497	161	0	100	0	1	161	561082	560922	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	84046	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
4538684	4538684	PRJNA722925_S_NODE_864_length_448_cov_5.391727_g802_i0	PRJNA722925	864	448	5.391727	24.15493696	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	440	7.919999999999998e-119	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g802	i0	84.564	484.705357142857	447	66	99	3	3	448	1237289	1236845	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	217148	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
6297721	6297721	PRJNA722925_S_NODE_10125_length_156_cov_2.495798_g10062_i0	PRJNA722925	10125	156	2.495798	3.89344488	Pedobacter	84567	Bacteria	Bacteria	278	1.95e-70	NTclustered	gi\|1062635033\|gb\|CP017141.1\|	430522	g10062	i0	98.718	298.282051282051	156	2	100	0	1	156	1130789	1130634	Pedobacter steynii strain DX4 chromosome, complete genome	blastn	46532	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter steynii
6297727	6297727	PRJNA722925_S_NODE_10565_length_154_cov_1.965812_g10502_i0	PRJNA722925	10565	154	1.965812	3.02735048	Niastella	354354	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|442580777\|gb\|KC157044.1\|	1282853	g10502	i0	100	100.974025974026	154	0	100	0	1	154	1073	1226	Niastella sp. HME8655 16S ribosomal RNA gene, partial sequence	blastn	15550	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella sp. HME8655
6297753	6297753	PRJNA722925_S_NODE_5845_length_190_cov_1.529412_g5782_i0	PRJNA722925	5845	190	1.529412	2.9058828	Weeksellaceae	2762318	Bacteria	Bacteria	340	3.1099999999999993e-89	NTclustered	gi\|1919297446\|gb\|CP063145.1\|	1118202	g5782	i0	98.947	53.0157894736842	190	2	100	0	1	190	305980	306169	Cruoricaptor ignavus strain M1214 chromosome, complete genome	blastn	10073	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cruoricaptor	Cruoricaptor ignavus
6297768	6297768	PRJNA722925_S_NODE_885_length_443_cov_6.334975_g822_i0	PRJNA722925	885	443	6.334975	28.06393925	Prevotella	838	Bacteria	Bacteria	619	9.369999999999998e-173	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g822	i0	93.317	251.291196388262	419	28	95	0	1	419	698680	698262	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	111322	623	0.993579454253612	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
7571506	7571506	PRJNA722925_S_NODE_1246_length_376_cov_23.719764_g1183_i0	PRJNA722925	1246	376	23.719764	89.18631264	Weeksellaceae	2762318	Bacteria	Bacteria	656	0	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g1183	i0	98.138	467.239361702128	376	7	100	0	1	376	1408551	1408176	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	175682	656	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
7571526	7571526	PRJNA722925_S_NODE_626_length_521_cov_4.871901_g566_i0	PRJNA722925	626	521	4.871901	25.38260421	Prevotella	838	Bacteria	Bacteria	562	1.91e-155	NTclustered	gi\|2774256485\|dbj\|AP035785.1\|	3236793	g566	i0	86.233	268.570057581574	523	66	100	6	1	521	949354	949872	Prevotella sp. GTC17253 DNA, complete genome	blastn	139925	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. GTC17253
8363564	8363564	PRJNA722925_S_NODE_4187_length_218_cov_8.563536_g4124_i0	PRJNA722925	4187	218	8.563536	18.66850848	Porphyromonas gingivalis	837	Bacteria	Bacteria	335	1.7099999999999992e-87	NTclustered	gi\|2537609197\|gb\|CP098925.1\|	837	g4124	i0	94.47	281.178899082569	217	12	99	0	1	217	190130	190346	Porphyromonas gingivalis strain grey chromosome, complete genome	blastn	61297	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
10914283	10914283	PRJNA722925_S_NODE_2289_length_288_cov_1.529880_g2226_i0	PRJNA722925	2289	288	1.52988	4.4060544	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	518	2.19e-142	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g2226	i0	99.301	399.107638888889	286	2	99	0	3	288	444926	445211	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	114943	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
12189570	12189570	PRJNA722925_S_NODE_2570_length_272_cov_4.978723_g2507_i0	PRJNA722925	2570	272	4.978723	13.54212656	Epilithonimonas zeae	1416779	Bacteria	Bacteria	420	5.94e-113	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g2507	i0	94.526	434.599264705882	274	11	100	4	1	272	2242805	2242534	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	118211	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
13947550	13947550	PRJNA722925_S_NODE_831_length_455_cov_20.720096_g769_i0	PRJNA722925	831	455	20.720096	94.2764368	Cloacibacterium	501783	Bacteria	Bacteria	791	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g769	i0	98.026	456.334065934066	456	8	100	1	1	455	130507	130052	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	207632	797	0.992471769134254	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
15222238	15222238	PRJNA722925_S_NODE_1112_length_397_cov_10.755556_g1049_i0	PRJNA722925	1112	397	10.755556	42.69955732	Cloacibacterium	501783	Bacteria	Bacteria	628	1.38e-175	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1049	i0	95.431	463.24685138539	394	18	99	0	1	394	130819	130426	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	183909	634	0.990536277602524	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
16012775	16012775	PRJNA722925_S_NODE_1353_length_364_cov_3.645260_g1290_i0	PRJNA722925	1353	364	3.64526	13.2687464	Capnocytophaga granulosa	45242	Bacteria	Bacteria	610	4.539999999999998e-170	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g1290	i0	96.978	503.994505494506	364	10	100	1	1	364	1522891	1522529	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	183454	610	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
16012807	16012807	PRJNA722925_S_NODE_7833_length_170_cov_4.052632_g7770_i0	PRJNA722925	7833	170	4.052632	6.8894744	Capnocytophaga sputigena	1019	Bacteria	Bacteria	309	7.64e-80	NTclustered	gi\|1242562181\|gb\|CP022385.1\|	1019	g7770	i0	99.412	263.194117647059	170	1	100	0	1	170	809483	809652	Capnocytophaga sputigena strain KC1668 chromosome, complete genome	blastn	44743	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
16496656	16496656	PRJNA722925_S_NODE_9513_length_159_cov_6.622951_g9450_i0	PRJNA722925	9513	159	6.622951	10.53049209	Prevotellaceae	171552	Bacteria	Bacteria	180	5.79e-41	NTclustered	gi\|2190105072\|gb\|CP091797.1\|	77095	g9450	i0	88.514	395.14465408805	148	17	93	0	11	158	341367	341220	Segatella bryantii strain TS1-5 chromosome 2, complete sequence	blastn	62828	180	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella bryantii
18562097	18562097	PRJNA722925_S_NODE_455_length_607_cov_4.947368_g401_i0	PRJNA722925	455	607	4.947368	30.03052376	Prevotella melaninogenica	28132	Bacteria	Bacteria	887	0	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g401	i0	93.092	241.912685337727	608	38	100	4	1	607	250380	250984	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	146841	887	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
19837208	19837208	PRJNA722925_S_NODE_4236_length_217_cov_2.933333_g4173_i0	PRJNA722925	4236	217	2.933333	6.36533261	Segatella copri	165179	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|2784148841\|gb\|CP156891.1\|	165179	g4173	i0	100	454.764976958525	217	0	100	0	1	217	2082301	2082517	Segatella copri strain HDC01 chromosome 1	blastn	98684	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
23663283	23663283	PRJNA722925_S_NODE_10899_length_153_cov_1.008621_g10836_i0	PRJNA722925	10899	153	1.008621	1.54319013	Cruoricaptor ignavus	1118202	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|1919297446\|gb\|CP063145.1\|	1118202	g10836	i0	100	39.9607843137255	153	0	100	0	1	153	403417	403265	Cruoricaptor ignavus strain M1214 chromosome, complete genome	blastn	6114	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cruoricaptor	Cruoricaptor ignavus
24936785	24936785	PRJNA722925_S_NODE_1400_length_360_cov_16.430341_g1337_i0	PRJNA722925	1400	360	16.430341	59.1492276	Chryseobacterium sp. Y16C	2920939	Bacteria	Bacteria	610	4.489999999999999e-170	NTclustered	gi\|2204304890\|gb\|CP092711.1\|	2920939	g1337	i0	97.222	356.022222222222	360	10	100	0	1	360	2578182	2577823	Chryseobacterium sp. Y16C chromosome, complete genome	blastn	128168	610	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. Y16C
25420264	25420264	PRJNA722925_S_NODE_760_length_469_cov_2.587963_g698_i0	PRJNA722925	760	469	2.587963	12.13754647	Pedobacter	84567	Bacteria	Bacteria	660	0	NTclustered	gi\|1527210401\|gb\|CP034190.1\|	2482728	g698	i0	92.161	379.132196162047	472	30	100	7	1	469	1755945	1755478	Pedobacter sp. G11 chromosome	blastn	177813	662	0.996978851963746	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. G11
25420272	25420272	PRJNA722925_S_NODE_880_length_444_cov_4.162162_g817_i0	PRJNA722925	880	444	4.162162	18.47999928	Segatella	2974251	Bacteria	Bacteria	647	0	NTclustered	gi\|2733781693\|gb\|CP152350.1\|	165179	g817	i0	97.625	342.903153153153	379	6	85	3	1	377	1480389	1480012	Segatella copri strain HDA03 chromosome, complete genome	blastn	152249	647	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri

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