metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA556992" 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
1801826	1801826	PRJNA556992_P_NODE_252482_length_304_cov_1.333333_g250293_i0	PRJNA556992	252482	304	1.333333	4.05333232	Armatimonadota bacterium	2033014	Bacteria	Bacteria	291	5.51e-74	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g250293	i0	84.466	127.990131578947	309	32	99	12	4	304	2411332	2411032	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	38909	291	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
1802694	1802694	PRJNA556992_P_NODE_308882_length_287_cov_3.696262_g306693_i0	PRJNA556992	308882	287	3.696262	10.60827194	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	252	2.44e-62	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g306693	i0	86.325	215.620209059233	234	29	81	3	56	287	126393	126625	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	61883	252	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
3083835	3083835	PRJNA556992_P_NODE_773783_length_247_cov_2.448276_g771593_i0	PRJNA556992	773783	247	2.448276	6.04724172	Fimbriimonas sp.	1936159	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g771593	i0	94.118	0.137651821862348	34	2	14	0	1	34	2514288	2514255	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	34	52.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
7505017	7505017	PRJNA556992_P_NODE_614706_length_257_cov_6.809783_g612517_i0	PRJNA556992	614706	257	6.809783	17.50114231	Fimbriimonas	1005038	Bacteria	Bacteria	309	1.26e-79	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g612517	i0	88.627	456.898832684825	255	27	99	2	3	256	29518	29771	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	117423	309	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8186010	8186010	PRJNA556992_P_NODE_794767_length_246_cov_2.063584_g792577_i0	PRJNA556992	794767	246	2.063584	5.07641664	Capsulimonas corticalis	2219043	Bacteria	Bacteria	82.4	2.83e-11	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g792577	i0	87.5	0.292682926829268	72	7	29	2	165	235	4503019	4503089	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	72	82.4	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
9454446	9454446	PRJNA556992_P_NODE_245768_length_307_cov_1.461538_g243580_i0	PRJNA556992	245768	307	1.461538	4.48692166	Armatimonadetes bacterium Uphvl-Ar1	2004467	Bacteria	Bacteria	523	5.049999999999998e-144	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g243580	i0	97.394	823.990228013029	307	8	100	0	1	307	1549848	1550154	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	252965	523	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
9463769	9463769	PRJNA556992_P_NODE_95988_length_410_cov_2.994065_g93804_i0	PRJNA556992	95988	410	2.994065	12.2756665	Armatimonadota bacterium	2033014	Bacteria	Bacteria	69.4	3.91e-7	NTclustered	gi\|2108374973\|gb\|CP070648.1\|	2033014	g93804	i0	89.286	0.517073170731707	56	5	14	1	182	237	4356992	4356938	MAG: Armatimonadetes bacterium isolate bin88 chromosome	blastn	212	69.4	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
10738385	10738385	PRJNA556992_P_NODE_882189_length_241_cov_7.011905_g879999_i0	PRJNA556992	882189	241	7.011905	16.89869105	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	222	1.56e-53	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g879999	i0	83.898	15.0041493775934	236	34	97	3	8	241	4531513	4531280	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	3616	222	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
12001836	12001836	PRJNA556992_P_NODE_1092490_length_214_cov_6.971631_g1090299_i0	PRJNA556992	1092490	214	6.971631	14.91929034	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	183	6.41e-42	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g1090299	i0	83.092	170.883177570093	207	29	96	5	3	207	1306820	1307022	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	36569	183	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
12004050	12004050	PRJNA556992_P_NODE_186850_length_334_cov_4.417625_g184662_i0	PRJNA556992	186850	334	4.417625	14.7548675	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	65.8	4.04e-6	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g184662	i0	93.182	0.323353293413174	44	3	13	0	223	266	953204	953161	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	108	65.8	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
12005654	12005654	PRJNA556992_P_NODE_290310_length_290_cov_2.603687_g288121_i0	PRJNA556992	290310	290	2.603687	7.5506923	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	108	5.65e-19	NTclustered	gi\|2874253971\|emb\|OY970296.1\|	157466	g288121	i0	78.947	19.9551724137931	171	27	58	6	122	290	3034405	3034568	MAG: uncultured Armatimonadetes bacterium isolate MFD04408.bin.1.1 genome assembly, chromosome: 1	blastn	5787	108	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
12606838	12606838	PRJNA556992_P_NODE_895470_length_241_cov_1.250000_g893280_i0	PRJNA556992	895470	241	1.25	3.0125	Capsulimonas	2494209	Bacteria	Bacteria	198	2.63e-46	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g893280	i0	82.305	268.879668049793	243	30	99	8	1	240	3409129	3408897	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	64800	200	0.99	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
13288446	13288446	PRJNA556992_P_NODE_892611_length_241_cov_1.761905_g890421_i0	PRJNA556992	892611	241	1.761905	4.24619105	Armatimonadota bacterium	2033014	Bacteria	Bacteria	124	4.53e-24	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g890421	i0	77.67	63.7219917012448	206	44	85	2	37	241	2409339	2409135	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	15357	124	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
14554983	14554983	PRJNA556992_P_NODE_242852_length_308_cov_2.523404_g240664_i0	PRJNA556992	242852	308	2.523404	7.77208432	Armatimonadetes bacterium Uphvl-Ar1	2004467	Bacteria	Bacteria	520	6.559999999999998e-143	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g240664	i0	97.078	249.386363636364	308	9	100	0	1	308	1548426	1548733	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	76811	520	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
14561061	14561061	PRJNA556992_P_NODE_710532_length_250_cov_4.700565_g708343_i0	PRJNA556992	710532	250	4.700565	11.7514125	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	147	1.01e-30	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g708343	i0	100	32.624	79	0	32	0	63	141	3264832	3264754	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	8156	147	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
16429746	16429746	PRJNA556992_P_NODE_636553_length_256_cov_1.661202_g634364_i0	PRJNA556992	636553	256	1.661202	4.25267712	Fimbriimonas	1005038	Bacteria	Bacteria	296	9.74e-76	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g634364	i0	88.095	26.3203125	252	27	98	3	1	251	27919	28168	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	6738	296	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17704767	17704767	PRJNA556992_P_NODE_586194_length_260_cov_1.647059_g584005_i0	PRJNA556992	586194	260	1.647059	4.2823534	Chthonomonas	1077265	Bacteria	Bacteria	158	4.88e-34	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g584005	i0	83.616	11.0384615384615	177	20	67	7	85	259	1436	1267	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	2870	158	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
18379957	18379957	PRJNA556992_P_NODE_392315_length_277_cov_2.637255_g390126_i0	PRJNA556992	392315	277	2.637255	7.30519635	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	128	4.12e-25	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g390126	i0	84.615	1.49819494584838	130	18	47	2	39	167	313661	313789	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	415	128	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
18387116	18387116	PRJNA556992_P_NODE_961735_length_234_cov_4.347826_g959545_i0	PRJNA556992	961735	234	4.347826	10.17391284	Fimbriimonas sp.	1936159	Bacteria	Bacteria	200	7.07e-47	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g959545	i0	82.819	1.43589743589744	227	35	96	4	1	225	1320481	1320705	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	336	200	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
19652945	19652945	PRJNA556992_P_NODE_28036_length_649_cov_3.232639_g25962_i0	PRJNA556992	28036	649	3.232639	20.97982711	Armatimonadota bacterium	2033014	Bacteria	Bacteria	291	1.26e-73	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g25962	i0	79.128	61.8859784283513	436	79	66	12	45	474	2409533	2409104	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	40164	291	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
19656176	19656176	PRJNA556992_P_NODE_5316_length_1399_cov_10.659125_g4030_i1	PRJNA556992	5316	1399	10.659125	149.12115875	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	1428	0	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g4030	i1	85.392	190.784846318799	1417	162	100	32	1	1399	667863	669252	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	266908	1428	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
20924313	20924313	PRJNA556992_P_NODE_1033997_length_227_cov_2.675325_g1031807_i0	PRJNA556992	1033997	227	2.675325	6.07298775	Armatimonadetes bacterium Uphvl-Ar1	2004467	Bacteria	Bacteria	359	1.06e-94	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g1031807	i0	95.154	94.1453744493392	227	11	100	0	1	227	1550883	1550657	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	21371	359	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
20928354	20928354	PRJNA556992_P_NODE_261157_length_300_cov_2.035242_g258968_i0	PRJNA556992	261157	300	2.035242	6.105726	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	243	1.5400000000000001e-59	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g258968	i0	83.219	45.4133333333333	292	22	94	13	1	282	2045024	2045298	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	13624	243	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
20935152	20935152	PRJNA556992_P_NODE_792957_length_246_cov_2.421965_g790767_i0	PRJNA556992	792957	246	2.421965	5.9580339	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	174	4.55e-39	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g790767	i0	87.582	124.552845528455	153	16	61	3	2	152	1306122	1306273	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	30640	174	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
22211673	22211673	PRJNA556992_P_NODE_908358_length_240_cov_2.497006_g906168_i0	PRJNA556992	908358	240	2.497006	5.9928144	Capsulimonas corticalis	2219043	Bacteria	Bacteria	119	2.1e-22	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g906168	i0	94.737	3.7875	76	4	32	0	165	240	1402104	1402029	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	909	119	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
24760425	24760425	PRJNA556992_P_NODE_880100_length_242_cov_0.911243_g877910_i0	PRJNA556992	880100	242	0.911243	2.20520806	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	313	9.06e-81	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g877910	i0	90.083	545.392561983471	242	23	100	1	1	242	1879407	1879647	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	131985	313	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae 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);;