metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax

19 rows where analysis = "blastn", bioproject = "PRJEB8827" 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
25529758	25529758	PRJEB8827e_S_NODE_6609_length_205_cov_7.411765_g6581_i0	PRJEB8827	6609	205	7.411765	15.19411825	uncultured Fimbriimonas sp.	1936177	Bacteria	Bacteria	303	4.48e-78	NTclustered	gi\|1154724300\|gb\|KX379253.1\|	1936177	g6581	i0	99.401	74.5073170731707	167	1	81	0	1	167	167	1	Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence	blastn	15274	303	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	uncultured Fimbriimonas sp.
25665457	25665457	PRJEB8827b_S_NODE_32786_length_173_cov_1.434783_g32734_i0	PRJEB8827	32786	173	1.434783	2.48217459	Fimbriimonas sp.	1936159	Bacteria	Bacteria	224	2.91e-54	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g32734	i0	93.377	74.1907514450867	151	10	87	0	23	173	1687595	1687745	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	12835	224	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
25753810	25753810	PRJEB8827b_S_NODE_18682_length_184_cov_1.543624_g18630_i0	PRJEB8827	18682	184	1.543624	2.84026816	Fimbriimonas	1005038	Bacteria	Bacteria	215	1.89e-51	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g18630	i0	89.474	6.47282608695652	171	17	93	1	1	171	28370	28201	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	1191	217	0.990783410138249	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25801628	25801628	PRJEB8827e_S_NODE_1043_length_373_cov_3.026627_g1015_i0	PRJEB8827	1043	373	3.026627	11.28931871	Fimbriimonas sp.	1936159	Bacteria	Bacteria	512	1.35e-140	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g1015	i0	94.065	870.879356568365	337	20	90	0	37	373	1687573	1687909	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	324838	512	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
25802508	25802508	PRJEB8827h_S_NODE_6843_length_197_cov_16.728395_g6824_i0	PRJEB8827	6843	197	16.728395	32.95493815	Fimbriimonas ginsengisoli Gsoil 348	661478	Bacteria	Bacteria	195	2.6799999999999997e-45	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g6824	i0	85.567	3.91878172588833	194	19	98	5	1	193	29850	29665	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	772	195	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25937824	25937824	PRJEB8827b_S_NODE_36484_length_167_cov_3.045455_g36432_i0	PRJEB8827	36484	167	3.045455	5.08590985	Fimbriimonas sp.	1936159	Bacteria	Bacteria	196	6.12e-46	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g36432	i0	88.095	4.91616766467066	168	16	100	3	1	167	1689155	1689319	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	821	196	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
26025946	26025946	PRJEB8827e_S_NODE_6788_length_204_cov_3.905325_g6760_i0	PRJEB8827	6788	204	3.905325	7.966863	Fimbriimonas	1005038	Bacteria	Bacteria	248	2.11e-61	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g6760	i0	90.86	288.833333333333	186	15	91	2	16	201	28372	28555	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	58922	248	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26074514	26074514	PRJEB8827f_S_NODE_925_length_375_cov_3.729412_g905_i0	PRJEB8827	925	375	3.729412	13.985295	Fimbriimonas sp.	1936159	Bacteria	Bacteria	512	1.36e-140	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g905	i0	94.065	866.165333333333	337	20	90	0	1	337	1687909	1687573	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	324812	512	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
26161971	26161971	PRJEB8827b_S_NODE_31877_length_174_cov_533.928058_g31825_i0	PRJEB8827	31877	174	533.928058	929.03482092	Fimbriimonas	1005038	Bacteria	Bacteria	178	2.31e-40	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g31825	i0	89.855	4.10919540229885	138	14	79	0	1	138	29649	29786	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	715	178	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26161979	26161979	PRJEB8827b_S_NODE_533_length_349_cov_3.477707_g481_i0	PRJEB8827	533	349	3.477707	12.13719743	Fimbriimonas	1005038	Bacteria	Bacteria	496	1.27e-135	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g481	i0	93.175	214.808022922636	337	23	97	0	13	349	28599	28935	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	74968	496	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26162112	26162112	PRJEB8827f_S_NODE_1885_length_298_cov_10.965779_g1865_i0	PRJEB8827	1885	298	10.965779	32.67802142	Fimbriimonas	1005038	Bacteria	Bacteria	244	4.26e-60	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1865	i0	90.052	90.9798657718121	191	16	100	3	1	189	29569	29758	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	27112	244	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26162136	26162136	PRJEB8827f_S_NODE_2957_length_253_cov_4.247706_g2937_i0	PRJEB8827	2957	253	4.247706	10.74669618	Fimbriimonas	1005038	Bacteria	Bacteria	366	7.22e-97	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g2937	i0	93.2	273.411067193676	250	15	99	2	1	250	28286	28533	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	69173	366	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26210565	26210565	PRJEB8827f_S_NODE_3278_length_243_cov_1316.014423_g3258_i0	PRJEB8827	3278	243	1316.014423	3197.91504789	uncultured Fimbriimonas sp.	1936177	Bacteria	Bacteria	287	5.52e-73	NTclustered	gi\|1154724300\|gb\|KX379253.1\|	1936177	g3258	i0	99.367	61.6131687242798	158	1	65	0	73	230	1	158	Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence	blastn	14972	287	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	uncultured Fimbriimonas sp.
26297775	26297775	PRJEB8827b_S_NODE_6454_length_203_cov_1.345238_g6402_i0	PRJEB8827	6454	203	1.345238	2.73083314	Fimbriimonas	1005038	Bacteria	Bacteria	263	7.51e-66	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g6402	i0	96.25	28.2906403940887	160	6	79	0	24	183	27442	27283	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	5743	263	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26346269	26346269	PRJEB8827f_S_NODE_1335_length_333_cov_6.362416_g1315_i0	PRJEB8827	1335	333	6.362416	21.18684528	uncultured Fimbriimonas sp.	1936177	Bacteria	Bacteria	562	1.17e-155	NTclustered	gi\|1154724300\|gb\|KX379253.1\|	1936177	g1315	i0	100	92.1801801801802	304	0	91	0	30	333	1244	941	Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence	blastn	30696	562	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	uncultured Fimbriimonas sp.
26433978	26433978	PRJEB8827f_S_NODE_167_length_597_cov_5.756228_g152_i0	PRJEB8827	167	597	5.756228	34.36468116	Fimbriimonas	1005038	Bacteria	Bacteria	845	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g152	i0	93.628	199.951423785595	565	36	95	0	1	565	29105	28541	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	119371	845	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26434136	26434136	PRJEB8827h_S_NODE_41887_length_162_cov_5.913386_g41868_i0	PRJEB8827	41887	162	5.913386	9.57968532	Fimbriimonas	1005038	Bacteria	Bacteria	159	7.72e-35	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g41868	i0	88.55	4.47530864197531	131	15	81	0	9	139	29646	29776	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	725	159	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26482431	26482431	PRJEB8827e_S_NODE_760_length_420_cov_18.685714_g732_i0	PRJEB8827	760	420	18.685714	78.4799988	Fimbriimonas ginsengisoli Gsoil 348	661478	Bacteria	Bacteria	435	3.44e-117	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g732	i0	88.064	57.1547619047619	377	32	89	9	48	420	29483	29850	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	24005	435	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26569900	26569900	PRJEB8827f_S_NODE_11376_length_178_cov_2.188811_g11356_i0	PRJEB8827	11376	178	2.188811	3.89608358	Fimbriimonas	1005038	Bacteria	Bacteria	145	2.4199999999999997e-30	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11356	i0	90.909	5.00561797752809	110	7	61	2	70	178	28099	27992	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	891	145	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);;