metadata: contig_metadata: 12 rows where bioproject = "PRJNA917598" and tax

12 rows where bioproject = "PRJNA917598" 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
10180205	10180205	PRJNA917598_P_NODE_6888_length_920_cov_3.736718_g6114_i0	PRJNA917598	6888	920	3.736718	34.3778056	Capsulimonas	2494209	Bacteria	Bacteria	468	7.790000000000001e-127	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g6114	i0	84.615	290.632608695652	481	63	52	7	3	480	3408694	3408222	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	267382	468	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
12375131	12375131	PRJNA917598_P_NODE_40970_length_359_cov_1.059441_g40026_i0	PRJNA917598	40970	359	1.059441	3.80339319	Bacteria	2	Bacteria	Bacteria	102	1.12e-25	NR	MFM7320239.1	2033014	g40026	i0	88.9	1.8050139275766	54	6	45.1	0	164	3	1	54	MFM7320239.1 50S ribosomal protein L27 [Armatimonadota bacterium]	diamond	648	102	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
12375477	12375477	PRJNA917598_P_NODE_54730_length_308_cov_1.821277_g53786_i0	PRJNA917598	54730	308	1.821277	5.60953316	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	128	4.64e-25	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g53786	i0	86.842	0.37012987012987	114	15	37	0	193	306	1625755	1625868	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	114	128	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
12375721	12375721	PRJNA917598_P_NODE_64750_length_282_cov_1.473684_g63806_i0	PRJNA917598	64750	282	1.473684	4.15578888	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	381	2.919999999999999e-101	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g63806	i0	91.103	287.890070921986	281	25	99	0	2	282	1879368	1879648	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	81185	381	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
13650248	13650248	PRJNA917598_P_NODE_66831_length_278_cov_1.497561_g65887_i0	PRJNA917598	66831	278	1.497561	4.16321958	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	248	3.0399999999999997e-61	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g65887	i0	84.585	289.161870503597	253	36	90	3	28	277	1304760	1304508	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	80387	248	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
14005074	14005074	PRJNA917598_P_NODE_12391_length_673_cov_3.160000_g11470_i0	PRJNA917598	12391	673	3.16	21.2668	Fimbriimonas	1005038	Bacteria	Bacteria	883	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11470	i0	90.909	218.887072808321	660	57	98	2	1	659	28905	28248	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	147311	883	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
16198590	16198590	PRJNA917598_P_NODE_30313_length_418_cov_1.594203_g29369_i0	PRJNA917598	30313	418	1.594203	6.66376854	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	484	3.3499999999999995e-132	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g29369	i0	87.952	25.1196172248804	415	44	99	6	1	412	894316	894727	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	10500	484	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
26992716	26992716	PRJNA917598_P_NODE_31022_length_413_cov_2.247059_g30078_i0	PRJNA917598	31022	413	2.247059	9.28035367	Armatimonadota bacterium	2033014	Bacteria	Bacteria	63.9	2.51e-9	NR	MBS1713088.1	2033014	g30078	i0	44.7	0.552058111380145	76	39	55.2	2	151	378	133	205	MBS1713088.1 hypothetical protein [Armatimonadota bacterium]	diamond	228	63.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30624850	30624850	PRJNA917598_P_NODE_77853_length_254_cov_2.425414_g76909_i0	PRJNA917598	77853	254	2.425414	6.16055156	Armatimonas sp.	1872638	Bacteria	Bacteria	57.4	2.87e-7	NR	WP_395145221.1	1872638	g76909	i0	60	1.58267716535433	45	18	53.1	0	6	140	410	454	WP_395145221.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Armatimonas sp.]	diamond	402	57.4	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
31232383	31232383	PRJNA917598_P_NODE_83075_length_249_cov_0.875000_g82131_i0	PRJNA917598	83075	249	0.875	2.17875	Armatimonadia	1042312	Bacteria	Bacteria	131	1.17e-35	NR	HVK01885.1	2933160	g82131	i0	75	2.89156626506024	80	20	96.4	0	241	2	1	80	HVK01885.1 enoyl-ACP reductase [Armatimonadaceae bacterium]	diamond	720	131	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae		Armatimonadaceae bacterium
31731233	31731233	PRJNA917598_P_NODE_66017_length_280_cov_1.169082_g65073_i0	PRJNA917598	66017	280	1.169082	3.2734296	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	134	1.88e-36	NR	MEA2553947.1	2682144	g65073	i0	61.3	0.996428571428571	93	36	99.6	0	279	1	132	224	MEA2553947.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	279	134	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
32079347	32079347	PRJNA917598_P_NODE_81138_length_250_cov_0.870056_g80194_i0	PRJNA917598	81138	250	0.870056	2.17514	Capsulimonadales bacterium	2971800	Bacteria	Bacteria	90.5	7.82e-22	NR	MDX1931705.1	2971800	g80194	i0	70.9	0.66	55	16	66	0	82	246	15	69	MDX1931705.1 hypothetical protein [Capsulimonadales bacterium]	diamond	165	90.5	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales			Capsulimonadales 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);;