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

5 rows where bioproject = "PRJNA849646", 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
8490970	8490970	PRJNA849646_P_NODE_20147_length_268_cov_1.579487_g20029_i0	PRJNA849646	20147	268	1.579487	4.23302516	Armatimonadota bacterium	2033014	Bacteria	Bacteria	123	1.33e-31	NR	MES2464449.1	2033014	g20029	i0	78.3	0.92910447761194	83	17	91.8	1	251	6	14	96	MES2464449.1 LacI family DNA-binding transcriptional regulator [Armatimonadota bacterium]	diamond	249	123	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
12317323	12317323	PRJNA849646_P_NODE_22650_length_263_cov_2.131579_g22532_i0	PRJNA849646	22650	263	2.131579	5.60605277	Fimbriimonas sp.	1936159	Bacteria	Bacteria	120	1.9299999999999995e-31	NR	HEY0866763.1	1936159	g22532	i0	63.2	1.98479087452471	87	32	99.2	0	261	1	64	150	HEY0866763.1 hypothetical protein [Fimbriimonas sp.]	diamond	522	120	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
29391832	29391832	PRJNA849646_P_NODE_21629_length_265_cov_2.088542_g21511_i0	PRJNA849646	21629	265	2.088542	5.5346363	Armatimonadota bacterium	2033014	Bacteria	Bacteria	66.6	1.96e-10	NR	MBI2843864.1	2033014	g21511	i0	41.4	0.984905660377358	87	40	88.3	2	264	31	312	396	MBI2843864.1 choice-of-anchor D domain-containing protein [Armatimonadota bacterium]	diamond	261	66.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30023507	30023507	PRJNA849646_P_NODE_16151_length_276_cov_1.167488_g16033_i0	PRJNA849646	16151	276	1.167488	3.22226688	Armatimonadota bacterium	2033014	Bacteria	Bacteria	124	9.92e-32	NR	MBC8135123.1	2033014	g16033	i0	67.8	1.89130434782609	87	28	94.6	0	1	261	281	367	MBC8135123.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadota bacterium]	diamond	522	124	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30971291	30971291	PRJNA849646_P_NODE_19954_length_268_cov_2.805128_g19836_i0	PRJNA849646	19954	268	2.805128	7.51774304	Armatimonadaceae bacterium	2933160	Bacteria	Bacteria	164	4.11e-45	NR	HVK03244.1	2933160	g19836	i0	81.8	0.985074626865672	88	16	98.5	0	264	1	34	121	HVK03244.1 hypothetical protein [Armatimonadaceae bacterium]	diamond	264	164	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae		Armatimonadaceae 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);;