metadata: contig_metadata: 29 rows where bioproject = "PRJNA326068", tax_clade = "FCB group" and tax

29 rows where bioproject = "PRJNA326068", 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
389464	389464	PRJNA326068_P_NODE_701_length_1183_cov_38.238302_g419_i2	PRJNA326068	701	1183	38.238302	452.35911266	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1450	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g419	i2	93.899	178.349112426036	967	50	97	8	1	962	3043544	3042582	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	210987	1450	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
1069205	1069205	PRJNA326068_P_NODE_18481_length_172_cov_8.083916_g17518_i0	PRJNA326068	18481	172	8.083916	13.90433552	Gemmatimonas	173479	Bacteria	Bacteria	254	3.68e-63	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g17518	i0	93.529	204.168604651163	170	11	99	0	2	171	2948	2779	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	35117	255	0.996078431372549	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
2940097	2940097	PRJNA326068_P_NODE_903_length_1067_cov_47.777457_g419_i3	PRJNA326068	903	1067	47.777457	509.78546619	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1677	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g419	i3	95.051	208.988753514527	1071	45	100	7	1	1067	3043544	3042478	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	222991	1677	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4897055	4897055	PRJNA326068_P_NODE_19824_length_153_cov_2.975806_g18861_i0	PRJNA326068	19824	153	2.975806	4.55298318	Gemmatimonas	173479	Bacteria	Bacteria	228	1.9399999999999995e-55	NTclustered	gi\|310755215\|gb\|HQ213105.1\|	221169	g18861	i0	99.206	79.6274509803922	126	1	82	0	28	153	874	749	Uncultured Gemmatimonas sp. clone 3_B06 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	12183	228	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	uncultured Gemmatimonas sp.
6767006	6767006	PRJNA326068_P_NODE_10766_length_297_cov_14.212687_g9805_i0	PRJNA326068	10766	297	14.212687	42.21168039	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	350	8.74e-92	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g9805	i0	91.667	56.5387205387205	252	21	85	0	46	297	172625	172876	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	16792	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7447080	7447080	PRJNA326068_P_NODE_2366_length_709_cov_38.426471_g419_i8	PRJNA326068	2366	709	38.426471	272.44367939	Gemmatimonas	173479	Bacteria	Bacteria	929	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g419	i8	90.665	309.465444287729	707	54	99	11	7	709	253	951	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	219411	929	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
9997337	9997337	PRJNA326068_P_NODE_4988_length_494_cov_262.597849_g4175_i0	PRJNA326068	4988	494	262.597849	1297.23337406	Gemmatimonas	173479	Bacteria	Bacteria	472	3.1199999999999996e-128	NTclustered	gi\|375271543\|gb\|JQ648992.1\|	221169	g4175	i0	95.876	56.1923076923077	291	12	59	0	1	291	291	1	Uncultured Gemmatimonas sp. clone PRS3-49 16S ribosomal RNA gene, partial sequence	blastn	27759	473	0.997885835095137	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	uncultured Gemmatimonas sp.
11868014	11868014	PRJNA326068_P_NODE_12510_length_260_cov_44.354978_g11547_i0	PRJNA326068	12510	260	44.354978	115.3229428	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	411	3.39e-110	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g11547	i0	95.349	343.980769230769	258	12	99	0	1	258	1103367	1103110	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	89435	411	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
11868034	11868034	PRJNA326068_P_NODE_17990_length_181_cov_1.651316_g17027_i0	PRJNA326068	17990	181	1.651316	2.98888196	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	235	1.42e-57	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g17027	i0	90.055	10.9226519337017	181	18	100	0	1	181	172493	172313	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1977	235	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13822611	13822611	PRJNA326068_P_NODE_11471_length_282_cov_1.968379_g10509_i0	PRJNA326068	11471	282	1.968379	5.55082878	Gemmatimonas	173479	Bacteria	Bacteria	172	1.91e-38	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g10509	i0	78.547	5.02836879432624	289	43	100	13	1	282	1655	1379	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	1418	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
15692106	15692106	PRJNA326068_P_NODE_19733_length_154_cov_3.520000_g18770_i0	PRJNA326068	19733	154	3.52	5.4208	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	180	5.56e-41	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g18770	i0	89.333	6.82467532467532	150	6	94	4	10	154	3045275	3045131	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	1051	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16371751	16371751	PRJNA326068_P_NODE_1193_length_960_cov_32.713212_g419_i4	PRJNA326068	1193	960	32.713212	314.0468352	Gemmatimonas	173479	Bacteria	Bacteria	1448	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g419	i4	94.13	266.127083333333	954	52	99	4	8	960	1	951	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	255482	1450	0.998620689655172	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
16966785	16966785	PRJNA326068_P_NODE_1894_length_784_cov_46.898013_g419_i6	PRJNA326068	1894	784	46.898013	367.68042192	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1129	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g419	i6	92.519	280.96556122449	802	39	100	9	1	784	3042478	3043276	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	220277	1129	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16966811	16966811	PRJNA326068_P_NODE_7014_length_404_cov_107.914667_g6087_i0	PRJNA326068	7014	404	107.914667	435.97525468	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	235	3.5799999999999995e-57	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g6087	i0	86.854	55.1658415841584	213	24	52	3	2	213	420971	420762	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	22287	235	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16966812	16966812	PRJNA326068_P_NODE_7094_length_401_cov_36.362903_g6164_i0	PRJNA326068	7094	401	36.362903	145.81524103	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	617	3.02e-172	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g6164	i0	94.514	47.7406483790524	401	20	100	2	1	401	3043646	3043248	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	19144	617	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
17646763	17646763	PRJNA326068_P_NODE_1194_length_960_cov_30.792696_g419_i5	PRJNA326068	1194	960	30.792696	295.6098816	Gemmatimonas	173479	Bacteria	Bacteria	1387	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g419	i5	92.984	268.216666666667	955	61	99	6	8	960	1	951	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	257488	1389	0.998560115190785	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
18241082	18241082	PRJNA326068_P_NODE_7095_length_401_cov_32.250000_g6165_i0	PRJNA326068	7095	401	32.25	129.3225	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	220	9.96e-53	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g6165	i0	88.525	131.097256857855	183	19	95	1	1	181	3042310	3042492	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	52570	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18241092	18241092	PRJNA326068_P_NODE_935_length_1053_cov_22.025391_g275_i2	PRJNA326068	935	1053	22.025391	231.92736723	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	1369	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g275	i2	90.207	114.264957264957	1062	87	99	15	3	1053	1102312	1103367	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	120321	1369	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
19515305	19515305	PRJNA326068_P_NODE_2036_length_756_cov_50.232462_g419_i7	PRJNA326068	2036	756	50.232462	379.75741272	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1190	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g419	i7	94.832	364.589947089947	774	20	100	8	1	756	3043544	3042773	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	275630	1190	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20790964	20790964	PRJNA326068_P_NODE_937_length_1053_cov_20.180664_g275_i3	PRJNA326068	937	1053	20.180664	212.50239192	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	1358	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g275	i3	90.019	116.415004748338	1062	89	99	15	1	1051	1103367	1102312	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	122585	1358	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
21470928	21470928	PRJNA326068_P_NODE_617_length_1243_cov_36.771829_g419_i0	PRJNA326068	617	1243	36.771829	457.07383447	Gemmatimonas	173479	Bacteria	Bacteria	1760	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g419	i0	92.649	205.973451327434	1238	68	99	12	2	1236	1218	1	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	256025	1762	0.998864926220204	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
22065844	22065844	PRJNA326068_P_NODE_10798_length_296_cov_33.588015_g9837_i0	PRJNA326068	10798	296	33.588015	99.4205244	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	315	3.17e-81	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9837	i0	86	31.9256756756757	300	34	100	8	1	296	3043983	3043688	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	9450	315	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22065859	22065859	PRJNA326068_P_NODE_14618_length_224_cov_44.779487_g13655_i0	PRJNA326068	14618	224	44.779487	100.30605088	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	265	2.35e-66	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g13655	i0	88.444	173.147321428571	225	19	99	5	2	224	1903909	1904128	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	38785	265	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22746095	22746095	PRJNA326068_P_NODE_618_length_1243_cov_35.299012_g419_i1	PRJNA326068	618	1243	35.299012	438.76671916	Gemmatimonas	173479	Bacteria	Bacteria	1700	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g419	i1	91.768	207.75301689461	1239	77	99	14	2	1236	1218	1	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	258237	1709	0.994733762434172	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
23341319	23341319	PRJNA326068_P_NODE_12739_length_256_cov_6.722467_g11776_i0	PRJNA326068	12739	256	6.722467	17.20951552	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.61e-83	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g11776	i0	89.494	177.70703125	257	23	100	3	1	256	1902014	1901761	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	45493	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24020971	24020971	PRJNA326068_P_NODE_13539_length_241_cov_9.872642_g12576_i0	PRJNA326068	13539	241	9.872642	23.79306722	Gemmatirosa	1706036	Bacteria	Bacteria	134	7.530000000000001e-27	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g12576	i0	97.436	45.5809128630705	78	2	32	0	1	78	232983	232906	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	10985	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
24020979	24020979	PRJNA326068_P_NODE_17939_length_181_cov_33.013158_g16976_i0	PRJNA326068	17939	181	33.013158	59.75381598	Gemmatirosa	1706036	Bacteria	Bacteria	196	6.709999999999999e-46	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g16976	i0	98.214	122.939226519337	112	2	62	0	70	181	232906	233017	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	22252	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
24615507	24615507	PRJNA326068_P_NODE_10960_length_292_cov_11.893536_g9999_i0	PRJNA326068	10960	292	11.893536	34.72912512	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	296	1.13e-75	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9999	i0	85.185	13.4075342465753	297	34	100	8	1	292	3043688	3043979	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	3915	296	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
30611562	30611562	PRJNA326068_P_NODE_12973_length_252_cov_1.520179_g12010_i0	PRJNA326068	12973	252	1.520179	3.83085108	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	45.8	0.00321	NR	MBI4420926.1	2026742	g12010	i0	38.7	0.738095238095238	62	38	73.8	0	200	15	255	316	MBI4420926.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	186	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;