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

34 rows where bioproject = "PRJNA827593" 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
821544	821544	PRJNA827593_P_NODE_54481_length_269_cov_1.448980_g54182_i0	PRJNA827593	54481	269	1.44898	3.8977562	Deinococcus radiopugnans	57497	Bacteria	Bacteria	353	6.03e-93	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g54182	i0	90.37	44.1338289962825	270	24	100	2	1	269	132120	131852	Deinococcus swuensis strain DY59, complete genome	blastn	11872	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
2096874	2096874	PRJNA827593_P_NODE_47422_length_292_cov_1.054795_g47123_i0	PRJNA827593	47422	292	1.054795	3.0800014	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	429	1.07e-115	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g47123	i0	93.151	7.94178082191781	292	20	100	0	1	292	374307	374598	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2319	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
5924684	5924684	PRJNA827593_P_NODE_54065_length_270_cov_1.563452_g53766_i0	PRJNA827593	54065	270	1.563452	4.2213204	Deinococcus ficus	317577	Bacteria	Bacteria	355	1.6799999999999996e-93	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g53766	i0	90.476	194.859259259259	273	20	100	5	1	270	2342890	2342621	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	52612	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8474621	8474621	PRJNA827593_P_NODE_68387_length_239_cov_2.295181_g68088_i0	PRJNA827593	68387	239	2.295181	5.48548259	Deinococcus gobiensis	502394	Bacteria	Bacteria	377	3.12e-100	NTclustered	gi\|380002081\|gb\|CP002193.1\|	745776	g68088	i0	98.148	1.02092050209205	216	4	90	0	24	239	355414	355199	Deinococcus gobiensis I-0 plasmid P2, complete sequence	blastn	244	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9748953	9748953	PRJNA827593_P_NODE_22508_length_445_cov_1.768817_g22209_i0	PRJNA827593	22508	445	1.768817	7.87123565	Thermus aquaticus	271	Bacteria	Bacteria	769	0	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g22209	i0	99.527	139.478651685393	423	1	95	1	24	445	44360	44782	Thermus aquaticus Y51MC23, complete genome	blastn	62068	769	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
9749236	9749236	PRJNA827593_P_NODE_38628_length_327_cov_1.818898_g38329_i0	PRJNA827593	38628	327	1.818898	5.94779646	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	99	3.89e-16	NTclustered	gi\|2706841266\|gb\|CP149784.1\|	3112952	g38329	i0	80.769	2.26605504587156	130	21	39	4	26	153	83566	83439	Deinococcus sp. VB142 plasmid p1, complete sequence	blastn	741	99	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
9749727	9749727	PRJNA827593_P_NODE_66988_length_242_cov_1.822485_g66689_i0	PRJNA827593	66988	242	1.822485	4.4104137	Thermus sp. PS18	2849039	Bacteria	Bacteria	246	9.32e-61	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g66689	i0	85.837	1.9297520661157	233	31	96	2	10	241	314864	315095	Thermus sp. PS18 chromosome, complete genome	blastn	467	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
11432127	11432127	PRJNA827593_P_NODE_33329_length_356_cov_1.886926_g33030_i0	PRJNA827593	33329	356	1.886926	6.71745656	Deinococcus	1298	Bacteria	Bacteria	621	2.05e-173	NTclustered	gi\|1572647933\|gb\|MK511813.1\|	47478	g33030	i0	99.705	97.1207865168539	339	1	95	0	1	339	589	251	Deinococcus sp. strain BMS19D 16S ribosomal RNA gene, partial sequence	blastn	34575	621	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11432153	11432153	PRJNA827593_P_NODE_39409_length_323_cov_2.744000_g39110_i0	PRJNA827593	39409	323	2.744	8.86312	Deinococcus	1298	Bacteria	Bacteria	488	1.9499999999999998e-133	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g39110	i0	95.455	196.978328173375	308	11	94	3	1	305	1456	1763	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	63624	488	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
12300886	12300886	PRJNA827593_P_NODE_66410_length_243_cov_1.358824_g66111_i0	PRJNA827593	66410	243	1.358824	3.30194232	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	163	9.7e-36	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g66111	i0	79.747	8.30452674897119	237	38	95	9	3	234	772905	773136	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2018	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
13575179	13575179	PRJNA827593_P_NODE_64431_length_246_cov_1.121387_g64132_i0	PRJNA827593	64431	246	1.121387	2.75861202	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	259	1.22e-64	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g64132	i0	85.83	153.353658536585	247	32	100	3	1	246	543573	543329	Deinococcus sp. NW-56 chromosome, complete genome	blastn	37725	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15256297	15256297	PRJNA827593_P_NODE_15772_length_544_cov_1.590234_g15475_i0	PRJNA827593	15772	544	1.590234	8.65087296	Deinococcus	1298	Bacteria	Bacteria	1005	0	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g15475	i0	100	47.0165441176471	544	0	100	0	1	544	630423	630966	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	25577	1005	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16123467	16123467	PRJNA827593_P_NODE_19973_length_476_cov_2.054591_g19675_i0	PRJNA827593	19973	476	2.054591	9.77985316	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	306	6.229999999999998e-103	NR	WP_386844773.1	536443	g19675	i0	97.4	0.957983193277311	152	4	95.8	0	3	458	52	203	WP_386844773.1 metalloenzyme domain protein [Deinococcus taklimakanensis]	diamond	456	306	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
16123716	16123716	PRJNA827593_P_NODE_33533_length_355_cov_1.226950_g33234_i0	PRJNA827593	33533	355	1.22695	4.3556725	Thermus aquaticus	271	Bacteria	Bacteria	577	4.4799999999999986e-160	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g33234	i0	98.765	44.1830985915493	324	4	91	0	10	333	48999	48676	Thermus aquaticus Y51MC23, complete genome	blastn	15685	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
16123959	16123959	PRJNA827593_P_NODE_46793_length_294_cov_1.393665_g46494_i0	PRJNA827593	46793	294	1.393665	4.0973751	Deinococcus antarcticus	1298767	Bacteria	Bacteria	181	3.3799999999999996e-56	NR	WP_380076054.1	1298767	g46494	i0	88.7	0.989795918367347	97	11	99	0	292	2	46	142	WP_380076054.1 DinB family protein [Deinococcus antarcticus]	diamond	291	181	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
18672303	18672303	PRJNA827593_P_NODE_25575_length_414_cov_1.806452_g25276_i0	PRJNA827593	25575	414	1.806452	7.47871128	Deinococcus yunweiensis	367282	Bacteria	Bacteria	228	6.159999999999999e-55	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g25276	i0	77.193	2.69565217391304	399	85	95	5	21	414	2742218	2741821	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	1116	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
20354717	20354717	PRJNA827593_P_NODE_38016_length_330_cov_1.797665_g37717_i0	PRJNA827593	38016	330	1.797665	5.9322945	Deinococcus aerolatus	522487	Bacteria	Bacteria	69.3	5.17e-11	NR	WP_188970448.1	522487	g37717	i0	45.6	1.03636363636364	114	57	99.1	2	1	327	1441	1554	WP_188970448.1 DUF2272 domain-containing protein [Deinococcus aerolatus]	diamond	342	69.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aerolatus
21223008	21223008	PRJNA827593_P_NODE_24317_length_426_cov_1.745042_g24018_i0	PRJNA827593	24317	426	1.745042	7.43387892	Deinococcus metallilatus	1211322	Bacteria	Bacteria	427	5.839999999999999e-115	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g24018	i0	88.418	30.669014084507	354	41	83	0	31	384	2887362	2887009	Deinococcus metallilatus strain MA1002 chromosome	blastn	13065	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
21630429	21630429	PRJNA827593_P_NODE_57877_length_259_cov_2.897849_g57578_i0	PRJNA827593	57877	259	2.897849	7.50542891	Fervidobacterium	2422	Bacteria	Bacteria	113	1.07e-20	NTclustered	gi\|2793125101\|gb\|CP126499.1\|	2423	g57578	i0	93.421	26.3706563706564	76	5	29	0	9	84	1171855	1171780	Fervidobacterium islandicum strain H-21 chromosome, complete genome	blastn	6830	113	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
22497575	22497575	PRJNA827593_P_NODE_17698_length_510_cov_1.773455_g17400_i0	PRJNA827593	17698	510	1.773455	9.0446205	Deinococcus ficus	317577	Bacteria	Bacteria	863	0	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g17400	i0	98.763	56.7235294117647	485	6	95	0	17	501	321348	320864	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	28929	863	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
23773298	23773298	PRJNA827593_P_NODE_19799_length_479_cov_1.278325_g19501_i0	PRJNA827593	19799	479	1.278325	6.12317675	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	228	7.219999999999997e-55	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g19501	i0	78.415	11.7891440501044	366	68	75	9	1	361	232824	233183	Deinococcus sp. D7000 chromosome, complete genome	blastn	5647	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
23773417	23773417	PRJNA827593_P_NODE_26019_length_410_cov_1.786350_g25720_i0	PRJNA827593	26019	410	1.78635	7.324035	Thermus aquaticus	271	Bacteria	Bacteria	658	0	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g25720	i0	96.259	4.37073170731707	401	15	98	0	10	410	1951599	1951199	Thermus aquaticus Y51MC23, complete genome	blastn	1792	658	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
23773959	23773959	PRJNA827593_P_NODE_57699_length_260_cov_1.561497_g57400_i0	PRJNA827593	57699	260	1.561497	4.0598922	Deinococcus geothermalis	68909	Bacteria	Bacteria	459	1.19e-124	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g57400	i0	98.462	14.9346153846154	260	4	100	0	1	260	1959582	1959841	Deinococcus geothermalis DSM 11300, complete genome	blastn	3883	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
26642858	26642858	PRJNA827593_P_NODE_43261_length_307_cov_1.974359_g42962_i0	PRJNA827593	43261	307	1.974359	6.06128213	Deinococcus betulae	2873312	Bacteria	Bacteria	57.4	4.89e-7	NR	WP_224573642.1	2873312	g42962	i0	61	0.400651465798046	41	16	40.1	0	24	146	292	332	WP_224573642.1 ParB/RepB/Spo0J family partition protein [Deinococcus betulae]	diamond	123	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus betulae
27180713	27180713	PRJNA827593_P_NODE_42102_length_312_cov_1.518828_g41803_i0	PRJNA827593	42102	312	1.518828	4.73874336	Deinococcus aquiradiocola	393059	Bacteria	Bacteria	113	9.02e-27	NR	WP_188960334.1	393059	g41803	i0	100	0.548076923076923	57	0	54.8	0	311	141	529	585	WP_188960334.1 PQQ-binding-like beta-propeller repeat protein [Deinococcus aquiradiocola]	diamond	171	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquiradiocola
28002306	28002306	PRJNA827593_P_NODE_67965_length_241_cov_0.916667_g67666_i0	PRJNA827593	67965	241	0.916667	2.20916747	Deinococcus sp. KNUC121	47478	Bacteria	Bacteria	60.5	2.05e-8	NR	WP_239051809.1	2917691	g67666	i0	51.8	2.09128630705394	56	21	62.2	2	1	150	298	353	WP_239051809.1 M57 family metalloprotease [Deinococcus sp. KNUC1210]	diamond	504	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
28065255	28065255	PRJNA827593_P_NODE_52245_length_275_cov_2.801980_g51946_i0	PRJNA827593	52245	275	2.80198	7.705445	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	76.6	6.62e-14	NR	WP_386844361.1	536443	g51946	i0	43	1.01454545454545	93	50	98.2	2	272	3	852	944	WP_386844361.1 hypothetical protein [Deinococcus taklimakanensis]	diamond	279	76.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
28191299	28191299	PRJNA827593_P_NODE_33826_length_353_cov_1.400000_g33527_i0	PRJNA827593	33826	353	1.4	4.942	Deinococcus antarcticus	1298767	Bacteria	Bacteria	227	2.98e-71	NR	WP_380075471.1	1298767	g33527	i0	96.4	0.943342776203966	111	4	94.3	0	1	333	122	232	WP_380075471.1 NAD(P)/FAD-dependent oxidoreductase [Deinococcus antarcticus]	diamond	333	227	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
29233600	29233600	PRJNA827593_P_NODE_59629_length_255_cov_1.269231_g59330_i0	PRJNA827593	59629	255	1.269231	3.23653905	Deinococcus antarcticus	1298767	Bacteria	Bacteria	120	6.269999999999999e-32	NR	WP_380076602.1	1298767	g59330	i0	96.7	0.717647058823529	61	2	71.8	0	254	72	168	228	WP_380076602.1 HAD family hydrolase [Deinococcus antarcticus]	diamond	183	120	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30149145	30149145	PRJNA827593_P_NODE_66652_length_243_cov_0.905882_g66353_i0	PRJNA827593	66652	243	0.905882	2.20129326	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	72	1.45e-13	NR	WP_386843892.1	536443	g66353	i0	100	0.407407407407407	33	0	40.7	0	6	104	134	166	WP_386843892.1 pyridoxamine 5'-phosphate oxidase family protein [Deinococcus taklimakanensis]	diamond	99	72	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30402514	30402514	PRJNA827593_P_NODE_49233_length_285_cov_2.179245_g48934_i0	PRJNA827593	49233	285	2.179245	6.21084825	Deinococcus apachensis	309886	Bacteria	Bacteria	86.3	3.74e-18	NR	WP_019588719.1	309886	g48934	i0	65.7	1.4	67	20	69.5	2	200	3	1	65	WP_019588719.1 DNA/RNA non-specific endonuclease [Deinococcus apachensis]	diamond	399	86.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus apachensis
30623112	30623112	PRJNA827593_P_NODE_67813_length_241_cov_1.375000_g67514_i0	PRJNA827593	67813	241	1.375	3.31375	Deinococcus antarcticus	1298767	Bacteria	Bacteria	150	6.379999999999998e-42	NR	WP_380075471.1	1298767	g67514	i0	98.7	0.983402489626556	79	1	98.3	0	5	241	15	93	WP_380075471.1 NAD(P)/FAD-dependent oxidoreductase [Deinococcus antarcticus]	diamond	237	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
32741407	32741407	PRJNA827593_P_NODE_48700_length_287_cov_1.789720_g48401_i0	PRJNA827593	48700	287	1.78972	5.1364964	Deinococcus yavapaiensis	309889	Bacteria	Bacteria	57.4	4.13e-7	NR	WP_110884932.1	309889	g48401	i0	66.7	0.439024390243902	42	14	43.9	0	268	143	326	367	WP_110884932.1 glutathionylspermidine synthase family protein [Deinococcus yavapaiensis]	diamond	126	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
32835615	32835615	PRJNA827593_P_NODE_54200_length_270_cov_1.172589_g53901_i0	PRJNA827593	54200	270	1.172589	3.1659903	Deinococcus cavernae	2320857	Bacteria	Bacteria	134	1.81e-35	NR	WP_119763708.1	2320857	g53901	i0	79.3	2.71111111111111	82	17	91.1	0	3	248	300	381	WP_119763708.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Deinococcus cavernae]	diamond	732	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae

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