metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax

13 rows where analysis = "diamond", 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
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
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
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);;