metadata: contig_metadata: 14 rows where bioproject = "PRJNA285816", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA285816", 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
13125826	13125826	PRJNA285816_S_NODE_21451_length_176_cov_1.157480_g21349_i0	PRJNA285816	21451	176	1.15748	2.0371648	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	94.4	8.8e-21	NR	HUQ99184.1	2026741	g21349	i0	70.2	8.74431818181818	57	17	97.2	0	175	5	246	302	HUQ99184.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadaceae bacterium]	diamond	1539	94.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
27629072	27629072	PRJNA285816_S_NODE_21004_length_177_cov_1.484375_g20902_i0	PRJNA285816	21004	177	1.484375	2.62734375	Bacteria	2	Bacteria	Bacteria	93.6	5.4e-21	NR	MDQ3208419.1	2026742	g20902	i0	73.7	6.77966101694915	57	15	96.6	0	175	5	82	138	MDQ3208419.1 acetyl-CoA C-acyltransferase [Gemmatimonadota bacterium]	diamond	1200	93.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29000848	29000848	PRJNA285816_S_NODE_25028_length_168_cov_0.865546_g24926_i0	PRJNA285816	25028	168	0.865546	1.45411728	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.4	0.0183	NR	TVR50587.1	2448054	g24926	i0	47.8	1.64285714285714	46	23	80.4	1	29	163	177	222	TVR50587.1 MAG: hypothetical protein EA421_16965 [Gemmatimonadales bacterium]	diamond	276	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29568759	29568759	PRJNA285816_S_NODE_5590_length_292_cov_2.181070_g5488_i0	PRJNA285816	5590	292	2.18107	6.3687244	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	48.5	5.8e-4	NR	MDB4951426.1	2026742	g5488	i0	45.9	0.76027397260274	74	32	71.9	4	14	223	29	98	MDB4951426.1 rRNA (uracil-5-)-methyltransferase RumA [Gemmatimonadota bacterium]	diamond	222	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29600130	29600130	PRJNA285816_S_NODE_15910_length_196_cov_1.027211_g15808_i0	PRJNA285816	15910	196	1.027211	2.01333356	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42	0.0211	NR	HKH84897.1	2448054	g15808	i0	44.2	0.658163265306122	43	24	65.8	0	67	195	26	68	HKH84897.1 globin family protein [Gemmatimonadales bacterium]	diamond	129	42	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29600153	29600153	PRJNA285816_S_NODE_5610_length_292_cov_1.275720_g5508_i0	PRJNA285816	5610	292	1.27572	3.7251024	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	50.1	1.71e-4	NR	MBC8088690.1	2026741	g5508	i0	36.4	0.678082191780822	66	33	66.8	2	95	289	283	340	MBC8088690.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	198	50.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
29934010	29934010	PRJNA285816_S_NODE_2251_length_443_cov_1.855330_g2149_i0	PRJNA285816	2251	443	1.85533	8.2191119	Pseudomonadati	3379134	Bacteria	Bacteria	150	2.86e-41	NR	MCL7958114.1	2026742	g2149	i0	54.6	7.05643340857788	130	59	88	0	441	52	216	345	MCL7958114.1 fatty acid desaturase [Gemmatimonadota bacterium]	diamond	3126	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
30548035	30548035	PRJNA285816_S_NODE_26673_length_165_cov_1.508621_g26571_i0	PRJNA285816	26673	165	1.508621	2.48922465	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	48.5	1.11e-4	NR	MDH4349816.1	2026742	g26571	i0	47.1	0.927272727272727	51	26	92.7	1	155	3	11	60	MDH4349816.1 APC family permease [Gemmatimonadota bacterium]	diamond	153	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
30642712	30642712	PRJNA285816_S_NODE_26013_length_166_cov_1.333333_g25911_i0	PRJNA285816	26013	166	1.333333	2.21333278	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	40	0.0468	NR	PYP32577.1	2026742	g25911	i0	41.7	1.08433734939759	60	29	97.6	2	164	3	48	107	PYP32577.1 MAG: hypothetical protein DMD47_03595 [Gemmatimonadota bacterium]	diamond	180	40	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
30737511	30737511	PRJNA285816_S_NODE_12134_length_215_cov_1.879518_g12032_i0	PRJNA285816	12134	215	1.879518	4.0409637	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	41.6	0.0348	NR	HMA24902.1	2026741	g12032	i0	57.9	0.530232558139535	38	16	53	0	175	62	72	109	HMA24902.1 DUF302 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	114	41.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
30832401	30832401	PRJNA285816_S_NODE_3134_length_379_cov_2.390909_g3032_i0	PRJNA285816	3134	379	2.390909	9.06154511	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52	3.47e-5	NR	MDP2956777.1	2910168	g3032	i0	36.4	1.29815303430079	99	57	76.8	2	377	87	67	161	MDP2956777.1 hypothetical protein [Longimicrobiales bacterium]	diamond	492	52	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales		Longimicrobiales bacterium
31450758	31450758	PRJNA285816_S_NODE_22396_length_173_cov_1.370968_g22294_i0	PRJNA285816	22396	173	1.370968	2.37177464	Pseudomonadati	3379134	Bacteria	Bacteria	55.1	6.23e-7	NR	GDX87922.1	2026742	g22294	i0	43.4	2.6878612716763	53	30	91.9	0	170	12	197	249	GDX87922.1 adenosine deaminase [Gemmatimonadota bacterium]	diamond	465	55.5	0.992792792792793	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
31496440	31496440	PRJNA285816_S_NODE_14136_length_204_cov_1.341935_g14034_i0	PRJNA285816	14136	204	1.341935	2.7375474	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	40.4	0.0359	NR	MCY3808007.1	2026742	g14034	i0	38.5	0.955882352941177	65	37	91.2	1	195	10	3	67	MCY3808007.1 type II toxin-antitoxin system Phd/YefM family antitoxin [Gemmatimonadota bacterium]	diamond	195	40.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
32477168	32477168	PRJNA285816_S_NODE_8599_length_245_cov_1.137755_g8497_i0	PRJNA285816	8599	245	1.137755	2.78749975	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	55.5	6.67e-7	NR	MBT4504232.1	2026742	g8497	i0	56.1	0.502040816326531	41	18	50.2	0	5	127	173	213	MBT4504232.1 phosphoenolpyruvate carboxykinase (GTP) [Gemmatimonadota bacterium]	diamond	123	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);;