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

28 rows where bioproject = "PRJNA874604" 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
2128184	2128184	PRJNA874604_P_NODE_91362_length_244_cov_0.900585_g91010_i0	PRJNA874604	91362	244	0.900585	2.1974274	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	252	2.02e-62	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g91010	i0	85.537	19.3770491803279	242	33	99	2	2	242	2219666	2219906	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	4728	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4680869	4680869	PRJNA874604_P_NODE_75424_length_249_cov_0.875000_g75072_i0	PRJNA874604	75424	249	0.875	2.17875	Deinococcus aetherius	200252	Bacteria	Bacteria	209	1.26e-49	NTclustered	gi\|2281898193\|dbj\|AP026561.1\|	200252	g75072	i0	84.689	0.839357429718876	209	32	84	0	31	239	398109	397901	Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome	blastn	209	209	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
6342243	6342243	PRJNA874604_P_NODE_82265_length_247_cov_0.885057_g81913_i0	PRJNA874604	82265	247	0.885057	2.18609079	Trueperaceae bacterium	2026798	Bacteria	Bacteria	117	5.35e-30	NR	HEX7004586.1	2026798	g81913	i0	68.3	3.78947368421053	82	26	99.6	0	1	246	15	96	HEX7004586.1 isocitrate lyase/phosphoenolpyruvate mutase family protein [Trueperaceae bacterium]	diamond	936	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7230770	7230770	PRJNA874604_P_NODE_77946_length_248_cov_0.880000_g77594_i0	PRJNA874604	77946	248	0.88	2.1824	Deinococcus grandis	57498	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g77594	i0	96.774	55.1733870967742	248	8	100	0	1	248	289439	289192	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	13683	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8505273	8505273	PRJNA874604_P_NODE_66627_length_254_cov_1.519337_g66275_i0	PRJNA874604	66627	254	1.519337	3.85911598	Deinococcus aetherius	200252	Bacteria	Bacteria	315	2.66e-81	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g66275	i0	89.243	7.56692913385827	251	27	99	0	2	252	1989845	1989595	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1922	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
9780236	9780236	PRJNA874604_P_NODE_68488_length_251_cov_1.382022_g68136_i0	PRJNA874604	68488	251	1.382022	3.46887522	Thermus thermophilus	274	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g68136	i0	98.008	65.5737051792829	251	5	100	0	1	251	85272	85522	Thermus thermophilus TF27 DNA, complete genome	blastn	16459	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
11055644	11055644	PRJNA874604_P_NODE_44749_length_296_cov_0.959641_g44397_i0	PRJNA874604	44749	296	0.959641	2.84053736	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	405	1.83e-108	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g44397	i0	95.038	186.72972972973	262	5	87	8	1	258	1886014	1886271	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	55272	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
12330394	12330394	PRJNA874604_P_NODE_101330_length_234_cov_2.440994_g100978_i0	PRJNA874604	101330	234	2.440994	5.71192596	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	422	1.39e-113	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g100978	i0	99.145	8.55982905982906	234	2	100	0	1	234	173541	173774	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	2003	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
14880503	14880503	PRJNA874604_P_NODE_74832_length_249_cov_0.875000_g74480_i0	PRJNA874604	74832	249	0.875	2.17875	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	195	3.5399999999999996e-45	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g74480	i0	81.008	2.39357429718876	258	37	100	7	1	249	550151	550405	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	596	195	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
17430263	17430263	PRJNA874604_P_NODE_53114_length_278_cov_1.502439_g52762_i0	PRJNA874604	53114	278	1.502439	4.17678042	Deinococcus metallilatus	1211322	Bacteria	Bacteria	254	6.54e-63	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g52762	i0	87.387	5.63669064748201	222	26	79	2	57	277	2429657	2429437	Deinococcus metallilatus strain MA1002 chromosome	blastn	1567	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
17430832	17430832	PRJNA874604_P_NODE_81894_length_247_cov_0.885057_g81542_i0	PRJNA874604	81894	247	0.885057	2.18609079	Cloacibacillus porcorum	1197717	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1050315908\|gb\|CP016757.1\|	1197717	g81542	i0	100	1	247	0	100	0	1	247	1094983	1095229	Cloacibacillus porcorum strain CL-84 chromosome, complete genome	blastn	247	457	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus porcorum
19089191	19089191	PRJNA874604_P_NODE_14735_length_457_cov_1.734375_g14383_i0	PRJNA874604	14735	457	1.734375	7.92609375	Deinococcus	1298	Bacteria	Bacteria	634	3.4599999999999992e-177	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g14383	i0	91.868	271.781181619256	455	35	99	2	3	457	1455235	1454783	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	124204	634	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
19979530	19979530	PRJNA874604_P_NODE_91676_length_244_cov_0.900585_g91324_i0	PRJNA874604	91676	244	0.900585	2.1974274	Deinococcus aquaticus	328692	Bacteria	Bacteria	374	4.1399999999999986e-99	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g91324	i0	94.262	1	244	14	100	0	1	244	242255	242498	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	244	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
22529604	22529604	PRJNA874604_P_NODE_92898_length_243_cov_0.905882_g92546_i0	PRJNA874604	92898	243	0.905882	2.20129326	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g92546	i0	100	0.123456790123457	30	0	12	0	23	52	933349	933320	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
24189529	24189529	PRJNA874604_P_NODE_48639_length_287_cov_1.102804_g48287_i0	PRJNA874604	48639	287	1.102804	3.16504748	Deinococcus	1298	Bacteria	Bacteria	464	2.8799999999999993e-126	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g48287	i0	96.127	1.97909407665505	284	11	99	0	4	287	65520	65237	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	568	464	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
24189610	24189610	PRJNA874604_P_NODE_57359_length_271_cov_1.025253_g57007_i0	PRJNA874604	57359	271	1.025253	2.77843563	Deinococcus	1298	Bacteria	Bacteria	440	4.539999999999998e-119	NTclustered	gi\|545344372\|gb\|KF507604.1\|	158789	g57007	i0	95.956	105.033210332103	272	10	100	1	1	271	472	201	Uncultured Deinococcus sp. clone 7270 16S ribosomal RNA gene, partial sequence	blastn	28464	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
25078583	25078583	PRJNA874604_P_NODE_75040_length_249_cov_0.875000_g74688_i0	PRJNA874604	75040	249	0.875	2.17875	Deinococcus grandis	57498	Bacteria	Bacteria	195	3.5399999999999996e-45	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g74688	i0	81.25	23.6787148594378	240	45	96	0	1	240	110012	109773	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	5896	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
26683318	26683318	PRJNA874604_P_NODE_38061_length_315_cov_1.272727_g37709_i0	PRJNA874604	38061	315	1.272727	4.00909005	Bacteria	2	Bacteria	Bacteria	214	8.77e-63	NR	1TAQ_A	271	g37709	i0	100	3.96190476190476	104	0	99	0	313	2	92	195	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1248	214	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27947749	27947749	PRJNA874604_P_NODE_77585_length_248_cov_0.880000_g77233_i0	PRJNA874604	77585	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	89.7	5.8e-20	NR	WP_309570986.1	47478	g77233	i0	55.4	5.02016129032258	83	36	99.2	1	248	3	9	91	WP_309570986.1 hypothetical protein [Deinococcus sp.]	diamond	1245	90.1	0.995560488346282	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
29147887	29147887	PRJNA874604_P_NODE_99229_length_241_cov_0.916667_g98877_i0	PRJNA874604	99229	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	126	1.54e-31	NR	1TAQ_A	271	g98877	i0	100	2.37759336099585	64	0	79.7	0	240	49	769	832	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	573	126	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
29770788	29770788	PRJNA874604_P_NODE_83131_length_246_cov_1.618497_g82779_i0	PRJNA874604	83131	246	1.618497	3.98150262	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	147	1.78e-40	NR	WP_386842286.1	536443	g82779	i0	97.5	0.98780487804878	81	2	98.8	0	3	245	190	270	WP_386842286.1 glutamate ligase domain-containing protein [Deinococcus taklimakanensis]	diamond	243	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30348143	30348143	PRJNA874604_P_NODE_45672_length_293_cov_1.400000_g45320_i0	PRJNA874604	45672	293	1.4	4.102	root	1	Root_unresolved	Root_unresolved	187	5.03e-53	NR	1TAQ_A	271	g45320	i0	97.9	3.97269624573379	97	2	99.3	0	1	291	461	557	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1164	187	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
31192282	31192282	PRJNA874604_P_NODE_67695_length_252_cov_1.720670_g67343_i0	PRJNA874604	67695	252	1.72067	4.3360884	Deinococcales bacterium	2478479	Bacteria	Bacteria	67	1e-10	NR	MFN3267616.1	2478479	g67343	i0	57.4	0.55952380952381	47	20	56	0	250	110	310	356	MFN3267616.1 serine hydrolase domain-containing protein [Deinococcales bacterium]	diamond	141	67	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			Deinococcales bacterium
31224094	31224094	PRJNA874604_P_NODE_91475_length_244_cov_0.900585_g91123_i0	PRJNA874604	91475	244	0.900585	2.1974274	Deinococcus sp. YIM 134	47478	Bacteria	Bacteria	137	3.2299999999999997e-37	NR	WP_331823149.1	3118910	g91123	i0	88.9	0.995901639344262	81	9	99.6	0	244	2	234	314	WP_331823149.1 M20/M25/M40 family metallo-hydrolase [Deinococcus sp. YIM 134068]	diamond	243	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus lichenicola
31793385	31793385	PRJNA874604_P_NODE_83977_length_246_cov_0.890173_g83625_i0	PRJNA874604	83977	246	0.890173	2.18982558	Deinococcota bacterium	1913990	Bacteria	Bacteria	91.7	1.48e-19	NR	MDQ3398686.1	1913990	g83625	i0	62	0.865853658536585	71	27	86.6	0	2	214	186	256	MDQ3398686.1 hypothetical protein [Deinococcota bacterium]	diamond	213	91.7	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
32110003	32110003	PRJNA874604_P_NODE_81658_length_247_cov_0.885057_g81306_i0	PRJNA874604	81658	247	0.885057	2.18609079	Deinococcus navajonensis	309884	Bacteria	Bacteria	106	1.66e-24	NR	WP_380041348.1	309884	g81306	i0	65.9	0.995951417004049	82	26	97.2	1	242	3	416	497	WP_380041348.1 M14 family zinc carboxypeptidase [Deinococcus navajonensis]	diamond	246	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus navajonensis
32616011	32616011	PRJNA874604_P_NODE_55040_length_275_cov_1.252475_g54688_i0	PRJNA874604	55040	275	1.252475	3.44430625	Synergistales bacterium	2268201	Bacteria	Bacteria	99.4	1.5199999999999995e-23	NR	MFA0888825.1	2268201	g54688	i0	70.3	4.88727272727273	64	19	69.8	0	197	6	1	64	MFA0888825.1 NAD(P)H:quinone oxidoreductase [Synergistales bacterium]	diamond	1344	99.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
32647134	32647134	PRJNA874604_P_NODE_80520_length_247_cov_0.885057_g80168_i0	PRJNA874604	80520	247	0.885057	2.18609079	Deinococcus aestuarii	2774531	Bacteria	Bacteria	150	1.38e-42	NR	WP_246581259.1	2774531	g80168	i0	95.1	0.995951417004049	82	4	99.6	0	247	2	178	259	WP_246581259.1 bifunctional DNA primase/polymerase [Deinococcus aestuarii]	diamond	246	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii

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