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

30 rows where bioproject = "PRJNA688352", 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
666853	666853	PRJNA688352_P_NODE_11361_length_243_cov_0.905882_g11258_i0	PRJNA688352	11361	243	0.905882	2.20129326	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	215	2.64e-51	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g11258	i0	84.722	17.1399176954733	216	31	88	2	28	242	1037800	1037586	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	4165	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3217736	3217736	PRJNA688352_P_NODE_10943_length_244_cov_0.871345_g10840_i0	PRJNA688352	10943	244	0.871345	2.1260818	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	155	1.07e-42	NR	MSR02140.1	2026742	g10840	i0	97.5	0.995901639344262	81	2	99.6	0	2	244	383	463	MSR02140.1 NADH-quinone oxidoreductase subunit M [Gemmatimonadota bacterium]	diamond	243	155	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
3217818	3217818	PRJNA688352_P_NODE_8343_length_249_cov_0.875000_g8240_i0	PRJNA688352	8343	249	0.875	2.17875	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	177	3.71e-51	NR	MDX2262629.1	2448054	g8240	i0	100	3	83	0	100	0	249	1	386	468	MDX2262629.1 diguanylate cyclase [Gemmatimonadales bacterium]	diamond	747	177	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
4494855	4494855	PRJNA688352_P_NODE_9264_length_247_cov_0.885057_g9161_i0	PRJNA688352	9264	247	0.885057	2.18609079	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	75.5	6.55e-16	NR	UCE17634.1	2026742	g9161	i0	94.3	1.7004048582996	35	2	42.5	0	2	106	36	70	UCE17634.1 MAG: helix-turn-helix transcriptional regulator [Gemmatimonadota bacterium]	diamond	420	75.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
12146245	12146245	PRJNA688352_P_NODE_12170_length_241_cov_0.916667_g12067_i0	PRJNA688352	12170	241	0.916667	2.20916747	Gaopeijia maritima	3119007	Bacteria	Bacteria	158	4.47e-34	NTclustered	gi\|2716997671\|gb\|CP144380.1\|	3119007	g12067	i0	81	2.60995850622407	200	36	83	2	42	240	760849	760651	Gaopeijia maritima strain DH-78 chromosome, complete genome	blastn	629	158	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Gaopeijiales	Gaopeijiaceae	Gaopeijia	Gaopeijia maritima
27030533	27030533	PRJNA688352_P_NODE_12442_length_241_cov_0.916667_g12339_i0	PRJNA688352	12442	241	0.916667	2.20916747	FCB group	1783270	Bacteria	Bacteria	111	2.04e-28	NR	HWP70012.1	2026741	g12339	i0	62.8	2.93775933609959	78	29	97.1	0	3	236	118	195	HWP70012.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	708	111	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27271875	27271875	PRJNA688352_P_NODE_7783_length_250_cov_0.870056_g7680_i0	PRJNA688352	7783	250	0.870056	2.17514	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	90.9	5.36e-22	NR	MEK7667110.1	2026742	g7680	i0	75.8	0.744	62	15	74.4	0	186	1	1	62	MEK7667110.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	186	90.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27871873	27871873	PRJNA688352_P_NODE_7145_length_251_cov_0.865169_g7042_i0	PRJNA688352	7145	251	0.865169	2.17157419	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	114	5.24e-29	NR	HEX9893506.1	2448054	g7042	i0	83.8	3.22709163346614	68	11	81.3	0	46	249	30	97	HEX9893506.1 alpha/beta hydrolase-fold protein [Gemmatimonadales bacterium]	diamond	810	114	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27935134	27935134	PRJNA688352_P_NODE_11085_length_243_cov_0.905882_g10982_i0	PRJNA688352	11085	243	0.905882	2.20129326	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	142	4.159999999999999e-42	NR	MFL5506150.1	2448054	g10982	i0	85.9	1.92592592592593	78	11	96.3	0	9	242	1	78	MFL5506150.1 Dabb family protein [Gemmatimonadales bacterium]	diamond	468	142	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28061270	28061270	PRJNA688352_P_NODE_12265_length_241_cov_0.916667_g12162_i0	PRJNA688352	12265	241	0.916667	2.20916747	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	146	1.95e-40	NR	MBT8477843.1	2026742	g12162	i0	93.8	2.98755186721992	80	5	99.6	0	1	240	112	191	MBT8477843.1 dicarboxylate/amino acid:cation symporter [Gemmatimonadota bacterium]	diamond	720	146	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28124550	28124550	PRJNA688352_P_NODE_10545_length_244_cov_0.900585_g10442_i0	PRJNA688352	10545	244	0.900585	2.1974274	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	82.8	2.89e-16	NR	MBK6459283.1	2026742	g10442	i0	59	2.87704918032787	78	32	95.9	0	2	235	123	200	MBK6459283.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	702	82.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28187419	28187419	PRJNA688352_P_NODE_7906_length_250_cov_0.870056_g7803_i0	PRJNA688352	7906	250	0.870056	2.17514	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	61.6	7.97e-9	NR	MFH1764596.1	2026742	g7803	i0	51.7	0.696	58	28	69.6	0	77	250	1	58	MFH1764596.1 oligopeptide/dipeptide ABC transporter ATP-binding protein [Gemmatimonadota bacterium]	diamond	174	61.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28598261	28598261	PRJNA688352_P_NODE_7707_length_250_cov_0.870056_g7604_i0	PRJNA688352	7707	250	0.870056	2.17514	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	146	2.51e-42	NR	HUX34015.1	2026741	g7604	i0	92.6	2.94	81	6	97.2	0	5	247	75	155	HUX34015.1 OmpA family protein [Gemmatimonadaceae bacterium]	diamond	735	146	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28755970	28755970	PRJNA688352_P_NODE_10427_length_245_cov_0.895349_g10324_i0	PRJNA688352	10427	245	0.895349	2.19360505	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	145	1.3899999999999996e-42	NR	HEX5818655.1	2448054	g10324	i0	88.9	0.991836734693878	81	9	99.2	0	244	2	10	90	HEX5818655.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	243	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29071899	29071899	PRJNA688352_P_NODE_11808_length_242_cov_0.911243_g11705_i0	PRJNA688352	11808	242	0.911243	2.20520806	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	81.6	4.51e-17	NR	MEO8450346.1	2026742	g11705	i0	62.9	1.48760330578512	62	23	76.9	0	57	242	1	62	MEO8450346.1 histidine phosphatase family protein [Gemmatimonadota bacterium]	diamond	360	81.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29114963	29114963	PRJNA688352_P_NODE_11628_length_242_cov_0.911243_g11525_i0	PRJNA688352	11628	242	0.911243	2.20520806	Gemmatimonas	173479	Bacteria	Bacteria	118	4.66e-30	NR	MEQ1693991.1	1962908	g11525	i0	80.3	2.91322314049587	76	15	94.2	0	230	3	215	290	MEQ1693991.1 hypothetical protein [Gemmatimonas sp.]	diamond	705	119	0.991596638655462	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
29166662	29166662	PRJNA688352_P_NODE_9129_length_247_cov_0.885057_g9026_i0	PRJNA688352	9129	247	0.885057	2.18609079	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	101	7.509999999999999e-23	NR	MBL8985569.1	2026742	g9026	i0	98	0.607287449392713	50	1	60.7	0	246	97	448	497	MBL8985569.1 ImmA/IrrE family metallo-endopeptidase [Gemmatimonadota bacterium]	diamond	150	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29955881	29955881	PRJNA688352_P_NODE_9331_length_247_cov_0.885057_g9228_i0	PRJNA688352	9331	247	0.885057	2.18609079	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	147	8.53e-40	NR	HEX9164651.1	2448054	g9228	i0	87.8	0.995951417004049	82	10	99.6	0	1	246	271	352	HEX9164651.1 CHAD domain-containing protein [Gemmatimonadales bacterium]	diamond	246	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30398683	30398683	PRJNA688352_P_NODE_12273_length_241_cov_0.916667_g12170_i0	PRJNA688352	12273	241	0.916667	2.20916747	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	92.4	1.56e-20	NR	HEX5727442.1	3047548	g12170	i0	65	2.98755186721992	60	21	74.7	0	61	240	3	62	HEX5727442.1 methyltransferase domain-containing protein [Longimicrobiaceae bacterium]	diamond	720	92.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
30441491	30441491	PRJNA688352_P_NODE_7473_length_251_cov_0.865169_g7370_i0	PRJNA688352	7473	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	73.2	1.13e-13	NR	MEO7367215.1	2026741	g7370	i0	66.7	3.71713147410359	51	17	61	0	153	1	1	51	MEO7367215.1 ECF-type sigma factor [Gemmatimonadaceae bacterium]	diamond	933	73.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30619283	30619283	PRJNA688352_P_NODE_9593_length_246_cov_0.890173_g9490_i0	PRJNA688352	9593	246	0.890173	2.18982558	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	149	2.0599999999999993e-40	NR	HYL29334.1	2448054	g9490	i0	97.5	1.97560975609756	81	2	98.8	0	2	244	96	176	HYL29334.1 TonB-dependent receptor plug domain-containing protein [Gemmatimonadales bacterium]	diamond	486	149	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30935423	30935423	PRJNA688352_P_NODE_9654_length_246_cov_0.890173_g9551_i0	PRJNA688352	9654	246	0.890173	2.18982558	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	159	5.13e-43	NR	MFO8172919.1	2910168	g9551	i0	85.2	0.98780487804878	81	12	98.8	0	246	4	57	137	MFO8172919.1 DPP IV N-terminal domain-containing protein [Longimicrobiales bacterium]	diamond	243	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31030357	31030357	PRJNA688352_P_NODE_12175_length_241_cov_0.916667_g12072_i0	PRJNA688352	12175	241	0.916667	2.20916747	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	120	1.2499999999999998e-29	NR	MFO7586841.1	2026742	g12072	i0	72.2	2.96265560165975	79	22	98.3	0	1	237	364	442	MFO7586841.1 amidohydrolase family protein [Gemmatimonadota bacterium]	diamond	714	120	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31042004	31042004	PRJNA688352_P_NODE_7195_length_251_cov_0.865169_g7092_i0	PRJNA688352	7195	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	91.3	2.73e-19	NR	MEP7380280.1	2026742	g7092	i0	51.8	3.9681274900398402	83	40	99.2	0	1	249	170	252	MEP7380280.1 FAD-dependent oxidoreductase [Gemmatimonadota bacterium]	diamond	996	91.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31251246	31251246	PRJNA688352_P_NODE_10235_length_245_cov_0.895349_g10132_i0	PRJNA688352	10235	245	0.895349	2.19360505	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	46.6	0.00164	NR	MDP3911448.1	2448054	g10132	i0	51.7	0.73469387755102	60	28	72.2	1	66	242	350	409	MDP3911448.1 IS66 family transposase [Gemmatimonadales bacterium]	diamond	180	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31472880	31472880	PRJNA688352_P_NODE_10256_length_245_cov_0.895349_g10153_i0	PRJNA688352	10256	245	0.895349	2.19360505	Gemmatimonadetes bacterium SCN 7	1660163	Bacteria	Bacteria	140	2.14e-36	NR	ODT05416.1	1660163	g10153	i0	87.5	0.979591836734694	80	10	98	0	245	6	563	642	ODT05416.1 MAG: hypothetical protein ABS52_00960 [Gemmatimonadetes bacterium SCN 70-22]	diamond	240	140	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium SCN 70-22
32516978	32516978	PRJNA688352_P_NODE_7479_length_251_cov_0.865169_g7376_i0	PRJNA688352	7479	251	0.865169	2.17157419	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	150	2.83e-44	NR	MDE3128720.1	2026742	g7376	i0	89.5	1.81673306772908	76	8	90.8	0	251	24	86	161	MDE3128720.1 recombination factor protein RarA [Gemmatimonadota bacterium]	diamond	456	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32674204	32674204	PRJNA688352_P_NODE_10440_length_245_cov_0.860465_g10337_i0	PRJNA688352	10440	245	0.860465	2.10813925	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	140	3.31e-39	NR	MFC1661008.1	2026742	g10337	i0	84	0.991836734693878	81	13	99.2	0	1	243	42	122	MFC1661008.1 substrate-binding domain-containing protein [Gemmatimonadota bacterium]	diamond	243	140	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32674205	32674205	PRJNA688352_P_NODE_12200_length_241_cov_0.916667_g12097_i0	PRJNA688352	12200	241	0.916667	2.20916747	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	113	6.0100000000000005e-27	NR	MCC6242841.1	2026741	g12097	i0	87.5	1.99170124481328	80	10	99.6	0	240	1	620	699	MCC6242841.1 zinc-dependent metalloprotease [Gemmatimonadaceae bacterium]	diamond	480	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32811855	32811855	PRJNA688352_P_NODE_8360_length_249_cov_0.875000_g8257_i0	PRJNA688352	8360	249	0.875	2.17875	Gemmatirosa	1706036	Bacteria	Bacteria	82.8	1.43e-17	NR	WP_148306154.1	861299	g8257	i0	77.8	3.26506024096386	45	10	54.2	0	1	135	107	151	WP_148306154.1 hypothetical protein [Gemmatirosa kalamazoonensis]	diamond	813	83.6	0.990430622009569	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis

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