metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA773778" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA773778" 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
750857	750857	PRJNA773778_S_NODE_19801_length_330_cov_1.980545_g19651_i0	PRJNA773778	19801	330	1.980545	6.5357985	Mesotoga infera	1236046	Bacteria	Bacteria	425	1.59e-114	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g19651	i0	91.139	18.5151515151515	316	25	95	3	17	330	2163724	2163410	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	6110	425	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
2027098	2027098	PRJNA773778_S_NODE_32602_length_274_cov_1.149254_g32452_i0	PRJNA773778	32602	274	1.149254	3.14895596	Mesotoga infera	1236046	Bacteria	Bacteria	296	1.05e-75	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g32452	i0	86.397	1.99270072992701	272	36	99	1	1	272	253911	254181	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	546	296	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
2027424	2027424	PRJNA773778_S_NODE_45682_length_244_cov_1.333333_g45532_i0	PRJNA773778	45682	244	1.333333	3.25333252	Thermus thermophilus	274	Bacteria	Bacteria	370	5.35e-98	NTclustered	gi\|2074864999\|dbj\|AP024934.1\|	274	g45532	i0	99.029	33.7704918032787	206	2	84	0	39	244	179160	178955	Thermus thermophilus AA3-7 plasmid pAA3-7b DNA, complete sequence	blastn	8240	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3302608	3302608	PRJNA773778_S_NODE_46583_length_243_cov_0.905882_g46433_i0	PRJNA773778	46583	243	0.905882	2.20129326	Mesotoga infera	1236046	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g46433	i0	92.105	0.781893004115226	190	9	76	3	59	243	946741	946929	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	190	263	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
4579221	4579221	PRJNA773778_S_NODE_26764_length_296_cov_1.026906_g26614_i0	PRJNA773778	26764	296	1.026906	3.03964176	Mesotoga infera	1236046	Bacteria	Bacteria	254	7.02e-63	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g26614	i0	82.373	1.88175675675676	295	49	99	3	3	296	312152	311860	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	557	254	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
5854344	5854344	PRJNA773778_S_NODE_15365_length_364_cov_3.432990_g15215_i0	PRJNA773778	15365	364	3.43299	12.4960836	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	588	2.13e-163	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g15215	i0	98.507	20.282967032967	335	2	91	1	33	364	2423940	2423606	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	7383	588	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5854732	5854732	PRJNA773778_S_NODE_32565_length_274_cov_1.184080_g32415_i0	PRJNA773778	32565	274	1.18408	3.2443792	Mesotoga infera	1236046	Bacteria	Bacteria	143	1.45e-29	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g32415	i0	77.154	0.974452554744526	267	47	95	12	1	260	1736620	1736879	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	267	143	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
6311339	6311339	PRJNA773778_S_NODE_35945_length_263_cov_1.600000_g35795_i0	PRJNA773778	35945	263	1.6	4.208	Bacteria	2	Bacteria	Bacteria	379	9.7e-101	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g35795	i0	97.727	55.2927756653992	220	5	84	0	20	239	340	121	Thermus aquaticus DNA polymerase (PolI) gene	blastn	14542	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
8404109	8404109	PRJNA773778_S_NODE_2127_length_730_cov_1.211568_g1994_i0	PRJNA773778	2127	730	1.211568	8.8444464	Mesotoga infera	1236046	Bacteria	Bacteria	780	0	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g1994	i0	86.027	1.64520547945205	730	98	99	4	3	730	1855705	1856432	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	1201	780	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404680	8404680	PRJNA773778_S_NODE_45747_length_244_cov_1.122807_g45597_i0	PRJNA773778	45747	244	1.1228070000000001	2.73964908	Mesotoga infera	1236046	Bacteria	Bacteria	152	2.11e-32	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g45597	i0	89.831	0.983606557377049	118	12	50	0	126	243	1931067	1930950	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	240	152	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404686	8404686	PRJNA773778_S_NODE_46007_length_244_cov_0.900585_g45857_i0	PRJNA773778	46007	244	0.900585	2.1974274	Mesotoga infera	1236046	Bacteria	Bacteria	241	4.38e-59	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g45857	i0	84.836	1	244	31	100	4	1	244	1935325	1935562	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	244	241	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8404712	8404712	PRJNA773778_S_NODE_47347_length_242_cov_1.147929_g47197_i0	PRJNA773778	47347	242	1.147929	2.77798818	Mesotoga infera	1236046	Bacteria	Bacteria	311	3.26e-80	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g47197	i0	94.527	18.7809917355372	201	11	83	0	1	201	1062269	1062469	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	4545	311	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
8860401	8860401	PRJNA773778_S_NODE_14807_length_369_cov_7.320946_g14657_i0	PRJNA773778	14807	369	7.320946	27.01429074	Truepera	332248	Bacteria	Bacteria	313	1.46e-80	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g14657	i0	92.627	447.715447154472	217	16	59	0	2	218	762032	762248	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	165207	316	0.990506329113924	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
9679226	9679226	PRJNA773778_S_NODE_12568_length_394_cov_2.034268_g12418_i0	PRJNA773778	12568	394	2.034268	8.01501592	Mesotoga infera	1236046	Bacteria	Bacteria	508	1.86e-139	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g12418	i0	97.324	12.6522842639594	299	8	77	0	94	392	134666	134368	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	4985	508	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
10135995	10135995	PRJNA773778_S_NODE_6328_length_509_cov_9.594037_g6178_i0	PRJNA773778	6328	509	9.594037	48.83364833	Thermus	270	Bacteria	Bacteria	811	0	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g6178	i0	99.551	6.93123772102161	445	2	87	0	65	509	1901424	1901868	Thermus scotoductus SA-01, complete genome	blastn	3528	811	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10955016	10955016	PRJNA773778_S_NODE_20249_length_327_cov_18.637795_g20099_i0	PRJNA773778	20249	327	18.637795	60.94558965	Mesotoga infera	1236046	Bacteria	Bacteria	346	1.26e-90	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g20099	i0	85.928	3.0519877675841	334	36	100	10	1	327	2701843	2702172	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	998	346	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
10955401	10955401	PRJNA773778_S_NODE_36869_length_260_cov_2.208556_g36719_i0	PRJNA773778	36869	260	2.208556	5.7422456	Mesotoga infera	1236046	Bacteria	Bacteria	156	1.76e-33	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g36719	i0	77.606	0.996153846153846	259	56	99	2	1	258	1854546	1854289	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	259	156	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
10955527	10955527	PRJNA773778_S_NODE_41669_length_249_cov_1.420455_g41519_i0	PRJNA773778	41669	249	1.420455	3.53693295	Mesotoga infera	1236046	Bacteria	Bacteria	217	7.55e-52	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g41519	i0	82.661	0.995983935742972	248	39	99	4	1	246	1930931	1930686	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	248	217	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
12230558	12230558	PRJNA773778_S_NODE_19450_length_332_cov_5.308880_g19300_i0	PRJNA773778	19450	332	5.30888	17.6254816	Aminobacterium sp. MB27-C1	3070661	Bacteria	Bacteria	233	1.04e-56	NTclustered	gi\|2569590977\|gb\|CP133089.1\|	3070661	g19300	i0	79.641	1.46385542168675	334	60	99	8	3	332	655656	655985	Aminobacterium sp. MB27-C1 chromosome, complete genome	blastn	486	233	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium sp. MB27-C1
13504657	13504657	PRJNA773778_S_NODE_20131_length_328_cov_2.050980_g19981_i0	PRJNA773778	20131	328	2.05098	6.7272144	Mesotoga prima	1184387	Bacteria	Bacteria	335	2.7399999999999993e-87	NTclustered	gi\|387857666\|gb\|CP003532.1\|	660470	g19981	i0	90.8	1.15548780487805	250	23	76	0	1	250	2784102	2783853	Mesotoga prima MesG1.Ag.4.2, complete genome	blastn	379	335	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga prima
16054091	16054091	PRJNA773778_S_NODE_48293_length_241_cov_0.916667_g48143_i0	PRJNA773778	48293	241	0.916667	2.20916747	Deinococcus ficus	317577	Bacteria	Bacteria	355	1.48e-93	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g48143	i0	99.487	20.7759336099585	195	1	81	0	47	241	484464	484270	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	5007	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
17329737	17329737	PRJNA773778_S_NODE_4434_length_574_cov_1.083832_g4286_i0	PRJNA773778	4434	574	1.083832	6.22119568	Mesotoga infera	1236046	Bacteria	Bacteria	915	0	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g4286	i0	95.462	1.96515679442509	573	26	100	0	2	574	1948574	1949146	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	1128	915	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
18602686	18602686	PRJNA773778_S_NODE_21295_length_322_cov_0.867470_g21145_i0	PRJNA773778	21295	322	0.86747	2.7932534	Mesotoga infera	1236046	Bacteria	Bacteria	407	5.6e-109	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g21145	i0	89.474	2.52795031055901	323	32	100	2	1	322	1814909	1815230	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	814	407	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
19877687	19877687	PRJNA773778_S_NODE_19756_length_330_cov_8.575875_g19606_i0	PRJNA773778	19756	330	8.575875	28.3003875	Mesotoga infera	1236046	Bacteria	Bacteria	593	4.119999999999999e-165	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g19606	i0	99.091	3	330	3	100	0	1	330	2702172	2701843	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	990	593	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
21609499	21609499	PRJNA773778_S_NODE_49417_length_230_cov_3.745223_g49267_i0	PRJNA773778	49417	230	3.745223	8.6140129	Deinococcus	1298	Bacteria	Bacteria	366	6.46e-97	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g49267	i0	100	4.28260869565217	198	0	86	0	1	198	1831932	1832129	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	985	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
24159022	24159022	PRJNA773778_S_NODE_8519_length_457_cov_5.213542_g8369_i0	PRJNA773778	8519	457	5.213542	23.82588694	Thermus	270	Bacteria	Bacteria	819	0	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g8369	i0	98.911	41.0678336980306	459	3	100	1	1	457	50213	49755	Thermus oshimai strain Blanco chromosome, complete genome	blastn	18768	824	0.993932038834951	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai

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