metadata: contig_metadata: 9 rows where bioproject = "PRJNA908278" and tax

9 rows where bioproject = "PRJNA908278" 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
27695599	27695599	PRJNA908278_P_NODE_31964_length_245_cov_0.895349_g31861_i0	PRJNA908278	31964	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	77.8	1.47e-14	NR	MCC7055219.1	2026741	g31861	i0	54.9	3.68571428571429	71	27	80.8	1	40	237	299	369	MCC7055219.1 alkaline phosphatase family protein [Gemmatimonadaceae bacterium]	diamond	903	77.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29179444	29179444	PRJNA908278_P_NODE_9809_length_385_cov_6.608974_g9706_i0	PRJNA908278	9809	385	6.608974	25.4445499	Pseudomonadati	3379134	Bacteria	Bacteria	78.2	3.96e-14	NR	MBK6304481.1	2026742	g9706	i0	49.4	1.77662337662338	83	41	63.9	1	136	381	44	126	MBK6304481.1 beta-lactamase family protein [Gemmatimonadota bacterium]	diamond	684	78.6	0.994910941475827	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29235015	29235015	PRJNA908278_P_NODE_25149_length_258_cov_1.248649_g25046_i0	PRJNA908278	25149	258	1.248649	3.22151442	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	125	7.089999999999998e-32	NR	MFQ5705264.1	2448054	g25046	i0	68.6	3	86	27	100	0	258	1	193	278	MFQ5705264.1 aldehyde dehydrogenase family protein [Gemmatimonadales bacterium]	diamond	774	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29519070	29519070	PRJNA908278_P_NODE_14910_length_326_cov_1.217391_g14807_i0	PRJNA908278	14910	326	1.217391	3.96869466	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	106	1.8999999999999998e-24	NR	MBA3579866.1	2026741	g14807	i0	54.2	0.984662576687117	107	43	98.5	2	3	323	329	429	MBA3579866.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadaceae bacterium]	diamond	321	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29866510	29866510	PRJNA908278_P_NODE_27131_length_250_cov_1.604520_g27028_i0	PRJNA908278	27131	250	1.60452	4.0113	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.7	0.034	NR	HEY7193298.1	2448054	g27028	i0	32.9	1.836	82	50	94.8	3	245	9	5	84	HEY7193298.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	459	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29992900	29992900	PRJNA908278_P_NODE_19211_length_292_cov_1.406393_g19108_i0	PRJNA908278	19211	292	1.406393	4.10666756	Longimicrobium sp.	2029185	Bacteria	Bacteria	86.3	2.3e-17	NR	HEX2211276.1	2029185	g19108	i0	54	2.68150684931507	87	34	88.4	3	1	258	214	295	HEX2211276.1 hypothetical protein [Longimicrobium sp.]	diamond	783	86.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31129917	31129917	PRJNA908278_P_NODE_29715_length_247_cov_1.770115_g29612_i0	PRJNA908278	29715	247	1.770115	4.37218405	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57.8	1.94e-7	NR	MBS1241634.1	2026742	g29612	i0	46.2	5.1497975708502	78	36	94.7	3	1	234	293	364	MBS1241634.1 peptidase family protein [Gemmatimonadota bacterium]	diamond	1272	57.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31478266	31478266	PRJNA908278_P_NODE_20316_length_286_cov_1.305164_g20213_i0	PRJNA908278	20316	286	1.305164	3.73276904	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	57.4	3.42e-7	NR	MFN2567339.1	2026741	g20213	i0	48.2	0.587412587412587	56	29	58.7	0	112	279	86	141	MFN2567339.1 alpha/beta fold hydrolase [Gemmatimonadaceae bacterium]	diamond	168	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32079047	32079047	PRJNA908278_P_NODE_1138_length_983_cov_5.060440_g1071_i0	PRJNA908278	1138	983	5.06044	49.7441252	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	251	2.01e-74	NR	NNE08319.1	2026742	g1071	i0	42.6	1.81586978636826	298	151	88.5	7	876	7	41	326	NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium]	diamond	1785	251	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);;