metadata: contig_metadata: 29 rows where bioproject = "PRJNA577226" and tax

29 rows where bioproject = "PRJNA577226" 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
2412556	2412556	PRJNA577226_S_NODE_19422_length_288_cov_7.027888_g18483_i0	PRJNA577226	19422	288	7.027888	20.24031744	Fimbriimonas	1005038	Bacteria	Bacteria	455	1.7400000000000003e-123	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g18483	i0	95.139	143.479166666667	288	14	100	0	1	288	28813	29100	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	41322	455	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4388874	4388874	PRJNA577226_S_NODE_21664_length_271_cov_8.064103_g20725_i0	PRJNA577226	21664	271	8.064103	21.853719130000002	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	278	3.77e-70	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g20725	i0	85.66	69.7158671586716	265	37	98	1	1	265	667697	667434	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	18893	278	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
5665066	5665066	PRJNA577226_S_NODE_21665_length_271_cov_6.837607_g20726_i0	PRJNA577226	21665	271	6.837607	18.52991497	Fimbriimonas sp.	1936159	Bacteria	Bacteria	326	1.33e-84	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g20726	i0	88.722	101.741697416974	266	30	98	0	5	270	1688897	1688632	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	27572	326	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
5666489	5666489	PRJNA577226_S_NODE_9605_length_426_cov_7.961440_g8669_i0	PRJNA577226	9605	426	7.96144	33.9157344	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	603	9.039999999999999e-168	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g8669	i0	92.254	232.600938967136	426	32	100	1	1	426	668973	668549	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	99088	603	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
6240669	6240669	PRJNA577226_S_NODE_15285_length_329_cov_7.465753_g14346_i0	PRJNA577226	15285	329	7.465753	24.56232737	Fimbriimonas	1005038	Bacteria	Bacteria	363	1.26e-95	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g14346	i0	86.707	159.702127659574	331	39	100	3	1	329	28212	27885	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	52542	363	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8214335	8214335	PRJNA577226_S_NODE_15967_length_321_cov_6.112676_g15028_i0	PRJNA577226	15967	321	6.1126760000000004	19.62168996	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	381	3.3799999999999996e-101	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g15028	i0	88.818	34.0591900311526	313	32	97	3	11	321	668662	668973	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	10933	381	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
8214946	8214946	PRJNA577226_S_NODE_36687_length_205_cov_2.547619_g35748_i0	PRJNA577226	36687	205	2.547619	5.22261895	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	207	3.61e-49	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g35748	i0	85.238	169.390243902439	210	22	98	6	5	205	893165	893374	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	34725	207	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
8790003	8790003	PRJNA577226_S_NODE_20687_length_278_cov_5.904564_g19748_i0	PRJNA577226	20687	278	5.904564	16.41468792	Chthonomonas	1077265	Bacteria	Bacteria	252	2.35e-62	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g19748	i0	85.714	475.60071942446	252	21	86	8	40	278	2830	2581	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	132217	252	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
9489445	9489445	PRJNA577226_S_NODE_10288_length_409_cov_5.618280_g9351_i0	PRJNA577226	10288	409	5.61828	22.9787652	Fimbriimonas sp.	1936159	Bacteria	Bacteria	584	3.13e-162	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g9351	i0	92.84	721.863080684597	405	26	99	3	1	403	1687970	1687567	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	295242	584	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
10765673	10765673	PRJNA577226_S_NODE_22229_length_267_cov_57.243478_g21290_i0	PRJNA577226	22229	267	57.243478	152.84008626	Capsulimonas corticalis	2219043	Bacteria	Bacteria	390	4.56e-104	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g21290	i0	92.937	155.565543071161	269	17	100	2	1	267	593555	593823	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	41536	390	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
10766305	10766305	PRJNA577226_S_NODE_4429_length_684_cov_7.349304_g3551_i0	PRJNA577226	4429	684	7.349304	50.26923936	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	933	0	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g3551	i0	91.279	399.191520467836	688	55	100	3	1	684	668973	668287	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	273047	933	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
12040175	12040175	PRJNA577226_S_NODE_10450_length_405_cov_5.934783_g9513_i0	PRJNA577226	10450	405	5.934783	24.03587115	Capsulimonas corticalis	2219043	Bacteria	Bacteria	501	3.21e-137	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g9513	i0	89.082	901.165432098765	403	44	99	0	1	403	593043	592641	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	364972	501	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
12040467	12040467	PRJNA577226_S_NODE_20410_length_280_cov_6.510288_g19471_i0	PRJNA577226	20410	280	6.510288	18.2288064	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	361	3.769999999999999e-95	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g19471	i0	90	143.778571428571	280	27	100	1	1	280	2201663	2201941	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	40258	361	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
12616351	12616351	PRJNA577226_S_NODE_36310_length_206_cov_13.112426_g35371_i0	PRJNA577226	36310	206	13.112426	27.01159756	Chthonomonas	1077265	Bacteria	Bacteria	276	9.82e-70	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g35371	i0	90.821	136.893203883495	207	18	100	1	1	206	1018	812	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	28200	276	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
13316786	13316786	PRJNA577226_S_NODE_8191_length_468_cov_5.960557_g7258_i0	PRJNA577226	8191	468	5.960557	27.89540676	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	553	1.0199999999999995e-152	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g7258	i0	88.06	145.299145299145	469	53	100	3	1	468	668373	668839	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	68000	553	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
14590550	14590550	PRJNA577226_S_NODE_33172_length_216_cov_2.391061_g32233_i0	PRJNA577226	33172	216	2.391061	5.16469176	Capsulimonas corticalis	2219043	Bacteria	Bacteria	366	5.99e-97	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g32233	i0	97.222	439.791666666667	216	6	100	0	1	216	594642	594857	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	94995	366	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
15165278	15165278	PRJNA577226_S_NODE_22232_length_267_cov_11.678261_g21293_i0	PRJNA577226	22232	267	11.678261	31.18095687	Fimbriimonas	1005038	Bacteria	Bacteria	270	6.2e-68	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g21293	i0	85.385	100.52808988764	260	38	97	0	4	263	29491	29750	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	26841	270	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15864216	15864216	PRJNA577226_S_NODE_26233_length_244_cov_5.903382_g25294_i0	PRJNA577226	26233	244	5.903382	14.40425208	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	224	4.4099999999999997e-54	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g25294	i0	84.167	323.41393442623	240	29	96	7	1	235	1876996	1876761	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	78913	224	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
16439855	16439855	PRJNA577226_S_NODE_23873_length_257_cov_6.995455_g22934_i0	PRJNA577226	23873	257	6.995455	17.97831935	Chthonomonas	1077265	Bacteria	Bacteria	370	5.68e-98	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g22934	i0	92.664	198.494163424125	259	16	100	3	1	257	2838	2581	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	51013	370	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
16439872	16439872	PRJNA577226_S_NODE_25093_length_250_cov_5.098592_g24154_i0	PRJNA577226	25093	250	5.098592	12.74648	Chthonomonas	1077265	Bacteria	Bacteria	291	4.41e-74	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g24154	i0	87.747	167.616	253	25	99	5	1	248	291	40	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	41904	291	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
17140106	17140106	PRJNA577226_S_NODE_6154_length_554_cov_9.100580_g5232_i0	PRJNA577226	6154	554	9.10058	50.4172132	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	750	0	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g5232	i0	91.155	216.351985559567	554	48	100	1	1	554	668287	668839	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	119859	750	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
17140199	17140199	PRJNA577226_S_NODE_64994_length_156_cov_3.899160_g64055_i0	PRJNA577226	64994	156	3.89916	6.0826896	Capsulimonas corticalis	2219043	Bacteria	Bacteria	257	2.54e-64	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g64055	i0	98.621	869.641025641026	145	2	93	0	1	145	593525	593381	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	135664	257	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
17140387	17140387	PRJNA577226_S_NODE_7574_length_489_cov_7.732301_g6643_i0	PRJNA577226	7574	489	7.732301	37.81095189	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	606	8.119999999999997e-169	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g6643	i0	89.024	599.795501022495	492	50	100	3	1	489	895504	895014	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	293300	606	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
18413154	18413154	PRJNA577226_S_NODE_15495_length_326_cov_58.107266_g14556_i0	PRJNA577226	15495	326	58.107266	189.42968716	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	460	4.2999999999999997e-125	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g14556	i0	94.059	190.782208588957	303	18	93	0	1	303	1877419	1877117	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	62195	460	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
18414231	18414231	PRJNA577226_S_NODE_5435_length_598_cov_4.668449_g4527_i0	PRJNA577226	5435	598	4.668449	27.91732502	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	736	0	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g4527	i0	88.889	108.88127090301	603	60	100	5	1	598	668973	668373	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	65111	736	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
19688914	19688914	PRJNA577226_S_NODE_62056_length_160_cov_0.983740_g61117_i0	PRJNA577226	62056	160	0.98374	1.573984	Fimbriimonas sp.	1936159	Bacteria	Bacteria	82.4	1.69e-11	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g61117	i0	97.872	22.575	47	1	29	0	1	47	2549740	2549786	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	3612	82.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
20963390	20963390	PRJNA577226_S_NODE_15357_length_328_cov_4.309278_g14418_i0	PRJNA577226	15357	328	4.309278	14.13443184	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	377	4.48e-100	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g14418	i0	90.78	39.2073170731707	282	26	86	0	47	328	668692	668973	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	12860	377	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
22239718	22239718	PRJNA577226_S_NODE_67958_length_154_cov_0.965812_g67019_i0	PRJNA577226	67958	154	0.965812	1.48735048	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	130	5.68e-26	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g67019	i0	84.848	0.857142857142857	132	16	84	4	1	130	1625527	1625656	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	132	130	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23513413	23513413	PRJNA577226_S_NODE_10039_length_415_cov_15.552910_g9103_i0	PRJNA577226	10039	415	15.55291	64.5445765	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	625	1.8699999999999995e-174	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g9103	i0	93.765	231.028915662651	417	24	100	1	1	415	1879097	1878681	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	95877	625	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae 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);;