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

6 rows where bioproject = "PRJNA1111082", 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
27888928	27888928	PRJNA1111082_P_NODE_9745_length_261_cov_0.829787_g9700_i0	PRJNA1111082	9745	261	0.829787	2.16574407	Armatimonadota bacterium	2033014	Bacteria	Bacteria	116	6.919999999999999e-31	NR	MBC8142647.1	2033014	g9700	i0	72.1	1.97701149425287	86	24	98.9	0	3	260	9	94	MBC8142647.1 IS200/IS605 family element transposase accessory protein TnpB [Armatimonadota bacterium]	diamond	516	116	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28994415	28994415	PRJNA1111082_P_NODE_10348_length_253_cov_1.072222_g10303_i0	PRJNA1111082	10348	253	1.072222	2.71272166	Fimbriimonas sp.	1936159	Bacteria	Bacteria	58.5	4.2e-8	NR	HLO97251.1	1936159	g10303	i0	41.8	0.936758893280632	79	41	93.7	1	251	15	2	75	HLO97251.1 hypothetical protein [Fimbriimonas sp.]	diamond	237	58.5	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
29206595	29206595	PRJNA1111082_P_NODE_10509_length_252_cov_1.586592_g10464_i0	PRJNA1111082	10509	252	1.586592	3.99821184	Bacteria	2	Bacteria	Bacteria	105	2.32e-27	NR	MBI2201853.1	2033014	g10464	i0	68.3	2.95238095238095	82	25	97.6	1	248	3	10	90	MBI2201853.1 transposase [Armatimonadota bacterium]	diamond	744	105	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30510081	30510081	PRJNA1111082_P_NODE_2633_length_467_cov_1.540609_g2588_i0	PRJNA1111082	2633	467	1.540609	7.19464403	Armatimonadota bacterium	2033014	Bacteria	Bacteria	108	1.25e-24	NR	MBS1722530.1	2033014	g2588	i0	39.4	0.995717344753747	155	92	98.3	2	459	1	119	273	MBS1722530.1 AAA family ATPase [Armatimonadota bacterium]	diamond	465	108	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30857566	30857566	PRJNA1111082_P_NODE_10174_length_255_cov_1.285714_g10129_i0	PRJNA1111082	10174	255	1.285714	3.2785707	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	67.4	6.65e-11	NR	GIV04105.1	2682145	g10129	i0	44.4	0.847058823529412	72	40	84.7	0	229	14	221	292	GIV04105.1 MAG: hypothetical protein KatS3mg015_2935 [Fimbriimonadales bacterium]	diamond	216	67.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
31869351	31869351	PRJNA1111082_P_NODE_7057_length_304_cov_1.012987_g7012_i0	PRJNA1111082	7057	304	1.012987	3.07948048	Armatimonadota bacterium	2033014	Bacteria	Bacteria	68.6	4.87e-12	NR	MBM3493291.1	2033014	g7012	i0	45.1	0.898026315789474	91	36	76	3	23	253	50	140	MBM3493291.1 hypothetical protein [Armatimonadota bacterium]	diamond	273	68.6	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);;