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

5 rows where bioproject = "PRJNA591127", 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
8218342	8218342	PRJNA591127_P_NODE_3467_length_386_cov_2.693410_g3299_i0	PRJNA591127	3467	386	2.69341	10.3965626	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	207	7.43e-49	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g3299	i0	92	311.836787564767	150	9	39	3	6	154	1305219	1305366	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	120369	207	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
18416825	18416825	PRJNA591127_P_NODE_12155_length_211_cov_2.356322_g11986_i0	PRJNA591127	12155	211	2.356322	4.97183942	Capsulimonas corticalis	2219043	Bacteria	Bacteria	193	1.05e-44	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g11986	i0	84.541	147.781990521327	207	18	96	11	9	211	593459	593263	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	31182	193	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
24791347	24791347	PRJNA591127_P_NODE_540_length_828_cov_16.093552_g448_i0	PRJNA591127	540	828	16.093552	133.25461056	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	549	2.419999999999999e-151	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g448	i0	81.267	342.091787439614	726	95	85	29	1	704	1306507	1305801	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	283252	549	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
27282895	27282895	PRJNA591127_P_NODE_29323_length_151_cov_4.131579_g29154_i0	PRJNA591127	29323	151	4.131579	6.23868429	Bacteria	2	Bacteria	Bacteria	41.6	0.0279	NR	WP_309719678.1	1872638	g29154	i0	60	1.98675496688742	25	10	49.7	0	11	85	571	595	WP_309719678.1 DEAD/DEAH box helicase family protein, partial [Armatimonas sp.]	diamond	300	41.6	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
32860757	32860757	PRJNA591127_P_NODE_20240_length_197_cov_1.756250_g20071_i0	PRJNA591127	20240	197	1.75625	3.4598125	Armatimonadota bacterium	2033014	Bacteria	Bacteria	82	2.89e-16	NR	MBI3947599.1	2033014	g20071	i0	63.6	1.00507614213198	66	23	99	1	3	197	384	449	MBI3947599.1 AAA family ATPase [Armatimonadota bacterium]	diamond	198	82	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);;