metadata: contig_metadata: 28 rows where bioproject = "PRJNA520845" and tax

28 rows where bioproject = "PRJNA520845" 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
489476	489476	PRJNA520845_P_NODE_187941_length_271_cov_1.878788_g186442_i0	PRJNA520845	187941	271	1.878788	5.09151548	Deinococcus yunweiensis	367282	Bacteria	Bacteria	176	1.41e-39	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g186442	i0	79.297	1.86346863468635	256	50	94	3	8	262	994598	994851	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	505	176	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
1763592	1763592	PRJNA520845_P_NODE_144742_length_310_cov_2.472574_g143243_i0	PRJNA520845	144742	310	2.472574	7.6649794	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	145	4.6399999999999994e-30	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g143243	i0	84.667	11.4290322580645	150	17	95	5	1	147	2269559	2269413	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	3543	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
3662937	3662937	PRJNA520845_P_NODE_237803_length_247_cov_0.885057_g236304_i0	PRJNA520845	237803	247	0.885057	2.18609079	Thermus	270	Bacteria	Bacteria	455	1.4600000000000002e-123	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g236304	i0	100	11.8663967611336	246	0	99	0	2	247	743183	743428	Thermus scotoductus SA-01, complete genome	blastn	2931	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
4316142	4316142	PRJNA520845_P_NODE_177944_length_279_cov_1.529126_g176445_i0	PRJNA520845	177944	279	1.529126	4.26626154	Deinococcus grandis	57498	Bacteria	Bacteria	274	5.04e-69	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g176445	i0	96.407	6.26164874551971	167	5	59	1	1	166	92495	92329	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1747	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
5595114	5595114	PRJNA520845_P_NODE_253085_length_243_cov_2.511765_g251586_i0	PRJNA520845	253085	243	2.511765	6.10358895	Deinococcus sp. 14RED	47478	Bacteria	Bacteria	122	1.69e-30	NR	WP_230288662.1	2745874	g251586	i0	100	0.790123456790123	64	0	79	0	51	242	385	448	WP_230288662.1 tetratricopeptide repeat-containing diguanylate cyclase [Deinococcus sp. 14RED07]	diamond	192	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. 14RED07
8764609	8764609	PRJNA520845_P_NODE_223387_length_249_cov_1.312500_g221888_i0	PRJNA520845	223387	249	1.3125	3.268125	Bacteria	2	Bacteria	Bacteria	108	4.74e-19	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g221888	i0	98.361	27.2570281124498	61	1	24	0	54	114	1598059	1597999	Deinococcus proteolyticus MRP, complete genome	blastn	6787	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
9419208	9419208	PRJNA520845_P_NODE_243048_length_245_cov_3.779070_g241549_i0	PRJNA520845	243048	245	3.77907	9.2587215	Deinococcus aquaticus	328692	Bacteria	Bacteria	183	7.519999999999998e-42	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g241549	i0	83.085	0.820408163265306	201	34	82	0	8	208	1787753	1787553	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	201	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
10040063	10040063	PRJNA520845_P_NODE_202888_length_259_cov_1.618280_g201389_i0	PRJNA520845	202888	259	1.61828	4.1913452	Deinococcus	1298	Bacteria	Bacteria	289	1.65e-73	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g201389	i0	88.889	57.8069498069498	234	26	90	0	10	243	225467	225234	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	14972	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
10694379	10694379	PRJNA520845_P_NODE_225549_length_249_cov_0.875000_g224050_i0	PRJNA520845	225549	249	0.875	2.17875	Deinococcus aquaticus	328692	Bacteria	Bacteria	180	9.91e-41	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g224050	i0	81.526	1.46184738955823	249	19	100	6	1	249	862764	862543	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	364	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
11968175	11968175	PRJNA520845_P_NODE_184590_length_274_cov_1.388060_g183091_i0	PRJNA520845	184590	274	1.38806	3.8032844	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	364	2.8499999999999992e-96	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g183091	i0	91.078	1.9014598540146	269	24	98	0	1	269	2325002	2325270	Deinococcus sp. NW-56 chromosome, complete genome	blastn	521	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12590669	12590669	PRJNA520845_P_NODE_244370_length_245_cov_0.895349_g242871_i0	PRJNA520845	244370	245	0.895349	2.19360505	Deinococcus	1298	Bacteria	Bacteria	95.3	3.62e-15	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g242871	i0	78.912	1.18775510204082	147	26	60	4	100	245	2079628	2079486	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	291	95.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
14520337	14520337	PRJNA520845_P_NODE_258592_length_242_cov_1.508876_g257093_i0	PRJNA520845	258592	242	1.508876	3.65147992	Deinococcus ficus	317577	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g257093	i0	97.934	1	242	5	100	0	1	242	19131	19372	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	242	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
16414477	16414477	PRJNA520845_P_NODE_253033_length_243_cov_3.552941_g251534_i0	PRJNA520845	253033	243	3.552941	8.63364663	Meiothermus	65551	Bacteria	Bacteria	75.9	4.05e-16	NR	WP_119357257.1	863370	g251534	i0	69.4	4.34567901234568	49	15	60.5	0	90	236	3	51	WP_119357257.1 cold-shock protein [Meiothermus granaticius]	diamond	1056	76.3	0.99475753604194	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus granaticius
19617494	19617494	PRJNA520845_P_NODE_259896_length_242_cov_0.911243_g258397_i0	PRJNA520845	259896	242	0.911243	2.20520806	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g258397	i0	99.587	49.3471074380165	242	1	100	0	1	242	315318	315559	Thermus sp. NEB1569 chromosome, complete genome	blastn	11942	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
20237992	20237992	PRJNA520845_P_NODE_203756_length_258_cov_2.410811_g202257_i0	PRJNA520845	203756	258	2.410811	6.21989238	Deinococcus	1298	Bacteria	Bacteria	241	4.67e-59	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g202257	i0	83.658	6.27906976744186	257	40	99	2	3	258	1737846	1738101	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	1620	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
20893138	20893138	PRJNA520845_P_NODE_247177_length_245_cov_0.895349_g245678_i0	PRJNA520845	247177	245	0.895349	2.19360505	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	193	1.25e-44	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g245678	i0	80.816	27.9510204081633	245	47	100	0	1	245	1762438	1762194	Deinococcus sp. QL22 chromosome, complete genome	blastn	6848	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
23441599	23441599	PRJNA520845_P_NODE_174339_length_282_cov_1.473684_g172840_i0	PRJNA520845	174339	282	1.473684	4.15578888	Deinococcus ficus	317577	Bacteria	Bacteria	206	1.8899999999999994e-48	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g172840	i0	80.292	3.9290780141844	274	52	97	2	10	282	1678210	1677938	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	1108	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
26728690	26728690	PRJNA520845_P_NODE_34281_length_648_cov_2.292174_g32827_i0	PRJNA520845	34281	648	2.292174	14.85328752	Deinococcus hopiensis	309885	Bacteria	Bacteria	294	2.0399999999999998e-94	NR	WP_170928889.1	309885	g32827	i0	74.2	1.70833333333333	186	48	86.1	0	87	644	43	228	WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis]	diamond	1107	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
26824285	26824285	PRJNA520845_P_NODE_256681_length_243_cov_0.905882_g255182_i0	PRJNA520845	256681	243	0.905882	2.20129326	Deinococcus antarcticus	1298767	Bacteria	Bacteria	147	3.55e-42	NR	WP_380079132.1	1298767	g255182	i0	100	0.864197530864197	70	0	86.4	0	241	32	179	248	WP_380079132.1 HepT-like ribonuclease domain-containing protein [Deinococcus antarcticus]	diamond	210	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
27361950	27361950	PRJNA520845_P_NODE_142823_length_312_cov_2.451883_g141324_i0	PRJNA520845	142823	312	2.451883	7.64987496	Synergistales bacterium	2268201	Bacteria	Bacteria	64.7	1.46e-9	NR	HOG14510.1	2268201	g141324	i0	69	1.64423076923077	42	13	40.4	0	1	126	305	346	HOG14510.1 GDP-mannose 4,6-dehydratase [Synergistales bacterium]	diamond	513	64.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
27425137	27425137	PRJNA520845_P_NODE_195703_length_265_cov_1.604167_g194204_i0	PRJNA520845	195703	265	1.604167	4.25104255	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	149	1.86e-42	NR	WP_353541169.1	457454	g194204	i0	100	0.883018867924528	78	0	88.3	0	3	236	188	265	WP_353541169.1 NINE protein [Deinococcus xinjiangensis]	diamond	234	149	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
28624941	28624941	PRJNA520845_P_NODE_228827_length_248_cov_1.320000_g227328_i0	PRJNA520845	228827	248	1.32	3.2736	Deinococcus roseus	392414	Bacteria	Bacteria	117	2.9e-28	NR	WP_229684590.1	392414	g227328	i0	70.3	1.79032258064516	74	22	89.5	0	247	26	352	425	WP_229684590.1 glycosyl hydrolase family 18 protein [Deinococcus roseus]	diamond	444	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
29856110	29856110	PRJNA520845_P_NODE_185671_length_273_cov_1.540000_g184172_i0	PRJNA520845	185671	273	1.54	4.2042	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	184	8.509999999999996e-55	NR	WP_353540740.1	457454	g184172	i0	98.9	0.989010989010989	90	1	98.9	0	3	272	225	314	WP_353540740.1 Gfo/Idh/MocA family oxidoreductase [Deinococcus xinjiangensis]	diamond	270	184	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
29982538	29982538	PRJNA520845_P_NODE_64311_length_464_cov_1.700767_g62812_i0	PRJNA520845	64311	464	1.700767	7.89155888	Deinococcus misasensis	392413	Bacteria	Bacteria	53.9	4.48e-5	NR	WP_034336163.1	392413	g62812	i0	26.4	0.782327586206897	121	83	74.4	2	383	39	347	467	WP_034336163.1 thiol-activated cytolysin family protein [Deinococcus misasensis]	diamond	363	53.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
30029527	30029527	PRJNA520845_P_NODE_212711_length_251_cov_1.657303_g211212_i0	PRJNA520845	212711	251	1.657303	4.15983053	Bacteria	2	Bacteria	Bacteria	50.4	6.93e-5	NR	MFA5551636.1	2026798	g211212	i0	42.9	1.94820717131474	63	30	68.1	1	206	36	32	94	MFA5551636.1 TspO/MBR family protein [Trueperaceae bacterium]	diamond	489	50.8	0.992125984251969	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30203408	30203408	PRJNA520845_P_NODE_238512_length_246_cov_1.427746_g237013_i0	PRJNA520845	238512	246	1.427746	3.51225516	Deinococcus cavernae	2320857	Bacteria	Bacteria	98.2	7.290000000000001e-22	NR	WP_119760211.1	2320857	g237013	i0	84.7	0.719512195121951	59	9	72	0	70	246	29	87	WP_119760211.1 esterase-like activity of phytase family protein [Deinococcus cavernae]	diamond	177	98.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
31214257	31214257	PRJNA520845_P_NODE_166375_length_288_cov_2.651163_g164876_i0	PRJNA520845	166375	288	2.651163	7.63534944	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	187	1.78e-58	NR	WP_353542765.1	457454	g164876	i0	100	0.989583333333333	95	0	99	0	286	2	56	150	WP_353542765.1 histidine phosphatase family protein [Deinococcus xinjiangensis]	diamond	285	187	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
32147477	32147477	PRJNA520845_P_NODE_199618_length_262_cov_1.222222_g198119_i0	PRJNA520845	199618	262	1.222222	3.20222164	Bacteria	2	Bacteria	Bacteria	126	4.12e-32	NR	WP_170928889.1	309885	g198119	i0	64	2.79389312977099	86	31	98.5	0	2	259	260	345	WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis]	diamond	732	126	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis

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