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

29 rows where bioproject = "PRJNA493827" 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
3656268	3656268	PRJNA493827_P_NODE_176303_length_257_cov_1.500000_g174105_i0	PRJNA493827	176303	257	1.5	3.855	Bacillati	1783272	Bacteria	Bacteria	108	4.92e-19	NTclustered	gi\|510021827\|emb\|HF951689.1\|	1303518	g174105	i0	96.875	2.75875486381323	64	2	25	0	17	80	2136211	2136148	Chthonomonas calidirosea T49 complete genome	blastn	709	108	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
4298416	4298416	PRJNA493827_P_NODE_197524_length_248_cov_1.462857_g195326_i0	PRJNA493827	197524	248	1.462857	3.62788536	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	167	7.679999999999999e-37	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g195326	i0	82	0.806451612903226	200	32	80	4	1	198	850202	850399	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	200	167	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4934458	4934458	PRJNA493827_P_NODE_92224_length_357_cov_1.686620_g90026_i0	PRJNA493827	92224	357	1.68662	6.0212334	Fimbriimonas	1005038	Bacteria	Bacteria	512	1.29e-140	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g90026	i0	92.918	844.717086834734	353	24	99	1	1	352	27189	26837	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	301564	512	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
6848339	6848339	PRJNA493827_P_NODE_157986_length_272_cov_3.226131_g155788_i0	PRJNA493827	157986	272	3.226131	8.77507632	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	381	2.8e-101	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g155788	i0	91.912	129.176470588235	272	22	100	0	1	272	1879639	1879368	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	35136	381	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
7482816	7482816	PRJNA493827_P_NODE_132626_length_296_cov_22.008969_g130428_i0	PRJNA493827	132626	296	22.008969	65.14654824	Armatimonadota	67819	Bacteria	Bacteria	339	1.88e-88	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g130428	i0	88.612	192.003378378378	281	28	94	4	2	280	37100	37378	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	56833	339	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
8123439	8123439	PRJNA493827_P_NODE_140807_length_288_cov_1.251163_g138609_i0	PRJNA493827	140807	288	1.251163	3.60334944	Armatimonadota bacterium	2033014	Bacteria	Bacteria	141	3.06e-39	NR	MCX6380811.1	2033014	g138609	i0	80.9	1.85416666666667	89	17	92.7	0	276	10	11	99	MCX6380811.1 SDR family NAD(P)-dependent oxidoreductase [Armatimonadota bacterium]	diamond	534	141	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
8757941	8757941	PRJNA493827_P_NODE_158027_length_272_cov_2.703518_g155829_i0	PRJNA493827	158027	272	2.703518	7.35356896	Fimbriimonas	1005038	Bacteria	Bacteria	346	1.02e-90	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g155829	i0	89.781	253.121323529412	274	23	100	5	1	272	27864	28134	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	68849	348	0.994252873563218	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
10033645	10033645	PRJNA493827_P_NODE_183308_length_251_cov_1.764045_g181110_i0	PRJNA493827	183308	251	1.764045	4.42775295	Chthonomonas	1077265	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g181110	i0	87.352	2.68525896414343	253	28	100	4	1	251	1226	1476	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	674	287	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
15772766	15772766	PRJNA493827_P_NODE_129933_length_300_cov_1.237885_g127735_i0	PRJNA493827	129933	300	1.237885	3.713655	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	185	2.6399999999999998e-42	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g127735	i0	79.11	11.4233333333333	292	43	93	9	22	300	2045300	2045014	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	3427	185	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15774191	15774191	PRJNA493827_P_NODE_196573_length_249_cov_0.875000_g194375_i0	PRJNA493827	196573	249	0.875	2.17875	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	172	1.66e-38	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g194375	i0	80	0.983935742971888	245	40	97	6	1	242	4652556	4652318	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	245	172	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
19597013	19597013	PRJNA493827_P_NODE_174776_length_258_cov_1.735135_g172578_i0	PRJNA493827	174776	258	1.735135	4.4766483	Fimbriimonas sp.	1936159	Bacteria	Bacteria	346	9.619999999999999e-91	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g172578	i0	91.016	566.313953488372	256	23	99	0	3	258	1688257	1688002	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	146109	346	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
26664969	26664969	PRJNA493827_P_NODE_145721_length_283_cov_2.133333_g143523_i0	PRJNA493827	145721	283	2.133333	6.03733239	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	133	7.16e-34	NR	MCW5942200.1	2682144	g143523	i0	60.2	0.985865724381625	93	37	98.6	0	3	281	380	472	MCW5942200.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	279	133	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
26887183	26887183	PRJNA493827_P_NODE_217501_length_244_cov_0.900585_g215303_i0	PRJNA493827	217501	244	0.900585	2.1974274	Armatimonadota bacterium	2033014	Bacteria	Bacteria	85.1	1.12e-17	NR	MBS1722435.1	2033014	g215303	i0	57.7	0.959016393442623	78	29	95.9	2	11	244	3	76	MBS1722435.1 hypothetical protein [Armatimonadota bacterium]	diamond	234	85.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27424687	27424687	PRJNA493827_P_NODE_200943_length_248_cov_0.880000_g198745_i0	PRJNA493827	200943	248	0.88	2.1824	Armatimonadota bacterium	2033014	Bacteria	Bacteria	78.6	5.33e-15	NR	NLC57698.1	2033014	g198745	i0	63.8	0.701612903225806	58	21	70.2	0	247	74	268	325	NLC57698.1 glycosyltransferase family 2 protein [Armatimonadota bacterium]	diamond	174	78.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27913565	27913565	PRJNA493827_P_NODE_210505_length_246_cov_0.890173_g208307_i0	PRJNA493827	210505	246	0.890173	2.18982558	Fimbriimonas	1005038	Bacteria	Bacteria	125	9.08e-33	NR	HWD39983.1	1936159	g208307	i0	75	1.95121951219512	80	20	97.6	0	3	242	12	91	HWD39983.1 tRNA-dihydrouridine synthase family protein [Fimbriimonas sp.]	diamond	480	125	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
27929722	27929722	PRJNA493827_P_NODE_62445_length_444_cov_1.253369_g60248_i0	PRJNA493827	62445	444	1.253369	5.56495836	Armatimonadota bacterium	2033014	Bacteria	Bacteria	109	1.14e-25	NR	MFB3880004.1	2033014	g60248	i0	48.3	0.783783783783784	116	60	78.4	0	55	402	207	322	MFB3880004.1 ribose-phosphate diphosphokinase [Armatimonadota bacterium]	diamond	348	109	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28181916	28181916	PRJNA493827_P_NODE_112586_length_322_cov_1.690763_g110388_i0	PRJNA493827	112586	322	1.690763	5.44425686	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	49.3	4.48e-4	NR	MCG9895440.1	2682144	g110388	i0	40.3	2.37577639751553	67	40	62.4	0	282	82	3	69	MCG9895440.1 carboxypeptidase-like regulatory domain-containing protein [Fimbriimonadaceae bacterium]	diamond	765	49.3	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
28213608	28213608	PRJNA493827_P_NODE_95386_length_351_cov_1.543165_g93188_i0	PRJNA493827	95386	351	1.543165	5.41650915	Fimbriimonas sp.	1936159	Bacteria	Bacteria	144	6.42e-38	NR	MDR3692382.1	1936159	g93188	i0	61.2	3.58974358974359	103	39	87.2	1	314	9	379	481	MDR3692382.1 MmgE/PrpD family protein [Fimbriimonas sp.]	diamond	1260	144	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
28340078	28340078	PRJNA493827_P_NODE_191346_length_250_cov_0.870056_g189148_i0	PRJNA493827	191346	250	0.870056	2.17514	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	94.4	1.02e-21	NR	WP_025229581.1	1005039	g189148	i0	55.4	0.996	83	37	99.6	0	1	249	118	200	WP_025229581.1 hypothetical protein [Fimbriimonas ginsengisoli]	diamond	249	94.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
28703162	28703162	PRJNA493827_P_NODE_195887_length_249_cov_0.875000_g193689_i0	PRJNA493827	195887	249	0.875	2.17875	Armatimonadota	67819	Bacteria	Bacteria	103	3.92e-26	NR	HXG25024.1	2282151	g193689	i0	78.7	2.21686746987952	61	13	73.5	0	248	66	70	130	HXG25024.1 hypothetical protein [Chthonomonadales bacterium]	diamond	552	103	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
28940132	28940132	PRJNA493827_P_NODE_147188_length_282_cov_1.464115_g144990_i0	PRJNA493827	147188	282	1.464115	4.1288043	Fimbriimonas sp.	1936159	Bacteria	Bacteria	52.8	1.52e-5	NR	HSI71605.1	1936159	g144990	i0	43.1	1.84042553191489	65	30	67	3	76	264	1	60	HSI71605.1 hypothetical protein [Fimbriimonas sp.]	diamond	519	52.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
29239879	29239879	PRJNA493827_P_NODE_184549_length_251_cov_0.865169_g182351_i0	PRJNA493827	184549	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	89.7	2.47e-20	NR	MBV9849364.1	2033014	g182351	i0	84	2.06772908366534	50	8	59.8	0	150	1	2	51	MBV9849364.1 peptide-methionine (S)-S-oxide reductase MsrA [Armatimonadota bacterium]	diamond	519	89.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30440184	30440184	PRJNA493827_P_NODE_197313_length_248_cov_1.708571_g195115_i0	PRJNA493827	197313	248	1.708571	4.23725608	PVC group	1783257	Bacteria	Bacteria	77	2.37e-14	NR	WP_348220638.1	2494211	g195115	i0	63.5	3.54435483870968	52	19	62.9	0	3	158	306	357	WP_348220638.1 WGR domain-containing protein [Capsulimonas sp.]	diamond	879	77.4	0.994832041343669	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas sp.
31451461	31451461	PRJNA493827_P_NODE_227316_length_242_cov_0.911243_g225118_i0	PRJNA493827	227316	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	50.1	2.43e-5	NR	OFX27234.1	1797288	g225118	i0	56.8	1.1900826446281	44	17	54.5	1	139	8	8	49	OFX27234.1 MAG: hypothetical protein A2Z07_04565 [Armatimonadetes bacterium RBG_16_67_12]	diamond	288	50.4	0.994047619047619	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium RBG_16_67_12
32194946	32194946	PRJNA493827_P_NODE_234498_length_241_cov_0.916667_g232300_i0	PRJNA493827	234498	241	0.916667	2.20916747	Armatimonadota bacterium	2033014	Bacteria	Bacteria	55.5	8.09e-7	NR	MBC8136374.1	2033014	g232300	i0	57.1	1.34439834024896	56	24	69.7	0	176	9	153	208	MBC8136374.1 hypothetical protein [Armatimonadota bacterium]	diamond	324	55.5	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32258536	32258536	PRJNA493827_P_NODE_229838_length_242_cov_0.911243_g227640_i0	PRJNA493827	229838	242	0.911243	2.20520806	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	84.3	8.25e-17	NR	MEA2552625.1	2682144	g227640	i0	46.1	0.942148760330578	76	41	94.2	0	1	228	586	661	MEA2552625.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	228	84.3	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
32574753	32574753	PRJNA493827_P_NODE_120079_length_312_cov_1.054393_g117881_i0	PRJNA493827	120079	312	1.054393	3.28970616	Armatimonas sp.	1872638	Bacteria	Bacteria	42	0.0429	NR	WP_395090479.1	1872638	g117881	i0	36.8	0.548076923076923	57	34	53.8	2	251	84	5	60	WP_395090479.1 hypothetical protein [Armatimonas sp.]	diamond	171	42	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
32826442	32826442	PRJNA493827_P_NODE_136160_length_293_cov_0.831818_g133962_i0	PRJNA493827	136160	293	0.831818	2.43722674	Armatimonadota bacterium	2033014	Bacteria	Bacteria	189	8.89e-59	NR	MCC7439900.1	2033014	g133962	i0	99	0.982935153583618	96	1	98.3	0	1	288	35	130	MCC7439900.1 50S ribosomal protein L4 [Armatimonadota bacterium]	diamond	288	189	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32857878	32857878	PRJNA493827_P_NODE_187260_length_251_cov_0.865169_g185062_i0	PRJNA493827	187260	251	0.865169	2.17157419	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	82	5.97e-16	NR	WP_025227541.1	1005039	g185062	i0	87.8	0.49003984063745	41	5	49	0	6	128	516	556	WP_025227541.1 hypothetical protein [Fimbriimonas ginsengisoli]	diamond	123	82	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli

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);;