metadata: contig_metadata: 27 rows where bioproject = "PRJNA1002570" and tax

27 rows where bioproject = "PRJNA1002570" 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
2702533	2702533	PRJNA1002570_P_NODE_25363_length_279_cov_1.121359_g25168_i0	PRJNA1002570	25363	279	1.121359	3.12859161	Bacteria	2	Bacteria	Bacteria	119	7.4e-31	NR	WP_248644177.1	37636	g25168	i0	70.8	21.1505376344086	89	26	95.7	0	267	1	4	92	WP_248644177.1 RNA-guided endonuclease InsQ/TnpB family protein, partial [Thermus scotoductus]	diamond	5901	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
4828699	4828699	PRJNA1002570_P_NODE_27024_length_275_cov_1.232673_g26829_i0	PRJNA1002570	27024	275	1.232673	3.38985075	Deinococcus	1298	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g26829	i0	100	201.174545454545	275	0	100	0	1	275	1454599	1454873	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	55323	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
7804691	7804691	PRJNA1002570_P_NODE_17147_length_302_cov_3.951965_g16952_i0	PRJNA1002570	17147	302	3.951965	11.9349343	Deinococcus grandis	57498	Bacteria	Bacteria	167	9.619999999999998e-37	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g16952	i0	93.043	22.8013245033113	115	6	38	2	189	302	1041744	1041857	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	6886	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7805254	7805254	PRJNA1002570_P_NODE_8307_length_395_cov_2.049689_g8112_i0	PRJNA1002570	8307	395	2.049689	8.09627155	Deinococcus radiomollis	468916	Bacteria	Bacteria	113	1.71e-20	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g8112	i0	85.981	6.4506329113924	107	13	27	2	1	106	828411	828516	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	2548	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
9079933	9079933	PRJNA1002570_P_NODE_35488_length_252_cov_1.318436_g35293_i0	PRJNA1002570	35488	252	1.318436	3.32245872	Deinococcus gobiensis	502394	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g35293	i0	99.206	2.66666666666667	252	2	100	0	1	252	1108628	1108377	Deinococcus gobiensis I-0, complete genome	blastn	672	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
14180820	14180820	PRJNA1002570_P_NODE_19452_length_292_cov_1.821918_g19257_i0	PRJNA1002570	19452	292	1.821918	5.32000056	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	418	2.3199999999999996e-112	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g19257	i0	91.935	2.12328767123288	310	7	100	6	1	292	2082257	2082566	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	620	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
15455117	15455117	PRJNA1002570_P_NODE_35573_length_251_cov_2.904494_g35378_i0	PRJNA1002570	35573	251	2.904494	7.29027994	Deinococcus taeanensis	2737050	Bacteria	Bacteria	174	4.65e-39	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g35378	i0	82.16	1.90836653386454	213	28	83	9	44	251	421856	421649	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	479	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
15455169	15455169	PRJNA1002570_P_NODE_38093_length_248_cov_2.262857_g37898_i0	PRJNA1002570	38093	248	2.262857	5.61188536	Deinococcus sp.	47478	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2425458090\|gb\|OQ221940.1\|	47478	g37898	i0	100	105.814516129032	248	0	100	0	1	248	152	399	Deinococcus sp. strain 926 16S ribosomal RNA gene, partial sequence	blastn	26242	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16303277	16303277	PRJNA1002570_P_NODE_42393_length_243_cov_0.905882_g42198_i0	PRJNA1002570	42393	243	0.905882	2.20129326	Deinobacterium chartae	521158	Bacteria	Bacteria	128	3.29e-32	NR	WP_183984939.1	521158	g42198	i0	77.5	0.987654320987654	80	18	98.8	0	242	3	177	256	WP_183984939.1 M16 family metallopeptidase [Deinobacterium chartae]	diamond	240	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinobacterium	Deinobacterium chartae
19278136	19278136	PRJNA1002570_P_NODE_40756_length_245_cov_1.343023_g40561_i0	PRJNA1002570	40756	245	1.343023	3.29040635	Thermus sp. PS18	2849039	Bacteria	Bacteria	398	2.47e-106	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g40561	i0	95.918	4	245	10	100	0	1	245	2125223	2125467	Thermus sp. PS18 chromosome, complete genome	blastn	980	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
21402787	21402787	PRJNA1002570_P_NODE_26357_length_276_cov_2.147783_g26162_i0	PRJNA1002570	26357	276	2.147783	5.92788108	Deinococcus	1298	Bacteria	Bacteria	462	9.89e-126	NTclustered	gi\|161513486\|emb\|AM292065.1\|	1299	g26162	i0	97.08	126.507246376812	274	8	99	0	3	276	133	406	Deinococcus radiodurans partial 16S rRNA gene, isolate zf-69-II	blastn	34916	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
21829241	21829241	PRJNA1002570_P_NODE_33238_length_258_cov_2.491892_g33043_i0	PRJNA1002570	33238	258	2.491892	6.42908136	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	449	7.13e-122	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g33043	i0	98.062	99.2286821705426	258	5	100	0	1	258	285569	285312	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	25601	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
24378190	24378190	PRJNA1002570_P_NODE_22480_length_285_cov_1.452830_g22285_i0	PRJNA1002570	22480	285	1.45283	4.1405655	Deinococcus aquiradiocola	393059	Bacteria	Bacteria	191	3.7900000000000005e-58	NR	WP_188964718.1	393059	g22285	i0	98.9	1	95	1	100	0	1	285	95	189	WP_188964718.1 peptidase C39 family protein [Deinococcus aquiradiocola]	diamond	285	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquiradiocola
27287283	27287283	PRJNA1002570_P_NODE_40443_length_245_cov_3.046512_g40248_i0	PRJNA1002570	40443	245	3.046512	7.4639544	Deinococcota bacterium	1913990	Bacteria	Bacteria	111	3.1200000000000003e-27	NR	MDQ3397577.1	1913990	g40248	i0	60.5	0.991836734693878	81	32	99.2	0	3	245	4	84	MDQ3397577.1 Gfo/Idh/MocA family oxidoreductase [Deinococcota bacterium]	diamond	243	111	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
27311719	27311719	PRJNA1002570_P_NODE_38583_length_248_cov_0.880000_g38388_i0	PRJNA1002570	38583	248	0.88	2.1824	Thermaceae	188786	Bacteria	Bacteria	122	1.9199999999999999e-31	NR	WP_027893118.1	52023	g38388	i0	69.5	3.96774193548387	82	25	99.2	0	248	3	13	94	WP_027893118.1 aromatic ring-hydroxylating oxygenase subunit alpha [Calidithermus chliarophilus]	diamond	984	123	0.991869918699187	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus chliarophilus
27698198	27698198	PRJNA1002570_P_NODE_21424_length_287_cov_2.088785_g21229_i0	PRJNA1002570	21424	287	2.088785	5.99481295	Deinococcus metalli	1141878	Bacteria	Bacteria	168	3.88e-46	NR	WP_184109144.1	1141878	g21229	i0	90.2	1.06620209059233	102	3	99.3	1	2	286	211	312	WP_184109144.1 tetratricopeptide repeat protein [Deinococcus metalli]	diamond	306	168	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metalli
27722425	27722425	PRJNA1002570_P_NODE_20904_length_288_cov_2.255814_g20709_i0	PRJNA1002570	20904	288	2.255814	6.49674432	Bacteria	2	Bacteria	Bacteria	79.3	7.35e-15	NR	HEX7021822.1	2026798	g20709	i0	45.6	7.26041666666667	90	49	93.8	0	283	14	336	425	HEX7021822.1 thymidine phosphorylase [Trueperaceae bacterium]	diamond	2091	80.1	0.990012484394507	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
28574420	28574420	PRJNA1002570_P_NODE_23127_length_284_cov_1.099526_g22932_i0	PRJNA1002570	23127	284	1.099526	3.12265384	Deinococcus	1298	Bacteria	Bacteria	74.3	2.99e-13	NR	WP_343759752.1	392408	g22932	i0	70	4.73239436619718	50	15	52.8	0	172	23	3	52	WP_343759752.1 FAD-dependent oxidoreductase [Deinococcus depolymerans]	diamond	1344	74.7	0.994645247657296	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus depolymerans
29245003	29245003	PRJNA1002570_P_NODE_27969_length_272_cov_2.271357_g27774_i0	PRJNA1002570	27969	272	2.271357	6.17809104	Deinococcota bacterium DY0809b	3396280	Bacteria	Bacteria	115	9.38e-28	NR	XOB97560.1	3396280	g27774	i0	64.8	2.93382352941176	88	31	97.1	0	270	7	448	535	XOB97560.1 type I restriction-modification system subunit M [Deinococcota bacterium DY0809b]	diamond	798	115	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium DY0809b
29308049	29308049	PRJNA1002570_P_NODE_40189_length_246_cov_0.890173_g39994_i0	PRJNA1002570	40189	246	0.890173	2.18982558	Deinococcus cellulosilyticus	401558	Bacteria	Bacteria	92.8	3.04e-20	NR	WP_146883315.1	401558	g39994	i0	53.1	0.98780487804878	81	37	97.6	1	2	241	261	341	WP_146883315.1 hypothetical protein [Deinococcus cellulosilyticus]	diamond	243	92.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus
29364005	29364005	PRJNA1002570_P_NODE_2489_length_686_cov_2.786297_g2304_i0	PRJNA1002570	2489	686	2.786297	19.11399742	Bacteria	2	Bacteria	Bacteria	112	2.34e-25	NR	WP_264777489.1	200252	g2304	i0	61.3	1.65743440233236	93	36	40.7	0	400	678	3	95	WP_264777489.1 NAD(P)H-binding protein [Deinococcus aetherius]	diamond	1137	113	0.991150442477876	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
30065870	30065870	PRJNA1002570_P_NODE_11772_length_346_cov_1.128205_g11577_i0	PRJNA1002570	11772	346	1.128205	3.9035893	Trueperaceae bacterium	2026798	Bacteria	Bacteria	53.1	2.53e-5	NR	TVR96497.1	2026798	g11577	i0	40.8	0.658959537572254	76	43	65.9	1	344	117	46	119	TVR96497.1 MAG: class A beta-lactamase-related serine hydrolase, partial [Trueperaceae bacterium]	diamond	228	53.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30382386	30382386	PRJNA1002570_P_NODE_28813_length_270_cov_2.152284_g28618_i0	PRJNA1002570	28813	270	2.152284	5.8111668	Trueperaceae bacterium	2026798	Bacteria	Bacteria	69.3	2.14e-11	NR	MEX2542763.1	2026798	g28618	i0	42.7	0.988888888888889	89	47	94.4	1	268	14	21	109	MEX2542763.1 ATP-binding protein [Trueperaceae bacterium]	diamond	267	69.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
31266740	31266740	PRJNA1002570_P_NODE_12895_length_334_cov_1.076628_g12700_i0	PRJNA1002570	12895	334	1.076628	3.59593752	Deinococcaceae bacterium	3079796	Bacteria	Bacteria	126	1.31e-33	NR	MFN8510663.1	3079796	g12700	i0	67.5	0.745508982035928	83	27	74.6	0	84	332	11	93	MFN8510663.1 tRNA (5-methylaminomethyl-2-thiouridine)(34)-methyltransferase MnmD [Deinococcaceae bacterium]	diamond	249	126	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae		Deinococcaceae bacterium
32208377	32208377	PRJNA1002570_P_NODE_4478_length_511_cov_1.248858_g4284_i0	PRJNA1002570	4478	511	1.248858	6.38166438	Bacteria	2	Bacteria	Bacteria	87.4	9.86e-17	NR	MDB5046174.1	47478	g4284	i0	39.6	4.96673189823875	144	84	84	2	431	3	233	374	MDB5046174.1 Acyltransferase family protein [Deinococcus sp.]	diamond	2538	87.8	0.995444191343964	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
32279238	32279238	PRJNA1002570_P_NODE_9699_length_373_cov_1.026667_g9504_i0	PRJNA1002570	9699	373	1.026667	3.82946791	Deinococcus hopiensis	309885	Bacteria	Bacteria	69.7	5.81e-11	NR	WP_139807161.1	309885	g9504	i0	37.4	0.924932975871314	115	70	90.9	2	34	372	131	245	WP_139807161.1 FUSC family protein [Deinococcus hopiensis]	diamond	345	69.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
32374084	32374084	PRJNA1002570_P_NODE_35959_length_251_cov_0.865169_g35764_i0	PRJNA1002570	35959	251	0.865169	2.17157419	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	48.5	2.13e-4	NR	WP_353543606.1	457454	g35764	i0	42.9	0.669322709163347	56	30	66.9	2	2	169	134	187	WP_353543606.1 hypothetical protein [Deinococcus xinjiangensis]	diamond	168	48.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis

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