metadata: contig_metadata: 15 rows where bioproject = "PRJNA906294", tax_clade = "FCB group" and tax

15 rows where bioproject = "PRJNA906294", 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
5989840	5989840	PRJNA906294_P_NODE_151985_length_309_cov_1.122881_g147869_i0	PRJNA906294	151985	309	1.122881	3.46970229	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	235	2.67e-57	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g147869	i0	83.396	362.68284789644	265	32	83	10	1	258	171814	171555	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	112069	235	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27309000	27309000	PRJNA906294_P_NODE_170363_length_286_cov_1.187793_g166247_i0	PRJNA906294	170363	286	1.187793	3.39708798	Longimicrobium sp.	2029185	Bacteria	Bacteria	43.9	0.0234	NR	WP_331074889.1	2029185	g166247	i0	38.6	0.734265734265734	70	40	73.4	1	13	222	60	126	WP_331074889.1 PQQ-binding-like beta-propeller repeat protein [Longimicrobium sp.]	diamond	210	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28666699	28666699	PRJNA906294_P_NODE_232787_length_236_cov_2.687117_g228671_i0	PRJNA906294	232787	236	2.687117	6.34159612	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	42.4	0.0451	NR	MEO5815131.1	2026741	g228671	i0	39.1	0.584745762711864	46	28	58.5	0	59	196	241	286	MEO5815131.1 FAD-binding protein [Gemmatimonadaceae bacterium]	diamond	138	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29455520	29455520	PRJNA906294_P_NODE_127830_length_348_cov_0.941818_g123714_i0	PRJNA906294	127830	348	0.941818	3.27752664	Gemmatimonas sp. UBA7669	1946568	Bacteria	Bacteria	46.2	0.0074	NR	WP_291157223.1	1946568	g123714	i0	33.8	1.49137931034483	65	43	56	0	128	322	652	716	WP_291157223.1 serine/threonine-protein kinase [Gemmatimonas sp. UBA7669]	diamond	519	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. UBA7669
29487313	29487313	PRJNA906294_P_NODE_216110_length_246_cov_0.878613_g211994_i0	PRJNA906294	216110	246	0.878613	2.16138798	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	45.8	0.00115	NR	HEX2188859.1	3047548	g211994	i0	35.6	0.719512195121951	59	38	72	0	64	240	36	94	HEX2188859.1 hypothetical protein [Longimicrobiaceae bacterium]	diamond	177	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
29518987	29518987	PRJNA906294_P_NODE_105990_length_398_cov_1.261538_g101875_i0	PRJNA906294	105990	398	1.261538	5.02092124	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	83.6	1.05e-15	NR	HVX39141.1	2026741	g101875	i0	40	1.84673366834171	125	66	93.5	3	12	383	6	122	HVX39141.1 cholesterol oxidase substrate-binding domain-containing protein [Gemmatimonadaceae bacterium]	diamond	735	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29866466	29866466	PRJNA906294_P_NODE_87051_length_462_cov_1.064267_g82937_i0	PRJNA906294	87051	462	1.064267	4.91691354	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	46.2	0.0201	NR	MEA3247283.1	2026742	g82937	i0	33.6	0.792207792207792	122	68	73.4	4	54	392	442	559	MEA3247283.1 selenocysteine-specific translation elongation factor [Gemmatimonadota bacterium]	diamond	366	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30182287	30182287	PRJNA906294_P_NODE_226752_length_242_cov_1.390533_g222636_i0	PRJNA906294	226752	242	1.390533	3.36508986	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	47.8	6.35e-4	NR	MBT4979715.1	2026742	g222636	i0	34.7	0.892561983471074	72	45	88	2	242	30	646	716	MBT4979715.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadota bacterium]	diamond	216	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30435356	30435356	PRJNA906294_P_NODE_179833_length_275_cov_2.514851_g175717_i0	PRJNA906294	179833	275	2.514851	6.91584025	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	98.2	1.3400000000000002e-21	NR	MEP7326825.1	2026742	g175717	i0	57.1	0.992727272727273	91	39	99.3	0	3	275	67	157	MEP7326825.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	273	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31256580	31256580	PRJNA906294_P_NODE_180395_length_275_cov_1.217822_g176279_i0	PRJNA906294	180395	275	1.217822	3.3490105	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	43.1	0.0246	NR	MFV2006094.1	2910168	g176279	i0	34.3	0.763636363636364	70	46	76.4	0	41	250	10	79	MFV2006094.1 magnesium transporter MgtE N-terminal domain-containing protein [Longimicrobiales bacterium]	diamond	210	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31485785	31485785	PRJNA906294_P_NODE_224836_length_243_cov_0.894118_g220720_i0	PRJNA906294	224836	243	0.894118	2.17270674	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.34e-18	NR	MDQ3672764.1	2026742	g220720	i0	51.4	3.7037037037037	74	36	91.4	0	1	222	18	91	MDQ3672764.1 HAD hydrolase-like protein [Gemmatimonadota bacterium]	diamond	900	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31636156	31636156	PRJNA906294_P_NODE_92556_length_441_cov_1.027174_g88442_i0	PRJNA906294	92556	441	1.027174	4.52983734	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.4	0.0345	NR	HEX6943759.1	2026741	g88442	i0	40.2	0.625850340136054	92	48	61.2	4	156	425	1771	1857	HEX6943759.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	276	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31675207	31675207	PRJNA906294_P_NODE_204177_length_251_cov_1.707865_g200061_i0	PRJNA906294	204177	251	1.707865	4.28674115	FCB group	1783270	Bacteria	Bacteria	59.7	1.01e-8	NR	HRN52631.1	2026741	g200061	i0	46.3	4.99601593625498	82	41	98	2	3	248	18	96	HRN52631.1 GNAT family N-acetyltransferase [Gemmatimonadaceae bacterium]	diamond	1254	60.1	0.993344425956739	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31699514	31699514	PRJNA906294_P_NODE_215737_length_246_cov_1.127168_g211621_i0	PRJNA906294	215737	246	1.127168	2.77283328	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.0289	NR	PYP38643.1	2026742	g211621	i0	32.3	0.75609756097561	62	40	73.2	1	246	67	65	126	PYP38643.1 MAG: hypothetical protein DMD48_08985 [Gemmatimonadota bacterium]	diamond	186	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31952423	31952423	PRJNA906294_P_NODE_177957_length_277_cov_2.519608_g173841_i0	PRJNA906294	177957	277	2.519608	6.97931416	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	48.1	6.73e-4	NR	HSR16316.1	2448054	g173841	i0	65.6	1.07220216606498	32	11	34.7	0	102	7	2	33	HSR16316.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Gemmatimonadales bacterium]	diamond	297	48.1	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);;