metadata: contig_metadata: 22 rows where bioproject = "PRJEB6584", tax_kingdom = "Bacillati" and tax

22 rows where bioproject = "PRJEB6584", tax_kingdom = "Bacillati" 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
25523480	25523480	PRJEB6584a_S_NODE_897_length_365_cov_4.890909_g877_i0	PRJEB6584	897	365	4.890909	17.85181785	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	375	1.81e-99	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g877	i0	86.034	218.608219178082	358	41	97	8	1	354	2201455	2201807	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	79792	375	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
25525559	25525559	PRJEB6584p_S_NODE_28713_length_172_cov_2.313869_g28682_i0	PRJEB6584	28713	172	2.313869	3.97985468	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	235	1.33e-57	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g28682	i0	96.479	90.3779069767442	142	5	83	0	1	142	1877991	1877850	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	15545	235	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
25615773	25615773	PRJEB6584b_S_NODE_8481_length_163_cov_3.281250_g8463_i0	PRJEB6584	8481	163	3.28125	5.3484375	Fimbriimonas	1005038	Bacteria	Bacteria	237	3.49e-58	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g8463	i0	93.711	142	159	8	97	2	4	161	29662	29505	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	23146	237	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25751936	25751936	PRJEB6584a_S_NODE_2530_length_233_cov_745.419192_g2510_i0	PRJEB6584	2530	233	745.419192	1736.82671736	Chthonomonas	1077265	Bacteria	Bacteria	174	4.27e-39	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g2510	i0	82.609	54.9656652360515	207	27	85	6	36	233	515	721	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	12807	174	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
25752572	25752572	PRJEB6584p_S_NODE_4266_length_209_cov_3.741379_g4235_i0	PRJEB6584	4266	209	3.741379	7.81948211	Fimbriimonas	1005038	Bacteria	Bacteria	217	6.14e-52	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g4235	i0	90.798	277.784688995215	163	13	78	2	47	209	28373	28533	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	58057	217	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25795756	25795756	PRJEB6584g_S_NODE_611_length_335_cov_4.016667_g599_i0	PRJEB6584	611	335	4.016667	13.45583445	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	597	3.239999999999999e-166	NTclustered	gi\|1187200751\|gb\|KY992724.1\|	157466	g599	i0	98.806	97.9970149253731	335	4	100	0	1	335	801	467	Uncultured Armatimonadetes bacterium clone Sp07PTArm_1 16S ribosomal RNA gene, partial sequence	blastn	32829	597	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
25797592	25797592	PRJEB6584p_S_NODE_32467_length_170_cov_6.651852_g32436_i0	PRJEB6584	32467	170	6.651852	11.3081484	uncultured Fimbriimonas sp.	1936177	Bacteria	Bacteria	303	3.55e-78	NTclustered	gi\|1154724300\|gb\|KX379253.1\|	1936177	g32436	i0	100	96.8235294117647	164	0	96	0	1	164	1062	1225	Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence	blastn	16460	303	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	uncultured Fimbriimonas sp.
25797608	25797608	PRJEB6584p_S_NODE_483_length_353_cov_10.522013_g452_i0	PRJEB6584	483	353	10.522013	37.14270589	Fimbriimonas ginsengisoli Gsoil 348	661478	Bacteria	Bacteria	422	2.21e-113	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g452	i0	89.79	67.8640226628895	333	29	93	5	24	353	29487	29817	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	23956	422	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25887707	25887707	PRJEB6584a_S_NODE_3251_length_210_cov_2.611429_g3231_i0	PRJEB6584	3251	210	2.6114289999999998	5.4840009	Chthonomonas	1077265	Bacteria	Bacteria	244	2.8299999999999997e-60	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g3231	i0	87.678	365.395238095238	211	25	100	1	1	210	1162	952	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	76733	244	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
25887867	25887867	PRJEB6584h_S_NODE_10851_length_199_cov_2.182927_g10789_i0	PRJEB6584	10851	199	2.182927	4.34402473	Chthonomonas	1077265	Bacteria	Bacteria	178	2.7299999999999998e-40	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g10789	i0	86.42	1.62814070351759	162	22	81	0	6	167	1310	1471	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	324	178	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
25887897	25887897	PRJEB6584i_S_NODE_163_length_457_cov_1.952607_g153_i0	PRJEB6584	163	457	1.952607	8.92341399	Chthonomonas	1077265	Bacteria	Bacteria	289	3.1e-73	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g153	i0	87.209	111.798687089716	258	27	91	6	204	457	1548	1803	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	51092	289	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
25887923	25887923	PRJEB6584l_S_NODE_11611_length_195_cov_2.637500_g11459_i0	PRJEB6584	11611	195	2.6375	5.143125	Fimbriimonas	1005038	Bacteria	Bacteria	294	2.54e-75	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11459	i0	93.846	162.497435897436	195	12	100	0	1	195	28741	28935	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	31687	294	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26023995	26023995	PRJEB6584a_S_NODE_444_length_482_cov_4.015660_g426_i0	PRJEB6584	444	482	4.01566	19.3554812	Chthonomonas	1077265	Bacteria	Bacteria	342	2.4899999999999998e-89	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g426	i0	87.838	118.03112033195	296	30	87	6	188	479	1548	1841	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	56891	342	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26024270	26024270	PRJEB6584l_S_NODE_8428_length_220_cov_1.870270_g8276_i0	PRJEB6584	8428	220	1.87027	4.114594	Fimbriimonas	1005038	Bacteria	Bacteria	291	3.79e-74	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g8276	i0	92.271	104.613636363636	207	13	93	3	6	210	29695	29490	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	23015	291	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26024605	26024605	PRJEB6584p_S_NODE_27004_length_173_cov_2.536232_g26973_i0	PRJEB6584	27004	173	2.536232	4.38768136	Fimbriimonas	1005038	Bacteria	Bacteria	252	1.33e-62	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g26973	i0	96.104	30.757225433526	154	6	89	0	1	154	27438	27285	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	5321	252	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26160461	26160461	PRJEB6584l_S_NODE_7669_length_228_cov_1.471503_g7517_i0	PRJEB6584	7669	228	1.471503	3.35502684	Fimbriimonas	1005038	Bacteria	Bacteria	289	1.42e-73	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7517	i0	90.498	261.447368421053	221	18	97	3	1	221	28582	28365	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	59610	289	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26296123	26296123	PRJEB6584i_S_NODE_9670_length_156_cov_5.066116_g9658_i0	PRJEB6584	9670	156	5.066116	7.90314096	Chthonomonas	1077265	Bacteria	Bacteria	137	3.45e-28	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g9658	i0	82.609	4.26923076923077	161	23	100	3	1	156	1299	1139	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	666	137	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26341932	26341932	PRJEB6584p_S_NODE_47783_length_162_cov_4.661417_g47752_i0	PRJEB6584	47783	162	4.661417	7.55149554	uncultured Fimbriimonas sp.	1936177	Bacteria	Bacteria	267	4.419999999999999e-67	NTclustered	gi\|1154724300\|gb\|KX379253.1\|	1936177	g47752	i0	99.32	84.4382716049383	147	1	91	0	11	157	1	147	Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence	blastn	13679	267	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	uncultured Fimbriimonas sp.
26431900	26431900	PRJEB6584a_S_NODE_5575_length_176_cov_5.361702_g5555_i0	PRJEB6584	5575	176	5.361702	9.43659552	Chthonomonas	1077265	Bacteria	Bacteria	254	3.79e-63	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g5555	i0	92.655	355.142045454545	177	12	100	1	1	176	2780	2604	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	62505	254	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
26432194	26432194	PRJEB6584l_S_NODE_7263_length_232_cov_501.761421_g7111_i0	PRJEB6584	7263	232	501.761421	1164.08649672	Fimbriimonas	1005038	Bacteria	Bacteria	147	9.25e-31	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7111	i0	95.604	30.5431034482759	91	4	39	0	132	222	26868	26958	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	7086	147	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26432550	26432550	PRJEB6584p_S_NODE_4127_length_210_cov_2.457143_g4096_i0	PRJEB6584	4127	210	2.457143	5.1600003	Fimbriimonas	1005038	Bacteria	Bacteria	268	1.6799999999999994e-67	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g4096	i0	93.37	352.180952380952	181	12	86	0	30	210	27532	27712	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	73958	268	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
26568561	26568561	PRJEB6584p_S_NODE_608_length_331_cov_6.155405_g577_i0	PRJEB6584	608	331	6.155405	20.37439055	Fimbriimonas	1005038	Bacteria	Bacteria	483	9.329999999999999e-132	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g577	i0	93.03	221.697885196375	330	23	99	0	1	330	28923	28594	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	73382	483	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);;