metadata: contig_metadata: 17 rows where bioproject = "PRJNA1195374", tax_clade = "FCB group" and tax

17 rows where bioproject = "PRJNA1195374", 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_species
11800512	11800512	PRJNA1195374_P_NODE_61250_length_276_cov_1.896552_g60906_i0	PRJNA1195374	61250	276	1.896552	5.23448352	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	63.9	1.17e-5	NTclustered	gi\|2107779373\|gb\|CP070829.1\|	2448054	g60906	i0	85.246	0.221014492753623	61	9	22	0	178	238	2945283	2945223	MAG: Gemmatimonadales bacterium isolate bin109 chromosome	blastn	61	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
21444701	21444701	PRJNA1195374_P_NODE_47577_length_320_cov_1.246964_g47233_i0	PRJNA1195374	47577	320	1.246964	3.9902848	Bacteria	2	Bacteria	Bacteria	211	4.68e-50	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g47233	i0	85.366	60.90625	205	28	64	2	39	242	3987748	3987951	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	19490	213	0.990610328638498	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		uncultured Gemmatimonadales bacterium
27293610	27293610	PRJNA1195374_P_NODE_10263_length_692_cov_1.373183_g9946_i0	PRJNA1195374	10263	692	1.373183	9.50242636	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	112	1.7500000000000002e-26	NR	GJM44098.1	2026742	g9946	i0	39.9	3.41618497109827	198	112	85	3	13	600	47	239	GJM44098.1 MAG: hypothetical protein DHS20C21_09400 [Gemmatimonadota bacterium]	diamond	2364	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
27376189	27376189	PRJNA1195374_P_NODE_23003_length_474_cov_0.957606_g22659_i0	PRJNA1195374	23003	474	0.957606	4.53905244	root	1	Root_unresolved	Root_unresolved	138	2.9599999999999996e-37	NR	MDH4352086.1	2026742	g22659	i0	57.1	5.51898734177215	133	53	82.9	3	470	78	100	230	MDH4352086.1 SDR family oxidoreductase [Gemmatimonadota bacterium]	diamond	2616	139	0.992805755395683	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
27388661	27388661	PRJNA1195374_P_NODE_47383_length_321_cov_0.931452_g47039_i0	PRJNA1195374	47383	321	0.931452	2.98996092	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	46.2	0.00564	NR	MBT4501140.1	2026742	g47039	i0	41.7	1.49532710280374	60	34	55.1	1	194	18	443	502	MBT4501140.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium]	diamond	480	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
28872398	28872398	PRJNA1195374_P_NODE_44968_length_330_cov_2.389105_g44624_i0	PRJNA1195374	44968	330	2.389105	7.8840465	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	68.6	6.07e-11	NR	MCU0620877.1	2448054	g44624	i0	51.5	0.618181818181818	68	32	60.9	1	329	129	235	302	MCU0620877.1 DUF1295 domain-containing protein [Gemmatimonadales bacterium]	diamond	204	68.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29409161	29409161	PRJNA1195374_P_NODE_45929_length_326_cov_1.814229_g45585_i0	PRJNA1195374	45929	326	1.814229	5.91438654	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	50.1	2.68e-4	NR	MCC6316636.1	2026741	g45585	i0	32.7	0.901840490797546	98	58	90.2	1	8	301	792	881	MCC6316636.1 serine/threonine protein kinase [Gemmatimonadaceae bacterium]	diamond	294	50.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
29409163	29409163	PRJNA1195374_P_NODE_47409_length_321_cov_0.923387_g47065_i0	PRJNA1195374	47409	321	0.923387	2.96407227	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	50.4	1.79e-4	NR	HEX9564790.1	2026741	g47065	i0	45.5	0.514018691588785	55	30	51.4	0	69	233	614	668	HEX9564790.1 S9 family peptidase [Gemmatimonadaceae bacterium]	diamond	165	50.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
29503823	29503823	PRJNA1195374_P_NODE_28470_length_425_cov_1.295455_g28126_i0	PRJNA1195374	28470	425	1.295455	5.50568375	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	147	2.84e-41	NR	HKJ01794.1	2910168	g28126	i0	58.6	1.88470588235294	133	52	92.5	2	3	395	85	216	HKJ01794.1 SDR family NAD(P)-dependent oxidoreductase [Longimicrobiales bacterium]	diamond	801	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales		Longimicrobiales bacterium
29693044	29693044	PRJNA1195374_P_NODE_33330_length_391_cov_1.210692_g32986_i0	PRJNA1195374	33330	391	1.210692	4.73380572	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.0452	NR	HTR21702.1	2448054	g32986	i0	38.8	0.375959079283887	49	30	37.6	0	177	323	219	267	HTR21702.1 PLP-dependent cysteine synthase family protein [Gemmatimonadales bacterium]	diamond	147	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
30894070	30894070	PRJNA1195374_P_NODE_50134_length_310_cov_1.949367_g49790_i0	PRJNA1195374	50134	310	1.949367	6.0430377	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.1	0.00346	NR	MBA3559761.1	2026741	g49790	i0	63.2	1.54838709677419	38	14	36.8	0	41	154	56	93	MBA3559761.1 DoxX family protein [Gemmatimonadaceae bacterium]	diamond	480	45.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
31431194	31431194	PRJNA1195374_P_NODE_33456_length_390_cov_1.457413_g33112_i0	PRJNA1195374	33456	390	1.457413	5.6839107	Candidatus Palauibacterales bacterium	2994973	Bacteria	Bacteria	82.4	2.44e-15	NR	MDP2497479.1	2994973	g33112	i0	37.6	0.961538461538462	125	76	94.6	1	17	385	445	569	MDP2497479.1 SLC13 family permease [Candidatus Palauibacterales bacterium]	diamond	375	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Candidatus Palauibacterales		Candidatus Palauibacterales bacterium
31450370	31450370	PRJNA1195374_P_NODE_36056_length_374_cov_1.860465_g35712_i0	PRJNA1195374	36056	374	1.860465	6.9581391	Bacteria	2	Bacteria	Bacteria	101	3.9e-25	NR	MCY4352252.1	2026742	g35712	i0	49.5	9.64973262032086	93	45	74.6	1	15	293	4	94	MCY4352252.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium]	diamond	3609	102	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
31589621	31589621	PRJNA1195374_P_NODE_70576_length_251_cov_1.724719_g70232_i0	PRJNA1195374	70576	251	1.724719	4.32904469	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.5	0.02	NR	HET6679641.1	2026741	g70232	i0	38.9	0.645418326693227	54	32	64.5	1	229	68	131	183	HET6679641.1 LytTR family DNA-binding domain-containing protein [Gemmatimonadaceae bacterium]	diamond	162	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
31684150	31684150	PRJNA1195374_P_NODE_78217_length_246_cov_0.890173_g77873_i0	PRJNA1195374	78217	246	0.890173	2.18982558	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.028	NR	MFH1567930.1	2026742	g77873	i0	33.3	0.768292682926829	63	42	76.8	0	37	225	162	224	MFH1567930.1 acyltransferase family protein [Gemmatimonadota bacterium]	diamond	189	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
31937247	31937247	PRJNA1195374_P_NODE_58537_length_283_cov_3.190476_g58193_i0	PRJNA1195374	58537	283	3.190476	9.02904708	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.5	0.0302	NR	MBK5096509.1	2026742	g58193	i0	44	0.530035335689046	50	27	51.9	1	282	136	245	294	MBK5096509.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	150	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
32285731	32285731	PRJNA1195374_P_NODE_30259_length_411_cov_2.082840_g29915_i0	PRJNA1195374	30259	411	2.08284	8.5604724	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	72	9.97e-12	NR	HEX6534750.1	2026741	g29915	i0	41.8	3.06569343065693	98	54	71.5	2	411	118	228	322	HEX6534750.1 CBS domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1260	72	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae 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);;