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

26 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
610196	610196	PRJNA640143_S_NODE_6701_length_323_cov_199.562937_g6491_i0	PRJNA640143	6701	323	199.562937	644.58828651	Marinitoga aeolica	2809031	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2498963055\|gb\|CP069362.1\|	2809031	g6491	i0	100	0.086687306501548	28	0	9	0	163	190	7681	7654	Marinitoga aeolica strain BP5-C20A chromosome, complete genome	blastn	28	52.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga aeolica
1885817	1885817	PRJNA640143_S_NODE_11422_length_256_cov_2.018265_g11212_i0	PRJNA640143	11422	256	2.018265	5.1667584	Deinococcus puniceus	1182568	Bacteria	Bacteria	446	9.139999999999999e-121	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g11212	i0	98.047	187.76953125	256	5	100	0	1	256	70417	70162	Deinococcus puniceus strain DY1, complete genome	blastn	48069	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
3161062	3161062	PRJNA640143_S_NODE_323_length_1045_cov_3.929563_g282_i0	PRJNA640143	323	1045	3.929563	41.06393335	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1315	0	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g282	i0	89.469	292.264114832536	1054	93	100	12	1	1045	8416	7372	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	305416	1315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
3707101	3707101	PRJNA640143_S_NODE_24783_length_177_cov_2.857143_g24573_i0	PRJNA640143	24783	177	2.857143	5.05714311	Truepera	332248	Bacteria	Bacteria	209	8.39e-50	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g24573	i0	94.161	51.1186440677966	137	8	77	0	18	154	2580546	2580682	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	9048	209	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3707121	3707121	PRJNA640143_S_NODE_31443_length_154_cov_1.000000_g31233_i0	PRJNA640143	31443	154	1	1.54	Truepera	332248	Bacteria	Bacteria	202	1.19e-47	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g31233	i0	90.26	32.1753246753247	154	15	100	0	1	154	3179415	3179262	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	4955	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3707140	3707140	PRJNA640143_S_NODE_4663_length_379_cov_4.789474_g4455_i0	PRJNA640143	4663	379	4.789474	18.15210646	Truepera	332248	Bacteria	Bacteria	556	6.28e-154	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g4455	i0	93.14	739.87598944591	379	26	100	0	1	379	864	486	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	280413	556	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6259078	6259078	PRJNA640143_S_NODE_21865_length_188_cov_3.086093_g21655_i0	PRJNA640143	21865	188	3.086093	5.80185484	Deinococcus	1298	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g21655	i0	100	197.170212765957	188	0	100	0	1	188	69665	69852	Deinococcus puniceus strain DY1, complete genome	blastn	37068	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
6259089	6259089	PRJNA640143_S_NODE_2325_length_508_cov_33.991507_g1219_i1	PRJNA640143	2325	508	33.991507	172.67685556	Deinococcus	1298	Bacteria	Bacteria	752	0	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g1219	i1	95.349	204.744094488189	473	22	93	0	36	508	72473	72001	Deinococcus puniceus strain DY1, complete genome	blastn	104010	752	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
6259092	6259092	PRJNA640143_S_NODE_24545_length_178_cov_1.929078_g24335_i0	PRJNA640143	24545	178	1.929078	3.43375884	Thermus	270	Bacteria	Bacteria	270	3.82e-68	NTclustered	gi\|2091883088\|dbj\|AP025158.1\|	274	g24335	i0	97.468	245.370786516854	158	4	89	0	1	158	65211	65368	Thermus thermophilus TMY DNA, complete genome	blastn	43676	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
7533182	7533182	PRJNA640143_S_NODE_1146_length_661_cov_189.318910_g1040_i0	PRJNA640143	1146	661	189.31891	1251.3979951	Truepera	332248	Bacteria	Bacteria	680	0	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g1040	i0	90.485	403.759455370651	515	49	78	0	3	517	761734	762248	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	266885	680	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7533247	7533247	PRJNA640143_S_NODE_19946_length_196_cov_387.018868_g19736_i0	PRJNA640143	19946	196	387.018868	758.55698128	Bacteria	2	Bacteria	Bacteria	289	1.1899999999999998e-73	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g19736	i0	100	24.5969387755102	156	0	80	0	1	156	289345	289500	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	4821	289	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
7533263	7533263	PRJNA640143_S_NODE_21646_length_189_cov_2.526316_g21436_i0	PRJNA640143	21646	189	2.526316	4.77473724	Bacteria	2	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g21436	i0	98.413	11.994708994709	189	3	100	0	1	189	787551	787739	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	2267	333	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
8263294	8263294	PRJNA640143_S_NODE_28327_length_164_cov_1.503937_g28117_i0	PRJNA640143	28327	164	1.503937	2.46645668	Thermus brockianus	56956	Bacteria	Bacteria	97.1	6.24e-16	NTclustered	gi\|2199615665\|dbj\|AP025594.1\|	56956	g28117	i0	91.549	30.1829268292683	71	4	43	2	83	152	38863	38794	Thermus brockianus SNM4-1 plasmid pTbrSNM4-1b DNA, complete sequence	blastn	4950	97.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
9538325	9538325	PRJNA640143_S_NODE_17648_length_208_cov_4.426901_g17438_i0	PRJNA640143	17648	208	4.426901	9.20795408	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	231	2.18e-56	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g17438	i0	90.96	121.769230769231	177	8	85	3	30	206	1362026	1362194	Deinococcus sp. QL22 chromosome, complete genome	blastn	25328	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
9538512	9538512	PRJNA640143_S_NODE_25608_length_174_cov_3.496350_g25398_i0	PRJNA640143	25608	174	3.49635	6.083649	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	257	2.89e-64	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g25398	i0	97.351	0.867816091954023	151	4	87	0	24	174	1125748	1125898	Thermus sp. NEB1569 chromosome, complete genome	blastn	151	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
9538565	9538565	PRJNA640143_S_NODE_28188_length_164_cov_2.259843_g27978_i0	PRJNA640143	28188	164	2.259843	3.70614252	Deinococcus puniceus	1182568	Bacteria	Bacteria	261	2.09e-65	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g27978	i0	95.181	2.95121951219512	166	6	100	2	1	164	2477975	2478140	Deinococcus puniceus strain DY1, complete genome	blastn	484	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
10083899	10083899	PRJNA640143_S_NODE_1828_length_556_cov_207.296724_g1685_i0	PRJNA640143	1828	556	207.296724	1152.56978544	Truepera	332248	Bacteria	Bacteria	682	0	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g1685	i0	90.504	473.879496402878	516	49	93	0	3	518	761734	762249	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	263477	682	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12634383	12634383	PRJNA640143_S_NODE_1010_length_699_cov_11.466767_g282_i1	PRJNA640143	1010	699	11.466767	80.15270133	Truepera	332248	Bacteria	Bacteria	717	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g282	i1	88.177	312.246065808298	609	62	86	7	1	603	1910	1306	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	218260	721	0.994452149791956	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12634507	12634507	PRJNA640143_S_NODE_31470_length_154_cov_1.000000_g31260_i0	PRJNA640143	31470	154	1	1.54	Truepera	332248	Bacteria	Bacteria	150	4.359999999999999e-32	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g31260	i0	84.416	17.3051948051948	154	22	99	2	1	153	532807	532655	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	2665	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
13364019	13364019	PRJNA640143_S_NODE_20531_length_194_cov_1.732484_g20321_i0	PRJNA640143	20531	194	1.732484	3.36101896	Thermus caldilimi	2483360	Bacteria	Bacteria	270	4.2499999999999985e-68	NTclustered	gi\|1608424790\|gb\|CP038452.1\|	2483360	g20321	i0	92.147	5.90721649484536	191	15	98	0	1	191	1431638	1431828	Thermus caldilimi strain YIM 78456 chromosome, complete genome	blastn	1146	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus caldilimi
16458188	16458188	PRJNA640143_S_NODE_24593_length_178_cov_1.567376_g24383_i0	PRJNA640143	24593	178	1.567376	2.78992928	Truepera	332248	Bacteria	Bacteria	279	6.35e-71	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g24383	i0	94.944	170.544943820225	178	9	100	0	1	178	946474	946651	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	30357	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19007025	19007025	PRJNA640143_S_NODE_6535_length_327_cov_3.103448_g6325_i0	PRJNA640143	6535	327	3.103448	10.14827496	Thermus	270	Bacteria	Bacteria	538	1.9399999999999998e-148	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g6325	i0	99.003	76.3608562691132	301	2	93	1	28	327	1871548	1871248	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	24970	538	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
19736416	19736416	PRJNA640143_S_NODE_1336_length_626_cov_27.275042_g1219_i0	PRJNA640143	1336	626	27.275042	170.74176292	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	902	0	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g1219	i0	94.098	167.402555910543	593	35	95	0	34	626	1360793	1361385	Deinococcus sp. QL22 chromosome, complete genome	blastn	104794	902	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
20281863	20281863	PRJNA640143_S_NODE_2296_length_510_cov_50.562368_g2133_i0	PRJNA640143	2296	510	50.562368	257.8680768	Truepera	332248	Bacteria	Bacteria	573	8.609999999999999e-159	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2133	i0	88.699	305.488235294118	469	53	92	0	3	471	512	44	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	155799	573	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
23562758	23562758	PRJNA640143_S_NODE_3999_length_406_cov_21.945799_g3800_i0	PRJNA640143	3999	406	21.945799	89.09994394	Thermus antranikianii	88190	Bacteria	Bacteria	616	1.0999999999999996e-171	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g3800	i0	97.011	1.72413793103448	368	7	90	2	32	395	2238719	2239086	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	700	616	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
23562848	23562848	PRJNA640143_S_NODE_7279_length_312_cov_3.781818_g7069_i0	PRJNA640143	7279	312	3.781818	11.79927216	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	451	2.46e-122	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g7069	i0	96.691	39.6762820512821	272	7	87	1	16	285	87879	87608	Thermus sp. NEB1569 chromosome, complete genome	blastn	12379	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569

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