metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA168635" 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
364374	364374	PRJNA168635_P_NODE_19701_length_183_cov_3.044776_g19285_i0	PRJNA168635	19701	183	3.044776	5.57194008	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	243	8.619999999999999e-60	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g19285	i0	90.811	211.448087431694	185	11	99	6	2	183	2201893	2201712	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	38695	243	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
1054377	1054377	PRJNA168635_P_NODE_34841_length_153_cov_4.500000_g34425_i0	PRJNA168635	34841	153	4.5	6.885	Bacteria	2	Bacteria	Bacteria	233	4.17e-57	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g34425	i0	94.156	478.725490196078	154	8	100	1	1	153	1548587	1548434	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	73245	233	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
1054440	1054440	PRJNA168635_P_NODE_7921_length_300_cov_10.051793_g7508_i0	PRJNA168635	7921	300	10.051793	30.155379	Armatimonadota	67819	Bacteria	Bacteria	326	1.4899999999999999e-84	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g7508	i0	90.361	166.026666666667	249	22	83	2	34	281	37131	37378	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	49808	326	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
1639285	1639285	PRJNA168635_P_NODE_23002_length_174_cov_1.432000_g22586_i0	PRJNA168635	23002	174	1.432	2.49168	Armatimonadota bacterium	2033014	Bacteria	Bacteria	97.1	6.67e-16	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g22586	i0	89.61	12.4137931034483	77	6	44	2	79	154	1011965	1011890	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	2160	97.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
2914974	2914974	PRJNA168635_P_NODE_12923_length_226_cov_2.163842_g12507_i0	PRJNA168635	12923	226	2.163842	4.89028292	Fimbriimonas sp.	1936159	Bacteria	Bacteria	237	5.17e-58	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g12507	i0	85.59	454.517699115044	229	30	100	3	1	226	1687801	1687573	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	102721	237	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
2915084	2915084	PRJNA168635_P_NODE_18283_length_188_cov_3.194245_g17867_i0	PRJNA168635	18283	188	3.194245	6.0051806	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	315	1.8599999999999999e-81	NTclustered	gi\|892164884\|gb\|KT182498.1\|	157466	g17867	i0	96.809	99.9734042553192	188	6	100	0	1	188	1275	1088	Uncultured Armatimonadetes bacterium clone MBR Cr 0.4ppm 1 16S ribosomal RNA gene, partial sequence	blastn	18795	315	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
2915274	2915274	PRJNA168635_P_NODE_31163_length_163_cov_0.912281_g30747_i0	PRJNA168635	31163	163	0.912281	1.48701803	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	276	7.41e-70	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g30747	i0	97.516	30.6687116564417	161	4	99	0	1	161	894693	894853	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	4999	276	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
4191435	4191435	PRJNA168635_P_NODE_13944_length_216_cov_3.904192_g13528_i0	PRJNA168635	13944	216	3.904192	8.43305472	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	346	7.810000000000001e-91	NTclustered	gi\|20385325\|gb\|AF368184.1\|	157466	g13528	i0	100	89.2268518518518	187	0	87	0	1	187	187	1	Uncultured candidate division OP10 bacterium clone SBRA136 16S ribosomal RNA gene, partial sequence	blastn	19273	346	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
4191750	4191750	PRJNA168635_P_NODE_3424_length_451_cov_7.947761_g3025_i0	PRJNA168635	3424	451	7.947761	35.84440211	Fimbriimonas sp.	1936159	Bacteria	Bacteria	606	7.439999999999997e-169	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g3025	i0	93.029	344.778270509978	416	27	92	2	36	451	1687570	1687983	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	155495	606	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
4882134	4882134	PRJNA168635_P_NODE_15324_length_205_cov_1.903846_g14908_i0	PRJNA168635	15324	205	1.903846	3.9028843	Armatimonadota	67819	Bacteria	Bacteria	183	6.08e-42	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g14908	i0	83.092	206.009756097561	207	30	100	5	1	205	36835	36632	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	42232	183	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
5468064	5468064	PRJNA168635_P_NODE_7805_length_302_cov_32.150198_g7392_i0	PRJNA168635	7805	302	32.150198	97.09359796	Capsulimonas corticalis	2219043	Bacteria	Bacteria	141	5.830000000000001e-29	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g7392	i0	88.333	113.37417218543	120	10	39	4	169	287	595443	595559	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	34239	141	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
8707071	8707071	PRJNA168635_P_NODE_3287_length_460_cov_8.058394_g2890_i0	PRJNA168635	3287	460	8.058394	37.0686124	Fimbriimonas	1005038	Bacteria	Bacteria	496	1.72e-135	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g2890	i0	86.275	70.004347826087	459	60	99	3	1	458	27893	28349	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	32202	496	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8707147	8707147	PRJNA168635_P_NODE_8307_length_293_cov_7.762295_g7892_i0	PRJNA168635	8307	293	7.762295	22.74352435	Fimbriimonas	1005038	Bacteria	Bacteria	307	5.25e-79	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7892	i0	86.316	208.430034129693	285	36	97	3	2	285	29773	29491	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	61070	307	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
9292699	9292699	PRJNA168635_P_NODE_32528_length_161_cov_3.589286_g32112_i0	PRJNA168635	32528	161	3.589286	5.77875046	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	235	1.24e-57	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g32112	i0	93.631	140.267080745342	157	10	98	0	5	161	315635	315479	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	22583	235	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
11257622	11257622	PRJNA168635_P_NODE_6409_length_334_cov_7.277193_g5998_i0	PRJNA168635	6409	334	7.277193	24.30582462	Fimbriimonas	1005038	Bacteria	Bacteria	374	5.9199999999999995e-99	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g5998	i0	87.888	86.3532934131737	322	34	95	4	1	318	27893	28213	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	28842	374	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11257641	11257641	PRJNA168635_P_NODE_809_length_837_cov_49.128173_g586_i0	PRJNA168635	809	837	49.128173	411.20280801	Chthonomonas	1077265	Bacteria	Bacteria	680	0	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g586	i0	84.582	561.73476702509	694	97	82	9	151	837	408	1098	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	470172	680	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
13118310	13118310	PRJNA168635_P_NODE_23991_length_171_cov_3.811475_g23575_i0	PRJNA168635	23991	171	3.811475	6.51762225	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	117	5.01e-22	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g23575	i0	91.667	11.3859649122807	84	7	49	0	3	86	2463406	2463489	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	1947	117	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
14393380	14393380	PRJNA168635_P_NODE_10372_length_256_cov_6.714976_g9957_i0	PRJNA168635	10372	256	6.714976	17.19033856	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	257	4.6e-64	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g9957	i0	85.892	115.5546875	241	34	94	0	16	256	667409	667649	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	29582	257	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15667098	15667098	PRJNA168635_P_NODE_11513_length_241_cov_5.354167_g11097_i0	PRJNA168635	11513	241	5.354167	12.90354247	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	357	4.1099999999999997e-94	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g11097	i0	93.388	277.842323651452	242	14	100	2	1	241	669617	669377	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	66960	357	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15667143	15667143	PRJNA168635_P_NODE_13553_length_220_cov_1.929825_g13137_i0	PRJNA168635	13553	220	1.929825	4.245615	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	180	8.57e-41	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g13137	i0	84.699	184.390909090909	183	24	83	4	34	215	126393	126572	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	40566	180	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
15667558	15667558	PRJNA168635_P_NODE_5553_length_358_cov_231.818770_g5148_i0	PRJNA168635	5553	358	231.81877	829.9111966	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	429	1.34e-115	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g5148	i0	88.268	989.983240223464	358	42	100	0	1	358	3407385	3407028	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	354414	429	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
16941880	16941880	PRJNA168635_P_NODE_33594_length_157_cov_3.824074_g33178_i0	PRJNA168635	33594	157	3.824074	6.00379618	Armatimonadota bacterium	2033014	Bacteria	Bacteria	169	1.23e-37	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g33178	i0	93.043	413.71974522293	115	8	73	0	33	147	2410730	2410616	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	64954	169	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
16941906	16941906	PRJNA168635_P_NODE_34854_length_153_cov_4.182692_g34438_i0	PRJNA168635	34854	153	4.182692	6.39951876	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|20385325\|gb\|AF368184.1\|	157466	g34438	i0	99.351	100.960784313725	154	0	100	1	1	153	418	265	Uncultured candidate division OP10 bacterium clone SBRA136 16S ribosomal RNA gene, partial sequence	blastn	15447	278	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
18905586	18905586	PRJNA168635_P_NODE_1295_length_692_cov_8.289269_g218_i3	PRJNA168635	1295	692	8.2892690000000009	57.36174148	Fimbriimonas	1005038	Bacteria	Bacteria	804	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g218	i3	88.722	153.611271676301	665	66	96	6	29	692	28183	28839	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	106299	804	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18905814	18905814	PRJNA168635_P_NODE_6535_length_331_cov_3.354610_g6124_i0	PRJNA168635	6535	331	3.35461	11.1037591	Bacteria	2	Bacteria	Bacteria	562	1.16e-155	NTclustered	gi\|20385325\|gb\|AF368184.1\|	157466	g6124	i0	97.281	100.117824773414	331	9	100	0	1	331	794	464	Uncultured candidate division OP10 bacterium clone SBRA136 16S ribosomal RNA gene, partial sequence	blastn	33139	562	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
20180167	20180167	PRJNA168635_P_NODE_10196_length_259_cov_4.642857_g9781_i0	PRJNA168635	10196	259	4.642857	12.02499963	Fimbriimonas	1005038	Bacteria	Bacteria	399	7.309999999999998e-107	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g9781	i0	94.595	418.938223938224	259	12	99	1	1	257	27139	26881	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	108505	399	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
20180467	20180467	PRJNA168635_P_NODE_9396_length_272_cov_3.372197_g8981_i0	PRJNA168635	9396	272	3.372197	9.17237584	Armatimonadota	67819	Bacteria	Bacteria	298	2.9e-76	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g8981	i0	87.121	327.202205882353	264	32	97	2	8	270	36456	36718	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	88999	298	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
22041356	22041356	PRJNA168635_P_NODE_6778_length_325_cov_22.463768_g6367_i0	PRJNA168635	6778	325	22.463768	73.007246	Chthonomonas calidirosea	454171	Bacteria	Bacteria	307	5.9e-79	NTclustered	gi\|510021827\|emb\|HF951689.1\|	1303518	g6367	i0	85.959	185.775384615385	292	35	88	4	6	291	2847635	2847344	Chthonomonas calidirosea T49 complete genome	blastn	60377	307	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
23316382	23316382	PRJNA168635_P_NODE_10399_length_256_cov_2.483092_g9984_i0	PRJNA168635	10399	256	2.483092	6.35671552	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	291	4.529999999999999e-74	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g9984	i0	95.135	194.16015625	185	8	100	1	73	256	317240	317056	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	49705	291	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
23316891	23316891	PRJNA168635_P_NODE_9819_length_265_cov_4.106481_g9404_i0	PRJNA168635	9819	265	4.106481	10.88217465	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	178	3.83e-40	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g9404	i0	83.168	79.8490566037736	202	26	75	7	1	198	1306493	1306690	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	21160	178	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
25280409	25280409	PRJNA168635_P_NODE_35220_length_152_cov_3.000000_g34804_i0	PRJNA168635	35220	152	3	4.56	Fimbriimonas	1005038	Bacteria	Bacteria	204	3.2399999999999996e-48	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g34804	i0	90.789	11.6447368421053	152	14	100	0	1	152	28318	28469	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	1770	204	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli

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