metadata: contig_metadata: 14 rows where bioproject = "PRJNA1123309", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA1123309", 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
3579687	3579687	PRJNA1123309_P_NODE_67723_length_232_cov_3.194969_g67343_i0	PRJNA1123309	67723	232	3.194969	7.41232808	Chthonomonas	1077265	Bacteria	Bacteria	196	9.06e-46	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g67343	i0	84.729	115.801724137931	203	24	87	5	32	232	323	520	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	26866	196	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
8682282	8682282	PRJNA1123309_P_NODE_67627_length_233_cov_12.625000_g67247_i0	PRJNA1123309	67627	233	12.625	29.41625	Fimbriimonas	1005038	Bacteria	Bacteria	211	3.25e-50	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g67247	i0	84.163	212.437768240343	221	31	94	4	1	219	29563	29781	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	49498	211	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11756624	11756624	PRJNA1123309_P_NODE_20050_length_353_cov_1.667857_g19671_i0	PRJNA1123309	20050	353	1.667857	5.88753521	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	385	2.8999999999999995e-102	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g19671	i0	86.571	282.246458923513	350	45	99	2	5	353	3407467	3407119	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	99633	385	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
13032302	13032302	PRJNA1123309_P_NODE_67431_length_236_cov_2.785276_g67051_i0	PRJNA1123309	67431	236	2.785276	6.57325136	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	226	1.18e-54	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g67051	i0	86.765	540.656779661017	204	26	86	1	4	207	893169	893371	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	127595	226	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15581276	15581276	PRJNA1123309_P_NODE_47573_length_253_cov_0.866667_g47193_i0	PRJNA1123309	47573	253	0.866667	2.19266751	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	96.7	2.14e-21	NR	MCW3101274.1	2739509	g47193	i0	46.8	0.91304347826087	77	41	91.3	0	16	246	291	367	MCW3101274.1 transposase-like [Chthonomonadaceae bacterium]	diamond	231	96.7	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
16855872	16855872	PRJNA1123309_P_NODE_68334_length_216_cov_4.587413_g67954_i0	PRJNA1123309	68334	216	4.587413	9.90881208	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	187	5.01e-43	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g67954	i0	83.981	65.8888888888889	206	22	93	11	16	215	126644	126444	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	14232	187	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
25255305	25255305	PRJNA1123309_P_NODE_31400_length_292_cov_1.109589_g31020_i0	PRJNA1123309	31400	292	1.109589	3.23999988	Fimbriimonas	1005038	Bacteria	Bacteria	425	1.38e-114	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g31020	i0	93.972	253.982876712329	282	15	96	2	8	288	29005	28725	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	74163	425	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
27891318	27891318	PRJNA1123309_P_NODE_52845_length_250_cov_0.881356_g52465_i0	PRJNA1123309	52845	250	0.881356	2.20339	Chthonomonadales bacterium	2282151	Bacteria	Bacteria	112	1.98e-29	NR	HXG23971.1	2282151	g52465	i0	71.4	0.924	77	22	92.4	0	240	10	12	88	HXG23971.1 secondary thiamine-phosphate synthase enzyme YjbQ [Chthonomonadales bacterium]	diamond	231	112	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
28301872	28301872	PRJNA1123309_P_NODE_46446_length_254_cov_1.353591_g46066_i0	PRJNA1123309	46446	254	1.353591	3.43812114	Armatimonadota bacterium	2033014	Bacteria	Bacteria	61.2	1.23e-8	NR	HJN17197.1	2033014	g46066	i0	52.4	0.74409448818897606	63	26	73.2	2	225	40	282	341	HJN17197.1 hypothetical protein [Armatimonadota bacterium]	diamond	189	61.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28523052	28523052	PRJNA1123309_P_NODE_58487_length_246_cov_1.618497_g58107_i0	PRJNA1123309	58487	246	1.618497	3.98150262	Armatimonadota bacterium	2033014	Bacteria	Bacteria	42.7	0.0366	NR	MEN3001747.1	2033014	g58107	i0	40.9	0.536585365853659	44	26	53.7	0	151	20	4	47	MEN3001747.1 tetratricopeptide repeat protein [Armatimonadota bacterium]	diamond	132	42.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30407291	30407291	PRJNA1123309_P_NODE_64693_length_243_cov_0.917647_g64313_i0	PRJNA1123309	64693	243	0.917647	2.22988221	Armatimonadota	67819	Bacteria	Bacteria	129	9.11e-33	NR	WP_395095279.1	1872638	g64313	i0	71.3	4.9382716049382704	80	23	98.8	0	241	2	186	265	WP_395095279.1 DUF1592 domain-containing protein [Armatimonas sp.]	diamond	1200	130	0.992307692307692	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
30449549	30449549	PRJNA1123309_P_NODE_39433_length_272_cov_1.306533_g39053_i0	PRJNA1123309	39433	272	1.306533	3.5537697600000002	Fimbriimonas sp.	1936159	Bacteria	Bacteria	118	1.83e-30	NR	HWD40383.1	1936159	g39053	i0	63.2	0.959558823529412	87	32	96	0	10	270	88	174	HWD40383.1 ParB/RepB/Spo0J family partition protein [Fimbriimonas sp.]	diamond	261	118	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
31018124	31018124	PRJNA1123309_P_NODE_66515_length_242_cov_0.923077_g66135_i0	PRJNA1123309	66515	242	0.923077	2.23384634	Armatimonadota bacterium	2033014	Bacteria	Bacteria	103	1.4500000000000002e-26	NR	HUV04219.1	2033014	g66135	i0	61.5	1.93388429752066	78	30	96.7	0	235	2	3	80	HUV04219.1 polyhydroxyalkanoate synthesis regulator [Armatimonadota bacterium]	diamond	468	103	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31808592	31808592	PRJNA1123309_P_NODE_30757_length_294_cov_1.226244_g30377_i0	PRJNA1123309	30757	294	1.226244	3.60515736	Armatimonadota bacterium	2033014	Bacteria	Bacteria	57.4	4.74e-7	NR	MBN9503455.1	2033014	g30377	i0	57.4	0.908163265306122	47	20	48	0	285	145	14	60	MBN9503455.1 tetratricopeptide repeat protein [Armatimonadota bacterium]	diamond	267	57.4	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);;