metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA293022" 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
373360	373360	PRJNA293022_P_NODE_62921_length_175_cov_1.277778_g62184_i0	PRJNA293022	62921	175	1.277778	2.2361115	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	268	1.34e-67	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g62184	i0	94.286	268.994285714286	175	10	100	0	1	175	69579	69405	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	47074	268	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
1059786	1059786	PRJNA293022_P_NODE_68001_length_169_cov_0.866667_g67264_i0	PRJNA293022	68001	169	0.866667	1.46466723	Deinococcus	1298	Bacteria	Bacteria	196	6.16e-46	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g67264	i0	87.952	4.44970414201183	166	20	98	0	1	166	241216	241381	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	752	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1647959	1647959	PRJNA293022_P_NODE_23382_length_293_cov_1.594262_g22645_i0	PRJNA293022	23382	293	1.594262	4.67118766	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	309	1.4600000000000003e-79	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g22645	i0	86.111	5.53242320819113	288	38	98	2	2	288	69934	69648	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	1621	309	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
4887600	4887600	PRJNA293022_P_NODE_2084_length_919_cov_57.942529_g1655_i0	PRJNA293022	2084	919	57.942529	532.49184151	Deinococcus	1298	Bacteria	Bacteria	1365	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g1655	i0	93.471	206.896626768226	919	60	100	0	1	919	2148445	2147527	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	190138	1375	0.992727272727273	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5476899	5476899	PRJNA293022_P_NODE_70805_length_167_cov_0.881356_g70068_i0	PRJNA293022	70805	167	0.881356	1.47186452	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	296	5.86e-76	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g70068	i0	100	4.59281437125748	160	0	96	0	1	160	683572	683413	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	767	296	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6162493	6162493	PRJNA293022_P_NODE_43045_length_212_cov_11.251534_g42308_i0	PRJNA293022	43045	212	11.251534	23.85325208	Deinococcus	1298	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g42308	i0	100	212.481132075472	212	0	100	0	1	212	1454758	1454969	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	45046	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
6751031	6751031	PRJNA293022_P_NODE_59126_length_181_cov_0.992424_g58389_i0	PRJNA293022	59126	181	0.992424	1.79628744	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	147	6.859999999999999e-31	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g58389	i0	100	1.19337016574586	79	0	44	0	1	79	1819815	1819737	Deinococcus sp. NW-56 chromosome, complete genome	blastn	216	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6751117	6751117	PRJNA293022_P_NODE_74126_length_165_cov_0.896552_g73389_i0	PRJNA293022	74126	165	0.896552	1.4793108	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	296	5.77e-76	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g73389	i0	99.387	17.7393939393939	163	1	99	0	1	163	2249163	2249001	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	2927	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6751144	6751144	PRJNA293022_P_NODE_77406_length_163_cov_0.912281_g76669_i0	PRJNA293022	77406	163	0.912281	1.48701803	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	300	4.39e-77	NTclustered	gi\|1339790005\|gb\|CP026518.1\|	2080419	g76669	i0	100	4.87116564417178	162	0	99	0	2	163	112912	113073	Deinococcus sp. NW-56 plasmid unnamed2, complete sequence	blastn	794	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
8026507	8026507	PRJNA293022_P_NODE_19487_length_323_cov_1.635036_g18750_i0	PRJNA293022	19487	323	1.635036	5.28116628	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	549	8.819999999999997e-152	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g18750	i0	97.508	322.272445820433	321	8	99	0	1	321	68297	68617	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	104094	549	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
8026683	8026683	PRJNA293022_P_NODE_61287_length_177_cov_2.421875_g60550_i0	PRJNA293022	61287	177	2.421875	4.28671875	Deinococcus radiophilus	32062	Bacteria	Bacteria	244	2.3e-60	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g60550	i0	91.667	124.971751412429	180	10	99	3	1	175	1813741	1813920	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	22120	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
8026740	8026740	PRJNA293022_P_NODE_71127_length_167_cov_0.881356_g70390_i0	PRJNA293022	71127	167	0.881356	1.47186452	Deinococcus proteolyticus	55148	Bacteria	Bacteria	145	2.25e-30	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g70390	i0	83.03	0.988023952095808	165	23	96	5	7	167	404376	404213	Deinococcus proteolyticus MRP, complete genome	blastn	165	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
8712343	8712343	PRJNA293022_P_NODE_2227_length_891_cov_57.953682_g1785_i0	PRJNA293022	2227	891	57.953682	516.36730662	Deinococcus	1298	Bacteria	Bacteria	1397	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g1785	i0	95.439	214.735129068462	877	38	98	2	16	891	1454108	1454983	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	191329	1397	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
8712403	8712403	PRJNA293022_P_NODE_51487_length_194_cov_1.772414_g50750_i0	PRJNA293022	51487	194	1.772414	3.43848316	Deinococcus	1298	Bacteria	Bacteria	276	9.13e-70	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g50750	i0	92.708	183.567010309278	192	12	99	2	1	192	1455254	1455443	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	35612	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
9301503	9301503	PRJNA293022_P_NODE_70548_length_167_cov_0.881356_g69811_i0	PRJNA293022	70548	167	0.881356	1.47186452	Deinococcus geothermalis	68909	Bacteria	Bacteria	294	2.11e-75	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g69811	i0	98.788	1.96407185628743	165	2	99	0	2	166	98341	98505	Deinococcus geothermalis DSM 11300, complete genome	blastn	328	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
9987932	9987932	PRJNA293022_P_NODE_77508_length_163_cov_0.912281_g76771_i0	PRJNA293022	77508	163	0.912281	1.48701803	Deinococcus	1298	Bacteria	Bacteria	287	3.42e-73	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g76771	i0	98.758	18.2638036809816	161	2	99	0	3	163	775379	775539	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	2977	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
10577341	10577341	PRJNA293022_P_NODE_68689_length_168_cov_1.394958_g67952_i0	PRJNA293022	68689	168	1.394958	2.34352944	Thermotoga profunda	1508420	Bacteria	Bacteria	69.4	1.4e-7	NTclustered	gi\|597439398\|dbj\|AP014510.1\|	1408160	g67952	i0	80.899	0.529761904761905	89	15	52	2	3	90	2163725	2163812	Thermotoga profunda AZM34c06 DNA, complete genome	blastn	89	69.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga profunda
10577353	10577353	PRJNA293022_P_NODE_69549_length_168_cov_0.873950_g68812_i0	PRJNA293022	69549	168	0.87395	1.468236	Deinococcus geothermalis	68909	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g68812	i0	100	17.2380952380952	166	0	99	0	1	166	107066	106901	Deinococcus geothermalis DSM 11300, complete genome	blastn	2896	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
12538281	12538281	PRJNA293022_P_NODE_730_length_1368_cov_46.529947_g503_i0	PRJNA293022	730	1368	46.529947	636.52967496	Deinococcus	1298	Bacteria	Bacteria	1832	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g503	i0	91.196	204.260233918129	1363	99	99	20	16	1366	2341647	2343000	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	279428	1832	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
13813076	13813076	PRJNA293022_P_NODE_35751_length_233_cov_23.521739_g35014_i0	PRJNA293022	35751	233	23.521739	54.80565187	Deinococcus	1298	Bacteria	Bacteria	429	8.239999999999998e-116	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g35014	i0	100	264.695278969957	232	0	99	0	1	232	1886213	1885982	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	61674	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
15675953	15675953	PRJNA293022_P_NODE_2473_length_848_cov_59.908636_g2007_i0	PRJNA293022	2473	848	59.908636	508.02523328	Deinococcus ficus	317577	Bacteria	Bacteria	1334	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g2007	i0	95.059	207.082547169811	850	38	100	2	1	848	2341434	2342281	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	175606	1334	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
15676023	15676023	PRJNA293022_P_NODE_38573_length_225_cov_1.170455_g37836_i0	PRJNA293022	38573	225	1.170455	2.63352375	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	412	7.97e-111	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g37836	i0	100	22.1111111111111	223	0	99	0	1	223	1114531	1114753	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	4975	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16362271	16362271	PRJNA293022_P_NODE_72213_length_166_cov_0.888889_g71476_i0	PRJNA293022	72213	166	0.888889	1.47555574	Deinococcus	1298	Bacteria	Bacteria	303	3.48e-78	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g71476	i0	100	1.97590361445783	164	0	99	0	1	164	369484	369647	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	328	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
16950845	16950845	PRJNA293022_P_NODE_77314_length_163_cov_0.912281_g76577_i0	PRJNA293022	77314	163	0.912281	1.48701803	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	243	7.51e-60	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g76577	i0	93.789	1.97546012269939	161	10	99	0	3	163	1290692	1290532	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	322	243	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18225039	18225039	PRJNA293022_P_NODE_56715_length_185_cov_1.161765_g55978_i0	PRJNA293022	56715	185	1.161765	2.14926525	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	313	6.56e-81	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g55978	i0	97.79	19.572972972973	181	4	98	0	3	183	2015782	2015962	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	3621	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19499210	19499210	PRJNA293022_P_NODE_44396_length_209_cov_2.837500_g43659_i0	PRJNA293022	44396	209	2.8375	5.930375	Thermosipho africanus	2421	Bacteria	Bacteria	137	4.92e-28	NTclustered	gi\|217035986\|gb\|CP001185.1\|	484019	g43659	i0	80.214	19.3588516746411	187	33	89	4	3	188	1123758	1123941	Thermosipho africanus TCF52B, complete genome	blastn	4046	137	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho africanus
20185748	20185748	PRJNA293022_P_NODE_3096_length_770_cov_17.581137_g503_i1	PRJNA293022	3096	770	17.581137	135.3747549	Deinococcus	1298	Bacteria	Bacteria	970	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g503	i1	89.597	290.841558441558	769	73	99	6	3	768	543899	543135	Deinococcus sp. NW-56 chromosome, complete genome	blastn	223948	970	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
20774644	20774644	PRJNA293022_P_NODE_1577_length_1025_cov_10.157787_g1201_i0	PRJNA293022	1577	1025	10.157787	104.11731675	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	1430	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g1201	i0	91.934	569.695609756098	1029	72	100	10	4	1025	69644	68620	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	583938	1430	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
20774647	20774647	PRJNA293022_P_NODE_17957_length_337_cov_2.111111_g17220_i0	PRJNA293022	17957	337	2.111111	7.11444407	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	398	3.5499999999999993e-106	NTclustered	gi\|429132235\|gb\|CP003383.1\|	937777	g17220	i0	88.047	1008.49851632047	343	31	99	8	2	337	446469	446130	Deinococcus peraridilitoris DSM 19664 plasmid pDEIPE01, complete sequence	blastn	339864	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
21461458	21461458	PRJNA293022_P_NODE_37017_length_229_cov_4.511111_g36280_i0	PRJNA293022	37017	229	4.511111	10.33044419	Aminobacterium	81466	Bacteria	Bacteria	302	1.84e-77	NTclustered	gi\|470486176\|ref\|NR_076740.1\|	81468	g36280	i0	90.435	176.633187772926	230	20	99	2	2	229	1933	1704	Aminobacterium colombiense strain ALA-1 23S ribosomal RNA gene, complete sequence	blastn	40449	302	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium colombiense
23325220	23325220	PRJNA293022_P_NODE_1459_length_1054_cov_2.980100_g1105_i0	PRJNA293022	1459	1054	2.9801	31.410254	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1351	0	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g1105	i0	90.01	550.019924098672	1051	95	99	6	10	1051	3600264	3601313	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	579721	1351	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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