metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA385073" 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
406270	406270	PRJNA385073_P_NODE_50501_length_246_cov_0.890173_g50339_i0	PRJNA385073	50501	246	0.890173	2.18982558	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	327	3.3e-85	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g50339	i0	90.763	96.5325203252033	249	17	100	6	1	246	68887	68642	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	23747	327	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
406526	406526	PRJNA385073_P_NODE_62361_length_228_cov_2.812903_g62199_i0	PRJNA385073	62361	228	2.812903	6.41341884	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	159	1.1599999999999999e-34	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g62199	i0	87.143	1.2280701754386	140	18	61	0	1	140	767902	767763	Thermus sp. NEB1569 chromosome, complete genome	blastn	280	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
406535	406535	PRJNA385073_P_NODE_62741_length_226_cov_4.078431_g62579_i0	PRJNA385073	62741	226	4.078431	9.21725406	Allomeiothermus silvanus	52022	Bacteria	Bacteria	412	8.01e-111	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g62579	i0	99.558	1	226	1	100	0	1	226	2973730	2973505	Meiothermus silvanus DSM 9946, complete genome	blastn	226	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
1681343	1681343	PRJNA385073_P_NODE_62162_length_229_cov_2.294872_g62000_i0	PRJNA385073	62162	229	2.294872	5.25525688	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	401	1.7599999999999995e-107	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g62000	i0	98.253	323.17903930131	229	4	100	0	1	229	1637572	1637800	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	74008	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
2351790	2351790	PRJNA385073_P_NODE_56842_length_242_cov_0.911243_g56680_i0	PRJNA385073	56842	242	0.911243	2.20520806	FCB group	1783270	Bacteria	Bacteria	122	1.6399999999999998e-23	NTclustered	gi\|313151615\|gb\|CP002361.1\|	670487	g56680	i0	96	31.904958677686	75	3	31	0	75	149	174882	174956	Oceanithermus profundus DSM 14977, complete genome	blastn	7721	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Oceanithermus	Oceanithermus profundus
7454489	7454489	PRJNA385073_P_NODE_65406_length_198_cov_5.480000_g65244_i0	PRJNA385073	65406	198	5.48	10.8504	Thermus	270	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g65244	i0	100	6.00505050505051	198	0	100	0	1	198	554869	555066	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	1189	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
8059060	8059060	PRJNA385073_P_NODE_28727_length_282_cov_2.674641_g28565_i0	PRJNA385073	28727	282	2.674641	7.54248762	Deinococcus aquaticus	328692	Bacteria	Bacteria	355	1.7699999999999997e-93	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g28565	i0	89.437	2.49290780141844	284	26	100	4	1	282	2601906	2601625	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	703	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
9334122	9334122	PRJNA385073_P_NODE_39168_length_255_cov_5.384615_g39006_i0	PRJNA385073	39168	255	5.384615	13.73076825	Synergistaceae bacterium	2053624	Bacteria	Bacteria	370	5.63e-98	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g39006	i0	92.913	57.5803921568627	254	18	99	0	2	255	47153	46900	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	14683	370	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
9334438	9334438	PRJNA385073_P_NODE_53968_length_244_cov_0.900585_g53806_i0	PRJNA385073	53968	244	0.900585	2.1974274	Deinococcus grandis	57498	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g53806	i0	92.623	4.98770491803279	244	18	100	0	1	244	2984626	2984383	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1217	351	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
9334651	9334651	PRJNA385073_P_NODE_63328_length_221_cov_4.432432_g63166_i0	PRJNA385073	63328	221	4.432432	9.79567472	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	381	2.2e-101	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g63166	i0	97.738	4.85972850678733	221	5	100	0	1	221	1275139	1274919	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1074	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
10609991	10609991	PRJNA385073_P_NODE_48989_length_247_cov_0.885057_g48827_i0	PRJNA385073	48989	247	0.885057	2.18609079	Synergistaceae bacterium	2053624	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g48827	i0	89.474	3.5748987854251	152	16	62	0	96	247	2140407	2140256	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	883	193	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
11279491	11279491	PRJNA385073_P_NODE_44449_length_249_cov_1.750000_g44287_i0	PRJNA385073	44449	249	1.75	4.3575	Deinococcus	1298	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g44287	i0	99.598	29.9598393574297	249	1	100	0	1	249	200312	200064	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	7460	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
13159673	13159673	PRJNA385073_P_NODE_34711_length_266_cov_2.046632_g34549_i0	PRJNA385073	34711	266	2.046632	5.44404112	Deinococcus aquaticus	328692	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g34549	i0	97.744	126.725563909774	266	6	100	0	1	266	915455	915190	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	33709	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
15709344	15709344	PRJNA385073_P_NODE_65633_length_196_cov_5.081301_g65471_i0	PRJNA385073	65633	196	5.081301	9.95934996	Thermus brockianus	56956	Bacteria	Bacteria	279	7.14e-71	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g65471	i0	92.386	48	197	13	100	2	1	196	1968288	1968483	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	9408	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
15709367	15709367	PRJNA385073_P_NODE_7693_length_450_cov_2.190981_g7533_i0	PRJNA385073	7693	450	2.190981	9.8594145	uncultured Dethiosulfovibrio sp.	185448	Bacteria	Bacteria	243	2.41e-59	NTclustered	gi\|2621705290\|emb\|OY763420.1\|	185448	g7533	i0	86.161	21.3222222222222	224	31	50	0	210	433	1393025	1393248	MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1	blastn	9595	243	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio	uncultured Dethiosulfovibrio sp.
16983026	16983026	PRJNA385073_P_NODE_21494_length_310_cov_5.122363_g21332_i0	PRJNA385073	21494	310	5.122363	15.8793253	Thermus aquaticus	271	Bacteria	Bacteria	267	9.5e-67	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g21332	i0	83.113	38.6258064516129	302	38	97	5	10	310	602670	602381	Thermus aquaticus Y51MC23, complete genome	blastn	11974	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
16983769	16983769	PRJNA385073_P_NODE_55154_length_243_cov_0.905882_g54992_i0	PRJNA385073	55154	243	0.905882	2.20129326	Deinococcus grandis	57498	Bacteria	Bacteria	431	2.4099999999999995e-116	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g54992	i0	98.76	62.9876543209877	242	3	99	0	1	242	32271	32512	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	15306	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18257127	18257127	PRJNA385073_P_NODE_19855_length_319_cov_4.483740_g19693_i0	PRJNA385073	19855	319	4.48374	14.3031306	Synergistaceae bacterium	2053624	Bacteria	Bacteria	514	3.17e-141	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g19693	i0	96.753	2.90909090909091	308	10	97	0	12	319	633619	633312	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	928	514	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
18257201	18257201	PRJNA385073_P_NODE_22655_length_306_cov_1.484979_g22493_i0	PRJNA385073	22655	306	1.484979	4.54403574	Synergistaceae bacterium	2053624	Bacteria	Bacteria	483	8.539999999999998e-132	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g22493	i0	95.098	1	306	15	100	0	1	306	633312	633617	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	306	483	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
18927975	18927975	PRJNA385073_P_NODE_63535_length_218_cov_5.400000_g63373_i0	PRJNA385073	63535	218	5.4	11.772	Thermus	270	Bacteria	Bacteria	403	4.62e-108	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g63373	i0	100	297.394495412844	218	0	100	0	1	218	1856968	1856751	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	64832	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
20807342	20807342	PRJNA385073_P_NODE_27077_length_287_cov_2.233645_g26915_i0	PRJNA385073	27077	287	2.233645	6.41056115	Deinococcus aetherius	200252	Bacteria	Bacteria	204	6.919999999999999e-48	NTclustered	gi\|2281898193\|dbj\|AP026561.1\|	200252	g26915	i0	89.441	29.0871080139373	161	17	56	0	3	163	706481	706641	Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome	blastn	8348	204	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21477938	21477938	PRJNA385073_P_NODE_40017_length_253_cov_3.577778_g39855_i0	PRJNA385073	40017	253	3.577778	9.05177834	Deinococcus	1298	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g39855	i0	98.419	2.12648221343874	253	4	100	0	1	253	2481506	2481758	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	538	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
22082111	22082111	PRJNA385073_P_NODE_23178_length_303_cov_2.008696_g23016_i0	PRJNA385073	23178	303	2.008696	6.08634888	Synergistaceae bacterium	2053624	Bacteria	Bacteria	459	1.4199999999999996e-124	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g23016	i0	94.314	2.97029702970297	299	17	99	0	2	300	633615	633317	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	900	459	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
23357951	23357951	PRJNA385073_P_NODE_33139_length_270_cov_2.157360_g32977_i0	PRJNA385073	33139	270	2.15736	5.824872	Thermus antranikianii	88190	Bacteria	Bacteria	488	1.5899999999999995e-133	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g32977	i0	99.259	2	270	2	100	0	1	270	1556434	1556165	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	540	488	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii

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