metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax

24 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
1285209	1285209	PRJDB9741_P_NODE_2562_length_457_cov_9.274510_g2248_i0	PRJDB9741	2562	457	9.27451	42.3845107	Deinococcus ficus	317577	Bacteria	Bacteria	512	1.69e-140	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g2248	i0	86.985	257.807439824945	461	53	100	7	1	457	2342551	2343008	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	117818	512	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1285334	1285334	PRJDB9741_P_NODE_40022_length_161_cov_0.910714_g39705_i0	PRJDB9741	40022	161	0.910714	1.46624954	Thermus brockianus	56956	Bacteria	Bacteria	230	5.7599999999999995e-56	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g39705	i0	93.506	41.4037267080745	154	10	96	0	1	154	799215	799368	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	6666	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
2560797	2560797	PRJDB9741_P_NODE_31063_length_165_cov_1.732759_g30746_i0	PRJDB9741	31063	165	1.732759	2.85905235	Deinococcus grandis	57498	Bacteria	Bacteria	265	1.6299999999999998e-66	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g30746	i0	95.758	10.8969696969697	165	6	100	1	1	165	118902	118739	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	1798	265	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
2560807	2560807	PRJDB9741_P_NODE_32923_length_164_cov_1.904348_g32606_i0	PRJDB9741	32923	164	1.904348	3.12313072	Allomeiothermus silvanus	52022	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g32606	i0	98.78	1	164	2	100	0	1	164	2865965	2866128	Meiothermus silvanus DSM 9946, complete genome	blastn	164	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2560826	2560826	PRJDB9741_P_NODE_35703_length_163_cov_0.894737_g35386_i0	PRJDB9741	35703	163	0.894737	1.45842131	Allomeiothermus silvanus	52022	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g35386	i0	98.16	1	163	3	100	0	1	163	422604	422442	Meiothermus silvanus DSM 9946, complete genome	blastn	163	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2560843	2560843	PRJDB9741_P_NODE_37503_length_162_cov_0.902655_g37186_i0	PRJDB9741	37503	162	0.902655	1.4623011	Allomeiothermus silvanus	52022	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g37186	i0	99.383	1	162	1	100	0	1	162	1291760	1291599	Meiothermus silvanus DSM 9946, complete genome	blastn	162	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2560875	2560875	PRJDB9741_P_NODE_41323_length_158_cov_4.293578_g41006_i0	PRJDB9741	41323	158	4.293578	6.78385324	Trueperaceae bacterium	2026798	Bacteria	Bacteria	195	2.05e-45	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g41006	i0	93.182	228.335443037975	132	9	84	0	1	132	9557	9426	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	36077	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
3837194	3837194	PRJDB9741_P_NODE_38684_length_162_cov_0.902655_g38367_i0	PRJDB9741	38684	162	0.902655	1.4623011	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1339790004\|gb\|CP026517.1\|	2080419	g38367	i0	100	1	162	0	100	0	1	162	220066	219905	Deinococcus sp. NW-56 plasmid unnamed1, complete sequence	blastn	162	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
4809695	4809695	PRJDB9741_P_NODE_17324_length_182_cov_2.601504_g17007_i0	PRJDB9741	17324	182	2.601504	4.73473728	Deinococcus	1298	Bacteria	Bacteria	233	5.149999999999999e-57	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g17007	i0	89.73	195.67032967033	185	16	100	3	1	182	98048	97864	Deinococcus sp. AJ005 chromosome, complete genome	blastn	35612	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
4809795	4809795	PRJDB9741_P_NODE_3724_length_345_cov_1.706081_g3408_i0	PRJDB9741	3724	345	1.706081	5.88597945	Truepera	332248	Bacteria	Bacteria	375	1.7099999999999998e-99	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g3408	i0	86.416	280.646376811594	346	44	100	3	1	345	407	64	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	96823	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
5113383	5113383	PRJDB9741_P_NODE_38445_length_162_cov_0.902655_g38128_i0	PRJDB9741	38445	162	0.902655	1.4623011	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	231	1.6099999999999998e-56	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g38128	i0	92.593	10.1975308641975	162	10	99	2	2	162	2165451	2165291	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	1652	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
7663133	7663133	PRJDB9741_P_NODE_14107_length_188_cov_1.503597_g13790_i0	PRJDB9741	14107	188	1.503597	2.82676236	Allomeiothermus silvanus	52022	Bacteria	Bacteria	326	8.6e-85	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g13790	i0	97.872	1	188	4	100	0	1	188	998433	998246	Meiothermus silvanus DSM 9946, complete genome	blastn	188	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
11185227	11185227	PRJDB9741_P_NODE_9389_length_210_cov_2.919255_g9072_i0	PRJDB9741	9389	210	2.919255	6.1304355	Thermus	270	Bacteria	Bacteria	185	1.74e-42	NTclustered	gi\|1886401075\|gb\|CP053288.1\|	274	g9072	i0	100	16.5952380952381	100	0	95	0	1	100	216203	216302	Thermus thermophilus strain HB27c plasmid pTT27, complete sequence	blastn	3485	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12461021	12461021	PRJDB9741_P_NODE_3290_length_377_cov_6.594512_g2975_i0	PRJDB9741	3290	377	6.594512	24.86131024	Deinococcus	1298	Bacteria	Bacteria	632	1.0099999999999996e-176	NTclustered	gi\|1561262424\|gb\|MK424382.1\|	47478	g2975	i0	97.312	100.620689655172	372	10	99	0	1	372	17	388	Deinococcus sp. strain GK27 16S ribosomal RNA gene, partial sequence	blastn	37934	638	0.990595611285266	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
15313081	15313081	PRJDB9741_P_NODE_2413_length_474_cov_11.178824_g2099_i0	PRJDB9741	2413	474	11.178824	52.98762576	Deinococcus grandis	57498	Bacteria	Bacteria	841	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g2099	i0	98.936	206.556962025316	470	5	99	0	5	474	3061135	3060666	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	97908	841	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
16587779	16587779	PRJDB9741_P_NODE_2414_length_474_cov_10.687059_g2100_i0	PRJDB9741	2414	474	10.687059	50.65665966	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	676	0	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g2100	i0	92.781	231.455696202532	471	29	99	5	5	473	1360913	1361380	Deinococcus sp. QL22 chromosome, complete genome	blastn	109710	676	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
17862639	17862639	PRJDB9741_P_NODE_13875_length_189_cov_1.057143_g13558_i0	PRJDB9741	13875	189	1.057143	1.99800027	Allomeiothermus silvanus	52022	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g13558	i0	98.413	1	189	3	100	0	1	189	1666843	1666655	Meiothermus silvanus DSM 9946, complete genome	blastn	189	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
17862875	17862875	PRJDB9741_P_NODE_4955_length_286_cov_4.772152_g4639_i0	PRJDB9741	4955	286	4.772152	13.64835472	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	309	1.4200000000000002e-79	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g4639	i0	88.716	144.905594405594	257	23	89	5	33	286	543362	543109	Deinococcus sp. NW-56 chromosome, complete genome	blastn	41443	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
17862903	17862903	PRJDB9741_P_NODE_7515_length_229_cov_1.416667_g7198_i0	PRJDB9741	7515	229	1.416667	3.24416743	Trueperaceae bacterium	2026798	Bacteria	Bacteria	318	1.82e-82	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g7198	i0	91.703	19.3275109170306	229	19	100	0	1	229	3600544	3600772	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	4426	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
19136386	19136386	PRJDB9741_P_NODE_20436_length_177_cov_1.593750_g20119_i0	PRJDB9741	20436	177	1.59375	2.8209375	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	248	1.7799999999999998e-61	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g20119	i0	92.045	19.5988700564972	176	14	99	0	2	177	1406467	1406292	Thermus sp. NEB1569 chromosome, complete genome	blastn	3469	248	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
21383919	21383919	PRJDB9741_P_NODE_1297_length_730_cov_2.446402_g1024_i0	PRJDB9741	1297	730	2.446402	17.8587346	Truepera	332248	Bacteria	Bacteria	1016	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g1024	i0	91.907	153.401369863014	729	55	99	3	5	730	1381	2108	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	111983	1016	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
22962787	22962787	PRJDB9741_P_NODE_23259_length_172_cov_5.008130_g22942_i0	PRJDB9741	23259	172	5.00813	8.6139836	Deinococcus gobiensis	502394	Bacteria	Bacteria	82.4	1.84e-11	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g22942	i0	82.796	0.540697674418605	93	14	53	2	72	163	2615466	2615557	Deinococcus gobiensis I-0, complete genome	blastn	93	82.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
22962894	22962894	PRJDB9741_P_NODE_39619_length_161_cov_0.910714_g39302_i0	PRJDB9741	39619	161	0.910714	1.46624954	Deinococcus gobiensis	502394	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g39302	i0	98.758	7.52173913043478	161	2	100	0	1	161	1528503	1528663	Deinococcus gobiensis I-0, complete genome	blastn	1211	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
25207862	25207862	PRJDB9741_P_NODE_10100_length_207_cov_1.974684_g9783_i0	PRJDB9741	10100	207	1.974684	4.08759588	Truepera	332248	Bacteria	Bacteria	344	2.67e-90	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g9783	i0	96.618	300.942028985507	207	7	100	0	1	207	635	841	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	62295	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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