metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA1020854" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA1020854" and tax_phylum = "Deinococcota"

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
6539094	6539094	PRJNA1020854_S_NODE_22966_length_225_cov_2.489796_g20202_i0	PRJNA1020854	22966	225	2.489796	5.602041	Thermus amyloliquefaciens	1449080	Bacteria	Bacteria	86.7	1.76e-18	NR	WP_185747759.1	1449080	g20202	i0	95.2	1.68	42	2	56	0	225	100	33	74	WP_185747759.1 hypothetical protein [Thermus amyloliquefaciens]	diamond	378	86.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus amyloliquefaciens
7813422	7813422	PRJNA1020854_S_NODE_20567_length_242_cov_3.845070_g17803_i0	PRJNA1020854	20567	242	3.84507	9.3050694	Thermus sp.	275	Bacteria	Bacteria	84.3	4.42e-18	NR	MEN2982676.1	275	g17803	i0	95	0.495867768595041	40	2	49.6	0	111	230	1	40	MEN2982676.1 TraX family protein [Thermus sp.]	diamond	120	84.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
12915050	12915050	PRJNA1020854_S_NODE_7531_length_547_cov_6.007722_g4909_i0	PRJNA1020854	7531	547	6.007722	32.86223934	Thermus sp.	275	Bacteria	Bacteria	178	2.12e-51	NR	MDM7324599.1	275	g4909	i0	57.4	0.888482632541133	162	63	87.2	3	2	478	109	267	MDM7324599.1 hypothetical protein [Thermus sp.]	diamond	486	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
15463497	15463497	PRJNA1020854_S_NODE_17493_length_270_cov_2200.991701_g14729_i0	PRJNA1020854	17493	270	2200.991701	5942.6775927	Thermus sp.	275	Bacteria	Bacteria	101	6.209999999999999e-23	NR	MEN2982701.1	275	g14729	i0	88.7	0.588888888888889	53	6	58.9	0	59	217	349	401	MEN2982701.1 hypothetical protein [Thermus sp.]	diamond	159	101	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
16737710	16737710	PRJNA1020854_S_NODE_17214_length_273_cov_2477.319672_g14450_i0	PRJNA1020854	17214	273	2477.319672	6763.08270456	Thermus sp.	275	Bacteria	Bacteria	127	1.87e-33	NR	MEN2982679.1	275	g14450	i0	97.1	0.758241758241758	69	1	75.8	1	48	254	210	277	MEN2982679.1 winged helix-turn-helix domain-containing protein [Thermus sp.]	diamond	207	127	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
17581292	17581292	PRJNA1020854_S_NODE_7594_length_542_cov_3455.130604_g4968_i0	PRJNA1020854	7594	542	3455.130604	18726.80787368	Thermus sp.	275	Bacteria	Bacteria	178	2.0599999999999998e-54	NR	MEN2982697.1	275	g4968	i0	98.9	0.498154981549816	90	1	49.8	0	353	84	1	90	MEN2982697.1 hypothetical protein [Thermus sp.]	diamond	270	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
19286289	19286289	PRJNA1020854_S_NODE_11076_length_381_cov_1482.818182_g8324_i0	PRJNA1020854	11076	381	1482.818182	5649.53727342	Thermus sp.	275	Bacteria	Bacteria	79	2.86e-14	NR	MEN2982686.1	275	g8324	i0	57.3	0.590551181102362	75	32	59.1	0	283	59	228	302	MEN2982686.1 hypothetical protein [Thermus sp.]	diamond	225	79	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
19286479	19286479	PRJNA1020854_S_NODE_19196_length_253_cov_2315.857143_g16432_i0	PRJNA1020854	19196	253	2315.857143	5859.11857179	Thermus scotoductus	37636	Bacteria	Bacteria	119	1.18e-30	NR	RTH02997.1	37636	g16432	i0	93.8	1.54150197628458	65	4	77.1	0	244	50	219	283	RTH02997.1 glycosyl transferase family 1 [Thermus scotoductus]	diamond	390	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
26591421	26591421	PRJNA1020854_S_NODE_11821_length_362_cov_7.450450_g9060_i0	PRJNA1020854	11821	362	7.45045	26.970629	Thermus	270	Bacteria	Bacteria	52	6.24e-6	NR	WP_114312268.1	270	g9060	i0	47.9	0.397790055248619	48	25	39.8	0	297	154	42	89	WP_114312268.1 MULTISPECIES: hypothetical protein [Thermus]	diamond	144	52	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
26781802	26781802	PRJNA1020854_S_NODE_39341_length_159_cov_3.023077_g36577_i0	PRJNA1020854	39341	159	3.023077	4.80669243	Thermus sp. 2.9	1577051	Bacteria	Bacteria	57	1.08e-7	NR	WP_152607374.1	1577051	g36577	i0	54.3	0.867924528301887	46	19	86.8	1	157	20	132	175	WP_152607374.1 hypothetical protein [Thermus sp. 2.9]	diamond	138	57	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. 2.9
27603822	27603822	PRJNA1020854_S_NODE_38764_length_160_cov_7.099237_g36000_i0	PRJNA1020854	38764	160	7.099237	11.3587792	Thermus	270	Bacteria	Bacteria	50.1	1.89e-5	NR	WP_019551678.1	270	g36000	i0	57.8	1.74375	45	14	84.4	1	3	137	120	159	WP_019551678.1 MULTISPECIES: hypothetical protein [Thermus]	diamond	279	50.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
27635296	27635296	PRJNA1020854_S_NODE_25644_length_209_cov_2.750000_g22880_i0	PRJNA1020854	25644	209	2.75	5.7475	Thermus tengchongensis	1214928	Bacteria	Bacteria	131	1.87e-36	NR	WP_135260722.1	1214928	g22880	i0	95.4	0.933014354066986	65	3	93.3	0	2	196	123	187	WP_135260722.1 hypothetical protein [Thermus tengchongensis]	diamond	195	131	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus tengchongensis
27698674	27698674	PRJNA1020854_S_NODE_29884_length_189_cov_3.081250_g27120_i0	PRJNA1020854	29884	189	3.08125	5.8235625	Thermus sp.	275	Bacteria	Bacteria	122	3.1699999999999993e-34	NR	MEN2982182.1	275	g27120	i0	96.8	0.984126984126984	62	2	98.4	0	187	2	36	97	MEN2982182.1 hypothetical protein [Thermus sp.]	diamond	186	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
27824783	27824783	PRJNA1020854_S_NODE_36064_length_168_cov_2.446043_g33300_i0	PRJNA1020854	36064	168	2.446043	4.10935224	Meiothermus sp. Pnk-1	873128	Bacteria	Bacteria	109	2.95e-26	NR	WP_110526061.1	873128	g33300	i0	96.4	0.982142857142857	55	2	98.2	0	2	166	487	541	WP_110526061.1 phage tail sheath subtilisin-like domain-containing protein [Meiothermus sp. Pnk-1]	diamond	165	109	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp. Pnk-1
28203276	28203276	PRJNA1020854_S_NODE_28266_length_196_cov_3.305389_g25502_i0	PRJNA1020854	28266	196	3.305389	6.47856244	Thermus scotoductus	37636	Bacteria	Bacteria	114	9.83e-29	NR	WP_019551594.1	37636	g25502	i0	94.4	4.91326530612245	54	3	82.7	0	3	164	20	73	WP_019551594.1 alcohol dehydrogenase AdhP [Thermus scotoductus]	diamond	963	114	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
28740289	28740289	PRJNA1020854_S_NODE_30687_length_186_cov_2.866242_g27923_i0	PRJNA1020854	30687	186	2.866242	5.33121012	Meiothermus sp. Pnk-1	873128	Bacteria	Bacteria	63.9	5.7e-10	NR	WP_110526061.1	873128	g27923	i0	73.9	0.741935483870968	46	11	74.2	1	184	47	538	582	WP_110526061.1 phage tail sheath subtilisin-like domain-containing protein [Meiothermus sp. Pnk-1]	diamond	138	63.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp. Pnk-1
28929715	28929715	PRJNA1020854_S_NODE_13028_length_336_cov_2.771987_g10264_i0	PRJNA1020854	13028	336	2.771987	9.31387632	Thermus tengchongensis	1214928	Bacteria	Bacteria	211	4.16e-67	NR	WP_135260722.1	1214928	g10264	i0	95.3	0.955357142857143	107	5	95.5	0	3	323	28	134	WP_135260722.1 hypothetical protein [Thermus tengchongensis]	diamond	321	211	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus tengchongensis
29182483	29182483	PRJNA1020854_S_NODE_31669_length_182_cov_3.973856_g28905_i0	PRJNA1020854	31669	182	3.973856	7.23241792	Thermus sp.	275	Bacteria	Bacteria	122	6.14e-33	NR	MEN2981686.1	275	g28905	i0	94.8	0.956043956043956	58	3	95.6	0	7	180	135	192	MEN2981686.1 hypothetical protein [Thermus sp.]	diamond	174	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
29403324	29403324	PRJNA1020854_S_NODE_15369_length_297_cov_296.533582_g12605_i0	PRJNA1020854	15369	297	296.533582	880.70473854	Thermus scotoductus	37636	Bacteria	Bacteria	167	3.93e-50	NR	WP_126212980.1	37636	g12605	i0	100	0.848484848484849	84	0	84.8	0	254	3	25	108	WP_126212980.1 hypothetical protein [Thermus scotoductus]	diamond	252	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
29434557	29434557	PRJNA1020854_S_NODE_10510_length_398_cov_6.065041_g7769_i0	PRJNA1020854	10510	398	6.065041	24.13886318	Thermus sp.	275	Bacteria	Bacteria	213	2.34e-66	NR	MEN2982679.1	275	g7769	i0	90.4	0.942211055276382	125	2	87.4	2	32	379	154	277	MEN2982679.1 winged helix-turn-helix domain-containing protein [Thermus sp.]	diamond	375	213	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
29655499	29655499	PRJNA1020854_S_NODE_23570_length_221_cov_3.765625_g20806_i0	PRJNA1020854	23570	221	3.765625	8.32203125	Thermus scotoductus	37636	Bacteria	Bacteria	74.3	1.41e-13	NR	WP_019551594.1	37636	g20806	i0	94.6	0.502262443438914	37	2	50.2	0	109	219	1	37	WP_019551594.1 alcohol dehydrogenase AdhP [Thermus scotoductus]	diamond	111	74.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
29813675	29813675	PRJNA1020854_S_NODE_34811_length_171_cov_11.063380_g32047_i0	PRJNA1020854	34811	171	11.06338	18.9183798	Thermus thermophilus	274	Bacteria	Bacteria	75.9	2.72e-14	NR	WP_203971776.1	274	g32047	i0	75	0.842105263157895	48	12	84.2	0	169	26	165	212	WP_203971776.1 O-antigen ligase family protein [Thermus thermophilus]	diamond	144	75.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
30256410	30256410	PRJNA1020854_S_NODE_16232_length_286_cov_4.661479_g13468_i0	PRJNA1020854	16232	286	4.661479	13.33182994	Thermus thermophilus	274	Bacteria	Bacteria	65.9	4.06e-10	NR	WP_244348009.1	274	g13468	i0	72.1	0.451048951048951	43	12	45.1	0	7	135	136	178	WP_244348009.1 hypothetical protein [Thermus thermophilus]	diamond	129	65.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
30508847	30508847	PRJNA1020854_S_NODE_39713_length_158_cov_3.348837_g36949_i0	PRJNA1020854	39713	158	3.348837	5.29116246	Thermus sp.	275	Bacteria	Bacteria	82	1.3e-18	NR	WP_297716014.1	275	g36949	i0	95.7	0.873417721518987	46	2	87.3	0	139	2	54	99	WP_297716014.1 hypothetical protein [Thermus sp.]	diamond	138	82	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
31678250	31678250	PRJNA1020854_S_NODE_39197_length_159_cov_5.053846_g36433_i0	PRJNA1020854	39197	159	5.053846	8.03561514	Thermus thermophilus	274	Bacteria	Bacteria	45.8	7.54e-4	NR	BCP97561.1	274	g36433	i0	62.1	1.09433962264151	29	11	54.7	0	157	71	163	191	BCP97561.1 hypothetical protein TthHB5002_06640 [Thermus thermophilus]	diamond	174	45.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
32152940	32152940	PRJNA1020854_S_NODE_13858_length_321_cov_3.869863_g11094_i0	PRJNA1020854	13858	321	3.869863	12.42226023	Meiothermus sp. Pnk-1	873128	Bacteria	Bacteria	112	1.84e-28	NR	WP_110526069.1	873128	g11094	i0	94.5	0.514018691588785	55	3	51.4	0	321	157	137	191	WP_110526069.1 hypothetical protein [Meiothermus sp. Pnk-1]	diamond	165	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp. Pnk-1
32879066	32879066	PRJNA1020854_S_NODE_42120_length_153_cov_1.750000_g39356_i0	PRJNA1020854	42120	153	1.75	2.6775	Thermaceae bacterium	2614257	Bacteria	Bacteria	66.6	1.72e-11	NR	MBF6594559.1	2614257	g39356	i0	59.2	0.96078431372549	49	20	96.1	0	149	3	86	134	MBF6594559.1 S24 family peptidase [Thermaceae bacterium]	diamond	147	66.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae		Thermaceae bacterium

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