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

34 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
748658	748658	PRJNA773247_P_NODE_10241_length_490_cov_3.191847_g10158_i0	PRJNA773247	10241	490	3.191847	15.6400503	Deinococcus gobiensis	502394	Bacteria	Bacteria	861	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g10158	i0	98.367	32.3408163265306	490	8	100	0	1	490	292519	293008	Deinococcus gobiensis I-0, complete genome	blastn	15847	861	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
748665	748665	PRJNA773247_P_NODE_10561_length_481_cov_1.568627_g10478_i0	PRJNA773247	10561	481	1.568627	7.54509587	Deinococcus radiophilus	32062	Bacteria	Bacteria	320	1.16e-82	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g10478	i0	82.058	0.787941787941788	379	64	78	3	1	377	1439136	1438760	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	379	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
748668	748668	PRJNA773247_P_NODE_10621_length_479_cov_3.603448_g10538_i0	PRJNA773247	10621	479	3.603448	17.26051592	Deinococcus gobiensis	502394	Bacteria	Bacteria	861	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g10538	i0	99.163	2.48643006263048	478	4	99	0	2	479	1501428	1500951	Deinococcus gobiensis I-0, complete genome	blastn	1191	861	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3299963	3299963	PRJNA773247_P_NODE_19183_length_329_cov_4.957031_g19099_i0	PRJNA773247	19183	329	4.957031	16.30863199	Deinococcus gobiensis	502394	Bacteria	Bacteria	597	3.169999999999999e-166	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g19099	i0	99.392	83.2826747720365	329	2	100	0	1	329	2780854	2780526	Deinococcus gobiensis I-0, complete genome	blastn	27400	597	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3300320	3300320	PRJNA773247_P_NODE_9363_length_520_cov_2.937360_g9280_i0	PRJNA773247	9363	520	2.93736	15.274272	Deinococcus gobiensis	502394	Bacteria	Bacteria	944	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g9280	i0	99.423	45.0826923076923	520	3	100	0	1	520	1500762	1500243	Deinococcus gobiensis I-0, complete genome	blastn	23443	944	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3758710	3758710	PRJNA773247_P_NODE_13203_length_416_cov_3.565598_g13119_i0	PRJNA773247	13203	416	3.565598	14.83288768	Deinococcus	1298	Bacteria	Bacteria	627	5.23e-175	NTclustered	gi\|1751874214\|dbj\|AP021850.1\|	57498	g13119	i0	93.976	84.6947115384615	415	24	99	1	1	414	137570	137156	Deinococcus grandis ATCC 43672 plasmid: pDEGR-1 DNA, complete genome	blastn	35233	630	0.995238095238095	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
4576957	4576957	PRJNA773247_P_NODE_14404_length_394_cov_4.012461_g14320_i0	PRJNA773247	14404	394	4.012461	15.80909634	Deinococcus grandis	57498	Bacteria	Bacteria	701	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g14320	i0	98.731	12.3045685279188	394	5	100	0	1	394	1167449	1167842	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	4848	701	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
5852316	5852316	PRJNA773247_P_NODE_17405_length_350_cov_1.021661_g17321_i0	PRJNA773247	17405	350	1.021661	3.5758135	Deinococcus gobiensis	502394	Bacteria	Bacteria	490	5.91e-134	NTclustered	gi\|380001697\|gb\|CP002192.1\|	745776	g17321	i0	91.977	12.8057142857143	349	28	99	0	1	349	380125	380473	Deinococcus gobiensis I-0 plasmid P1, complete sequence	blastn	4482	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
7127460	7127460	PRJNA773247_P_NODE_14686_length_389_cov_2.667722_g14602_i0	PRJNA773247	14686	389	2.667722	10.37743858	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	675	0	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g14602	i0	97.943	25.2853470437018	389	8	100	0	1	389	2024532	2024920	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	9836	675	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
7127611	7127611	PRJNA773247_P_NODE_26366_length_272_cov_1.356784_g26282_i0	PRJNA773247	26366	272	1.356784	3.69045248	Deinococcus gobiensis	502394	Bacteria	Bacteria	392	1.2899999999999997e-104	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g26282	i0	92.647	1.50367647058824	272	20	100	0	1	272	2160812	2161083	Deinococcus gobiensis I-0, complete genome	blastn	409	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
7127842	7127842	PRJNA773247_P_NODE_746_length_2178_cov_3.348219_g731_i0	PRJNA773247	746	2178	3.348219	72.92420982	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	1882	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g731	i0	97.632	25.2121212121212	1098	25	100	1	1082	2178	2585152	2586249	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	54912	1882	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8401945	8401945	PRJNA773247_P_NODE_16507_length_361_cov_1.270833_g16423_i0	PRJNA773247	16507	361	1.270833	4.58770713	Deinococcus gobiensis	502394	Bacteria	Bacteria	662	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g16423	i0	99.723	49.6675900277008	361	1	100	0	1	361	292049	292409	Deinococcus gobiensis I-0, complete genome	blastn	17930	662	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
8402166	8402166	PRJNA773247_P_NODE_3067_length_1106_cov_18.862536_g3007_i0	PRJNA773247	3067	1106	18.862536	208.61964816	Deinococcus gobiensis	502394	Bacteria	Bacteria	1050	0	NTclustered	gi\|380002081\|gb\|CP002193.1\|	745776	g3007	i0	88.734	5.15099457504521	861	94	78	3	244	1102	230149	229290	Deinococcus gobiensis I-0 plasmid P2, complete sequence	blastn	5697	1050	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
8860159	8860159	PRJNA773247_P_NODE_13687_length_407_cov_1.278443_g13603_i0	PRJNA773247	13687	407	1.278443	5.20326301	Deinococcus	1298	Bacteria	Bacteria	741	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g13603	i0	99.509	17.990171990172	407	2	100	0	1	407	2587467	2587061	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	7322	741	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
9677249	9677249	PRJNA773247_P_NODE_17428_length_349_cov_7.166667_g17344_i0	PRJNA773247	17428	349	7.166667	25.01166783	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	634	2.5699999999999996e-177	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g17344	i0	99.427	37.2320916905444	349	2	100	0	1	349	2039002	2039350	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	12994	634	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
9677396	9677396	PRJNA773247_P_NODE_27568_length_265_cov_1.494792_g27484_i0	PRJNA773247	27568	265	1.494792	3.9611988	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	451	2.04e-122	NTclustered	gi\|1435318733\|gb\|CP031159.1\|	980427	g27484	i0	97.358	4.99245283018868	265	7	100	0	1	265	145286	145550	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdA, complete sequence	blastn	1323	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
10952958	10952958	PRJNA773247_P_NODE_2309_length_1315_cov_39.058776_g2262_i0	PRJNA773247	2309	1315	39.058776	513.6229044	Deinococcus altitudinis	468914	Bacteria	Bacteria	665	0	NTclustered	gi\|2865408430\|gb\|CP129417.1\|	468914	g2262	i0	81.807	36.1642585551331	808	133	61	13	477	1277	36577	35777	Deinococcus altitudinis strain LMG 24022 plasmid unnamed2, complete sequence	blastn	47556	665	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
10952981	10952981	PRJNA773247_P_NODE_24949_length_281_cov_1.211538_g24865_i0	PRJNA773247	24949	281	1.211538	3.40442178	Deinococcus gobiensis	502394	Bacteria	Bacteria	503	5.95e-138	NTclustered	gi\|380002081\|gb\|CP002193.1\|	745776	g24865	i0	98.932	91.2775800711744	281	3	100	0	1	281	249540	249260	Deinococcus gobiensis I-0 plasmid P2, complete sequence	blastn	25649	503	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
12228397	12228397	PRJNA773247_P_NODE_13070_length_419_cov_2.395954_g12987_i0	PRJNA773247	13070	419	2.395954	10.03904726	Deinococcus aquaticus	328692	Bacteria	Bacteria	507	7.16e-139	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g12987	i0	97.315	16.7183770883055	298	8	71	0	122	419	2312310	2312013	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	7005	507	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
12228714	12228714	PRJNA773247_P_NODE_34190_length_242_cov_2.278107_g34106_i0	PRJNA773247	34190	242	2.278107	5.51301894	Deinococcus gobiensis	502394	Bacteria	Bacteria	327	3.23e-85	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g34106	i0	92.889	0.929752066115702	225	16	93	0	18	242	2161495	2161271	Deinococcus gobiensis I-0, complete genome	blastn	225	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
12228726	12228726	PRJNA773247_P_NODE_35510_length_236_cov_2.822086_g35426_i0	PRJNA773247	35510	236	2.822086	6.66012296	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	381	2.379999999999999e-101	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g35426	i0	95.763	2.98728813559322	236	10	100	0	1	236	3036214	3036449	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	705	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
13502656	13502656	PRJNA773247_P_NODE_29051_length_257_cov_1.429348_g28967_i0	PRJNA773247	29051	257	1.429348	3.67342436	Deinococcus gobiensis	502394	Bacteria	Bacteria	431	2.57e-116	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g28967	i0	96.887	2.00778210116732	257	8	100	0	1	257	1745921	1745665	Deinococcus gobiensis I-0, complete genome	blastn	516	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
18600419	18600419	PRJNA773247_P_NODE_11215_length_463_cov_1.553846_g11132_i0	PRJNA773247	11215	463	1.553846	7.19430698	Deinococcus grandis	57498	Bacteria	Bacteria	403	1.0799999999999999e-107	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g11132	i0	97.863	2.32397408207343	234	3	100	2	232	463	70833	71066	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1076	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18600596	18600596	PRJNA773247_P_NODE_2195_length_1347_cov_80.972527_g2148_i0	PRJNA773247	2195	1347	80.972527	1090.69993869	Deinococcus gobiensis	502394	Bacteria	Bacteria	1965	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g2148	i0	93.101	18.3066072754269	1348	84	99	9	6	1344	962959	961612	Deinococcus gobiensis I-0, complete genome	blastn	24659	1965	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
19875505	19875505	PRJNA773247_P_NODE_17956_length_343_cov_2.348148_g17872_i0	PRJNA773247	17956	343	2.348148	8.05414764	Deinococcus gobiensis	502394	Bacteria	Bacteria	604	1.9899999999999992e-168	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g17872	i0	99.399	0.970845481049563	333	2	97	0	11	343	293103	293435	Deinococcus gobiensis I-0, complete genome	blastn	333	604	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
19875540	19875540	PRJNA773247_P_NODE_20876_length_312_cov_7.882845_g20792_i0	PRJNA773247	20876	312	7.882845	24.5944764	Deinococcus gobiensis	502394	Bacteria	Bacteria	387	7.039999999999998e-103	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g20792	i0	89.508	4.35576923076923	305	32	98	0	8	312	361433	361129	Deinococcus gobiensis I-0, complete genome	blastn	1359	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
21151771	21151771	PRJNA773247_P_NODE_9437_length_517_cov_3.538288_g9354_i0	PRJNA773247	9437	517	3.538288	18.29294896	Deinococcus grandis	57498	Bacteria	Bacteria	737	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g9354	i0	93.01	3.23984526112186	515	20	99	9	2	514	2114485	2114985	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1675	737	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
21609158	21609158	PRJNA773247_P_NODE_17817_length_345_cov_1.488971_g17733_i0	PRJNA773247	17817	345	1.488971	5.13694995	Deinococcus	1298	Bacteria	Bacteria	510	4.48e-140	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g17733	i0	93.333	5.74782608695652	345	23	100	0	1	345	508714	508370	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	1983	510	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
22426015	22426015	PRJNA773247_P_NODE_13058_length_419_cov_4.919075_g12975_i0	PRJNA773247	13058	419	4.919075	20.61092425	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	745	0	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g12975	i0	98.804	45.9904534606205	418	5	99	0	2	419	2142336	2142753	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	19270	745	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22426174	22426174	PRJNA773247_P_NODE_23578_length_290_cov_2.737327_g23494_i0	PRJNA773247	23578	290	2.737327	7.9382483	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	63.9	1.24e-5	NTclustered	gi\|359289533\|gb\|CP003126.1\|	1111069	g23494	i0	89.796	0.289655172413793	49	5	17	0	44	92	1865176	1865224	Thermus sp. CCB_US3_UF1, complete genome	blastn	84	63.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
22426241	22426241	PRJNA773247_P_NODE_28578_length_259_cov_3.456989_g28494_i0	PRJNA773247	28578	259	3.456989	8.95360151	Deinococcus gobiensis	502394	Bacteria	Bacteria	433	7.21e-117	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g28494	i0	97.255	36.8223938223938	255	7	98	0	1	255	1986365	1986111	Deinococcus gobiensis I-0, complete genome	blastn	9537	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24975511	24975511	PRJNA773247_P_NODE_22100_length_302_cov_1.694323_g22016_i0	PRJNA773247	22100	302	1.694323	5.11685546	Deinococcus gobiensis	502394	Bacteria	Bacteria	534	2.2899999999999998e-147	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g22016	i0	98.671	0.996688741721854	301	4	99	0	1	301	363854	363554	Deinococcus gobiensis I-0, complete genome	blastn	301	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24975608	24975608	PRJNA773247_P_NODE_28240_length_261_cov_2.446809_g28156_i0	PRJNA773247	28240	261	2.446809	6.38617149	Deinococcus gobiensis	502394	Bacteria	Bacteria	255	1.69e-63	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g28156	i0	91.005	0.724137931034483	189	17	72	0	73	261	1138826	1139014	Deinococcus gobiensis I-0, complete genome	blastn	189	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24975687	24975687	PRJNA773247_P_NODE_33840_length_243_cov_0.905882_g33756_i0	PRJNA773247	33840	243	0.905882	2.20129326	Deinococcus proteolyticus	55148	Bacteria	Bacteria	322	1.51e-83	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g33756	i0	90.871	1.27160493827161	241	20	99	2	1	240	1803373	1803612	Deinococcus proteolyticus MRP, complete genome	blastn	309	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus

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