metadata: contig_metadata: 13 rows where bioproject = "PRJNA1010780", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA1010780", 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
26781481	26781481	PRJNA1010780_S_NODE_12381_length_646_cov_3.235679_g11289_i0	PRJNA1010780	12381	646	3.235679	20.90248634	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	165	9.6e-45	NR	HEY8176084.1	2026741	g11289	i0	43.5	14.061919504644	209	99	92	4	599	6	230	430	HEY8176084.1 erythromycin esterase family protein [Gemmatimonadaceae bacterium]	diamond	9084	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26876729	26876729	PRJNA1010780_S_NODE_5761_length_1118_cov_4.911357_g5193_i0	PRJNA1010780	5761	1118	4.911357	54.90897126	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	85.9	3.63e-14	NR	HEV2132607.1	3047548	g5193	i0	38.2	0.456171735241503	170	94	43.5	4	486	1	156	322	HEV2132607.1 SWIM zinc finger family protein [Longimicrobiaceae bacterium]	diamond	510	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
28669400	28669400	PRJNA1010780_S_NODE_31787_length_251_cov_2.134259_g30498_i0	PRJNA1010780	31787	251	2.134259	5.35699009	Pseudomonadati	3379134	Bacteria	Bacteria	62.8	1.23e-9	NR	NNK48993.1	2026742	g30498	i0	66	2.74900398406374	47	16	56.2	0	2	142	162	208	NNK48993.1 phosphodiester glycosidase family protein [Gemmatimonadota bacterium]	diamond	690	62.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28921721	28921721	PRJNA1010780_S_NODE_368_length_3075_cov_8.805921_g308_i0	PRJNA1010780	368	3075	8.805921	270.78207075	Bacteria	2	Bacteria	Bacteria	249	8e-70	NR	MCL7960438.1	2026742	g308	i0	42.6	1.50731707317073	319	172	30.7	4	2926	1982	54	365	MCL7960438.1 beta-lactamase family protein [Gemmatimonadota bacterium]	diamond	4635	249	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29490073	29490073	PRJNA1010780_S_NODE_54630_length_165_cov_1.376923_g53341_i0	PRJNA1010780	54630	165	1.376923	2.27192295	Pseudomonadati	3379134	Bacteria	Bacteria	58.2	4.8e-8	NR	WP_015894615.1	173480	g53341	i0	55.8	7.27272727272727	43	19	78.2	0	147	19	100	142	WP_015894615.1 amidohydrolase [Gemmatimonas aurantiaca]	diamond	1200	58.5	0.994871794871795	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
30634832	30634832	PRJNA1010780_S_NODE_9153_length_827_cov_4.077020_g8265_i0	PRJNA1010780	9153	827	4.07702	33.7169554	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	252	9.94e-80	NR	HET9983271.1	2910168	g8265	i0	48.5	3.97944377267231	274	140	99.4	1	1	822	13	285	HET9983271.1 SDR family oxidoreductase [Longimicrobiales bacterium]	diamond	3291	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30982661	30982661	PRJNA1010780_S_NODE_33974_length_236_cov_3.820896_g32685_i0	PRJNA1010780	33974	236	3.820896	9.01731456	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	80.5	1.72e-15	NR	MEE2992509.1	2026742	g32685	i0	47.4	1.98305084745763	78	41	99.2	0	235	2	229	306	MEE2992509.1 selenide, water dikinase SelD [Gemmatimonadota bacterium]	diamond	468	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31077377	31077377	PRJNA1010780_S_NODE_19515_length_413_cov_1.952381_g18230_i0	PRJNA1010780	19515	413	1.952381	8.06333353	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	50.1	5.83e-4	NR	HZK78776.1	2026741	g18230	i0	39.7	3.36319612590799	68	38	49.4	1	204	407	8	72	HZK78776.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium]	diamond	1389	50.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31101152	31101152	PRJNA1010780_S_NODE_36035_length_225_cov_1.852632_g34746_i0	PRJNA1010780	36035	225	1.852632	4.168422	Pseudomonadati	3379134	Bacteria	Bacteria	51.6	2.09e-5	NR	MCK5489653.1	2026742	g34746	i0	41.9	4.09333333333333	74	37	97.3	3	3	221	183	251	MCK5489653.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	921	51.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31171823	31171823	PRJNA1010780_S_NODE_52555_length_169_cov_1.641791_g51266_i0	PRJNA1010780	52555	169	1.641791	2.77462679	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	52.4	5.52e-6	NR	HEU6451633.1	2026741	g51266	i0	51.8	8.82248520710059	56	22	99.4	2	169	2	247	297	HEU6451633.1 M28 family metallopeptidase [Gemmatimonadaceae bacterium]	diamond	1491	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31955115	31955115	PRJNA1010780_S_NODE_38057_length_215_cov_2.444444_g36768_i0	PRJNA1010780	38057	215	2.444444	5.2555546	Pseudomonadati	3379134	Bacteria	Bacteria	75.1	5.8e-14	NR	HLL82976.1	2029185	g36768	i0	47.1	4.71627906976744	70	31	89.3	1	1	192	105	174	HLL82976.1 SDR family NAD(P)-dependent oxidoreductase [Longimicrobium sp.]	diamond	1014	75.5	0.994701986754967	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32532566	32532566	PRJNA1010780_S_NODE_39539_length_209_cov_1.522989_g38250_i0	PRJNA1010780	39539	209	1.522989	3.18304701	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	51.2	2.16e-5	NR	MYC16820.1	2026742	g38250	i0	43.6	0.789473684210526	55	31	78.9	0	43	207	183	237	MYC16820.1 phytanoyl-CoA dioxygenase family protein [Gemmatimonadota bacterium]	diamond	165	51.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32776719	32776719	PRJNA1010780_S_NODE_1180_length_2159_cov_8.658663_g1048_i0	PRJNA1010780	1180	2159	8.658663	186.94053417	Pseudomonadati	3379134	Bacteria	Bacteria	456	9.569999999999997e-148	NR	MCH9014914.1	2026742	g1048	i0	41.8	3.82538212135248	692	337	94.6	13	58	2100	25	661	MCH9014914.1 oligopeptide transporter, OPT family [Gemmatimonadota bacterium]	diamond	8259	456	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);;