metadata: contig_metadata: 12 rows where bioproject = "PRJNA1118794", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA1118794", 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
4852981	4852981	PRJNA1118794_P_NODE_35104_length_279_cov_3.966019_g34354_i0	PRJNA1118794	35104	279	3.966019	11.06519301	Chthonomonas	1077265	Bacteria	Bacteria	254	6.56e-63	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g34354	i0	84.351	5.62724014336918	262	38	93	3	1	260	1226	1486	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	1570	254	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
5333687	5333687	PRJNA1118794_P_NODE_35545_length_278_cov_3.248780_g34795_i0	PRJNA1118794	35545	278	3.24878	9.0316084	Capsulimonas corticalis	2219043	Bacteria	Bacteria	427	3.6399999999999996e-115	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g34795	i0	94.585	460.431654676259	277	13	100	2	1	275	593652	593928	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	128000	427	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
6608516	6608516	PRJNA1118794_P_NODE_21306_length_331_cov_1.806202_g20556_i0	PRJNA1118794	21306	331	1.806202	5.97852862	Capsulimonas corticalis	2219043	Bacteria	Bacteria	438	2.0499999999999993e-118	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g20556	i0	90.634	504.851963746224	331	29	99	2	1	330	593560	593231	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	167106	438	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
6608641	6608641	PRJNA1118794_P_NODE_30966_length_289_cov_3.314815_g30216_i0	PRJNA1118794	30966	289	3.314815	9.57981535	Armatimonadota bacterium	2033014	Bacteria	Bacteria	130	3.97e-33	NR	MBS1726118.1	2033014	g30216	i0	64.6	3.93425605536332	96	31	99.7	1	288	1	340	432	MBS1726118.1 MmgE/PrpD family protein [Armatimonadota bacterium]	diamond	1137	130	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
9158542	9158542	PRJNA1118794_P_NODE_44448_length_259_cov_1.559140_g43698_i0	PRJNA1118794	44448	259	1.55914	4.0381726	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	84.2	8.36e-12	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g43698	i0	73.585	1.14671814671815	265	50	99	18	1	258	3408478	3408227	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	297	84.2	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
9158724	9158724	PRJNA1118794_P_NODE_59908_length_246_cov_1.670520_g59158_i0	PRJNA1118794	59908	246	1.67052	4.1094792	Capsulimonas corticalis	2219043	Bacteria	Bacteria	335	1.9699999999999992e-87	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g59158	i0	91.2	784.963414634146	250	17	100	5	1	246	594189	594437	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	193101	335	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
10433858	10433858	PRJNA1118794_P_NODE_17149_length_358_cov_0.877193_g16399_i0	PRJNA1118794	17149	358	0.877193	3.14035094	Capsulimonas corticalis	2219043	Bacteria	Bacteria	507	6.02e-139	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g16399	i0	92.222	479.851955307263	360	25	100	3	1	358	593560	593202	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	171787	507	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
23977235	23977235	PRJNA1118794_P_NODE_22199_length_326_cov_6.853755_g21449_i0	PRJNA1118794	22199	326	6.853755	22.3432413	Fimbriimonas	1005038	Bacteria	Bacteria	272	2.16e-68	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g21449	i0	82.848	330.923312883436	309	48	94	5	7	312	29785	29479	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	107881	272	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
30794687	30794687	PRJNA1118794_P_NODE_64654_length_244_cov_1.801170_g63904_i0	PRJNA1118794	64654	244	1.80117	4.3948548	Capsulimonadales bacterium	2971800	Bacteria	Bacteria	107	2.38e-26	NR	MDX1931059.1	2971800	g63904	i0	70.7	0.922131147540984	75	22	92.2	0	243	19	208	282	MDX1931059.1 Stp1/IreP family PP2C-type Ser/Thr phosphatase [Capsulimonadales bacterium]	diamond	225	107	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales			Capsulimonadales bacterium
31363801	31363801	PRJNA1118794_P_NODE_49096_length_251_cov_0.865169_g48346_i0	PRJNA1118794	49096	251	0.865169	2.17157419	Armatimonadota bacterium	2033014	Bacteria	Bacteria	84	8.12e-18	NR	MCA0362111.1	2033014	g48346	i0	52.4	2.00796812749004	82	38	98	1	2	247	88	168	MCA0362111.1 GNAT family N-acetyltransferase [Armatimonadota bacterium]	diamond	504	84	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31734031	31734031	PRJNA1118794_P_NODE_70617_length_242_cov_0.911243_g69867_i0	PRJNA1118794	70617	242	0.911243	2.20520806	PVC group	1783257	Bacteria	Bacteria	97.1	2.5600000000000003e-21	NR	MBI3922192.1	2033014	g69867	i0	55.7	2.93801652892562	79	29	96.7	2	4	237	133	206	MBI3922192.1 hypothetical protein [Armatimonadota bacterium]	diamond	711	97.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32786085	32786085	PRJNA1118794_P_NODE_29640_length_294_cov_1.217195_g28890_i0	PRJNA1118794	29640	294	1.217195	3.5785533	Armatimonadota bacterium	2033014	Bacteria	Bacteria	43.5	0.0362	NR	MCC6446865.1	2033014	g28890	i0	51.2	0.418367346938776	41	18	40.8	2	75	194	13	52	MCC6446865.1 DUF4091 domain-containing protein [Armatimonadota bacterium]	diamond	123	43.5	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);;