metadata: contig_metadata: 26 rows where bioproject = "PRJNA1204310", tax_clade = "FCB group" and tax

26 rows where bioproject = "PRJNA1204310", 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
26692696	26692696	PRJNA1204310_P_NODE_38161_length_301_cov_1.364035_g37864_i0	PRJNA1204310	38161	301	1.364035	4.10574535	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	58.5	1.98e-7	NR	MYA65157.1	2026742	g37864	i0	35.7	0.837209302325581	84	54	83.7	0	40	291	42	125	MYA65157.1 beta-lactamase family protein [Gemmatimonadota bacterium]	diamond	252	58.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
26901792	26901792	PRJNA1204310_P_NODE_22481_length_385_cov_0.955128_g22184_i0	PRJNA1204310	22481	385	0.955128	3.6772428	Pseudomonadati	3379134	Bacteria	Bacteria	63.2	1.63e-10	NR	HEU4631955.1	2026741	g22184	i0	71.4	0.81038961038961	49	12	36.6	1	330	190	3	51	HEU4631955.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	312	63.5	0.995275590551181	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27041025	27041025	PRJNA1204310_P_NODE_51342_length_253_cov_0.866667_g51045_i0	PRJNA1204310	51342	253	0.866667	2.19266751	Longimicrobium sp.	2029185	Bacteria	Bacteria	42.7	0.0294	NR	HLL85046.1	2029185	g51045	i0	52	0.592885375494071	50	23	58.1	1	99	245	109	158	HLL85046.1 hypothetical protein [Longimicrobium sp.]	diamond	150	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27597136	27597136	PRJNA1204310_P_NODE_21364_length_393_cov_1.581250_g21067_i0	PRJNA1204310	21364	393	1.58125	6.2143125	Bacteria	2	Bacteria	Bacteria	120	1.68e-28	NR	HKR09544.1	2026741	g21067	i0	44.1	23.8778625954198	127	71	96.9	0	392	12	827	953	HKR09544.1 glucoamylase family protein [Gemmatimonadaceae bacterium]	diamond	9384	121	0.991735537190083	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27609752	27609752	PRJNA1204310_P_NODE_11044_length_528_cov_2.459341_g10749_i0	PRJNA1204310	11044	528	2.4593410000000002	12.98532048	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	172	7.26e-49	NR	MEO6068463.1	2448054	g10749	i0	52.3	1	176	68	99.4	3	2	526	5	165	MEO6068463.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	528	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27609792	27609792	PRJNA1204310_P_NODE_56684_length_248_cov_0.891429_g56387_i0	PRJNA1204310	56684	248	0.891429	2.21074392	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	48.9	1.46e-5	NR	HEU4631955.1	2026741	g56387	i0	61.9	0.870967741935484	42	16	50.8	0	2	127	16	57	HEU4631955.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	216	48.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28083234	28083234	PRJNA1204310_P_NODE_59305_length_245_cov_0.906977_g59008_i0	PRJNA1204310	59305	245	0.906977	2.22209365	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	58.2	7.44e-9	NR	MDH3291636.1	2026742	g59008	i0	40.7	0.991836734693878	81	43	99.2	1	2	244	2	77	MDH3291636.1 MTH1187 family thiamine-binding protein [Gemmatimonadota bacterium]	diamond	243	58.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28367373	28367373	PRJNA1204310_P_NODE_63106_length_229_cov_3.500000_g62809_i0	PRJNA1204310	63106	229	3.5	8.015	Longimicrobium sp.	2029185	Bacteria	Bacteria	72	1.5e-12	NR	HEU4559394.1	2029185	g62809	i0	50.6	3.24890829694323	83	33	98.3	2	229	5	428	510	HEU4559394.1 leishmanolysin-related zinc metalloendopeptidase [Longimicrobium sp.]	diamond	744	72	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28386294	28386294	PRJNA1204310_P_NODE_46566_length_269_cov_2.673469_g46269_i0	PRJNA1204310	46566	269	2.673469	7.19163161	Gemmatimonas	173479	Bacteria	Bacteria	59.3	1.95e-8	NR	KPK61927.1	1703358	g46269	i0	54.4	1.90706319702602	57	19	63.6	2	1	171	17	66	KPK61927.1 MAG: CMP deaminase [Gemmatimonas sp. SG8_38_2]	diamond	513	59.7	0.993299832495812	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SG8_38_2
28399073	28399073	PRJNA1204310_P_NODE_61926_length_242_cov_2.094675_g61629_i0	PRJNA1204310	61926	242	2.094675	5.0691135	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	79.3	4.73e-15	NR	NNE08319.1	2026742	g61629	i0	48.7	0.942148760330578	76	35	94.2	1	4	231	251	322	NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium]	diamond	228	79.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28462440	28462440	PRJNA1204310_P_NODE_48166_length_263_cov_1.231579_g47869_i0	PRJNA1204310	48166	263	1.231579	3.23905277	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.8	0.00378	NR	HXV16464.1	2026741	g47869	i0	45.8	0.547528517110266	48	26	54.8	0	263	120	333	380	HXV16464.1 ankyrin repeat domain-containing protein [Gemmatimonadaceae bacterium]	diamond	144	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28999306	28999306	PRJNA1204310_P_NODE_3088_length_927_cov_1.608899_g2865_i0	PRJNA1204310	3088	927	1.608899	14.91449373	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	67.4	2.42e-8	NR	MBA2684872.1	2026741	g2865	i0	33.3	0.83495145631068	129	74	39.2	3	912	550	541	665	MBA2684872.1 PKD domain-containing protein [Gemmatimonadaceae bacterium]	diamond	774	67.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29157016	29157016	PRJNA1204310_P_NODE_26289_length_360_cov_1.087108_g25992_i0	PRJNA1204310	26289	360	1.087108	3.9135888	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	160	5.87e-46	NR	MEO8449316.1	2026742	g25992	i0	66.7	2	120	39	100	1	360	1	192	310	MEO8449316.1 cysteine synthase A [Gemmatimonadota bacterium]	diamond	720	160	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29440701	29440701	PRJNA1204310_P_NODE_47810_length_264_cov_1.633508_g47513_i0	PRJNA1204310	47810	264	1.633508	4.31246112	Gemmatimonas sp. SG8_17	1703355	Bacteria	Bacteria	42	0.0421	NR	KPJ92099.1	1703355	g47513	i0	39.1	0.522727272727273	46	28	52.3	0	168	31	16	61	KPJ92099.1 MAG: hypothetical protein AMS18_08095 [Gemmatimonas sp. SG8_17]	diamond	138	42	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SG8_17
29472292	29472292	PRJNA1204310_P_NODE_49370_length_258_cov_1.264865_g49073_i0	PRJNA1204310	49370	258	1.264865	3.2633517	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	95.1	1.74e-20	NR	HEY0809003.1	2910168	g49073	i0	55.6	2.80232558139535	81	31	88.4	1	31	258	5	85	HEY0809003.1 pyruvate, phosphate dikinase [Longimicrobiales bacterium]	diamond	723	95.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30028441	30028441	PRJNA1204310_P_NODE_60831_length_244_cov_0.912281_g60534_i0	PRJNA1204310	60831	244	0.912281	2.22596564	FCB group	1783270	Bacteria	Bacteria	75.5	3.03e-15	NR	HYC32897.1	2448054	g60534	i0	54.1	4.83196721311475	61	28	75	0	52	234	40	100	HYC32897.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	1179	75.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30154384	30154384	PRJNA1204310_P_NODE_28772_length_346_cov_1.142857_g28475_i0	PRJNA1204310	28772	346	1.142857	3.95428522	Pseudomonadati	3379134	Bacteria	Bacteria	95.5	5.53e-21	NR	MDH5314922.1	2026742	g28475	i0	53.7	6.70231213872832	108	47	91	3	25	339	6	113	MDH5314922.1 NmrA/HSCARG family protein [Gemmatimonadota bacterium]	diamond	2319	95.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30217763	30217763	PRJNA1204310_P_NODE_20112_length_403_cov_1.418182_g19815_i0	PRJNA1204310	20112	403	1.418182	5.71527346	Longimicrobium	1804994	Bacteria	Bacteria	158	6.579999999999998e-42	NR	HEX8696377.1	2029185	g19815	i0	59.2	7.53349875930521	125	50	93.1	1	377	3	2129	2252	HEX8696377.1 glucoamylase family protein [Longimicrobium sp.]	diamond	3036	158	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30894262	30894262	PRJNA1204310_P_NODE_48094_length_263_cov_1.642105_g47797_i0	PRJNA1204310	48094	263	1.642105	4.31873615	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	42.7	0.0172	NR	HVZ76574.1	2026741	g47797	i0	38.6	0.650190114068441	57	25	65	2	199	29	25	71	HVZ76574.1 (deoxy)nucleoside triphosphate pyrophosphohydrolase [Gemmatimonadaceae bacterium]	diamond	171	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30944672	30944672	PRJNA1204310_P_NODE_62414_length_242_cov_0.923077_g62117_i0	PRJNA1204310	62414	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	89	2.9e-20	NR	HXE61350.1	2026741	g62117	i0	56.4	6.79338842975207	78	33	96.7	1	240	7	55	131	HXE61350.1 OsmC family protein [Gemmatimonadaceae bacterium]	diamond	1644	89	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30957470	30957470	PRJNA1204310_P_NODE_48354_length_262_cov_1.566138_g48057_i0	PRJNA1204310	48354	262	1.566138	4.10328156	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	80.9	2.34e-16	NR	HVD61543.1	2026741	g48057	i0	51.2	5.01526717557252	82	34	93.9	2	247	2	39	114	HVD61543.1 peptidylprolyl isomerase [Gemmatimonadaceae bacterium]	diamond	1314	80.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31463271	31463271	PRJNA1204310_P_NODE_43356_length_281_cov_2.019231_g43059_i0	PRJNA1204310	43356	281	2.019231	5.67403911	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	79.7	1.68e-15	NR	HEX2217275.1	2448054	g43059	i0	53.9	3.09608540925267	76	34	80.1	1	279	55	166	241	HEX2217275.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium]	diamond	870	79.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31779226	31779226	PRJNA1204310_P_NODE_27037_length_355_cov_1.659574_g26740_i0	PRJNA1204310	27037	355	1.659574	5.8914877	Candidatus Palauibacterales bacterium	2994973	Bacteria	Bacteria	48.5	0.00107	NR	MDP2497777.1	2994973	g26740	i0	32.5	0.988732394366197	117	61	94.6	3	354	19	96	199	MDP2497777.1 class I SAM-dependent methyltransferase [Candidatus Palauibacterales bacterium]	diamond	351	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Candidatus Palauibacterales			Candidatus Palauibacterales bacterium
32051346	32051346	PRJNA1204310_P_NODE_39118_length_297_cov_0.875000_g38821_i0	PRJNA1204310	39118	297	0.875	2.59875	Bacteria	2	Bacteria	Bacteria	123	3.34e-30	NR	MCA9752804.1	2026742	g38821	i0	64.2	7.23232323232323	95	25	94.9	4	293	12	195	281	MCA9752804.1 PKD domain-containing protein [Gemmatimonadota bacterium]	diamond	2148	123	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32159190	32159190	PRJNA1204310_P_NODE_18318_length_419_cov_2.407514_g18021_i0	PRJNA1204310	18318	419	2.407514	10.08748366	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	53.5	6.56e-6	NR	MFA6166471.1	2026741	g18021	i0	45.3	0.458233890214797	64	35	45.8	0	192	383	47	110	MFA6166471.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	192	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32651828	32651828	PRJNA1204310_P_NODE_41600_length_287_cov_1.939252_g41303_i0	PRJNA1204310	41600	287	1.939252	5.56565324	Bacteria	2	Bacteria	Bacteria	55.5	2.15e-6	NR	MFQ5537465.1	2026742	g41303	i0	71.4	2.24738675958188	35	10	36.6	0	29	133	26	60	MFQ5537465.1 tryptophanase [Gemmatimonadota bacterium]	diamond	645	55.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;