metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA168635" 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
364335	364335	PRJNA168635_P_NODE_17341_length_192_cov_2.160839_g16925_i0	PRJNA168635	17341	192	2.160839	4.14881088	uncultured Thermotogae bacterium	453412	Bacteria	Bacteria	71.3	4.56e-8	NTclustered	gi\|2621705100\|emb\|OY763325.1\|	453412	g16925	i0	84.932	19.8020833333333	73	7	37	4	31	101	345260	345330	MAG: uncultured Thermotogae bacterium isolate fcbefaaa-1511-4f39-b5ed-7dc52d8fa8ec genome assembly, chromosome: 1	blastn	3802	71.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae				uncultured Thermotogae bacterium
1054230	1054230	PRJNA168635_P_NODE_161_length_1395_cov_9.627043_g101_i1	PRJNA168635	161	1395	9.627043	134.29724985	Meiothermus	65551	Bacteria	Bacteria	815	0	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g101	i1	77.885	372.240860215054	1456	224	99	66	1	1393	470	1890	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	519276	815	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
4191508	4191508	PRJNA168635_P_NODE_17624_length_191_cov_1.436620_g17208_i0	PRJNA168635	17624	191	1.43662	2.7439442	Meiothermus ruber	277	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g17208	i0	99.476	2.96858638743455	191	1	100	0	1	191	114919	115109	Meiothermus ruber DSM 1279, complete genome	blastn	567	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
6157072	6157072	PRJNA168635_P_NODE_35085_length_152_cov_6.883495_g34669_i0	PRJNA168635	35085	152	6.883495	10.4629124	Deinococcus	1298	Bacteria	Bacteria	196	5.429999999999999e-46	NTclustered	gi\|1336609736\|gb\|MG860167.1\|	47478	g34669	i0	99.091	77.0065789473684	110	0	72	1	44	152	582	691	Deinococcus sp. strain LA6P7 16S ribosomal RNA gene, partial sequence	blastn	11705	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
7432170	7432170	PRJNA168635_P_NODE_22826_length_174_cov_2.240000_g22410_i0	PRJNA168635	22826	174	2.24	3.8976	Allomeiothermus	2935559	Bacteria	Bacteria	222	1.05e-53	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g22410	i0	90.116	791.448275862069	172	16	98	1	4	174	982	1153	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	137712	222	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
7432262	7432262	PRJNA168635_P_NODE_34406_length_155_cov_2.037736_g33990_i0	PRJNA168635	34406	155	2.037736	3.1584908	Deinococcus	1298	Bacteria	Bacteria	110	7.46e-20	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g33990	i0	83.193	57.7096774193548	119	20	77	0	31	149	1204	1322	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	8945	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
8017707	8017707	PRJNA168635_P_NODE_15707_length_202_cov_2.039216_g15291_i0	PRJNA168635	15707	202	2.039216	4.11921632	Synergistales bacterium	2268201	Bacteria	Bacteria	122	1.32e-23	NTclustered	gi\|2621703689\|emb\|OY762654.1\|	2268201	g15291	i0	82.237	228.054455445545	152	18	73	9	5	151	236721	236868	MAG: Synergistales bacterium isolate e2a2af2a-30b9-47e3-8e03-f1be080e1666 genome assembly, chromosome: 1	blastn	46067	122	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
8017991	8017991	PRJNA168635_P_NODE_34187_length_155_cov_4.669811_g33771_i0	PRJNA168635	34187	155	4.669811	7.23820705	Allomeiothermus silvanus	52022	Bacteria	Bacteria	122	9.58e-24	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g33771	i0	98.571	2.25806451612903	70	0	45	1	68	136	308441	308372	Meiothermus silvanus DSM 9946, complete genome	blastn	350	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
8706957	8706957	PRJNA168635_P_NODE_17767_length_190_cov_2.971631_g17351_i0	PRJNA168635	17767	190	2.971631	5.6460989	Allomeiothermus	2935559	Bacteria	Bacteria	324	3.13e-84	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g17351	i0	97.368	145.457894736842	190	5	100	0	1	190	777	966	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	27637	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
9292353	9292353	PRJNA168635_P_NODE_11328_length_243_cov_6.505155_g10912_i0	PRJNA168635	11328	243	6.505155	15.80752665	Deinococcus rubellus	1889240	Bacteria	Bacteria	244	3.37e-60	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g10912	i0	85.141	376.543209876543	249	26	99	5	4	243	319909	320155	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	91500	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
9292530	9292530	PRJNA168635_P_NODE_20288_length_181_cov_2.568182_g19872_i0	PRJNA168635	20288	181	2.568182	4.64840942	Deinococcus ficus	317577	Bacteria	Bacteria	329	6.340000000000001e-86	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g19872	i0	99.448	210.629834254144	181	1	100	0	1	181	2342532	2342352	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	38124	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
9982329	9982329	PRJNA168635_P_NODE_24648_length_170_cov_1.685950_g24232_i0	PRJNA168635	24648	170	1.68595	2.866115	Deinococcus	1298	Bacteria	Bacteria	154	3.79e-33	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g24232	i0	83.237	148.3	173	24	100	4	1	170	1454408	1454578	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	25211	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
10568601	10568601	PRJNA168635_P_NODE_26389_length_168_cov_0.873950_g25973_i0	PRJNA168635	26389	168	0.87395	1.468236	Allomeiothermus silvanus	52022	Bacteria	Bacteria	292	7.64e-75	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g25973	i0	98.204	10.7083333333333	167	3	99	0	1	167	1711244	1711078	Meiothermus silvanus DSM 9946, complete genome	blastn	1799	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
11257481	11257481	PRJNA168635_P_NODE_19649_length_183_cov_4.380597_g19233_i0	PRJNA168635	19649	183	4.380597	8.01649251	Meiothermus	65551	Bacteria	Bacteria	163	6.899999999999999e-36	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g19233	i0	82.888	36.9289617486339	187	26	99	5	1	181	187	1	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	6758	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
11257574	11257574	PRJNA168635_P_NODE_31789_length_162_cov_1.415929_g31373_i0	PRJNA168635	31789	162	1.415929	2.29380498	root	1	Root_unresolved	Root_unresolved	300	4.36e-77	NTclustered	gi\|118025299\|emb\|AJ864718.1\|	277	g31373	i0	100	102.993827160494	162	0	100	0	1	162	1266	1105	Meiothermus ruber 16S rRNA gene, strain E-steel-R2A-2	blastn	16685	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
11257620	11257620	PRJNA168635_P_NODE_6089_length_343_cov_4.846939_g5680_i0	PRJNA168635	6089	343	4.846939	16.62500077	Deinococcus	1298	Bacteria	Bacteria	435	2.76e-117	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g5680	i0	89.685	214.431486880466	349	24	100	12	1	343	2367	2025	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	73550	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
13118580	13118580	PRJNA168635_P_NODE_9511_length_270_cov_4.972851_g9096_i0	PRJNA168635	9511	270	4.972851	13.4266977	Deinococcus aetherius	200252	Bacteria	Bacteria	180	1.09e-40	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g9096	i0	78.986	112.011111111111	276	48	100	10	1	270	822822	823093	Deinococcus aetherius ST0316 DNA, complete genome	blastn	30243	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
14393778	14393778	PRJNA168635_P_NODE_34992_length_153_cov_2.730769_g34576_i0	PRJNA168635	34992	153	2.730769	4.17807657	Synergistaceae bacterium	2053624	Bacteria	Bacteria	108	2.64e-19	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g34576	i0	83.929	11.0392156862745	112	18	79	0	42	153	324065	323954	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	1689	108	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
18215988	18215988	PRJNA168635_P_NODE_11435_length_242_cov_3.455959_g11019_i0	PRJNA168635	11435	242	3.455959	8.36342078	Deinococcus metallilatus	1211322	Bacteria	Bacteria	381	2.449999999999999e-101	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g11019	i0	95.082	201.409090909091	244	9	100	2	1	242	329494	329736	Deinococcus metallilatus strain MA1002 chromosome	blastn	48741	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
20180368	20180368	PRJNA168635_P_NODE_31496_length_162_cov_2.725664_g31080_i0	PRJNA168635	31496	162	2.725664	4.41557568	Thermotoga	2335	Bacteria	Bacteria	104	3.67e-18	NTclustered	gi\|806984312\|ref\|NG_042010.1\|	93929	g31080	i0	84.404	34.1049382716049	109	13	65	3	2	107	489	382	Thermotoga petrophila strain RKU-1 23S ribosomal RNA gene, complete sequence	blastn	5525	104	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga petrophila
20180444	20180444	PRJNA168635_P_NODE_7516_length_308_cov_6.332046_g7104_i0	PRJNA168635	7516	308	6.332046	19.50270168	Deinococcus	1298	Bacteria	Bacteria	424	5.29e-114	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g7104	i0	92.833	347.61038961039	293	19	95	2	11	303	413379	413089	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	107064	427	0.992974238875878	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
20180456	20180456	PRJNA168635_P_NODE_8396_length_291_cov_10.239669_g7981_i0	PRJNA168635	8396	291	10.239669	29.79743679	Meiothermus	65551	Bacteria	Bacteria	335	2.389999999999999e-87	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g7981	i0	87.5	159.628865979381	296	29	100	8	1	291	523	231	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	46452	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
21456029	21456029	PRJNA168635_P_NODE_21237_length_178_cov_3.457364_g20821_i0	PRJNA168635	21237	178	3.457364	6.15410792	root	1	Root_unresolved	Root_unresolved	329	6.21e-86	NTclustered	gi\|576924\|gb\|L37521.1\|TTHAC2	275	g20821	i0	100	102	178	0	100	0	1	178	472	649	Thermus sp. (strain ac-2) 16S ribosomal RNA (16S rRNA) gene	blastn	18156	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
21456055	21456055	PRJNA168635_P_NODE_23457_length_173_cov_0.879032_g23041_i0	PRJNA168635	23457	173	0.879032	1.52072536	Truepera	332248	Bacteria	Bacteria	270	3.69e-68	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g23041	i0	94.798	114.381502890173	173	9	100	0	1	173	1668	1840	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	19788	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
21456130	21456130	PRJNA168635_P_NODE_33537_length_157_cov_5.574074_g33121_i0	PRJNA168635	33537	157	5.574074	8.75129618	Meiothermus	65551	Bacteria	Bacteria	278	1.96e-70	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g33121	i0	98.718	42.5732484076433	156	2	99	0	1	156	812	657	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	6684	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
21456174	21456174	PRJNA168635_P_NODE_6017_length_345_cov_3.371622_g5609_i0	PRJNA168635	6017	345	3.371622	11.6320959	Deinococcus	1298	Bacteria	Bacteria	158	6.72e-34	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g5609	i0	85.35	320.779710144928	157	18	45	4	14	167	319531	319685	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	110669	159	0.993710691823899	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
24006248	24006248	PRJNA168635_P_NODE_29479_length_164_cov_2.669565_g29063_i0	PRJNA168635	29479	164	2.669565	4.3780866	Allomeiothermus	2935559	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g29063	i0	98.78	149	164	2	100	0	1	164	1916	1753	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	24436	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
24006374	24006374	PRJNA168635_P_NODE_9599_length_269_cov_2.086364_g9184_i0	PRJNA168635	9599	269	2.086364	5.61231916	Allomeiothermus	2935559	Bacteria	Bacteria	477	3.4299999999999985e-130	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g9184	i0	98.529	142.078066914498	272	1	100	1	1	269	1453	1724	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	38219	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
25280394	25280394	PRJNA168635_P_NODE_33680_length_157_cov_2.824074_g33264_i0	PRJNA168635	33680	157	2.824074	4.43379618	Deinococcus	1298	Bacteria	Bacteria	276	7.06e-70	NTclustered	gi\|1073549716\|gb\|KX946495.1\|	47478	g33264	i0	100	113.87898089172	149	0	95	0	1	149	153	5	Deinococcus sp. strain FX4 16S ribosomal RNA gene, partial sequence	blastn	17879	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.

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