metadata: contig_metadata: 19 rows where bioproject = "PRJNA867519", tax_clade = "FCB group" and tax

19 rows where bioproject = "PRJNA867519", 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
7226394	7226394	PRJNA867519_P_NODE_33466_length_241_cov_0.916667_g33312_i0	PRJNA867519	33466	241	0.916667	2.20916747	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2518552101\|emb\|OX638356.1\|	2910168	g33312	i0	100	0.116182572614108	28	0	12	0	72	99	3082417	3082390	MAG: Longimicrobiales bacterium isolate 11c1aa9f-90ef-4017-a54d-d6b2e11378d8 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
12327280	12327280	PRJNA867519_P_NODE_30410_length_245_cov_0.895349_g30256_i0	PRJNA867519	30410	245	0.895349	2.19360505	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	117	2.81e-28	NR	MBA3969861.1	2026742	g30256	i0	66.7	6.95510204081633	81	26	99.2	1	2	244	653	732	MBA3969861.1 glycosyl transferase family 36 [Gemmatimonadota bacterium]	diamond	1704	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
25074174	25074174	PRJNA867519_P_NODE_19400_length_278_cov_1.502439_g19246_i0	PRJNA867519	19400	278	1.502439	4.17678042	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	74.7	3.15e-13	NR	HEX6941595.1	2026741	g19246	i0	42	6.63669064748201	88	51	95	0	2	265	203	290	HEX6941595.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	1845	74.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26738203	26738203	PRJNA867519_P_NODE_9901_length_359_cov_2.153846_g9747_i0	PRJNA867519	9901	359	2.153846	7.73230714	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	47.4	0.0027	NR	HWB43226.1	2448054	g9747	i0	36.1	2.02228412256267	83	44	66	4	118	354	49	126	HWB43226.1 DUF5602 domain-containing protein [Gemmatimonadales bacterium]	diamond	726	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27157780	27157780	PRJNA867519_P_NODE_30862_length_244_cov_2.362573_g30708_i0	PRJNA867519	30862	244	2.362573	5.76467812	Pseudomonadati	3379134	Bacteria	Bacteria	93.6	4.91e-20	NR	MEO6527652.1	2026741	g30708	i0	58.7	6.57786885245902	75	30	91	1	20	241	647	721	MEO6527652.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1605	93.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28191899	28191899	PRJNA867519_P_NODE_19626_length_277_cov_1.642157_g19472_i0	PRJNA867519	19626	277	1.642157	4.54877489	Gemmatimonas sp. SG8_38_2	1703358	Bacteria	Bacteria	65.1	7.94e-10	NR	KPK63065.1	1703358	g19472	i0	50.7	4.64620938628159	67	24	63.9	2	101	277	744	809	KPK63065.1 MAG: hypothetical protein AMS21_06925 [Gemmatimonas sp. SG8_38_2]	diamond	1287	65.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SG8_38_2
28507957	28507957	PRJNA867519_P_NODE_29367_length_246_cov_1.751445_g29213_i0	PRJNA867519	29367	246	1.751445	4.3085547	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.037	NR	MDH4131553.1	2026742	g29213	i0	33.8	1.73170731707317	71	41	86.6	1	32	244	187	251	MDH4131553.1 ammonium transporter [Gemmatimonadota bacterium]	diamond	426	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28507972	28507972	PRJNA867519_P_NODE_8407_length_384_cov_0.967846_g8253_i0	PRJNA867519	8407	384	0.967846	3.71652864	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	52.4	6.9e-5	NR	MFN9351417.1	2026742	g8253	i0	32.9	2.59375	82	55	64.1	0	126	371	351	432	MFN9351417.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	996	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28791881	28791881	PRJNA867519_P_NODE_27747_length_248_cov_1.417143_g27593_i0	PRJNA867519	27747	248	1.417143	3.51451464	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	63.5	2.86e-10	NR	MCK5412122.1	2026742	g27593	i0	53.8	0.629032258064516	52	24	62.9	0	21	176	16	67	MCK5412122.1 NINE protein [Gemmatimonadota bacterium]	diamond	156	63.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28863225	28863225	PRJNA867519_P_NODE_33988_length_239_cov_3.240964_g33834_i0	PRJNA867519	33988	239	3.240964	7.74590396	Candidatus Palauibacter	3056650	Bacteria	Bacteria	52	1.87e-5	NR	MXW65572.1	3056733	g33834	i0	47.5	5.63598326359833	61	27	70.3	2	232	65	340	400	MXW65572.1 hypothetical protein [Candidatus Palauibacter irciniicola]	diamond	1347	52.4	0.99236641221374	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Candidatus Palauibacterales	Candidatus Palauibacteraceae	Candidatus Palauibacter	Candidatus Palauibacter irciniicola
29171097	29171097	PRJNA867519_P_NODE_33089_length_242_cov_0.911243_g32935_i0	PRJNA867519	33089	242	0.911243	2.20520806	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	57	2.48e-7	NR	HEX6939935.1	2910168	g32935	i0	47.8	3.60743801652893	69	34	85.5	1	239	33	45	111	HEX6939935.1 aquaporin [Longimicrobiales bacterium]	diamond	873	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30718578	30718578	PRJNA867519_P_NODE_33194_length_241_cov_2.101190_g33040_i0	PRJNA867519	33194	241	2.10119	5.0638679	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	61.2	8.09e-9	NR	HEV8197261.1	2448054	g33040	i0	60	3.6597510373444	40	16	49.8	0	213	94	237	276	HEV8197261.1 3-mercaptopyruvate sulfurtransferase [Gemmatimonadales bacterium]	diamond	882	61.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30726705	30726705	PRJNA867519_P_NODE_13934_length_314_cov_1.265560_g13780_i0	PRJNA867519	13934	314	1.26556	3.9738584	root	1	Root_unresolved	Root_unresolved	103	4.599999999999999e-24	NR	TDJ54718.1	2026742	g13780	i0	54.8	1.98726114649682	104	43	99.4	2	1	312	238	337	TDJ54718.1 MAG: uroporphyrinogen decarboxylase [Gemmatimonadota bacterium]	diamond	624	103	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30853129	30853129	PRJNA867519_P_NODE_1534_length_783_cov_2.042254_g1394_i0	PRJNA867519	1534	783	2.042254	15.99084882	Gemmatimonadota	142182	Bacteria	Bacteria	162	1.38e-41	NR	HEY2377597.1	2026741	g1394	i0	43.3	2.30651340996169	215	108	78.9	6	739	122	594	803	HEY2377597.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1806	162	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31129048	31129048	PRJNA867519_P_NODE_6775_length_421_cov_1.304598_g6621_i0	PRJNA867519	6775	421	1.304598	5.49235758	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	85.9	2.21e-16	NR	MCA9752804.1	2026742	g6621	i0	58	2.93586698337292	69	25	49.2	2	5	211	235	299	MCA9752804.1 PKD domain-containing protein [Gemmatimonadota bacterium]	diamond	1236	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31232121	31232121	PRJNA867519_P_NODE_32215_length_243_cov_0.905882_g32061_i0	PRJNA867519	32215	243	0.905882	2.20129326	FCB group	1783270	Bacteria	Bacteria	43.9	0.0147	NR	MEX0936131.1	2026742	g32061	i0	42	3.34567901234568	50	28	60.5	1	85	231	201	250	MEX0936131.1 diguanylate cyclase [Gemmatimonadota bacterium]	diamond	813	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32078245	32078245	PRJNA867519_P_NODE_22238_length_266_cov_0.886010_g22084_i0	PRJNA867519	22238	266	0.88601	2.3567866	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	73.2	9.39e-13	NR	MDH3732962.1	2026742	g22084	i0	66.7	0.541353383458647	48	16	54.1	0	10	153	483	530	MDH3732962.1 long-chain-fatty-acid--CoA ligase [Gemmatimonadota bacterium]	diamond	144	73.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32521536	32521536	PRJNA867519_P_NODE_10199_length_356_cov_0.717314_g10045_i0	PRJNA867519	10199	356	0.717314	2.55363784	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	46.6	0.00452	NR	MEX2530020.1	2026742	g10045	i0	46.8	0.396067415730337	47	25	39.6	0	331	191	198	244	MEX2530020.1 CsgG/HfaB family protein [Gemmatimonadota bacterium]	diamond	141	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32773266	32773266	PRJNA867519_P_NODE_32520_length_242_cov_1.467456_g32366_i0	PRJNA867519	32520	242	1.467456	3.55124352	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	106	6.2e-25	NR	HSG48360.1	2910168	g32366	i0	64.6	0.979338842975207	79	28	97.9	0	238	2	167	245	HSG48360.1 M24 family metallopeptidase [Longimicrobiales bacterium]	diamond	237	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales 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);;