metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax

30 rows where analysis = "blastn", bioproject = "PRJEB14175" 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
25509707	25509707	PRJEB14175_P_NODE_45241_length_554_cov_58.196755_g43021_i0	PRJEB14175	45241	554	58.196755	322.4100227	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	363	2.2199999999999998e-95	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g43021	i0	82.423	0.759927797833935	421	69	76	5	10	428	383078	382661	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	421	363	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
25608961	25608961	PRJEB14175_P_NODE_207705_length_222_cov_2.894410_g205438_i0	PRJEB14175	207705	222	2.89441	6.4255902	Fimbriimonas	1005038	Bacteria	Bacteria	191	4e-44	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g205438	i0	83.495	91.1981981981982	206	32	92	2	1	205	29581	29785	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	20246	191	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25640764	25640764	PRJEB14175_P_NODE_183794_length_241_cov_4.177778_g181527_i0	PRJEB14175	183794	241	4.177778	10.06844498	Capsulimonas corticalis	2219043	Bacteria	Bacteria	86.1	2.14e-12	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g181527	i0	88.571	0.784232365145228	70	8	29	0	149	218	592724	592793	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	189	86.1	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
25641598	25641598	PRJEB14175_P_NODE_20266_length_813_cov_5.510638_g18423_i0	PRJEB14175	20266	813	5.510638	44.80148694	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	303	2.04e-77	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g18423	i0	77.329	186.768757687577	569	94	68	28	264	813	1307039	1306487	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	151843	303	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
25747765	25747765	PRJEB14175_P_NODE_84890_length_394_cov_15.024024_g82625_i0	PRJEB14175	84890	394	15.024024	59.19465456	Fimbriimonas	1005038	Bacteria	Bacteria	647	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g82625	i0	97.867	196.335025380711	375	7	95	1	21	394	27463	27089	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	77356	647	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25778190	25778190	PRJEB14175_P_NODE_210387_length_220_cov_3.283019_g208120_i0	PRJEB14175	210387	220	3.283019	7.2226418	Capsulimonas corticalis	2219043	Bacteria	Bacteria	254	4.98e-63	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g208120	i0	89.848	87.3045454545454	197	20	90	0	1	197	595376	595572	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	19207	254	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
25879170	25879170	PRJEB14175_P_NODE_114243_length_329_cov_18.279851_g111977_i0	PRJEB14175	114243	329	18.279851	60.14070979	Chthonomonas	1077265	Bacteria	Bacteria	213	1.34e-50	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g111977	i0	80.205	142.082066869301	293	51	88	7	20	308	2836	2547	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	46745	213	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
25881373	25881373	PRJEB14175_P_NODE_230395_length_208_cov_1.795918_g228127_i0	PRJEB14175	230395	208	1.795918	3.73550944	Fimbriimonas	1005038	Bacteria	Bacteria	158	3.7499999999999998e-34	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g228127	i0	90.909	19.7932692307692	121	6	56	5	22	138	28760	28641	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	4117	158	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25913393	25913393	PRJEB14175_P_NODE_189780_length_236_cov_5.097143_g187513_i0	PRJEB14175	189780	236	5.097143	12.02925748	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	291	4.119999999999999e-74	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g187513	i0	90.783	52.8220338983051	217	20	92	0	2	218	1878777	1878993	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	12466	291	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
25914577	25914577	PRJEB14175_P_NODE_218396_length_214_cov_26.228758_g216128_i0	PRJEB14175	218396	214	26.228758	56.12954212	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	130	8.47e-26	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g216128	i0	80.982	0.761682242990654	163	31	76	0	33	195	1500305	1500143	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	163	130	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
26019339	26019339	PRJEB14175_P_NODE_60460_length_477_cov_8.418269_g58205_i0	PRJEB14175	60460	477	8.418269	40.15514313	Chthonomonas	1077265	Bacteria	Bacteria	412	1.8499999999999998e-110	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g58205	i0	83.011	66.9224318658281	465	70	96	8	1	460	1750	1290	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	31922	412	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26049415	26049415	PRJEB14175_P_NODE_190757_length_235_cov_66.459770_g188490_i0	PRJEB14175	190757	235	66.45977	156.1804595	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	207	4.25e-49	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g188490	i0	85.096	78.9872340425532	208	25	87	6	6	210	667598	667394	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	18562	207	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
26051508	26051508	PRJEB14175_P_NODE_239869_length_206_cov_0.882759_g237601_i0	PRJEB14175	239869	206	0.882759	1.81848354	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	272	1.2699999999999996e-68	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g237601	i0	90.686	0.990291262135922	204	19	99	0	1	204	2336390	2336593	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	204	272	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
26052478	26052478	PRJEB14175_P_NODE_26469_length_718_cov_49.246575_g24445_i0	PRJEB14175	26469	718	49.246575	353.5904085	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	815	0	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g24445	i0	98.485	1.25626740947075	462	7	86	0	235	696	1428538	1428077	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	902	815	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
26154113	26154113	PRJEB14175_P_NODE_252709_length_203_cov_0.901408_g250441_i0	PRJEB14175	252709	203	0.901408	1.82985824	root	1	Root_unresolved	Root_unresolved	54.7	0.005	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g250441	i0	100	1.27093596059113	29	0	14	0	117	145	2105546	2105518	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	258	54.7	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
26182720	26182720	PRJEB14175_P_NODE_127150_length_308_cov_2.578947_g124883_i0	PRJEB14175	127150	308	2.578947	7.94315676	Fimbriimonas sp.	1936159	Bacteria	Bacteria	318	2.57e-82	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g124883	i0	90.283	74.4090909090909	247	19	79	3	45	286	1687570	1687816	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	22918	318	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
26187014	26187014	PRJEB14175_P_NODE_222198_length_212_cov_1.761589_g219930_i0	PRJEB14175	222198	212	1.761589	3.73456868	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	196	8.14e-46	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g219930	i0	84.925	7.47169811320755	199	25	92	5	1	196	126458	126654	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	1584	196	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
26187159	26187159	PRJEB14175_P_NODE_225710_length_210_cov_0.859060_g223442_i0	PRJEB14175	225710	210	0.85906	1.804026	Capsulimonas corticalis	2219043	Bacteria	Bacteria	128	2.98e-25	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g223442	i0	82.55	401.580952380952	149	23	70	3	56	201	594934	594786	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	84332	128	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
26288483	26288483	PRJEB14175_P_NODE_159030_length_266_cov_2.429268_g156763_i0	PRJEB14175	159030	266	2.429268	6.46185288	Bacteria	2	Bacteria	Bacteria	265	2.87e-66	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g156763	i0	85.328	12.390977443609	259	34	97	4	1	257	1550032	1550288	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	3296	267	0.99250936329588	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
26289225	26289225	PRJEB14175_P_NODE_201230_length_227_cov_2.644578_g198963_i0	PRJEB14175	201230	227	2.644578	6.00319206	Chthonomonas	1077265	Bacteria	Bacteria	130	9.08e-26	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g198963	i0	85.271	59.1894273127753	129	16	56	3	4	130	1654	1527	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	13436	130	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26321658	26321658	PRJEB14175_P_NODE_197439_length_230_cov_2.414201_g195172_i0	PRJEB14175	197439	230	2.414201	5.5526623	Capsulimonas corticalis	2219043	Bacteria	Bacteria	248	2.44e-61	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g195172	i0	88.038	424.382608695652	209	25	91	0	22	230	595507	595299	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	97608	248	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
26425923	26425923	PRJEB14175_P_NODE_245423_length_204_cov_3.013986_g243155_i0	PRJEB14175	245423	204	3.013986	6.14853144	Chthonomonas	1077265	Bacteria	Bacteria	213	7.71e-51	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g243155	i0	94.245	302.578431372549	139	8	68	0	20	158	1065	1203	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	61726	213	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26426263	26426263	PRJEB14175_P_NODE_267231_length_193_cov_3.462121_g264963_i0	PRJEB14175	267231	193	3.462121	6.68189353	Fimbriimonas	1005038	Bacteria	Bacteria	316	5.34e-82	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g264963	i0	98.87	233.119170984456	177	2	92	0	1	177	27094	27270	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	44992	316	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26427660	26427660	PRJEB14175_P_NODE_80047_length_408_cov_6.867435_g77785_i0	PRJEB14175	80047	408	6.867435	28.0191348	Fimbriimonas	1005038	Bacteria	Bacteria	531	4.13e-146	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g77785	i0	91.517	210.53921568627501	389	27	95	6	23	408	29163	28778	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	85900	531	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26455283	26455283	PRJEB14175_P_NODE_137760_length_292_cov_17.090909_g135493_i0	PRJEB14175	137760	292	17.090909	49.90545428	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	152	2.59e-32	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g135493	i0	80.612	21.7191780821918	196	38	67	0	8	203	667401	667596	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	6342	152	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
26458431	26458431	PRJEB14175_P_NODE_206568_length_223_cov_2.277778_g204301_i0	PRJEB14175	206568	223	2.277778	5.07944494	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	241	3.94e-59	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g204301	i0	89.231	194.995515695067	195	18	87	3	1	193	126458	126651	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	43484	241	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
26560142	26560142	PRJEB14175_P_NODE_148008_length_279_cov_3.568807_g145741_i0	PRJEB14175	148008	279	3.568807	9.95697153	Chthonomonas	1077265	Bacteria	Bacteria	241	5.11e-59	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g145741	i0	83.333	262.978494623656	264	40	93	4	1	260	1027	764	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	73371	241	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26560486	26560486	PRJEB14175_P_NODE_166040_length_258_cov_8.736041_g163773_i0	PRJEB14175	166040	258	8.736041	22.53898578	Fimbriimonas	1005038	Bacteria	Bacteria	209	1.32e-49	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g163773	i0	84.906	27.7945736434109	212	26	81	6	3	211	29573	29781	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	7171	209	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26560502	26560502	PRJEB14175_P_NODE_167016_length_257_cov_8.576531_g164749_i0	PRJEB14175	167016	257	8.576531	22.04168467	Chthonomonas	1077265	Bacteria	Bacteria	237	6.01e-58	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g164749	i0	84.937	117.836575875486	239	30	92	6	22	257	1953	2188	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	30284	237	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26561056	26561056	PRJEB14175_P_NODE_195984_length_231_cov_3.929412_g193717_i0	PRJEB14175	195984	231	3.929412	9.07694172	Fimbriimonas	1005038	Bacteria	Bacteria	228	3.1999999999999998e-55	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g193717	i0	86.667	19.7445887445887	210	22	89	6	1	206	27934	28141	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	4561	228	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);;