metadata: contig_metadata: 30 rows where bioproject = "PRJNA345071" and tax

30 rows where bioproject = "PRJNA345071" 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
1070364	1070364	PRJNA345071_P_NODE_11261_length_228_cov_2.064516_g11221_i0	PRJNA345071	11261	228	2.064516	4.70709648	Elizabethkingia	308865	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g11221	i0	100	478.991228070175	228	0	100	0	1	228	304715	304942	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	109210	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
1070365	1070365	PRJNA345071_P_NODE_1921_length_406_cov_2.201201_g1881_i0	PRJNA345071	1921	406	2.201201	8.93687606	Hymenobacter	89966	Bacteria	Bacteria	649	0	NTclustered	gi\|1844056603\|gb\|CP053538.1\|	2735321	g1881	i0	95.556	281.551724137931	405	18	99	0	2	406	244081	244485	Hymenobacter taeanensis strain TS19 chromosome, complete genome	blastn	114310	649	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter taeanensis
4898217	4898217	PRJNA345071_P_NODE_10564_length_243_cov_0.917647_g10524_i0	PRJNA345071	10564	243	0.917647	2.22988221	Bacteroidota	976	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2290648998\|gb\|CP103151.1\|	817	g10524	i0	100	138.753086419753	243	0	100	0	1	243	4368962	4368720	Bacteroides fragilis strain BFG-167 chromosome, complete genome	blastn	33717	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
4898221	4898221	PRJNA345071_P_NODE_11044_length_236_cov_2.564417_g11004_i0	PRJNA345071	11044	236	2.564417	6.05202412	Hymenobacter	89966	Bacteria	Bacteria	427	3.01e-115	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g11004	i0	99.573	280.754237288136	234	1	99	0	1	234	505241	505474	Hymenobacter swuensis DY53, complete genome	blastn	66258	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
5497080	5497080	PRJNA345071_P_NODE_8765_length_249_cov_0.886364_g8725_i0	PRJNA345071	8765	249	0.886364	2.20704636	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g8725	i0	100	87.3614457831325	249	0	100	0	1	249	834441	834689	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	21753	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
8046680	8046680	PRJNA345071_P_NODE_6847_length_262_cov_1.587302_g6807_i0	PRJNA345071	6847	262	1.587302	4.15873124	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	462	9.319999999999999e-126	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g6807	i0	98.479	2.54961832061069	263	3	100	1	1	262	2036330	2036592	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	668	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
16372941	16372941	PRJNA345071_P_NODE_2873_length_350_cov_1.126354_g2833_i0	PRJNA345071	2873	350	1.126354	3.942239	Hymenobacter	89966	Bacteria	Bacteria	549	9.619999999999996e-152	NTclustered	gi\|1594476705\|gb\|CP037922.1\|	2496028	g2833	i0	95.129	318.754285714286	349	16	99	1	1	349	1252834	1253181	Hymenobacter radiodurans strain 17J36-26 chromosome, complete genome	blastn	111564	551	0.996370235934664	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter radiodurans
20196453	20196453	PRJNA345071_P_NODE_2856_length_350_cov_3.339350_g2816_i0	PRJNA345071	2856	350	3.33935	11.687725	Hymenobacter	89966	Bacteria	Bacteria	575	1.5899999999999994e-159	NTclustered	gi\|2221923801\|gb\|CP095046.1\|	2932248	g2816	i0	96.812	364.571428571429	345	10	99	1	1	345	978739	978396	Hymenobacter cellulosilyticus strain 5116 S-3 chromosome, complete genome	blastn	127600	580	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter cellulosilyticus
20794727	20794727	PRJNA345071_P_NODE_3397_length_331_cov_2.643411_g3357_i0	PRJNA345071	3397	331	2.643411	8.74969041	Hymenobacter sp. GOD-10R	3093922	Bacteria	Bacteria	551	2.5199999999999993e-152	NTclustered	gi\|2647515459\|gb\|CP141184.1\|	3093922	g3357	i0	96.677	281.634441087613	331	11	100	0	1	331	1703358	1703028	Hymenobacter sp. GOD-10R chromosome, complete genome	blastn	93221	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. GOD-10R
20794863	20794863	PRJNA345071_P_NODE_9617_length_246_cov_0.901734_g9577_i0	PRJNA345071	9617	246	0.901734	2.21826564	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g9577	i0	99.187	1.95528455284553	246	2	100	0	1	246	4738269	4738024	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	481	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
22069717	22069717	PRJNA345071_P_NODE_10518_length_243_cov_0.917647_g10478_i0	PRJNA345071	10518	243	0.917647	2.22988221	Capnocytophaga ochracea	1018	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2325766218\|gb\|CP110228.1\|	1018	g10478	i0	99.588	11.8271604938272	243	1	100	0	1	243	146459	146217	Capnocytophaga ochracea strain KCOM 2191 chromosome, complete genome	blastn	2874	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga ochracea
22069884	22069884	PRJNA345071_P_NODE_698_length_611_cov_2.291822_g658_i0	PRJNA345071	698	611	2.291822	14.00303242	Balneolaceae bacterium	2053516	Bacteria	Bacteria	104	1.52e-24	NR	MDX1619131.1	2053516	g658	i0	48.5	1.03600654664484	103	53	50.6	0	257	565	43	145	MDX1619131.1 Hsp20/alpha crystallin family protein [Balneolaceae bacterium]	diamond	633	104	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
26694802	26694802	PRJNA345071_P_NODE_9861_length_245_cov_0.906977_g9821_i0	PRJNA345071	9861	245	0.906977	2.22209365	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	42.7	0.032	NR	HEY6220477.1	2026741	g9821	i0	34.6	0.955102040816327	78	47	95.5	2	1	234	1	74	HEY6220477.1 YoaK family protein [Gemmatimonadaceae bacterium]	diamond	234	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26790030	26790030	PRJNA345071_P_NODE_10141_length_244_cov_0.912281_g10101_i0	PRJNA345071	10141	244	0.912281	2.22596564	Rhodothermales bacterium	2306054	Bacteria	Bacteria	47.8	6.26e-4	NR	MFT5130753.1	2306054	g10101	i0	42.2	0.786885245901639	64	36	78.7	1	15	206	296	358	MFT5130753.1 cytochrome c2 [Rhodothermales bacterium]	diamond	192	47.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
26948092	26948092	PRJNA345071_P_NODE_9362_length_247_cov_0.896552_g9322_i0	PRJNA345071	9362	247	0.896552	2.21448344	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	47.4	7.59e-4	NR	MBX7052925.1	2021391	g9322	i0	36.6	0.995951417004049	82	47	99.6	2	2	247	96	172	MBX7052925.1 FkbM family methyltransferase [Flavobacteriales bacterium]	diamond	246	47.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27345028	27345028	PRJNA345071_P_NODE_9223_length_247_cov_0.896552_g9183_i0	PRJNA345071	9223	247	0.896552	2.21448344	Bacteroidota	976	Bacteria	Bacteria	73.9	4.02e-13	NR	WP_021069665.1	1385985	g9183	i0	59.3	5.35627530364372	59	24	71.7	0	178	2	136	194	WP_021069665.1 serine/threonine-protein kinase [Sphingobacterium paucimobilis]	diamond	1323	73.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium paucimobilis
27801418	27801418	PRJNA345071_P_NODE_8204_length_251_cov_0.876404_g8164_i0	PRJNA345071	8204	251	0.876404	2.19977404	Arsenicibacter rosenii	1750698	Bacteria	Bacteria	142	3.98e-39	NR	WP_071501647.1	1750698	g8164	i0	96.2	0.932270916334661	78	3	93.2	0	238	5	1	78	WP_071501647.1 SDR family NAD(P)-dependent oxidoreductase [Arsenicibacter rosenii]	diamond	234	142	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Arsenicibacter	Arsenicibacter rosenii
28179952	28179952	PRJNA345071_P_NODE_7646_length_253_cov_0.866667_g7606_i0	PRJNA345071	7646	253	0.866667	2.19266751	Raineya sp.	2071615	Bacteria	Bacteria	59.7	2.89e-8	NR	MCU0438948.1	2071615	g7606	i0	41.5	2.32411067193676	65	38	77.1	0	41	235	67	131	MCU0438948.1 TIGR00266 family protein [Raineya sp.]	diamond	588	59.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Raineyaceae	Raineya	Raineya sp.
28401196	28401196	PRJNA345071_P_NODE_4926_length_292_cov_1.365297_g4886_i0	PRJNA345071	4926	292	1.365297	3.98666724	Marinilabiliales bacterium	2053303	Bacteria	Bacteria	50.8	9.52e-5	NR	MCE1197837.1	2053303	g4886	i0	34	1.05821917808219	103	52	96.6	5	11	292	108	203	MCE1197837.1 hypothetical protein [Marinilabiliales bacterium]	diamond	309	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales			Marinilabiliales bacterium
28432834	28432834	PRJNA345071_P_NODE_2806_length_353_cov_2.228571_g2766_i0	PRJNA345071	2806	353	2.228571	7.86685563	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	66.6	5.68e-10	NR	MBK13185.1	2026728	g2766	i0	42.5	2.82152974504249	87	47	73.9	2	89	349	26	109	MBK13185.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	996	66.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
28906164	28906164	PRJNA345071_P_NODE_9988_length_245_cov_0.906977_g9948_i0	PRJNA345071	9988	245	0.906977	2.22209365	Candidatus Cryptobacteroides excrementipullorum	2840761	Bacteria	Bacteria	138	7.82e-36	NR	MBO8479386.1	2840761	g9948	i0	86.1	1.92244897959184	79	11	96.7	0	237	1	301	379	MBO8479386.1 protein translocase subunit SecDF [Candidatus Cryptobacteroides excrementipullorum]	diamond	471	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales		Candidatus Cryptobacteroides	Candidatus Cryptobacteroides excrementipullorum
29001490	29001490	PRJNA345071_P_NODE_9128_length_247_cov_3.413793_g9088_i0	PRJNA345071	9128	247	3.413793	8.43206871	Segatella copri	165179	Bacteria	Bacteria	107	3.56e-28	NR	WP_203031503.1	165179	g9088	i0	92.7	0.668016194331984	55	4	66.8	0	246	82	35	89	WP_203031503.1 hypothetical protein [Segatella copri]	diamond	165	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
29159155	29159155	PRJNA345071_P_NODE_8249_length_251_cov_0.876404_g8209_i0	PRJNA345071	8249	251	0.876404	2.19977404	Maribacter sp.	1897614	Bacteria	Bacteria	53.9	4.63e-6	NR	NND79417.1	1897614	g8209	i0	50	0.621513944223108	52	25	61	1	178	26	5	56	NND79417.1 mannitol dehydrogenase family protein [Maribacter sp.]	diamond	156	53.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Maribacter	Maribacter sp.
29190665	29190665	PRJNA345071_P_NODE_2409_length_373_cov_3.013333_g2369_i0	PRJNA345071	2409	373	3.013333	11.23973209	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	48.5	1.35e-4	NR	MFM7857885.1	2026740	g2369	i0	43.9	0.458445040214477	57	31	45	1	27	194	7	63	MFM7857885.1 hypothetical protein [Flammeovirgaceae bacterium]	diamond	171	48.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
29537791	29537791	PRJNA345071_P_NODE_10830_length_242_cov_0.923077_g10790_i0	PRJNA345071	10830	242	0.923077	2.23384634	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	63.9	1.28e-9	NR	HEU4996224.1	2026741	g10790	i0	51.3	1.89669421487603	78	36	96.7	1	239	6	1209	1284	HEU4996224.1 invasin domain 3-containing protein [Gemmatimonadaceae bacterium]	diamond	459	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29632229	29632229	PRJNA345071_P_NODE_8990_length_248_cov_0.891429_g8950_i0	PRJNA345071	8990	248	0.891429	2.21074392	Candidatus Cryptobacteroides merdigallinarum	2840770	Bacteria	Bacteria	124	1.16e-32	NR	MBO8448727.1	2840770	g8950	i0	70.4	0.979838709677419	81	24	98	0	247	5	173	253	MBO8448727.1 AraC family transcriptional regulator [Candidatus Cryptobacteroides merdigallinarum]	diamond	243	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales		Candidatus Cryptobacteroides	Candidatus Cryptobacteroides merdigallinarum
31450926	31450926	PRJNA345071_P_NODE_4996_length_291_cov_1.123853_g4956_i0	PRJNA345071	4996	291	1.123853	3.27041223	Candidatus Caccoplasma	2840531	Bacteria	Bacteria	146	1.79e-39	NR	HIT38957.1	2840716	g4956	i0	75	1.97938144329897	96	24	99	0	290	3	66	161	HIT38957.1 tetratricopeptide repeat protein [Candidatus Caccoplasma intestinavium]	diamond	576	147	0.993197278911565	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Candidatus Caccoplasma	Candidatus Caccoplasma intestinavium
31749743	31749743	PRJNA345071_P_NODE_3937_length_314_cov_1.850622_g3897_i0	PRJNA345071	3937	314	1.850622	5.81095308	Ferruginibacter sp.	1940288	Bacteria	Bacteria	69.3	6.77e-12	NR	MEP6676074.1	1940288	g3897	i0	41.6	0.964968152866242	101	51	95.5	2	1	300	62	155	MEP6676074.1 hypothetical protein [Ferruginibacter sp.]	diamond	303	69.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
32288097	32288097	PRJNA345071_P_NODE_7699_length_253_cov_0.866667_g7659_i0	PRJNA345071	7699	253	0.866667	2.19266751	Bacteroidales bacterium	2030927	Bacteria	Bacteria	142	1.34e-40	NR	MBQ1209364.1	2030927	g7659	i0	90.4	4.93280632411067	83	8	98.4	0	1	249	140	222	MBQ1209364.1 paraslipin [Bacteroidales bacterium]	diamond	1248	142	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32509519	32509519	PRJNA345071_P_NODE_9599_length_246_cov_0.901734_g9559_i0	PRJNA345071	9599	246	0.901734	2.21826564	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	42.4	0.0113	NR	MDB4187301.1	1871037	g9559	i0	76	0.304878048780488	25	6	30.5	0	3	77	24	48	MDB4187301.1 BspA family leucine-rich repeat surface protein [Flavobacteriaceae bacterium]	diamond	75	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae 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);;