metadata: contig_metadata: 31 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax

31 rows where analysis = "diamond", bioproject = "PRJNA509429" 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
6863086	6863086	PRJNA509429_P_NODE_50346_length_153_cov_1.355932_g49518_i0	PRJNA509429	50346	153	1.355932	2.07457596	Flectobacillus	101	Bacteria	Bacteria	98.6	2.0399999999999994e-24	NR	WP_095160730.1	101	g49518	i0	100	0.980392156862745	50	0	98	0	151	2	51	100	WP_095160730.1 MULTISPECIES: 50S ribosomal protein L17 [Flectobacillus]	diamond	150	98.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus
18336978	18336978	PRJNA509429_P_NODE_50755_length_152_cov_1.709402_g49927_i0	PRJNA509429	50755	152	1.709402	2.59829104	Flectobacillus major	103	Bacteria	Bacteria	103	7.77e-28	NR	WP_026996997.1	103	g49927	i0	96	0.986842105263158	50	2	98.7	0	151	2	7	56	WP_026996997.1 50S ribosomal protein L32 [Flectobacillus major]	diamond	150	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus major
19611292	19611292	PRJNA509429_P_NODE_41616_length_176_cov_1.134752_g40788_i0	PRJNA509429	41616	176	1.134752	1.99716352	Bacteroidota	976	Bacteria	Bacteria	118	4.18e-29	NR	WP_310588847.1	1509483	g40788	i0	98.3	1.97727272727273	58	1	98.9	0	174	1	343	400	WP_310588847.1 TonB-dependent receptor domain-containing protein [Flectobacillus sp. BAB-3569]	diamond	348	119	0.991596638655462	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
24062710	24062710	PRJNA509429_P_NODE_48179_length_158_cov_1.300813_g47351_i0	PRJNA509429	48179	158	1.300813	2.05528454	Bacteroidia bacterium	2044936	Bacteria	Bacteria	99.8	1.69e-23	NR	MBX7180634.1	2044936	g47351	i0	90.4	0.987341772151899	52	5	98.7	0	157	2	233	284	MBX7180634.1 SDR family oxidoreductase [Bacteroidia bacterium]	diamond	156	99.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
26982230	26982230	PRJNA509429_P_NODE_37202_length_191_cov_2.051282_g36374_i0	PRJNA509429	37202	191	2.051282	3.91794862	Bacteroidota	976	Bacteria	Bacteria	60.5	2.16e-10	NR	WP_166552293.1	976	g36374	i0	100	0.801047120418848	51	0	80.1	0	1	153	11	61	WP_166552293.1 MULTISPECIES: hypothetical protein [Bacteroidota]	diamond	153	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
27045570	27045570	PRJNA509429_P_NODE_28962_length_231_cov_1.423469_g28134_i0	PRJNA509429	28962	231	1.423469	3.28821339	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.00835	NR	HXI66283.1	2448054	g28134	i0	32.4	2.71428571428571	68	45	88.3	1	2	205	71	137	HXI66283.1 magnesium chelatase domain-containing protein [Gemmatimonadales bacterium]	diamond	627	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27377343	27377343	PRJNA509429_P_NODE_36503_length_194_cov_0.993711_g35675_i0	PRJNA509429	36503	194	0.993711	1.92779934	Fluviicola	332102	Bacteria	Bacteria	113	2.27e-27	NR	MEO0037580.1	1898104	g35675	i0	92.2	1.97938144329897	64	5	99	0	2	193	645	708	MEO0037580.1 hypothetical protein [Bacteroidota bacterium]	diamond	384	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27646038	27646038	PRJNA509429_P_NODE_51224_length_151_cov_1.724138_g50396_i0	PRJNA509429	51224	151	1.724138	2.60344838	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	102	8.230000000000001e-26	NR	WP_205690850.1	2683263	g50396	i0	100	0.993377483443709	50	0	99.3	0	2	151	52	101	WP_205690850.1 RNA polymerase sigma factor [Cellulophaga sp. BC115SP]	diamond	150	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
27740860	27740860	PRJNA509429_P_NODE_38044_length_188_cov_1.215686_g37216_i0	PRJNA509429	38044	188	1.215686	2.28548968	Bacteroidota bacterium	1898104	Bacteria	Bacteria	82.8	3.51e-17	NR	MFM1754836.1	1898104	g37216	i0	100	0.622340425531915	39	0	62.2	0	118	2	4	42	MFM1754836.1 hypothetical protein [Bacteroidota bacterium]	diamond	117	82.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27993251	27993251	PRJNA509429_P_NODE_44245_length_168_cov_1.503759_g43417_i0	PRJNA509429	44245	168	1.503759	2.52631512	Bacteroidota bacterium	1898104	Bacteria	Bacteria	112	2.42e-29	NR	MFM1754471.1	1898104	g43417	i0	98.2	1	56	1	100	0	168	1	133	188	MFM1754471.1 hypothetical protein [Bacteroidota bacterium]	diamond	168	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28087722	28087722	PRJNA509429_P_NODE_32625_length_211_cov_1.136364_g31797_i0	PRJNA509429	32625	211	1.136364	2.39772804	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	45.8	0.00203	NR	MBD3163102.1	2053570	g31797	i0	54.5	0.625592417061611	44	17	61.1	2	156	28	53	94	MBD3163102.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	132	45.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
28340430	28340430	PRJNA509429_P_NODE_31806_length_215_cov_1.155556_g30978_i0	PRJNA509429	31806	215	1.155556	2.4844454	Flectobacillus sp. BAB-3569	1509483	Bacteria	Bacteria	136	4.48e-36	NR	WP_095168144.1	1509483	g30978	i0	97.2	0.990697674418605	71	2	99.1	0	214	2	11	81	WP_095168144.1 RagB/SusD family nutrient uptake outer membrane protein [Flectobacillus sp. BAB-3569]	diamond	213	136	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
28624816	28624816	PRJNA509429_P_NODE_28607_length_233_cov_1.212121_g27779_i0	PRJNA509429	28607	233	1.212121	2.82424193	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	144	5.41e-38	NR	WP_166551180.1	2683263	g27779	i0	98.7	0.991416309012876	77	1	99.1	0	232	2	77	153	WP_166551180.1 TonB-dependent receptor [Cellulophaga sp. BC115SP]	diamond	231	144	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
28656293	28656293	PRJNA509429_P_NODE_38287_length_187_cov_1.315789_g37459_i0	PRJNA509429	38287	187	1.315789	2.46052543	Bacteroidota	976	Bacteria	Bacteria	120	8.799999999999999e-33	NR	WP_166550090.1	976	g37459	i0	100	0.994652406417112	62	0	99.5	0	187	2	55	116	WP_166550090.1 MULTISPECIES: 50S ribosomal protein L25/general stress protein Ctc [Bacteroidota]	diamond	186	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
28940576	28940576	PRJNA509429_P_NODE_51048_length_151_cov_4.103448_g50220_i0	PRJNA509429	51048	151	4.103448	6.19620648	Bacteroidota	976	Bacteria	Bacteria	83.6	1.67e-19	NR	WP_095162422.1	976	g50220	i0	100	0.913907284768212	46	0	91.4	0	139	2	1	46	WP_095162422.1 MULTISPECIES: 30S ribosomal protein S20 [Bacteroidota]	diamond	138	83.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
29319195	29319195	PRJNA509429_P_NODE_49609_length_155_cov_0.975000_g48781_i0	PRJNA509429	49609	155	0.975	1.51125	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	40.8	0.0381	NR	MFN8317862.1	2202734	g48781	i0	40.5	0.716129032258065	37	22	71.6	0	153	43	115	151	MFN8317862.1 1,2-phenylacetyl-CoA epoxidase subunit PaaD [Saprospiraceae bacterium]	diamond	111	40.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
29350892	29350892	PRJNA509429_P_NODE_27609_length_239_cov_1.960784_g26781_i0	PRJNA509429	27609	239	1.960784	4.68627376	Arcicella aurantiaca	591202	Bacteria	Bacteria	50.1	2.18e-5	NR	PWK29478.1	591202	g26781	i0	67.4	0.539748953974895	43	13	54	1	228	100	31	72	PWK29478.1 hypothetical protein LV89_00319 [Arcicella aurantiaca]	diamond	129	50.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Arcicella	Arcicella aurantiaca
29350893	29350893	PRJNA509429_P_NODE_33249_length_208_cov_1.364162_g32421_i0	PRJNA509429	33249	208	1.364162	2.83745696	Flavobacterium sp.	239	Bacteria	Bacteria	129	7.81e-33	NR	WP_296684635.1	239	g32421	i0	94.1	0.980769230769231	68	4	98.1	0	3	206	437	504	WP_296684635.1 SusC/RagA family TonB-linked outer membrane protein [Flavobacterium sp.]	diamond	204	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29697703	29697703	PRJNA509429_P_NODE_47790_length_159_cov_1.290323_g46962_i0	PRJNA509429	47790	159	1.290323	2.05161357	Flavobacterium sp. H122	2529860	Bacteria	Bacteria	106	3.18e-28	NR	WP_136667385.1	2529860	g46962	i0	88.7	1	53	6	100	0	159	1	42	94	WP_136667385.1 toxin-antitoxin system YwqK family antitoxin [Flavobacterium sp. H122]	diamond	159	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. H122
30014063	30014063	PRJNA509429_P_NODE_50351_length_153_cov_1.355932_g49523_i0	PRJNA509429	50351	153	1.355932	2.07457596	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	99.8	3.0799999999999994e-24	NR	MBP6091716.1	2026728	g49523	i0	94	0.980392156862745	50	3	98	0	152	3	18	67	MBP6091716.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	150	99.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
30155476	30155476	PRJNA509429_P_NODE_30252_length_223_cov_1.601064_g29424_i0	PRJNA509429	30252	223	1.601064	3.57037272	Tenacibaculum	104267	Bacteria	Bacteria	119	4.46e-29	NR	WP_121146198.1	104267	g29424	i0	85.1	4.97757847533632	74	11	99.6	0	1	222	449	522	WP_121146198.1 MULTISPECIES: choice-of-anchor L domain-containing protein [Tenacibaculum]	diamond	1110	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum
30203280	30203280	PRJNA509429_P_NODE_44692_length_167_cov_1.212121_g43864_i0	PRJNA509429	44692	167	1.212121	2.02424207	Flectobacillus sp. BAB-3569	1509483	Bacteria	Bacteria	92.8	1.35e-20	NR	WP_095164846.1	1509483	g43864	i0	95.9	0.880239520958084	49	2	88	0	166	20	324	372	WP_095164846.1 efflux RND transporter periplasmic adaptor subunit [Flectobacillus sp. BAB-3569]	diamond	147	92.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
30250776	30250776	PRJNA509429_P_NODE_24032_length_265_cov_1.391304_g23204_i0	PRJNA509429	24032	265	1.391304	3.6869556	Flavobacterium	237	Bacteria	Bacteria	175	1.49e-48	NR	WP_296684635.1	239	g23204	i0	98.9	1.99245283018868	88	1	99.6	0	264	1	523	610	WP_296684635.1 SusC/RagA family TonB-linked outer membrane protein [Flavobacterium sp.]	diamond	528	175	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30898777	30898777	PRJNA509429_P_NODE_51794_length_150_cov_1.391304_g50966_i0	PRJNA509429	51794	150	1.391304	2.086956	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	67.8	4.76e-13	NR	HMP31694.1	2202734	g50966	i0	71.1	0.9	45	13	90	0	3	137	62	106	HMP31694.1 hypothetical protein [Saprospiraceae bacterium]	diamond	135	67.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
31214152	31214152	PRJNA509429_P_NODE_38055_length_188_cov_1.045752_g37227_i0	PRJNA509429	38055	188	1.045752	1.96601376	Flectobacillus longus	2984207	Bacteria	Bacteria	60.1	1.37e-8	NR	WP_283330185.1	2984207	g37227	i0	100	2.31382978723404	29	0	46.3	0	2	88	887	915	WP_283330185.1 hypothetical protein [Flectobacillus longus]	diamond	435	60.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus longus
31246215	31246215	PRJNA509429_P_NODE_45035_length_166_cov_1.221374_g44207_i0	PRJNA509429	45035	166	1.221374	2.02748084	Flavobacterium sp.	239	Bacteria	Bacteria	108	8.5e-26	NR	WP_296684633.1	239	g44207	i0	96.4	0.993975903614458	55	2	99.4	0	166	2	29	83	WP_296684633.1 RagB/SusD family nutrient uptake outer membrane protein [Flavobacterium sp.]	diamond	165	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
31341137	31341137	PRJNA509429_P_NODE_44976_length_166_cov_1.526718_g44148_i0	PRJNA509429	44976	166	1.526718	2.53435188	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	89	8.25e-21	NR	MBL7834284.1	2099675	g44148	i0	80	1.96987951807229	55	11	99.4	0	166	2	35	89	MBL7834284.1 MarR family transcriptional regulator [Cyclobacteriaceae bacterium]	diamond	327	89	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
31688959	31688959	PRJNA509429_P_NODE_30117_length_224_cov_1.470899_g29289_i0	PRJNA509429	30117	224	1.470899	3.29481376	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	70.9	4.27e-13	NR	WP_297867892.1	165435	g29289	i0	51.4	1.98214285714286	74	35	99.1	1	1	222	53	125	WP_297867892.1 RNA polymerase sigma factor [uncultured Flavobacterium sp.]	diamond	444	70.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
31767635	31767635	PRJNA509429_P_NODE_36457_length_194_cov_1.503145_g35629_i0	PRJNA509429	36457	194	1.503145	2.9161013	Flectobacillus	101	Bacteria	Bacteria	92	8.24e-20	NR	WP_044174349.1	103	g35629	i0	100	2.96907216494845	48	0	74.2	0	51	194	1	48	WP_044174349.1 DEAD/DEAH box helicase [Flectobacillus major]	diamond	576	92	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus major
32448613	32448613	PRJNA509429_P_NODE_18519_length_317_cov_4.138298_g17691_i0	PRJNA509429	18519	317	4.138298	13.11840466	Sphingobacterium chungjuense	2675553	Bacteria	Bacteria	43.1	0.0384	NR	WP_166333489.1	2675553	g17691	i0	35.8	0.501577287066246	53	30	46.4	1	63	209	48	100	WP_166333489.1 DUF6141 family protein [Sphingobacterium chungjuense]	diamond	159	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium chungjuense
32575136	32575136	PRJNA509429_P_NODE_2339_length_919_cov_11.272624_g1890_i0	PRJNA509429	2339	919	11.272624	103.59541456	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	48.9	0.0189	NR	WP_249755517.1	2942477	g1890	i0	55.1	0.159956474428727	49	16	14	3	747	875	210	258	WP_249755517.1 RNA-directed DNA polymerase, partial [Algibacter sp. L4_22]	diamond	147	48.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22

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