metadata: contig_metadata: 25 rows where bioproject = "PRJNA664479" and tax

25 rows where bioproject = "PRJNA664479" 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
1905253	1905253	PRJNA664479_S_NODE_1222_length_429_cov_2.005263_g1146_i0	PRJNA664479	1222	429	2.005263	8.60257827	Empedobacter stercoris	1628248	Bacteria	Bacteria	776	0	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g1146	i0	99.301	355.594405594406	429	3	100	0	1	429	1406515	1406943	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	152550	776	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
4457078	4457078	PRJNA664479_S_NODE_6904_length_212_cov_1.061350_g6828_i0	PRJNA664479	6904	212	1.06135	2.250062	Flavobacterium alkalisoli	2602769	Bacteria	Bacteria	60.2	1.11e-4	NTclustered	gi\|1724793953\|gb\|CP042831.1\|	2602769	g6828	i0	91.304	0.216981132075472	46	1	22	3	86	131	1713469	1713511	Flavobacterium alkalisoli strain XS-5 chromosome, complete genome	blastn	46	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium alkalisoli
4990553	4990553	PRJNA664479_S_NODE_17064_length_163_cov_1.342105_g16988_i0	PRJNA664479	17064	163	1.342105	2.18763115	Flavobacterium	237	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2306666110\|emb\|OX336425.1\|	1114861	g16988	i0	100	450.901840490798	163	0	100	0	1	163	24392	24554	Flavobacterium collinsii strain TRV642 genome assembly, chromosome: TRV642	blastn	73497	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium collinsii
8282388	8282388	PRJNA664479_S_NODE_9107_length_193_cov_6.097222_g9031_i0	PRJNA664479	9107	193	6.097222	11.76763846	Apibacter raozihei	2500547	Bacteria	Bacteria	302	1.5e-77	NTclustered	gi\|1554515621\|gb\|CP034930.1\|	2500547	g9031	i0	94.819	470.761658031088	193	10	100	0	1	193	781316	781124	Apibacter raozihei strain HY041 chromosome, complete genome	blastn	90857	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Apibacter	Apibacter raozihei
9557643	9557643	PRJNA664479_S_NODE_16548_length_164_cov_0.886957_g16472_i0	PRJNA664479	16548	164	0.886957	1.45460948	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	276	7.46e-70	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g16472	i0	96.951	9.61585365853658	164	5	100	0	1	164	2560096	2559933	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	1577	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
12108482	12108482	PRJNA664479_S_NODE_15690_length_165_cov_0.879310_g15614_i0	PRJNA664479	15690	165	0.87931	1.4508615	Epilithonimonas zeae	1416779	Bacteria	Bacteria	161	2.2e-35	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g15614	i0	84.242	1.95151515151515	165	26	100	0	1	165	3540019	3539855	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	322	161	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
12108483	12108483	PRJNA664479_S_NODE_15790_length_165_cov_0.879310_g15714_i0	PRJNA664479	15790	165	0.87931	1.4508615	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	287	3.47e-73	NTclustered	gi\|1958230772\|gb\|CP068083.1\|	258	g15714	i0	98.171	4.9030303030303	164	3	99	0	1	164	1857885	1857722	Sphingobacterium spiritivorum strain FDAARGOS_1145 chromosome, complete genome	blastn	809	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
13916230	13916230	PRJNA664479_S_NODE_2931_length_294_cov_1.355102_g2855_i0	PRJNA664479	2931	294	1.355102	3.98399988	Flavobacteriales	200644	Bacteria	Bacteria	534	2.2199999999999998e-147	NTclustered	gi\|1896493618\|gb\|MT921741.1\|	247	g2855	i0	99.32	111.979591836735	294	2	100	0	1	294	468	761	Empedobacter brevis strain DPBS068 16S ribosomal RNA gene, partial sequence	blastn	32922	538	0.992565055762082	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
14658116	14658116	PRJNA664479_S_NODE_17992_length_162_cov_0.902655_g17916_i0	PRJNA664479	17992	162	0.902655	1.4623011	Epilithonimonas zeae	1416779	Bacteria	Bacteria	202	1.26e-47	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g17916	i0	89.024	3.84567901234568	164	16	100	1	1	162	3379468	3379305	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	623	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
17207203	17207203	PRJNA664479_S_NODE_15774_length_165_cov_0.879310_g15698_i0	PRJNA664479	15774	165	0.87931	1.4508615	Chryseobacterium sp. CY350	2997336	Bacteria	Bacteria	132	1.72e-26	NTclustered	gi\|2430443073\|gb\|CP116034.1\|	2997336	g15698	i0	84.173	1.56969696969697	139	19	84	3	28	165	3954901	3955037	Chryseobacterium sp. CY350 chromosome, complete genome	blastn	259	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. CY350
17207211	17207211	PRJNA664479_S_NODE_3154_length_285_cov_1.394068_g3078_i0	PRJNA664479	3154	285	1.394068	3.9730938	Empedobacter falsenii	343874	Bacteria	Bacteria	390	4.909999999999998e-104	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g3078	i0	95.142	330.347368421053	247	12	87	0	3	249	522419	522173	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	94149	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
18481564	18481564	PRJNA664479_S_NODE_5775_length_225_cov_2.562500_g5699_i0	PRJNA664479	5775	225	2.5625	5.765625	Empedobacter stercoris	1628248	Bacteria	Bacteria	394	2.89e-105	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g5699	i0	98.222	679.902222222222	225	4	100	0	1	225	85301	85525	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	152978	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
19013852	19013852	PRJNA664479_S_NODE_7935_length_202_cov_2.026144_g7859_i0	PRJNA664479	7935	202	2.026144	4.09281088	Weeksellaceae	2762318	Bacteria	Bacteria	335	1.5599999999999993e-87	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g7859	i0	97	230.311881188119	200	4	98	2	5	202	522034	522233	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	46523	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
21031694	21031694	PRJNA664479_S_NODE_18897_length_161_cov_0.910714_g18821_i0	PRJNA664479	18897	161	0.910714	1.46624954	Prevotella melaninogenica	28132	Bacteria	Bacteria	222	9.63e-54	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g18821	i0	91.824	27.0186335403727	159	13	100	0	3	161	1641183	1641025	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	4350	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
22839686	22839686	PRJNA664479_S_NODE_17918_length_162_cov_0.902655_g17842_i0	PRJNA664479	17918	162	0.902655	1.4623011	Sphingobacterium	28453	Bacteria	Bacteria	244	2.07e-60	NTclustered	gi\|2831337980\|gb\|CP171136.1\|	1768011	g17842	i0	93.827	2.91975308641975	162	10	100	0	1	162	1396904	1396743	Sphingobacterium cellulitidis strain WGS1282 chromosome, complete genome	blastn	473	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium cellulitidis
24855402	24855402	PRJNA664479_S_NODE_15800_length_165_cov_0.879310_g15724_i0	PRJNA664479	15800	165	0.87931	1.4508615	Winogradskyella sediminis	1382466	Bacteria	Bacteria	108	2.9e-19	NTclustered	gi\|1085942643\|emb\|LT629774.1\|	1382466	g15724	i0	80.272	0.890909090909091	147	25	88	3	2	146	741407	741551	Winogradskyella sediminis strain RHA_55 genome assembly, chromosome: I	blastn	147	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella sediminis
26682016	26682016	PRJNA664479_S_NODE_16841_length_164_cov_0.869565_g16765_i0	PRJNA664479	16841	164	0.869565	1.4260866	root	1	Root_unresolved	Root_unresolved	75.5	2.19e-15	NR	WP_151874162.1	817	g16765	i0	75.9	94.5548780487805	54	13	98.8	0	164	3	92	145	WP_151874162.1 30S ribosomal protein S4, partial [Bacteroides fragilis]	diamond	15507	75.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
27271100	27271100	PRJNA664479_S_NODE_17963_length_162_cov_0.902655_g17887_i0	PRJNA664479	17963	162	0.902655	1.4623011	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	83.6	2.91e-18	NR	HUQ97798.1	1869212	g17887	i0	79.2	1.96296296296296	53	10	98.1	1	161	3	18	69	HUQ97798.1 RdgB/HAM1 family non-canonical purine NTP pyrophosphatase [Chitinophagaceae bacterium]	diamond	318	83.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27745111	27745111	PRJNA664479_S_NODE_15724_length_165_cov_0.879310_g15648_i0	PRJNA664479	15724	165	0.87931	1.4508615	Cloacibacterium rupense	517423	Bacteria	Bacteria	108	6.12e-26	NR	WP_188618631.1	517423	g15648	i0	92.6	0.981818181818182	54	4	98.2	0	2	163	154	207	WP_188618631.1 ATP-dependent helicase [Cloacibacterium rupense]	diamond	162	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium rupense
27871046	27871046	PRJNA664479_S_NODE_14685_length_167_cov_0.864407_g14609_i0	PRJNA664479	14685	167	0.864407	1.44355969	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	84.3	2.7e-17	NR	MBQ9216630.1	2498093	g14609	i0	76.4	1.97604790419162	55	13	98.8	0	3	167	400	454	MBQ9216630.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Muribaculaceae bacterium]	diamond	330	84.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
28313267	28313267	PRJNA664479_S_NODE_16686_length_164_cov_0.886957_g16610_i0	PRJNA664479	16686	164	0.886957	1.45460948	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	115	5.66e-29	NR	WP_294820642.1	165435	g16610	i0	98.1	1.97560975609756	54	1	98.8	0	3	164	201	254	WP_294820642.1 aminopeptidase C [uncultured Flavobacterium sp.]	diamond	324	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
28325227	28325227	PRJNA664479_S_NODE_3066_length_288_cov_4.447699_g2990_i0	PRJNA664479	3066	288	4.447699	12.80937312	Bacteroidia	200643	Bacteria	Bacteria	44.7	0.0123	NR	WP_025865170.1	314319	g2990	i0	61.5	2.97916666666667	26	10	27.1	0	18	95	294	319	WP_025865170.1 type I glyceraldehyde-3-phosphate dehydrogenase [Prolixibacter bellariivorans]	diamond	858	45.1	0.991130820399113	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Prolixibacter	Prolixibacter bellariivorans
29008123	29008123	PRJNA664479_S_NODE_18008_length_162_cov_0.902655_g17932_i0	PRJNA664479	18008	162	0.902655	1.4623011	Myroides sp.	1874736	Bacteria	Bacteria	82.8	4.99e-17	NR	MDO5637570.1	1874736	g17932	i0	79.2	2.92592592592593	53	11	98.1	0	2	160	172	224	MDO5637570.1 COX15/CtaA family protein [Myroides sp.]	diamond	474	82.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides sp.
30776674	30776674	PRJNA664479_S_NODE_15014_length_166_cov_0.871795_g14938_i0	PRJNA664479	15014	166	0.871795	1.4471797	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	108	6.41e-26	NR	WP_407497252.1	1117645	g14938	i0	100	1.98795180722892	55	0	99.4	0	166	2	581	635	WP_407497252.1 Eco57I restriction-modification methylase domain-containing protein [Elizabethkingia anophelis]	diamond	330	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
32389377	32389377	PRJNA664479_S_NODE_14859_length_166_cov_1.623932_g14783_i0	PRJNA664479	14859	166	1.623932	2.69572712	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	41.2	0.0434	NR	MCC6144449.1	2030809	g14783	i0	40.3	1.12048192771084	62	24	88.6	2	12	158	114	175	MCC6144449.1 lipid-A-disaccharide synthase N-terminal domain-containing protein [Candidatus Hydrogenedentota bacterium]	diamond	186	41.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota					Candidatus Hydrogenedentota 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);;