metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1240804" 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
349177	349177	PRJNA1240804_P_NODE_9501_length_417_cov_2.274457_g9139_i0	PRJNA1240804	9501	417	2.274457	9.48448569	Armatimonadota bacterium	2033014	Bacteria	Bacteria	182	4.9e-41	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g9139	i0	85.714	179.726618705036	175	21	41	4	9	180	1692704	1692877	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	74946	182	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
1622867	1622867	PRJNA1240804_P_NODE_42082_length_233_cov_1.657609_g41716_i0	PRJNA1240804	42082	233	1.657609	3.86222897	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	207	4.21e-49	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g41716	i0	84.071	182.836909871245	226	24	94	12	1	220	126440	126659	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	42601	207	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
6726248	6726248	PRJNA1240804_P_NODE_51406_length_217_cov_0.994048_g51040_i0	PRJNA1240804	51406	217	0.994048	2.15708416	Fimbriimonas sp.	1936159	Bacteria	Bacteria	263	8.13e-66	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g51040	i0	90.196	42.9308755760369	204	17	93	3	15	216	1688871	1688669	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	9316	263	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
8703095	8703095	PRJNA1240804_P_NODE_44367_length_228_cov_4.067039_g44001_i0	PRJNA1240804	44367	228	4.067039	9.27284892	Fimbriimonas	1005038	Bacteria	Bacteria	246	8.69e-61	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g44001	i0	87.85	90.4912280701754	214	21	93	5	1	212	29573	29783	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	20632	246	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11253340	11253340	PRJNA1240804_P_NODE_14729_length_351_cov_2.384106_g14364_i0	PRJNA1240804	14729	351	2.384106	8.36821206	Fimbriimonas	1005038	Bacteria	Bacteria	407	6.14e-109	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g14364	i0	90.096	63.6096866096866	313	31	89	0	6	318	27891	28203	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	22327	407	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11253371	11253371	PRJNA1240804_P_NODE_16669_length_334_cov_19.150877_g16304_i0	PRJNA1240804	16669	334	19.150877	63.96392918	Fimbriimonas	1005038	Bacteria	Bacteria	472	2.04e-128	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g16304	i0	95.593	404.050898203593	295	12	88	1	3	296	27230	26936	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	134953	472	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
13100563	13100563	PRJNA1240804_P_NODE_101911_length_172_cov_1.487805_g101545_i0	PRJNA1240804	101911	172	1.487805	2.5590246	Armatimonadota bacterium	2033014	Bacteria	Bacteria	187	3.79e-43	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g101545	i0	93.651	233.773255813953	126	6	73	2	10	134	1692754	1692878	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	40209	187	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
17627615	17627615	PRJNA1240804_P_NODE_111414_length_168_cov_4.487395_g111048_i0	PRJNA1240804	111414	168	4.487395	7.5388236	Fimbriimonas	1005038	Bacteria	Bacteria	241	2.81e-59	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g111048	i0	95.946	458.142857142857	148	6	88	0	21	168	26868	27015	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	76968	241	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17627890	17627890	PRJNA1240804_P_NODE_31334_length_261_cov_4.117925_g30968_i0	PRJNA1240804	31334	261	4.117925	10.74778425	Chthonomonas	1077265	Bacteria	Bacteria	235	2.1999999999999997e-57	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g30968	i0	85.526	1.74712643678161	228	30	87	3	16	241	1218	1444	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	456	235	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
17628036	17628036	PRJNA1240804_P_NODE_61454_length_203_cov_1.292208_g61088_i0	PRJNA1240804	61454	203	1.292208	2.62318224	Capsulimonas	2494209	Bacteria	Bacteria	244	2.72e-60	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g61088	i0	91.62	561.940886699507	179	11	87	4	27	203	3408007	3407831	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	114074	244	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
18200599	18200599	PRJNA1240804_P_NODE_73675_length_191_cov_1.169014_g73309_i0	PRJNA1240804	73675	191	1.169014	2.23281674	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	84.2	5.83e-12	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g73309	i0	93.103	26.5130890052356	58	3	30	1	15	71	589981	590038	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	5064	84.2	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
22023766	22023766	PRJNA1240804_P_NODE_117138_length_167_cov_2.457627_g116772_i0	PRJNA1240804	117138	167	2.457627	4.10423709	Armatimonadota bacterium	2033014	Bacteria	Bacteria	63.9	6.47e-6	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g116772	i0	93.023	0.760479041916168	43	3	26	0	75	117	1170670	1170712	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	127	63.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
22727104	22727104	PRJNA1240804_P_NODE_33778_length_254_cov_1.239024_g33412_i0	PRJNA1240804	33778	254	1.239024	3.14712096	Armatimonadota	67819	Bacteria	Bacteria	289	1.61e-73	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g33412	i0	88.703	512.874015748032	239	24	94	3	5	242	34472	34708	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	130270	289	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus

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);;