metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA694770" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA694770" 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
6285108	6285108	PRJNA694770_P_NODE_75185_length_255_cov_1.692308_g74891_i0	PRJNA694770	75185	255	1.692308	4.3153854	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	168	6.54e-50	NR	WP_092264041.1	856736	g74891	i0	100	0.988235294117647	84	0	98.8	0	254	3	145	228	WP_092264041.1 CBS domain-containing protein [Deinococcus reticulitermitis]	diamond	252	168	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
7053631	7053631	PRJNA694770_P_NODE_62366_length_276_cov_1.433498_g62072_i0	PRJNA694770	62366	276	1.433498	3.95645448	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	182	4.489999999999999e-54	NR	WP_386843709.1	536443	g62072	i0	98.9	0.967391304347826	89	1	96.7	0	276	10	189	277	WP_386843709.1 exo-beta-N-acetylmuramidase NamZ domain-containing protein [Deinococcus taklimakanensis]	diamond	267	182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
12154905	12154905	PRJNA694770_P_NODE_88710_length_246_cov_1.046243_g88416_i0	PRJNA694770	88710	246	1.046243	2.57375778	Deinococcus	1298	Bacteria	Bacteria	117	2.4799999999999996e-29	NR	WP_191299638.1	223556	g88416	i0	81.3	2.92682926829268	80	13	97.6	1	242	3	256	333	WP_191299638.1 hypothetical protein [Deinococcus indicus]	diamond	720	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus indicus
22351518	22351518	PRJNA694770_P_NODE_32018_length_355_cov_1.092199_g31724_i0	PRJNA694770	32018	355	1.092199	3.87730645	Deinococcus grandis	57498	Bacteria	Bacteria	169	1.4199999999999998e-46	NR	WP_153013617.1	57498	g31724	i0	75.4	1.9943661971831	118	27	99.7	2	354	1	80	195	WP_153013617.1 AAA family ATPase [Deinococcus grandis]	diamond	708	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
22352152	22352152	PRJNA694770_P_NODE_56138_length_285_cov_1.452830_g55844_i0	PRJNA694770	56138	285	1.45283	4.1405655	Deinococcus ficus	317577	Bacteria	Bacteria	155	5e-46	NR	WP_022802548.1	317577	g55844	i0	72.3	0.989473684210526	94	26	98.9	0	2	283	32	125	WP_022802548.1 DUF3105 domain-containing protein [Deinococcus ficus]	diamond	282	155	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
27430511	27430511	PRJNA694770_P_NODE_86943_length_247_cov_0.885057_g86649_i0	PRJNA694770	86943	247	0.885057	2.18609079	uncultured Truepera sp.	543023	Bacteria	Bacteria	68.2	4.29e-11	NR	CAA9572486.1	543023	g86649	i0	91.2	0.412955465587045	34	3	41.3	0	247	146	491	524	CAA9572486.1 MAG: Acetyl-coenzyme A carboxyl transferase alpha chain / Acetyl-coenzyme A carboxyl transferase beta chain; Propionyl-CoA carboxylase beta chain [uncultured Truepera sp.]	diamond	102	68.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27524980	27524980	PRJNA694770_P_NODE_85103_length_248_cov_0.880000_g84809_i0	PRJNA694770	85103	248	0.88	2.1824	Deinococcus sp. 6GRE	47478	Bacteria	Bacteria	132	1.6200000000000002e-33	NR	WP_230295512.1	2745873	g84809	i0	79.3	0.991935483870968	82	17	99.2	0	2	247	1463	1544	WP_230295512.1 DEAD/DEAH box helicase [Deinococcus sp. 6GRE01]	diamond	246	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. 6GRE01
27788965	27788965	PRJNA694770_P_NODE_96784_length_242_cov_1.615385_g96490_i0	PRJNA694770	96784	242	1.615385	3.9092317	Deinococcus	1298	Bacteria	Bacteria	137	2.38e-38	NR	WP_189643747.1	394230	g96490	i0	87.5	2.97520661157025	80	10	99.2	0	2	241	130	209	WP_189643747.1 ParA family protein [Deinococcus piscis]	diamond	720	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
28093311	28093311	PRJNA694770_P_NODE_99405_length_241_cov_0.916667_g99111_i0	PRJNA694770	99405	241	0.916667	2.20916747	Deinococcus aquatilis	519440	Bacteria	Bacteria	86.3	1.43e-18	NR	WP_157452060.1	519440	g99111	i0	62.7	0.83402489626556	67	25	83.4	0	1	201	158	224	WP_157452060.1 hypothetical protein [Deinococcus aquatilis]	diamond	201	86.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquatilis
29135512	29135512	PRJNA694770_P_NODE_93469_length_244_cov_0.900585_g93175_i0	PRJNA694770	93469	244	0.900585	2.1974274	Deinococcus aerius	200253	Bacteria	Bacteria	50.4	5.46e-5	NR	WP_103128064.1	200253	g93175	i0	70	0.368852459016393	30	9	36.9	0	242	153	215	244	WP_103128064.1 PRTRC system ThiF family protein [Deinococcus aerius]	diamond	90	50.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aerius
29198554	29198554	PRJNA694770_P_NODE_56889_length_284_cov_1.459716_g56595_i0	PRJNA694770	56889	284	1.459716	4.14559344	Deinococcus indicus	223556	Bacteria	Bacteria	85.9	1.41e-18	NR	WP_088249198.1	223556	g56595	i0	44.8	1.01408450704225	96	49	97.2	1	2	277	31	126	WP_088249198.1 hypothetical protein [Deinococcus indicus]	diamond	288	85.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus indicus
29482323	29482323	PRJNA694770_P_NODE_70590_length_263_cov_1.421053_g70296_i0	PRJNA694770	70590	263	1.421053	3.73736939	Deinococcus multiflagellatus	1656887	Bacteria	Bacteria	97.8	1.76e-21	NR	WP_224609744.1	1656887	g70296	i0	54.5	0.878326996197719	77	35	87.8	0	33	263	2	78	WP_224609744.1 GspE/PulE family protein [Deinococcus multiflagellatus]	diamond	231	97.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus multiflagellatus
30430560	30430560	PRJNA694770_P_NODE_94533_length_243_cov_1.811765_g94239_i0	PRJNA694770	94533	243	1.811765	4.40258895	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	158	4.31e-45	NR	WP_299302745.1	1678694	g94239	i0	100	0.987654320987654	80	0	98.8	0	3	242	66	145	WP_299302745.1 ABC transporter substrate-binding protein [uncultured Fretibacterium sp.]	diamond	240	158	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
30588005	30588005	PRJNA694770_P_NODE_87713_length_247_cov_0.885057_g87419_i0	PRJNA694770	87713	247	0.885057	2.18609079	Deinococcus enclensis	1049582	Bacteria	Bacteria	93.2	8.310000000000001e-21	NR	WP_307467552.1	1049582	g87419	i0	57.1	1.02024291497976	84	34	99.6	1	246	1	44	127	WP_307467552.1 hypothetical protein [Deinococcus enclensis]	diamond	252	93.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus enclensis
30852141	30852141	PRJNA694770_P_NODE_80514_length_250_cov_0.870056_g80220_i0	PRJNA694770	80514	250	0.870056	2.17514	Fretibacterium	1434006	Bacteria	Bacteria	170	5.259999999999999e-47	NR	WP_299078920.1	1678694	g80220	i0	98.8	2.988	83	1	99.6	0	250	2	28	110	WP_299078920.1 flagellar hook-associated protein FlgK [uncultured Fretibacterium sp.]	diamond	747	170	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
30872471	30872471	PRJNA694770_P_NODE_96334_length_243_cov_0.905882_g96040_i0	PRJNA694770	96334	243	0.905882	2.20129326	Synergistaceae bacterium	2053624	Bacteria	Bacteria	62.4	2.37e-10	NR	NLD95480.1	2053624	g96040	i0	74.3	0.851851851851852	35	9	43.2	0	105	1	57	91	NLD95480.1 hypothetical protein [Synergistaceae bacterium]	diamond	207	62.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31674052	31674052	PRJNA694770_P_NODE_92977_length_244_cov_0.900585_g92683_i0	PRJNA694770	92977	244	0.900585	2.1974274	Thermus	270	Bacteria	Bacteria	44.7	0.00786	NR	WP_235283688.1	1577051	g92683	i0	46.5	1.58606557377049	43	23	52.9	0	166	38	255	297	WP_235283688.1 sensor histidine kinase [Thermus sp. 2.9]	diamond	387	44.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. 2.9
32137470	32137470	PRJNA694770_P_NODE_88898_length_246_cov_0.890173_g88604_i0	PRJNA694770	88898	246	0.890173	2.18982558	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	169	5.59e-49	NR	WP_177183286.1	856736	g88604	i0	100	0.98780487804878	81	0	98.8	0	3	245	174	254	WP_177183286.1 LCP family protein [Deinococcus reticulitermitis]	diamond	243	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
32200768	32200768	PRJNA694770_P_NODE_81598_length_250_cov_0.870056_g81304_i0	PRJNA694770	81598	250	0.870056	2.17514	Deinococcus malanensis	1706855	Bacteria	Bacteria	89.4	1.31e-18	NR	WP_189006506.1	1706855	g81304	i0	81.8	0.66	55	10	66	0	166	2	1	55	WP_189006506.1 dipeptidase [Deinococcus malanensis]	diamond	165	89.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus malanensis
32800557	32800557	PRJNA694770_P_NODE_47580_length_304_cov_1.000000_g47286_i0	PRJNA694770	47580	304	1	3.04	Deinococcus murrayi	68910	Bacteria	Bacteria	49.7	2.49e-4	NR	WP_027459255.1	68910	g47286	i0	59.1	0.434210526315789	44	18	43.4	0	173	304	249	292	WP_027459255.1 hypothetical protein [Deinococcus murrayi]	diamond	132	49.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus murrayi

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