metadata: contig_metadata: 30 rows where bioproject = "PRJNA1111146", tax_clade = "FCB group" and tax

30 rows where bioproject = "PRJNA1111146", 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
2766656	2766656	PRJNA1111146_P_NODE_229903_length_200_cov_1.551020_g228765_i0	PRJNA1111146	229903	200	1.55102	3.10204	Gaopeijia maritima	3119007	Bacteria	Bacteria	111	2.83e-20	NTclustered	gi\|2716997671\|gb\|CP144380.1\|	3119007	g228765	i0	92.308	1.825	78	6	39	0	123	200	492315	492238	Gaopeijia maritima strain DH-78 chromosome, complete genome	blastn	365	111	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Gaopeijiales	Gaopeijiaceae	Gaopeijia	Gaopeijia maritima
2766699	2766699	PRJNA1111146_P_NODE_238823_length_198_cov_2.234483_g237685_i0	PRJNA1111146	238823	198	2.234483	4.42427634	Bacteria	2	Bacteria	Bacteria	99.8	1.75e-22	NR	MEP7326173.1	2026742	g237685	i0	70.3	16.6818181818182	64	19	97	0	193	2	786	849	MEP7326173.1 glucoamylase family protein [Gemmatimonadota bacterium]	diamond	3303	100	0.998	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
2766871	2766871	PRJNA1111146_P_NODE_280083_length_190_cov_2.270073_g278945_i0	PRJNA1111146	280083	190	2.270073	4.3131387	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	125	6.22e-32	NR	HEY5939787.1	2448054	g278945	i0	100	2.98421052631579	63	0	99.5	0	190	2	176	238	HEY5939787.1 molecular chaperone DnaK [Gemmatimonadales bacterium]	diamond	567	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
7868479	7868479	PRJNA1111146_P_NODE_154047_length_219_cov_1.608434_g152909_i0	PRJNA1111146	154047	219	1.608434	3.52247046	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	259	1.06e-64	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g152909	i0	88.073	88.812785388127807	218	26	99	0	1	218	3045048	3045265	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	19450	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9143601	9143601	PRJNA1111146_P_NODE_220088_length_202_cov_1.530201_g218950_i0	PRJNA1111146	220088	202	1.530201	3.09100602	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	137	4.72e-28	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g218950	i0	81.143	1.39108910891089	175	30	86	3	5	177	1897341	1897514	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	281	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10419724	10419724	PRJNA1111146_P_NODE_291709_length_188_cov_1.688889_g290571_i0	PRJNA1111146	291709	188	1.688889	3.17511132	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	119	8.16e-33	NR	HVF40931.1	2026741	g290571	i0	90.3	2.96808510638298	62	6	98.9	0	2	187	82	143	HVF40931.1 SRPBCC family protein [Gemmatimonadaceae bacterium]	diamond	558	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
11695857	11695857	PRJNA1111146_P_NODE_7950_length_555_cov_16.754980_g6840_i0	PRJNA1111146	7950	555	16.75498	92.990139	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	632	1.5299999999999996e-176	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g6840	i0	87.321	138.913513513514	560	62	100	9	1	555	3042866	3042311	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	77097	632	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15519502	15519502	PRJNA1111146_P_NODE_417193_length_178_cov_0.912000_g416055_i0	PRJNA1111146	417193	178	0.912	1.62336	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	211	2.35e-50	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g416055	i0	88.136	46.6179775280899	177	21	99	0	1	177	676573	676749	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	8298	211	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
18068127	18068127	PRJNA1111146_P_NODE_343635_length_183_cov_0.861538_g342497_i0	PRJNA1111146	343635	183	0.861538	1.57661454	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	217	5.219999999999999e-52	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g342497	i0	88.043	2.01092896174863	184	20	100	2	1	183	725132	725314	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	368	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22698992	22698992	PRJNA1111146_P_NODE_402858_length_179_cov_0.896825_g401720_i0	PRJNA1111146	402858	179	0.896825	1.60531675	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	101	4.24e-24	NR	HET7426547.1	2448054	g401720	i0	83.1	1.97765363128492	59	10	98.9	0	177	1	34	92	HET7426547.1 ABC transporter ATP-binding protein [Gemmatimonadales bacterium]	diamond	354	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
24442181	24442181	PRJNA1111146_P_NODE_285560_length_189_cov_2.220588_g284422_i0	PRJNA1111146	285560	189	2.220588	4.19691132	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.12e-83	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g284422	i0	97.354	132.21164021164	189	5	100	0	1	189	421797	421609	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	24988	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27320729	27320729	PRJNA1111146_P_NODE_122703_length_232_cov_1.357542_g121565_i0	PRJNA1111146	122703	232	1.357542	3.14949744	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	108	1.26e-26	NR	MFQ5690325.1	2026742	g121565	i0	62.7	1.93965517241379	75	28	97	0	4	228	130	204	MFQ5690325.1 pantoate--beta-alanine ligase [Gemmatimonadota bacterium]	diamond	450	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27636614	27636614	PRJNA1111146_P_NODE_250844_length_196_cov_1.566434_g249706_i0	PRJNA1111146	250844	196	1.566434	3.07021064	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	89.4	9.81e-21	NR	MCH7562497.1	2026742	g249706	i0	66.2	4.97448979591837	65	22	99.5	0	1	195	40	104	MCH7562497.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	975	89.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27888959	27888959	PRJNA1111146_P_NODE_382225_length_180_cov_0.897638_g381087_i0	PRJNA1111146	382225	180	0.897638	1.6157484	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	71.6	1.07e-12	NR	MBA3560156.1	2026741	g381087	i0	66.7	0.95	57	19	95	0	171	1	349	405	MBA3560156.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	171	71.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27920590	27920590	PRJNA1111146_P_NODE_442825_length_174_cov_2.404959_g441687_i0	PRJNA1111146	442825	174	2.404959	4.1846286600000004	Gemmatimonas sp.	1962908	Bacteria	Bacteria	43.1	0.0105	NR	WP_373070462.1	1962908	g441687	i0	59.5	0.637931034482759	37	12	63.8	1	113	3	29	62	WP_373070462.1 peptidoglycan recognition family protein [Gemmatimonas sp.]	diamond	111	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
28678589	28678589	PRJNA1111146_P_NODE_361247_length_181_cov_1.781250_g360109_i0	PRJNA1111146	361247	181	1.78125	3.2240625	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	104	2.25e-26	NR	HZK77278.1	2026741	g360109	i0	90	0.994475138121547	60	6	99.4	0	181	2	11	70	HZK77278.1 recombinase family protein [Gemmatimonadaceae bacterium]	diamond	180	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29530996	29530996	PRJNA1111146_P_NODE_368490_length_181_cov_0.890625_g367352_i0	PRJNA1111146	368490	181	0.890625	1.61203125	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	73.9	3.87e-14	NR	HEX5386266.1	2448054	g367352	i0	64.8	1.79005524861878	54	19	89.5	0	179	18	5	58	HEX5386266.1 TonB family protein [Gemmatimonadales bacterium]	diamond	324	73.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29562382	29562382	PRJNA1111146_P_NODE_410290_length_178_cov_1.792000_g409152_i0	PRJNA1111146	410290	178	1.792	3.18976	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	65.9	1.09e-10	NR	MEY4956712.1	2026742	g409152	i0	50	0.97752808988764	58	28	97.8	1	5	178	50	106	MEY4956712.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	174	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29941608	29941608	PRJNA1111146_P_NODE_407191_length_179_cov_0.880952_g406053_i0	PRJNA1111146	407191	179	0.880952	1.57690408	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	84.3	3.44e-17	NR	HEX2190359.1	3047548	g406053	i0	69	3.75418994413408	58	18	97.2	0	176	3	477	534	HEX2190359.1 asparagine synthase (glutamine-hydrolyzing) [Longimicrobiaceae bacterium]	diamond	672	84.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
30185316	30185316	PRJNA1111146_P_NODE_273912_length_192_cov_1.179856_g272774_i0	PRJNA1111146	273912	192	1.179856	2.26532352	Pseudomonadati	3379134	Bacteria	Bacteria	90.5	2.77e-19	NR	HWG53082.1	2026741	g272774	i0	89.1	14.375	46	5	71.9	0	191	54	565	610	HWG53082.1 PQQ-dependent dehydrogenase, methanol/ethanol family [Gemmatimonadaceae bacterium]	diamond	2760	90.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30225749	30225749	PRJNA1111146_P_NODE_388032_length_180_cov_0.889764_g386894_i0	PRJNA1111146	388032	180	0.889764	1.6015752	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	114	2.6699999999999997e-30	NR	WP_337172754.1	173480	g386894	i0	100	0.983333333333333	59	0	98.3	0	2	178	26	84	WP_337172754.1 hypothetical protein [Gemmatimonas aurantiaca]	diamond	177	114	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
30564249	30564249	PRJNA1111146_P_NODE_427033_length_177_cov_1.733871_g425895_i0	PRJNA1111146	427033	177	1.733871	3.06895167	Pseudomonadati	3379134	Bacteria	Bacteria	92.4	2.19e-20	NR	HTJ23223.1	2026741	g425895	i0	77.2	2.89830508474576	57	13	96.6	0	173	3	67	123	HTJ23223.1 M12 family metallopeptidase [Gemmatimonadaceae bacterium]	diamond	513	93.2	0.991416309012876	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30763012	30763012	PRJNA1111146_P_NODE_417994_length_178_cov_0.912000_g416856_i0	PRJNA1111146	417994	178	0.912	1.62336	Longimicrobium sp.	2029185	Bacteria	Bacteria	42.7	0.0101	NR	HYW12391.1	2029185	g416856	i0	76.9	0.438202247191011	26	6	43.8	0	176	99	143	168	HYW12391.1 hypothetical protein [Longimicrobium sp.]	diamond	78	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31141687	31141687	PRJNA1111146_P_NODE_385335_length_180_cov_0.897638_g384197_i0	PRJNA1111146	385335	180	0.897638	1.6157484	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	73.2	1.01e-14	NR	HSD31978.1	2448054	g384197	i0	74.5	0.85	51	12	83.3	1	152	3	7	57	HSD31978.1 metalloregulator ArsR/SmtB family transcription factor [Gemmatimonadales bacterium]	diamond	153	73.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31268523	31268523	PRJNA1111146_P_NODE_266175_length_193_cov_1.600000_g265037_i0	PRJNA1111146	266175	193	1.6	3.088	Longimicrobium sp.	2029185	Bacteria	Bacteria	119	9.71e-33	NR	HST62507.1	2029185	g265037	i0	88.9	2.96891191709845	63	7	97.9	0	190	2	63	125	HST62507.1 cupredoxin domain-containing protein [Longimicrobium sp.]	diamond	573	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31670854	31670854	PRJNA1111146_P_NODE_434437_length_177_cov_0.911290_g433299_i0	PRJNA1111146	434437	177	0.91129	1.6129833	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	2.98e-5	NR	WP_012681860.1	173480	g433299	i0	57.1	4.71186440677966	42	17	69.5	1	55	177	3	44	WP_012681860.1 TIGR01777 family oxidoreductase [Gemmatimonas aurantiaca]	diamond	834	50.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
31901121	31901121	PRJNA1111146_P_NODE_96597_length_245_cov_1.473958_g95459_i0	PRJNA1111146	96597	245	1.473958	3.6111971	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	130	2.24e-34	NR	CAA9361433.1	246130	g95459	i0	75.3	4.92244897959184	81	20	99.2	0	244	2	14	94	CAA9361433.1 MAG: Response regulator, partial [uncultured Gemmatimonadaceae bacterium]	diamond	1206	130	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
31996081	31996081	PRJNA1111146_P_NODE_404778_length_179_cov_0.896825_g403640_i0	PRJNA1111146	404778	179	0.896825	1.60531675	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	109	3.87e-26	NR	WP_337172016.1	173480	g403640	i0	100	0.988826815642458	59	0	98.9	0	178	2	200	258	WP_337172016.1 hypothetical protein [Gemmatimonas aurantiaca]	diamond	177	109	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
32217565	32217565	PRJNA1111146_P_NODE_222038_length_202_cov_1.208054_g220900_i0	PRJNA1111146	222038	202	1.208054	2.44026908	Longimicrobium sp.	2029185	Bacteria	Bacteria	82	3.12e-16	NR	HZG44266.1	2029185	g220900	i0	59.7	0.995049504950495	67	27	99.5	0	2	202	239	305	HZG44266.1 hypothetical protein [Longimicrobium sp.]	diamond	201	82	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32249549	32249549	PRJNA1111146_P_NODE_80478_length_256_cov_1.389163_g79340_i0	PRJNA1111146	80478	256	1.389163	3.55625728	Gemmatirosa sp.	2510638	Bacteria	Bacteria	94	1.8e-20	NR	HEY0777418.1	2510638	g79340	i0	50.6	1.98046875	85	42	99.6	0	256	2	74	158	HEY0777418.1 transaldolase [Gemmatirosa sp.]	diamond	507	94	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.

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