metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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
1590581	1590581	PRJNA1174207_P_NODE_43002_length_228_cov_2.948387_g42473_i0	PRJNA1174207	43002	228	2.948387	6.72232236	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	399	6.299999999999999e-107	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g42473	i0	98.253	46	229	3	100	1	1	228	76029	76257	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	10488	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
2316007	2316007	PRJNA1174207_P_NODE_37082_length_246_cov_2.208092_g36553_i0	PRJNA1174207	37082	246	2.208092	5.43190632	Deinococcus	1298	Bacteria	Bacteria	414	2.46e-111	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g36553	i0	99.559	154.512195121951	227	1	92	0	1	227	2671736	2671510	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	38010	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
2866811	2866811	PRJNA1174207_P_NODE_7983_length_562_cov_4.085890_g7459_i0	PRJNA1174207	7983	562	4.08589	22.9627018	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	852	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g7459	i0	99.154	180.386120996441	473	4	84	0	1	473	3086400	3085928	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	101377	852	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
4142254	4142254	PRJNA1174207_P_NODE_13404_length_399_cov_1.567485_g12876_i0	PRJNA1174207	13404	399	1.567485	6.25426515	Trueperaceae bacterium	2026798	Bacteria	Bacteria	544	5.17e-150	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g12876	i0	91.155	705.739348370927	407	27	100	6	1	399	3600743	3601148	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	281590	544	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4142701	4142701	PRJNA1174207_P_NODE_36324_length_247_cov_1.770115_g35795_i0	PRJNA1174207	36324	247	1.770115	4.37218405	Thermus thermophilus	274	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|2074862859\|dbj\|AP024933.1\|	274	g35795	i0	97.479	11.2024291497976	238	6	96	0	1	238	889012	888775	Thermus thermophilus AA3-7 DNA, complete genome	blastn	2767	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
4868470	4868470	PRJNA1174207_P_NODE_13744_length_394_cov_1.588785_g13215_i0	PRJNA1174207	13744	394	1.588785	6.2598129	Thermus	270	Bacteria	Bacteria	728	0	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g13215	i0	100	46.9796954314721	394	0	100	0	1	394	35333	34940	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	18510	728	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
4868471	4868471	PRJNA1174207_P_NODE_13784_length_393_cov_2.275000_g13255_i0	PRJNA1174207	13784	393	2.275	8.94075	Thermus	270	Bacteria	Bacteria	726	0	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g13255	i0	100	47.4503816793893	393	0	100	0	1	393	34567	34959	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	18648	726	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
4868605	4868605	PRJNA1174207_P_NODE_22944_length_296_cov_3.448430_g22415_i0	PRJNA1174207	22944	296	3.44843	10.2073528	Allomeiothermus	2935559	Bacteria	Bacteria	276	1.5e-69	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g22415	i0	99.342	148.550675675676	152	1	99	0	1	152	2358	2509	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	43971	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
6693570	6693570	PRJNA1174207_P_NODE_30106_length_264_cov_1.612565_g29577_i0	PRJNA1174207	30106	264	1.612565	4.2571716	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|2793129014\|gb\|CP126982.1\|	3389975	g29577	i0	100	136.397727272727	264	0	100	0	1	264	293230	292967	Fervidobacterium pennivorans subsp. shakshaketiis strain GSH chromosome, complete genome	blastn	36009	488	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
8693563	8693563	PRJNA1174207_P_NODE_26927_length_277_cov_2.205882_g26398_i0	PRJNA1174207	26927	277	2.205882	6.11029314	Meiothermus	65551	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g26398	i0	100	139.58844765343	275	0	99	0	3	277	1820	1546	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	38666	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
8693615	8693615	PRJNA1174207_P_NODE_30967_length_260_cov_3.877005_g30438_i0	PRJNA1174207	30967	260	3.877005	10.080213	Thermus	270	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1092183759\|dbj\|AB862156.1\|	274	g30438	i0	100	116.003846153846	260	0	100	0	1	260	292	551	Thermus thermophilus gene for 16S ribosomal RNA, partial sequence, strain: TR2	blastn	30161	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9968949	9968949	PRJNA1174207_P_NODE_6608_length_640_cov_8.100529_g6090_i0	PRJNA1174207	6608	640	8.100529	51.8433856	Deinococcus	1298	Bacteria	Bacteria	972	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g6090	i0	94.228	209.0171875	641	29	99	4	2	640	1793007	1793641	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	133771	972	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
10519458	10519458	PRJNA1174207_P_NODE_38729_length_244_cov_1.801170_g38200_i0	PRJNA1174207	38729	244	1.80117	4.3948548	Meiothermus ruber	277	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g38200	i0	99.18	2	244	2	100	0	1	244	704492	704735	Meiothermus ruber DSM 1279, complete genome	blastn	488	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
11243922	11243922	PRJNA1174207_P_NODE_29689_length_266_cov_1.227979_g29160_i0	PRJNA1174207	29689	266	1.227979	3.26642414	Thermus	270	Bacteria	Bacteria	486	5.629999999999999e-133	NTclustered	gi\|210077502\|gb\|FJ358543.1\|	570924	g29160	i0	99.624	54.7518796992481	266	1	100	0	1	266	1335	1600	Thermus sp. NMX2.A1 PolI (polI) gene, complete cds	blastn	14564	486	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NMX2.A1
11794432	11794432	PRJNA1174207_P_NODE_37770_length_246_cov_0.890173_g37241_i0	PRJNA1174207	37770	246	0.890173	2.18982558	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g37241	i0	99.187	27.4471544715447	246	2	100	0	1	246	2263850	2264095	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	6752	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
12519250	12519250	PRJNA1174207_P_NODE_24330_length_288_cov_4.209302_g23801_i0	PRJNA1174207	24330	288	4.209302	12.12278976	Fervidobacterium	2422	Bacteria	Bacteria	529	1.01e-145	NTclustered	gi\|2793125101\|gb\|CP126499.1\|	2423	g23801	i0	100	155.048611111111	286	0	99	0	3	288	1622581	1622866	Fervidobacterium islandicum strain H-21 chromosome, complete genome	blastn	44654	529	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
13069135	13069135	PRJNA1174207_P_NODE_22951_length_296_cov_3.170404_g22422_i0	PRJNA1174207	22951	296	3.170404	9.38439584	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	278	4.1700000000000005e-70	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g22422	i0	100	22.3783783783784	150	0	100	0	147	296	717879	718028	Thermus sp. NEB1569 chromosome, complete genome	blastn	6624	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
13793727	13793727	PRJNA1174207_P_NODE_13511_length_397_cov_2.481481_g12983_i0	PRJNA1174207	13511	397	2.481481	9.85147957	Deinococcus	1298	Bacteria	Bacteria	364	4.3e-96	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g12983	i0	82.426	26.3123425692695	404	63	99	4	2	397	74776	75179	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	10446	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13794039	13794039	PRJNA1174207_P_NODE_39351_length_244_cov_0.900585_g38822_i0	PRJNA1174207	39351	244	0.900585	2.1974274	Thermus	270	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g38822	i0	98.77	42.2090163934426	244	3	100	0	1	244	370613	370370	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	10299	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
15618619	15618619	PRJNA1174207_P_NODE_39553_length_243_cov_1.635294_g39024_i0	PRJNA1174207	39553	243	1.635294	3.97376442	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|444439382\|ref\|NR_074097.1\|	771875	g39024	i0	99.588	109.024691358025	243	1	100	0	1	243	1324	1082	Fervidobacterium pennivorans DSM 9078 16S ribosomal RNA, partial sequence	blastn	26493	444	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
16343438	16343438	PRJNA1174207_P_NODE_8793_length_525_cov_2.227876_g8269_i0	PRJNA1174207	8793	525	2.227876	11.696349	Fervidobacterium	2422	Bacteria	Bacteria	953	0	NTclustered	gi\|2793125101\|gb\|CP126499.1\|	2423	g8269	i0	99.429	109.620952380952	525	3	100	0	1	525	1626211	1626735	Fervidobacterium islandicum strain H-21 chromosome, complete genome	blastn	57551	959	0.993743482794578	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
16892677	16892677	PRJNA1174207_P_NODE_26114_length_281_cov_1.312500_g25585_i0	PRJNA1174207	26114	281	1.3125	3.688125	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	481	2.79e-131	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g25585	i0	97.509	30.0747330960854	281	7	100	0	1	281	2731208	2730928	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	8451	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
17618436	17618436	PRJNA1174207_P_NODE_29894_length_265_cov_1.588542_g29365_i0	PRJNA1174207	29894	265	1.588542	4.2096363	Fervidobacterium	2422	Bacteria	Bacteria	481	2.61e-131	NTclustered	gi\|470489789\|ref\|NR_076950.1\|	93466	g29365	i0	99.62	147.011320754717	263	1	99	0	1	263	2600	2862	Fervidobacterium pennivorans strain Ven5 23S ribosomal RNA gene, complete sequence	blastn	38958	481	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
18167321	18167321	PRJNA1174207_P_NODE_32135_length_256_cov_1.202186_g31606_i0	PRJNA1174207	32135	256	1.202186	3.07759616	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	451	1.96e-122	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g31606	i0	98.438	2.5390625	256	4	100	0	1	256	275483	275738	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	650	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
18892216	18892216	PRJNA1174207_P_NODE_30795_length_261_cov_2.085106_g30266_i0	PRJNA1174207	30795	261	2.085106	5.44212666	Thermaceae	188786	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|88909602\|gb\|DQ352191.1\|	277	g30266	i0	100	99.3946360153257	261	0	100	0	1	261	23	283	Meiothermus ruber strain M 16S ribosomal RNA gene, partial sequence	blastn	25942	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
19441394	19441394	PRJNA1174207_P_NODE_17196_length_344_cov_2.376384_g16667_i0	PRJNA1174207	17196	344	2.376384	8.17476096	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	497	3.48e-136	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g16667	i0	92.795	234.587209302326	347	19	100	6	1	344	1361366	1361023	Deinococcus sp. QL22 chromosome, complete genome	blastn	80698	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
19441629	19441629	PRJNA1174207_P_NODE_27456_length_275_cov_1.524752_g26927_i0	PRJNA1174207	27456	275	1.524752	4.193068	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g26927	i0	100	3.82545454545455	275	0	100	0	1	275	3184044	3184318	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	1052	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
21442298	21442298	PRJNA1174207_P_NODE_12277_length_422_cov_2.934097_g11750_i0	PRJNA1174207	12277	422	2.934097	12.38188934	Fervidobacterium	2422	Bacteria	Bacteria	752	0	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g11750	i0	98.815	201.471563981043	422	5	100	0	1	422	1637212	1637633	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	85021	758	0.992084432717678	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
21442500	21442500	PRJNA1174207_P_NODE_23417_length_293_cov_1.977273_g22888_i0	PRJNA1174207	23417	293	1.977273	5.79340989	Thermus	270	Bacteria	Bacteria	525	1.3299999999999994e-144	NTclustered	gi\|1701967042\|dbj\|AP019801.1\|	274	g22888	i0	98.98	146.672354948805	294	2	100	1	1	293	12782	12489	Thermus thermophilus HC11 DNA, complete genome	blastn	42975	525	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
23992574	23992574	PRJNA1174207_P_NODE_13319_length_400_cov_2.795107_g12791_i0	PRJNA1174207	13319	400	2.795107	11.180428	Deinococcus	1298	Bacteria	Bacteria	689	0	NTclustered	gi\|2648560497\|gb\|PP129705.1\|	47478	g12791	i0	97.75	103.245	400	9	100	0	1	400	558	159	Deinococcus sp. strain YIM_134068 16S ribosomal RNA gene, partial sequence	blastn	41298	689	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23992776	23992776	PRJNA1174207_P_NODE_25659_length_283_cov_1.209524_g25130_i0	PRJNA1174207	25659	283	1.209524	3.42295292	Thermus	270	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g25130	i0	100	100.187279151943	283	0	100	0	1	283	189915	189633	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	28353	523	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
23992818	23992818	PRJNA1174207_P_NODE_28059_length_272_cov_2.904523_g27530_i0	PRJNA1174207	28059	272	2.904523	7.90030256	Truepera	332248	Bacteria	Bacteria	313	1.04e-80	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g27530	i0	87.454	1.99264705882353	271	34	99	0	2	272	2003069	2002799	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	542	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25266752	25266752	PRJNA1174207_P_NODE_17580_length_340_cov_1.494382_g17051_i0	PRJNA1174207	17580	340	1.494382	5.0808988	Meiothermus	65551	Bacteria	Bacteria	621	1.95e-173	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g17051	i0	99.705	149.205882352941	339	1	99	0	1	339	83	421	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	50730	621	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber

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