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

34 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
862574	862574	PRJNA888821_P_NODE_13561_length_310_cov_7.645570_g13479_i0	PRJNA888821	13561	310	7.64557	23.701267	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	272	2.04e-68	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g13479	i0	99.333	0.967741935483871	150	1	97	0	1	150	1126850	1126999	Deinococcus sp. NW-56 chromosome, complete genome	blastn	300	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
862824	862824	PRJNA888821_P_NODE_29941_length_270_cov_6.030457_g29858_i0	PRJNA888821	29941	270	6.030457	16.2822339	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	448	2.6999999999999998e-121	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g29858	i0	96.654	4.6962962962963	269	9	99	0	1	269	1859220	1859488	Thermus sp. NEB1569 chromosome, complete genome	blastn	1268	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
862950	862950	PRJNA888821_P_NODE_37701_length_244_cov_11.842105_g37618_i0	PRJNA888821	37701	244	11.842105	28.8947362	Deinococcus grandis	57498	Bacteria	Bacteria	405	1.47e-108	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g37618	i0	97.468	8.66803278688525	237	6	97	0	1	237	972032	972268	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	2115	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
2138007	2138007	PRJNA888821_P_NODE_14342_length_310_cov_7.042194_g14260_i0	PRJNA888821	14342	310	7.042194	21.8308014	Deinococcus geothermalis	68909	Bacteria	Bacteria	267	9.5e-67	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g14260	i0	98.667	3.41612903225806	150	2	97	0	161	310	83715	83566	Deinococcus geothermalis DSM 11300, complete genome	blastn	1059	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
2517684	2517684	PRJNA888821_P_NODE_6122_length_312_cov_5.100418_g6040_i0	PRJNA888821	6122	312	5.100418	15.91330416	Deinococci	188787	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|399532133\|gb\|JQ627417.1\|	310703	g6040	i0	100	99.9775641025641	312	0	100	0	1	312	437	748	Uncultured Deinococcales bacterium clone A3_1_3B_118 small subunit ribosomal RNA gene, partial sequence	blastn	31193	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			uncultured Deinococcales bacterium
3413723	3413723	PRJNA888821_P_NODE_38043_length_244_cov_0.900585_g37960_i0	PRJNA888821	38043	244	0.900585	2.1974274	Deinococcus metallilatus	1211322	Bacteria	Bacteria	374	4.1399999999999986e-99	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g37960	i0	94.286	42.3237704918033	245	12	100	2	1	244	2442344	2442101	Deinococcus metallilatus strain MA1002 chromosome	blastn	10327	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
4690989	4690989	PRJNA888821_P_NODE_15724_length_310_cov_6.025316_g15642_i0	PRJNA888821	15724	310	6.025316	18.6784796	Thermus brockianus	56956	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g15642	i0	100	1.87096774193548	150	0	96	0	161	310	1813810	1813661	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	580	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
5069955	5069955	PRJNA888821_P_NODE_36944_length_246_cov_2.791908_g36861_i0	PRJNA888821	36944	246	2.791908	6.86809368	Thermus	270	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g36861	i0	100	45.6585365853659	243	0	99	0	1	243	481592	481834	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	11232	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
5069977	5069977	PRJNA888821_P_NODE_39244_length_241_cov_2.857143_g39161_i0	PRJNA888821	39244	241	2.857143	6.88571463	Truepera	332248	Bacteria	Bacteria	357	4.1099999999999997e-94	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g39161	i0	94.043	204.107883817427	235	14	98	0	7	241	2234	2000	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	49190	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6345978	6345978	PRJNA888821_P_NODE_43205_length_227_cov_14.538961_g43122_i0	PRJNA888821	43205	227	14.538961	33.00344147	Deinococcus	1298	Bacteria	Bacteria	255	1.44e-63	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g43122	i0	87.111	15.9383259911894	225	29	99	0	3	227	1095493	1095269	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	3618	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7240877	7240877	PRJNA888821_P_NODE_27406_length_281_cov_9.750000_g27324_i0	PRJNA888821	27406	281	9.75	27.3975	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	497	2.77e-136	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g27324	i0	98.577	8.86120996441281	281	4	100	0	1	281	1620009	1620289	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	2490	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
7241084	7241084	PRJNA888821_P_NODE_39266_length_241_cov_2.017857_g39183_i0	PRJNA888821	39266	241	2.017857	4.86303537	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	399	6.729999999999998e-107	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g39183	i0	96.68	215.124481327801	241	7	99	1	2	241	1637881	1637641	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	51845	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
8515711	8515711	PRJNA888821_P_NODE_3067_length_389_cov_1.762658_g2986_i0	PRJNA888821	3067	389	1.762658	6.85673962	Trueperaceae bacterium	2026798	Bacteria	Bacteria	492	1.85e-134	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g2986	i0	89.487	372.231362467866	390	40	100	1	1	389	6910	6521	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	144798	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
8894992	8894992	PRJNA888821_P_NODE_5707_length_317_cov_1.258197_g5625_i0	PRJNA888821	5707	317	1.258197	3.98848449	Truepera	332248	Bacteria	Bacteria	466	8.95e-127	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5625	i0	93.103	176.302839116719	319	20	100	2	1	317	2028	1710	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	55888	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
9791059	9791059	PRJNA888821_P_NODE_47768_length_212_cov_8.273381_g47685_i0	PRJNA888821	47768	212	8.273381	17.53956772	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g47685	i0	100	1	212	0	100	0	1	212	1573349	1573560	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	212	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
11066053	11066053	PRJNA888821_P_NODE_11969_length_310_cov_8.974684_g11887_i0	PRJNA888821	11969	310	8.974684	27.8215204	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g11887	i0	100	1.92903225806452	150	0	96	0	1	150	717554	717703	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	598	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
11445786	11445786	PRJNA888821_P_NODE_44509_length_223_cov_6.426667_g44426_i0	PRJNA888821	44509	223	6.426667	14.33146741	Deinococcus	1298	Bacteria	Bacteria	401	1.7099999999999992e-107	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g44426	i0	99.103	29.695067264574	223	2	100	0	1	223	1923235	1923013	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	6622	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12341861	12341861	PRJNA888821_P_NODE_25550_length_290_cov_3.276498_g25468_i0	PRJNA888821	25550	290	3.276498	9.5018442	Thermus parvatiensis	456163	Bacteria	Bacteria	305	1.87e-78	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g25468	i0	98.286	25.0689655172414	175	2	60	1	117	290	1797440	1797614	Thermus parvatiensis strain RL, complete genome	blastn	7270	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
12342413	12342413	PRJNA888821_P_NODE_9650_length_310_cov_11.565401_g9568_i0	PRJNA888821	9650	310	11.565401	35.8527431	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	250	9.57e-62	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g9568	i0	96.667	1.93548387096774	150	5	48	0	161	310	1184154	1184303	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	600	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
12721450	12721450	PRJNA888821_P_NODE_4070_length_355_cov_1.872340_g3989_i0	PRJNA888821	4070	355	1.87234	6.646807	Deinococcus	1298	Bacteria	Bacteria	518	2.76e-142	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g3989	i0	92.958	201.245070422535	355	25	100	0	1	355	69610	69964	Deinococcus puniceus strain DY1, complete genome	blastn	71442	518	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
16165814	16165814	PRJNA888821_P_NODE_46133_length_217_cov_10.583333_g46050_i0	PRJNA888821	46133	217	10.583333	22.96583261	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	385	1.66e-102	NTclustered	gi\|1819263924\|gb\|CP049359.1\|	1288484	g46050	i0	98.618	1	217	3	100	0	1	217	164079	163863	Deinococcus wulumuqiensis R12 plasmid unnamed2, complete sequence	blastn	217	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16165910	16165910	PRJNA888821_P_NODE_51473_length_201_cov_15.835938_g51390_i0	PRJNA888821	51473	201	15.835938	31.83023538	Deinococcus geothermalis	68909	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g51390	i0	100	3.78109452736318	201	0	100	0	1	201	45978	46178	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	760	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
17440692	17440692	PRJNA888821_P_NODE_11894_length_310_cov_9.033755_g11812_i0	PRJNA888821	11894	310	9.033755	28.0046405	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	185	2.7399999999999998e-42	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g11812	i0	89.189	1.41290322580645	148	16	48	0	163	310	1969762	1969615	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	438	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
17441392	17441392	PRJNA888821_P_NODE_52534_length_198_cov_53.360000_g52451_i0	PRJNA888821	52534	198	53.36	105.6528	Deinococcus metallilatus	1211322	Bacteria	Bacteria	244	2.64e-60	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g52451	i0	88.889	27.2878787878788	198	22	100	0	1	198	394061	394258	Deinococcus metallilatus strain MA1002 chromosome	blastn	5403	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
19093143	19093143	PRJNA888821_P_NODE_18115_length_310_cov_4.312236_g18033_i0	PRJNA888821	18115	310	4.312236	13.3679316	Thermus	270	Bacteria	Bacteria	206	2.1e-48	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g18033	i0	93.478	24.5096774193548	138	9	45	0	173	310	298863	298726	Thermus thermophilus HB5008 DNA, complete genome	blastn	7598	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
19989802	19989802	PRJNA888821_P_NODE_5196_length_327_cov_1.212598_g5114_i0	PRJNA888821	5196	327	1.212598	3.96519546	Trueperaceae bacterium	2026798	Bacteria	Bacteria	444	4.34e-120	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g5114	i0	91.045	674.489296636086	335	21	100	4	1	327	3600771	3601104	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	220558	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
21264720	21264720	PRJNA888821_P_NODE_26137_length_287_cov_10.471963_g26055_i0	PRJNA888821	26137	287	10.471963	30.05453381	Deinococcus geothermalis	68909	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g26055	i0	100	2.79442508710801	287	0	100	0	1	287	275184	274898	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	802	531	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
22539320	22539320	PRJNA888821_P_NODE_12138_length_310_cov_8.818565_g12056_i0	PRJNA888821	12138	310	8.818565	27.3375515	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g12056	i0	100	8.97741935483871	150	0	97	0	1	150	213129	213278	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	2783	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22539794	22539794	PRJNA888821_P_NODE_40658_length_236_cov_8.834356_g40575_i0	PRJNA888821	40658	236	8.834356	20.84908016	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g40575	i0	100	2.63983050847458	236	0	100	0	1	236	1588437	1588202	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	623	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
22919321	22919321	PRJNA888821_P_NODE_22038_length_308_cov_12.753191_g21956_i0	PRJNA888821	22038	308	12.753191	39.27982828	Thermus	270	Bacteria	Bacteria	276	1.57e-69	NTclustered	gi\|2199613113\|dbj\|AP025598.1\|	274	g21956	i0	100	8.51948051948052	149	0	97	0	1	149	17805	17953	Thermus thermophilus SNM1-1 plasmid pTthSNM1-1c DNA, complete sequence	blastn	2624	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
23815320	23815320	PRJNA888821_P_NODE_49299_length_207_cov_21.604478_g49216_i0	PRJNA888821	49299	207	21.604478	44.72126946	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	377	2.63e-100	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g49216	i0	99.517	218.24154589372	207	1	100	0	1	207	1638159	1638365	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	45176	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
25088675	25088675	PRJNA888821_P_NODE_17660_length_310_cov_4.662447_g17578_i0	PRJNA888821	17660	310	4.662447	14.4535857	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	196	1.26e-45	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g17578	i0	90.667	0.483870967741935	150	10	48	4	1	148	2586113	2585966	Deinococcus sp. NW-56 chromosome, complete genome	blastn	150	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
25088847	25088847	PRJNA888821_P_NODE_27980_length_279_cov_1.344660_g27898_i0	PRJNA888821	27980	279	1.34466	3.7516014	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	383	8.02e-102	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g27898	i0	91.429	154.612903225806	280	23	100	1	1	279	544744	544465	Deinococcus sp. NW-56 chromosome, complete genome	blastn	43137	383	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
25468427	25468427	PRJNA888821_P_NODE_24000_length_295_cov_2.112613_g23918_i0	PRJNA888821	24000	295	2.112613	6.23220835	Truepera	332248	Bacteria	Bacteria	412	1.0899999999999999e-110	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g23918	i0	91.864	371.105084745763	295	24	100	0	1	295	849	555	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	109476	412	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);;