metadata: contig_metadata: 29 rows where bioproject = "PRJNA703759", tax_kingdom = "Bacillati" and tax

29 rows where bioproject = "PRJNA703759", 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
10113465	10113465	PRJNA703759_P_NODE_24948_length_285_cov_1.471698_g24472_i0	PRJNA703759	24948	285	1.471698	4.1943393	Armatimonadota bacterium	2033014	Bacteria	Bacteria	75.9	1.39e-13	NR	MBI3910466.1	2033014	g24472	i0	45.8	3.02105263157895	96	49	97.9	2	6	284	852	947	MBI3910466.1 fibronectin type III domain-containing protein [Armatimonadota bacterium]	diamond	861	75.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
19036704	19036704	PRJNA703759_P_NODE_33435_length_255_cov_2.142857_g32959_i0	PRJNA703759	33435	255	2.142857	5.46428535	Fimbriimonas sp.	1936159	Bacteria	Bacteria	136	2.31e-35	NR	HLO98517.1	1936159	g32959	i0	83.3	0.988235294117647	84	14	98.8	0	3	254	216	299	HLO98517.1 DNA-directed RNA polymerase subunit beta [Fimbriimonas sp.]	diamond	252	136	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
27272458	27272458	PRJNA703759_P_NODE_34563_length_253_cov_0.866667_g34087_i0	PRJNA703759	34563	253	0.866667	2.19266751	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	148	4.36e-40	NR	WP_025227103.1	1005039	g34087	i0	80.2	0.960474308300395	81	16	96	0	244	2	1	81	WP_025227103.1 PIG-L family deacetylase [Fimbriimonas ginsengisoli]	diamond	243	148	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
27777916	27777916	PRJNA703759_P_NODE_42924_length_247_cov_0.896552_g42448_i0	PRJNA703759	42924	247	0.896552	2.21448344	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	94	1.7100000000000003e-21	NR	HLK55163.1	2739509	g42448	i0	51.9	1.91902834008097	79	38	96	0	1	237	125	203	HLK55163.1 hypothetical protein [Chthonomonadaceae bacterium]	diamond	474	94	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
27935712	27935712	PRJNA703759_P_NODE_39005_length_250_cov_0.881356_g38529_i0	PRJNA703759	39005	250	0.881356	2.20339	Armatimonadota bacterium	2033014	Bacteria	Bacteria	146	2.39e-40	NR	GDX40257.1	2033014	g38529	i0	94	0.996	83	5	99.6	0	1	249	276	358	GDX40257.1 thiamin pyrophosphokinase [Armatimonadota bacterium]	diamond	249	146	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28030425	28030425	PRJNA703759_P_NODE_51305_length_242_cov_0.923077_g50829_i0	PRJNA703759	51305	242	0.923077	2.23384634	Capsulimonadales bacterium	2971800	Bacteria	Bacteria	95.5	9.87e-21	NR	MDX1931437.1	2971800	g50829	i0	57.7	0.966942148760331	78	33	96.7	0	242	9	299	376	MDX1931437.1 SpoIIE family protein phosphatase [Capsulimonadales bacterium]	diamond	234	95.5	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales			Capsulimonadales bacterium
28199153	28199153	PRJNA703759_P_NODE_42906_length_247_cov_0.896552_g42430_i0	PRJNA703759	42906	247	0.896552	2.21448344	Bacteria	2	Bacteria	Bacteria	54.7	2.6e-7	NR	MCC6729963.1	2282151	g42430	i0	53.7	3.27935222672065	54	25	65.6	0	236	75	57	110	MCC6729963.1 hypothetical protein [Chthonomonadales bacterium]	diamond	810	54.7	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
28282744	28282744	PRJNA703759_P_NODE_49006_length_243_cov_0.917647_g48530_i0	PRJNA703759	49006	243	0.917647	2.22988221	Armatimonadota bacterium	2033014	Bacteria	Bacteria	60.5	2.07e-8	NR	MBS1721456.1	2033014	g48530	i0	90.9	0.407407407407407	33	3	40.7	0	2	100	657	689	MBS1721456.1 elongation factor G [Armatimonadota bacterium]	diamond	99	60.5	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28409285	28409285	PRJNA703759_P_NODE_50606_length_242_cov_0.923077_g50130_i0	PRJNA703759	50606	242	0.923077	2.23384634	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	132	9.67e-35	NR	WP_025226340.1	1005039	g50130	i0	76.9	0.966942148760331	78	18	96.7	0	240	7	201	278	WP_025226340.1 PhoPQ-activated protein PqaA family protein [Fimbriimonas ginsengisoli]	diamond	234	132	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
28598848	28598848	PRJNA703759_P_NODE_40467_length_249_cov_0.886364_g39991_i0	PRJNA703759	40467	249	0.886364	2.20704636	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	153	4.45e-41	NR	MFN8219191.1	2682145	g39991	i0	84.3	2	83	13	100	0	1	249	128	210	MFN8219191.1 phosphoribosylformylglycinamidine synthase subunit PurL [Fimbriimonadales bacterium]	diamond	498	153	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
29261559	29261559	PRJNA703759_P_NODE_48909_length_243_cov_0.917647_g48433_i0	PRJNA703759	48909	243	0.917647	2.22988221	Armatimonadota bacterium	2033014	Bacteria	Bacteria	80.1	3.59e-16	NR	MCX6380339.1	2033014	g48433	i0	54.3	0.864197530864197	70	32	86.4	0	236	27	159	228	MCX6380339.1 DUF6062 family protein [Armatimonadota bacterium]	diamond	210	80.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29261563	29261563	PRJNA703759_P_NODE_7789_length_494_cov_1.439430_g7313_i0	PRJNA703759	7789	494	1.43943	7.1107842	Fimbriimonas sp.	1936159	Bacteria	Bacteria	45.4	0.0473	NR	HWD37352.1	1936159	g7313	i0	30.1	0.746963562753036	123	80	71.7	3	354	1	306	427	HWD37352.1 YjhG/YagF family D-xylonate dehydratase [Fimbriimonas sp.]	diamond	369	45.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
29356532	29356532	PRJNA703759_P_NODE_25749_length_282_cov_1.253589_g25273_i0	PRJNA703759	25749	282	1.253589	3.53512098	Armatimonadota bacterium	2033014	Bacteria	Bacteria	148	8.109999999999998e-41	NR	MCX6378277.1	2033014	g25273	i0	72	0.98936170212766	93	26	98.9	0	3	281	168	260	MCX6378277.1 mandelate racemase/muconate lactonizing enzyme family protein [Armatimonadota bacterium]	diamond	279	148	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29419471	29419471	PRJNA703759_P_NODE_30029_length_267_cov_1.061856_g29553_i0	PRJNA703759	30029	267	1.061856	2.83515552	Armatimonadota bacterium	2033014	Bacteria	Bacteria	104	1.95e-24	NR	MCA1947289.1	2033014	g29553	i0	63.9	1.61797752808989	72	26	80.9	0	266	51	305	376	MCA1947289.1 glycoside hydrolase family 5 protein [Armatimonadota bacterium]	diamond	432	104	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29735070	29735070	PRJNA703759_P_NODE_45290_length_246_cov_0.901734_g44814_i0	PRJNA703759	45290	246	0.901734	2.21826564	Armatimonadota bacterium	2033014	Bacteria	Bacteria	96.7	1.4e-21	NR	MCX6379473.1	2033014	g44814	i0	65.9	1	82	26	98.8	2	3	245	19	99	MCX6379473.1 peptidylprolyl isomerase [Armatimonadota bacterium]	diamond	246	96.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30051101	30051101	PRJNA703759_P_NODE_52431_length_228_cov_2.012903_g51955_i0	PRJNA703759	52431	228	2.012903	4.5894188400000004	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	99	1.6400000000000001e-22	NR	MCW3098042.1	2739509	g51955	i0	95.9	2.57894736842105	49	2	64.5	0	228	82	323	371	MCW3098042.1 hypothetical protein [Chthonomonadaceae bacterium]	diamond	588	99	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
30145698	30145698	PRJNA703759_P_NODE_42332_length_248_cov_0.891429_g41856_i0	PRJNA703759	42332	248	0.891429	2.21074392	Armatimonadota bacterium	2033014	Bacteria	Bacteria	145	3.3e-40	NR	MCX6380692.1	2033014	g41856	i0	87.3	0.955645161290323	79	10	95.6	0	238	2	173	251	MCX6380692.1 trypsin-like peptidase domain-containing protein [Armatimonadota bacterium]	diamond	237	145	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30430756	30430756	PRJNA703759_P_NODE_46553_length_245_cov_0.906977_g46077_i0	PRJNA703759	46553	245	0.906977	2.22209365	Armatimonadota bacterium	2033014	Bacteria	Bacteria	42.7	0.0169	NR	MCX6343965.1	2033014	g46077	i0	36	1.70204081632653	75	45	91.8	1	225	1	49	120	MCX6343965.1 septum formation initiator family protein [Armatimonadota bacterium]	diamond	417	42.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30536271	30536271	PRJNA703759_P_NODE_41493_length_248_cov_0.891429_g41017_i0	PRJNA703759	41493	248	0.891429	2.21074392	Fimbriimonas	1005038	Bacteria	Bacteria	49.7	1.4e-4	NR	WP_025228795.1	1005039	g41017	i0	91.7	0.883064516129032	24	2	29	0	246	175	545	568	WP_025228795.1 GAF domain-containing protein [Fimbriimonas ginsengisoli]	diamond	219	49.7	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
30588206	30588206	PRJNA703759_P_NODE_41533_length_248_cov_0.891429_g41057_i0	PRJNA703759	41533	248	0.891429	2.21074392	Armatimonadota bacterium	2033014	Bacteria	Bacteria	120	6.58e-32	NR	MBS1724127.1	2033014	g41057	i0	94.3	0.641129032258065	53	3	64.1	0	248	90	154	206	MBS1724127.1 hypothetical protein [Armatimonadota bacterium]	diamond	159	120	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30872674	30872674	PRJNA703759_P_NODE_47514_length_244_cov_0.912281_g47038_i0	PRJNA703759	47514	244	0.912281	2.22596564	Armatimonadetes bacterium GXS	1661582	Bacteria	Bacteria	164	9.73e-45	NR	CUU37002.1	1661582	g47038	i0	90.1	0.995901639344262	81	8	99.6	0	2	244	100	180	CUU37002.1 Signal transduction histidine kinase [Armatimonadetes bacterium GXS]	diamond	243	164	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium GXS
31125086	31125086	PRJNA703759_P_NODE_38755_length_250_cov_0.881356_g38279_i0	PRJNA703759	38755	250	0.881356	2.20339	Armatimonadota bacterium	2033014	Bacteria	Bacteria	138	4.849999999999999e-37	NR	MCX6379156.1	2033014	g38279	i0	72	0.984	82	23	98.4	0	246	1	36	117	MCX6379156.1 hypothetical protein [Armatimonadota bacterium]	diamond	246	138	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31473443	31473443	PRJNA703759_P_NODE_37596_length_251_cov_0.876404_g37120_i0	PRJNA703759	37596	251	0.876404	2.19977404	Armatimonadota bacterium	2033014	Bacteria	Bacteria	62	6.77e-9	NR	MCX6380441.1	2033014	g37120	i0	43.6	0.932270916334661	78	38	93.2	2	2	235	577	648	MCX6380441.1 DUF2339 domain-containing protein [Armatimonadota bacterium]	diamond	234	62	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31631369	31631369	PRJNA703759_P_NODE_29236_length_269_cov_1.591837_g28760_i0	PRJNA703759	29236	269	1.591837	4.28204153	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	115	6.58e-28	NR	HZO91098.1	2739509	g28760	i0	60.2	0.981412639405205	88	35	98.1	0	269	6	292	379	HZO91098.1 tetratricopeptide repeat protein [Chthonomonadaceae bacterium]	diamond	264	115	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
32074362	32074362	PRJNA703759_P_NODE_45138_length_246_cov_0.901734_g44662_i0	PRJNA703759	45138	246	0.901734	2.21826564	Armatimonadota bacterium	2033014	Bacteria	Bacteria	154	4.5e-46	NR	MBS1724443.1	2033014	g44662	i0	92.6	0.98780487804878	81	6	98.8	0	244	2	32	112	MBS1724443.1 hypothetical protein [Armatimonadota bacterium]	diamond	243	154	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32296209	32296209	PRJNA703759_P_NODE_44339_length_246_cov_0.901734_g43863_i0	PRJNA703759	44339	246	0.901734	2.21826564	Armatimonadota bacterium	2033014	Bacteria	Bacteria	73.9	1.79e-13	NR	GDX41297.1	2033014	g43863	i0	77.3	1.07317073170732	44	10	53.7	0	133	2	44	87	GDX41297.1 amidohydrolase [Armatimonadota bacterium]	diamond	264	73.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32327872	32327872	PRJNA703759_P_NODE_40119_length_249_cov_0.886364_g39643_i0	PRJNA703759	40119	249	0.886364	2.20704636	Armatimonadota bacterium	2033014	Bacteria	Bacteria	142	6.97e-38	NR	MDE2125815.1	2033014	g39643	i0	80.5	1.97590361445783	82	16	98.8	0	2	247	385	466	MDE2125815.1 aldehyde dehydrogenase family protein [Armatimonadota bacterium]	diamond	492	142	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32390784	32390784	PRJNA703759_P_NODE_41899_length_248_cov_0.891429_g41423_i0	PRJNA703759	41899	248	0.891429	2.21074392	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	102	1.97e-24	NR	HZP81461.1	2739509	g41423	i0	63.8	0.967741935483871	80	29	96.8	0	2	241	30	109	HZP81461.1 serine hydrolase [Chthonomonadaceae bacterium]	diamond	240	102	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
32580749	32580749	PRJNA703759_P_NODE_48859_length_243_cov_0.917647_g48383_i0	PRJNA703759	48859	243	0.917647	2.22988221	Armatimonadota bacterium	2033014	Bacteria	Bacteria	84	1.09e-16	NR	MES2464983.1	2033014	g48383	i0	60.2	1.02469135802469	83	30	98.8	1	2	241	2	84	MES2464983.1 hypothetical protein [Armatimonadota bacterium]	diamond	249	84	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);;