metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1174770" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1174770" 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
2867143	2867143	PRJNA1174770_P_NODE_8343_length_168_cov_0.873950_g8254_i0	PRJNA1174770	8343	168	0.87395	1.468236	Prevotella melaninogenica	28132	Bacteria	Bacteria	289	9.879999999999999e-74	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g8254	i0	97.619	13.875	168	4	100	0	1	168	1120044	1119877	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	2331	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
2867153	2867153	PRJNA1174770_P_NODE_9303_length_166_cov_1.299145_g9214_i0	PRJNA1174770	9303	166	1.299145	2.1565807	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	235	1.2899999999999998e-57	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g9214	i0	93.21	227.319277108434	162	8	96	3	7	166	443352	443192	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	37735	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
5419352	5419352	PRJNA1174770_P_NODE_5805_length_193_cov_1.687500_g5716_i0	PRJNA1174770	5805	193	1.6875	3.256875	Mucilaginibacter sp. M24C8	1713024	Bacteria	Bacteria	291	3.2399999999999994e-74	NTclustered	gi\|939371427\|gb\|KJ654641.1\|	1713024	g5716	i0	95.58	101.062176165803	181	8	94	0	13	193	21	201	Mucilaginibacter sp. M24C8 16S ribosomal RNA gene, partial sequence	blastn	19505	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. M24C8
5419368	5419368	PRJNA1174770_P_NODE_7825_length_169_cov_1.733333_g7736_i0	PRJNA1174770	7825	169	1.733333	2.92933277	Prevotella sp. oral taxon 299	652716	Bacteria	Bacteria	230	6.0699999999999995e-56	NTclustered	gi\|532125950\|gb\|CP003666.1\|	575614	g7736	i0	91.124	1	169	15	100	0	1	169	524233	524065	Prevotella sp. oral taxon 299 str. F0039, complete genome	blastn	169	230	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 299
6143915	6143915	PRJNA1174770_P_NODE_9345_length_166_cov_0.888889_g9256_i0	PRJNA1174770	9345	166	0.888889	1.47555574	Tannerella	195950	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|363406024\|gb\|CP003191.1\|	203275	g9256	i0	100	3	166	0	100	0	1	166	537880	538045	Tannerella forsythia 92A2, complete genome	blastn	498	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella forsythia
6694243	6694243	PRJNA1174770_P_NODE_8246_length_168_cov_0.873950_g8157_i0	PRJNA1174770	8246	168	0.87395	1.468236	Segatella oris	28135	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g8157	i0	99.405	1	168	1	100	0	1	168	2199460	2199293	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	168	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
7969604	7969604	PRJNA1174770_P_NODE_9727_length_166_cov_0.871795_g9638_i0	PRJNA1174770	9727	166	0.871795	1.4471797	Prevotella nigrescens	28133	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|2028845652\|gb\|CP072341.1\|	702439	g9638	i0	98.193	21.1746987951807	166	3	100	0	1	166	2089268	2089433	Prevotella nigrescens F0103 chromosome 1, complete sequence	blastn	3515	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
9244203	9244203	PRJNA1174770_P_NODE_1828_length_356_cov_2.436482_g1739_i0	PRJNA1174770	1828	356	2.436482	8.67387592	Mucilaginibacter jinjuensis	1176721	Bacteria	Bacteria	508	1.66e-139	NTclustered	gi\|2442599841\|gb\|CP117167.1\|	1176721	g1739	i0	92.938	405.441011235955	354	18	99	7	6	356	5329529	5329180	Mucilaginibacter jinjuensis strain KACC 16571 chromosome, complete genome	blastn	144337	508	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter jinjuensis
11794924	11794924	PRJNA1174770_P_NODE_9690_length_166_cov_0.880342_g9601_i0	PRJNA1174770	9690	166	0.880342	1.46136772	Tannerella serpentiformis	712710	Bacteria	Bacteria	303	3.48e-78	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g9601	i0	100	1.97590361445783	164	0	99	0	1	164	1412563	1412400	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	328	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
13069882	13069882	PRJNA1174770_P_NODE_3451_length_250_cov_1.955224_g3362_i0	PRJNA1174770	3451	250	1.955224	4.88806	Mucilaginibacter ginkgonis	2682091	Bacteria	Bacteria	401	1.9499999999999994e-107	NTclustered	gi\|1953477154\|gb\|CP066775.1\|	2682091	g3362	i0	95.6	309.18	250	11	100	0	1	250	2177827	2177578	Mucilaginibacter ginkgonis strain HMF7856 chromosome, complete genome	blastn	77295	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginkgonis
15619032	15619032	PRJNA1174770_P_NODE_3413_length_252_cov_1.704433_g3324_i0	PRJNA1174770	3413	252	1.704433	4.29517116	Cloacibacterium caeni	2004710	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g3324	i0	99.602	366.269841269841	251	1	99	0	2	252	1872179	1872429	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	92300	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
16343537	16343537	PRJNA1174770_P_NODE_4933_length_208_cov_2.264151_g4844_i0	PRJNA1174770	4933	208	2.264151	4.70943408	Cloacibacterium	501783	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g4844	i0	99.519	487.100961538462	208	1	100	0	1	208	129504	129297	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	101317	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
18167886	18167886	PRJNA1174770_P_NODE_12355_length_162_cov_0.902655_g12266_i0	PRJNA1174770	12355	162	0.902655	1.4623011	Porphyromonas cangingivalis	36874	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1540237777\|emb\|LR134506.1\|	36874	g12266	i0	100	1	162	0	100	0	1	162	333065	332904	Porphyromonas cangingivalis strain NCTC12856 genome assembly, chromosome: 1	blastn	162	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas cangingivalis
21442899	21442899	PRJNA1174770_P_NODE_10257_length_165_cov_0.887931_g10168_i0	PRJNA1174770	10257	165	0.887931	1.46508615	Empedobacter	59734	Bacteria	Bacteria	261	2.11e-65	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g10168	i0	95.152	309.551515151515	165	8	100	0	1	165	228363	228527	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	51076	261	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
21442901	21442901	PRJNA1174770_P_NODE_10517_length_164_cov_1.356522_g10428_i0	PRJNA1174770	10517	164	1.356522	2.22469608	Flavobacterium	237	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2643654678\|gb\|CP136574.1\|	239	g10428	i0	100	561.207317073171	164	0	100	0	1	164	235708	235871	MAG: Flavobacterium sp. isolate GU0601_MAG5 chromosome, complete genome	blastn	92038	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
21442965	21442965	PRJNA1174770_P_NODE_7637_length_171_cov_1.368852_g7548_i0	PRJNA1174770	7637	171	1.368852	2.34073692	Bacteroidales	171549	Bacteria	Bacteria	217	4.8e-52	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g7548	i0	89.881	296.719298245614	168	17	100	0	1	168	442317	442484	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	50739	219	0.990867579908676	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
21442983	21442983	PRJNA1174770_P_NODE_9677_length_166_cov_0.880342_g9588_i0	PRJNA1174770	9677	166	0.880342	1.46136772	Prevotella	838	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2028882546\|gb\|CP072373.1\|	28129	g9588	i0	100	44.5602409638554	166	0	100	0	1	166	1799425	1799590	Prevotella denticola strain F0119 chromosome, complete genome	blastn	7397	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
23268457	23268457	PRJNA1174770_P_NODE_12099_length_162_cov_0.920354_g12010_i0	PRJNA1174770	12099	162	0.920354	1.49097348	Segatella oris	28135	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g12010	i0	100	1	162	0	100	0	1	162	1133253	1133414	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	162	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
24542225	24542225	PRJNA1174770_P_NODE_11220_length_163_cov_0.912281_g11131_i0	PRJNA1174770	11220	163	0.912281	1.48701803	Prevotella sp. oral taxon 299	652716	Bacteria	Bacteria	182	1.66e-41	NTclustered	gi\|532125950\|gb\|CP003666.1\|	575614	g11131	i0	87.037	0.993865030674847	162	19	99	2	1	161	344899	345059	Prevotella sp. oral taxon 299 str. F0039, complete genome	blastn	162	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 299
25267249	25267249	PRJNA1174770_P_NODE_1380_length_421_cov_3.086022_g1291_i0	PRJNA1174770	1380	421	3.086022	12.99215262	Cloacibacterium	501783	Bacteria	Bacteria	778	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1291	i0	100	491.282660332542	421	0	100	0	1	421	129716	130136	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	206830	778	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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