metadata: contig_metadata: 22 rows where bioproject = "PRJNA800053" and tax

22 rows where bioproject = "PRJNA800053" 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
1219876	1219876	PRJNA800053_P_NODE_23641_length_241_cov_0.916667_g23477_i0	PRJNA800053	23641	241	0.916667	2.20916747	Thermus	270	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|1953559172\|dbj\|AP024270.1\|	274	g23477	i0	99.163	38.3858921161826	239	1	99	1	1	239	864449	864686	Thermus thermophilus HB5018 DNA, complete genome	blastn	9251	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
4624621	4624621	PRJNA800053_P_NODE_17524_length_251_cov_0.865169_g17360_i0	PRJNA800053	17524	251	0.865169	2.17157419	Meiothermus ruber	277	Bacteria	Bacteria	198	2.76e-46	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g17360	i0	81.933	2.8207171314741	238	40	94	3	8	243	544051	544287	Meiothermus ruber DSM 1279, complete genome	blastn	708	198	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
5048037	5048037	PRJNA800053_P_NODE_9384_length_315_cov_1.880165_g9220_i0	PRJNA800053	9384	315	1.880165	5.92251975	Thermus	270	Bacteria	Bacteria	326	1.57e-84	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g9220	i0	100	39.752380952381	176	0	99	0	140	315	281393	281568	Thermus thermophilus TF27 DNA, complete genome	blastn	12522	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
5899746	5899746	PRJNA800053_P_NODE_18365_length_250_cov_0.870056_g18201_i0	PRJNA800053	18365	250	0.870056	2.17514	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	246	9.679999999999999e-61	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g18201	i0	85.185	4.588	243	33	97	3	5	246	441224	441464	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1147	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6323868	6323868	PRJNA800053_P_NODE_15065_length_265_cov_1.276042_g14901_i0	PRJNA800053	15065	265	1.276042	3.3815113	Thermus	270	Bacteria	Bacteria	420	5.76e-113	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g14901	i0	96.124	10.5056603773585	258	9	97	1	5	262	1088799	1088543	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	2784	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
8449356	8449356	PRJNA800053_P_NODE_8447_length_329_cov_1.511719_g8283_i0	PRJNA800053	8447	329	1.511719	4.97355551	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	575	1.4899999999999995e-159	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g8283	i0	99.062	0.972644376899696	320	3	97	0	7	326	137530	137211	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	320	575	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
9724277	9724277	PRJNA800053_P_NODE_17008_length_253_cov_0.916667_g16844_i0	PRJNA800053	17008	253	0.916667	2.31916751	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	427	3.26e-115	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g16844	i0	97.233	222.509881422925	253	6	99	1	1	252	1638756	1639008	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	56295	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
14824648	14824648	PRJNA800053_P_NODE_24812_length_228_cov_2.903226_g24648_i0	PRJNA800053	24812	228	2.903226	6.61935528	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	327	3.02e-85	NTclustered	gi\|359289533\|gb\|CP003126.1\|	1111069	g24648	i0	93.981	48.6315789473684	216	13	95	0	8	223	1427110	1427325	Thermus sp. CCB_US3_UF1, complete genome	blastn	11088	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
14824679	14824679	PRJNA800053_P_NODE_9272_length_317_cov_1.127049_g9108_i0	PRJNA800053	9272	317	1.127049	3.57274533	Deinococcus taeanensis	2737050	Bacteria	Bacteria	501	2.45e-137	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g9108	i0	95.833	258.053627760252	312	9	98	3	5	314	1634	1943	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	81803	501	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
16098680	16098680	PRJNA800053_P_NODE_13113_length_279_cov_1.189320_g12949_i0	PRJNA800053	13113	279	1.18932	3.3182028	Deinococcus radiopugnans	57497	Bacteria	Bacteria	416	7.909999999999999e-112	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g12949	i0	93.885	186.698924731183	278	13	99	4	4	279	69204	69479	Deinococcus swuensis strain DY59, complete genome	blastn	52089	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
16522741	16522741	PRJNA800053_P_NODE_6073_length_375_cov_1.317881_g5910_i0	PRJNA800053	6073	375	1.317881	4.94205375	Truepera	332248	Bacteria	Bacteria	490	6.379999999999999e-134	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5910	i0	90.374	90.232	374	34	99	1	1	372	1890	1517	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	33837	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
17374590	17374590	PRJNA800053_P_NODE_15834_length_260_cov_1.422460_g15670_i0	PRJNA800053	15834	260	1.42246	3.698396	Thermus brockianus	56956	Bacteria	Bacteria	472	1.53e-128	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g15670	i0	99.612	1.98461538461538	258	1	99	0	3	260	80552	80809	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	516	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
17374695	17374695	PRJNA800053_P_NODE_7234_length_350_cov_3.350181_g7070_i0	PRJNA800053	7234	350	3.350181	11.7256335	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	579	1.2299999999999996e-160	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g7070	i0	97.633	217.948571428571	338	7	97	1	1	338	2417493	2417829	Deinococcus sp. NW-56 chromosome, complete genome	blastn	76282	579	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
19923062	19923062	PRJNA800053_P_NODE_3616_length_465_cov_6.716837_g3453_i0	PRJNA800053	3616	465	6.716837	31.23329205	Deinococcus aetherius	200252	Bacteria	Bacteria	534	3.68e-147	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g3453	i0	87.686	195.939784946237	471	42	99	12	1	462	823128	822665	Deinococcus aetherius ST0316 DNA, complete genome	blastn	91112	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21198629	21198629	PRJNA800053_P_NODE_19757_length_247_cov_1.408046_g19593_i0	PRJNA800053	19757	247	1.408046	3.47787362	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	436	5.279999999999999e-118	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g19593	i0	98.776	8.46558704453441	245	3	99	0	1	245	1476608	1476364	Thermus sp. NEB1569 chromosome, complete genome	blastn	2091	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
25022882	25022882	PRJNA800053_P_NODE_7100_length_353_cov_1.260714_g6936_i0	PRJNA800053	7100	353	1.260714	4.45032042	Trueperaceae bacterium	2026798	Bacteria	Bacteria	411	4.779999999999999e-110	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g6936	i0	88.563	327.813031161473	341	35	97	4	5	345	3600974	3600638	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	115718	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
26999575	26999575	PRJNA800053_P_NODE_5742_length_384_cov_0.881029_g5579_i0	PRJNA800053	5742	384	0.881029	3.38315136	Bacteria	2	Bacteria	Bacteria	97.8	1.37e-22	NR	WP_084542836.1	68910	g5579	i0	41.3	5.6953125	126	72	96.9	1	1	372	64	189	WP_084542836.1 HNH endonuclease [Deinococcus murrayi]	diamond	2187	98.6	0.991886409736308	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus murrayi
27559436	27559436	PRJNA800053_P_NODE_21264_length_245_cov_0.895349_g21100_i0	PRJNA800053	21264	245	0.895349	2.19360505	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	136	6.649999999999999e-37	NR	WP_014515545.1	1111069	g21100	i0	85.9	0.955102040816327	78	11	95.5	0	238	5	22	99	WP_014515545.1 hypothetical protein [Thermus sp. CCB_US3_UF1]	diamond	234	136	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
28475296	28475296	PRJNA800053_P_NODE_24286_length_237_cov_2.457317_g24122_i0	PRJNA800053	24286	237	2.457317	5.82384129	Thermus	270	Bacteria	Bacteria	130	6.36e-33	NR	WP_234502992.1	270	g24122	i0	84.2	0.962025316455696	76	12	96.2	0	8	235	361	436	WP_234502992.1 MULTISPECIES: BTAD domain-containing putative transcriptional regulator [Thermus]	diamond	228	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
28569912	28569912	PRJNA800053_P_NODE_23547_length_241_cov_1.345238_g23383_i0	PRJNA800053	23547	241	1.345238	3.24202358	Deinococcus antarcticus	1298767	Bacteria	Bacteria	157	3.86e-48	NR	WP_380075691.1	1298767	g23383	i0	97.3	3.89626556016598	73	2	90.9	0	220	2	1	73	WP_380075691.1 IS200/IS605 family transposase, partial [Deinococcus antarcticus]	diamond	939	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
28790845	28790845	PRJNA800053_P_NODE_22627_length_243_cov_0.905882_g22463_i0	PRJNA800053	22627	243	0.905882	2.20129326	Deinococcus antarcticus	1298767	Bacteria	Bacteria	67.8	3.93e-11	NR	WP_380075745.1	1298767	g22463	i0	57.6	2.35802469135802	66	28	81.5	0	217	20	4	69	WP_380075745.1 tyrosine-type recombinase/integrase [Deinococcus antarcticus]	diamond	573	67.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30275522	30275522	PRJNA800053_P_NODE_19932_length_247_cov_0.885057_g19768_i0	PRJNA800053	19932	247	0.885057	2.18609079	Deinococcus sedimenti	1867090	Bacteria	Bacteria	58.2	3.72e-8	NR	WP_189074593.1	1867090	g19768	i0	47.8	0.558704453441296	46	24	55.9	0	105	242	2	47	WP_189074593.1 hypothetical protein [Deinococcus sedimenti]	diamond	138	58.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sedimenti

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