metadata: contig_metadata: 25 rows where bioproject = "PRJNA767802", tax_clade = "FCB group" and tax

25 rows where bioproject = "PRJNA767802", tax_clade = "FCB group" and tax_kingdom = "Pseudomonadati"

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
745204	745204	PRJNA767802_P_NODE_241_length_1587_cov_2.401170_g227_i0	PRJNA767802	241	1587	2.40117	38.1065679	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	2920	0	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g227	i0	99.874	1.94517958412098	1587	2	100	0	1	1587	3238301	3239887	Lacibacter sp. MH-610 chromosome	blastn	3087	2920	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
2021217	2021217	PRJNA767802_P_NODE_4002_length_430_cov_1.797900_g3929_i0	PRJNA767802	4002	430	1.7979	7.73097	Flavihumibacter stibioxidans	1834163	Bacteria	Bacteria	195	1.54e-54	NR	WP_187254985.1	1834163	g3929	i0	98.1	0.725581395348837	104	2	72.6	0	119	430	502	605	WP_187254985.1 CusA/CzcA family heavy metal efflux RND transporter [Flavihumibacter stibioxidans]	diamond	312	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter stibioxidans
21147778	21147778	PRJNA767802_P_NODE_4557_length_394_cov_4.179710_g4484_i0	PRJNA767802	4557	394	4.17971	16.4680574	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	682	0	NTclustered	gi\|2636475595\|gb\|CP139978.1\|	258	g4484	i0	99.467	5.28680203045685	375	2	95	0	20	394	4324637	4324263	Sphingobacterium spiritivorum strain HAMBI_1896 chromosome, complete genome	blastn	2083	682	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
22422524	22422524	PRJNA767802_P_NODE_9338_length_238_cov_1.074074_g9265_i0	PRJNA767802	9338	238	1.074074	2.55629612	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	303	5.35e-78	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g9265	i0	91.441	342.894957983193	222	17	93	2	18	238	360769	360989	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	81609	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
23698154	23698154	PRJNA767802_P_NODE_4359_length_406_cov_4.481793_g4286_i0	PRJNA767802	4359	406	4.481793	18.19607958	Cloacibacterium sp.	1913682	Bacteria	Bacteria	186	5.029999999999999e-54	NR	MFN4076187.1	1913682	g4286	i0	89.1	1.60344827586207	110	12	81.3	0	360	31	336	445	MFN4076187.1 OmpA family protein [Cloacibacterium sp.]	diamond	651	186	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium sp.
26704821	26704821	PRJNA767802_P_NODE_4921_length_373_cov_2.913580_g4848_i0	PRJNA767802	4921	373	2.91358	10.8676534	Maribacter sp. 221	1897614	Bacteria	Bacteria	99.8	1.76e-21	NR	WP_413969516.1	3386272	g4848	i0	39.3	0.981233243967828	122	73	97.3	1	365	3	167	288	WP_413969516.1 hypothetical protein [Maribacter sp. 2210JD10-5]	diamond	366	99.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Maribacter	Maribacter sp. 2210JD10-5
26895233	26895233	PRJNA767802_P_NODE_14281_length_180_cov_1.374046_g14208_i0	PRJNA767802	14281	180	1.374046	2.4732828	Tenacibaculum sp. SZ-18	754423	Bacteria	Bacteria	45.4	0.00148	NR	WP_157811690.1	754423	g14208	i0	41.5	1.8	53	31	88.3	0	2	160	144	196	WP_157811690.1 hypothetical protein [Tenacibaculum sp. SZ-18]	diamond	324	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum sp. SZ-18
27021619	27021619	PRJNA767802_P_NODE_7822_length_270_cov_1.348416_g7749_i0	PRJNA767802	7822	270	1.348416	3.6407232	uncultured Aquimarina sp.	575652	Bacteria	Bacteria	68.2	6e-11	NR	WP_299609184.1	575652	g7749	i0	63.5	1.6	52	19	57.8	0	239	84	1998	2049	WP_299609184.1 T9SS type B sorting domain-containing protein [uncultured Aquimarina sp.]	diamond	432	68.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	uncultured Aquimarina sp.
27116225	27116225	PRJNA767802_P_NODE_3262_length_491_cov_7.993213_g3191_i0	PRJNA767802	3262	491	7.993213	39.24667583	Ferruginibacter sp.	1940288	Bacteria	Bacteria	162	3.01e-46	NR	HEX2682415.1	1940288	g3191	i0	48.2	1.0142566191446	166	77	95.9	2	1	471	21	186	HEX2682415.1 hypothetical protein [Ferruginibacter sp.]	diamond	498	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
27242820	27242820	PRJNA767802_P_NODE_3463_length_472_cov_5.248227_g3391_i0	PRJNA767802	3463	472	5.248227	24.77163144	Bacteroidota bacterium	1898104	Bacteria	Bacteria	99	4.9900000000000006e-21	NR	MCR9290574.1	1898104	g3391	i0	44.1	5.49152542372881	143	73	90.3	2	442	17	152	288	MCR9290574.1 phage integrase N-terminal SAM-like domain-containing protein [Bacteroidota bacterium]	diamond	2592	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27337803	27337803	PRJNA767802_P_NODE_15843_length_167_cov_1.728814_g15770_i0	PRJNA767802	15843	167	1.728814	2.88711938	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	42	0.0253	NR	MCC6816024.1	2202734	g15770	i0	50	1.31137724550898	30	15	53.9	0	3	92	80	109	MCC6816024.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium]	diamond	219	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
27401016	27401016	PRJNA767802_P_NODE_16543_length_166_cov_0.871795_g16470_i0	PRJNA767802	16543	166	0.871795	1.4471797	Bacteroidia bacterium	2044936	Bacteria	Bacteria	44.7	0.00129	NR	MBL7934166.1	2044936	g16470	i0	74.1	0.487951807228916	27	7	48.8	0	84	164	1	27	MBL7934166.1 4Fe-4S binding protein [Bacteroidia bacterium]	diamond	81	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
27600115	27600115	PRJNA767802_P_NODE_4384_length_405_cov_2.674157_g4311_i0	PRJNA767802	4384	405	2.674157	10.83033585	Puia	2045098	Bacteria	Bacteria	120	3.7899999999999997e-31	NR	MBK7883588.1	1869212	g4311	i0	46	1.88148148148148	126	65	93.3	1	7	384	17	139	MBK7883588.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	762	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27821124	27821124	PRJNA767802_P_NODE_9424_length_236_cov_1.737968_g9351_i0	PRJNA767802	9424	236	1.737968	4.10160448	Pseudomonadati	3379134	Bacteria	Bacteria	72	1.72e-13	NR	MEO6941123.1	2447898	g9351	i0	49.2	2.33898305084746	63	32	80.1	0	223	35	115	177	MEO6941123.1 lipocalin family protein [Candidatus Kapaibacterium sp.]	diamond	552	72	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
28221634	28221634	PRJNA767802_P_NODE_4186_length_417_cov_2.328804_g4113_i0	PRJNA767802	4186	417	2.328804	9.71111268	Ferruginibacter sp.	1940288	Bacteria	Bacteria	157	2.17e-41	NR	HEX2682422.1	1940288	g4113	i0	52.9	0.992805755395683	138	65	99.3	0	3	416	393	530	HEX2682422.1 hypothetical protein [Ferruginibacter sp.]	diamond	414	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
29232286	29232286	PRJNA767802_P_NODE_2089_length_628_cov_3.053541_g2027_i0	PRJNA767802	2089	628	3.053541	19.17623748	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	204	2.96e-60	NR	MFM9908692.1	1869212	g2027	i0	67.4	0.687898089171974	144	47	68.8	0	609	178	273	416	MFM9908692.1 oligosaccharide flippase family protein [Chitinophagaceae bacterium]	diamond	432	204	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29295310	29295310	PRJNA767802_P_NODE_1269_length_818_cov_20.369311_g1222_i0	PRJNA767802	1269	818	20.369311	166.62096398	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	187	1.8299999999999995e-54	NR	HQJ91130.1	2748031	g1222	i0	48.1	0.663814180929095	181	93	66.4	1	818	276	80	259	HQJ91130.1 DNA methyltransferase [Paludibacteraceae bacterium]	diamond	543	187	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
29705355	29705355	PRJNA767802_P_NODE_14150_length_181_cov_1.537879_g14077_i0	PRJNA767802	14150	181	1.537879	2.78356099	Bacteroidota bacterium	1898104	Bacteria	Bacteria	107	1.23e-28	NR	MBS1577785.1	1898104	g14077	i0	84.2	0.94475138121547	57	9	94.5	0	9	179	1	57	MBS1577785.1 hypothetical protein [Bacteroidota bacterium]	diamond	171	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29705356	29705356	PRJNA767802_P_NODE_1810_length_677_cov_6.226115_g1752_i0	PRJNA767802	1810	677	6.226115	42.15079855	Agriterribacter sp.	2821509	Bacteria	Bacteria	165	4.95e-46	NR	HRP30473.1	2821509	g1752	i0	52.4	0.633677991137371	143	67	63.4	1	674	246	163	304	HRP30473.1 hypothetical protein [Agriterribacter sp.]	diamond	429	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Agriterribacter	Agriterribacter sp.
30906484	30906484	PRJNA767802_P_NODE_2394_length_587_cov_1.691450_g2329_i0	PRJNA767802	2394	587	1.69145	9.9288115	Flavobacterium psychrophilum	96345	Bacteria	Bacteria	65.1	1.5e-8	NR	WP_094163979.1	96345	g2329	i0	40	0.40885860306644	80	48	40.9	0	537	298	141	220	WP_094163979.1 hypothetical protein [Flavobacterium psychrophilum]	diamond	240	65.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
31222035	31222035	PRJNA767802_P_NODE_16215_length_167_cov_0.864407_g16142_i0	PRJNA767802	16215	167	0.864407	1.44355969	Chitinophaga sp.	1869181	Bacteria	Bacteria	110	1.22e-28	NR	MBA4196886.1	1869181	g16142	i0	100	0.988023952095808	55	0	98.8	0	167	3	117	171	MBA4196886.1 hypothetical protein [Chitinophaga sp.]	diamond	165	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp.
31854791	31854791	PRJNA767802_P_NODE_14577_length_177_cov_1.593750_g14504_i0	PRJNA767802	14577	177	1.59375	2.8209375	Pedobacter sp. ASV12	2795120	Bacteria	Bacteria	65.5	1.45e-10	NR	WP_199137422.1	2795120	g14504	i0	96.8	0.525423728813559	31	1	52.5	0	2	94	28	58	WP_199137422.1 carboxypeptidase-like regulatory domain-containing protein [Pedobacter sp. ASV12]	diamond	93	65.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. ASV12
31918160	31918160	PRJNA767802_P_NODE_9377_length_237_cov_1.627660_g9304_i0	PRJNA767802	9377	237	1.62766	3.8575542	Flectobacillus sp. BAB-3569	1509483	Bacteria	Bacteria	163	4.28e-47	NR	WP_095160086.1	1509483	g9304	i0	97.5	1	79	2	100	0	1	237	148	226	WP_095160086.1 FIST signal transduction protein [Flectobacillus sp. BAB-3569]	diamond	237	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
32202943	32202943	PRJNA767802_P_NODE_1298_length_807_cov_4.864116_g1250_i0	PRJNA767802	1298	807	4.864116	39.25341612	Bacteroidota bacterium	1898104	Bacteria	Bacteria	100	9.61e-20	NR	PCJ66674.1	1898104	g1250	i0	34.6	0.66542750929368	179	101	61	4	168	659	1693	1870	PCJ66674.1 MAG: hypothetical protein COA58_04235 [Bacteroidota bacterium]	diamond	537	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32361358	32361358	PRJNA767802_P_NODE_9219_length_240_cov_1.602094_g9146_i0	PRJNA767802	9219	240	1.602094	3.8450256	Bacteroidota bacterium	1898104	Bacteria	Bacteria	42.7	0.0366	NR	MBS1625871.1	1898104	g9146	i0	65.7	0.4375	35	12	43.8	0	194	90	579	613	MBS1625871.1 tail fiber domain-containing protein [Bacteroidota bacterium]	diamond	105	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium

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