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

10 rows where bioproject = "PRJNA890871", 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
865531	865531	PRJNA890871_P_NODE_93581_length_207_cov_4.380597_g93446_i0	PRJNA890871	93581	207	4.380597	9.06783579	PVC group	1783257	Bacteria	Bacteria	67.4	4.2e-11	NR	WP_309723482.1	1872638	g93446	i0	57.9	6.23188405797101	57	24	82.6	0	5	175	315	371	WP_309723482.1 flagellar biosynthesis protein FlhF [Armatimonas sp.]	diamond	1290	67.8	0.994100294985251	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
26675395	26675395	PRJNA890871_P_NODE_72681_length_247_cov_0.885057_g72546_i0	PRJNA890871	72681	247	0.885057	2.18609079	Armatimonadota bacterium	2033014	Bacteria	Bacteria	67.8	5.93e-11	NR	HEY3281287.1	2033014	g72546	i0	38.7	0.910931174089069	75	45	91.1	1	240	16	383	456	HEY3281287.1 sugar-binding protein [Armatimonadota bacterium]	diamond	225	67.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27908085	27908085	PRJNA890871_P_NODE_17905_length_381_cov_3.688312_g17770_i0	PRJNA890871	17905	381	3.688312	14.05246872	Armatimonadota bacterium	2033014	Bacteria	Bacteria	150	3.82e-42	NR	MBI3930308.1	2033014	g17770	i0	52.7	1.03149606299213	131	58	100	1	381	1	76	206	MBI3930308.1 DUF5591 domain-containing protein [Armatimonadota bacterium]	diamond	393	150	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28350373	28350373	PRJNA890871_P_NODE_4106_length_747_cov_2.347181_g3974_i0	PRJNA890871	4106	747	2.347181	17.53344207	Armatimonadota bacterium	2033014	Bacteria	Bacteria	301	5.869999999999998e-96	NR	MDE2127144.1	2033014	g3974	i0	60.9	0.995983935742972	248	96	99.6	1	2	745	68	314	MDE2127144.1 hypothetical protein [Armatimonadota bacterium]	diamond	744	301	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28634875	28634875	PRJNA890871_P_NODE_94187_length_199_cov_4.134921_g94052_i0	PRJNA890871	94187	199	4.134921	8.22849279	Armatimonadota bacterium	2033014	Bacteria	Bacteria	87.8	2.68e-18	NR	MBC7804913.1	2033014	g94052	i0	70.8	0.979899497487437	65	19	98	0	197	3	567	631	MBC7804913.1 hypothetical protein [Armatimonadota bacterium]	diamond	195	87.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29234607	29234607	PRJNA890871_P_NODE_80129_length_243_cov_1.811765_g79994_i0	PRJNA890871	80129	243	1.811765	4.40258895	Chthonomonadales bacterium	2282151	Bacteria	Bacteria	114	2.5e-27	NR	MCW3051259.1	2282151	g79994	i0	70.4	1	81	24	100	0	1	243	32	112	MCW3051259.1 LuxR family transcriptional regulator [Chthonomonadales bacterium]	diamond	243	114	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
29265904	29265904	PRJNA890871_P_NODE_68449_length_249_cov_0.875000_g68314_i0	PRJNA890871	68449	249	0.875	2.17875	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	92	1.87e-19	NR	MEA2554428.1	2682144	g68314	i0	46.9	0.975903614457831	81	42	96.4	1	10	249	133	213	MEA2554428.1 tricorn protease [Fimbriimonadaceae bacterium]	diamond	243	92	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
30497951	30497951	PRJNA890871_P_NODE_68193_length_249_cov_0.875000_g68058_i0	PRJNA890871	68193	249	0.875	2.17875	Fimbriimonas sp.	1936159	Bacteria	Bacteria	137	1.63e-37	NR	HSI72008.1	1936159	g68058	i0	77.3	0.903614457831325	75	17	90.4	0	21	245	208	282	HSI72008.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Fimbriimonas sp.]	diamond	225	137	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
32015385	32015385	PRJNA890871_P_NODE_44278_length_275_cov_1.480198_g44143_i0	PRJNA890871	44278	275	1.480198	4.0705445	Armatimonadota bacterium	2033014	Bacteria	Bacteria	84	1.72e-16	NR	MCC2672153.1	2033014	g44143	i0	54.8	0.796363636363636	73	33	79.6	0	1	219	22	94	MCC2672153.1 protein translocase subunit secF/protein translocase subunit secD [Armatimonadota bacterium]	diamond	219	84	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32647494	32647494	PRJNA890871_P_NODE_84520_length_241_cov_3.785714_g84385_i0	PRJNA890871	84520	241	3.785714	9.12357074	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	94	1.58e-21	NR	MDX2065328.1	2682144	g84385	i0	71.4	2.47717842323651	63	18	78.4	0	189	1	2	64	MDX2065328.1 Sir2 family NAD-dependent protein deacetylase [Fimbriimonadaceae bacterium]	diamond	597	94	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae 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);;