metadata: contig_metadata: 11 rows where bioproject = "PRJNA867519", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA867519", 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_species
8501076	8501076	PRJNA867519_P_NODE_3667_length_546_cov_7.264271_g3515_i0	PRJNA867519	3667	546	7.264271	39.66291966	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	176	1.72e-52	NR	MEJ5169988.1	2682145	g3515	i0	57.6	1.6978021978022	151	60	82.4	3	543	94	32	179	MEJ5169988.1 glutathione peroxidase [Fimbriimonadales bacterium]	diamond	927	176	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales		Fimbriimonadales bacterium
14876104	14876104	PRJNA867519_P_NODE_24372_length_256_cov_1.054645_g24218_i0	PRJNA867519	24372	256	1.054645	2.6998912	Armatimonadota bacterium	2033014	Bacteria	Bacteria	125	9.94e-35	NR	MEI6499432.1	2033014	g24218	i0	70.9	2.015625	86	24	99.6	1	255	1	2	87	MEI6499432.1 arsenate reductase ArsC [Armatimonadota bacterium]	diamond	516	125	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
28791871	28791871	PRJNA867519_P_NODE_18327_length_283_cov_1.442857_g18173_i0	PRJNA867519	18327	283	1.442857	4.08328531	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	63.9	1.87e-10	NR	MFN3963584.1	2682144	g18173	i0	61.7	0.636042402826855	60	23	63.6	0	180	1	1	60	MFN3963584.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	180	63.9	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
28799953	28799953	PRJNA867519_P_NODE_1547_length_781_cov_1.440678_g1406_i0	PRJNA867519	1547	781	1.440678	11.25169518	PVC group	1783257	Bacteria	Bacteria	369	7.229999999999999e-126	NR	MBS1708037.1	2033014	g1406	i0	69.5	17.5544174135723	249	73	95.6	1	747	1	14	259	MBS1708037.1 inositol oxygenase [Armatimonadota bacterium]	diamond	13710	369	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
28926420	28926420	PRJNA867519_P_NODE_5008_length_480_cov_2.226044_g4854_i0	PRJNA867519	5008	480	2.226044	10.6850112	FCB group	1783270	Bacteria	Bacteria	143	2.07e-37	NR	MEP6755583.1	2282151	g4854	i0	56.6	6.1125	122	53	76.3	0	368	3	41	162	MEP6755583.1 ammonium transporter [Chthonomonadales bacterium]	diamond	2934	144	0.993055555555556	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales		Chthonomonadales bacterium
29084451	29084451	PRJNA867519_P_NODE_24348_length_256_cov_1.262295_g24194_i0	PRJNA867519	24348	256	1.262295	3.2314752	PVC group	1783257	Bacteria	Bacteria	119	1.72e-29	NR	MEI7984073.1	2033014	g24194	i0	70.1	4.51171875	77	23	90.2	0	22	252	373	449	MEI7984073.1 MmgE/PrpD family protein [Armatimonadota bacterium]	diamond	1155	120	0.991666666666667	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
29581098	29581098	PRJNA867519_P_NODE_24750_length_254_cov_0.751381_g24596_i0	PRJNA867519	24750	254	0.751381	1.90850774	Armatimonadota bacterium	2033014	Bacteria	Bacteria	42	0.0416	NR	NDK16950.1	2033014	g24596	i0	37.8	0.531496062992126	45	28	53.1	0	74	208	21	65	NDK16950.1 hypothetical protein [Armatimonadota bacterium]	diamond	135	42	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
29770716	29770716	PRJNA867519_P_NODE_28051_length_248_cov_0.880000_g27897_i0	PRJNA867519	28051	248	0.88	2.1824	Armatimonadota bacterium	2033014	Bacteria	Bacteria	107	6.51e-25	NR	MBS1726118.1	2033014	g27897	i0	61.3	2.9758064516129	80	31	96.8	0	241	2	364	443	MBS1726118.1 MmgE/PrpD family protein [Armatimonadota bacterium]	diamond	738	107	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
30781824	30781824	PRJNA867519_P_NODE_28094_length_248_cov_0.880000_g27940_i0	PRJNA867519	28094	248	0.88	2.1824	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	70.9	4.96e-12	NR	MDX2064639.1	2682144	g27940	i0	42.7	0.991935483870968	82	47	99.2	0	246	1	55	136	MDX2064639.1 PA14 domain-containing protein [Fimbriimonadaceae bacterium]	diamond	246	70.9	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
31382454	31382454	PRJNA867519_P_NODE_17796_length_285_cov_1.740566_g17642_i0	PRJNA867519	17796	285	1.740566	4.9606131	Armatimonadota bacterium	2033014	Bacteria	Bacteria	80.9	2.37e-15	NR	MDH7569298.1	2033014	g17642	i0	47.9	0.768421052631579	73	38	76.8	0	220	2	494	566	MDH7569298.1 hypothetical protein [Armatimonadota bacterium]	diamond	219	80.9	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
32300113	32300113	PRJNA867519_P_NODE_13799_length_315_cov_1.652893_g13645_i0	PRJNA867519	13799	315	1.652893	5.20661295	Armatimonadota bacterium	2033014	Bacteria	Bacteria	69.3	7.31e-13	NR	MDW8289218.1	2033014	g13645	i0	52.9	1.33333333333333	70	29	63.8	3	271	71	6	74	MDW8289218.1 hypothetical protein [Armatimonadota bacterium]	diamond	420	69.3	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);;