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

29 rows where bioproject = "PRJNA854078" 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
841752	841752	PRJNA854078_P_NODE_7321_length_348_cov_1.876364_g7109_i0	PRJNA854078	7321	348	1.876364	6.52974672	Flavobacterium sediminis	2201181	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g7109	i0	100	0.0833333333333333	29	0	8	0	267	295	3205777	3205749	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis
5944829	5944829	PRJNA854078_P_NODE_11845_length_274_cov_1.149254_g11633_i0	PRJNA854078	11845	274	1.149254	3.14895596	Tannerella serpentiformis	712710	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g11633	i0	100	0.204379562043796	28	0	10	0	193	220	1533154	1533181	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
8887765	8887765	PRJNA854078_P_NODE_14407_length_250_cov_0.870056_g14195_i0	PRJNA854078	14407	250	0.870056	2.17514	Chryseobacterium	59732	Bacteria	Bacteria	407	4.1899999999999994e-109	NTclustered	gi\|2039848361\|gb\|CP074372.1\|	253	g14195	i0	96	50.924	250	10	100	0	1	250	2274323	2274074	Chryseobacterium indologenes strain PgBE177 chromosome, complete genome	blastn	12731	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
13595417	13595417	PRJNA854078_P_NODE_14351_length_250_cov_0.870056_g14139_i0	PRJNA854078	14351	250	0.870056	2.17514	Chryseobacterium sp. JV274	1932669	Bacteria	Bacteria	329	9.34e-86	NTclustered	gi\|1868782965\|emb\|LR824569.1\|	1932669	g14139	i0	90.4	5.832	250	24	100	0	1	250	1741292	1741541	Chryseobacterium sp. JV274 strain F3_Prior genome assembly, chromosome: I	blastn	1458	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. JV274
13988609	13988609	PRJNA854078_P_NODE_14111_length_251_cov_0.865169_g13899_i0	PRJNA854078	14111	251	0.865169	2.17157419	Chryseobacterium	59732	Bacteria	Bacteria	353	5.569999999999998e-93	NTclustered	gi\|2039848361\|gb\|CP074372.1\|	253	g13899	i0	92.063	28.0358565737052	252	19	100	1	1	251	189124	189375	Chryseobacterium indologenes strain PgBE177 chromosome, complete genome	blastn	7037	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
16144412	16144412	PRJNA854078_P_NODE_14093_length_251_cov_0.865169_g13881_i0	PRJNA854078	14093	251	0.865169	2.17157419	Chryseobacterium indologenes	253	Bacteria	Bacteria	337	5.609999999999998e-88	NTclustered	gi\|2039848361\|gb\|CP074372.1\|	253	g13881	i0	90.837	2.99601593625498	251	23	100	0	1	251	2966300	2966550	Chryseobacterium indologenes strain PgBE177 chromosome, complete genome	blastn	752	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
22518418	22518418	PRJNA854078_P_NODE_15338_length_246_cov_0.890173_g15126_i0	PRJNA854078	15338	246	0.890173	2.18982558	Chryseobacterium sp. KCF3-3	3231511	Bacteria	Bacteria	226	1.2399999999999997e-54	NTclustered	gi\|2802707432\|dbj\|AP035792.1\|	3231511	g15126	i0	92.949	25.1910569105691	156	9	63	2	91	246	223630	223783	Chryseobacterium sp. KCF3-3 DNA, complete genome	blastn	6197	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. KCF3-3
23793852	23793852	PRJNA854078_P_NODE_11019_length_284_cov_1.118483_g10807_i0	PRJNA854078	11019	284	1.118483	3.17649172	Sphingobacterium sp. G1-14	2003121	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|1207396639\|gb\|CP021381.1\|	2003121	g10807	i0	100	11	284	0	100	0	1	284	3541447	3541164	Sphingobacterium sp. G1-14, complete genome	blastn	3124	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. G1-14
25067772	25067772	PRJNA854078_P_NODE_14040_length_251_cov_0.921348_g13828_i0	PRJNA854078	14040	251	0.921348	2.31258348	Winogradskyella eximia	262006	Bacteria	Bacteria	73.9	5.58e-15	NR	WP_115817787.1	262006	g13828	i0	41.6	3.70517928286853	77	44	92	1	20	250	5	80	WP_115817787.1 thioredoxin [Winogradskyella eximia]	diamond	930	73.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella eximia
27181299	27181299	PRJNA854078_P_NODE_322_length_1612_cov_6.115660_g251_i0	PRJNA854078	322	1612	6.11566	98.5844392	Emticicia sp. 17c	3127704	Bacteria	Bacteria	388	5.17e-122	NR	WP_337045214.1	3127704	g251	i0	53.5	0.660669975186104	355	157	65	4	22	1068	27	379	WP_337045214.1 hypothetical protein [Emticicia sp. 17c]	diamond	1065	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 17c
27727068	27727068	PRJNA854078_P_NODE_6444_length_371_cov_2.080537_g6232_i0	PRJNA854078	6444	371	2.080537	7.71879227	Bacteria	2	Bacteria	Bacteria	55.8	4.15e-6	NR	MES2811807.1	1898104	g6232	i0	41.6	3.41239892183288	101	54	78.4	3	305	15	329	428	MES2811807.1 endonuclease [Bacteroidota bacterium]	diamond	1266	56.2	0.99288256227758	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27813414	27813414	PRJNA854078_P_NODE_5064_length_421_cov_1.666667_g4852_i0	PRJNA854078	5064	421	1.666667	7.01666807	candidate division Zixibacteria bacterium RBG_16_43_9	1802784	Bacteria	Bacteria	98.2	1.73e-22	NR	OGC84902.1	1802784	g4852	i0	39.6	7.38242280285036	134	77	95.5	2	3	404	8	137	OGC84902.1 MAG: septum formation protein Maf [candidate division Zixibacteria bacterium RBG_16_43_9]	diamond	3108	98.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota					candidate division Zixibacteria bacterium RBG_16_43_9
28034333	28034333	PRJNA854078_P_NODE_12125_length_270_cov_2.106599_g11913_i0	PRJNA854078	12125	270	2.106599	5.6878173	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	53.1	1.14e-5	NR	MBL0293990.1	2202734	g11913	i0	40.8	1.74444444444444	76	40	82.2	2	235	14	1158	1230	MBL0293990.1 fibronectin type III domain-containing protein [Saprospiraceae bacterium]	diamond	471	53.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
28507863	28507863	PRJNA854078_P_NODE_5567_length_401_cov_1.426829_g5355_i0	PRJNA854078	5567	401	1.426829	5.72158429	Bacteroidales bacterium	2030927	Bacteria	Bacteria	58.5	6.8e-7	NR	MBQ4442661.1	2030927	g5355	i0	32.8	2.00498753117207	134	80	95.8	2	10	393	1607	1736	MBQ4442661.1 fibronectin type III domain-containing protein [Bacteroidales bacterium]	diamond	804	58.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28728856	28728856	PRJNA854078_P_NODE_307_length_1642_cov_3.745061_g241_i0	PRJNA854078	307	1642	3.745061	61.49390162	Emticicia sp. 17c	3127704	Bacteria	Bacteria	394	2.09e-124	NR	WP_337045214.1	3127704	g241	i0	55.9	1.52740560292326	345	144	61.9	4	1640	624	37	379	WP_337045214.1 hypothetical protein [Emticicia sp. 17c]	diamond	2508	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 17c
28950049	28950049	PRJNA854078_P_NODE_4608_length_442_cov_2.959350_g4396_i0	PRJNA854078	4608	442	2.95935	13.080327	Bacteroidota bacterium	1898104	Bacteria	Bacteria	50.4	6.26e-4	NR	GDX51860.1	1898104	g4396	i0	27	0.855203619909502	126	78	76	4	338	3	996	1121	GDX51860.1 hypothetical protein LBMAG27_09070 [Bacteroidota bacterium]	diamond	378	50.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28981608	28981608	PRJNA854078_P_NODE_368_length_1512_cov_2.676859_g282_i0	PRJNA854078	368	1512	2.676859	40.47410808	Emticicia sp. 17c	3127704	Bacteria	Bacteria	354	1.31e-109	NR	WP_337045214.1	3127704	g282	i0	51	3.55952380952381	357	167	69.6	4	19	1071	27	381	WP_337045214.1 hypothetical protein [Emticicia sp. 17c]	diamond	5382	354	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 17c
29013289	29013289	PRJNA854078_P_NODE_2628_length_588_cov_2.638835_g2422_i0	PRJNA854078	2628	588	2.638835	15.5163498	Bacteroidales bacterium	2030927	Bacteria	Bacteria	59.3	1.95e-6	NR	MDF1546861.1	2030927	g2422	i0	37.4	1.41836734693878	155	89	77	5	43	495	766	916	MDF1546861.1 M4 family metallopeptidase [Bacteroidales bacterium]	diamond	834	59.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29454634	29454634	PRJNA854078_P_NODE_4390_length_453_cov_2.234211_g4178_i0	PRJNA854078	4390	453	2.234211	10.12097583	Bacteroidota bacterium	1898104	Bacteria	Bacteria	48.5	0.00191	NR	HRS02609.1	1898104	g4178	i0	36.7	0.52317880794702	79	49	51.7	1	236	3	100	178	HRS02609.1 fibronectin type III domain-containing protein [Bacteroidota bacterium]	diamond	237	48.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29549544	29549544	PRJNA854078_P_NODE_8170_length_329_cov_1.726562_g7958_i0	PRJNA854078	8170	329	1.726562	5.68038898	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	57.8	7.34e-8	NR	NCW45907.1	2026741	g7958	i0	40.3	1.66869300911854	77	41	70.2	2	234	4	25	96	NCW45907.1 tryptophan-rich sensory protein [Gemmatimonadaceae bacterium]	diamond	549	57.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29897200	29897200	PRJNA854078_P_NODE_4271_length_459_cov_4.766839_g4059_i0	PRJNA854078	4271	459	4.766839	21.87979101	Chryseobacterium gambrini	373672	Bacteria	Bacteria	50.8	5.21e-4	NR	WP_084196507.1	373672	g4059	i0	34.5	0.928104575163399	142	87	90.8	4	459	43	291	429	WP_084196507.1 endonuclease [Chryseobacterium gambrini]	diamond	426	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
29897201	29897201	PRJNA854078_P_NODE_651_length_1181_cov_2.787004_g523_i0	PRJNA854078	651	1181	2.787004	32.91451724	Fibrella sp. WM1	3242485	Bacteria	Bacteria	231	1.93e-65	NR	WP_370701424.1	3242485	g523	i0	41.7	0.906858594411516	357	185	85.6	7	4	1014	200	553	WP_370701424.1 hypothetical protein [Fibrella sp. WM1]	diamond	1071	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella musci
29936938	29936938	PRJNA854078_P_NODE_7271_length_349_cov_2.369565_g7059_i0	PRJNA854078	7271	349	2.369565	8.26978185	Polaribacter	52959	Bacteria	Bacteria	56.6	1.72e-6	NR	WP_068364217.1	996801	g7059	i0	35.6	1.71919770773639	90	53	73.9	3	70	327	316	404	WP_068364217.1 endonuclease [Polaribacter reichenbachii]	diamond	600	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter reichenbachii
31128951	31128951	PRJNA854078_P_NODE_6315_length_375_cov_1.715232_g6103_i0	PRJNA854078	6315	375	1.715232	6.43212	Winogradskyella sp. PE311	3366943	Bacteria	Bacteria	47	0.00442	NR	WP_411125040.1	3366943	g6103	i0	34.9	0.664	83	51	64	2	366	127	41	123	WP_411125040.1 hypothetical protein [Winogradskyella sp. PE311]	diamond	249	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella sp. PE311
31508928	31508928	PRJNA854078_P_NODE_3216_length_529_cov_104.701754_g3004_i0	PRJNA854078	3216	529	104.701754	553.87227866	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	54.3	5.68e-5	NR	PIE50853.1	2021391	g3004	i0	38.7	0.958412098298677	75	42	40.3	1	351	139	293	367	PIE50853.1 MAG: endonuclease I [Flavobacteriales bacterium]	diamond	507	54.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
31833087	31833087	PRJNA854078_P_NODE_377_length_1492_cov_8.241015_g289_i0	PRJNA854078	377	1492	8.241015	122.9559438	Bacteroidota	976	Bacteria	Bacteria	417	1.0599999999999999e-136	NR	WP_052598397.1	1313421	g289	i0	44.2	3.85053619302949	525	227	97.1	10	1450	2	19	519	WP_052598397.1 glycosyl hydrolase family 18 protein [Aureispira sp. CCB-QB1]	diamond	5745	418	0.997607655502392	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira sp. CCB-QB1
32458027	32458027	PRJNA854078_P_NODE_239_length_1877_cov_4.303215_g187_i0	PRJNA854078	239	1877	4.303215	80.77134555	Flammeovirga sp. EKP2	1978526	Bacteria	Bacteria	107	4.96e-20	NR	WP_188171209.1	2770592	g187	i0	29.8	0.847096430474161	530	320	82.6	22	95	1645	738	1228	WP_188171209.1 fibronectin type III domain-containing protein [Flammeovirga sp. EKP202]	diamond	1590	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Flammeovirga	Flammeovirga sp. EKP202
32529547	32529547	PRJNA854078_P_NODE_3179_length_533_cov_0.995652_g2967_i0	PRJNA854078	3179	533	0.995652	5.30682516	Alistipes	239759	Bacteria	Bacteria	163	5.52e-44	NR	MBP3482326.1	1872444	g2967	i0	51.4	11.8480300187617	175	79	96.2	3	523	11	91	263	MBP3482326.1 C69 family dipeptidase [Alistipes sp.]	diamond	6315	164	0.99390243902439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
32907282	32907282	PRJNA854078_P_NODE_9120_length_312_cov_1.158996_g8908_i0	PRJNA854078	9120	312	1.158996	3.61606752	Bacteria	2	Bacteria	Bacteria	121	4.6399999999999994e-30	NR	WP_185877965.1	1653831	g8908	i0	56.3	13.4519230769231	103	45	99	0	311	3	149	251	WP_185877965.1 class II fumarate hydratase [Blattabacterium cuenoti]	diamond	4197	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti

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