metadata: contig_metadata: 16 rows where bioproject = "PRJNA340009", tax_clade = "FCB group" and tax

16 rows where bioproject = "PRJNA340009", 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
1667075	1667075	PRJNA340009_P_NODE_66562_length_165_cov_0.879310_g66255_i0	PRJNA340009	66562	165	0.87931	1.4508615	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	233	4.5899999999999994e-57	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g66255	i0	98.485	26.3151515151515	132	2	80	0	24	155	421995	421864	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	4342	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27580162	27580162	PRJNA340009_P_NODE_34404_length_214_cov_4.309091_g34097_i0	PRJNA340009	34404	214	4.309091	9.22145474	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	67.4	1.05e-11	NR	MFO0271375.1	2026742	g34097	i0	46.8	2.59345794392523	62	33	86.9	0	190	5	1	62	MFO0271375.1 class I SAM-dependent methyltransferase [Gemmatimonadota bacterium]	diamond	555	67.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28481536	28481536	PRJNA340009_P_NODE_35906_length_210_cov_5.062112_g35599_i0	PRJNA340009	35906	210	5.062112	10.6304352	FCB group	1783270	Bacteria	Bacteria	44.3	0.00332	NR	MDP9205723.1	2026742	g35599	i0	36.2	3.22857142857143	58	37	82.9	0	17	190	91	148	MDP9205723.1 DUF1761 domain-containing protein [Gemmatimonadota bacterium]	diamond	678	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29632201	29632201	PRJNA340009_P_NODE_76890_length_161_cov_0.910714_g76583_i0	PRJNA340009	76890	161	0.910714	1.46624954	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	45.8	0.001	NR	MES2179848.1	2026742	g76583	i0	63.6	0.614906832298137	33	12	61.5	0	5	103	604	636	MES2179848.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	99	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29807537	29807537	PRJNA340009_P_NODE_51351_length_181_cov_3.030303_g51044_i0	PRJNA340009	51351	181	3.030303	5.48484843	Pseudomonadati	3379134	Bacteria	Bacteria	51.2	1.42e-5	NR	MCH7891117.1	2026742	g51044	i0	52.4	2.88397790055249	42	20	69.6	0	176	51	8	49	MCH7891117.1 galactose oxidase [Gemmatimonadota bacterium]	diamond	522	51.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29839156	29839156	PRJNA340009_P_NODE_77151_length_161_cov_0.910714_g76844_i0	PRJNA340009	77151	161	0.910714	1.46624954	Pseudomonadati	3379134	Bacteria	Bacteria	53.5	1.89e-6	NR	HTJ21729.1	2026741	g76844	i0	52.9	5.42236024844721	51	24	95	0	6	158	472	522	HTJ21729.1 glycosyltransferase family 2 protein [Gemmatimonadaceae bacterium]	diamond	873	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30169375	30169375	PRJNA340009_P_NODE_73592_length_162_cov_0.902655_g73285_i0	PRJNA340009	73592	162	0.902655	1.4623011	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	103	1.93e-24	NR	TFG62408.1	2448054	g73285	i0	90.6	0.981481481481482	53	5	98.1	0	3	161	330	382	TFG62408.1 MAG: hypothetical protein E4H28_07700 [Gemmatimonadales bacterium]	diamond	159	103	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30801277	30801277	PRJNA340009_P_NODE_34234_length_215_cov_1.228916_g33927_i0	PRJNA340009	34234	215	1.228916	2.6421694	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	47	7.85e-4	NR	MBT7549997.1	2026742	g33927	i0	47.5	0.558139534883721	40	21	55.8	0	93	212	2	41	MBT7549997.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	120	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31370560	31370560	PRJNA340009_P_NODE_69156_length_164_cov_0.886957_g68849_i0	PRJNA340009	69156	164	0.886957	1.45460948	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	96.7	1.29e-21	NR	HET8624605.1	2448054	g68849	i0	75	9.45731707317073	52	13	95.1	0	2	157	107	158	HET8624605.1 CocE/NonD family hydrolase [Gemmatimonadales bacterium]	diamond	1551	96.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31370568	31370568	PRJNA340009_P_NODE_75016_length_162_cov_0.902655_g74709_i0	PRJNA340009	75016	162	0.902655	1.4623011	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.00837	NR	MEK7403321.1	2026742	g74709	i0	51.9	1.96296296296296	54	22	92.6	1	13	162	77	130	MEK7403321.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	318	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32002995	32002995	PRJNA340009_P_NODE_70138_length_164_cov_0.886957_g69831_i0	PRJNA340009	70138	164	0.886957	1.45460948	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52.4	5.03e-6	NR	HLQ69537.1	2448054	g69831	i0	55.8	1.55487804878049	43	19	78.7	0	144	16	131	173	HLQ69537.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	255	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32083437	32083437	PRJNA340009_P_NODE_6738_length_424_cov_5.672000_g6431_i0	PRJNA340009	6738	424	5.672	24.04928	FCB group	1783270	Bacteria	Bacteria	152	3.25e-41	NR	MBA2243914.1	2026742	g6431	i0	63.5	16.8962264150943	126	43	89.2	2	36	413	107	229	MBA2243914.1 S8 family peptidase [Gemmatimonadota bacterium]	diamond	7164	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32319704	32319704	PRJNA340009_P_NODE_46799_length_188_cov_2.913669_g46492_i0	PRJNA340009	46799	188	2.913669	5.47769772	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	41.6	0.0412	NR	MCC7194393.1	2026741	g46492	i0	38.2	0.877659574468085	55	34	87.8	0	179	15	41	95	MCC7194393.1 phosphatase PAP2 family protein [Gemmatimonadaceae bacterium]	diamond	165	41.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32526764	32526764	PRJNA340009_P_NODE_18679_length_278_cov_2.227074_g18372_i0	PRJNA340009	18679	278	2.227074	6.19126572	Pseudomonadati	3379134	Bacteria	Bacteria	95.1	2.94e-23	NR	WP_298267574.1	1962908	g18372	i0	63.2	1.5	68	25	73.4	0	204	1	3	70	WP_298267574.1 DUF2442 domain-containing protein [Gemmatimonas sp.]	diamond	417	95.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
32589786	32589786	PRJNA340009_P_NODE_75959_length_161_cov_0.910714_g75652_i0	PRJNA340009	75959	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	73.9	8.76e-14	NR	HJU68783.1	2026741	g75652	i0	66	2.98136645962733	53	14	91.3	1	156	10	104	156	HJU68783.1 arginine deiminase-related protein [Gemmatimonadaceae bacterium]	diamond	480	73.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32698286	32698286	PRJNA340009_P_NODE_67620_length_165_cov_0.879310_g67313_i0	PRJNA340009	67620	165	0.87931	1.4508615	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	49.3	1.42e-5	NR	HEY6108686.1	2448054	g67313	i0	59.5	0.672727272727273	37	15	67.3	0	151	41	81	117	HEY6108686.1 DUF2793 domain-containing protein [Gemmatimonadales bacterium]	diamond	111	49.3	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);;