metadata: contig_metadata: 17 rows where bioproject = "PRJNA564013", tax_kingdom = "Bacillati" and tax

17 rows where bioproject = "PRJNA564013", 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
547579	547579	PRJNA564013_P_NODE_15101_length_923_cov_19.976798_g13099_i0	PRJNA564013	15101	923	19.976798	184.38584554	Armatimonadota bacterium	2033014	Bacteria	Bacteria	330	6.749999999999999e-109	NR	MBN8691216.1	2033014	g13099	i0	82	5.94799566630553	194	27	60.5	1	2	559	129	322	MBN8691216.1 4-hydroxyphenylpyruvate dioxygenase [Armatimonadota bacterium]	diamond	5490	330	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
1827837	1827837	PRJNA564013_P_NODE_51602_length_551_cov_119.012245_g48844_i0	PRJNA564013	51602	551	119.012245	655.75746995	Capsulimonas corticalis	2219043	Bacteria	Bacteria	110	3.17e-19	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g48844	i0	82.171	14.4882032667877	129	21	23	2	199	326	594078	594205	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	7983	110	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
6928324	6928324	PRJNA564013_P_NODE_279566_length_239_cov_2.028090_g276714_i0	PRJNA564013	279566	239	2.02809	4.8471351	PVC group	1783257	Bacteria	Bacteria	142	5.61e-38	NR	WP_025226263.1	1005039	g276714	i0	86.8	6.71548117154812	76	10	95.4	0	2	229	131	206	WP_025226263.1 MBOAT family O-acyltransferase [Fimbriimonas ginsengisoli]	diamond	1605	142	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8199302	8199302	PRJNA564013_P_NODE_103247_length_405_cov_1.619186_g100411_i0	PRJNA564013	103247	405	1.619186	6.5577033	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	339	2.66e-88	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g100411	i0	81.728	1.9283950617284	405	74	100	0	1	405	1855511	1855915	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	781	339	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
10755244	10755244	PRJNA564013_P_NODE_313589_length_217_cov_2.647436_g310737_i0	PRJNA564013	313589	217	2.647436	5.74493612	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	255	1.36e-63	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g310737	i0	92.222	0.95852534562212	180	14	83	0	22	201	989266	989087	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	208	255	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
18404806	18404806	PRJNA564013_P_NODE_7335_length_1246_cov_12.659916_g5916_i0	PRJNA564013	7335	1246	12.659916	157.74255336	Chthonomonadales bacterium	2282151	Bacteria	Bacteria	309	5.55e-98	NR	MCC6729986.1	2282151	g5916	i0	60.2	0.707865168539326	294	91	68.1	5	864	16	11	289	MCC6729986.1 arsenite methyltransferase [Chthonomonadales bacterium]	diamond	882	309	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
26858086	26858086	PRJNA564013_P_NODE_120621_length_382_cov_3.750779_g117777_i0	PRJNA564013	120621	382	3.750779	14.32797578	Fimbriimonas sp.	1936159	Bacteria	Bacteria	46.2	0.0099	NR	HEY0866626.1	1936159	g117777	i0	29.7	0.793193717277487	101	62	74.6	2	66	350	122	219	HEY0866626.1 hypothetical protein [Fimbriimonas sp.]	diamond	303	46.2	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
27458655	27458655	PRJNA564013_P_NODE_297783_length_227_cov_1.379518_g294931_i0	PRJNA564013	297783	227	1.379518	3.13150586	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	84.7	1.19e-18	NR	MFN3730432.1	2682144	g294931	i0	58.1	0.977973568281938	74	31	97.8	0	222	1	32	105	MFN3730432.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	222	84.7	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27630304	27630304	PRJNA564013_P_NODE_62224_length_508_cov_26.724832_g59431_i0	PRJNA564013	62224	508	26.724832	135.76214656	Bacteria	2	Bacteria	Bacteria	161	4.459999999999999e-48	NR	MBI5705390.1	2033014	g59431	i0	74.1	3.33070866141732	108	28	63.8	0	426	103	2	109	MBI5705390.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Armatimonadota bacterium]	diamond	1692	161	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27742925	27742925	PRJNA564013_P_NODE_231504_length_277_cov_4.435185_g228652_i0	PRJNA564013	231504	277	4.435185	12.28546245	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	77	6.06e-15	NR	MFN3730433.1	2682144	g228652	i0	60.3	0.628158844765343	58	23	62.8	0	276	103	137	194	MFN3730433.1 helix-turn-helix domain-containing protein [Fimbriimonadaceae bacterium]	diamond	174	77	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
27837201	27837201	PRJNA564013_P_NODE_184624_length_320_cov_15.602317_g181774_i0	PRJNA564013	184624	320	15.602317	49.9274144	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	62	1.53e-8	NR	MCC7229431.1	2682144	g181774	i0	34.4	0.871875	93	61	87.2	0	14	292	380	472	MCC7229431.1 VWA domain-containing protein [Fimbriimonadaceae bacterium]	diamond	279	62	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
31121550	31121550	PRJNA564013_P_NODE_635_length_3234_cov_54.279231_g444_i0	PRJNA564013	635	3234	54.279231	1755.39033054	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	398	5.96e-126	NR	MFN3730435.1	2682144	g444	i0	62.6	0.309833024118738	334	120	31	1	2062	1061	3	331	MFN3730435.1 replication-relaxation family protein [Fimbriimonadaceae bacterium]	diamond	1002	398	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
31406604	31406604	PRJNA564013_P_NODE_368896_length_180_cov_20.084034_g366044_i0	PRJNA564013	368896	180	20.084034	36.1512612	Chthonomonas sp.	2282153	Bacteria	Bacteria	70.9	1.86e-12	NR	MBL8059959.1	2282153	g366044	i0	56.1	1.9	57	23	91.7	1	14	178	373	429	MBL8059959.1 VanW family protein [Chthonomonas sp.]	diamond	342	70.9	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas sp.
31722704	31722704	PRJNA564013_P_NODE_57857_length_525_cov_5.030172_g55073_i0	PRJNA564013	57857	525	5.030172	26.408403	Armatimonadota bacterium	2033014	Bacteria	Bacteria	184	7.34e-53	NR	MCX6366894.1	2033014	g55073	i0	56.5	0.92	161	70	92	0	505	23	214	374	MCX6366894.1 S8 family serine peptidase [Armatimonadota bacterium]	diamond	483	184	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32229137	32229137	PRJNA564013_P_NODE_14898_length_928_cov_18.227220_g12903_i0	PRJNA564013	14898	928	18.22722	169.1486016	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	196	1.1999999999999998e-56	NR	HMS54648.1	2682144	g12903	i0	36.8	0.931034482758621	288	180	92.5	1	47	904	5	292	HMS54648.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	864	196	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
32639644	32639644	PRJNA564013_P_NODE_183200_length_322_cov_2.559387_g180350_i0	PRJNA564013	183200	322	2.559387	8.24122614	Armatimonadaceae bacterium	2933160	Bacteria	Bacteria	74.7	5.22e-13	NR	HVK06203.1	2933160	g180350	i0	75.5	0.456521739130435	49	12	45.7	0	170	316	369	417	HVK06203.1 PilN domain-containing protein [Armatimonadaceae bacterium]	diamond	147	74.7	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae		Armatimonadaceae bacterium
32671324	32671324	PRJNA564013_P_NODE_342820_length_203_cov_0.915493_g339968_i0	PRJNA564013	342820	203	0.915493	1.85845079	Armatimonadaceae bacterium	2933160	Bacteria	Bacteria	103	2.6899999999999994e-24	NR	HVK06684.1	2933160	g339968	i0	75.4	0.960591133004926	65	16	96.1	0	3	197	57	121	HVK06684.1 cation:proton antiporter [Armatimonadaceae bacterium]	diamond	195	103	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae		Armatimonadaceae 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);;