metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392456	392456	PRJNA340009_P_NODE_63021_length_167_cov_0.864407_g62714_i0	PRJNA340009	63021	167	0.864407	1.44355969	Thermus thermophilus	274	Bacteria	Bacteria	237	3.599999999999999e-58	NTclustered	gi\|2199618452\|dbj\|AP025604.1\|	274	g62714	i0	92.216	1.98203592814371	167	13	100	0	1	167	161543	161709	Thermus thermophilus SNM1-7 plasmid pTthSNM1-7b DNA, complete sequence	blastn	331	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
392479	392479	PRJNA340009_P_NODE_64821_length_166_cov_0.871795_g64514_i0	PRJNA340009	64821	166	0.871795	1.4471797	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g64514	i0	96.988	7.42168674698795	166	5	100	0	1	166	1566616	1566451	Thermus sp. NEB1569 chromosome, complete genome	blastn	1232	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
392501	392501	PRJNA340009_P_NODE_66321_length_165_cov_1.241379_g66014_i0	PRJNA340009	66321	165	1.241379	2.04827535	Deinococcus ficus	317577	Bacteria	Bacteria	276	7.52e-70	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g66014	i0	98.71	270	155	2	94	0	11	165	2342644	2342490	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	44550	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
2345360	2345360	PRJNA340009_P_NODE_33122_length_218_cov_1.337278_g32815_i0	PRJNA340009	33122	218	1.337278	2.91526604	Deinococcus	1298	Bacteria	Bacteria	387	4.649999999999998e-103	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g32815	i0	98.624	325.853211009174	218	3	100	0	1	218	1792221	1792438	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	71036	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
2943212	2943212	PRJNA340009_P_NODE_74883_length_162_cov_0.902655_g74576_i0	PRJNA340009	74883	162	0.902655	1.4623011	Thermus aquaticus	271	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g74576	i0	100	5.47530864197531	162	0	100	0	1	162	1843871	1844032	Thermus aquaticus Y51MC23, complete genome	blastn	887	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
4897931	4897931	PRJNA340009_P_NODE_57244_length_173_cov_1.354839_g56937_i0	PRJNA340009	57244	173	1.354839	2.34387147	Deinococcus	1298	Bacteria	Bacteria	292	7.87e-75	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g56937	i0	97.11	210.21387283237	173	5	100	0	1	173	2341079	2340907	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	36367	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
4898045	4898045	PRJNA340009_P_NODE_8604_length_385_cov_2.348214_g8297_i0	PRJNA340009	8604	385	2.348214	9.0406239	Bacteria	2	Bacteria	Bacteria	693	0	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g8297	i0	100	47.7480519480519	375	0	97	0	1	375	820	446	Thermus aquaticus DNA polymerase (PolI) gene	blastn	18383	693	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
6172970	6172970	PRJNA340009_P_NODE_52445_length_180_cov_0.740458_g52138_i0	PRJNA340009	52445	180	0.740458	1.3328244	Deinococcus	1298	Bacteria	Bacteria	259	8.38e-65	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g52138	i0	94.118	185.022222222222	170	10	94	0	1	170	1793575	1793406	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	33304	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6770100	6770100	PRJNA340009_P_NODE_67166_length_165_cov_0.879310_g66859_i0	PRJNA340009	67166	165	0.87931	1.4508615	Allomeiothermus silvanus	52022	Bacteria	Bacteria	185	1.3e-42	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g66859	i0	97.248	2.63636363636364	109	3	66	0	57	165	666950	667058	Meiothermus silvanus DSM 9946, complete genome	blastn	435	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
9320399	9320399	PRJNA340009_P_NODE_57748_length_172_cov_1.658537_g57441_i0	PRJNA340009	57748	172	1.658537	2.85268364	Thermus aquaticus	271	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g57441	i0	100	3.00581395348837	172	0	100	0	1	172	50042	49871	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	517	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
9998267	9998267	PRJNA340009_P_NODE_60348_length_169_cov_0.983333_g60041_i0	PRJNA340009	60348	169	0.983333	1.66183277	Thermus	270	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g60041	i0	99.408	3.98816568047337	169	1	100	0	1	169	970680	970512	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	674	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
10596265	10596265	PRJNA340009_P_NODE_74989_length_162_cov_0.902655_g74682_i0	PRJNA340009	74989	162	0.902655	1.4623011	Allomeiothermus silvanus	52022	Bacteria	Bacteria	285	1.2199999999999998e-72	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g74682	i0	100	0.950617283950617	154	0	95	0	1	154	2036911	2037064	Meiothermus silvanus DSM 9946, complete genome	blastn	154	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
11870897	11870897	PRJNA340009_P_NODE_4750_length_489_cov_2.240909_g4445_i0	PRJNA340009	4750	489	2.240909	10.95804501	Deinococcus ficus	317577	Bacteria	Bacteria	747	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g4445	i0	94.813	289.259713701432	482	20	98	5	11	489	2341804	2342283	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	141448	747	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
12548433	12548433	PRJNA340009_P_NODE_17470_length_286_cov_2.299578_g17163_i0	PRJNA340009	17470	286	2.299578	6.57679308	Thermus	270	Bacteria	Bacteria	523	4.659999999999998e-144	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g17163	i0	99.65	8.2972027972028	286	1	100	0	1	286	1207384	1207099	Thermus oshimai strain Blanco chromosome, complete genome	blastn	2373	523	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
12548494	12548494	PRJNA340009_P_NODE_29170_length_230_cov_1.071823_g28863_i0	PRJNA340009	29170	230	1.071823	2.4651929	Deinococcus	1298	Bacteria	Bacteria	339	1.41e-88	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g28863	i0	94.907	180.013043478261	216	11	94	0	5	220	2341542	2341757	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	41403	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
13145704	13145704	PRJNA340009_P_NODE_32711_length_219_cov_1.917647_g32404_i0	PRJNA340009	32711	219	1.917647	4.19964693	Deinococcus aetherius	200252	Bacteria	Bacteria	359	1.0199999999999999e-94	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g32404	i0	97.608	198.283105022831	209	5	95	0	11	219	83987	83779	Deinococcus aetherius ST0316 DNA, complete genome	blastn	43424	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
13146126	13146126	PRJNA340009_P_NODE_69651_length_164_cov_0.886957_g69344_i0	PRJNA340009	69651	164	0.886957	1.45460948	Thermus parvatiensis	456163	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g69344	i0	98.78	34.9207317073171	164	2	100	0	1	164	433887	433724	Thermus parvatiensis strain RL, complete genome	blastn	5727	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
13823502	13823502	PRJNA340009_P_NODE_44951_length_191_cov_3.415493_g44644_i0	PRJNA340009	44951	191	3.415493	6.52359163	Deinococcus	1298	Bacteria	Bacteria	303	4.11e-78	NTclustered	gi\|2155018472\|emb\|OV024758.1\|	1299	g44644	i0	95.288	164.910994764398	191	9	100	0	1	191	144802	144992	Deinococcus radiodurans isolate DRR11 genome assembly, plasmid: 2	blastn	31498	305	0.99344262295082	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
14420964	14420964	PRJNA340009_P_NODE_41292_length_198_cov_6.476510_g40985_i0	PRJNA340009	41292	198	6.47651	12.8234898	Thermus scotoductus	37636	Bacteria	Bacteria	361	2.51e-95	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g40985	i0	99.495	7.95959595959596	198	1	100	0	1	198	671500	671697	Thermus scotoductus SA-01, complete genome	blastn	1576	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
15695190	15695190	PRJNA340009_P_NODE_74913_length_162_cov_0.902655_g74606_i0	PRJNA340009	74913	162	0.902655	1.4623011	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	239	9.64e-59	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g74606	i0	93.21	12.1049382716049	162	11	100	0	1	162	2669858	2670019	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1961	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16969888	16969888	PRJNA340009_P_NODE_70054_length_164_cov_0.886957_g69747_i0	PRJNA340009	70054	164	0.886957	1.45460948	Thermosipho africanus	2421	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|217035986\|gb\|CP001185.1\|	484019	g69747	i0	97.059	0.207317073170732	34	0	21	1	129	162	679829	679797	Thermosipho africanus TCF52B, complete genome	blastn	34	56.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho africanus
17647760	17647760	PRJNA340009_P_NODE_68514_length_164_cov_1.660870_g68207_i0	PRJNA340009	68514	164	1.66087	2.7238268	Thermus	270	Bacteria	Bacteria	285	1.24e-72	NTclustered	gi\|939575858\|gb\|CP010824.1\|	498848	g68207	i0	100	1.8780487804878	154	0	94	0	11	164	1534	1381	Thermus aquaticus Y51MC23 plasmid pTA16, complete sequence	blastn	308	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
18244071	18244071	PRJNA340009_P_NODE_69175_length_164_cov_0.886957_g68868_i0	PRJNA340009	69175	164	0.886957	1.45460948	Allomeiothermus silvanus	52022	Bacteria	Bacteria	279	5.77e-71	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g68868	i0	99.351	0.939024390243902	154	1	94	0	11	164	822161	822008	Meiothermus silvanus DSM 9946, complete genome	blastn	154	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
18921586	18921586	PRJNA340009_P_NODE_66675_length_165_cov_0.879310_g66368_i0	PRJNA340009	66675	165	0.87931	1.4508615	Thermus	270	Bacteria	Bacteria	274	2.7e-69	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g66368	i0	96.933	5.93939393939394	163	5	99	0	1	163	1963502	1963664	Thermus scotoductus SA-01, complete genome	blastn	980	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
19518383	19518383	PRJNA340009_P_NODE_74196_length_162_cov_0.902655_g73889_i0	PRJNA340009	74196	162	0.902655	1.4623011	Allomeiothermus silvanus	52022	Bacteria	Bacteria	222	9.709999999999999e-54	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g73889	i0	91.358	91.7407407407407	162	14	100	0	1	162	522559	522720	Meiothermus silvanus DSM 9946, complete genome	blastn	14862	222	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
19518411	19518411	PRJNA340009_P_NODE_76776_length_161_cov_0.910714_g76469_i0	PRJNA340009	76776	161	0.910714	1.46624954	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	248	1.59e-61	NTclustered	gi\|1868564649\|gb\|CP058536.1\|	2755035	g76469	i0	94.937	1.95652173913043	158	8	98	0	1	158	95125	94968	Deinococcus sp. D7000 plasmid p_2, complete sequence	blastn	315	248	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
20793256	20793256	PRJNA340009_P_NODE_13817_length_316_cov_5.640449_g13510_i0	PRJNA340009	13817	316	5.640449	17.82381884	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	584	2.359999999999999e-162	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g13510	i0	100	97.2626582278481	316	0	100	0	1	316	1969523	1969208	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	30735	584	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22746873	22746873	PRJNA340009_P_NODE_28978_length_230_cov_3.337017_g28671_i0	PRJNA340009	28978	230	3.337017	7.6751391	Deinococcus	1298	Bacteria	Bacteria	337	5.059999999999998e-88	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g28671	i0	93.043	7	230	16	100	0	1	230	1755665	1755436	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	1610	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus

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