metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA811725" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA811725" and tax_phylum = "Bacteroidota"

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
2085649	2085649	PRJNA811725_P_NODE_26382_length_299_cov_2.902655_g26136_i0	PRJNA811725	26382	299	2.902655	8.67893845	Kaistella haifensis	421525	Bacteria	Bacteria	427	3.95e-115	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g26136	i0	91.718	2.18060200668896	326	0	100	1	1	299	2613799	2614124	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	652	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
4638384	4638384	PRJNA811725_P_NODE_21584_length_326_cov_3.343874_g21338_i0	PRJNA811725	21584	326	3.343874	10.90102924	Aquimarina sp. Aq107	1191912	Bacteria	Bacteria	355	2.09e-93	NTclustered	gi\|2261239293\|emb\|OX030782.1\|	1191912	g21338	i0	87.338	333.042944785276	308	29	94	6	1	307	325163	325461	Aquimarina sp. Aq107 genome assembly, chromosome: 1	blastn	108572	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. Aq107
4638407	4638407	PRJNA811725_P_NODE_24084_length_310_cov_3.388186_g23838_i0	PRJNA811725	24084	310	3.388186	10.5033766	Kaistella haifensis	421525	Bacteria	Bacteria	494	3.999999999999999e-135	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g23838	i0	94.025	3.08064516129032	318	11	100	1	1	310	651437	651120	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	955	494	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
4638410	4638410	PRJNA811725_P_NODE_24464_length_310_cov_2.586498_g24218_i0	PRJNA811725	24464	310	2.586498	8.0181438	Prevotella sp. oral taxon 475	712471	Bacteria	Bacteria	250	9.57e-62	NTclustered	gi\|2028838898\|gb\|CP072334.1\|	712471	g24218	i0	96.667	0.967741935483871	150	5	97	0	161	310	746669	746520	Prevotella sp. oral taxon 475 strain F0059 chromosome, complete genome	blastn	300	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 475
4638452	4638452	PRJNA811725_P_NODE_28724_length_289_cov_1.962963_g28478_i0	PRJNA811725	28724	289	1.962963	5.67296307	Pedobacter mucosus	2895286	Bacteria	Bacteria	161	4.26e-35	NTclustered	gi\|2192693946\|gb\|CP087585.1\|	2895286	g28478	i0	90.244	6.21107266435986	123	12	43	0	128	250	2508633	2508755	Pedobacter mucosus strain Q8-18 chromosome, complete genome	blastn	1795	161	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter mucosus
4638613	4638613	PRJNA811725_P_NODE_9384_length_483_cov_2.151220_g9140_i0	PRJNA811725	9384	483	2.15122	10.3903926	Flavobacterium aestivum	3003257	Bacteria	Bacteria	691	0	NTclustered	gi\|2477602438\|gb\|CP113977.2\|	3003257	g9140	i0	94.092	514.221532091097	457	23	94	3	29	483	191810	191356	Flavobacterium aestivum isolate IMCC34774 chromosome, complete genome	blastn	248369	691	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium aestivum
5913347	5913347	PRJNA811725_P_NODE_26225_length_299_cov_3.884956_g25979_i0	PRJNA811725	26225	299	3.884956	11.61601844	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	512	1.06e-140	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g25979	i0	97.368	6.49498327759197	304	3	100	1	1	299	3210745	3211048	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	1942	512	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
7602266	7602266	PRJNA811725_P_NODE_4726_length_661_cov_11.108844_g4491_i0	PRJNA811725	4726	661	11.108844	73.42945884	Flavobacterium	237	Bacteria	Bacteria	1066	0	NTclustered	gi\|2886028665\|gb\|CP176803.1\|	96345	g4491	i0	95.909	552.694402420575	660	23	100	4	1	658	1303880	1304537	Flavobacterium psychrophilum strain 2022-495 chromosome, complete genome	blastn	365331	1066	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
8462991	8462991	PRJNA811725_P_NODE_28707_length_289_cov_2.120370_g28461_i0	PRJNA811725	28707	289	2.12037	6.1278693	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	207	5.3900000000000004e-49	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g28461	i0	100	3.15916955017301	112	0	40	0	3	114	137079	137190	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	913	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
12289204	12289204	PRJNA811725_P_NODE_16330_length_374_cov_13.787375_g16084_i0	PRJNA811725	16330	374	13.787375	51.5647825	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	368	3.11e-97	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g16084	i0	84.615	1.00802139037433	377	50	99	6	1	373	991422	991794	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	377	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
12289270	12289270	PRJNA811725_P_NODE_24550_length_310_cov_2.270042_g24304_i0	PRJNA811725	24550	310	2.270042	7.0371302	Cloacibacterium caeni	2004710	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g24304	i0	100	3.84838709677419	150	0	97	0	1	150	1652067	1651918	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1193	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
12289348	12289348	PRJNA811725_P_NODE_34510_length_260_cov_1.604278_g34264_i0	PRJNA811725	34510	260	1.604278	4.1711228	Prevotella melaninogenica	28132	Bacteria	Bacteria	424	4.36e-114	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g34264	i0	97.581	7.97692307692308	248	5	95	1	1	247	75275	75522	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	2074	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
13563623	13563623	PRJNA811725_P_NODE_32611_length_272_cov_1.492462_g32365_i0	PRJNA811725	32611	272	1.492462	4.05949664	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	285	2.26e-72	NTclustered	gi\|2513399288\|emb\|OX638201.1\|	165435	g32365	i0	86.719	12.3897058823529	256	34	94	0	2	257	1368558	1368303	MAG: uncultured Flavobacterium sp. isolate ccd45242-ab75-41bb-baf2-9ba9f1fd70fe genome assembly, chromosome: 1	blastn	3370	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
13977738	13977738	PRJNA811725_P_NODE_19531_length_343_cov_1.585185_g19285_i0	PRJNA811725	19531	343	1.585185	5.43718455	Porphyromonas	836	Bacteria	Bacteria	628	1.1799999999999997e-175	NTclustered	gi\|1274923455\|gb\|CP024600.1\|	837	g19285	i0	99.708	36	343	1	100	0	1	343	970425	970083	Porphyromonas gingivalis strain KCOM 2801 chromosome, complete genome	blastn	12348	628	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
14838208	14838208	PRJNA811725_P_NODE_32912_length_270_cov_2.857868_g32666_i0	PRJNA811725	32912	270	2.857868	7.7162436	Phocaeicola coprophilus	387090	Bacteria	Bacteria	276	1.35e-69	NTclustered	gi\|1985970415\|gb\|CP069440.1\|	387090	g32666	i0	87.243	32.0740740740741	243	29	90	2	29	270	3247249	3247490	Phocaeicola coprophilus strain FDAARGOS_1220 chromosome, complete genome	blastn	8660	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola coprophilus
16112338	16112338	PRJNA811725_P_NODE_19053_length_347_cov_2.631387_g18807_i0	PRJNA811725	19053	347	2.631387	9.13091289	Flavobacterium faecale	1355330	Bacteria	Bacteria	403	7.87e-108	NTclustered	gi\|2922046464\|gb\|CP182943.1\|	1355330	g18807	i0	87.791	95.1325648414986	344	42	99	0	2	345	2888525	2888868	Flavobacterium faecale strain WV33 chromosome, complete genome	blastn	33011	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium faecale
16112380	16112380	PRJNA811725_P_NODE_24093_length_310_cov_3.367089_g23847_i0	PRJNA811725	24093	310	3.367089	10.4379759	Prevotella scopos	589437	Bacteria	Bacteria	198	3.5199999999999995e-46	NTclustered	gi\|1043183637\|gb\|CP016205.1\|	1236518	g23847	i0	91.096	51.1774193548387	146	13	47	0	1	146	1370350	1370495	Prevotella scopos JCM 17725 strain W2052 chromosome 2 genome	blastn	15865	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella scopos
17388310	17388310	PRJNA811725_P_NODE_26894_length_297_cov_4.165179_g26648_i0	PRJNA811725	26894	297	4.165179	12.37058163	Cloacibacterium normanense	237258	Bacteria	Bacteria	518	2.26e-142	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g26648	i0	98	4.04040404040404	300	3	100	2	1	297	1333718	1333419	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1200	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
21212248	21212248	PRJNA811725_P_NODE_6137_length_590_cov_5.292070_g5898_i0	PRJNA811725	6137	590	5.29207	31.223213	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	1035	0	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g5898	i0	99.822	477.379661016949	563	1	95	0	1	563	669434	668872	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	281654	1035	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei

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