metadata: contig_metadata: 32 rows where bioproject = "PRJNA1022392" and tax

32 rows where bioproject = "PRJNA1022392" 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
162168	162168	PRJNA1022392_P_NODE_46121_length_194_cov_2.877551_g45452_i0	PRJNA1022392	46121	194	2.877551	5.58244894	Deinococcus radiopugnans	57497	Bacteria	Bacteria	97.1	7.63e-16	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g45452	i0	84.536	1.43814432989691	97	15	50	0	98	194	325116	325020	Deinococcus swuensis strain DY59, complete genome	blastn	279	97.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
2279130	2279130	PRJNA1022392_P_NODE_59562_length_178_cov_1.175573_g58893_i0	PRJNA1022392	59562	178	1.175573	2.09251994	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	115	3.13e-29	NR	WP_386845130.1	536443	g58893	i0	98.3	0.99438202247191	59	1	99.4	0	1	177	184	242	WP_386845130.1 ABC transporter ATP-binding protein [Deinococcus taklimakanensis]	diamond	177	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
2279200	2279200	PRJNA1022392_P_NODE_70262_length_165_cov_0.864407_g69593_i0	PRJNA1022392	70262	165	0.864407	1.42627155	Fervidobacterium	2422	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g69593	i0	99.394	4.93939393939394	165	1	100	0	1	165	1805554	1805390	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	815	300	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
2712813	2712813	PRJNA1022392_P_NODE_59283_length_178_cov_1.954198_g58614_i0	PRJNA1022392	59283	178	1.954198	3.47847244	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	322	1.04e-83	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g58614	i0	99.435	5.5	177	1	99	0	2	178	751792	751616	Thermus sp. NEB1569 chromosome, complete genome	blastn	979	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
3988635	3988635	PRJNA1022392_P_NODE_33504_length_206_cov_2.723270_g32835_i0	PRJNA1022392	33504	206	2.72327	5.6099362	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	159	1.03e-34	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g32835	i0	95.918	16.9757281553398	98	4	48	0	109	206	360011	360108	Deinococcus sp. NW-56 chromosome, complete genome	blastn	3497	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
4831946	4831946	PRJNA1022392_P_NODE_55324_length_183_cov_2.617647_g54655_i0	PRJNA1022392	55324	183	2.617647	4.79029401	Fervidobacterium	2422	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g54655	i0	100	4.01092896174863	124	0	68	0	60	183	1737696	1737819	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	734	230	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
11640787	11640787	PRJNA1022392_P_NODE_43830_length_195_cov_2.790541_g43161_i0	PRJNA1022392	43830	195	2.790541	5.44155495	Aminithiophilus ramosus	3029084	Bacteria	Bacteria	69.4	1.67e-7	NTclustered	gi\|2027188528\|gb\|CP072943.1\|	3029084	g43161	i0	95.349	3.00512820512821	43	2	22	0	153	195	1413766	1413724	Aminithiophilus ramosus strain J.5.4.2-T.3.5.2 chromosome, complete genome	blastn	586	69.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminithiophilaceae	Aminithiophilus	Aminithiophilus ramosus
11641198	11641198	PRJNA1022392_P_NODE_80150_length_157_cov_2.045455_g79481_i0	PRJNA1022392	80150	157	2.045455	3.21136435	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	230	5.58e-56	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g79481	i0	92.994	33.9108280254777	157	11	100	0	1	157	2507806	2507650	Deinococcus sp. NW-56 chromosome, complete genome	blastn	5324	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12916274	12916274	PRJNA1022392_P_NODE_74911_length_161_cov_1.728070_g74242_i0	PRJNA1022392	74911	161	1.72807	2.7821927	Allomeiothermus silvanus	52022	Bacteria	Bacteria	189	9.77e-44	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g74242	i0	88.889	0.950310559006211	153	17	95	0	9	161	2545650	2545802	Meiothermus silvanus DSM 9946, complete genome	blastn	153	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
12916373	12916373	PRJNA1022392_P_NODE_84951_length_150_cov_2.475728_g84282_i0	PRJNA1022392	84951	150	2.475728	3.713592	Deinococcus geothermalis	68909	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g84282	i0	99.333	1	150	1	100	0	1	150	2117984	2118133	Deinococcus geothermalis DSM 11300, complete genome	blastn	150	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
14191223	14191223	PRJNA1022392_P_NODE_79972_length_157_cov_2.509091_g79303_i0	PRJNA1022392	79972	157	2.509091	3.93927287	Deinococcus metallilatus	1211322	Bacteria	Bacteria	215	1.56e-51	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g79303	i0	91.667	5.61783439490446	156	11	99	2	3	157	2625682	2625528	Deinococcus metallilatus strain MA1002 chromosome	blastn	882	215	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
18014333	18014333	PRJNA1022392_P_NODE_68875_length_166_cov_1.949580_g68206_i0	PRJNA1022392	68875	166	1.94958	3.2363028	Allomeiothermus silvanus	52022	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g68206	i0	98.193	1	166	3	100	0	1	166	2974263	2974428	Meiothermus silvanus DSM 9946, complete genome	blastn	166	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
18855371	18855371	PRJNA1022392_P_NODE_24115_length_214_cov_2.838323_g23446_i0	PRJNA1022392	24115	214	2.838323	6.07401122	root	1	Root_unresolved	Root_unresolved	387	4.55e-103	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g23446	i0	99.528	56.1869158878505	212	1	99	0	1	212	1974	2185	Thermus aquaticus DNA polymerase (PolI) gene	blastn	12024	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
18855692	18855692	PRJNA1022392_P_NODE_79215_length_158_cov_0.918919_g78546_i0	PRJNA1022392	79215	158	0.918919	1.45189202	Deinococcus	1298	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g78546	i0	100	3.20253164556962	158	0	100	0	1	158	949245	949402	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	506	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
19288307	19288307	PRJNA1022392_P_NODE_79216_length_158_cov_0.918919_g78547_i0	PRJNA1022392	79216	158	0.918919	1.45189202	Thermus thermophilus	274	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g78547	i0	100	42.7658227848101	158	0	100	0	1	158	1672302	1672459	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	6757	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25230167	25230167	PRJNA1022392_P_NODE_58680_length_179_cov_1.409091_g58011_i0	PRJNA1022392	58680	179	1.409091	2.52227289	Thermus	270	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g58011	i0	100	35.6312849162011	179	0	100	0	1	179	1505948	1505770	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	6378	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
26654849	26654849	PRJNA1022392_P_NODE_29701_length_206_cov_3.779874_g29032_i0	PRJNA1022392	29701	206	3.779874	7.78654044	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	64.7	3.7e-12	NR	AEV17142.1	1111069	g29032	i0	90.6	0.466019417475728	32	3	46.6	0	98	3	1	32	AEV17142.1 Alpha-aminoadipate carrier protein lysW [Thermus sp. CCB_US3_UF1]	diamond	96	64.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
26654851	26654851	PRJNA1022392_P_NODE_44441_length_195_cov_2.358108_g43772_i0	PRJNA1022392	44441	195	2.358108	4.5983106	Deinococcus sp. RM	2316359	Bacteria	Bacteria	61.6	2.81e-9	NR	WP_119673422.1	2316359	g43772	i0	82.9	0.538461538461538	35	6	53.8	0	91	195	82	116	WP_119673422.1 hypothetical protein [Deinococcus sp. RM]	diamond	105	61.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. RM
26971602	26971602	PRJNA1022392_P_NODE_84342_length_151_cov_2.461538_g83673_i0	PRJNA1022392	84342	151	2.461538	3.71692238	Deinococcus radiophilus	32062	Bacteria	Bacteria	70.5	1.76e-12	NR	WP_126351156.1	32062	g83673	i0	66.7	1.90728476821192	48	16	95.4	0	150	7	858	905	WP_126351156.1 DUF11 domain-containing protein [Deinococcus radiophilus]	diamond	288	70.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
27003155	27003155	PRJNA1022392_P_NODE_33302_length_206_cov_2.767296_g32633_i0	PRJNA1022392	33302	206	2.767296	5.70062976	Deinococcus cellulosilyticus	401558	Bacteria	Bacteria	65.1	3.49e-11	NR	WP_186815829.1	401558	g32633	i0	96.9	0.466019417475728	32	1	46.6	0	2	97	83	114	WP_186815829.1 Lrp/AsnC family transcriptional regulator [Deinococcus cellulosilyticus]	diamond	96	65.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus
27287831	27287831	PRJNA1022392_P_NODE_60603_length_176_cov_3.116279_g59934_i0	PRJNA1022392	60603	176	3.116279	5.48465104	uncultured Truepera sp.	543023	Bacteria	Bacteria	57.8	8e-9	NR	CAA9562262.1	543023	g59934	i0	73.7	0.647727272727273	38	10	64.8	0	175	62	81	118	CAA9562262.1 MAG: hypothetical protein AVDCRST_MAG86-736 [uncultured Truepera sp.]	diamond	114	57.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
28298243	28298243	PRJNA1022392_P_NODE_11506_length_328_cov_3.911032_g10844_i0	PRJNA1022392	11506	328	3.911032	12.82818496	Dethiosulfovibrio sp.	2944751	Bacteria	Bacteria	138	7.74e-39	NR	MDD4837478.1	2944751	g10844	i0	61.1	0.98780487804878	108	40	97	1	2	319	72	179	MDD4837478.1 hypothetical protein [Dethiosulfovibrio sp.]	diamond	324	138	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio	Dethiosulfovibrio sp.
28551103	28551103	PRJNA1022392_P_NODE_61167_length_176_cov_0.906977_g60498_i0	PRJNA1022392	61167	176	0.906977	1.59627952	Deinococcus misasensis	392413	Bacteria	Bacteria	119	2.49e-31	NR	WP_034345641.1	392413	g60498	i0	96.6	0.988636363636364	58	2	98.9	0	176	3	24	81	WP_034345641.1 alpha/beta hydrolase [Deinococcus misasensis]	diamond	174	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
29024886	29024886	PRJNA1022392_P_NODE_34628_length_206_cov_2.484277_g33959_i0	PRJNA1022392	34628	206	2.484277	5.11761062	uncultured Truepera sp.	543023	Bacteria	Bacteria	87.4	4.2e-18	NR	CAA9586658.1	543023	g33959	i0	57.6	1.2378640776699	85	19	99	1	2	205	1007	1091	CAA9586658.1 MAG: GH13_16 \| GH13_36 \| GH13_23 \| GH13_17 \| GH13 _4 \| GH13_31 \| GH13 \| GH13_40 \| GH13_30 \| GH13_29 \| G H13_35 \| GH13_20 \| GH13_2 \| GH13_21 \| GH13_18 \| GH13 _34 \| GH13_1 [uncultured Truepera sp.]	diamond	255	87.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
29561151	29561151	PRJNA1022392_P_NODE_47890_length_192_cov_4.255172_g47221_i0	PRJNA1022392	47890	192	4.255172	8.16993024	Deinococcus cavernae	2320857	Bacteria	Bacteria	91.3	2.17e-20	NR	WP_119759979.1	2320857	g47221	i0	52.2	1.4375	92	16	100	1	192	1	103	194	WP_119759979.1 cycloisomerase [Deinococcus cavernae]	diamond	276	91.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
29655591	29655591	PRJNA1022392_P_NODE_62090_length_174_cov_3.858268_g61421_i0	PRJNA1022392	62090	174	3.858268	6.71338632	Aminivibrio sp.	1872489	Bacteria	Bacteria	39.3	0.0443	NR	HPK07954.1	1872489	g61421	i0	54.3	0.603448275862069	35	15	60.3	1	38	142	14	47	HPK07954.1 hypothetical protein [Aminivibrio sp.]	diamond	105	39.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.
29940389	29940389	PRJNA1022392_P_NODE_52311_length_187_cov_2.321429_g51642_i0	PRJNA1022392	52311	187	2.321429	4.34107223	Truepera radiovictrix	332249	Bacteria	Bacteria	55.1	7.9e-7	NR	WP_013177145.1	332249	g51642	i0	74.2	0.497326203208556	31	8	49.7	0	2	94	211	241	WP_013177145.1 N-6 DNA methylase [Truepera radiovictrix]	diamond	93	55.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
30192884	30192884	PRJNA1022392_P_NODE_52192_length_187_cov_2.771429_g51523_i0	PRJNA1022392	52192	187	2.771429	5.18257223	Deinococcus aestuarii	2774531	Bacteria	Bacteria	99.8	1.8199999999999994e-23	NR	WP_216324452.1	2774531	g51523	i0	60	1.60427807486631	100	1	97.9	1	3	185	94	193	WP_216324452.1 DMT family transporter [Deinococcus aestuarii]	diamond	300	99.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
30635129	30635129	PRJNA1022392_P_NODE_40153_length_196_cov_4.684564_g39484_i0	PRJNA1022392	40153	196	4.684564	9.18174544	Meiothermus hypogaeus	884155	Bacteria	Bacteria	52.8	4.08e-7	NR	WP_119340678.1	884155	g39484	i0	89.7	0.443877551020408	29	3	44.4	0	3	89	32	60	WP_119340678.1 HypC/HybG/HupF family hydrogenase formation chaperone [Meiothermus hypogaeus]	diamond	87	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus
31038476	31038476	PRJNA1022392_P_NODE_37575_length_204_cov_2.000000_g36906_i0	PRJNA1022392	37575	204	2	4.08	Deinococci	188787	Bacteria	Bacteria	68.9	6.68e-13	NR	MBA2666787.1	2026798	g36906	i0	85.4	2.41176470588235	41	6	60.3	0	204	82	36	76	MBA2666787.1 30S ribosomal protein S11 [Trueperaceae bacterium]	diamond	492	68.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
31931420	31931420	PRJNA1022392_P_NODE_76817_length_160_cov_0.858407_g76148_i0	PRJNA1022392	76817	160	0.858407	1.3734512	Thermus oshimai	56957	Bacteria	Bacteria	56.6	7.99e-9	NR	GAA6741988.1	56957	g76148	i0	65.8	0.7125	38	13	71.3	0	155	42	45	82	GAA6741988.1 hypothetical protein Thermus77359_21750 [Thermus oshimai]	diamond	114	56.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
32532953	32532953	PRJNA1022392_P_NODE_57479_length_180_cov_3.699248_g56810_i0	PRJNA1022392	57479	180	3.699248	6.6586464	Fervidobacterium sp.	1871331	Bacteria	Bacteria	99.8	1.93e-25	NR	MBP9518197.1	1871331	g56810	i0	100	0.783333333333333	47	0	78.3	0	141	1	1	47	MBP9518197.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Fervidobacterium sp.]	diamond	141	99.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium 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);;