metadata: contig_metadata: 12 rows where bioproject = "PRJNA940501", tax_clade = "FCB group" and tax

12 rows where bioproject = "PRJNA940501", 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
27467716	27467716	PRJNA940501_S_NODE_231203_length_184_cov_0.957447_g230385_i0	PRJNA940501	231203	184	0.957447	1.76170248	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42	0.0328	NR	PYP59744.1	2026742	g230385	i0	42.3	0.847826086956522	52	22	84.8	1	184	29	718	761	PYP59744.1 MAG: glycosyl transferase [Gemmatimonadota bacterium]	diamond	156	42	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27657251	27657251	PRJNA940501_S_NODE_30064_length_324_cov_2.352313_g29246_i0	PRJNA940501	30064	324	2.352313	7.62149412	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.4	0.014	NR	HLQ24141.1	2448054	g29246	i0	36.2	0.435185185185185	47	30	43.5	0	182	322	4	50	HLQ24141.1 pyridoxamine 5'-phosphate oxidase family protein [Gemmatimonadales bacterium]	diamond	141	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28604268	28604268	PRJNA940501_S_NODE_185347_length_198_cov_1.212903_g184529_i0	PRJNA940501	185347	198	1.212903	2.40154794	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	45.4	0.00182	NR	MEO8199954.1	2026742	g184529	i0	39.3	0.848484848484849	56	32	84.8	1	13	180	140	193	MEO8199954.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	168	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29204370	29204370	PRJNA940501_S_NODE_288969_length_169_cov_3.674603_g288151_i0	PRJNA940501	288969	169	3.674603	6.21007907	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.1	0.00109	NR	HEY4658038.1	2026741	g288151	i0	42.9	0.745562130177515	42	23	74.6	1	20	145	6	46	HEY4658038.1 HNH endonuclease [Gemmatimonadaceae bacterium]	diamond	126	45.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30119852	30119852	PRJNA940501_S_NODE_287872_length_170_cov_1.110236_g287054_i0	PRJNA940501	287872	170	1.110236	1.8874012	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	45.1	0.00211	NR	HEX8275669.1	3047548	g287054	i0	40.4	2.80588235294118	52	29	90	2	4	156	218	268	HEX8275669.1 LLM class flavin-dependent oxidoreductase [Longimicrobiaceae bacterium]	diamond	477	45.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
30183133	30183133	PRJNA940501_S_NODE_155252_length_209_cov_1.698795_g154434_i0	PRJNA940501	155252	209	1.698795	3.55048155	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.00636	NR	HTI04622.1	2448054	g154434	i0	44.9	3.45933014354067	69	16	99	2	1	207	209	255	HTI04622.1 PhzF family phenazine biosynthesis protein [Gemmatimonadales bacterium]	diamond	723	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30562080	30562080	PRJNA940501_S_NODE_82333_length_251_cov_1.274038_g81515_i0	PRJNA940501	82333	251	1.274038	3.19783538	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.5	0.0134	NR	HTI62360.1	2026741	g81515	i0	32.9	0.836653386454183	70	35	69.3	2	13	186	44	113	HTI62360.1 Rieske 2Fe-2S domain-containing protein [Gemmatimonadaceae bacterium]	diamond	210	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31320673	31320673	PRJNA940501_S_NODE_217135_length_188_cov_0.972414_g216317_i0	PRJNA940501	217135	188	0.972414	1.82813832	Longimicrobium sp.	2029185	Bacteria	Bacteria	41.2	0.0184	NR	HEU4886168.1	2029185	g216317	i0	54.8	0.49468085106383	31	13	49.5	1	88	180	41	70	HEU4886168.1 hypothetical protein [Longimicrobium sp.]	diamond	93	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31668603	31668603	PRJNA940501_S_NODE_261877_length_176_cov_1.060150_g261059_i0	PRJNA940501	261877	176	1.06015	1.865864	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.0108	NR	MCY3761175.1	2026742	g261059	i0	51.4	2.96590909090909	37	18	63.1	0	45	155	195	231	MCY3761175.1 phytanoyl-CoA dioxygenase family protein [Gemmatimonadota bacterium]	diamond	522	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31921715	31921715	PRJNA940501_S_NODE_192777_length_195_cov_1.855263_g191959_i0	PRJNA940501	192777	195	1.855263	3.61776285	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	41.2	0.0313	NR	HET7583272.1	2026741	g191959	i0	33.3	0.876923076923077	57	37	86.2	1	185	18	19	75	HET7583272.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	171	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32111586	32111586	PRJNA940501_S_NODE_123818_length_224_cov_1.430939_g123000_i0	PRJNA940501	123818	224	1.430939	3.20530336	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	45.1	0.00447	NR	HEX9105716.1	2910168	g123000	i0	38.1	1.64732142857143	63	31	84.4	1	199	11	309	363	HEX9105716.1 family 43 glycosylhydrolase [Longimicrobiales bacterium]	diamond	369	45.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32655537	32655537	PRJNA940501_S_NODE_154260_length_209_cov_3.548193_g153442_i0	PRJNA940501	154260	209	3.548193	7.41572337	Bacteria	2	Bacteria	Bacteria	73.2	4.27e-13	NR	MEP6571922.1	2026742	g153442	i0	55.1	2.97129186602871	69	31	99	0	1	207	169	237	MEP6571922.1 Nramp family divalent metal transporter [Gemmatimonadota bacterium]	diamond	621	73.2	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);;