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

29 rows where analysis = "blastn", bioproject = "PRJEB48872" 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
86379	86379	PRJEB48872_P_NODE_602141_length_168_cov_1.271318_g586329_i0	PRJEB48872	602141	168	1.271318	2.13581424	Segatella oris	28135	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g586329	i0	98.81	278.684523809524	168	2	100	0	1	168	440580	440747	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	46819	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
2265998	2265998	PRJEB48872_P_NODE_528362_length_186_cov_1.081633_g512550_i0	PRJEB48872	528362	186	1.081633	2.01183738	Prevotella	838	Bacteria	Bacteria	327	2.36e-85	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g512550	i0	98.387	231.016129032258	186	3	100	0	1	186	594793	594608	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	42969	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
2266018	2266018	PRJEB48872_P_NODE_558242_length_178_cov_1.388489_g542430_i0	PRJEB48872	558242	178	1.388489	2.47151042	Prevotella	838	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g542430	i0	98.876	224.095505617978	178	2	100	0	1	178	168847	168670	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	39889	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
3913724	3913724	PRJEB48872_P_NODE_628664_length_162_cov_2.260163_g612852_i0	PRJEB48872	628664	162	2.260163	3.66146406	Proteiniphilum propionicum	2829812	Bacteria	Bacteria	211	2.1e-50	NTclustered	gi\|2194522320\|gb\|CP073586.1\|	2829812	g612852	i0	90.123	13.8888888888889	162	16	100	0	1	162	1724857	1724696	Proteiniphilum propionicum strain JNU-WLY501 chromosome, complete genome	blastn	2250	211	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Proteiniphilum	Proteiniphilum propionicum
4818744	4818744	PRJEB48872_P_NODE_653364_length_158_cov_1.033613_g637552_i0	PRJEB48872	653364	158	1.033613	1.63310854	Hymenobacter	89966	Bacteria	Bacteria	276	7.120000000000001e-70	NTclustered	gi\|1041495553\|gb\|KU758882.1\|	1867102	g637552	i0	100	97.6455696202532	149	0	94	0	10	158	65	213	Hymenobacter sp. 16F3Y 16S ribosomal RNA gene, partial sequence	blastn	15428	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 16F3Y
5183477	5183477	PRJEB48872_P_NODE_49445_length_1069_cov_4.624272_g37643_i0	PRJEB48872	49445	1069	4.624272	49.43346768	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	1162	0	NTclustered	gi\|2874253714\|emb\|OY969556.1\|	152509	g37643	i0	86.376	329.913002806361	1079	129	99	17	3	1069	170251	169179	MAG: uncultured Bacteroidetes bacterium isolate MFD09286.bin.c.1 genome assembly, chromosome: 1	blastn	352677	1162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
6093698	6093698	PRJEB48872_P_NODE_145005_length_492_cov_3.713024_g129271_i0	PRJEB48872	145005	492	3.713024	18.26807808	Cloacibacterium	501783	Bacteria	Bacteria	630	4.849999999999999e-176	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g129271	i0	98.867	467.563008130081	353	4	72	0	140	492	130505	130153	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	230041	630	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
6093732	6093732	PRJEB48872_P_NODE_263945_length_316_cov_2.624549_g248133_i0	PRJEB48872	263945	316	2.624549	8.29357484	Spirosoma	107	Bacteria	Bacteria	235	2.74e-57	NTclustered	gi\|1142450876\|gb\|CP014263.1\|	1178516	g248133	i0	90.857	25.5601265822785	175	16	55	0	6	180	3067023	3066849	Spirosoma montaniterrae strain DY10 chromosome, complete genome	blastn	8077	237	0.991561181434599	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
6448052	6448052	PRJEB48872_P_NODE_259546_length_320_cov_2.451957_g243734_i0	PRJEB48872	259546	320	2.451957	7.8462624	Spirosoma sp. KCTC 42546	2520506	Bacteria	Bacteria	496	1.15e-135	NTclustered	gi\|1702113944\|gb\|CP041360.1\|	2520506	g243734	i0	94.688	294.790625	320	15	100	2	1	320	677550	677233	Spirosoma sp. KCTC 42546 chromosome, complete genome	blastn	94333	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KCTC 42546
6467815	6467815	PRJEB48872_P_NODE_672186_length_154_cov_2.008696_g656374_i0	PRJEB48872	672186	154	2.008696	3.09339184	Lacibacter sediminis	2760713	Bacteria	Bacteria	257	2.5e-64	NTclustered	gi\|1888315716\|gb\|CP060007.1\|	2760713	g656374	i0	96.753	268.116883116883	154	5	100	0	1	154	867379	867532	Lacibacter sediminis strain S13-6-22 chromosome, complete genome	blastn	41290	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sediminis
7368117	7368117	PRJEB48872_P_NODE_161266_length_455_cov_3.310096_g145489_i0	PRJEB48872	161266	455	3.310096	15.0609368	Spirosoma	107	Bacteria	Bacteria	409	2.2699999999999996e-109	NTclustered	gi\|1702113944\|gb\|CP041360.1\|	2520506	g145489	i0	94.697	191.342857142857	264	12	97	1	191	454	677058	677319	Spirosoma sp. KCTC 42546 chromosome, complete genome	blastn	87061	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KCTC 42546
7368184	7368184	PRJEB48872_P_NODE_320266_length_273_cov_2.816239_g304454_i0	PRJEB48872	320266	273	2.816239	7.68833247	Pedobacter	84567	Bacteria	Bacteria	385	2.18e-102	NTclustered	gi\|1272249552\|gb\|CP024091.1\|	363852	g304454	i0	92.251	338.472527472527	271	21	99	0	3	273	49623	49893	Pedobacter ginsengisoli strain T01R-27 chromosome, complete genome	blastn	92403	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ginsengisoli
7739374	7739374	PRJEB48872_P_NODE_616347_length_165_cov_1.301587_g600535_i0	PRJEB48872	616347	165	1.301587	2.14761855	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	259	7.57e-65	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g600535	i0	95.152	440.939393939394	165	7	100	1	1	165	443158	443321	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	72755	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
8996654	8996654	PRJEB48872_P_NODE_249688_length_330_cov_1.670103_g233876_i0	PRJEB48872	249688	330	1.670103	5.5113399	Hymenobacter sedentarius	1411621	Bacteria	Bacteria	527	4.229999999999999e-145	NTclustered	gi\|972940812\|gb\|CP013909.1\|	1411621	g233876	i0	95.455	137.79696969697	330	15	100	0	1	330	386916	387245	Hymenobacter sedentarius strain DG5B chromosome, complete genome	blastn	45473	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sedentarius
9013713	9013713	PRJEB48872_P_NODE_604828_length_167_cov_1.921875_g589016_i0	PRJEB48872	604828	167	1.921875	3.20953125	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g589016	i0	97.006	507.065868263473	167	5	100	0	1	167	444953	445119	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	84680	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
9918793	9918793	PRJEB48872_P_NODE_174048_length_430_cov_3.790281_g158252_i0	PRJEB48872	174048	430	3.790281	16.2982083	Cloacibacterium	501783	Bacteria	Bacteria	756	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g158252	i0	98.372	465.611627906977	430	7	100	0	1	430	1872706	1872277	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	200213	756	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
10267877	10267877	PRJEB48872_P_NODE_151309_length_477_cov_2.728311_g135553_i0	PRJEB48872	151309	477	2.728311	13.01404347	Pseudocnuella soli	2502779	Bacteria	Bacteria	699	0	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g135553	i0	93.319	410.127882599581	479	22	99	9	1	476	1186270	1185799	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	195631	699	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
11562730	11562730	PRJEB48872_P_NODE_564230_length_176_cov_2.437956_g548418_i0	PRJEB48872	564230	176	2.437956	4.29080256	Pseudocnuella soli	2502779	Bacteria	Bacteria	287	3.74e-73	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g548418	i0	96.023	320.880681818182	176	7	100	0	1	176	1188146	1188321	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	56475	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
13744208	13744208	PRJEB48872_P_NODE_585451_length_171_cov_2.931818_g569639_i0	PRJEB48872	585451	171	2.931818	5.01340878	Flavobacterium	237	Bacteria	Bacteria	289	1e-73	NTclustered	gi\|2886028665\|gb\|CP176803.1\|	96345	g569639	i0	97.619	547.456140350877	168	4	98	0	1	168	1837	2004	Flavobacterium psychrophilum strain 2022-495 chromosome, complete genome	blastn	93615	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
15369446	15369446	PRJEB48872_P_NODE_200733_length_388_cov_1.667622_g184926_i0	PRJEB48872	200733	388	1.667622	6.47037336	Flavobacterium okayamense	2830782	Bacteria	Bacteria	305	2.58e-78	NTclustered	gi\|2062617959\|dbj\|AP024749.1\|	2830782	g184926	i0	81.818	604.925257731959	374	59	96	7	4	372	1222258	1221889	Flavobacterium sp. KK2020170 DNA, complete genome	blastn	234711	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium okayamense
16655321	16655321	PRJEB48872_P_NODE_442994_length_213_cov_1.160920_g427182_i0	PRJEB48872	442994	213	1.16092	2.4727596	Segatella oris	28135	Bacteria	Bacteria	388	1.26e-103	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g427182	i0	99.531	213.089201877934	213	1	100	0	1	213	1249396	1249184	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	45388	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
17568360	17568360	PRJEB48872_P_NODE_160774_length_456_cov_3.508393_g144999_i0	PRJEB48872	160774	456	3.508393	15.99827208	Cloacibacterium	501783	Bacteria	Bacteria	525	2.1699999999999993e-144	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g144999	i0	96.53	473.907894736842	317	11	70	0	140	456	130505	130189	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	216102	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
17929709	17929709	PRJEB48872_P_NODE_433735_length_216_cov_2.118644_g417923_i0	PRJEB48872	433735	216	2.118644	4.57627104	Prevotella multiformis	282402	Bacteria	Bacteria	291	3.709999999999999e-74	NTclustered	gi\|2028862730\|gb\|CP072357.1\|	282402	g417923	i0	96.571	211.606481481481	175	6	81	0	42	216	3601	3427	Prevotella multiformis strain F0096 chromosome 1, complete sequence	blastn	45707	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella multiformis
19207772	19207772	PRJEB48872_P_NODE_519156_length_188_cov_1.738255_g503344_i0	PRJEB48872	519156	188	1.738255	3.2679194	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	265	1.9000000000000001e-66	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g503344	i0	92.432	411.941489361702	185	14	100	0	1	185	1236259	1236443	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	77445	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
20469827	20469827	PRJEB48872_P_NODE_238417_length_341_cov_2.480132_g222605_i0	PRJEB48872	238417	341	2.480132	8.45725012	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	577	4.299999999999999e-160	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g222605	i0	97.085	274.346041055719	343	8	100	2	1	341	339203	338861	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	93552	577	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
23031182	23031182	PRJEB48872_P_NODE_455739_length_208_cov_1.479290_g439927_i0	PRJEB48872	455739	208	1.47929	3.0769232	Hymenobacter sp. 5317J-9	2932250	Bacteria	Bacteria	313	7.569999999999998e-81	NTclustered	gi\|2221939013\|gb\|CP095050.1\|	2932250	g439927	i0	93.81	240.461538461538	210	9	100	4	1	208	596404	596197	Hymenobacter sp. 5317J-9 chromosome, complete genome	blastn	50016	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 5317J-9
23942972	23942972	PRJEB48872_P_NODE_380419_length_239_cov_3.190000_g364607_i0	PRJEB48872	380419	239	3.19	7.6241	Spirosoma	107	Bacteria	Bacteria	348	2.4500000000000002e-91	NTclustered	gi\|1163018612\|gb\|CP020105.1\|	564064	g364607	i0	92.887	289.380753138075	239	17	100	0	1	239	1093797	1094035	Spirosoma rigui strain KCTC 12531 chromosome, complete genome	blastn	69162	351	0.991452991452991	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rigui
23942984	23942984	PRJEB48872_P_NODE_410079_length_226_cov_1.652406_g394267_i0	PRJEB48872	410079	226	1.652406	3.73443756	root	1	Root_unresolved	Root_unresolved	412	8.01e-111	NTclustered	gi\|332002488\|gb\|JF803557.1\|	28129	g394267	i0	99.558	105.991150442478	226	1	100	0	1	226	312	537	Prevotella denticola strain C1134 16S ribosomal RNA gene, partial sequence	blastn	23954	414	0.995169082125604	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
24314322	24314322	PRJEB48872_P_NODE_647600_length_159_cov_1.283333_g631788_i0	PRJEB48872	647600	159	1.283333	2.04049947	Arachidicoccus soli	2341117	Bacteria	Bacteria	198	1.6e-46	NTclustered	gi\|1483497402\|gb\|CP032489.1\|	2341117	g631788	i0	91.667	225.163522012579	144	11	90	1	1	143	250928	250785	Arachidicoccus soli strain KIS59-12 chromosome, complete genome	blastn	35801	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Arachidicoccus	Arachidicoccus soli

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