metadata: contig_metadata: 29 rows where bioproject = "PRJNA698538" and tax

29 rows where bioproject = "PRJNA698538" 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
681321	681321	PRJNA698538_S_NODE_14141_length_318_cov_2.069388_g13975_i0	PRJNA698538	14141	318	2.069388	6.58065384	Candidatus Chryseobacterium colombiense	3121364	Bacteria	Bacteria	477	4.149999999999998e-130	NTclustered	gi\|2457556413\|gb\|CP119310.1\|	3121364	g13975	i0	93.73	95.6415094339623	319	19	100	1	1	318	1399626	1399944	MAG: Candidatus Chryseobacterium colombiense isolate MAG_1654 chromosome, complete genome	blastn	30414	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Candidatus Chryseobacterium colombiense
681325	681325	PRJNA698538_S_NODE_14221_length_317_cov_4.303279_g14055_i0	PRJNA698538	14221	317	4.303279	13.64139443	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g14055	i0	100	0.0946372239747634	30	0	9	0	35	64	1161438	1161409	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
1957345	1957345	PRJNA698538_S_NODE_21322_length_276_cov_129.783251_g21156_i0	PRJNA698538	21322	276	129.783251	358.20177276	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	62.1	4.22e-5	NTclustered	gi\|2717309477\|emb\|OZ032149.1\|	336810	g21156	i0	97.222	0.130434782608696	36	1	13	0	110	145	226088	226053	Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1	blastn	36	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
5784759	5784759	PRJNA698538_S_NODE_15425_length_310_cov_1.949367_g15259_i0	PRJNA698538	15425	310	1.949367	6.0430377	Epilithonimonas zeae	1416779	Bacteria	Bacteria	459	1.46e-124	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g15259	i0	93.77	98.6064516129032	305	19	98	0	1	305	2080415	2080719	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	30568	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
5785082	5785082	PRJNA698538_S_NODE_8765_length_361_cov_2.569444_g8599_i0	PRJNA698538	8765	361	2.569444	9.27569284	Flectobacillus	101	Bacteria	Bacteria	206	1.2e-61	NR	WP_283368946.1	101	g8599	i0	95.5	0.930747922437673	112	5	93.1	0	338	3	53	164	WP_283368946.1 MULTISPECIES: F0F1 ATP synthase subunit alpha [Flectobacillus]	diamond	336	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus
10885324	10885324	PRJNA698538_S_NODE_14429_length_316_cov_2.111111_g14263_i0	PRJNA698538	14429	316	2.111111	6.67111076	Mucilaginibacter gotjawali	1550579	Bacteria	Bacteria	564	3.069999999999999e-156	NTclustered	gi\|998615918\|dbj\|AP017313.1\|	1550579	g14263	i0	98.742	281.575949367089	318	2	100	1	1	316	429078	428761	Mucilaginibacter gotjawali DNA, complete genome	blastn	88978	564	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter gotjawali
15212623	15212623	PRJNA698538_S_NODE_11232_length_339_cov_2.845865_g11066_i0	PRJNA698538	11232	339	2.845865	9.64748235	Elizabethkingia	308865	Bacteria	Bacteria	621	1.95e-173	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g11066	i0	99.705	90	339	1	100	0	1	339	4096190	4096528	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	30510	621	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
15984283	15984283	PRJNA698538_S_NODE_7613_length_373_cov_3.296667_g7447_i0	PRJNA698538	7613	373	3.296667	12.29656791	Bacteroidales bacterium	2030927	Bacteria	Bacteria	139	2.94e-39	NR	MDR1847601.1	2030927	g7447	i0	62.5	10.9383378016086	96	36	77.2	0	366	79	57	152	MDR1847601.1 urocanate hydratase [Bacteroidales bacterium]	diamond	4080	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
19035836	19035836	PRJNA698538_S_NODE_10735_length_343_cov_2.811111_g10569_i0	PRJNA698538	10735	343	2.811111	9.64211073	Weeksellaceae	2762318	Bacteria	Bacteria	575	1.5599999999999995e-159	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g10569	i0	97.892	502.31778425656	332	7	97	0	1	332	1757325	1757656	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	172295	580	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
19035840	19035840	PRJNA698538_S_NODE_11855_length_334_cov_3.969349_g11689_i0	PRJNA698538	11855	334	3.969349	13.25762566	Myroides	76831	Bacteria	Bacteria	484	2.6199999999999996e-132	NTclustered	gi\|969868918\|gb\|CP013690.1\|	76832	g11689	i0	92.814	99.8652694610778	334	24	100	0	1	334	511367	511700	Myroides odoratimimus strain PR63039 chromosome, complete genome	blastn	33355	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
19035875	19035875	PRJNA698538_S_NODE_9295_length_356_cov_1.632509_g9129_i0	PRJNA698538	9295	356	1.632509	5.81173204	Chryseobacterium	59732	Bacteria	Bacteria	652	0	NTclustered	gi\|2429067237\|gb\|CP115859.1\|	1265445	g9129	i0	99.719	99.9859550561798	356	1	100	0	1	356	2456145	2456500	Chryseobacterium camelliae strain VAN22-5A chromosome, complete genome	blastn	35595	652	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
21083838	21083838	PRJNA698538_S_NODE_27037_length_250_cov_0.870056_g26871_i0	PRJNA698538	27037	250	0.870056	2.17514	Chryseobacterium sp. Hurlbut	1871047	Bacteria	Bacteria	155	1.31e-44	NR	WP_050380590.1	1681828	g26871	i0	97.6	0.996	83	2	99.6	0	2	250	93	175	WP_050380590.1 SDR family oxidoreductase [Chryseobacterium sp. Hurlbut01]	diamond	249	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. Hurlbut01
22861549	22861549	PRJNA698538_S_NODE_16118_length_305_cov_4.978448_g15952_i0	PRJNA698538	16118	305	4.978448	15.1842664	Aquirufa	2676247	Bacteria	Bacteria	309	1.53e-79	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g15952	i0	85.246	100.045901639344	305	40	99	5	1	301	214089	214392	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	30514	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
27398905	27398905	PRJNA698538_S_NODE_5363_length_405_cov_1.855422_g5197_i0	PRJNA698538	5363	405	1.855422	7.5144591	Taibaiella sp.	1869185	Bacteria	Bacteria	144	3.5399999999999997e-37	NR	MBC7553931.1	1869185	g5197	i0	55	0.97037037037037	131	59	97	0	405	13	529	659	MBC7553931.1 carboxy terminal-processing peptidase [Taibaiella sp.]	diamond	393	144	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Taibaiella	Taibaiella sp.
28503873	28503873	PRJNA698538_S_NODE_28587_length_245_cov_1.790698_g28421_i0	PRJNA698538	28587	245	1.790698	4.3872101	Chitinophagales bacterium	2448779	Bacteria	Bacteria	43.9	0.00534	NR	MEO5674090.1	2448779	g28421	i0	82.6	0.844897959183673	23	4	28.2	0	176	244	14	36	MEO5674090.1 glycogen/starch synthase [Chitinophagales bacterium]	diamond	207	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
28946177	28946177	PRJNA698538_S_NODE_6188_length_392_cov_2.166144_g6022_i0	PRJNA698538	6188	392	2.166144	8.49128448	Ferruginibacter sp. HRS2-29	2487334	Bacteria	Bacteria	144	9.96e-41	NR	WP_255156192.1	2487334	g6022	i0	56.4	1.76785714285714	117	51	89.5	0	14	364	65	181	WP_255156192.1 DUF4352 domain-containing protein [Ferruginibacter sp. HRS2-29]	diamond	693	144	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp. HRS2-29
29388100	29388100	PRJNA698538_S_NODE_19529_length_286_cov_1.253521_g19363_i0	PRJNA698538	19529	286	1.253521	3.58507006	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	42.4	0.0487	NR	HWZ58621.1	2026741	g19363	i0	48	0.524475524475524	50	24	50.3	1	85	228	89	138	HWZ58621.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	150	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29588275	29588275	PRJNA698538_S_NODE_14690_length_314_cov_3.858921_g14524_i0	PRJNA698538	14690	314	3.858921	12.11701194	Pseudomonadati	3379134	Bacteria	Bacteria	113	1.19e-26	NR	TVQ15449.1	1898104	g14524	i0	52.9	2.98089171974522	104	49	99.4	0	312	1	1053	1156	TVQ15449.1 MAG: hypothetical protein EA361_05700 [Bacteroidota bacterium]	diamond	936	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30188608	30188608	PRJNA698538_S_NODE_3412_length_453_cov_3.202632_g3246_i0	PRJNA698538	3412	453	3.202632	14.50792296	Bacteroidota	976	Bacteria	Bacteria	71.2	4.86e-12	NR	MCA1919253.1	1114874	g3246	i0	68.4	1.25827814569536	38	12	25.2	0	428	315	153	190	MCA1919253.1 superoxide dismutase [Flavobacterium piscis]	diamond	570	71.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium piscis
30335887	30335887	PRJNA698538_S_NODE_13972_length_319_cov_2.723577_g13806_i0	PRJNA698538	13972	319	2.723577	8.68821063	Porphyromonadaceae bacterium W3.11	3058992	Bacteria	Bacteria	69.7	3.15e-11	NR	MDN4753990.1	3058992	g13806	i0	44.3	2.17241379310345	79	44	74.3	0	82	318	5	83	MDN4753990.1 anaerobic ribonucleoside triphosphate reductase [Porphyromonadaceae bacterium W3.11]	diamond	693	69.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		Porphyromonadaceae bacterium W3.11
30335892	30335892	PRJNA698538_S_NODE_19392_length_286_cov_3.976526_g19226_i0	PRJNA698538	19392	286	3.976526	11.37286436	Bacteroidales bacterium	2030927	Bacteria	Bacteria	177	1.07e-50	NR	NLA63608.1	2030927	g19226	i0	94.7	0.996503496503496	95	5	99.7	0	2	286	413	507	NLA63608.1 L-aspartate oxidase [Bacteroidales bacterium]	diamond	285	177	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30378672	30378672	PRJNA698538_S_NODE_19792_length_284_cov_3.630332_g19626_i0	PRJNA698538	19792	284	3.630332	10.31014288	Flavobacteriaceae	49546	Bacteria	Bacteria	120	2.95e-29	NR	WP_227057304.1	96345	g19626	i0	74.4	1.67957746478873	78	20	82.4	0	234	1	746	823	WP_227057304.1 type ISP restriction/modification enzyme [Flavobacterium psychrophilum]	diamond	477	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
30556447	30556447	PRJNA698538_S_NODE_13533_length_322_cov_2.461847_g13367_i0	PRJNA698538	13533	322	2.461847	7.92714734	Bacteroidales bacterium	2030927	Bacteria	Bacteria	89	1.91e-18	NR	MFA6676327.1	2030927	g13367	i0	76.9	1.45341614906832	52	11	48.4	1	320	165	282	332	MFA6676327.1 class II fructose-bisphosphate aldolase [Bacteroidales bacterium]	diamond	468	89	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31062430	31062430	PRJNA698538_S_NODE_29595_length_242_cov_1.822485_g29429_i0	PRJNA698538	29595	242	1.822485	4.4104137	Dyadobacter fanqingshengii	2906443	Bacteria	Bacteria	43.1	0.0257	NR	WP_234612282.1	2906443	g29429	i0	34.7	0.929752066115702	75	39	85.5	2	17	223	277	347	WP_234612282.1 complement C1q domain-containing protein [Dyadobacter fanqingshengii]	diamond	225	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fanqingshengii
31104843	31104843	PRJNA698538_S_NODE_14615_length_315_cov_1.706612_g14449_i0	PRJNA698538	14615	315	1.706612	5.3758278	Bacteroidota	976	Bacteria	Bacteria	56.6	4.24e-7	NR	WP_082376992.1	253	g14449	i0	66.7	3.28571428571429	39	13	37.1	0	315	199	152	190	WP_082376992.1 thiol peroxidase [Chryseobacterium indologenes]	diamond	1035	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
31283313	31283313	PRJNA698538_S_NODE_24055_length_263_cov_1.242105_g23889_i0	PRJNA698538	24055	263	1.242105	3.26673615	Bacteroidota bacterium	1898104	Bacteria	Bacteria	42.7	0.046	NR	MEO1049795.1	1898104	g23889	i0	37.5	0.638783269961977	56	33	61.6	1	192	31	56	111	MEO1049795.1 DUF2851 family protein [Bacteroidota bacterium]	diamond	168	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31378441	31378441	PRJNA698538_S_NODE_1896_length_534_cov_1.832972_g1732_i0	PRJNA698538	1896	534	1.832972	9.78807048	Bacteroidetes bacterium GWF2_38_335	1797344	Bacteria	Bacteria	90.1	2.02e-17	NR	OFY36820.1	1797344	g1732	i0	59.2	0.426966292134831	76	31	42.7	0	533	306	410	485	OFY36820.1 MAG: malate dehydrogenase [Bacteroidetes bacterium GWF2_38_335]	diamond	228	90.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium GWF2_38_335
31536664	31536664	PRJNA698538_S_NODE_28536_length_245_cov_2.238372_g28370_i0	PRJNA698538	28536	245	2.238372	5.4840114	Porphyromonas circumdentaria	29524	Bacteria	Bacteria	68.2	3.5e-11	NR	WP_078736611.1	29524	g28370	i0	40	0.979591836734694	80	48	98	0	245	6	105	184	WP_078736611.1 radical SAM protein [Porphyromonas circumdentaria]	diamond	240	68.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas circumdentaria
32370411	32370411	PRJNA698538_S_NODE_10019_length_349_cov_3.565217_g9853_i0	PRJNA698538	10019	349	3.565217	12.44260733	Pseudomonadati	3379134	Bacteria	Bacteria	107	6.53e-25	NR	MCB5251109.1	2030808	g9853	i0	44.8	8.11461318051576	105	58	90.3	0	343	29	283	387	MCB5251109.1 FprA family A-type flavoprotein [Candidatus Cloacimonadota bacterium]	diamond	2832	108	0.990740740740741	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota 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);;