metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax

34 rows where analysis = "blastn", bioproject = "PRJDB4470" 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
9665	9665	PRJDB4470_P_NODE_57801_length_257_cov_12.134615_g56646_i0	PRJDB4470	57801	257	12.134615	31.18596055	Deinococcus aetherius	200252	Bacteria	Bacteria	363	9.51e-96	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g56646	i0	94.468	19.8326848249027	235	13	91	0	22	256	2399755	2399521	Deinococcus aetherius ST0316 DNA, complete genome	blastn	5097	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
9771	9771	PRJDB4470_P_NODE_69941_length_221_cov_1.058140_g68786_i0	PRJDB4470	69941	221	1.05814	2.3384894	Allomeiothermus silvanus	52022	Bacteria	Bacteria	204	5.109999999999999e-48	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g68786	i0	85.427	30.6153846153846	199	25	89	3	1	197	10409	10605	Meiothermus silvanus DSM 9946, complete genome	blastn	6766	204	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
981350	981350	PRJDB4470_P_NODE_57641_length_258_cov_2.196172_g56486_i0	PRJDB4470	57641	258	2.196172	5.66612376	Deinococcus	1298	Bacteria	Bacteria	370	5.71e-98	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g56486	i0	93.878	153.162790697674	245	15	95	0	14	258	1792037	1792281	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	39516	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
1283384	1283384	PRJDB4470_P_NODE_116342_length_164_cov_0.886957_g115187_i0	PRJDB4470	116342	164	0.886957	1.45460948	Allomeiothermus silvanus	52022	Bacteria	Bacteria	143	7.9e-30	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g115187	i0	87.302	2.88414634146341	126	14	90	2	17	142	1903437	1903560	Meiothermus silvanus DSM 9946, complete genome	blastn	473	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
1283448	1283448	PRJDB4470_P_NODE_123782_length_162_cov_0.902655_g122627_i0	PRJDB4470	123782	162	0.902655	1.4623011	Allomeiothermus silvanus	52022	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g122627	i0	99.383	33.320987654321	162	1	100	0	1	162	2634070	2633909	Meiothermus silvanus DSM 9946, complete genome	blastn	5398	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2256459	2256459	PRJDB4470_P_NODE_104162_length_167_cov_0.881356_g103007_i0	PRJDB4470	104162	167	0.881356	1.47186452	Deinococcus	1298	Bacteria	Bacteria	71.3	3.87e-8	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g103007	i0	87.302	14.5329341317365	63	6	41	2	1	63	412661	412721	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	2427	71.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
4809129	4809129	PRJDB4470_P_NODE_103144_length_168_cov_0.865546_g101989_i0	PRJDB4470	103144	168	0.865546	1.45411728	Bacteria	2	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g101989	i0	100	138.375	168	0	100	0	1	168	1762	1595	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	23247	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
4809361	4809361	PRJDB4470_P_NODE_82644_length_194_cov_1.434483_g81489_i0	PRJDB4470	82644	194	1.434483	2.78289702	Bacteria	2	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g81489	i0	99.485	134.886597938144	194	1	100	0	1	194	785	592	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	26168	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
6388171	6388171	PRJDB4470_P_NODE_92406_length_179_cov_2.307692_g91251_i0	PRJDB4470	92406	179	2.307692	4.13076868	Allomeiothermus silvanus	52022	Bacteria	Bacteria	294	2.28e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g91251	i0	96.61	0.988826815642458	177	6	99	0	1	177	3046467	3046291	Meiothermus silvanus DSM 9946, complete genome	blastn	177	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
9909503	9909503	PRJDB4470_P_NODE_49988_length_289_cov_17.804167_g48835_i0	PRJDB4470	49988	289	17.804167	51.454042629999996	Truepera	332248	Bacteria	Bacteria	353	6.55e-93	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g48835	i0	90.943	523.131487889273	265	21	91	3	6	268	761986	762249	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	151185	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
10211991	10211991	PRJDB4470_P_NODE_119549_length_163_cov_0.894737_g118394_i0	PRJDB4470	119549	163	0.894737	1.45842131	Allomeiothermus silvanus	52022	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g118394	i0	99.387	1	163	1	100	0	1	163	94141	93979	Meiothermus silvanus DSM 9946, complete genome	blastn	163	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
10212034	10212034	PRJDB4470_P_NODE_126749_length_154_cov_2.819048_g125594_i0	PRJDB4470	126749	154	2.819048	4.34133392	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|359289533\|gb\|CP003126.1\|	1111069	g125594	i0	100	0.181818181818182	28	0	18	0	98	125	887472	887445	Thermus sp. CCB_US3_UF1, complete genome	blastn	28	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
11184635	11184635	PRJDB4470_P_NODE_53809_length_273_cov_1.883929_g52654_i0	PRJDB4470	53809	273	1.883929	5.14312617	Deinococcus	1298	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g52654	i0	98.535	209.164835164835	273	4	100	0	1	273	1791162	1791434	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	57102	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11184680	11184680	PRJDB4470_P_NODE_70249_length_220_cov_1.350877_g69094_i0	PRJDB4470	70249	220	1.350877	2.9719294	root	1	Root_unresolved	Root_unresolved	372	1.32e-98	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g69094	i0	99.51	62.8954545454545	204	1	93	0	17	220	1554	1757	Thermus aquaticus DNA polymerase (PolI) gene	blastn	13837	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
11487321	11487321	PRJDB4470_P_NODE_27090_length_448_cov_5.027569_g25952_i0	PRJDB4470	27090	448	5.027569	22.52350912	Deinococcus aquaticus	328692	Bacteria	Bacteria	754	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g25952	i0	97.105	196.227678571429	449	10	99	3	1	446	714653	715101	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	87910	754	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
11487863	11487863	PRJDB4470_P_NODE_86210_length_188_cov_2.179856_g85055_i0	PRJDB4470	86210	188	2.179856	4.09812928	Allomeiothermus silvanus	52022	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g85055	i0	100	1	188	0	100	0	1	188	153199	153012	Meiothermus silvanus DSM 9946, complete genome	blastn	188	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
12762712	12762712	PRJDB4470_P_NODE_122751_length_162_cov_0.920354_g121596_i0	PRJDB4470	122751	162	0.920354	1.49097348	Allomeiothermus silvanus	52022	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g121596	i0	99.383	1.19135802469136	162	1	100	0	1	162	2042650	2042811	Meiothermus silvanus DSM 9946, complete genome	blastn	193	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
12762716	12762716	PRJDB4470_P_NODE_123071_length_162_cov_0.902655_g121916_i0	PRJDB4470	123071	162	0.902655	1.4623011	Allomeiothermus silvanus	52022	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g121916	i0	99.383	1	162	1	100	0	1	162	3073315	3073476	Meiothermus silvanus DSM 9946, complete genome	blastn	162	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
15009268	15009268	PRJDB4470_P_NODE_66072_length_231_cov_1.390110_g64917_i0	PRJDB4470	66072	231	1.39011	3.2111541	Deinococcus	1298	Bacteria	Bacteria	359	1.09e-94	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g64917	i0	94.805	196.896103896104	231	11	100	1	1	231	1130	1359	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	45483	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
15311234	15311234	PRJDB4470_P_NODE_114873_length_164_cov_0.904348_g113718_i0	PRJDB4470	114873	164	0.904348	1.48313072	Allomeiothermus silvanus	52022	Bacteria	Bacteria	259	7.52e-65	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g113718	i0	95.122	54.0121951219512	164	8	100	0	1	164	3139690	3139527	Meiothermus silvanus DSM 9946, complete genome	blastn	8858	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
16284109	16284109	PRJDB4470_P_NODE_87153_length_187_cov_1.231884_g85998_i0	PRJDB4470	87153	187	1.231884	2.30362308	Bacteria	2	Bacteria	Bacteria	246	6.84e-61	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g85998	i0	97.887	99.7700534759358	142	3	76	0	1	142	1696225	1696366	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	18657	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
17559255	17559255	PRJDB4470_P_NODE_45954_length_310_cov_1.452107_g44801_i0	PRJDB4470	45954	310	1.452107	4.5015317	Deinococcus	1298	Bacteria	Bacteria	562	1.08e-155	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g44801	i0	99.355	199.564516129032	310	2	100	0	1	310	1793650	1793341	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	61865	562	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
17559361	17559361	PRJDB4470_P_NODE_85154_length_190_cov_1.368794_g83999_i0	PRJDB4470	85154	190	1.368794	2.6007086	Bacteria	2	Bacteria	Bacteria	340	3.1099999999999993e-89	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g83999	i0	98.947	136.015789473684	190	2	100	0	1	190	1370	1559	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	25843	340	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
17860862	17860862	PRJDB4470_P_NODE_103075_length_168_cov_0.873950_g101920_i0	PRJDB4470	103075	168	0.87395	1.468236	Allomeiothermus silvanus	52022	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g101920	i0	98.81	1.41071428571429	168	2	100	0	1	168	2405606	2405773	Meiothermus silvanus DSM 9946, complete genome	blastn	237	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
17861790	17861790	PRJDB4470_P_NODE_94735_length_176_cov_1.622047_g93580_i0	PRJDB4470	94735	176	1.622047	2.85480272	Allomeiothermus silvanus	52022	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g93580	i0	100	1	176	0	100	0	1	176	1938344	1938519	Meiothermus silvanus DSM 9946, complete genome	blastn	176	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
19134579	19134579	PRJDB4470_P_NODE_105656_length_167_cov_0.864407_g104501_i0	PRJDB4470	105656	167	0.864407	1.44355969	Allomeiothermus silvanus	52022	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g104501	i0	99.401	1	167	1	100	0	1	167	412181	412015	Meiothermus silvanus DSM 9946, complete genome	blastn	167	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
19135399	19135399	PRJDB4470_P_NODE_83916_length_192_cov_1.370629_g82761_i0	PRJDB4470	83916	192	1.370629	2.63160768	Allomeiothermus silvanus	52022	Bacteria	Bacteria	337	4.079999999999999e-88	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g82761	i0	98.936	0.979166666666667	188	2	98	0	5	192	3008999	3009186	Meiothermus silvanus DSM 9946, complete genome	blastn	188	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
19135423	19135423	PRJDB4470_P_NODE_87696_length_186_cov_1.489051_g86541_i0	PRJDB4470	87696	186	1.489051	2.76963486	Allomeiothermus silvanus	52022	Bacteria	Bacteria	305	1.11e-78	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g86541	i0	96.237	1	186	7	100	0	1	186	2192445	2192630	Meiothermus silvanus DSM 9946, complete genome	blastn	186	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
20108022	20108022	PRJDB4470_P_NODE_95376_length_175_cov_1.730159_g94221_i0	PRJDB4470	95376	175	1.730159	3.02777825	Bacteria	2	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g94221	i0	100	49.7714285714286	175	0	100	0	1	175	869	695	Thermus aquaticus DNA polymerase (PolI) gene	blastn	8710	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
22961667	22961667	PRJDB4470_P_NODE_67439_length_227_cov_1.646067_g66284_i0	PRJDB4470	67439	227	1.646067	3.73657209	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	381	2.2699999999999995e-101	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g66284	i0	96.916	2.14537444933921	227	7	100	0	1	227	2241985	2241759	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	487	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22961741	22961741	PRJDB4470_P_NODE_74719_length_210_cov_0.950311_g73564_i0	PRJDB4470	74719	210	0.950311	1.9956531	Trueperaceae bacterium	2026798	Bacteria	Bacteria	243	1.02e-59	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g73564	i0	89.947	6.28095238095238	189	18	90	1	21	208	7984	8172	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	1319	243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
23933692	23933692	PRJDB4470_P_NODE_127059_length_153_cov_2.317308_g125904_i0	PRJDB4470	127059	153	2.317308	3.54548124	Bacteria	2	Bacteria	Bacteria	279	5.28e-71	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g125904	i0	100	143.104575163399	151	0	99	0	1	151	1010	1160	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	21895	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
24234988	24234988	PRJDB4470_P_NODE_113820_length_164_cov_1.808696_g112665_i0	PRJDB4470	113820	164	1.808696	2.96626144	Allomeiothermus silvanus	52022	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g112665	i0	98.78	1	164	2	100	0	1	164	1824663	1824500	Meiothermus silvanus DSM 9946, complete genome	blastn	164	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
24235019	24235019	PRJDB4470_P_NODE_117600_length_163_cov_1.824561_g116445_i0	PRJDB4470	117600	163	1.824561	2.97403443	Allomeiothermus silvanus	52022	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g116445	i0	100	1	163	0	100	0	1	163	321343	321181	Meiothermus silvanus DSM 9946, complete genome	blastn	163	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus

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