metadata: contig_metadata: 28 rows where bioproject = "PRJNA1137393", tax_clade = "FCB group" and tax

28 rows where bioproject = "PRJNA1137393", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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
284826	284826	PRJNA1137393_P_NODE_71221_length_162_cov_0.920354_g70705_i0	PRJNA1137393	71221	162	0.920354	1.49097348	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	71.2	7.4e-13	NR	HEY4954885.1	2026741	g70705	i0	79.1	1.68518518518519	43	9	79.6	0	131	3	2	44	HEY4954885.1 ring-cleaving dioxygenase [Gemmatimonadaceae bacterium]	diamond	273	71.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
4111768	4111768	PRJNA1137393_P_NODE_42584_length_169_cov_0.866667_g42068_i0	PRJNA1137393	42584	169	0.866667	1.46466723	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	148	1.75e-31	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g42068	i0	86.567	8.2189349112426	134	18	79	0	1	134	4689604	4689737	Gemmatimonas phototrophica strain AP64, complete genome	blastn	1389	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
4111894	4111894	PRJNA1137393_P_NODE_9764_length_265_cov_2.208333_g9248_i0	PRJNA1137393	9764	265	2.208333	5.85208245	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	348	2.76e-91	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g9248	i0	91.188	149.350943396226	261	15	97	7	9	265	802205	801949	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	39578	348	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5387873	5387873	PRJNA1137393_P_NODE_20525_length_200_cov_2.178808_g20009_i0	PRJNA1137393	20525	200	2.178808	4.357616	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	239	1.24e-58	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g20009	i0	96.528	88.655	144	5	72	0	1	144	1103077	1103220	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	17731	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
5388063	5388063	PRJNA1137393_P_NODE_9185_length_274_cov_0.928889_g8669_i0	PRJNA1137393	9185	274	0.928889	2.54515586	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	248	2.99e-61	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g8669	i0	88.725	191.704379562044	204	21	74	2	1	202	802691	802894	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	52527	248	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6134920	6134920	PRJNA1137393_P_NODE_35605_length_173_cov_1.935484_g35089_i0	PRJNA1137393	35605	173	1.935484	3.34838732	root	1	Root_unresolved	Root_unresolved	172	1.07e-38	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g35089	i0	85.143	79.1734104046243	175	18	100	6	1	173	231347	231515	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	13697	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
6662507	6662507	PRJNA1137393_P_NODE_15346_length_220_cov_2.333333_g14830_i0	PRJNA1137393	15346	220	2.333333	5.1333326	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	259	1.07e-64	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g14830	i0	88.288	14.8136363636364	222	19	100	5	1	220	1903338	1903554	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3259	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11763274	11763274	PRJNA1137393_P_NODE_10370_length_257_cov_5.769231_g9854_i0	PRJNA1137393	10370	257	5.7692310000000004	14.82692367	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	396	9.379999999999997e-106	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g9854	i0	95.547	157.750972762646	247	11	96	0	11	257	803510	803756	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	40542	396	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11763349	11763349	PRJNA1137393_P_NODE_31250_length_179_cov_2.100000_g30734_i0	PRJNA1137393	31250	179	2.1	3.759	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	185	1.43e-42	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g30734	i0	86.826	8.44692737430168	167	20	93	2	3	168	2075176	2075011	Gemmatimonas phototrophica strain AP64, complete genome	blastn	1512	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
14313577	14313577	PRJNA1137393_P_NODE_10852_length_252_cov_1.901478_g10336_i0	PRJNA1137393	10852	252	1.901478	4.79172456	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	361	3.34e-95	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g10336	i0	92.49	17.4563492063492	253	17	100	2	1	252	3043564	3043815	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4399	361	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14313671	14313671	PRJNA1137393_P_NODE_41812_length_169_cov_0.866667_g41296_i0	PRJNA1137393	41812	169	0.866667	1.46466723	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g41296	i0	100	0.177514792899408	30	0	18	0	114	143	403654	403683	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14313780	14313780	PRJNA1137393_P_NODE_74172_length_159_cov_2.272727_g73656_i0	PRJNA1137393	74172	159	2.272727	3.61363593	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	233	4.38e-57	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g73656	i0	93.082	2	159	11	100	0	1	159	3043929	3043771	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	318	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15587647	15587647	PRJNA1137393_P_NODE_4933_length_399_cov_5.120000_g4418_i0	PRJNA1137393	4933	399	5.12	20.4288	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	499	1.14e-136	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g4418	i0	89.594	100.037593984962	394	39	98	2	2	394	421004	421396	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	39915	499	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19410653	19410653	PRJNA1137393_P_NODE_32596_length_177_cov_2.617188_g32080_i0	PRJNA1137393	32596	177	2.617188	4.63242276	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	239	1.07e-58	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g32080	i0	91.111	218.45197740113	180	10	100	6	1	177	1904741	1904565	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	38666	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20686101	20686101	PRJNA1137393_P_NODE_26777_length_186_cov_8.518248_g26261_i0	PRJNA1137393	26777	186	8.518248	15.84394128	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	204	4.15e-48	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g26261	i0	90.446	94.6881720430108	157	11	84	4	28	183	343510	343663	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	17612	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24510785	24510785	PRJNA1137393_P_NODE_73780_length_161_cov_4.000000_g73264_i0	PRJNA1137393	73780	161	4	6.44	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	150	4.61e-32	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g73264	i0	88.71	72.4472049689441	124	12	78	2	36	158	420757	420879	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	11664	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27639227	27639227	PRJNA1137393_P_NODE_54044_length_166_cov_0.888889_g53528_i0	PRJNA1137393	54044	166	0.888889	1.47555574	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	41.6	0.0348	NR	MCX5755190.1	2026742	g53528	i0	44.7	0.849397590361446	47	18	81.3	2	14	148	16	56	MCX5755190.1 UPF0182 family protein [Gemmatimonadota bacterium]	diamond	141	41.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27670820	27670820	PRJNA1137393_P_NODE_8764_length_281_cov_1.810345_g8248_i0	PRJNA1137393	8764	281	1.810345	5.08706945	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.0408	NR	MYH51855.1	2026742	g8248	i0	41.5	0.693950177935943	65	33	69.4	2	54	248	208	267	MYH51855.1 aminotransferase class V-fold PLP-dependent enzyme [Gemmatimonadota bacterium]	diamond	195	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28649551	28649551	PRJNA1137393_P_NODE_62867_length_164_cov_0.904348_g62351_i0	PRJNA1137393	62867	164	0.904348	1.48313072	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	98.2	4.679999999999999e-23	NR	GJG89246.1	2839016	g62351	i0	83.3	0.98780487804878	54	9	98.8	0	3	164	34	87	GJG89246.1 hypothetical protein tb265_44270 [Gemmatimonadetes bacterium T265]	diamond	162	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
29059981	29059981	PRJNA1137393_P_NODE_32088_length_178_cov_1.604651_g31572_i0	PRJNA1137393	32088	178	1.604651	2.85627878	Gemmatimonas sp.	1962908	Bacteria	Bacteria	46.2	8.84e-4	NR	MQA90362.1	1962908	g31572	i0	70.8	0.404494382022472	24	7	40.4	0	105	176	2	25	MQA90362.1 hypothetical protein [Gemmatimonas sp.]	diamond	72	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
29470049	29470049	PRJNA1137393_P_NODE_8010_length_295_cov_5.223577_g7494_i0	PRJNA1137393	8010	295	5.223577	15.40955215	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	45.8	0.00556	NR	HKH82792.1	2448054	g7494	i0	39.4	0.671186440677966	66	35	66.1	2	86	280	263	324	HKH82792.1 APC family permease [Gemmatimonadales bacterium]	diamond	198	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29944125	29944125	PRJNA1137393_P_NODE_27151_length_186_cov_1.284672_g26635_i0	PRJNA1137393	27151	186	1.284672	2.38948992	Longimicrobium sp.	2029185	Bacteria	Bacteria	100	2.66e-25	NR	HEX8245191.1	2029185	g26635	i0	92.5	2.56451612903226	53	4	85.5	0	27	185	1	53	HEX8245191.1 TraR/DksA C4-type zinc finger protein [Longimicrobium sp.]	diamond	477	100	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30481172	30481172	PRJNA1137393_P_NODE_53053_length_166_cov_0.888889_g52537_i0	PRJNA1137393	53053	166	0.888889	1.47555574	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	94.4	4.26e-21	NR	HET9464089.1	2448054	g52537	i0	92.6	1.95180722891566	54	4	97.6	0	163	2	124	177	HET9464089.1 galactokinase [Gemmatimonadales bacterium]	diamond	324	94.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30722825	30722825	PRJNA1137393_P_NODE_51134_length_167_cov_0.881356_g50618_i0	PRJNA1137393	51134	167	0.881356	1.47186452	Pseudomonadati	3379134	Bacteria	Bacteria	70.9	5.24e-13	NR	NNG17336.1	2448054	g50618	i0	65.4	1.92215568862275	52	18	93.4	0	161	6	150	201	NNG17336.1 trehalose-phosphatase [Gemmatimonadales bacterium]	diamond	321	71.6	0.990223463687151	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31271128	31271128	PRJNA1137393_P_NODE_5695_length_363_cov_4.133758_g5179_i0	PRJNA1137393	5695	363	4.133758	15.00554154	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	97.8	3.88e-21	NR	HEU5042096.1	2448054	g5179	i0	73.8	0.661157024793388	80	18	65.3	2	7	243	310	387	HEU5042096.1 HD domain-containing protein [Gemmatimonadales bacterium]	diamond	240	97.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31998623	31998623	PRJNA1137393_P_NODE_61698_length_164_cov_0.904348_g61182_i0	PRJNA1137393	61698	164	0.904348	1.48313072	Longimicrobium sp.	2029185	Bacteria	Bacteria	98.6	2.45e-22	NR	WP_325310493.1	2029185	g61182	i0	92.6	0.98780487804878	54	4	98.8	0	163	2	3	56	WP_325310493.1 malate synthase A [Longimicrobium sp.]	diamond	162	98.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32630897	32630897	PRJNA1137393_P_NODE_59320_length_165_cov_0.896552_g58804_i0	PRJNA1137393	59320	165	0.896552	1.4793108	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	57.4	3.83e-8	NR	MDX1492957.1	2910168	g58804	i0	50	0.836363636363636	46	23	83.6	0	164	27	78	123	MDX1492957.1 hypothetical protein [Longimicrobiales bacterium]	diamond	138	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32725602	32725602	PRJNA1137393_P_NODE_7380_length_310_cov_6.068966_g6864_i0	PRJNA1137393	7380	310	6.068966	18.8137946	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.7	0.044	NR	MFN0179075.1	2448054	g6864	i0	39.3	0.590322580645161	61	37	59	0	5	187	89	149	MFN0179075.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	183	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;