metadata: contig_metadata: 6 rows where bioproject = "PRJNA594101", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA594101", 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
16442163	16442163	PRJNA594101_S_NODE_7533_length_595_cov_5.921456_g7234_i0	PRJNA594101	7533	595	5.921456	35.2326632	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	176	2.1699999999999993e-52	NR	MEJ5169988.1	2682145	g7234	i0	57.6	1.55798319327731	151	60	75.6	3	520	71	32	179	MEJ5169988.1 glutathione peroxidase [Fimbriimonadales bacterium]	diamond	927	176	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales		Fimbriimonadales bacterium
26953025	26953025	PRJNA594101_S_NODE_37202_length_284_cov_2.113744_g36900_i0	PRJNA594101	37202	284	2.113744	6.00303296	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	62.4	7.26e-9	NR	HEY3780838.1	2682144	g36900	i0	50.8	1.2887323943662	61	26	64.4	1	184	2	166	222	HEY3780838.1 ankyrin repeat domain-containing protein [Fimbriimonadaceae bacterium]	diamond	366	62.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
27048186	27048186	PRJNA594101_S_NODE_25402_length_336_cov_1.171103_g25100_i0	PRJNA594101	25402	336	1.171103	3.93490608	Armatimonadota bacterium	2033014	Bacteria	Bacteria	93.6	1.14e-19	NR	MBM3464694.1	2033014	g25100	i0	67.7	1.17857142857143	65	21	58	0	326	132	384	448	MBM3464694.1 aspartate aminotransferase family protein [Armatimonadota bacterium]	diamond	396	93.6	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
27648590	27648590	PRJNA594101_S_NODE_4944_length_728_cov_3.305344_g4667_i0	PRJNA594101	4944	728	3.305344	24.06290432	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	73.2	9.49e-12	NR	MBL8064284.1	2739509	g4667	i0	28.9	0.684065934065934	166	111	65.5	2	252	728	3	168	MBL8064284.1 PEP-CTERM sorting domain-containing protein [Chthonomonadaceae bacterium]	diamond	498	73.2	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonadaceae bacterium
31153650	31153650	PRJNA594101_S_NODE_5055_length_719_cov_5.001548_g4778_i0	PRJNA594101	5055	719	5.001548	35.96113012	Armatimonadota bacterium	2033014	Bacteria	Bacteria	119	1.15e-26	NR	MBI1333722.1	2033014	g4778	i0	46.8	5.9749652294854	126	66	52.2	1	146	520	459	584	MBI1333722.1 beta-galactosidase [Armatimonadota bacterium]	diamond	4296	119	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
32609011	32609011	PRJNA594101_S_NODE_57720_length_241_cov_0.904762_g57418_i0	PRJNA594101	57720	241	0.904762	2.18047642	Armatimonadota bacterium	2033014	Bacteria	Bacteria	77.8	1.29e-15	NR	MDQ7800261.1	2033014	g57418	i0	49.4	6.28630705394191	79	39	98.3	1	238	2	57	134	MDQ7800261.1 O-acetyl-ADP-ribose deacetylase [Armatimonadota bacterium]	diamond	1515	77.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);;