metadata: contig_metadata: 8 rows where bioproject = "PRJNA1111077", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA1111077", 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
10417979	10417979	PRJNA1111077_P_NODE_17789_length_296_cov_3.385650_g17568_i0	PRJNA1111077	17789	296	3.38565	10.021524	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	110	1.61e-19	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g17568	i0	81.481	0.550675675675676	135	23	45	2	1	134	2118429	2118562	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	163	110	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26814718	26814718	PRJNA1111077_P_NODE_26501_length_264_cov_3.361257_g26280_i0	PRJNA1111077	26501	264	3.361257	8.87371848	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	82	7.13e-16	NR	MFQ3678497.1	2682144	g26280	i0	51.1	2.97727272727273	88	42	98.9	1	2	262	290	377	MFQ3678497.1 cytochrome c biogenesis protein CcsA [Fimbriimonadaceae bacterium]	diamond	786	82	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27036145	27036145	PRJNA1111077_P_NODE_34122_length_245_cov_0.895349_g33901_i0	PRJNA1111077	34122	245	0.895349	2.19360505	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	139	3.07e-36	NR	MBC7526815.1	2739509	g33901	i0	79	4.95918367346939	81	17	99.2	0	2	244	159	239	MBC7526815.1 DUF1592 domain-containing protein [Chthonomonadaceae bacterium]	diamond	1215	139	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
27162373	27162373	PRJNA1111077_P_NODE_32882_length_247_cov_0.885057_g32661_i0	PRJNA1111077	32882	247	0.885057	2.18609079	Armatimonadota bacterium	2033014	Bacteria	Bacteria	43.9	0.0146	NR	MCS7193046.1	2033014	g32661	i0	41.9	1.50607287449393	62	21	66.8	2	17	181	55	108	MCS7193046.1 ABC transporter permease [Armatimonadota bacterium]	diamond	372	43.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27289008	27289008	PRJNA1111077_P_NODE_28683_length_256_cov_1.683060_g28462_i0	PRJNA1111077	28683	256	1.68306	4.3086336	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	117	2.33e-28	NR	HLK15082.1	2682144	g28462	i0	64.3	0.984375	84	30	98.4	0	254	3	638	721	HLK15082.1 DUF4132 domain-containing protein [Fimbriimonadaceae bacterium]	diamond	252	117	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27510245	27510245	PRJNA1111077_P_NODE_14983_length_310_cov_4.063291_g14762_i0	PRJNA1111077	14983	310	4.063291	12.5962021	Armatimonadota bacterium	2033014	Bacteria	Bacteria	54.7	5.11e-6	NR	MFQ6099522.1	2033014	g14762	i0	34.8	1.73225806451613	92	49	78.4	1	249	7	376	467	MFQ6099522.1 VWA domain-containing protein [Armatimonadota bacterium]	diamond	537	54.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30478596	30478596	PRJNA1111077_P_NODE_11133_length_355_cov_1.365248_g10912_i0	PRJNA1111077	11133	355	1.365248	4.8466304	Armatimonadetes bacterium RBG_16_58_9	1797287	Bacteria	Bacteria	55.1	5.71e-6	NR	OFX15666.1	1797287	g10912	i0	62.8	0.363380281690141	43	15	35.5	1	352	227	62	104	OFX15666.1 MAG: hypothetical protein A2Z18_10935 [Armatimonadetes bacterium RBG_16_58_9]	diamond	129	55.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium RBG_16_58_9
31923874	31923874	PRJNA1111077_P_NODE_17317_length_298_cov_5.973333_g17096_i0	PRJNA1111077	17317	298	5.973333	17.80053234	Bacteria	2	Bacteria	Bacteria	61.6	1.67e-8	NR	WP_309718084.1	1872638	g17096	i0	96.9	7.22818791946309	32	1	32.2	0	2	97	659	690	WP_309718084.1 sodium-translocating pyrophosphatase [Armatimonas sp.]	diamond	2154	61.6	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.

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);;