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

26 rows where analysis = "blastn", bioproject = "PRJNA946307" 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
1260384	1260384	PRJNA946307_P_NODE_25961_length_253_cov_2.416667_g25087_i0	PRJNA946307	25961	253	2.416667	6.11416751	Bacteria	2	Bacteria	Bacteria	230	9.879999999999999e-56	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g25087	i0	84.956	244.276679841897	226	34	89	0	28	253	3407424	3407199	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	61802	230	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
2200958	2200958	PRJNA946307_P_NODE_107922_length_180_cov_4.167939_g107048_i0	PRJNA946307	107922	180	4.167939	7.5022902	Armatimonadota bacterium	2033014	Bacteria	Bacteria	180	6.71e-41	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g107048	i0	93.388	235.294444444444	121	8	67	0	57	177	1692876	1692756	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	42353	180	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
2201840	2201840	PRJNA946307_P_NODE_161262_length_162_cov_1.522124_g160388_i0	PRJNA946307	161262	162	1.522124	2.46584088	Chthonomonas calidirosea	454171	Bacteria	Bacteria	75	2.88e-9	NTclustered	gi\|510021827\|emb\|HF951689.1\|	1303518	g160388	i0	80.198	0.876543209876543	101	18	62	2	57	156	3014550	3014649	Chthonomonas calidirosea T49 complete genome	blastn	142	75	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
2535826	2535826	PRJNA946307_P_NODE_150962_length_164_cov_3.904348_g150088_i0	PRJNA946307	150962	164	3.904348	6.40313072	Capsulimonas	2494209	Bacteria	Bacteria	161	2.1799999999999997e-35	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g150088	i0	86	644.207317073171	150	21	91	0	15	164	3407334	3407185	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	105650	161	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
3477928	3477928	PRJNA946307_P_NODE_37423_length_216_cov_5.922156_g36549_i0	PRJNA946307	37423	216	5.922156	12.79185696	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	285	1.73e-72	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g36549	i0	92.118	236.296296296296	203	14	94	2	1	202	668309	668108	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	51040	285	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
3812027	3812027	PRJNA946307_P_NODE_132283_length_170_cov_1.355372_g131409_i0	PRJNA946307	132283	170	1.355372	2.3041324	Fimbriimonas	1005038	Bacteria	Bacteria	268	1.3e-67	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g131409	i0	97.452	462.9	157	4	92	0	2	158	26934	27090	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	78693	268	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
6029466	6029466	PRJNA946307_P_NODE_143845_length_166_cov_1.717949_g142971_i0	PRJNA946307	143845	166	1.717949	2.85179534	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	252	1.28e-62	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g142971	i0	96.689	138.536144578313	151	5	91	0	14	164	1877987	1877837	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	22997	252	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
6363888	6363888	PRJNA946307_P_NODE_11765_length_387_cov_2.085799_g10903_i0	PRJNA946307	11765	387	2.085799	8.07204213	Bacteria	2	Bacteria	Bacteria	209	2.07e-49	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g10903	i0	82.979	82.8863049095607	235	36	60	4	32	264	2200804	2201036	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	32077	211	0.990521327014218	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
8579755	8579755	PRJNA946307_P_NODE_21087_length_278_cov_5.449782_g20214_i0	PRJNA946307	21087	278	5.449782	15.15039396	Capsulimonas corticalis	2219043	Bacteria	Bacteria	292	1.39e-74	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g20214	i0	85.932	91.0323741007194	263	30	93	6	20	278	593767	593508	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	25307	292	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
8912735	8912735	PRJNA946307_P_NODE_129787_length_171_cov_1.549180_g128913_i0	PRJNA946307	129787	171	1.54918	2.6490978	Fimbriimonas	1005038	Bacteria	Bacteria	148	1.78e-31	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g128913	i0	83.648	81.5672514619883	159	24	92	2	1	158	29552	29709	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	13948	148	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8913709	8913709	PRJNA946307_P_NODE_8507_length_472_cov_9.023641_g7684_i0	PRJNA946307	8507	472	9.023641	42.59158552	Fimbriimonas	1005038	Bacteria	Bacteria	385	3.99e-102	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7684	i0	81.996	13.9851694915254	461	75	97	7	15	471	28445	27989	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	6601	385	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8913740	8913740	PRJNA946307_P_NODE_89987_length_189_cov_0.857143_g89113_i0	PRJNA946307	89987	189	0.857143	1.62000027	Fimbriimonas	1005038	Bacteria	Bacteria	161	2.5799999999999996e-35	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g89113	i0	83.051	144.31746031746	177	30	94	0	13	189	29739	29563	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	27276	161	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
10189108	10189108	PRJNA946307_P_NODE_23348_length_265_cov_7.111111_g22474_i0	PRJNA946307	23348	265	7.111111	18.84444415	Fimbriimonas	1005038	Bacteria	Bacteria	291	4.71e-74	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g22474	i0	87.698	147.833962264151	252	28	95	3	15	265	28849	28600	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	39176	291	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
10189763	10189763	PRJNA946307_P_NODE_94848_length_186_cov_3.240876_g93974_i0	PRJNA946307	94848	186	3.240876	6.02802936	Armatimonadota	67819	Bacteria	Bacteria	76.8	9.44e-10	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g93974	i0	100	2.40860215053763	41	0	22	0	1	41	1688808	1688768	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	448	76.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
11464830	11464830	PRJNA946307_P_NODE_99029_length_184_cov_4.703704_g98155_i0	PRJNA946307	99029	184	4.703704	8.65481536	Bacteria	2	Bacteria	Bacteria	252	1.44e-62	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g98155	i0	94.479	97.7065217391304	163	9	89	0	15	177	1548613	1548451	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	17978	252	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
12405368	12405368	PRJNA946307_P_NODE_14110_length_345_cov_11.439189_g13240_i0	PRJNA946307	14110	345	11.439189	39.46520205	Capsulimonas corticalis	2219043	Bacteria	Bacteria	368	2.85e-97	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g13240	i0	89.86	454.313043478261	286	29	83	0	46	331	594015	594300	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	156738	368	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
14954281	14954281	PRJNA946307_P_NODE_150692_length_165_cov_0.879310_g149818_i0	PRJNA946307	150692	165	0.87931	1.4508615	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g149818	i0	100	0.175757575757576	29	0	18	0	117	145	1160039	1160011	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
14955431	14955431	PRJNA946307_P_NODE_5592_length_608_cov_8.180680_g4868_i0	PRJNA946307	5592	608	8.18068	49.7385344	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	771	0	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g4868	i0	90.909	221.680921052632	583	39	95	11	20	599	2201547	2202118	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	134782	771	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
16230132	16230132	PRJNA946307_P_NODE_38433_length_214_cov_7.151515_g37559_i0	PRJNA946307	38433	214	7.151515	15.3042421	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	167	6.449999999999999e-37	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g37559	i0	96.97	7.73831775700935	99	3	46	0	4	102	1877588	1877686	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	1656	167	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
16563282	16563282	PRJNA946307_P_NODE_58173_length_210_cov_2.540373_g57299_i0	PRJNA946307	58173	210	2.540373	5.3347833	Fimbriimonas	1005038	Bacteria	Bacteria	174	3.77e-39	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g57299	i0	81.373	48.6047619047619	204	27	94	7	14	210	28598	28399	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	10207	174	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17837526	17837526	PRJNA946307_P_NODE_148814_length_165_cov_1.379310_g147940_i0	PRJNA946307	148814	165	1.37931	2.2758615	Fimbriimonas	1005038	Bacteria	Bacteria	169	1.31e-37	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g147940	i0	86.928	113.836363636364	153	16	92	4	14	164	29714	29564	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	18783	169	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18779687	18779687	PRJNA946307_P_NODE_78875_length_195_cov_2.013699_g78001_i0	PRJNA946307	78875	195	2.013699	3.92671305	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	78.7	2.78e-10	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g78001	i0	76.667	1.6	150	29	75	6	49	195	2201438	2201584	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	312	78.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
20387231	20387231	PRJNA946307_P_NODE_8156_length_484_cov_8.473563_g7344_i0	PRJNA946307	8156	484	8.473563	41.01204492	Fimbriimonas	1005038	Bacteria	Bacteria	385	4.09e-102	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7344	i0	89.769	148.76652892562	303	28	80	3	6	306	29771	29470	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	72003	385	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
21329877	21329877	PRJNA946307_P_NODE_72197_length_198_cov_6.275168_g71323_i0	PRJNA946307	72197	198	6.275168	12.42483264	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	128	2.77e-25	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g71323	i0	96.154	86.9646464646465	78	3	39	0	14	91	667956	668033	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	17219	128	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
22603756	22603756	PRJNA946307_P_NODE_16918_length_312_cov_29.927757_g16047_i0	PRJNA946307	16918	312	29.927757	93.37460184	Fimbriimonas sp.	1936159	Bacteria	Bacteria	233	9.71e-57	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g16047	i0	81.063	738.246794871795	301	50	96	6	15	312	1690489	1690193	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	230333	233	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
24211504	24211504	PRJNA946307_P_NODE_12219_length_377_cov_5.341463_g11354_i0	PRJNA946307	12219	377	5.341463	20.13731551	Fimbriimonas	1005038	Bacteria	Bacteria	516	1.06e-141	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11354	i0	91.328	158.339522546419	369	24	96	5	15	376	27438	27071	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	59694	516	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);;