metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
219739	219739	PRJNA1112809_P_NODE_165721_length_250_cov_2.604520_g162446_i0	PRJNA1112809	165721	250	2.60452	6.5113	Trueperaceae bacterium	2026798	Bacteria	Bacteria	274	4.44e-69	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g162446	i0	87.19	103.572	242	29	96	2	5	244	3601475	3601234	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	25893	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
219963	219963	PRJNA1112809_P_NODE_181281_length_245_cov_0.895349_g178006_i0	PRJNA1112809	181281	245	0.895349	2.19360505	Thermus parvatiensis	456163	Bacteria	Bacteria	440	4.0399999999999986e-119	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g178006	i0	99.184	55.3591836734694	245	1	100	1	1	245	990990	990747	Thermus parvatiensis strain RL, complete genome	blastn	13563	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
1023213	1023213	PRJNA1112809_P_NODE_154741_length_259_cov_1.510753_g151466_i0	PRJNA1112809	154741	259	1.510753	3.91285027	Deinococcus	1298	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g151466	i0	100	2.54826254826255	259	0	100	0	1	259	470699	470441	Deinococcus swuensis strain DY59, complete genome	blastn	660	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
1023329	1023329	PRJNA1112809_P_NODE_191621_length_241_cov_2.220238_g188346_i0	PRJNA1112809	191621	241	2.220238	5.35077358	Bacteria	2	Bacteria	Bacteria	385	1.88e-102	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g188346	i0	100	8.62240663900415	208	0	86	0	1	208	168042	168249	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	2078	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
1494731	1494731	PRJNA1112809_P_NODE_182542_length_245_cov_0.883721_g179267_i0	PRJNA1112809	182542	245	0.883721	2.16511645	Thermus scotoductus	37636	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g179267	i0	97.959	1	245	5	100	0	1	245	1553532	1553288	Thermus scotoductus SA-01, complete genome	blastn	245	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
2298814	2298814	PRJNA1112809_P_NODE_187922_length_243_cov_0.905882_g184647_i0	PRJNA1112809	187922	243	0.905882	2.20129326	Deinococcus	1298	Bacteria	Bacteria	228	3.389999999999999e-55	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g184647	i0	83.607	27.9300411522634	244	39	100	1	1	243	1647562	1647805	Deinococcus gobiensis I-0, complete genome	blastn	6787	230	0.991304347826087	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3573763	3573763	PRJNA1112809_P_NODE_148323_length_265_cov_1.598958_g145048_i0	PRJNA1112809	148323	265	1.598958	4.2372387	Fervidobacterium	2422	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g145048	i0	100	4	265	0	100	0	1	265	1068436	1068700	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1060	490	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
4851229	4851229	PRJNA1112809_P_NODE_150904_length_262_cov_3.375661_g147629_i0	PRJNA1112809	150904	262	3.375661	8.84423182	Deinococcus	1298	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g147629	i0	99.618	196.274809160305	262	1	100	0	1	262	69629	69890	Deinococcus puniceus strain DY1, complete genome	blastn	51424	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
5322239	5322239	PRJNA1112809_P_NODE_144505_length_269_cov_1.280612_g141230_i0	PRJNA1112809	144505	269	1.280612	3.44484628	Deinococcus metallilatus	1211322	Bacteria	Bacteria	309	1.32e-79	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g141230	i0	88.077	6.74349442379182	260	31	97	0	1	260	1504963	1505222	Deinococcus metallilatus strain MA1002 chromosome	blastn	1814	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
5322382	5322382	PRJNA1112809_P_NODE_152425_length_261_cov_1.638298_g149150_i0	PRJNA1112809	152425	261	1.638298	4.27595778	Oceanithermus profundus	187137	Bacteria	Bacteria	67.6	8.5e-7	NTclustered	gi\|313151615\|gb\|CP002361.1\|	670487	g149150	i0	86.667	0.620689655172414	60	8	23	0	199	258	101221	101162	Oceanithermus profundus DSM 14977, complete genome	blastn	162	67.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Oceanithermus	Oceanithermus profundus
6126295	6126295	PRJNA1112809_P_NODE_181125_length_245_cov_0.895349_g177850_i0	PRJNA1112809	181125	245	0.895349	2.19360505	Truepera	332248	Bacteria	Bacteria	182	2.7e-41	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g177850	i0	80.498	5.20816326530612	241	43	98	4	5	243	2579160	2578922	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	1276	182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6597617	6597617	PRJNA1112809_P_NODE_150066_length_263_cov_2.242105_g146791_i0	PRJNA1112809	150066	263	2.242105	5.89673615	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	156	1.7800000000000002e-33	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g146791	i0	87.407	1.00760456273764	135	17	51	0	2	136	1197171	1197037	Deinococcus sp. NW-56 chromosome, complete genome	blastn	265	156	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6597689	6597689	PRJNA1112809_P_NODE_153806_length_260_cov_1.235294_g150531_i0	PRJNA1112809	153806	260	1.235294	3.2117644	Trueperaceae bacterium	2026798	Bacteria	Bacteria	396	9.5e-106	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g150531	i0	94.208	384.507692307692	259	15	99	0	1	259	2559597	2559339	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	99972	396	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
13776495	13776495	PRJNA1112809_P_NODE_135911_length_278_cov_1.380488_g132636_i0	PRJNA1112809	135911	278	1.380488	3.83775664	Thermus	270	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g132636	i0	99.64	45.5215827338129	278	1	100	0	1	278	11530	11807	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	12655	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
15521864	15521864	PRJNA1112809_P_NODE_135053_length_279_cov_1.276699_g131778_i0	PRJNA1112809	135053	279	1.276699	3.56199021	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	510	3.5299999999999996e-140	NTclustered	gi\|2793123095\|gb\|CP126500.1\|	3389976	g131778	i0	99.642	3.60215053763441	279	1	100	0	1	279	232439	232161	Fervidobacterium pennivorans subsp. carthaginiensis strain DSM 21710 chromosome, complete genome	blastn	1005	510	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
15522625	15522625	PRJNA1112809_P_NODE_179033_length_246_cov_0.890173_g175758_i0	PRJNA1112809	179033	246	0.890173	2.18982558	Allomeiothermus silvanus	52022	Bacteria	Bacteria	82.4	2.83e-11	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g175758	i0	92.857	0.386178861788618	56	4	34	0	1	56	46150	46095	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	95	82.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
16325880	16325880	PRJNA1112809_P_NODE_170453_length_249_cov_0.875000_g167178_i0	PRJNA1112809	170453	249	0.875	2.17875	Fervidobacterium	2422	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g167178	i0	100	4.99196787148594	249	0	100	0	1	249	1323922	1323674	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1243	460	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
16325914	16325914	PRJNA1112809_P_NODE_184593_length_244_cov_0.900585_g181318_i0	PRJNA1112809	184593	244	0.900585	2.1974274	Thermus	270	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g181318	i0	100	47.9098360655738	244	0	100	0	1	244	1373745	1373502	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	11690	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
16325924	16325924	PRJNA1112809_P_NODE_187913_length_243_cov_0.905882_g184638_i0	PRJNA1112809	187913	243	0.905882	2.20129326	Deinococcus	1298	Bacteria	Bacteria	220	5.67e-53	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g184638	i0	83.058	1.9917695473251	242	41	99	0	1	242	2226604	2226363	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	484	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
16797073	16797073	PRJNA1112809_P_NODE_178094_length_246_cov_0.890173_g174819_i0	PRJNA1112809	178094	246	0.890173	2.18982558	Thermus thermophilus	274	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g174819	i0	98.78	36	246	3	100	0	1	246	365190	364945	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	8856	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
17600925	17600925	PRJNA1112809_P_NODE_147934_length_265_cov_2.546875_g144659_i0	PRJNA1112809	147934	265	2.546875	6.74921875	Deinococcus	1298	Bacteria	Bacteria	473	4.3599999999999987e-129	NTclustered	gi\|662020442\|gb\|KJ729576.1\|	158789	g144659	i0	98.868	120.562264150943	265	3	100	0	1	265	268	4	Uncultured Deinococcus sp. clone B1L-c11 16S ribosomal RNA gene, partial sequence	blastn	31949	473	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
17601055	17601055	PRJNA1112809_P_NODE_184354_length_244_cov_0.900585_g181079_i0	PRJNA1112809	184354	244	0.900585	2.1974274	Thermus	270	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g181079	i0	99.59	38.9795081967213	244	1	100	0	1	244	970310	970067	Thermus thermophilus AA2-29 DNA, complete genome	blastn	9511	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
17601286	17601286	PRJNA1112809_P_NODE_69254_length_423_cov_3.034286_g65979_i0	PRJNA1112809	69254	423	3.034286	12.83502978	Deinococcus	1298	Bacteria	Bacteria	760	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g65979	i0	99.286	245.527186761229	420	3	100	0	1	420	69999	70418	Deinococcus swuensis strain DY59, complete genome	blastn	103858	760	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18874995	18874995	PRJNA1112809_P_NODE_166695_length_250_cov_1.242938_g163420_i0	PRJNA1112809	166695	250	1.242938	3.107345	Thermus	270	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g163420	i0	100	39.764	250	0	100	0	1	250	1635701	1635950	Thermus thermophilus AA2-29 DNA, complete genome	blastn	9941	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
19345159	19345159	PRJNA1112809_P_NODE_136436_length_277_cov_1.980392_g133161_i0	PRJNA1112809	136436	277	1.980392	5.48568584	Thermus thermophilus	274	Bacteria	Bacteria	496	9.8e-136	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g133161	i0	98.917	42.7653429602888	277	3	100	0	1	277	1216437	1216713	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	11846	496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
20621090	20621090	PRJNA1112809_P_NODE_177977_length_246_cov_1.196532_g174702_i0	PRJNA1112809	177977	246	1.196532	2.94346872	Thermus thermophilus	274	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|2199613261\|dbj\|AP025596.1\|	274	g174702	i0	98.78	13	246	3	100	0	1	246	723048	722803	Thermus thermophilus SNM1-1 DNA, complete genome	blastn	3198	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
21896649	21896649	PRJNA1112809_P_NODE_166878_length_250_cov_0.870056_g163603_i0	PRJNA1112809	166878	250	0.870056	2.17514	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g163603	i0	98.785	3.984	247	3	99	0	4	250	3214308	3214062	Deinococcus sp. D7000 chromosome, complete genome	blastn	996	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
23173076	23173076	PRJNA1112809_P_NODE_44439_length_594_cov_2.201536_g41204_i0	PRJNA1112809	44439	594	2.201536	13.07712384	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	422	3.89e-113	NTclustered	gi\|1868564649\|gb\|CP058536.1\|	2755035	g41204	i0	79.796	1.55387205387205	589	111	98	8	1	585	316321	316905	Deinococcus sp. D7000 plasmid p_2, complete sequence	blastn	923	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
23975647	23975647	PRJNA1112809_P_NODE_173279_length_248_cov_0.880000_g170004_i0	PRJNA1112809	173279	248	0.88	2.1824	Fervidobacterium	2422	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2793129014\|gb\|CP126982.1\|	3389975	g170004	i0	100	2.95161290322581	248	0	100	0	1	248	611344	611097	Fervidobacterium pennivorans subsp. shakshaketiis strain GSH chromosome, complete genome	blastn	732	459	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
24445884	24445884	PRJNA1112809_P_NODE_167620_length_250_cov_0.870056_g164345_i0	PRJNA1112809	167620	250	0.870056	2.17514	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g164345	i0	100	1.98	250	0	100	0	1	250	453776	454025	Deinococcus sp. D7000 chromosome, complete genome	blastn	495	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
24446172	24446172	PRJNA1112809_P_NODE_184700_length_244_cov_0.900585_g181425_i0	PRJNA1112809	184700	244	0.900585	2.1974274	Thermus parvatiensis	456163	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g181425	i0	98.361	47.2745901639344	244	4	100	0	1	244	769058	769301	Thermus parvatiensis strain RL, complete genome	blastn	11535	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis

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