metadata: contig_metadata: 10 rows where bioproject = "PRJNA934472", tax_phylum = "Armatimonadota" and tax

10 rows where bioproject = "PRJNA934472", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"

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
2531179	2531179	PRJNA934472_P_NODE_20682_length_320_cov_2.530364_g20305_i0	PRJNA934472	20682	320	2.530364	8.0971648	Chthonomonas	1077265	Bacteria	Bacteria	193	1.69e-44	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g20305	i0	81.148	151.828125	244	42	75	4	1	240	2543	2786	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	48585	193	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
11459283	11459283	PRJNA934472_P_NODE_23809_length_300_cov_7.422907_g23431_i0	PRJNA934472	23809	300	7.422907	22.268721	Candidatus Nitrosymbiomonas	2819028	Bacteria	Bacteria	289	1.9499999999999996e-73	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g23431	i0	85.211	87	284	38	94	4	7	288	37382	37101	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	26100	289	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
13664865	13664865	PRJNA934472_P_NODE_39791_length_231_cov_2.044304_g39413_i0	PRJNA934472	39791	231	2.044304	4.72234224	Armatimonadota bacterium	2033014	Bacteria	Bacteria	259	1.13e-64	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g39413	i0	87.124	121.463203463203	233	24	99	6	1	230	2409699	2409470	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	28058	259	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
17833075	17833075	PRJNA934472_P_NODE_26114_length_288_cov_1.986047_g25736_i0	PRJNA934472	26114	288	1.986047	5.71981536	Chthonomonas	1077265	Bacteria	Bacteria	213	1.15e-50	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g25736	i0	83.772	18.1909722222222	228	33	78	2	11	236	1305529	1305754	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	5239	213	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
27846157	27846157	PRJNA934472_P_NODE_36364_length_248_cov_0.880000_g35986_i0	PRJNA934472	36364	248	0.88	2.1824	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	93.6	4.11e-20	NR	MBX3108943.1	2682144	g35986	i0	50	0.991935483870968	82	41	99.2	0	247	2	137	218	MBX3108943.1 tyrosine-type recombinase/integrase [Fimbriimonadaceae bacterium]	diamond	246	93.6	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
29867067	29867067	PRJNA934472_P_NODE_27911_length_280_cov_1.444444_g27533_i0	PRJNA934472	27911	280	1.444444	4.0444432	Capsulimonas sp.	2494211	Bacteria	Bacteria	62.4	6.43e-9	NR	WP_348223279.1	2494211	g27533	i0	33.3	1.06071428571429	99	58	97.5	3	3	275	20	118	WP_348223279.1 PepSY-associated TM helix domain-containing protein [Capsulimonas sp.]	diamond	297	62.4	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas sp.
29930399	29930399	PRJNA934472_P_NODE_28551_length_277_cov_1.416667_g28173_i0	PRJNA934472	28551	277	1.416667	3.92416759	Armatimonadota bacterium	2033014	Bacteria	Bacteria	91.7	3.69e-19	NR	NLC58560.1	2033014	g28173	i0	46.7	5.12274368231047	92	49	99.6	0	2	277	621	712	NLC58560.1 hypothetical protein [Armatimonadota bacterium]	diamond	1419	91.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31004475	31004475	PRJNA934472_P_NODE_22174_length_310_cov_3.189873_g21796_i0	PRJNA934472	22174	310	3.189873	9.8886063	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	58.5	6.64e-8	NR	WP_025225480.1	1005039	g21796	i0	58.7	0.445161290322581	46	19	44.5	0	308	171	43	88	WP_025225480.1 RNA polymerase sigma factor [Fimbriimonas ginsengisoli]	diamond	138	58.5	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
31889801	31889801	PRJNA934472_P_NODE_36297_length_248_cov_0.880000_g35919_i0	PRJNA934472	36297	248	0.88	2.1824	Armatimonas rosea	685828	Bacteria	Bacteria	154	7.539999999999998e-42	NR	WP_184203789.1	685828	g35919	i0	92.7	2.9758064516129	82	6	99.2	0	248	3	175	256	WP_184203789.1 YjhG/YagF family D-xylonate dehydratase [Armatimonas rosea]	diamond	738	154	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas rosea
32301575	32301575	PRJNA934472_P_NODE_35479_length_250_cov_1.548023_g35101_i0	PRJNA934472	35479	250	1.548023	3.8700575	Armatimonadota bacterium	2033014	Bacteria	Bacteria	96.7	3.3100000000000003e-21	NR	MBN9500294.1	2033014	g35101	i0	57.6	2.052	85	31	98.4	3	1	246	250	332	MBN9500294.1 deoxyribodipyrimidine photo-lyase [Armatimonadota bacterium]	diamond	513	96.7	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);;