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

5 rows where bioproject = "PRJNA908278", 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_species
3441267	3441267	PRJNA908278_P_NODE_7643_length_428_cov_1.715493_g7540_i0	PRJNA908278	7643	428	1.715493	7.34231004	Armatimonadota bacterium	2033014	Bacteria	Bacteria	62	5.18e-8	NR	MBS1716455.1	2033014	g7540	i0	40.4	1.39485981308411	94	51	64.5	3	420	145	15	105	MBS1716455.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium]	diamond	597	62	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
26960939	26960939	PRJNA908278_P_NODE_4502_length_544_cov_1.295117_g4399_i0	PRJNA908278	4502	544	1.295117	7.04543648	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	68.9	1.42e-10	NR	HEY3780547.1	2682144	g4399	i0	43.3	1.03125	90	44	49.6	1	187	456	120	202	HEY3780547.1 aquaporin [Fimbriimonadaceae bacterium]	diamond	561	68.9	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
28414148	28414148	PRJNA908278_P_NODE_20106_length_287_cov_1.341121_g20003_i0	PRJNA908278	20106	287	1.341121	3.84901727	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	107	2.52e-25	NR	MEA2552362.1	2682144	g20003	i0	53.7	3.97212543554007	95	44	99.3	0	3	287	279	373	MEA2552362.1 cystathionine gamma-lyase [Fimbriimonadaceae bacterium]	diamond	1140	107	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
30213846	30213846	PRJNA908278_P_NODE_7272_length_439_cov_1.051913_g7169_i0	PRJNA908278	7272	439	1.051913	4.61789807	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	45.4	0.0221	NR	MBC8064416.1	2682144	g7169	i0	31.8	0.73120728929385	107	61	67	3	412	119	8	111	MBC8064416.1 PEP-CTERM sorting domain-containing protein [Fimbriimonadaceae bacterium]	diamond	321	45.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
32237696	32237696	PRJNA908278_P_NODE_29558_length_248_cov_0.880000_g29455_i0	PRJNA908278	29558	248	0.88	2.1824	Armatimonadota bacterium	2033014	Bacteria	Bacteria	60.8	1.64e-8	NR	MCX6381156.1	2033014	g29455	i0	39	0.991935483870968	82	37	99.2	1	1	246	87	155	MCX6381156.1 Ig-like domain repeat protein [Armatimonadota bacterium]	diamond	246	60.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);;