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

34 rows where analysis = "blastn", bioproject = "PRJNA695273" 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
677192	677192	PRJNA695273_P_NODE_143741_length_246_cov_0.890173_g142983_i0	PRJNA695273	143741	246	0.890173	2.18982558	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g142983	i0	97.967	137.682926829268	246	5	100	0	1	246	69216	69461	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	33870	427	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
1182241	1182241	PRJNA695273_P_NODE_150041_length_244_cov_0.900585_g149283_i0	PRJNA695273	150041	244	0.900585	2.1974274	Deinococcus	1298	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g149283	i0	97.131	41	244	7	100	0	1	244	379608	379365	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	10004	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
1952561	1952561	PRJNA695273_P_NODE_118522_length_258_cov_2.497297_g117764_i0	PRJNA695273	118522	258	2.497297	6.44302626	Deinococcus grandis	57498	Bacteria	Bacteria	427	3.34e-115	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g117764	i0	96.512	4.84883720930233	258	9	100	0	1	258	1433804	1433547	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1251	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
1953164	1953164	PRJNA695273_P_NODE_143962_length_246_cov_0.890173_g143204_i0	PRJNA695273	143962	246	0.890173	2.18982558	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	263	9.430000000000001e-66	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g143204	i0	91.237	0.788617886178862	194	15	78	2	54	246	1083966	1083774	Deinococcus sp. NW-56 chromosome, complete genome	blastn	194	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
2458732	2458732	PRJNA695273_P_NODE_89122_length_292_cov_1.757991_g88364_i0	PRJNA695273	89122	292	1.757991	5.13333372	Deinococcus	1298	Bacteria	Bacteria	518	2.22e-142	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g88364	i0	98.63	182.020547945205	292	4	100	0	1	292	2595745	2595454	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	53150	523	0.990439770554493	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
3227351	3227351	PRJNA695273_P_NODE_109223_length_269_cov_1.571429_g108465_i0	PRJNA695273	109223	269	1.571429	4.22714401	Deinococcus ficus	317577	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g108465	i0	99.628	41.2676579925651	269	1	100	0	1	269	441518	441786	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	11101	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
3227742	3227742	PRJNA695273_P_NODE_125903_length_251_cov_0.865169_g125145_i0	PRJNA695273	125903	251	0.865169	2.17157419	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	315	2.6299999999999998e-81	NTclustered	gi\|1339790004\|gb\|CP026517.1\|	2080419	g125145	i0	89.796	9.98804780876494	245	25	98	0	1	245	67196	66952	Deinococcus sp. NW-56 plasmid unnamed1, complete sequence	blastn	2507	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3227974	3227974	PRJNA695273_P_NODE_135543_length_248_cov_0.880000_g134785_i0	PRJNA695273	135543	248	0.88	2.1824	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g134785	i0	100	2.99596774193548	248	0	100	0	1	248	499250	499003	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	743	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
3733943	3733943	PRJNA695273_P_NODE_142503_length_246_cov_0.890173_g141745_i0	PRJNA695273	142503	246	0.890173	2.18982558	Deinococcus	1298	Bacteria	Bacteria	174	4.55e-39	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g141745	i0	81.604	13.5894308943089	212	37	86	2	1	211	1319595	1319385	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	3343	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
4504461	4504461	PRJNA695273_P_NODE_110124_length_268_cov_1.579487_g109366_i0	PRJNA695273	110124	268	1.579487	4.23302516	Deinococcus ficus	317577	Bacteria	Bacteria	457	4.45e-124	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g109366	i0	97.388	9.97761194029851	268	7	100	0	1	268	381889	382156	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	2674	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
4505029	4505029	PRJNA695273_P_NODE_133824_length_249_cov_0.875000_g133066_i0	PRJNA695273	133824	249	0.875	2.17875	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	147	1e-30	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g133066	i0	95.652	1.77911646586345	92	3	37	1	1	92	446706	446616	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	443	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4505684	4505684	PRJNA695273_P_NODE_161084_length_241_cov_0.916667_g160326_i0	PRJNA695273	161084	241	0.916667	2.20916747	Deinococcus grandis	57498	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g160326	i0	91.286	35.448132780083	241	21	100	0	1	241	1621923	1621683	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	8543	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
5010355	5010355	PRJNA695273_P_NODE_137604_length_248_cov_0.880000_g136846_i0	PRJNA695273	137604	248	0.88	2.1824	Thermus	270	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2701833777\|dbj\|AP031329.1\|	274	g136846	i0	99.194	21.0524193548387	248	2	100	0	1	248	204742	204989	Thermus thermophilus TF24 plasmid pTF24b DNA, complete sequence	blastn	5221	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
7055742	7055742	PRJNA695273_P_NODE_142466_length_246_cov_0.890173_g141708_i0	PRJNA695273	142466	246	0.890173	2.18982558	Deinococcus grandis	57498	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g141708	i0	97.154	8.44715447154472	246	7	100	0	1	246	552204	552449	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	2078	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7057758	7057758	PRJNA695273_P_NODE_87806_length_295_cov_0.909910_g87048_i0	PRJNA695273	87806	295	0.90991	2.6842345	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	518	2.25e-142	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g87048	i0	98.305	26.7898305084746	295	5	100	0	1	295	1493155	1492861	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	7903	518	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8330290	8330290	PRJNA695273_P_NODE_141147_length_247_cov_0.879310_g140389_i0	PRJNA695273	141147	247	0.87931	2.1718957	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	252	2.05e-62	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g140389	i0	85.957	4.81781376518219	235	33	95	0	1	235	507805	508039	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	1190	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
8836395	8836395	PRJNA695273_P_NODE_85467_length_299_cov_1.132743_g84709_i0	PRJNA695273	85467	299	1.132743	3.38690157	Deinococcus	1298	Bacteria	Bacteria	525	1.3599999999999994e-144	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g84709	i0	98.328	51.4247491638796	299	5	100	0	1	299	820321	820619	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	15376	525	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
10880703	10880703	PRJNA695273_P_NODE_121849_length_254_cov_2.541436_g121091_i0	PRJNA695273	121849	254	2.541436	6.45524744	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	337	5.69e-88	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g121091	i0	90.551	1	254	24	100	0	1	254	2184051	2184304	Deinococcus sp. NW-56 chromosome, complete genome	blastn	254	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
10881120	10881120	PRJNA695273_P_NODE_139009_length_247_cov_0.885057_g138251_i0	PRJNA695273	139009	247	0.885057	2.18609079	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	176	1.27e-39	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g138251	i0	82.843	1.07287449392713	204	27	81	7	1	200	712768	712967	Deinococcus sp. NW-56 chromosome, complete genome	blastn	265	176	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
10882301	10882301	PRJNA695273_P_NODE_47709_length_393_cov_0.962500_g46951_i0	PRJNA695273	47709	393	0.9625	3.782625	Deinococcus metallilatus	1211322	Bacteria	Bacteria	383	1.1699999999999998e-101	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g46951	i0	86.325	44.5394402035623	351	48	89	0	1	351	124813	124463	Deinococcus metallilatus strain MA1002 chromosome	blastn	17504	383	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
10883334	10883334	PRJNA695273_P_NODE_95929_length_284_cov_1.464455_g95171_i0	PRJNA695273	95929	284	1.464455	4.1590522	Deinococcus aquaticus	328692	Bacteria	Bacteria	497	2.8e-136	NTclustered	gi\|2444124408\|gb\|CP115168.1\|	328692	g95171	i0	98.239	1	284	5	100	0	1	284	86614	86331	Deinococcus aquaticus strain PB-314 plasmid pDATS03, complete sequence	blastn	284	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
11387195	11387195	PRJNA695273_P_NODE_97529_length_282_cov_2.172249_g96771_i0	PRJNA695273	97529	282	2.172249	6.12574218	Bacteria	2	Bacteria	Bacteria	516	7.67e-142	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g96771	i0	99.645	57.8262411347518	282	1	100	0	1	282	325	606	Thermus aquaticus DNA polymerase (PolI) gene	blastn	16307	516	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
12155448	12155448	PRJNA695273_P_NODE_105790_length_273_cov_1.540000_g105032_i0	PRJNA695273	105790	273	1.54	4.2042	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	339	1.72e-88	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g105032	i0	89.011	89.9304029304029	273	30	100	0	1	273	829705	829433	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	24551	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
12156460	12156460	PRJNA695273_P_NODE_147250_length_245_cov_0.895349_g146492_i0	PRJNA695273	147250	245	0.895349	2.19360505	Deinococcus radiophilus	32062	Bacteria	Bacteria	287	5.57e-73	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g146492	i0	87.755	5.8530612244898	245	30	100	0	1	245	599441	599197	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	1434	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
14707449	14707449	PRJNA695273_P_NODE_57572_length_360_cov_1.432056_g56814_i0	PRJNA695273	57572	360	1.432056	5.1554016	Thermus aquaticus	271	Bacteria	Bacteria	627	4.459999999999999e-175	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g56814	i0	100	23.8638888888889	339	0	94	0	1	339	1843754	1844092	Thermus aquaticus Y51MC23, complete genome	blastn	8591	627	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
16486149	16486149	PRJNA695273_P_NODE_68553_length_332_cov_1.637066_g67795_i0	PRJNA695273	68553	332	1.637066	5.43505912	Deinococcus	1298	Bacteria	Bacteria	479	1.2099999999999996e-130	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g67795	i0	98.175	232.484939759036	274	5	83	0	1	274	880577	880304	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	77185	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
17255433	17255433	PRJNA695273_P_NODE_159234_length_241_cov_0.916667_g158476_i0	PRJNA695273	159234	241	0.916667	2.20916747	Thermus thermophilus	274	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2074862301\|dbj\|AP024930.1\|	274	g158476	i0	99.17	281.464730290456	241	2	100	0	1	241	131389	131629	Thermus thermophilus AA2-2 plasmid pAA2-2b DNA, complete sequence	blastn	67833	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
17255874	17255874	PRJNA695273_P_NODE_33774_length_468_cov_4.111392_g33016_i0	PRJNA695273	33774	468	4.111392	19.24131456	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	763	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g33016	i0	96.146	196.989316239316	467	18	99	0	2	468	2417498	2417964	Deinococcus sp. NW-56 chromosome, complete genome	blastn	92191	763	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
18530303	18530303	PRJNA695273_P_NODE_55135_length_367_cov_12.414966_g54377_i0	PRJNA695273	55135	367	12.414966	45.56292522	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	612	1.2699999999999999e-170	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g54377	i0	99.407	33.7493188010899	337	2	100	0	1	337	2238426	2238762	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	12386	612	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
19034015	19034015	PRJNA695273_P_NODE_151475_length_243_cov_1.811765_g150717_i0	PRJNA695273	151475	243	1.811765	4.40258895	Deinococcus	1298	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g150717	i0	93.827	14	243	15	100	0	1	243	69680	69438	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	3402	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
21079530	21079530	PRJNA695273_P_NODE_140797_length_247_cov_0.885057_g140039_i0	PRJNA695273	140797	247	0.885057	2.18609079	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g140039	i0	99.19	35.4777327935223	247	2	100	0	1	247	2646400	2646154	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	8763	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
21080578	21080578	PRJNA695273_P_NODE_43737_length_409_cov_2.041667_g42979_i0	PRJNA695273	43737	409	2.041667	8.35041803	Deinococcus taeanensis	2737050	Bacteria	Bacteria	322	2.71e-83	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g42979	i0	81.235	12.2371638141809	405	71	99	4	6	409	708105	707705	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	5005	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
22354305	22354305	PRJNA695273_P_NODE_133918_length_249_cov_0.875000_g133160_i0	PRJNA695273	133918	249	0.875	2.17875	Deinococcus ficus	317577	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g133160	i0	99.197	1	249	2	100	0	1	249	2465097	2465345	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	249	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
24902515	24902515	PRJNA695273_P_NODE_102200_length_277_cov_1.509804_g101442_i0	PRJNA695273	102200	277	1.509804	4.18215708	Trueperaceae bacterium	2026798	Bacteria	Bacteria	357	4.82e-94	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g101442	i0	90.146	470.501805054152	274	27	99	0	1	274	3599693	3599966	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	130329	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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