metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA376117" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA376117" 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
7451506	7451506	PRJNA376117_P_NODE_13526_length_371_cov_1.637584_g13224_i0	PRJNA376117	13526	371	1.637584	6.07543664	Deinococcus aestuarii	2774531	Bacteria	Bacteria	241	4.13e-72	NR	WP_216327841.1	2774531	g13224	i0	91.9	0.994609164420485	123	10	99.5	0	1	369	656	778	WP_216327841.1 VirB4 family type IV secretion system protein [Deinococcus aestuarii]	diamond	369	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
8053422	8053422	PRJNA376117_P_NODE_9407_length_438_cov_1.898630_g9105_i0	PRJNA376117	9407	438	1.89863	8.3159994	Bacteria	2	Bacteria	Bacteria	152	3.9e-40	NR	WP_093005720.1	482827	g9105	i0	61.3	17.9794520547945	119	46	81.5	0	81	437	4	122	WP_093005720.1 NAD-dependent malic enzyme [Thermus arciformis]	diamond	7875	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus arciformis
8726361	8726361	PRJNA376117_P_NODE_26947_length_276_cov_1.453202_g26645_i0	PRJNA376117	26947	276	1.453202	4.01083752	Deinococcus sp. S9	2545754	Bacteria	Bacteria	63.2	2.88e-10	NR	WP_133009863.1	2545754	g26645	i0	57.4	0.58695652173913	54	23	58.7	0	2	163	77	130	WP_133009863.1 helix-turn-helix domain-containing protein [Deinococcus sp. S9]	diamond	162	63.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. S9
11878581	11878581	PRJNA376117_P_NODE_27770_length_273_cov_1.315000_g27468_i0	PRJNA376117	27770	273	1.315	3.58995	Deinococcus aetherius	200252	Bacteria	Bacteria	162	1.11e-44	NR	WP_264775771.1	200252	g27468	i0	89	1	91	10	100	0	273	1	24	114	WP_264775771.1 ABC transporter ATP-binding protein [Deinococcus aetherius]	diamond	273	162	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
20801278	20801278	PRJNA376117_P_NODE_23737_length_287_cov_1.191589_g23435_i0	PRJNA376117	23737	287	1.191589	3.41986043	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	178	1.83e-49	NR	WP_353543079.1	457454	g23435	i0	97.9	0.993031358885017	95	2	99.3	0	1	285	587	681	WP_353543079.1 FHA domain-containing serine/threonine-protein kinase [Deinococcus xinjiangensis]	diamond	285	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
26821882	26821882	PRJNA376117_P_NODE_43701_length_242_cov_0.911243_g43399_i0	PRJNA376117	43701	242	0.911243	2.20520806	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	161	3.48e-44	NR	WP_353542704.1	457454	g43399	i0	100	0.991735537190083	80	0	99.2	0	242	3	489	568	WP_353542704.1 protein kinase domain-containing protein [Deinococcus xinjiangensis]	diamond	240	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
26885227	26885227	PRJNA376117_P_NODE_37001_length_248_cov_0.880000_g36699_i0	PRJNA376117	37001	248	0.88	2.1824	Deinococcus aetherius	200252	Bacteria	Bacteria	142	3.25e-42	NR	WP_264775452.1	200252	g36699	i0	91.1	0.955645161290323	79	7	95.6	0	247	11	10	88	WP_264775452.1 AbrB/MazE/SpoVT family DNA-binding domain-containing protein [Deinococcus aetherius]	diamond	237	142	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
27011542	27011542	PRJNA376117_P_NODE_36402_length_249_cov_0.875000_g36100_i0	PRJNA376117	36402	249	0.875	2.17875	Deinococcota bacterium	1913990	Bacteria	Bacteria	83.2	4.55e-18	NR	MDQ3398976.1	1913990	g36100	i0	66.7	0.686746987951807	57	19	68.7	0	1	171	90	146	MDQ3398976.1 type II toxin-antitoxin system VapC family toxin [Deinococcota bacterium]	diamond	171	83.2	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
27517279	27517279	PRJNA376117_P_NODE_40243_length_245_cov_0.895349_g39941_i0	PRJNA376117	40243	245	0.895349	2.19360505	uncultured Truepera sp.	543023	Bacteria	Bacteria	63.2	3.09e-10	NR	CAA9559048.1	543023	g39941	i0	57.7	0.636734693877551	52	21	62.4	1	154	2	36	87	CAA9559048.1 MAG: hypothetical protein AVDCRST_MAG86-453 [uncultured Truepera sp.]	diamond	156	63.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27643757	27643757	PRJNA376117_P_NODE_13644_length_370_cov_1.037037_g13342_i0	PRJNA376117	13644	370	1.037037	3.8370369	Deinococcus sp. S9	2545754	Bacteria	Bacteria	240	7.01e-74	NR	WP_133009923.1	2545754	g13342	i0	96.7	1.99459459459459	123	4	99.7	0	1	369	80	202	WP_133009923.1 type IV secretory system conjugative DNA transfer family protein [Deinococcus sp. S9]	diamond	738	240	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. S9
27770086	27770086	PRJNA376117_P_NODE_45324_length_226_cov_2.078431_g45022_i0	PRJNA376117	45324	226	2.078431	4.69725406	Deinococcus detaillensis	2592048	Bacteria	Bacteria	81.3	8.57e-18	NR	WP_143722109.1	2592048	g45022	i0	60	0.929203539823009	70	28	92.9	0	210	1	3	72	WP_143722109.1 hypothetical protein [Deinococcus detaillensis]	diamond	210	81.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus detaillensis
28955422	28955422	PRJNA376117_P_NODE_42308_length_243_cov_0.905882_g42006_i0	PRJNA376117	42308	243	0.905882	2.20129326	FCB group	1783270	Bacteria	Bacteria	166	1.45e-45	NR	MCK9435893.1	2053624	g42006	i0	97.5	1.97530864197531	80	2	98.8	0	3	242	611	690	MCK9435893.1 TonB-dependent receptor [Synergistaceae bacterium]	diamond	480	166	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28969709	28969709	PRJNA376117_P_NODE_33508_length_251_cov_2.398876_g33206_i0	PRJNA376117	33508	251	2.398876	6.02117876	Deinococcus arenicola	2994950	Bacteria	Bacteria	90.9	1.32e-21	NR	WP_317641932.1	2994950	g33206	i0	61	0.9800796812749	82	32	98	0	4	249	18	99	WP_317641932.1 helix-turn-helix domain-containing protein [Deinococcus arenicola]	diamond	246	90.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus arenicola
29064524	29064524	PRJNA376117_P_NODE_37448_length_248_cov_0.880000_g37146_i0	PRJNA376117	37448	248	0.88	2.1824	Trueperaceae bacterium	2026798	Bacteria	Bacteria	67.4	7.97e-11	NR	MFO7543893.1	2026798	g37146	i0	54.5	0.798387096774194	66	30	79.8	0	203	6	366	431	MFO7543893.1 leishmanolysin-related zinc metalloendopeptidase [Trueperaceae bacterium]	diamond	198	67.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30201032	30201032	PRJNA376117_P_NODE_24132_length_285_cov_2.533019_g23830_i0	PRJNA376117	24132	285	2.533019	7.21910415	Deinococcus fonticola	2528713	Bacteria	Bacteria	92.4	2.09e-19	NR	WP_135230113.1	2528713	g23830	i0	50	0.989473684210526	94	47	98.9	0	283	2	133	226	WP_135230113.1 nuclease A inhibitor family protein [Deinococcus fonticola]	diamond	282	92.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
30328165	30328165	PRJNA376117_P_NODE_4032_length_689_cov_2.167208_g3745_i0	PRJNA376117	4032	689	2.167208	14.93206312	Deinococcus hopiensis	309885	Bacteria	Bacteria	367	7.110000000000001e-123	NR	WP_170928889.1	309885	g3745	i0	71.6	0.997097242380261	229	65	99.7	0	689	3	130	358	WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis]	diamond	687	367	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
30345298	30345298	PRJNA376117_P_NODE_41852_length_243_cov_1.582353_g41550_i0	PRJNA376117	41852	243	1.582353	3.84511779	Bacteria	2	Bacteria	Bacteria	72	1.59e-12	NR	WP_339956470.1	275	g41550	i0	42.2	3.98765432098765	83	38	96.3	3	239	6	125	202	WP_339956470.1 ABC transporter substrate-binding protein [Thermus sp.]	diamond	969	72	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
30391305	30391305	PRJNA376117_P_NODE_12713_length_381_cov_1.292208_g12411_i0	PRJNA376117	12713	381	1.292208	4.92331248	Trueperaceae bacterium	2026798	Bacteria	Bacteria	57	1.73e-6	NR	MCA9839568.1	2026798	g12411	i0	37.5	1.95275590551181	72	42	54.3	1	381	175	266	337	MCA9839568.1 hypothetical protein [Trueperaceae bacterium]	diamond	744	57	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30738286	30738286	PRJNA376117_P_NODE_25834_length_280_cov_1.149758_g25532_i0	PRJNA376117	25834	280	1.149758	3.2193224	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	173	2.74e-51	NR	WP_353542535.1	457454	g25532	i0	98.9	0.996428571428571	93	1	99.6	0	280	2	124	216	WP_353542535.1 low temperature requirement protein A [Deinococcus xinjiangensis]	diamond	279	173	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
31022804	31022804	PRJNA376117_P_NODE_30515_length_263_cov_1.273684_g30213_i0	PRJNA376117	30515	263	1.273684	3.34978892	uncultured Truepera sp.	543023	Bacteria	Bacteria	103	1.3299999999999995e-23	NR	CAA9559356.1	543023	g30213	i0	64.4	0.992395437262357	87	27	99.2	1	3	263	370	452	CAA9559356.1 MAG: Allophanate hydrolase 2 subunit 1 / Allophanate hydrolase 2 subunit 2 [uncultured Truepera sp.]	diamond	261	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
31134316	31134316	PRJNA376117_P_NODE_30355_length_263_cov_2.726316_g30053_i0	PRJNA376117	30355	263	2.726316	7.17021108	Deinococcus	1298	Bacteria	Bacteria	153	3.08e-42	NR	WP_170928889.1	309885	g30053	i0	78.2	2.97718631178707	87	19	99.2	0	262	2	363	449	WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis]	diamond	783	153	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
31180384	31180384	PRJNA376117_P_NODE_25055_length_282_cov_1.473684_g24753_i0	PRJNA376117	25055	282	1.473684	4.15578888	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	107	2.07e-25	NR	WP_353542231.1	457454	g24753	i0	100	0.595744680851064	56	0	59.6	0	1	168	286	341	WP_353542231.1 FecCD family ABC transporter permease [Deinococcus xinjiangensis]	diamond	168	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
31275537	31275537	PRJNA376117_P_NODE_27255_length_275_cov_1.222772_g26953_i0	PRJNA376117	27255	275	1.222772	3.362623	Deinococcus kurensis	2662757	Bacteria	Bacteria	57.8	1.48e-7	NR	WP_155300557.1	2662757	g26953	i0	41.9	1.62545454545455	74	40	80.7	2	228	7	134	204	WP_155300557.1 hypothetical protein [Deinococcus kurensis]	diamond	447	57.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus kurensis
31781488	31781488	PRJNA376117_P_NODE_25457_length_281_cov_1.360577_g25155_i0	PRJNA376117	25457	281	1.360577	3.82322137	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	52	3.14e-5	NR	WP_353540823.1	457454	g25155	i0	100	0.245551601423488	23	0	24.6	0	211	279	1	23	WP_353540823.1 thymidine phosphorylase [Deinococcus xinjiangensis]	diamond	69	52	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
32051855	32051855	PRJNA376117_P_NODE_15938_length_344_cov_2.000000_g15636_i0	PRJNA376117	15938	344	2	6.88	Deinococcus	1298	Bacteria	Bacteria	153	3.3399999999999997e-45	NR	WP_407542841.1	468916	g15636	i0	77.9	3.31395348837209	95	21	82.8	0	342	58	14	108	WP_407542841.1 IS1595 family transposase [Deinococcus radiomollis]	diamond	1140	154	0.993506493506494	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
32351358	32351358	PRJNA376117_P_NODE_28159_length_271_cov_1.974747_g27857_i0	PRJNA376117	28159	271	1.974747	5.35156437	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	112	1.08e-26	NR	WP_353541661.1	457454	g27857	i0	98.1	0.586715867158672	53	1	58.7	0	159	1	124	176	WP_353541661.1 protein phosphatase 2C domain-containing protein [Deinococcus xinjiangensis]	diamond	159	112	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);;