metadata: contig_metadata: 15 rows where bioproject = "PRJNA494251", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA494251", 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
16409516	16409516	PRJNA494251_P_NODE_16693_length_342_cov_0.858736_g16380_i0	PRJNA494251	16693	342	0.858736	2.93687712	Chthonomonas	1077265	Bacteria	Bacteria	385	2.81e-102	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g16380	i0	87.246	104.865497076023	345	34	99	9	5	342	648	989	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	35864	385	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
18327132	18327132	PRJNA494251_P_NODE_43535_length_246_cov_0.890173_g43221_i0	PRJNA494251	43535	246	0.890173	2.18982558	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	58.4	4.78e-4	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g43221	i0	100	0.126016260162602	31	0	13	0	97	127	516931	516961	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
26823899	26823899	PRJNA494251_P_NODE_18161_length_330_cov_1.789883_g17847_i0	PRJNA494251	18161	330	1.789883	5.9066139	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	45.1	0.0148	NR	MCS6776784.1	2739509	g17847	i0	60	1.38181818181818	35	14	31.8	0	6	110	150	184	MCS6776784.1 ankyrin repeat domain-containing protein [Chthonomonadaceae bacterium]	diamond	456	45.1	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
27203118	27203118	PRJNA494251_P_NODE_29622_length_273_cov_1.540000_g29308_i0	PRJNA494251	29622	273	1.54	4.2042	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	52.4	2.27e-5	NR	HZO86726.1	2739509	g29308	i0	41.7	1.58241758241758	72	37	73.6	2	70	270	806	877	HZO86726.1 methyltransferase domain-containing protein [Chthonomonadaceae bacterium]	diamond	432	52.4	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
28750632	28750632	PRJNA494251_P_NODE_14187_length_366_cov_1.051195_g13878_i0	PRJNA494251	14187	366	1.051195	3.8473737	Fimbriimonas sp.	1936159	Bacteria	Bacteria	44.3	0.0404	NR	HWD38068.1	1936159	g13878	i0	34.4	0.737704918032787	90	51	72.1	3	331	68	511	594	HWD38068.1 hypothetical protein [Fimbriimonas sp.]	diamond	270	44.3	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
28750666	28750666	PRJNA494251_P_NODE_33407_length_261_cov_0.946809_g33093_i0	PRJNA494251	33407	261	0.946809	2.47117149	Fimbriimonas sp.	1936159	Bacteria	Bacteria	114	1.78e-27	NR	HSI72157.1	1936159	g33093	i0	64.4	5.02298850574713	90	24	97.7	2	259	5	346	432	HSI72157.1 MmgE/PrpD family protein [Fimbriimonas sp.]	diamond	1311	114	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
28813568	28813568	PRJNA494251_P_NODE_48168_length_242_cov_0.911243_g47854_i0	PRJNA494251	48168	242	0.911243	2.20520806	Armatimonadetes bacterium Cent15-Ar3	1987502	Bacteria	Bacteria	97.8	7.859999999999998e-24	NR	OWU66185.1	1987502	g47854	i0	100	0.59504132231405	48	0	59.5	0	240	97	4	51	OWU66185.1 MAG: 50S ribosomal protein L17 [Armatimonadetes bacterium Cent15-Ar3]	diamond	144	97.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Cent15-Ar3
30139723	30139723	PRJNA494251_P_NODE_22192_length_305_cov_0.995690_g21878_i0	PRJNA494251	22192	305	0.99569	3.0368545	Armatimonadota bacterium	2033014	Bacteria	Bacteria	45.4	0.00576	NR	MBM3458581.1	2033014	g21878	i0	70.8	0.236065573770492	24	7	23.6	0	111	40	2	25	MBM3458581.1 hypothetical protein [Armatimonadota bacterium]	diamond	72	45.4	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30424946	30424946	PRJNA494251_P_NODE_50113_length_241_cov_0.916667_g49799_i0	PRJNA494251	50113	241	0.916667	2.20916747	Armatimonadota bacterium	2033014	Bacteria	Bacteria	105	2.87e-25	NR	MBW3637694.1	2033014	g49799	i0	70	2.98755186721992	80	24	99.6	0	1	240	80	159	MBW3637694.1 2-hydroxyacid dehydrogenase [Armatimonadota bacterium]	diamond	720	105	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30866728	30866728	PRJNA494251_P_NODE_20154_length_316_cov_1.905350_g19840_i0	PRJNA494251	20154	316	1.90535	6.020906	Armatimonadota bacterium	2033014	Bacteria	Bacteria	127	3.93e-33	NR	HAY14858.1	2033014	g19840	i0	59.8	2.90506329113924	102	41	96.8	0	2	307	212	313	HAY14858.1 GDP-mannose 4,6-dehydratase [Armatimonadota bacterium]	diamond	918	127	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31577944	31577944	PRJNA494251_P_NODE_41576_length_247_cov_0.885057_g41262_i0	PRJNA494251	41576	247	0.885057	2.18609079	FCB group	1783270	Bacteria	Bacteria	48.5	3.44e-4	NR	WP_119322822.1	2219043	g41262	i0	43.1	1.42105263157895	65	30	76.5	2	242	54	467	526	WP_119322822.1 phosphoenolpyruvate carboxykinase (ATP) [Capsulimonas corticalis]	diamond	351	48.5	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
31815327	31815327	PRJNA494251_P_NODE_39737_length_249_cov_0.875000_g39423_i0	PRJNA494251	39737	249	0.875	2.17875	Armatimonadota bacterium	2033014	Bacteria	Bacteria	46.2	0.00243	NR	MCL6519555.1	2033014	g39423	i0	35.7	1.01204819277108	84	42	88	4	18	236	1258	1340	MCL6519555.1 N-acetylmuramoyl-L-alanine amidase [Armatimonadota bacterium]	diamond	252	46.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32131910	32131910	PRJNA494251_P_NODE_44798_length_245_cov_0.895349_g44484_i0	PRJNA494251	44798	245	0.895349	2.19360505	Armatimonadota bacterium	2033014	Bacteria	Bacteria	47.8	6.19e-4	NR	MEY3763693.1	2033014	g44484	i0	44.6	1.83673469387755	74	29	89.4	3	235	17	168	230	MEY3763693.1 hypothetical protein [Armatimonadota bacterium]	diamond	450	47.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32606167	32606167	PRJNA494251_P_NODE_8060_length_463_cov_1.458974_g7757_i0	PRJNA494251	8060	463	1.458974	6.75504962	Armatimonadota bacterium	2033014	Bacteria	Bacteria	68.6	2.55e-10	NR	MBS1713247.1	2033014	g7757	i0	46.9	0.524838012958963	81	39	52.5	2	5	247	244	320	MBS1713247.1 trypsin-like serine protease [Armatimonadota bacterium]	diamond	243	68.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32637381	32637381	PRJNA494251_P_NODE_48240_length_242_cov_0.911243_g47926_i0	PRJNA494251	48240	242	0.911243	2.20520806	Armatimonadaceae bacterium	2933160	Bacteria	Bacteria	48.5	3.29e-4	NR	HVK05730.1	2933160	g47926	i0	39.4	0.880165289256198	71	43	88	0	7	219	404	474	HVK05730.1 hypothetical protein [Armatimonadaceae bacterium]	diamond	213	48.5	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);;