metadata: contig_metadata: 7 rows where bioproject = "PRJEB81327", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJEB81327", 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
21817020	21817020	PRJEB81327_P_NODE_8218_length_485_cov_1.601942_g7611_i0	PRJEB81327	8218	485	1.601942	7.7694187	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g7611	i0	94.118	0.0701030927835052	34	2	7	0	112	145	2475734	2475701	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	34	52.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales		Fimbriimonadales bacterium
26685961	26685961	PRJEB81327_P_NODE_46321_length_251_cov_0.865169_g45713_i0	PRJEB81327	46321	251	0.865169	2.17157419	Armatimonadota bacterium	2033014	Bacteria	Bacteria	107	1.2200000000000002e-27	NR	HTE18704.1	2033014	g45713	i0	61.8	1.86454183266932	76	29	90.8	0	251	24	67	142	HTE18704.1 hypothetical protein [Armatimonadota bacterium]	diamond	468	107	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
26717290	26717290	PRJEB81327_P_NODE_41381_length_259_cov_1.327957_g40773_i0	PRJEB81327	41381	259	1.327957	3.43940863	Armatimonadota bacterium	2033014	Bacteria	Bacteria	65.5	1.09e-11	NR	MBW3636559.1	2033014	g40773	i0	82.8	0.335907335907336	29	5	33.6	0	171	257	1	29	MBW3636559.1 hypothetical protein [Armatimonadota bacterium]	diamond	87	65.5	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
28613344	28613344	PRJEB81327_P_NODE_25827_length_286_cov_1.347418_g25219_i0	PRJEB81327	25827	286	1.347418	3.85361548	Chthonomonadales bacterium	2282151	Bacteria	Bacteria	77.8	8.34e-15	NR	MCW3051939.1	2282151	g25219	i0	44.2	2.70629370629371	77	43	80.8	0	254	24	36	112	MCW3051939.1 N-Dimethylarginine dimethylaminohydrolase [Chthonomonadales bacterium]	diamond	774	77.8	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales		Chthonomonadales bacterium
29876426	29876426	PRJEB81327_P_NODE_48591_length_250_cov_0.870056_g47983_i0	PRJEB81327	48591	250	0.870056	2.17514	Armatimonadota bacterium	2033014	Bacteria	Bacteria	53.1	7.67e-6	NR	MCX6379887.1	2033014	g47983	i0	51.1	2.064	47	22	56.4	1	250	110	227	272	MCX6379887.1 alpha/beta hydrolase [Armatimonadota bacterium]	diamond	516	53.1	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
31139729	31139729	PRJEB81327_P_NODE_55715_length_246_cov_0.890173_g55107_i0	PRJEB81327	55715	246	0.890173	2.18982558	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	131	2.81e-36	NR	MEA2554330.1	2682144	g55107	i0	69.5	1.98780487804878	82	25	100	0	246	1	28	109	MEA2554330.1 transcriptional regulator [Fimbriimonadaceae bacterium]	diamond	489	131	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
31298142	31298142	PRJEB81327_P_NODE_49375_length_249_cov_2.079545_g48767_i0	PRJEB81327	49375	249	2.079545	5.17806705	Armatimonadota bacterium	2033014	Bacteria	Bacteria	116	3.82e-28	NR	MBC7807156.1	2033014	g48767	i0	66.7	1.95180722891566	81	27	97.6	0	5	247	12	92	MBC7807156.1 S9 family peptidase [Armatimonadota bacterium]	diamond	486	116	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);;