metadata: contig_metadata: 5 rows where bioproject = "PRJNA1215813", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA1215813", 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
7985186	7985186	PRJNA1215813_P_NODE_5467_length_331_cov_1.957364_g5387_i0	PRJNA1215813	5467	331	1.957364	6.47887484	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	164	7.75e-49	NR	HEY3782149.1	2682144	g5387	i0	71.6	21.7341389728097	109	31	98.8	0	3	329	66	174	HEY3782149.1 CoA transferase subunit B [Fimbriimonadaceae bacterium]	diamond	7194	164	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
21447702	21447702	PRJNA1215813_P_NODE_5217_length_338_cov_1.132075_g5137_i0	PRJNA1215813	5217	338	1.132075	3.8264135	Fimbriimonas	1005038	Bacteria	Bacteria	422	2.11e-113	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g5137	i0	89.381	143.786982248521	339	31	100	4	1	338	28703	28369	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	48600	422	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
28967630	28967630	PRJNA1215813_P_NODE_1828_length_549_cov_1.964286_g1749_i0	PRJNA1215813	1828	549	1.964286	10.78393014	Fimbriimonas sp.	1936159	Bacteria	Bacteria	70.1	1.3099999999999999e-10	NR	HLO99943.1	1936159	g1749	i0	32.9	1.62841530054645	140	85	75.4	2	522	109	143	275	HLO99943.1 collagen-binding domain-containing protein [Fimbriimonas sp.]	diamond	894	70.1	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
29030829	29030829	PRJNA1215813_P_NODE_12588_length_242_cov_0.923077_g12508_i0	PRJNA1215813	12588	242	0.923077	2.23384634	Capsulimonas corticalis	2219043	Bacteria	Bacteria	111	1.09e-26	NR	WP_119324298.1	2219043	g12508	i0	65	0.991735537190083	80	28	99.2	0	1	240	1	80	WP_119324298.1 glycoside hydrolase family 125 protein [Capsulimonas corticalis]	diamond	240	111	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
29819750	29819750	PRJNA1215813_P_NODE_8351_length_271_cov_1.181818_g8271_i0	PRJNA1215813	8351	271	1.181818	3.20272678	Armatimonadota bacterium	2033014	Bacteria	Bacteria	47.8	6.2e-4	NR	HEX2952174.1	2033014	g8271	i0	36.5	0.575645756457565	52	33	57.6	0	262	107	48	99	HEX2952174.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium]	diamond	156	47.8	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);;