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

29 rows where analysis = "blastn", bioproject = "PRJNA407087" 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
414875	414875	PRJNA407087_S_NODE_1741_length_504_cov_26.183158_g1307_i0	PRJNA407087	1741	504	26.183158	131.96311632	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	785	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g1307	i0	94.851	497.952380952381	505	23	100	3	1	504	730941	730439	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	250968	785	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
1689801	1689801	PRJNA407087_S_NODE_5442_length_219_cov_15.242105_g4979_i0	PRJNA407087	5442	219	15.242105	33.38020995	Chryseobacterium camelliae	1265445	Bacteria	Bacteria	399	6.009999999999999e-107	NTclustered	gi\|2429067237\|gb\|CP115859.1\|	1265445	g4979	i0	99.543	471.89497716895	219	1	100	0	1	219	1728814	1729032	Chryseobacterium camelliae strain VAN22-5A chromosome, complete genome	blastn	103345	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
2357087	2357087	PRJNA407087_S_NODE_1562_length_541_cov_15.744141_g1142_i0	PRJNA407087	1562	541	15.744141	85.17580281	Chryseobacterium	59732	Bacteria	Bacteria	961	0	NTclustered	gi\|1337009544\|gb\|MG871221.1\|	253	g1142	i0	100	138.96303142329	520	0	96	0	22	541	1	520	Chryseobacterium indologenes strain FC1366 16S ribosomal RNA gene, partial sequence	blastn	75179	968	0.992768595041322	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
2357099	2357099	PRJNA407087_S_NODE_6742_length_191_cov_2.320988_g6279_i0	PRJNA407087	6742	191	2.320988	4.43308708	Prevotella	838	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|285171583\|gb\|GU413263.1\|	28132	g6279	i0	100	104	191	0	100	0	1	191	152	342	Prevotella melaninogenica clone GI030 16S ribosomal RNA gene, partial sequence	blastn	19864	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
2965709	2965709	PRJNA407087_S_NODE_6683_length_192_cov_2.717791_g6220_i0	PRJNA407087	6683	192	2.717791	5.21815872	Changchengzhania lutea	2049305	Bacteria	Bacteria	60.2	9.88e-5	NTclustered	gi\|1702229803\|gb\|CP039456.1\|	2049305	g6220	i0	100	0.166666666666667	32	0	17	0	10	41	1756792	1756761	Changchengzhania lutea strain SM1355 chromosome, complete genome	blastn	32	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Changchengzhania	Changchengzhania lutea
3632508	3632508	PRJNA407087_S_NODE_4103_length_272_cov_42.074074_g3640_i0	PRJNA407087	4103	272	42.074074	114.44148128	Flavobacterium	237	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|15027324\|emb\|AJ318155.1\|	152509	g3640	i0	100	112.926470588235	272	0	100	0	1	272	1184	913	Uncultured Bacteroidetes bacterium 16S rRNA gene, clone BIjiii34	blastn	30716	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
4242056	4242056	PRJNA407087_S_NODE_4864_length_239_cov_9.019048_g4401_i0	PRJNA407087	4864	239	9.019048	21.55552472	Flectobacillus sp. WG3	671626	Bacteria	Bacteria	420	5.11e-113	NTclustered	gi\|257667133\|emb\|FN547417.1\|	671626	g4401	i0	100	102.836820083682	227	0	95	0	13	239	1487	1261	Flectobacillus sp. WG3 partial 16S rRNA gene, strain WG3	blastn	24578	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. WG3
4909653	4909653	PRJNA407087_S_NODE_8224_length_167_cov_44.398551_g7761_i0	PRJNA407087	8224	167	44.398551	74.14558017	root	1	Root_unresolved	Root_unresolved	309	7.53e-80	NTclustered	gi\|2450141964\|gb\|OQ546328.1\|	239	g7761	i0	100	103.748502994012	167	0	100	0	1	167	274	440	Flavobacterium sp. strain CA_68B 16S ribosomal RNA gene, partial sequence	blastn	17326	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
5518711	5518711	PRJNA407087_S_NODE_2425_length_412_cov_4.151436_g1964_i0	PRJNA407087	2425	412	4.151436	17.10391632	Hymenobacter baengnokdamensis	2615203	Bacteria	Bacteria	584	3.1599999999999987e-162	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g1964	i0	92.252	262.46359223301	413	30	100	2	1	412	1425398	1424987	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	108135	584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
6792703	6792703	PRJNA407087_S_NODE_7806_length_173_cov_3.965278_g7343_i0	PRJNA407087	7806	173	3.965278	6.85993094	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	243	8.03e-60	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g7343	i0	91.908	170.329479768786	173	14	100	0	1	173	339552	339724	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	29467	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
7459600	7459600	PRJNA407087_S_NODE_8306_length_166_cov_42.897810_g7843_i0	PRJNA407087	8306	166	42.89781	71.2103646	Bacteroidota	976	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g7843	i0	99.398	425.132530120482	166	1	100	0	1	166	2972229	2972394	Flavobacterium psychrophilum strain Z1, complete genome	blastn	70572	303	0.996699669966997	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
8068238	8068238	PRJNA407087_S_NODE_1607_length_531_cov_10.860558_g1178_i0	PRJNA407087	1607	531	10.860558	57.66956298	Flectobacillus sp. WG3	671626	Bacteria	Bacteria	941	0	NTclustered	gi\|257667133\|emb\|FN547417.1\|	671626	g1178	i0	100	95.5329566854991	509	0	96	0	23	531	1	509	Flectobacillus sp. WG3 partial 16S rRNA gene, strain WG3	blastn	50728	941	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. WG3
8734495	8734495	PRJNA407087_S_NODE_607_length_963_cov_34.265525_g202_i1	PRJNA407087	607	963	34.265525	329.97700575	Aquirufa	2676247	Bacteria	Bacteria	913	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g202	i1	86.842	138.88785046729	836	86	86	19	1	825	360460	359638	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	133749	918	0.994553376906318	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
10618858	10618858	PRJNA407087_S_NODE_1549_length_544_cov_18.436893_g1130_i0	PRJNA407087	1549	544	18.436893	100.29669792	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	614	5.439999999999999e-171	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g1130	i0	88.35	672.242647058824	515	54	94	5	33	544	730950	730439	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	365700	614	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
10618866	10618866	PRJNA407087_S_NODE_2029_length_462_cov_14.394919_g1576_i0	PRJNA407087	2029	462	14.394919	66.50452578	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	684	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g1576	i0	93.333	364.647186147186	465	28	100	3	1	462	361047	360583	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	168467	684	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
10618909	10618909	PRJNA407087_S_NODE_709_length_888_cov_20.727590_g385_i2	PRJNA407087	709	888	20.72759	184.0609992	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	1341	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g385	i2	93.953	505.518018018018	893	44	100	10	1	888	730941	730054	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	448900	1341	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
10618913	10618913	PRJNA407087_S_NODE_729_length_876_cov_21.167651_g385_i3	PRJNA407087	729	876	21.167651	185.42862276	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	1375	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g385	i3	95	497.076484018265	880	37	100	7	1	876	730930	730054	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	435439	1375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
11284945	11284945	PRJNA407087_S_NODE_4609_length_249_cov_27.309091_g4146_i0	PRJNA407087	4609	249	27.309091	67.99963659	Flavobacterium	237	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g4146	i0	100	580.738955823293	249	0	100	0	1	249	718896	718648	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	144604	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
11893772	11893772	PRJNA407087_S_NODE_2430_length_411_cov_10.688482_g1969_i0	PRJNA407087	2430	411	10.688482	43.92966102	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	628	1.43e-175	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g1969	i0	94.203	466.776155717762	414	21	100	3	1	411	360996	360583	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	191845	628	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
12560347	12560347	PRJNA407087_S_NODE_6150_length_202_cov_10.109827_g5687_i0	PRJNA407087	6150	202	10.109827	20.42185054	Dokdonia	326319	Bacteria	Bacteria	222	1.27e-53	NTclustered	gi\|332168736\|gb\|CP002528.1\|	983548	g5687	i0	87	301.633663366337	200	23	99	3	2	200	2386313	2386510	Dokdonia sp. 4H-3-7-5 chromosome, complete genome	blastn	60930	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Dokdonia	Dokdonia sp. 4H-3-7-5
13168698	13168698	PRJNA407087_S_NODE_1831_length_492_cov_27.129590_g1392_i0	PRJNA407087	1831	492	27.12959	133.4775828	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	821	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g1392	i0	96.748	481.170731707317	492	16	100	0	1	492	730930	730439	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	236736	821	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
13168737	13168737	PRJNA407087_S_NODE_651_length_928_cov_16.532814_g385_i1	PRJNA407087	651	928	16.532814	153.42451392	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	1168	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g385	i1	90.255	640.960129310345	903	75	97	12	33	928	730950	730054	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	594811	1168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
13835169	13835169	PRJNA407087_S_NODE_7451_length_178_cov_4.503356_g6988_i0	PRJNA407087	7451	178	4.503356	8.01597368	Hymenobacter	89966	Bacteria	Bacteria	309	8.09e-80	NTclustered	gi\|2221923801\|gb\|CP095046.1\|	2932248	g6988	i0	98.295	267.230337078652	176	3	99	0	2	177	977956	977781	Hymenobacter cellulosilyticus strain 5116 S-3 chromosome, complete genome	blastn	47567	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter cellulosilyticus
14443892	14443892	PRJNA407087_S_NODE_5192_length_227_cov_24.353535_g4729_i0	PRJNA407087	5192	227	24.353535	55.28252445	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g4729	i0	100	644.506607929515	227	0	100	0	1	227	731490	731716	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	146303	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
15717621	15717621	PRJNA407087_S_NODE_1333_length_604_cov_10.888696_g939_i0	PRJNA407087	1333	604	10.888696	65.76772384	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	599	1.6999999999999993e-166	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g939	i0	84.74	337.533112582781	616	74	100	17	1	604	359483	358876	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	203870	599	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
17659221	17659221	PRJNA407087_S_NODE_3694_length_295_cov_8.932331_g3231_i0	PRJNA407087	3694	295	8.932331	26.35037645	Hymenobacter	89966	Bacteria	Bacteria	529	1.0399999999999996e-145	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g3231	i0	99.654	300.366101694915	289	1	98	0	7	295	1424812	1424524	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	88608	529	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
17659224	17659224	PRJNA407087_S_NODE_7114_length_183_cov_16.694805_g6651_i0	PRJNA407087	7114	183	16.694805	30.55149315	Cloacibacterium	501783	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g6651	i0	97.814	477.065573770492	183	4	100	0	1	183	129475	129293	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	87303	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
18266582	18266582	PRJNA407087_S_NODE_7215_length_182_cov_2.267974_g6752_i0	PRJNA407087	7215	182	2.267974	4.12771268	Winogradskyella forsetii	2686077	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1866746738\|gb\|CP053348.1\|	2686077	g6752	i0	100	0.307692307692308	28	0	15	0	112	139	1317563	1317590	Winogradskyella forsetii strain HL857 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella forsetii
25307799	25307799	PRJNA407087_S_NODE_7780_length_173_cov_23.756944_g7317_i0	PRJNA407087	7780	173	23.756944	41.09951312	Weeksellaceae	2762318	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|1519499628\|gb\|CP033914.1\|	1493872	g7317	i0	99.422	338.734104046243	173	1	100	0	1	173	368819	368991	Chryseobacterium shandongense strain G0239 chromosome, complete genome	blastn	58601	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium shandongense

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