metadata: contig_metadata: 34 rows where bioproject = "PRJNA615351" and tax

34 rows where bioproject = "PRJNA615351" and tax_kingdom = "Thermotogati"

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
1150037	1150037	PRJNA615351_P_NODE_65441_length_542_cov_2.753452_g51783_i0	PRJNA615351	65441	542	2.753452	14.92370984	Deinococcus	1298	Bacteria	Bacteria	833	0	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g51783	i0	94.465	215.581180811808	542	28	100	1	1	542	71993	71454	Deinococcus puniceus strain DY1, complete genome	blastn	116845	833	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
1871820	1871820	PRJNA615351_P_NODE_48102_length_755_cov_3.284722_g36299_i0	PRJNA615351	48102	755	3.284722	24.7996511	Deinococcus ficus	317577	Bacteria	Bacteria	996	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g36299	i0	90.646	197.495364238411	759	58	100	9	1	755	2341927	2341178	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	149109	996	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1871869	1871869	PRJNA615351_P_NODE_562_length_5364_cov_19.501783_g121_i2	PRJNA615351	562	5364	19.501783	1046.07564012	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	56.5	0.043	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g121	i2	100	0.00559284116331096	30	0	1	0	4951	4980	350343	350372	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
3146452	3146452	PRJNA615351_P_NODE_167183_length_168_cov_1.962406_g153083_i0	PRJNA615351	167183	168	1.962406	3.29684208	Trueperaceae bacterium	2026798	Bacteria	Bacteria	195	2.22e-45	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g153083	i0	87.5	103.809523809524	168	21	100	0	1	168	2559879	2560046	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	17440	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4423423	4423423	PRJNA615351_P_NODE_58764_length_611_cov_3.796875_g45639_i0	PRJNA615351	58764	611	3.796875	23.19890625	Trueperaceae bacterium	2026798	Bacteria	Bacteria	350	1.92e-91	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g45639	i0	79.644	211.945990180033	506	88	82	14	1	500	2558545	2559041	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	129499	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4978052	4978052	PRJNA615351_P_NODE_112604_length_271_cov_70.970339_g98505_i0	PRJNA615351	112604	271	70.970339	192.32961869	root	1	Root_unresolved	Root_unresolved	466	7.49e-127	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g98505	i0	97.786	109.981549815498	271	5	99	1	1	270	850	580	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	29805	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
4978064	4978064	PRJNA615351_P_NODE_122544_length_243_cov_6.418269_g108444_i0	PRJNA615351	122544	243	6.418269	15.59639367	Deinococcus	1298	Bacteria	Bacteria	298	2.55e-76	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g108444	i0	88.934	215.353909465021	244	24	100	3	1	243	3060881	3061122	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	52331	300	0.993333333333333	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
4978083	4978083	PRJNA615351_P_NODE_138924_length_208_cov_1.861272_g124824_i0	PRJNA615351	138924	208	1.861272	3.87144576	Fervidobacterium	2422	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g124824	i0	99.519	162.918269230769	208	1	100	0	1	208	218	11	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	33887	379	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
4978128	4978128	PRJNA615351_P_NODE_175424_length_160_cov_1.352000_g161324_i0	PRJNA615351	175424	160	1.352	2.1632	Fervidobacterium	2422	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g161324	i0	99.375	101.29375	160	1	100	0	1	160	2277	2436	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	16207	291	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
5699255	5699255	PRJNA615351_P_NODE_181645_length_154_cov_2.689076_g167545_i0	PRJNA615351	181645	154	2.689076	4.14117704	Trueperaceae bacterium	2026798	Bacteria	Bacteria	174	2.59e-39	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g167545	i0	87.261	13.0454545454545	157	15	100	4	1	154	2559863	2559709	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	2009	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
6973994	6973994	PRJNA615351_P_NODE_143846_length_199_cov_6.329268_g129746_i0	PRJNA615351	143846	199	6.329268	12.59524332	Deinococcus taeanensis	2737050	Bacteria	Bacteria	279	7.280000000000001e-71	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g129746	i0	92	329.804020100502	200	14	100	2	1	199	2533	2335	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	65631	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
18447505	18447505	PRJNA615351_P_NODE_113295_length_269_cov_3.166667_g99196_i0	PRJNA615351	113295	269	3.166667	8.51833423	uncultured Deinococci bacterium	310701	Bacteria	Bacteria	436	5.819999999999999e-118	NTclustered	gi\|339645757\|gb\|JN032374.1\|	310701	g99196	i0	95.971	96.6914498141264	273	3	100	6	1	269	1	269	Uncultured Deinococci bacterium clone WeeA_B08 16S ribosomal RNA gene, partial sequence	blastn	26010	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci				uncultured Deinococci bacterium
19001338	19001338	PRJNA615351_P_NODE_111375_length_275_cov_8.900000_g97276_i0	PRJNA615351	111375	275	8.9	24.475	Deinococcus	1298	Bacteria	Bacteria	497	2.7e-136	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g97276	i0	99.273	297.952727272727	275	2	100	0	1	275	71385	71111	Deinococcus swuensis strain DY59, complete genome	blastn	81937	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
19001405	19001405	PRJNA615351_P_NODE_166875_length_169_cov_0.888060_g152775_i0	PRJNA615351	166875	169	0.88806	1.5008214	Thermus	270	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g152775	i0	100	148.005917159763	169	0	100	0	1	169	1387	1219	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	25013	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
19722102	19722102	PRJNA615351_P_NODE_11516_length_1917_cov_8.022317_g8275_i0	PRJNA615351	11516	1917	8.022317	153.78781689	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1910	0	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g8275	i0	85.776	325.150756390193	1856	205	95	40	1	1812	2560715	2558875	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	623314	1910	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
20276347	20276347	PRJNA615351_P_NODE_120996_length_247_cov_8.084906_g106896_i0	PRJNA615351	120996	247	8.084906	19.96971782	Deinococcus	1298	Bacteria	Bacteria	307	4.32e-79	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g106896	i0	91.15	221.603238866397	226	20	91	0	11	236	69401	69176	Deinococcus swuensis strain DY59, complete genome	blastn	54736	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
21551996	21551996	PRJNA615351_P_NODE_94557_length_342_cov_5.527687_g80468_i0	PRJNA615351	94557	342	5.527687	18.90468954	Truepera	332248	Bacteria	Bacteria	431	3.55e-116	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g80468	i0	89.443	418.412280701754	341	36	99	0	1	341	11	351	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	143097	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24821840	24821840	PRJNA615351_P_NODE_174400_length_161_cov_1.380952_g160300_i0	PRJNA615351	174400	161	1.380952	2.22333272	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g160300	i0	100	140.434782608696	161	0	100	0	1	161	409931	410091	Thermus sp. NEB1569 chromosome, complete genome	blastn	22610	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
27080427	27080427	PRJNA615351_P_NODE_20382_length_1449_cov_3.973126_g14153_i1	PRJNA615351	20382	1449	3.973126	57.57059574	Marinitoga aeolica	2809031	Bacteria	Bacteria	52	0.0061	NR	WP_280998107.1	2809031	g14153	i1	23.5	0.316770186335404	153	114	31.7	1	332	790	63	212	WP_280998107.1 methyl-accepting chemotaxis protein [Marinitoga aeolica]	diamond	459	52	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga aeolica
27093299	27093299	PRJNA615351_P_NODE_114582_length_266_cov_0.965368_g100483_i0	PRJNA615351	114582	266	0.965368	2.56787888	Bacteria	2	Bacteria	Bacteria	44.3	0.0143	NR	MBQ6969619.1	2053624	g100483	i0	38.9	2.3796992481203	54	23	60.9	1	163	2	672	715	MBQ6969619.1 hypothetical protein [Synergistaceae bacterium]	diamond	633	44.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27680927	27680927	PRJNA615351_P_NODE_152284_length_187_cov_1.052632_g138184_i0	PRJNA615351	152284	187	1.052632	1.96842184	Trueperaceae bacterium	2026798	Bacteria	Bacteria	42.4	0.0244	NR	MEX2534109.1	2026798	g138184	i0	38.3	0.962566844919786	60	33	89.8	1	7	174	239	298	MEX2534109.1 hypothetical protein [Trueperaceae bacterium]	diamond	180	42.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
28217071	28217071	PRJNA615351_P_NODE_111866_length_274_cov_1.665272_g97767_i0	PRJNA615351	111866	274	1.665272	4.56284528	Thermovirga lienii	336261	Bacteria	Bacteria	45.8	0.00403	NR	WP_014163196.1	336261	g97767	i0	60.5	0.843065693430657	43	14	47.1	2	267	139	240	279	WP_014163196.1 polyamine aminopropyltransferase [Thermovirga lienii]	diamond	231	45.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae	Thermovirga	Thermovirga lienii
28596576	28596576	PRJNA615351_P_NODE_90467_length_363_cov_2.222561_g76388_i0	PRJNA615351	90467	363	2.222561	8.06789643	Deinococcus carri	1211323	Bacteria	Bacteria	74.3	1e-12	NR	GAA5511987.1	1211323	g76388	i0	41.9	0.768595041322314	93	52	76	2	332	57	18	109	GAA5511987.1 hypothetical protein Dcar01_00701 [Deinococcus carri]	diamond	279	74.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus carri
29303843	29303843	PRJNA615351_P_NODE_93169_length_349_cov_2.547771_g79083_i0	PRJNA615351	93169	349	2.547771	8.89172079	Deinococcus	1298	Bacteria	Bacteria	51.2	1.3e-4	NR	WP_052351547.1	309888	g79083	i0	33.3	5.77650429799427	111	70	95.4	3	14	346	153	259	WP_052351547.1 Ig-like domain-containing protein [Deinococcus pimensis]	diamond	2016	51.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus pimensis
30965204	30965204	PRJNA615351_P_NODE_158274_length_179_cov_1.243056_g144174_i0	PRJNA615351	158274	179	1.243056	2.22507024	Allomeiothermus silvanus	52022	Bacteria	Bacteria	49.3	6.79e-5	NR	WP_013158102.1	52022	g144174	i0	45.8	3.93854748603352	48	23	75.4	1	144	10	93	140	WP_013158102.1 serine/threonine-protein kinase [Allomeiothermus silvanus]	diamond	705	49.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
31280998	31280998	PRJNA615351_P_NODE_135195_length_215_cov_1.777778_g121095_i0	PRJNA615351	135195	215	1.777778	3.8222227	Deinococcus oregonensis	1805970	Bacteria	Bacteria	50.4	4.23e-5	NR	WP_380007841.1	1805970	g121095	i0	41	0.851162790697674	61	33	80.9	1	1	174	46	106	WP_380007841.1 trypsin-like serine peptidase [Deinococcus oregonensis]	diamond	183	50.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus oregonensis
31376046	31376046	PRJNA615351_P_NODE_122376_length_244_cov_1.655502_g108276_i0	PRJNA615351	122376	244	1.655502	4.03942488	Synergistaceae bacterium	2053624	Bacteria	Bacteria	92.8	8.82e-20	NR	HOU33238.1	2053624	g108276	i0	55.8	5.68032786885246	77	34	94.7	0	239	9	99	175	HOU33238.1 S8 family serine peptidase [Synergistaceae bacterium]	diamond	1386	92.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31439170	31439170	PRJNA615351_P_NODE_19556_length_1483_cov_3.973066_g14153_i0	PRJNA615351	19556	1483	3.973066	58.92056878	Marinitoga aeolica	2809031	Bacteria	Bacteria	52	0.00634	NR	WP_280998107.1	2809031	g14153	i0	23.5	0.309507754551585	153	114	31	1	1118	660	63	212	WP_280998107.1 methyl-accepting chemotaxis protein [Marinitoga aeolica]	diamond	459	52	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga aeolica
31515728	31515728	PRJNA615351_P_NODE_38416_length_931_cov_3.946429_g28459_i0	PRJNA615351	38416	931	3.946429	36.74125399	Deinococcus	1298	Bacteria	Bacteria	202	1.59e-58	NR	WP_034388996.1	1540221	g28459	i0	40.5	6.83458646616541	299	155	95.1	6	38	922	82	361	WP_034388996.1 aldose epimerase family protein [Deinococcus sp. YIM 77859]	diamond	6363	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. YIM 77859
31660501	31660501	PRJNA615351_P_NODE_2397_length_3425_cov_5.661652_g1663_i0	PRJNA615351	2397	3425	5.661652	193.911581	Thermosipho africanus	2421	Bacteria	Bacteria	73.6	1.64e-9	NR	WP_051001529.1	2421	g1663	i0	29	0.362627737226277	207	126	17.3	7	478	1068	21	216	WP_051001529.1 M16 family metallopeptidase [Thermosipho africanus]	diamond	1242	73.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho africanus
31692346	31692346	PRJNA615351_P_NODE_40797_length_885_cov_2.283529_g30329_i0	PRJNA615351	40797	885	2.283529	20.20923165	Thermus sp. 2.9	1577051	Bacteria	Bacteria	53.1	3.96e-4	NR	WP_039459017.1	1577051	g30329	i0	37.5	0.271186440677966	80	47	26.1	1	470	240	115	194	WP_039459017.1 alpha/beta hydrolase [Thermus sp. 2.9]	diamond	240	53.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. 2.9
31831536	31831536	PRJNA615351_P_NODE_174957_length_160_cov_2.416000_g160857_i0	PRJNA615351	174957	160	2.416	3.8656	Bacteria	2	Bacteria	Bacteria	43.5	0.00626	NR	HOZ12969.1	2053689	g160857	i0	37.5	3.15	56	28	91.9	2	6	152	262	317	HOZ12969.1 glycosyltransferase family 4 protein [Thermotogota bacterium]	diamond	504	43.5	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32167031	32167031	PRJNA615351_P_NODE_17778_length_1561_cov_11.463303_g12856_i0	PRJNA615351	17778	1561	11.463303	178.94215983	Thermotogota bacterium	2053689	Bacteria	Bacteria	61.2	7.13e-6	NR	HCZ05867.1	2053689	g12856	i0	23.2	0.390134529147982	203	136	38.4	5	1229	630	144	329	HCZ05867.1 glutamate--tRNA ligase [Thermotogota bacterium]	diamond	609	61.2	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32452006	32452006	PRJNA615351_P_NODE_73259_length_474_cov_16.002278_g59299_i0	PRJNA615351	73259	474	16.002278	75.85079772	Geotoga petraea	28234	Bacteria	Bacteria	46.2	0.0165	NR	WP_135402796.1	28234	g59299	i0	30.4	0.436708860759494	69	48	43.7	0	13	219	4	72	WP_135402796.1 SDR family NAD(P)-dependent oxidoreductase [Geotoga petraea]	diamond	207	46.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Geotoga	Geotoga petraea

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