metadata: contig_metadata: 34 rows where bioproject = "PRJNA493244" and tax

34 rows where bioproject = "PRJNA493244" 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
5558850	5558850	PRJNA493244_P_NODE_1285005_length_301_cov_2.825000_g1261881_i0	PRJNA493244	1285005	301	2.825	8.50325	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	313	1.16e-80	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g1261881	i0	87.097	2.54485049833887	279	33	92	1	1	276	531031	531309	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	766	313	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
5560103	5560103	PRJNA493244_P_NODE_1749265_length_181_cov_4.033333_g1726140_i0	PRJNA493244	1749265	181	4.033333	7.30033273	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	169	1.4599999999999998e-37	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g1726140	i0	86.928	32.171270718232	153	16	83	4	1	151	667553	667403	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	5823	169	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
9384015	9384015	PRJNA493244_P_NODE_1603748_length_219_cov_16.088608_g1580623_i0	PRJNA493244	1603748	219	16.088608	35.23405152	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	183	6.59e-42	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g1580623	i0	84.021	308.867579908676	194	27	87	3	1	190	667594	667401	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	67642	183	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
10028305	10028305	PRJNA493244_P_NODE_1745728_length_188_cov_2.354331_g1722603_i0	PRJNA493244	1745728	188	2.354331	4.42614228	Fimbriimonas	1005038	Bacteria	Bacteria	209	9.03e-50	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1722603	i0	89.222	20.9627659574468	167	18	89	0	22	188	27630	27464	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	3941	209	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17033044	17033044	PRJNA493244_P_NODE_1462994_length_252_cov_1.287958_g1439869_i0	PRJNA493244	1462994	252	1.287958	3.24565416	Armatimonadota bacterium	2033014	Bacteria	Bacteria	148	3.42e-41	NR	MDQ3815591.1	2033014	g1439869	i0	81.9	1.97619047619048	83	15	98.8	0	250	2	60	142	MDQ3815591.1 membrane-bound O-acyltransferase family protein [Armatimonadota bacterium]	diamond	498	148	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
19582023	19582023	PRJNA493244_P_NODE_1633856_length_213_cov_2.105263_g1610731_i0	PRJNA493244	1633856	213	2.105263	4.48421019	Capsulimonas corticalis	2219043	Bacteria	Bacteria	93.5	1.1e-14	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g1610731	i0	82.243	2.51173708920188	107	19	50	0	30	136	595557	595451	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	535	93.5	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
21501734	21501734	PRJNA493244_P_NODE_1536037_length_234_cov_53.606936_g1512912_i0	PRJNA493244	1536037	234	53.606936	125.44023024	Fimbriimonas	1005038	Bacteria	Bacteria	281	2.46e-71	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1512912	i0	90.61	63.4102564102564	213	18	91	2	1	212	29575	29786	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	14838	281	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
22132127	22132127	PRJNA493244_P_NODE_1429318_length_260_cov_3.155779_g1406193_i0	PRJNA493244	1429318	260	3.155779	8.2050254	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	161	3.97e-44	NR	MCX7688281.1	2682145	g1406193	i0	100	0.992307692307692	86	0	99.2	0	259	2	595	680	MCX7688281.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Fimbriimonadales bacterium]	diamond	258	161	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
23408056	23408056	PRJNA493244_P_NODE_1501659_length_242_cov_2.928177_g1478534_i0	PRJNA493244	1501659	242	2.928177	7.08618834	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	122	1.6399999999999998e-23	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1478534	i0	87.619	4.85537190082645	105	13	43	0	1	105	5174333	5174437	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	1175	122	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23408297	23408297	PRJNA493244_P_NODE_1585359_length_223_cov_22.993827_g1562234_i0	PRJNA493244	1585359	223	22.993827	51.27623421	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	196	8.64e-46	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g1562234	i0	85.946	2.56502242152466	185	25	83	1	40	223	667410	667594	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	572	196	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
24052161	24052161	PRJNA493244_P_NODE_992599_length_410_cov_2.716332_g969519_i0	PRJNA493244	992599	410	2.716332	11.1369612	Fimbriimonas	1005038	Bacteria	Bacteria	457	7.14e-124	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g969519	i0	86.925	132.221951219512	413	47	100	6	1	410	28020	28428	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	54211	457	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25326074	25326074	PRJNA493244_P_NODE_1518580_length_238_cov_231.644068_g1495455_i0	PRJNA493244	1518580	238	231.644068	551.31288184	Fimbriimonas	1005038	Bacteria	Bacteria	215	2.58e-51	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1495455	i0	85.446	37.218487394958	213	23	88	8	3	211	29573	29781	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	8858	215	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26680803	26680803	PRJNA493244_P_NODE_1502221_length_242_cov_2.121547_g1479096_i0	PRJNA493244	1502221	242	2.121547	5.13414374	Bacteria	2	Bacteria	Bacteria	129	1.9399999999999993e-34	NR	HLK15113.1	2682144	g1479096	i0	78.5	2.96280991735537	79	17	97.9	0	2	238	82	160	HLK15113.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	717	130	0.992307692307692	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27313853	27313853	PRJNA493244_P_NODE_1599583_length_220_cov_3.402516_g1576458_i0	PRJNA493244	1599583	220	3.402516	7.4855352	Bacteria	2	Bacteria	Bacteria	60.8	1.12e-8	NR	OWU65972.1	1987502	g1576458	i0	68.4	1.41818181818182	38	12	51.8	0	104	217	2	39	OWU65972.1 MAG: hypothetical protein CBB60_001950 [Armatimonadetes bacterium Cent15-Ar3]	diamond	312	61.2	0.993464052287582	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Cent15-Ar3
27361144	27361144	PRJNA493244_P_NODE_1704963_length_203_cov_1.352113_g1681838_i0	PRJNA493244	1704963	203	1.352113	2.74478939	Fimbriimonas sp.	1936159	Bacteria	Bacteria	99.4	7.949999999999999e-23	NR	HWD41339.1	1936159	g1681838	i0	71.6	0.990147783251232	67	18	97.5	1	203	6	210	276	HWD41339.1 Gfo/Idh/MocA family oxidoreductase [Fimbriimonas sp.]	diamond	201	99.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
27645314	27645314	PRJNA493244_P_NODE_1177924_length_336_cov_5.970909_g1154800_i0	PRJNA493244	1177924	336	5.970909	20.06225424	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	132	6.23e-35	NR	MBC8064666.1	2682144	g1154800	i0	68.8	0.830357142857143	93	27	81.3	1	61	333	26	118	MBC8064666.1 metallophosphoesterase [Fimbriimonadaceae bacterium]	diamond	279	132	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27676964	27676964	PRJNA493244_P_NODE_1443384_length_257_cov_1.306122_g1420259_i0	PRJNA493244	1443384	257	1.306122	3.35673354	Armatimonadota bacterium	2033014	Bacteria	Bacteria	103	1.35e-24	NR	RMH08921.1	2033014	g1420259	i0	56	0.980544747081712	84	37	98.1	0	254	3	164	247	RMH08921.1 MAG: hypothetical protein D6697_04910 [Armatimonadota bacterium]	diamond	252	103	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28055460	28055460	PRJNA493244_P_NODE_1700525_length_204_cov_0.895105_g1677400_i0	PRJNA493244	1700525	204	0.895105	1.8260142	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	132	4.159999999999999e-37	NR	GIV03840.1	2682145	g1677400	i0	92.5	0.985294117647059	67	5	98.5	0	202	2	84	150	GIV03840.1 MAG: hypothetical protein KatS3mg015_2670 [Fimbriimonadales bacterium]	diamond	201	132	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
28197680	28197680	PRJNA493244_P_NODE_1248946_length_313_cov_1.015873_g1225822_i0	PRJNA493244	1248946	313	1.015873	3.17968249	Bacteria	2	Bacteria	Bacteria	113	1.7000000000000003e-28	NR	MCX6380722.1	2033014	g1225822	i0	49.5	3.71884984025559	97	49	93	0	23	313	40	136	MCX6380722.1 ABC transporter ATP-binding protein [Armatimonadota bacterium]	diamond	1164	114	0.991228070175439	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28308265	28308265	PRJNA493244_P_NODE_1201326_length_328_cov_3.438202_g1178202_i0	PRJNA493244	1201326	328	3.438202	11.27730256	Armatimonadota bacterium	2033014	Bacteria	Bacteria	43.9	0.04	NR	MCH7903491.1	2033014	g1178202	i0	30.1	0.759146341463415	83	55	75.9	2	5	253	614	693	MCH7903491.1 DEAD/DEAH box helicase family protein [Armatimonadota bacterium]	diamond	249	43.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28750195	28750195	PRJNA493244_P_NODE_1185487_length_334_cov_1.611722_g1162363_i0	PRJNA493244	1185487	334	1.611722	5.38315148	Armatimonadota bacterium	2033014	Bacteria	Bacteria	141	2.6999999999999995e-38	NR	MFN3650818.1	2033014	g1162363	i0	66.7	1.72455089820359	96	32	86.2	0	332	45	53	148	MFN3650818.1 glycosyltransferase [Armatimonadota bacterium]	diamond	576	141	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29160945	29160945	PRJNA493244_P_NODE_274089_length_1024_cov_11.682243_g259546_i0	PRJNA493244	274089	1024	11.682243	119.62616832	Chthonomonas sp.	2282153	Bacteria	Bacteria	119	6.0499999999999996e-28	NR	GMV89371.1	2282153	g259546	i0	65.9	0.240234375	82	28	24	0	25	270	130	211	GMV89371.1 MAG: hypothetical protein AMXMBFR81_23020 [Chthonomonas sp.]	diamond	246	119	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas sp.
29224081	29224081	PRJNA493244_P_NODE_1665389_length_208_cov_0.870748_g1642264_i0	PRJNA493244	1665389	208	0.870748	1.81115584	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	49.3	7.48e-5	NR	HLV80937.1	2739509	g1642264	i0	59.5	0.605769230769231	42	17	60.6	0	204	79	84	125	HLV80937.1 flavodoxin domain-containing protein [Chthonomonadaceae bacterium]	diamond	126	49.3	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
29224083	29224083	PRJNA493244_P_NODE_1671009_length_207_cov_1.609589_g1647884_i0	PRJNA493244	1671009	207	1.609589	3.33184923	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	121	2.78e-34	NR	GIV03795.1	2682145	g1647884	i0	85.3	0.985507246376812	68	10	98.6	0	205	2	8	75	GIV03795.1 MAG: hypothetical protein KatS3mg015_2625 [Fimbriimonadales bacterium]	diamond	204	121	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
29334505	29334505	PRJNA493244_P_NODE_1597969_length_221_cov_1.262500_g1574844_i0	PRJNA493244	1597969	221	1.2625	2.790125	PVC group	1783257	Bacteria	Bacteria	108	3.5100000000000004e-26	NR	MCC2669118.1	2033014	g1574844	i0	69.4	2.94570135746606	72	22	97.7	0	218	3	151	222	MCC2669118.1 recombination protein RecF [Armatimonadota bacterium]	diamond	651	108	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29855393	29855393	PRJNA493244_P_NODE_1683151_length_206_cov_0.882759_g1660026_i0	PRJNA493244	1683151	206	0.882759	1.81848354	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	57	2.07e-7	NR	MDX2066615.1	2682144	g1660026	i0	52	0.728155339805825	50	24	72.8	0	30	179	250	299	MDX2066615.1 GntR family transcriptional regulator [Fimbriimonadaceae bacterium]	diamond	150	57	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
30329754	30329754	PRJNA493244_P_NODE_1715592_length_202_cov_0.907801_g1692467_i0	PRJNA493244	1715592	202	0.907801	1.83375802	Armatimonadota bacterium	2033014	Bacteria	Bacteria	41.2	0.0397	NR	MBS1711251.1	2033014	g1692467	i0	50	0.564356435643564	38	19	56.4	0	2	115	100	137	MBS1711251.1 very short patch repair endonuclease [Armatimonadota bacterium]	diamond	114	41.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30456014	30456014	PRJNA493244_P_NODE_196913_length_1190_cov_5.502214_g185301_i0	PRJNA493244	196913	1190	5.502214	65.4763466	Armatimonadota bacterium	2033014	Bacteria	Bacteria	461	4.719999999999998e-158	NR	MCL6533977.1	2033014	g185301	i0	95.7	0.579831932773109	230	10	58	0	1166	477	1	230	MCL6533977.1 glycosyltransferase family 4 protein [Armatimonadota bacterium]	diamond	690	461	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30771732	30771732	PRJNA493244_P_NODE_1607614_length_219_cov_1.215190_g1584489_i0	PRJNA493244	1607614	219	1.21519	2.6612661	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	110	1.03e-27	NR	MFI5385774.1	2682145	g1584489	i0	65.3	0.986301369863014	72	25	98.6	0	218	3	130	201	MFI5385774.1 hypothetical protein [Fimbriimonadales bacterium]	diamond	216	110	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
31530393	31530393	PRJNA493244_P_NODE_1468096_length_250_cov_4.619048_g1444971_i0	PRJNA493244	1468096	250	4.619048	11.54762	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	42.7	0.0395	NR	MBX7135943.1	2682144	g1444971	i0	30.6	0.864	72	49	85.2	1	246	34	153	224	MBX7135943.1 right-handed parallel beta-helix repeat-containing protein [Fimbriimonadaceae bacterium]	diamond	216	42.7	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
31941252	31941252	PRJNA493244_P_NODE_1715257_length_202_cov_0.907801_g1692132_i0	PRJNA493244	1715257	202	0.907801	1.83375802	Capsulimonadaceae bacterium	2953755	Bacteria	Bacteria	97.1	1.47e-21	NR	HEY3330051.1	2953755	g1692132	i0	67.2	0.905940594059406	61	20	90.6	0	185	3	15	75	HEY3330051.1 SpoIIE family protein phosphatase [Capsulimonadaceae bacterium]	diamond	183	97.1	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae		Capsulimonadaceae bacterium
31973040	31973040	PRJNA493244_P_NODE_895738_length_456_cov_1.620253_g872785_i0	PRJNA493244	895738	456	1.620253	7.38835368	Armatimonadota bacterium	2033014	Bacteria	Bacteria	114	1.74e-26	NR	MDI6828761.1	2033014	g872785	i0	54	0.657894736842105	100	45	65.1	1	83	379	388	487	MDI6828761.1 hypothetical protein [Armatimonadota bacterium]	diamond	300	114	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32384405	32384405	PRJNA493244_P_NODE_497939_length_731_cov_1.940299_g477833_i0	PRJNA493244	497939	731	1.940299	14.18358569	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	243	3.36e-72	NR	WP_025226175.1	1005039	g477833	i0	71.2	1.33789329685363	163	47	66.9	0	727	239	518	680	WP_025226175.1 ATP-dependent DNA helicase [Fimbriimonas ginsengisoli]	diamond	978	243	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
32479523	32479523	PRJNA493244_P_NODE_1572899_length_226_cov_1.945455_g1549774_i0	PRJNA493244	1572899	226	1.945455	4.3967283	Armatimonadota bacterium	2033014	Bacteria	Bacteria	77.4	1.85e-14	NR	MBN9502973.1	2033014	g1549774	i0	50	0.982300884955752	74	37	98.2	0	223	2	318	391	MBN9502973.1 hypothetical protein [Armatimonadota bacterium]	diamond	222	77.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);;