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

32 rows where analysis = "blastn", bioproject = "PRJNA290839" 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
372907	372907	PRJNA290839_P_NODE_1581_length_243_cov_0.911765_g1560_i0	PRJNA290839	1581	243	0.911765	2.21558895	Prevotella nigrescens	28133	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2028843725\|gb\|CP072339.1\|	28133	g1560	i0	96.721	18.2181069958848	244	7	100	1	1	243	1782031	1781788	Prevotella nigrescens strain F0109 chromosome 1, complete sequence	blastn	4427	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
372912	372912	PRJNA290839_P_NODE_761_length_292_cov_1.776256_g740_i0	PRJNA290839	761	292	1.776256	5.18666752	Bacteroidales bacterium	2030927	Bacteria	Bacteria	209	1.52e-49	NTclustered	gi\|2621700911\|emb\|OY759745.1\|	2030927	g740	i0	81.818	170.280821917808	253	42	86	4	41	291	637359	637109	MAG: Bacteroidales bacterium isolate 6557e7a1-78fa-4815-bf71-3c9d2683966d genome assembly, chromosome: 1	blastn	49722	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
372915	372915	PRJNA290839_P_NODE_981_length_256_cov_1.863388_g960_i0	PRJNA290839	981	256	1.863388	4.77027328	Pseudoprevotella muciniphila	2133944	Bacteria	Bacteria	257	4.6e-64	NTclustered	gi\|1765929929\|gb\|CP033459.1\|	2133944	g960	i0	85.2	128.39453125	250	37	98	0	7	256	2326640	2326889	Pseudoprevotella muciniphila strain E39 chromosome, complete genome	blastn	32869	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Pseudoprevotella	Pseudoprevotella muciniphila
1647638	1647638	PRJNA290839_P_NODE_1562_length_243_cov_0.917647_g1541_i0	PRJNA290839	1562	243	0.917647	2.22988221	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	213	9.49e-51	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g1541	i0	83.262	0.958847736625514	233	38	95	1	12	243	915409	915641	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	233	213	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
1647643	1647643	PRJNA290839_P_NODE_942_length_261_cov_1.351064_g921_i0	PRJNA290839	942	261	1.351064	3.52627704	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	289	1.67e-73	NTclustered	gi\|2621702112\|emb\|OY760143.1\|	2748031	g921	i0	87.698	242.727969348659	252	26	95	5	8	256	1472321	1472072	MAG: Paludibacteraceae bacterium isolate 01c8064d-6cbe-49cb-b462-9ef0373b1e27 genome assembly, chromosome: 1	blastn	63352	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
3610010	3610010	PRJNA290839_P_NODE_263_length_525_cov_0.869469_g242_i0	PRJNA290839	263	525	0.869469	4.56471225	Cytophagales	768507	Bacteria	Bacteria	322	3.55e-83	NTclustered	gi\|2808418640\|gb\|CP159481.1\|	1297121	g242	i0	79.736	193.788571428571	454	85	86	7	12	462	780176	780625	Cyclobacterium xiamenense strain ac3 chromosome, complete genome	blastn	101739	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cyclobacterium	Cyclobacterium xiamenense
4200036	4200036	PRJNA290839_P_NODE_1444_length_245_cov_0.906977_g1423_i0	PRJNA290839	1444	245	0.906977	2.22209365	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	220	5.73e-53	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g1423	i0	83.913	1.48571428571429	230	37	94	0	12	241	1013531	1013302	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	364	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
5476359	5476359	PRJNA290839_P_NODE_1025_length_253_cov_0.866667_g1004_i0	PRJNA290839	1025	253	0.866667	2.19266751	Parabacteroides distasonis	823	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2290784043\|gb\|CP103242.1\|	823	g1004	i0	99.605	554.893280632411	253	1	100	0	1	253	248652	248400	Parabacteroides distasonis strain BFG-275 chromosome, complete genome	blastn	140388	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
6162293	6162293	PRJNA290839_P_NODE_25_length_1795_cov_10.691057_g15_i0	PRJNA290839	25	1795	10.691057	191.90447315	Prevotella	838	Bacteria	Bacteria	2822	0	NTclustered	gi\|1276663706\|gb\|CP024723.1\|	28131	g15	i0	95.017	210.508635097493	1806	75	100	12	1	1795	982927	981126	Prevotella intermedia strain KCOM 2837 chromosome 1, complete sequence	blastn	377863	2832	0.996468926553672	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
8026200	8026200	PRJNA290839_P_NODE_27_length_1723_cov_10.807273_g15_i1	PRJNA290839	27	1723	10.807273	186.20931379	Prevotella melaninogenica	28132	Bacteria	Bacteria	2584	0	NTclustered	gi\|1239343847\|dbj\|AP018050.1\|	28132	g15	i1	93.75	214.983749274521	1728	99	100	8	1	1723	266313	264590	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	370417	2584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
9300974	9300974	PRJNA290839_P_NODE_1528_length_244_cov_0.900585_g1507_i0	PRJNA290839	1528	244	0.900585	2.1974274	Prevotella melaninogenica	28132	Bacteria	Bacteria	344	3.2399999999999993e-90	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g1507	i0	92.181	13.5532786885246	243	19	99	0	1	243	1641504	1641262	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	3307	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
10576832	10576832	PRJNA290839_P_NODE_29_length_1722_cov_8.053972_g15_i2	PRJNA290839	29	1722	8.053972	138.68939784	Prevotella melaninogenica	28132	Bacteria	Bacteria	3092	0	NTclustered	gi\|1239343847\|dbj\|AP018050.1\|	28132	g15	i2	99.071	225.867015098722	1723	15	100	1	1	1722	266312	264590	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	388943	3092	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
10576835	10576835	PRJNA290839_P_NODE_769_length_291_cov_1.426606_g748_i0	PRJNA290839	769	291	1.426606	4.15142346	Prevotella melaninogenica	28132	Bacteria	Bacteria	532	7.9e-147	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g748	i0	99.656	81.7388316151203	291	1	100	0	1	291	1190615	1190325	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	23786	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
11262650	11262650	PRJNA290839_P_NODE_1449_length_245_cov_0.906977_g1428_i0	PRJNA290839	1449	245	0.906977	2.22209365	Hymenobacter	89966	Bacteria	Bacteria	172	1.63e-38	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g1428	i0	82.564	64.9265306122449	195	34	80	0	1	195	3276283	3276477	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	15907	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
11851567	11851567	PRJNA290839_P_NODE_110_length_899_cov_2.349879_g90_i0	PRJNA290839	110	899	2.349879	21.12541221	Hoylesella enoeca	76123	Bacteria	Bacteria	1282	0	NTclustered	gi\|953017979\|gb\|CP013195.1\|	76123	g90	i0	92.453	236.222469410456	901	63	100	4	1	899	384282	383385	Hoylesella enoeca strain F0113 chromosome, complete genome	blastn	212364	1282	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella enoeca
13126716	13126716	PRJNA290839_P_NODE_1471_length_245_cov_0.901163_g1450_i0	PRJNA290839	1471	245	0.901163	2.20784935	Prevotella melaninogenica	28132	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g1450	i0	99.184	7.97142857142857	245	2	100	0	1	245	770989	770745	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	1953	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
13812868	13812868	PRJNA290839_P_NODE_1331_length_247_cov_0.896552_g1310_i0	PRJNA290839	1331	247	0.896552	2.21448344	Duncaniella	2518495	Bacteria	Bacteria	357	4.22e-94	NTclustered	gi\|2445454812\|gb\|OQ450188.1\|	2301481	g1310	i0	93.061	226.886639676113	245	16	99	1	1	244	2805	3049	Uncultured Muribaculaceae bacterium clone Long_Read_Consensus_FHFX_043 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56041	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		uncultured Muribaculaceae bacterium
14401867	14401867	PRJNA290839_P_NODE_1652_length_242_cov_0.905325_g1631_i0	PRJNA290839	1652	242	0.905325	2.1908865	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	121	5.889999999999999e-23	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g1631	i0	98.529	0.28099173553719	68	1	28	0	172	239	2412972	2412905	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	68	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
15087090	15087090	PRJNA290839_P_NODE_1012_length_253_cov_1.283333_g991_i0	PRJNA290839	1012	253	1.283333	3.24683249	Cloacibacterium	501783	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g991	i0	99.605	470.106719367589	253	1	100	0	1	253	2158487	2158235	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	118937	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
15675627	15675627	PRJNA290839_P_NODE_1133_length_251_cov_0.865169_g1112_i0	PRJNA290839	1133	251	0.865169	2.17157419	Prevotella intermedia	28131	Bacteria	Bacteria	429	8.99e-116	NTclustered	gi\|1276701046\|gb\|CP024696.1\|	28131	g1112	i0	97.6	24.2788844621514	250	6	99	0	2	251	275272	275521	Prevotella intermedia strain KCOM 2033 chromosome, complete genome	blastn	6094	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
16361967	16361967	PRJNA290839_P_NODE_533_length_352_cov_1.530466_g512_i0	PRJNA290839	533	352	1.530466	5.38724032	Bacteroidota	976	Bacteria	Bacteria	636	7.219999999999999e-178	NTclustered	gi\|14537958\|gb\|AF385549.1\|	163555	g512	i0	99.148	99.6477272727273	352	3	100	0	1	352	352	1	Flavobacterium-like sp. oral clone AZ123 16S ribosomal RNA gene, partial sequence	blastn	35076	640	0.99375	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium-like sp. oral clone AZ123
16950302	16950302	PRJNA290839_P_NODE_734_length_298_cov_2.697778_g713_i0	PRJNA290839	734	298	2.697778	8.03937844	Prevotella intermedia	28131	Bacteria	Bacteria	431	3.04e-116	NTclustered	gi\|1276663706\|gb\|CP024723.1\|	28131	g713	i0	92.667	248.241610738255	300	20	100	2	1	298	981697	981398	Prevotella intermedia strain KCOM 2837 chromosome 1, complete sequence	blastn	73976	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
19498813	19498813	PRJNA290839_P_NODE_1136_length_251_cov_0.865169_g1115_i0	PRJNA290839	1136	251	0.865169	2.17157419	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	353	5.569999999999998e-93	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g1115	i0	92.032	100.03187250996	251	20	100	0	1	251	558669	558919	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	25108	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
19498824	19498824	PRJNA290839_P_NODE_996_length_255_cov_1.269231_g975_i0	PRJNA290839	996	255	1.269231	3.23653905	Hoylesella enoeca	76123	Bacteria	Bacteria	422	1.53e-113	NTclustered	gi\|953017979\|gb\|CP013195.1\|	76123	g975	i0	96.471	83.243137254902	255	9	100	0	1	255	1263584	1263330	Hoylesella enoeca strain F0113 chromosome, complete genome	blastn	21227	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella enoeca
20774374	20774374	PRJNA290839_P_NODE_1617_length_242_cov_0.923077_g1596_i0	PRJNA290839	1617	242	0.923077	2.23384634	Prevotella intermedia	28131	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|1132727451\|gb\|CP019300.1\|	1122984	g1596	i0	99.174	19	242	2	100	0	1	242	571321	571562	Prevotella intermedia ATCC 25611 = DSM 20706 strain ATCC 25611 chromosome I, complete sequence	blastn	4598	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
20774376	20774376	PRJNA290839_P_NODE_677_length_310_cov_1.316456_g656_i0	PRJNA290839	677	310	1.316456	4.0810136	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	219	2.7e-52	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g656	i0	83.983	16.1354838709677	231	34	74	3	81	309	1977247	1977476	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	5002	219	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
21461248	21461248	PRJNA290839_P_NODE_557_length_345_cov_0.878676_g536_i0	PRJNA290839	557	345	0.878676	3.0314322	Bacteroides	816	Bacteria	Bacteria	375	1.7099999999999998e-99	NTclustered	gi\|1586077253\|gb\|CP036491.1\|	2528203	g536	i0	86.726	93.0405797101449	339	43	98	2	8	345	3094253	3094590	Bacteroides sp. A1C1 chromosome, complete genome	blastn	32099	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. A1C1
22049323	22049323	PRJNA290839_P_NODE_1058_length_252_cov_0.871508_g1037_i0	PRJNA290839	1058	252	0.871508	2.19620016	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	353	5.59e-93	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g1037	i0	92.126	502.718253968254	254	15	100	4	1	252	956016	956266	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	126685	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
22049332	22049332	PRJNA290839_P_NODE_498_length_365_cov_3.157534_g477_i0	PRJNA290839	498	365	3.157534	11.5249991	Bergeyella cardium	1585976	Bacteria	Bacteria	531	3.65e-146	NTclustered	gi\|2504455906\|gb\|CP121693.1\|	1585976	g477	i0	92.896	378.706849315068	366	24	100	2	1	365	994399	994035	Bergeyella cardium strain BC chromosome, complete genome	blastn	138228	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium
23324948	23324948	PRJNA290839_P_NODE_1139_length_250_cov_2.203390_g1118_i0	PRJNA290839	1139	250	2.20339	5.508475	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g1118	i0	97.2	404.208	250	7	100	0	1	250	1420	1171	Pedobacter sp. SL55 chromosome	blastn	101052	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
24599005	24599005	PRJNA290839_P_NODE_440_length_389_cov_1.221519_g419_i0	PRJNA290839	440	389	1.221519	4.75170891	Prevotella intermedia	28131	Bacteria	Bacteria	399	1.1499999999999998e-106	NTclustered	gi\|1276666115\|gb\|CP024725.1\|	28131	g419	i0	85.459	306.233933161954	392	47	99	9	1	388	1480966	1480581	Prevotella intermedia strain KCOM 2838 chromosome 1, complete sequence	blastn	119125	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
24599007	24599007	PRJNA290839_P_NODE_640_length_320_cov_1.882591_g619_i0	PRJNA290839	640	320	1.882591	6.0242912	Epilithonimonas zeae	1416779	Bacteria	Bacteria	575	1.44e-159	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g619	i0	99.062	518.425	320	3	100	0	1	320	2242016	2241697	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	165896	575	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae

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