metadata: contig_metadata: 16 rows where bioproject = "PRJNA864829", tax_kingdom = "Bacillati" and tax

16 rows where bioproject = "PRJNA864829", 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
11051048	11051048	PRJNA864829_S_NODE_9789_length_201_cov_1.401316_g9703_i0	PRJNA864829	9789	201	1.401316	2.81664516	Armatimonadota bacterium	2033014	Bacteria	Bacteria	96.3	1.48e-21	NR	MBU0607340.1	2033014	g9703	i0	70.1	9	67	20	100	0	1	201	224	290	MBU0607340.1 IS5 family transposase [Armatimonadota bacterium]	diamond	1809	96.3	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
11440633	11440633	PRJNA864829_S_NODE_12929_length_178_cov_2.302326_g12843_i0	PRJNA864829	12929	178	2.302326	4.09814028	Fimbriimonas	1005038	Bacteria	Bacteria	307	2.91e-79	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g12843	i0	97.753	772.061797752809	178	4	100	0	1	178	27158	26981	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	137427	307	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
12326404	12326404	PRJNA864829_S_NODE_10770_length_193_cov_2.215278_g10684_i0	PRJNA864829	10770	193	2.215278	4.27548654	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	206	1.21e-48	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g10684	i0	88.69	82.5284974093264	168	19	87	0	1	168	1879496	1879663	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	15928	206	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
14875327	14875327	PRJNA864829_S_NODE_9172_length_207_cov_0.841772_g9086_i0	PRJNA864829	9172	207	0.841772	1.74246804	Bacteria	2	Bacteria	Bacteria	116	2.26e-28	NR	MBX3119070.1	2682144	g9086	i0	72.1	5.91304347826087	68	19	98.6	0	205	2	9	76	MBX3119070.1 DNA primase [Fimbriimonadaceae bacterium]	diamond	1224	117	0.991452991452991	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15264784	15264784	PRJNA864829_S_NODE_7592_length_224_cov_1.360000_g7506_i0	PRJNA864829	7592	224	1.36	3.0464	Fimbriimonas	1005038	Bacteria	Bacteria	239	1.42e-58	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7506	i0	88.177	232.888392857143	203	20	90	4	24	224	27634	27434	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	52167	239	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17814326	17814326	PRJNA864829_S_NODE_254_length_826_cov_3.574003_g202_i0	PRJNA864829	254	826	3.574003	29.52126478	Fimbriimonas	1005038	Bacteria	Bacteria	981	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g202	i0	88.249	159.434624697337	834	80	99	13	1	825	29215	28391	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	131693	981	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23799532	23799532	PRJNA864829_S_NODE_3039_length_315_cov_3.409774_g2953_i0	PRJNA864829	3039	315	3.409774	10.7407881	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	407	5.459999999999999e-109	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g2953	i0	91.304	148.965079365079	299	25	95	1	18	315	668769	669067	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	46924	407	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
25073395	25073395	PRJNA864829_S_NODE_80_length_1202_cov_5.633998_g61_i0	PRJNA864829	80	1202	5.633998	67.72065596	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	484	1.02e-131	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g61	i0	74.895	110.520798668885	1191	236	96	57	1	1158	1305837	1306997	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	132846	484	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
25463564	25463564	PRJNA864829_S_NODE_6460_length_239_cov_7.242105_g6374_i0	PRJNA864829	6460	239	7.242105	17.30863095	Armatimonadota	67819	Bacteria	Bacteria	255	1.53e-63	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g6374	i0	90.306	116.338912133891	196	17	82	2	45	239	37378	37184	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	27805	255	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
26897087	26897087	PRJNA864829_S_NODE_6681_length_236_cov_3.406417_g6595_i0	PRJNA864829	6681	236	3.406417	8.03914412	Armatimonadota bacterium	2033014	Bacteria	Bacteria	140	9.619999999999998e-37	NR	MCC7438988.1	2033014	g6595	i0	89.2	1.88135593220339	74	8	94.1	0	236	15	600	673	MCC7438988.1 OmpA family protein [Armatimonadota bacterium]	diamond	444	140	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28065813	28065813	PRJNA864829_S_NODE_16065_length_162_cov_3.964602_g15979_i0	PRJNA864829	16065	162	3.964602	6.42265524	Armatimonadota bacterium	2033014	Bacteria	Bacteria	92.4	1.79e-22	NR	MCC7437879.1	2033014	g15979	i0	86.8	0.981481481481482	53	7	98.1	0	161	3	39	91	MCC7437879.1 endonuclease domain-containing protein [Armatimonadota bacterium]	diamond	159	92.4	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30253039	30253039	PRJNA864829_S_NODE_9232_length_206_cov_1.917197_g9146_i0	PRJNA864829	9232	206	1.917197	3.94942582	FCB group	1783270	Bacteria	Bacteria	72.4	8.05e-13	NR	MCC7436866.1	2033014	g9146	i0	100	2.47572815533981	34	0	49.5	0	136	35	745	778	MCC7436866.1 hypothetical protein [Armatimonadota bacterium]	diamond	510	72.4	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30403112	30403112	PRJNA864829_S_NODE_9933_length_200_cov_1.463576_g9847_i0	PRJNA864829	9933	200	1.463576	2.927152	Armatimonadota bacterium	2033014	Bacteria	Bacteria	136	1.95e-35	NR	MCC7438601.1	2033014	g9847	i0	90.9	0.99	66	6	99	0	199	2	92	157	MCC7438601.1 Eco57I restriction-modification methylase domain-containing protein [Armatimonadota bacterium]	diamond	198	136	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30876599	30876599	PRJNA864829_S_NODE_4414_length_277_cov_1.307018_g4328_i0	PRJNA864829	4414	277	1.307018	3.62043986	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	128	1e-36	NR	MBL8065531.1	2739509	g4328	i0	100	0.649819494584838	60	0	65	0	180	1	1	60	MBL8065531.1 type Z 30S ribosomal protein S14 [Chthonomonadaceae bacterium]	diamond	180	128	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
30916512	30916512	PRJNA864829_S_NODE_3454_length_301_cov_3.535714_g3368_i0	PRJNA864829	3454	301	3.535714	10.64249914	Fimbriimonas	1005038	Bacteria	Bacteria	77.4	2.07e-15	NR	WP_025227921.1	1005039	g3368	i0	50.7	1.42524916943522	69	34	68.8	0	259	53	90	158	WP_025227921.1 hypothetical protein [Fimbriimonas ginsengisoli]	diamond	429	77.8	0.994858611825193	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
32402868	32402868	PRJNA864829_S_NODE_11019_length_191_cov_3.401408_g10933_i0	PRJNA864829	11019	191	3.401408	6.49668928	FCB group	1783270	Bacteria	Bacteria	138	8.259999999999999e-37	NR	MCC7437919.1	2033014	g10933	i0	100	1.97905759162304	63	0	99	0	191	3	111	173	MCC7437919.1 aldehyde dehydrogenase family protein [Armatimonadota bacterium]	diamond	378	138	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);;