metadata: contig_metadata: 10 rows where bioproject = "PRJNA600413", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA600413", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27346268	27346268	PRJNA600413_P_NODE_107323_length_167_cov_0.864407_g106622_i0	PRJNA600413	107323	167	0.864407	1.44355969	Armatimonadota	67819	Bacteria	Bacteria	43.5	0.00709	NR	MBX3119356.1	2682144	g106622	i0	79.2	1.23952095808383	24	5	43.1	0	165	94	328	351	MBX3119356.1 DNA polymerase III subunit delta [Fimbriimonadaceae bacterium]	diamond	207	43.5	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27901008	27901008	PRJNA600413_P_NODE_88445_length_174_cov_2.856000_g87744_i0	PRJNA600413	88445	174	2.856	4.96944	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	45.8	0.0012	NR	HLK57162.1	2739509	g87744	i0	56.8	0.758620689655172	44	19	75.9	0	164	33	614	657	HLK57162.1 RHS repeat-associated core domain-containing protein [Chthonomonadaceae bacterium]	diamond	132	45.8	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
29953580	29953580	PRJNA600413_P_NODE_131271_length_163_cov_0.894737_g130570_i0	PRJNA600413	131271	163	0.894737	1.45842131	Armatimonadota bacterium	2033014	Bacteria	Bacteria	119	5.6599999999999994e-30	NR	MBC8138851.1	2033014	g130570	i0	96.3	0.993865030674847	54	2	99.4	0	1	162	123	176	MBC8138851.1 hypothetical protein [Armatimonadota bacterium]	diamond	162	119	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30869764	30869764	PRJNA600413_P_NODE_150494_length_161_cov_0.910714_g149793_i0	PRJNA600413	150494	161	0.910714	1.46624954	Armatimonadota bacterium	2033014	Bacteria	Bacteria	98.6	2.62e-22	NR	HEY3413142.1	2033014	g149793	i0	100	5.92546583850932	53	0	98.8	0	161	3	469	521	HEY3413142.1 efflux RND transporter permease subunit [Armatimonadota bacterium]	diamond	954	98.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31009449	31009449	PRJNA600413_P_NODE_131174_length_163_cov_0.894737_g130473_i0	PRJNA600413	131174	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	102	8.75e-24	NR	HVT10777.1	2682144	g130473	i0	92.6	4.96932515337423	54	4	99.4	0	163	2	307	360	HVT10777.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Fimbriimonadaceae bacterium]	diamond	810	102	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
31090950	31090950	PRJNA600413_P_NODE_108635_length_166_cov_1.743590_g107934_i0	PRJNA600413	108635	166	1.74359	2.8943594	Armatimonadota bacterium	2033014	Bacteria	Bacteria	84.7	2.03e-17	NR	MBI5833618.1	2033014	g107934	i0	72.2	0.975903614457831	54	15	97.6	0	164	3	67	120	MBI5833618.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium]	diamond	162	84.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31881448	31881448	PRJNA600413_P_NODE_147117_length_161_cov_0.910714_g146416_i0	PRJNA600413	147117	161	0.910714	1.46624954	Capsulimonadaceae bacterium	2953755	Bacteria	Bacteria	44.3	0.00353	NR	HEY3332025.1	2953755	g146416	i0	77.3	0.409937888198758	22	5	41	0	159	94	771	792	HEY3332025.1 FlgD immunoglobulin-like domain containing protein [Capsulimonadaceae bacterium]	diamond	66	44.3	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae		Capsulimonadaceae bacterium
32166545	32166545	PRJNA600413_P_NODE_144258_length_161_cov_2.017857_g143557_i0	PRJNA600413	144258	161	2.017857	3.24874977	Armatimonadota bacterium	2033014	Bacteria	Bacteria	50.1	3.18e-5	NR	MBC8101528.1	2033014	g143557	i0	68.8	0.596273291925466	32	10	59.6	0	66	161	84	115	MBC8101528.1 Flp pilus assembly complex ATPase component TadA [Armatimonadota bacterium]	diamond	96	50.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32229833	32229833	PRJNA600413_P_NODE_121278_length_165_cov_0.879310_g120577_i0	PRJNA600413	121278	165	0.87931	1.4508615	Armatimonas sp.	1872638	Bacteria	Bacteria	43.5	0.00684	NR	WP_309712663.1	1872638	g120577	i0	37.3	2.81818181818182	51	32	92.7	0	155	3	60	110	WP_309712663.1 hypothetical protein, partial [Armatimonas sp.]	diamond	465	43.5	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
32324916	32324916	PRJNA600413_P_NODE_90179_length_173_cov_2.346774_g89478_i0	PRJNA600413	90179	173	2.346774	4.05991902	Armatimonadota bacterium	2033014	Bacteria	Bacteria	56.6	4.94e-8	NR	MFB3879773.1	2033014	g89478	i0	62.5	0.971098265895954	56	19	97.1	1	168	1	101	154	MFB3879773.1 sulfite exporter TauE/SafE family protein [Armatimonadota bacterium]	diamond	168	56.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota 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);;