metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA942359" 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
922945	922945	PRJNA942359_P_NODE_17821_length_246_cov_0.901734_g17706_i0	PRJNA942359	17821	246	0.901734	2.21826564	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g17706	i0	99.593	48.1260162601626	246	1	100	0	1	246	1532726	1532481	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	11839	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
922984	922984	PRJNA942359_P_NODE_19641_length_243_cov_0.917647_g19526_i0	PRJNA942359	19641	243	0.917647	2.22988221	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	411	3.14e-110	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g19526	i0	97.119	5.8477366255144	243	7	100	0	1	243	1275163	1274921	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1421	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
923163	923163	PRJNA942359_P_NODE_9521_length_286_cov_0.816901_g9406_i0	PRJNA942359	9521	286	0.816901	2.33633686	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	479	1.02e-130	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g9406	i0	96.864	195.832167832168	287	8	100	1	1	286	55374	55660	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	56008	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
2198268	2198268	PRJNA942359_P_NODE_16102_length_248_cov_0.891429_g15987_i0	PRJNA942359	16102	248	0.891429	2.21074392	Deinococcus aquaticus	328692	Bacteria	Bacteria	292	1.21e-74	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g15987	i0	88.211	0.991935483870968	246	27	99	2	3	247	2056342	2056586	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	246	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4751478	4751478	PRJNA942359_P_NODE_5204_length_363_cov_1.075862_g5089_i0	PRJNA942359	5204	363	1.075862	3.90537906	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	128	5.56e-25	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g5089	i0	83.688	0.476584022038567	141	18	38	5	227	363	374530	374391	Deinococcus sp. NW-56 chromosome, complete genome	blastn	173	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6362820	6362820	PRJNA942359_P_NODE_16045_length_248_cov_0.891429_g15930_i0	PRJNA942359	16045	248	0.891429	2.21074392	Deinococcus	1298	Bacteria	Bacteria	228	3.469999999999999e-55	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g15930	i0	86.256	15.2540322580645	211	27	85	2	39	248	2167580	2167789	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	3783	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
6362822	6362822	PRJNA942359_P_NODE_16405_length_248_cov_0.891429_g16290_i0	PRJNA942359	16405	248	0.891429	2.21074392	Deinococcus	1298	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g16290	i0	100	205.661290322581	248	0	100	0	1	248	441	194	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	51004	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
7300984	7300984	PRJNA942359_P_NODE_13906_length_252_cov_0.871508_g13791_i0	PRJNA942359	13906	252	0.871508	2.19620016	Deinococcus aetherius	200252	Bacteria	Bacteria	137	6.13e-28	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g13791	i0	89.091	1.87301587301587	110	12	44	0	5	114	2258675	2258784	Deinococcus aetherius ST0316 DNA, complete genome	blastn	472	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
7636996	7636996	PRJNA942359_P_NODE_9526_length_285_cov_2.929245_g9411_i0	PRJNA942359	9526	285	2.929245	8.34834825	Deinococcus	1298	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|2567376453\|gb\|OR475725.1\|	47478	g9411	i0	100	105.957894736842	285	0	100	0	1	285	1300	1016	Deinococcus sp. strain HR17 16S ribosomal RNA gene, partial sequence	blastn	30198	527	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
8575802	8575802	PRJNA942359_P_NODE_13647_length_252_cov_0.871508_g13532_i0	PRJNA942359	13647	252	0.871508	2.19620016	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g13532	i0	99.206	4.68253968253968	252	2	100	0	1	252	2394260	2394511	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1180	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8575803	8575803	PRJNA942359_P_NODE_13687_length_252_cov_0.871508_g13572_i0	PRJNA942359	13687	252	0.871508	2.19620016	Deinococcus ficus	317577	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g13572	i0	100	3.79761904761905	252	0	100	0	1	252	2011561	2011812	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	957	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8575837	8575837	PRJNA942359_P_NODE_15427_length_249_cov_0.886364_g15312_i0	PRJNA942359	15427	249	0.886364	2.20704636	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g15312	i0	91.165	5.81124497991968	249	22	100	0	1	249	260759	260511	Deinococcus sp. NW-56 chromosome, complete genome	blastn	1447	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
9851010	9851010	PRJNA942359_P_NODE_19668_length_243_cov_0.917647_g19553_i0	PRJNA942359	19668	243	0.917647	2.22988221	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	159	1.2499999999999999e-34	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g19553	i0	82.955	0.724279835390947	176	30	72	0	9	184	2213661	2213836	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	176	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11126543	11126543	PRJNA942359_P_NODE_15849_length_249_cov_0.886364_g15734_i0	PRJNA942359	15849	249	0.886364	2.20704636	Deinococcus gobiensis	502394	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g15734	i0	95.582	88.1084337349398	249	11	100	0	1	249	2631849	2632097	Deinococcus gobiensis I-0, complete genome	blastn	21939	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11126599	11126599	PRJNA942359_P_NODE_18389_length_245_cov_0.906977_g18274_i0	PRJNA942359	18389	245	0.906977	2.22209365	Deinococcus ficus	317577	Bacteria	Bacteria	237	5.69e-58	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g18274	i0	86.792	7.44897959183673	212	28	87	0	29	240	606613	606824	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	1825	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
11126639	11126639	PRJNA942359_P_NODE_20209_length_242_cov_0.923077_g20094_i0	PRJNA942359	20209	242	0.923077	2.23384634	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	281	2.55e-71	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g20094	i0	87.603	6.60743801652893	242	30	100	0	1	242	1392604	1392363	Deinococcus sp. NW-56 chromosome, complete genome	blastn	1599	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12738177	12738177	PRJNA942359_P_NODE_14450_length_251_cov_0.876404_g14335_i0	PRJNA942359	14450	251	0.876404	2.19977404	Deinococcus	1298	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g14335	i0	98.008	2	251	5	100	0	1	251	1355118	1354868	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	502	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
13676581	13676581	PRJNA942359_P_NODE_13951_length_252_cov_0.871508_g13836_i0	PRJNA942359	13951	252	0.871508	2.19620016	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	436	5.4e-118	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g13836	i0	98.008	22.5515873015873	251	5	99	0	1	251	42642	42892	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	5683	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
13676640	13676640	PRJNA942359_P_NODE_16431_length_248_cov_0.891429_g16316_i0	PRJNA942359	16431	248	0.891429	2.21074392	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g16316	i0	85.59	80.8104838709677	229	31	92	2	1	228	312307	312080	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	20041	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
14950838	14950838	PRJNA942359_P_NODE_12992_length_253_cov_0.866667_g12877_i0	PRJNA942359	12992	253	0.866667	2.19266751	Deinococcus aquaticus	328692	Bacteria	Bacteria	387	5.539999999999998e-103	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g12877	i0	94.422	9.96047430830039	251	14	99	0	1	251	2004967	2005217	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	2520	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
16561335	16561335	PRJNA942359_P_NODE_17413_length_246_cov_0.901734_g17298_i0	PRJNA942359	17413	246	0.901734	2.21826564	Thermus	270	Bacteria	Bacteria	285	2.01e-72	NTclustered	gi\|939575858\|gb\|CP010824.1\|	498848	g17298	i0	88.559	3.58536585365854	236	25	96	2	12	246	2879	2645	Thermus aquaticus Y51MC23 plasmid pTA16, complete sequence	blastn	882	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
17501109	17501109	PRJNA942359_P_NODE_15194_length_250_cov_0.881356_g15079_i0	PRJNA942359	15194	250	0.881356	2.20339	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	374	4.2499999999999986e-99	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g15079	i0	93.651	3.144	252	13	99	1	1	249	3037497	3037748	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	786	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
18774654	18774654	PRJNA942359_P_NODE_14235_length_251_cov_0.876404_g14120_i0	PRJNA942359	14235	251	0.876404	2.19977404	Deinococcus yunweiensis	367282	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g14120	i0	98.406	1	251	4	100	0	1	251	1481496	1481246	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	251	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
18774888	18774888	PRJNA942359_P_NODE_7135_length_320_cov_0.967611_g7020_i0	PRJNA942359	7135	320	0.967611	3.0963552	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	448	3.2799999999999996e-121	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g7020	i0	98.425	195.6125	254	4	100	0	67	320	15816	16069	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	62596	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21325069	21325069	PRJNA942359_P_NODE_17877_length_245_cov_2.290698_g17762_i0	PRJNA942359	17877	245	2.290698	5.6122101	Deinococcus aetherius	200252	Bacteria	Bacteria	375	1.16e-99	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g17762	i0	94.309	197.975510204082	246	12	100	2	1	245	82161	81917	Deinococcus aetherius ST0316 DNA, complete genome	blastn	48504	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
22936580	22936580	PRJNA942359_P_NODE_17358_length_246_cov_0.901734_g17243_i0	PRJNA942359	17358	246	0.901734	2.21826564	Deinococcus	1298	Bacteria	Bacteria	224	4.45e-54	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g17243	i0	90.964	16.6910569105691	166	15	67	0	81	246	2025102	2024937	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	4106	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
23875382	23875382	PRJNA942359_P_NODE_13719_length_252_cov_0.871508_g13604_i0	PRJNA942359	13719	252	0.871508	2.19620016	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	276	1.2499999999999998e-69	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g13604	i0	86.694	7.13888888888889	248	33	98	0	1	248	1342681	1342928	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1799	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23875467	23875467	PRJNA942359_P_NODE_17659_length_246_cov_0.901734_g17544_i0	PRJNA942359	17659	246	0.901734	2.21826564	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g17544	i0	89.113	30.8577235772358	248	23	100	4	1	246	81069	81314	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	7591	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
25149061	25149061	PRJNA942359_P_NODE_11800_length_263_cov_1.278947_g11685_i0	PRJNA942359	11800	263	1.278947	3.36363061	Deinococcus yunweiensis	367282	Bacteria	Bacteria	254	6.13e-63	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g11685	i0	84.03	20.8136882129278	263	42	100	0	1	263	1116531	1116269	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	5474	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
25149215	25149215	PRJNA942359_P_NODE_18960_length_244_cov_0.912281_g18845_i0	PRJNA942359	18960	244	0.912281	2.22596564	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	255	1.5600000000000001e-63	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g18845	i0	87.444	8.69262295081967	223	26	91	2	23	244	2620017	2619796	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	2121	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
25149236	25149236	PRJNA942359_P_NODE_19640_length_243_cov_0.917647_g19525_i0	PRJNA942359	19640	243	0.917647	2.22988221	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	381	2.4599999999999995e-101	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g19525	i0	98.165	33.6502057613169	218	4	90	0	26	243	449367	449584	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	8177	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
25485393	25485393	PRJNA942359_P_NODE_18460_length_245_cov_0.906977_g18345_i0	PRJNA942359	18460	245	0.906977	2.22209365	Deinococcus	1298	Bacteria	Bacteria	217	7.41e-52	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g18345	i0	83.264	2.09795918367347	239	36	97	4	8	244	269002	269238	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	514	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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