metadata: contig_metadata: 34 rows where analysis = "diamond", bioproject = "PRJNA757618" and tax

34 rows where analysis = "diamond", bioproject = "PRJNA757618" and tax_phylum = "Deinococcota"

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
2008539	2008539	PRJNA757618_P_NODE_29102_length_251_cov_1.308989_g28050_i0	PRJNA757618	29102	251	1.308989	3.28556239	Deinococcus daejeonensis	1007098	Bacteria	Bacteria	133	1.6199999999999998e-35	NR	WP_189059668.1	1007098	g28050	i0	80.7	0.99203187250996006	83	16	99.2	0	1	249	253	335	WP_189059668.1 sensor histidine kinase [Deinococcus daejeonensis]	diamond	249	133	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus daejeonensis
3283791	3283791	PRJNA757618_P_NODE_26583_length_253_cov_1.205556_g25531_i0	PRJNA757618	26583	253	1.205556	3.05005668	Deinococcus radiophilus	32062	Bacteria	Bacteria	131	7.239999999999998e-35	NR	WP_126352417.1	32062	g25531	i0	82.7	0.960474308300395	81	14	96	0	6	248	228	308	WP_126352417.1 FecCD family ABC transporter permease [Deinococcus radiophilus]	diamond	243	131	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
7111158	7111158	PRJNA757618_P_NODE_25326_length_257_cov_1.255435_g24274_i0	PRJNA757618	25326	257	1.255435	3.22646795	Deinococcus geothermalis	68909	Bacteria	Bacteria	89.7	1.31e-18	NR	WP_011529457.1	68909	g24274	i0	53.9	3.11673151750973	89	36	99.2	2	256	2	357	444	WP_011529457.1 DUF11 domain-containing protein [Deinococcus geothermalis]	diamond	801	89.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
17310712	17310712	PRJNA757618_P_NODE_36754_length_247_cov_0.896552_g35702_i0	PRJNA757618	36754	247	0.896552	2.21448344	Deinococcus aquaedulcis	2840455	Bacteria	Bacteria	160	1.61e-47	NR	WP_221090541.1	2840455	g35702	i0	98.8	1.96761133603239	81	1	98.4	0	245	3	72	152	WP_221090541.1 HAD-IA family hydrolase [Deinococcus aquaedulcis]	diamond	486	160	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaedulcis
21135195	21135195	PRJNA757618_P_NODE_39117_length_246_cov_0.901734_g38065_i0	PRJNA757618	39117	246	0.901734	2.21826564	Truepera radiovictrix	332249	Bacteria	Bacteria	140	1.95e-40	NR	WP_013177047.1	332249	g38065	i0	79	0.98780487804878	81	17	98.8	0	2	244	10	90	WP_013177047.1 disulfide oxidoreductase [Truepera radiovictrix]	diamond	243	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
22409826	22409826	PRJNA757618_P_NODE_26178_length_254_cov_1.408840_g25126_i0	PRJNA757618	26178	254	1.40884	3.5784536	Deinococcus budaensis	1665626	Bacteria	Bacteria	169	1e-49	NR	WP_343057654.1	1665626	g25126	i0	98.8	1.98425196850394	84	1	99.2	0	2	253	170	253	WP_343057654.1 sugar-binding transcriptional regulator [Deinococcus budaensis]	diamond	504	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
26641391	26641391	PRJNA757618_P_NODE_40741_length_245_cov_0.906977_g39689_i0	PRJNA757618	40741	245	0.906977	2.22209365	Deinococcus proteolyticus	55148	Bacteria	Bacteria	71.2	3.45e-12	NR	WP_148231752.1	55148	g39689	i0	73.3	0.73469387755102	60	13	72.2	2	67	243	1	58	WP_148231752.1 V-type ATP synthase subunit I [Deinococcus proteolyticus]	diamond	180	71.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
27021340	27021340	PRJNA757618_P_NODE_36442_length_247_cov_2.057471_g35390_i0	PRJNA757618	36442	247	2.057471	5.08195337	Deinococcus piscis	394230	Bacteria	Bacteria	140	2.23e-39	NR	GHG08658.1	394230	g35390	i0	92.8	0.838056680161943	69	5	83.8	0	40	246	1	69	GHG08658.1 hypothetical protein GCM10017783_21530 [Deinococcus piscis]	diamond	207	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
27147343	27147343	PRJNA757618_P_NODE_5602_length_556_cov_2.931677_g4552_i0	PRJNA757618	5602	556	2.931677	16.30012412	Deinococcus radiophilus	32062	Bacteria	Bacteria	289	3.19e-97	NR	WP_411675088.1	32062	g4552	i0	81.9	4.44604316546763	166	30	89.6	0	556	59	12	177	WP_411675088.1 IS630 family transposase [Deinococcus radiophilus]	diamond	2472	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
27526879	27526879	PRJNA757618_P_NODE_40043_length_246_cov_0.890173_g38991_i0	PRJNA757618	40043	246	0.890173	2.18982558	Deinococcus sp. Marseille-Q64	47478	Bacteria	Bacteria	106	4.61e-25	NR	WP_261663804.1	2969223	g38991	i0	88.1	1.4390243902439	59	7	72	0	178	2	1	59	WP_261663804.1 phosphoglycerate kinase [Deinococcus sp. Marseille-Q6407]	diamond	354	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Marseille-Q6407
27779648	27779648	PRJNA757618_P_NODE_9764_length_357_cov_2.063380_g8712_i0	PRJNA757618	9764	357	2.06338	7.3662666	Deinococcus piscis	394230	Bacteria	Bacteria	236	1.85e-76	NR	GHG08658.1	394230	g8712	i0	94.9	0.991596638655462	118	6	99.2	0	355	2	103	220	GHG08658.1 hypothetical protein GCM10017783_21530 [Deinococcus piscis]	diamond	354	236	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
27842477	27842477	PRJNA757618_P_NODE_36324_length_248_cov_0.874286_g35272_i0	PRJNA757618	36324	248	0.874286	2.16822928	Thermus	270	Bacteria	Bacteria	154	1.03e-42	NR	WP_253704860.1	270	g35272	i0	97.5	0.955645161290323	79	2	95.6	0	12	248	1	79	WP_253704860.1 MULTISPECIES: TROVE domain-containing protein [Thermus]	diamond	237	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
27874204	27874204	PRJNA757618_P_NODE_35225_length_248_cov_0.891429_g34173_i0	PRJNA757618	35225	248	0.891429	2.21074392	Deinococcus proteolyticus	55148	Bacteria	Bacteria	109	6.460000000000001e-27	NR	WP_013615364.1	55148	g34173	i0	78	1.98387096774194	82	18	99.2	0	2	247	112	193	WP_013615364.1 4-(cytidine 5'-diphospho)-2-C-methyl-D-erythritol kinase [Deinococcus proteolyticus]	diamond	492	109	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
28073395	28073395	PRJNA757618_P_NODE_13925_length_311_cov_0.978992_g12873_i0	PRJNA757618	13925	311	0.978992	3.04466512	Deinococcus	1298	Bacteria	Bacteria	111	2.33e-26	NR	MDO4264050.1	47478	g12873	i0	73.1	2.2572347266881	78	21	75.2	0	234	1	5	82	MDO4264050.1 transglycosylase domain-containing protein [Deinococcus sp.]	diamond	702	111	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28189715	28189715	PRJNA757618_P_NODE_12826_length_320_cov_1.870445_g11774_i0	PRJNA757618	12826	320	1.870445	5.985424	Deinococcus lacus	392561	Bacteria	Bacteria	177	8.5e-54	NR	WP_380083459.1	392561	g11774	i0	80.2	0.99375	106	21	99.4	0	318	1	6	111	WP_380083459.1 M15 family metallopeptidase [Deinococcus lacus]	diamond	318	177	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus lacus
28231090	28231090	PRJNA757618_P_NODE_49146_length_228_cov_2.574194_g48094_i0	PRJNA757618	49146	228	2.574194	5.86916232	Deinococcus	1298	Bacteria	Bacteria	125	1.4799999999999998e-31	NR	WP_233433682.1	1298	g48094	i0	86.7	6.90789473684211	75	10	98.7	0	3	227	342	416	WP_233433682.1 MULTISPECIES: copper-translocating P-type ATPase [Deinococcus]	diamond	1575	125	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
28357486	28357486	PRJNA757618_P_NODE_48366_length_242_cov_0.911243_g47314_i0	PRJNA757618	48366	242	0.911243	2.20520806	Deinococcus	1298	Bacteria	Bacteria	73.9	3.75e-13	NR	WP_229670830.1	393059	g47314	i0	53.8	1.98347107438017	80	37	99.2	0	241	2	644	723	WP_229670830.1 methyl-accepting chemotaxis protein [Deinococcus aquiradiocola]	diamond	480	73.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquiradiocola
28379373	28379373	PRJNA757618_P_NODE_31926_length_250_cov_0.875706_g30874_i0	PRJNA757618	31926	250	0.875706	2.189265	Truepera radiovictrix	332249	Bacteria	Bacteria	79	5.92e-15	NR	WP_013177681.1	332249	g30874	i0	53.8	0.96	80	24	91.2	3	235	8	6	76	WP_013177681.1 class I SAM-dependent rRNA methyltransferase [Truepera radiovictrix]	diamond	240	79	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
28726737	28726737	PRJNA757618_P_NODE_9527_length_362_cov_1.072664_g8475_i0	PRJNA757618	9527	362	1.072664	3.88304368	Deinococcus radiophilus	32062	Bacteria	Bacteria	92.4	1.68e-19	NR	WP_126352061.1	32062	g8475	i0	66.7	0.870165745856354	105	23	87	2	48	362	11	103	WP_126352061.1 ABC transporter substrate-binding protein [Deinococcus radiophilus]	diamond	315	92.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
28979477	28979477	PRJNA757618_P_NODE_45208_length_243_cov_0.917647_g44156_i0	PRJNA757618	45208	243	0.917647	2.22988221	Deinococcus piscis	394230	Bacteria	Bacteria	129	6.4e-33	NR	WP_189641918.1	394230	g44156	i0	74.1	2	81	20	100	1	1	243	144	223	WP_189641918.1 bifunctional metallophosphatase/5'-nucleotidase [Deinococcus piscis]	diamond	486	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
29105779	29105779	PRJNA757618_P_NODE_22548_length_266_cov_2.569948_g21496_i0	PRJNA757618	22548	266	2.569948	6.83606168	Deinococcus	1298	Bacteria	Bacteria	46.2	3.2e-4	NR	WP_013614158.1	1298	g21496	i0	57.1	0.473684210526316	42	18	47.4	0	113	238	35	76	WP_013614158.1 MULTISPECIES: hypothetical protein [Deinococcus]	diamond	126	46.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
29137440	29137440	PRJNA757618_P_NODE_30029_length_251_cov_0.870787_g28977_i0	PRJNA757618	30029	251	0.870787	2.18567537	Deinococcus piscis	394230	Bacteria	Bacteria	84.3	5.21e-19	NR	WP_189643277.1	394230	g28977	i0	67.6	1.49402390438247	68	22	81.3	0	48	251	1	68	WP_189643277.1 KH domain-containing protein [Deinococcus piscis]	diamond	375	84.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
29326520	29326520	PRJNA757618_P_NODE_17369_length_288_cov_1.813953_g16317_i0	PRJNA757618	17369	288	1.813953	5.22418464	Deinococcus murrayi	68910	Bacteria	Bacteria	80.5	2.07e-15	NR	WP_027461099.1	68910	g16317	i0	70.2	1.23958333333333	57	12	59.4	1	172	2	2	53	WP_027461099.1 tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Deinococcus murrayi]	diamond	357	80.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus murrayi
29326522	29326522	PRJNA757618_P_NODE_24449_length_260_cov_1.240642_g23397_i0	PRJNA757618	24449	260	1.240642	3.2256692	Deinococcus sp. Marseille-Q64	47478	Bacteria	Bacteria	129	3.07e-34	NR	WP_261665012.1	2969223	g23397	i0	77.9	0.992307692307692	86	19	99.2	0	3	260	101	186	WP_261665012.1 LysR family transcriptional regulator [Deinococcus sp. Marseille-Q6407]	diamond	258	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Marseille-Q6407
29494310	29494310	PRJNA757618_P_NODE_36850_length_247_cov_0.896552_g35798_i0	PRJNA757618	36850	247	0.896552	2.21448344	Deinococcus	1298	Bacteria	Bacteria	150	7.069999999999999e-45	NR	MDO4264274.1	47478	g35798	i0	86.6	2.98785425101215	82	11	99.6	0	2	247	59	140	MDO4264274.1 prolipoprotein diacylglyceryl transferase [Deinococcus sp.]	diamond	738	151	0.993377483443709	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
29926732	29926732	PRJNA757618_P_NODE_31931_length_250_cov_0.875706_g30879_i0	PRJNA757618	31931	250	0.875706	2.189265	Deinococcus sp.	47478	Bacteria	Bacteria	124	1.51e-33	NR	MDO4264138.1	47478	g30879	i0	77.8	2.916	81	18	97.2	0	3	245	50	130	MDO4264138.1 permease-like cell division protein FtsX [Deinococcus sp.]	diamond	729	124	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
30179207	30179207	PRJNA757618_P_NODE_45232_length_243_cov_0.917647_g44180_i0	PRJNA757618	45232	243	0.917647	2.22988221	uncultured Truepera sp.	543023	Bacteria	Bacteria	107	1.05e-27	NR	CAA9575695.1	543023	g44180	i0	71.6	0.827160493827161	67	19	82.7	0	43	243	19	85	CAA9575695.1 MAG: hypothetical protein AVDCRST_MAG86-2154 [uncultured Truepera sp.]	diamond	201	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
30252527	30252527	PRJNA757618_P_NODE_30812_length_250_cov_1.355932_g29760_i0	PRJNA757618	30812	250	1.355932	3.38983	Deinococcus	1298	Bacteria	Bacteria	131	7e-34	NR	WP_245532754.1	55148	g29760	i0	81.9	2.988	83	15	99.6	0	249	1	346	428	WP_245532754.1 N-acetylmuramoyl-L-alanine amidase family protein [Deinococcus proteolyticus]	diamond	747	131	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
30558258	30558258	PRJNA757618_P_NODE_33633_length_249_cov_0.880682_g32581_i0	PRJNA757618	33633	249	0.880682	2.19289818	Deinococcus lacus	392561	Bacteria	Bacteria	65.5	9.32e-11	NR	WP_380083180.1	392561	g32581	i0	85.7	0.867469879518072	35	5	42.2	0	241	137	164	198	WP_380083180.1 hypothetical protein [Deinococcus lacus]	diamond	216	65.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus lacus
30937770	30937770	PRJNA757618_P_NODE_4114_length_916_cov_4.161329_g3098_i0	PRJNA757618	4114	916	4.161329	38.11777364	Deinococcus cavernae	2320857	Bacteria	Bacteria	524	1.4299999999999994e-183	NR	WP_119760459.1	2320857	g3098	i0	83.9	0.998908296943231	305	49	99.9	0	1	915	33	337	WP_119760459.1 IS66 family transposase [Deinococcus cavernae]	diamond	915	524	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
31854530	31854530	PRJNA757618_P_NODE_33177_length_249_cov_0.886364_g32125_i0	PRJNA757618	33177	249	0.886364	2.20704636	Deinococcus piscis	394230	Bacteria	Bacteria	60.5	5.04e-9	NR	WP_189644002.1	394230	g32125	i0	56.6	1.26506024096386	53	23	63.9	0	89	247	1	53	WP_189644002.1 hypothetical protein [Deinococcus piscis]	diamond	315	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
32012825	32012825	PRJNA757618_P_NODE_38218_length_247_cov_0.885057_g37166_i0	PRJNA757618	38218	247	0.885057	2.18609079	Truepera sp.	2478917	Bacteria	Bacteria	90.9	3.26e-19	NR	MDE0528985.1	2478917	g37166	i0	50.6	0.959514170040486	79	39	96	0	243	7	205	283	MDE0528985.1 ABC transporter permease [Truepera sp.]	diamond	237	90.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera sp.
32171213	32171213	PRJNA757618_P_NODE_37938_length_247_cov_0.890805_g36886_i0	PRJNA757618	37938	247	0.890805	2.20028835	Deinococcus sp.	47478	Bacteria	Bacteria	119	1.11e-32	NR	WP_291426739.1	47478	g36886	i0	76.8	0.995951417004049	82	19	99.6	0	247	2	31	112	WP_291426739.1 hypothetical protein [Deinococcus sp.]	diamond	246	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
32329551	32329551	PRJNA757618_P_NODE_9399_length_364_cov_1.381443_g8347_i0	PRJNA757618	9399	364	1.381443	5.02845252	Deinococcus sp. Marseille-Q64	47478	Bacteria	Bacteria	104	3.31e-24	NR	WP_409996748.1	2969223	g8347	i0	55	0.914835164835165	111	48	89.8	1	328	2	143	253	WP_409996748.1 replication initiation protein [Deinococcus sp. Marseille-Q6407]	diamond	333	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Marseille-Q6407

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