metadata: contig_metadata: 30 rows where bioproject = "PRJNA1111077" and tax

30 rows where bioproject = "PRJNA1111077" 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
214669	214669	PRJNA1111077_P_NODE_24981_length_270_cov_1.482234_g24760_i0	PRJNA1111077	24981	270	1.482234	4.0020318	Thermus caldilimi	2483360	Bacteria	Bacteria	267	8.12e-67	NTclustered	gi\|1608424790\|gb\|CP038452.1\|	2483360	g24760	i0	86.42	3.6	243	33	90	0	1	243	536950	536708	Thermus caldilimi strain YIM 78456 chromosome, complete genome	blastn	972	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus caldilimi
214738	214738	PRJNA1111077_P_NODE_28001_length_259_cov_1.317204_g27780_i0	PRJNA1111077	28001	259	1.317204	3.41155836	Deinococcus yunweiensis	367282	Bacteria	Bacteria	418	2.0199999999999998e-112	NTclustered	gi\|2890656794\|gb\|CP177253.1\|	367282	g27780	i0	95.753	1	259	11	100	0	1	259	445221	444963	Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP1, complete sequence	blastn	259	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
3571643	3571643	PRJNA1111077_P_NODE_21603_length_281_cov_7.894231_g21382_i0	PRJNA1111077	21603	281	7.8942310000000004	22.18278911	FCB group	1783270	Bacteria	Bacteria	162	4.49e-49	NR	WP_119356658.1	863370	g21382	i0	86	8.93594306049822	93	13	99.3	0	281	3	15	107	WP_119356658.1 5-(carboxyamino)imidazole ribonucleotide mutase [Meiothermus granaticius]	diamond	2511	162	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus granaticius
3571693	3571693	PRJNA1111077_P_NODE_28003_length_259_cov_1.306452_g27782_i0	PRJNA1111077	28003	259	1.306452	3.38371068	PVC group	1783257	Bacteria	Bacteria	105	9.34e-27	NR	WP_119316215.1	1408545	g27782	i0	75	3.74131274131274	64	16	74.1	0	2	193	80	143	WP_119316215.1 GNAT family N-acetyltransferase [Calidithermus terrae]	diamond	969	106	0.990566037735849	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus terrae
5317564	5317564	PRJNA1111077_P_NODE_23565_length_275_cov_1.376238_g23344_i0	PRJNA1111077	23565	275	1.376238	3.7846545	Deinococcus metallilatus	1211322	Bacteria	Bacteria	368	2.21e-97	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g23344	i0	90.909	1	275	23	99	2	1	274	270034	269761	Deinococcus metallilatus strain MA1002 chromosome	blastn	275	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
5317676	5317676	PRJNA1111077_P_NODE_28085_length_258_cov_2.702703_g27864_i0	PRJNA1111077	28085	258	2.702703	6.97297374	Trueperaceae bacterium	2026798	Bacteria	Bacteria	355	1.6e-93	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g27864	i0	91.506	15	259	20	100	2	1	258	6986	6729	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	3870	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7867243	7867243	PRJNA1111077_P_NODE_16207_length_309_cov_5.754237_g15986_i0	PRJNA1111077	16207	309	5.754237	17.78059233	Deinococcus aetherius	200252	Bacteria	Bacteria	147	1.29e-30	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g15986	i0	86.667	48.4239482200647	135	14	43	3	3	136	81648	81779	Deinococcus aetherius ST0316 DNA, complete genome	blastn	14963	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
7867642	7867642	PRJNA1111077_P_NODE_33087_length_247_cov_0.885057_g32866_i0	PRJNA1111077	33087	247	0.885057	2.18609079	Deinococcus yunweiensis	367282	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g32866	i0	98.381	2	247	4	100	0	1	247	1203984	1204230	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	494	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
8674298	8674298	PRJNA1111077_P_NODE_25187_length_269_cov_1.903061_g24966_i0	PRJNA1111077	25187	269	1.903061	5.11923409	Deinococcus	1298	Bacteria	Bacteria	87.9	6.76e-13	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g24966	i0	96.226	0.394052044609665	53	2	20	0	217	269	1104335	1104283	Deinococcus swuensis strain DY59, complete genome	blastn	106	87.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
10418038	10418038	PRJNA1111077_P_NODE_20289_length_286_cov_1.286385_g20068_i0	PRJNA1111077	20289	286	1.286385	3.6790611	Thermus scotoductus	37636	Bacteria	Bacteria	499	7.85e-137	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g20068	i0	99.634	18.6468531468531	273	1	95	0	1	273	993219	993491	Thermus scotoductus SA-01, complete genome	blastn	5333	499	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10418069	10418069	PRJNA1111077_P_NODE_21529_length_282_cov_1.277512_g21308_i0	PRJNA1111077	21529	282	1.277512	3.60258384	Deinococcus aetherius	200252	Bacteria	Bacteria	255	1.85e-63	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g21308	i0	89.604	2.58510638297872	202	20	72	1	1	202	97646	97446	Deinococcus aetherius ST0316 DNA, complete genome	blastn	729	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
12968629	12968629	PRJNA1111077_P_NODE_28031_length_259_cov_1.010753_g27810_i0	PRJNA1111077	28031	259	1.010753	2.61785027	Thermus thermophilus	274	Bacteria	Bacteria	468	1.98e-127	NTclustered	gi\|383508497\|gb\|CP003252.1\|	798128	g27810	i0	99.228	41.1853281853282	259	2	100	0	1	259	615822	615564	Thermus thermophilus JL-18, complete genome	blastn	10667	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
14243397	14243397	PRJNA1111077_P_NODE_19612_length_288_cov_1.646512_g19391_i0	PRJNA1111077	19612	288	1.646512	4.74195456	Deinococcus yunweiensis	367282	Bacteria	Bacteria	531	2.81e-146	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g19391	i0	100	2.32291666666667	287	0	99	0	1	287	860656	860942	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	669	531	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
14243744	14243744	PRJNA1111077_P_NODE_33592_length_246_cov_0.890173_g33371_i0	PRJNA1111077	33592	246	0.890173	2.18982558	Truepera sp.	2478917	Bacteria	Bacteria	120	1.18e-30	NR	MBS3934030.1	2478917	g33371	i0	73.2	1	82	22	100	0	1	246	90	171	MBS3934030.1 DNA-processing protein DprA [Truepera sp.]	diamond	246	120	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera sp.
15048829	15048829	PRJNA1111077_P_NODE_28492_length_257_cov_1.532609_g28271_i0	PRJNA1111077	28492	257	1.532609	3.93880513	Bacteria	2	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g28271	i0	100	133.828793774319	254	0	99	0	4	257	308	55	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	34394	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
18066384	18066384	PRJNA1111077_P_NODE_25855_length_267_cov_1.221649_g25634_i0	PRJNA1111077	25855	267	1.221649	3.26180283	Deinococcus yunweiensis	367282	Bacteria	Bacteria	483	7.31e-132	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g25634	i0	99.251	2	267	2	100	0	1	267	2399980	2399714	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	534	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
20615789	20615789	PRJNA1111077_P_NODE_22077_length_280_cov_1.458937_g21856_i0	PRJNA1111077	22077	280	1.458937	4.0850236	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	363	1.0499999999999999e-95	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g21856	i0	90.036	38.0178571428571	281	26	100	2	1	280	482569	482290	Thermus sp. NEB1569 chromosome, complete genome	blastn	10645	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
20616051	20616051	PRJNA1111077_P_NODE_32977_length_247_cov_0.885057_g32756_i0	PRJNA1111077	32977	247	0.885057	2.18609079	Meiothermus ruber	277	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g32756	i0	98.785	7.52631578947368	247	3	100	0	1	247	850499	850253	Meiothermus ruber DSM 1279, complete genome	blastn	1859	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
21891500	21891500	PRJNA1111077_P_NODE_23818_length_274_cov_1.532338_g23597_i0	PRJNA1111077	23818	274	1.532338	4.19860612	uncultured Truepera sp.	543023	Bacteria	Bacteria	110	1.85e-26	NR	CAA9574229.1	543023	g23597	i0	65.9	0.996350364963504	91	20	99.6	1	2	274	50	129	CAA9574229.1 MAG: Aspartate aminotransferase (AspB-4) [uncultured Truepera sp.]	diamond	273	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
21891513	21891513	PRJNA1111077_P_NODE_24378_length_272_cov_1.547739_g24157_i0	PRJNA1111077	24378	272	1.547739	4.20985008	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	361	3.65e-95	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g24157	i0	90.741	18.8639705882353	270	25	99	0	1	270	1803366	1803635	Deinococcus sp. NW-56 chromosome, complete genome	blastn	5131	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
23167199	23167199	PRJNA1111077_P_NODE_31239_length_249_cov_1.823864_g31018_i0	PRJNA1111077	31239	249	1.823864	4.54142136	Deinococcus yunweiensis	367282	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g31018	i0	98.394	7.93172690763052	249	4	100	0	1	249	1475532	1475284	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	1975	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
26687889	26687889	PRJNA1111077_P_NODE_34221_length_245_cov_0.895349_g34000_i0	PRJNA1111077	34221	245	0.895349	2.19360505	Trueperaceae bacterium	2026798	Bacteria	Bacteria	102	3.0299999999999996e-23	NR	MCA9838910.1	2026798	g34000	i0	59.5	1.02857142857143	84	31	99.2	1	2	244	226	309	MCA9838910.1 hypothetical protein [Trueperaceae bacterium]	diamond	252	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
27763003	27763003	PRJNA1111077_P_NODE_27104_length_262_cov_2.084656_g26883_i0	PRJNA1111077	27104	262	2.084656	5.46179872	uncultured Truepera sp.	543023	Bacteria	Bacteria	135	3.54e-36	NR	CAA9586192.1	543023	g26883	i0	77.6	0.973282442748092	85	19	97.3	0	6	260	207	291	CAA9586192.1 MAG: Spore photoproduct lyase [uncultured Truepera sp.]	diamond	255	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27920533	27920533	PRJNA1111077_P_NODE_36285_length_241_cov_4.589286_g36064_i0	PRJNA1111077	36285	241	4.589286	11.06017926	uncultured Truepera sp.	543023	Bacteria	Bacteria	53.9	2.83e-7	NR	CAA9564092.1	543023	g36064	i0	72.7	0.410788381742739	33	9	41.1	0	107	9	1	33	CAA9564092.1 MAG: hypothetical protein AVDCRST_MAG86-884 [uncultured Truepera sp.]	diamond	99	53.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
28046870	28046870	PRJNA1111077_P_NODE_29985_length_251_cov_1.640449_g29764_i0	PRJNA1111077	29985	251	1.640449	4.11752699	uncultured Truepera sp.	543023	Bacteria	Bacteria	93.6	6.7e-21	NR	CAA9583997.1	543023	g29764	i0	70.3	0.884462151394422	74	22	88.4	0	226	5	135	208	CAA9583997.1 MAG: hypothetical protein AVDCRST_MAG86-3508 [uncultured Truepera sp.]	diamond	222	93.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
28867789	28867789	PRJNA1111077_P_NODE_24468_length_272_cov_1.195980_g24247_i0	PRJNA1111077	24468	272	1.19598	3.2530656	uncultured Truepera sp.	543023	Bacteria	Bacteria	109	6.44e-28	NR	CAA9564541.1	543023	g24247	i0	67.4	0.948529411764706	86	27	93.8	1	2	256	87	172	CAA9564541.1 MAG: hypothetical protein AVDCRST_MAG86-927 [uncultured Truepera sp.]	diamond	258	109	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
30194020	30194020	PRJNA1111077_P_NODE_25012_length_270_cov_1.375635_g24791_i0	PRJNA1111077	25012	270	1.375635	3.7142145	Deinococcus terrestris	2651870	Bacteria	Bacteria	102	5.649999999999999e-23	NR	WP_152872055.1	2651870	g24791	i0	59.1	0.977777777777778	88	36	97.8	0	270	7	163	250	WP_152872055.1 DUF3320 domain-containing protein [Deinococcus terrestris]	diamond	264	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus terrestris
30447070	30447070	PRJNA1111077_P_NODE_22753_length_278_cov_1.248780_g22532_i0	PRJNA1111077	22753	278	1.24878	3.4716084	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	185	4.77e-56	NR	WP_295821212.1	158789	g22532	i0	98.9	0.992805755395683	92	1	99.3	0	278	3	223	314	WP_295821212.1 tyrosine-type recombinase/integrase [uncultured Deinococcus sp.]	diamond	276	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
31331643	31331643	PRJNA1111077_P_NODE_36136_length_242_cov_0.911243_g35915_i0	PRJNA1111077	36136	242	0.911243	2.20520806	Deinococcus soli (ex Cha et al. 2	1309411	Bacteria	Bacteria	83.2	1.07e-16	NR	WP_081424478.1	1309411	g35915	i0	54.7	0.929752066115702	75	34	93	0	236	12	120	194	WP_081424478.1 DUF4062 domain-containing protein [Deinococcus soli (ex Cha et al. 2016)]	diamond	225	83.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
32628325	32628325	PRJNA1111077_P_NODE_37060_length_239_cov_2.228916_g36839_i0	PRJNA1111077	37060	239	2.228916	5.32710924	Deinococcus carri	1211323	Bacteria	Bacteria	137	7.56e-37	NR	WP_345466418.1	1211323	g36839	i0	89.7	0.97907949790795	78	8	97.9	0	235	2	208	285	WP_345466418.1 acyl-CoA thioesterase/bile acid-CoA:amino acid N-acyltransferase family protein [Deinococcus carri]	diamond	234	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus carri

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