metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA782235" 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
3314575	3314575	PRJNA782235_P_NODE_17963_length_250_cov_0.870056_g17774_i0	PRJNA782235	17963	250	0.870056	2.17514	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	159	3.1099999999999993e-43	NR	WP_386846772.1	536443	g17774	i0	98.7	0.948	79	1	94.8	0	237	1	141	219	WP_386846772.1 malto-oligosyltrehalose synthase [Deinococcus taklimakanensis]	diamond	237	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
20338748	20338748	PRJNA782235_P_NODE_17516_length_250_cov_0.870056_g17327_i0	PRJNA782235	17516	250	0.870056	2.17514	Deinococcus antarcticus	1298767	Bacteria	Bacteria	152	8.86e-45	NR	WP_380077394.1	1298767	g17327	i0	94	0.996	83	5	99.6	0	2	250	65	147	WP_380077394.1 NADH-quinone oxidoreductase subunit J [Deinococcus antarcticus]	diamond	249	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
27211430	27211430	PRJNA782235_P_NODE_28702_length_233_cov_2.787500_g28513_i0	PRJNA782235	28702	233	2.7875	6.494875	Deinococcus budaensis	1665626	Bacteria	Bacteria	125	2.2299999999999996e-31	NR	WP_221269927.1	1665626	g28513	i0	85.7	0.991416309012876	77	11	99.1	0	3	233	328	404	WP_221269927.1 hypothetical protein [Deinococcus budaensis]	diamond	231	125	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
29138101	29138101	PRJNA782235_P_NODE_17429_length_250_cov_0.870056_g17240_i0	PRJNA782235	17429	250	0.870056	2.17514	Deinococcus sp. Marseille-Q64	47478	Bacteria	Bacteria	140	3.77e-38	NR	WP_261663318.1	2969223	g17240	i0	88	1.992	83	10	99.6	0	1	249	40	122	WP_261663318.1 phosphate acyltransferase PlsX [Deinococcus sp. Marseille-Q6407]	diamond	498	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Marseille-Q6407
29895740	29895740	PRJNA782235_P_NODE_12391_length_274_cov_1.412935_g12202_i0	PRJNA782235	12391	274	1.412935	3.8714419	Deinococcus terrestris	2651870	Bacteria	Bacteria	82	3.39e-17	NR	WP_152872230.1	2651870	g12202	i0	74.5	0.602189781021898	55	14	60.2	0	165	1	1	55	WP_152872230.1 HD-GYP domain-containing protein [Deinococcus terrestris]	diamond	165	82	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus terrestris
29958805	29958805	PRJNA782235_P_NODE_20911_length_247_cov_0.885057_g20722_i0	PRJNA782235	20911	247	0.885057	2.18609079	uncultured Truepera sp.	543023	Bacteria	Bacteria	77.4	2.46e-14	NR	CAA9552986.1	543023	g20722	i0	62.3	0.838056680161943	69	24	81.4	1	47	247	5	73	CAA9552986.1 MAG: hypothetical protein AVDCRST_MAG86-178 [uncultured Truepera sp.]	diamond	207	77.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
30275051	30275051	PRJNA782235_P_NODE_17272_length_250_cov_1.548023_g17083_i0	PRJNA782235	17272	250	1.548023	3.8700575	Deinococcus metallilatus	1211322	Bacteria	Bacteria	42	0.0381	NR	WP_129118752.1	1211322	g17083	i0	44.4	0.648	54	30	64.8	0	191	30	1	54	WP_129118752.1 hypothetical protein [Deinococcus metallilatus]	diamond	162	42	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
31127466	31127466	PRJNA782235_P_NODE_20835_length_247_cov_0.885057_g20646_i0	PRJNA782235	20835	247	0.885057	2.18609079	Deinococcus hohokamensis	309883	Bacteria	Bacteria	95.9	3.24e-21	NR	WP_380063275.1	309883	g20646	i0	67.2	2.42914979757085	64	19	75.3	1	247	62	305	368	WP_380063275.1 Gfo/Idh/MocA family protein [Deinococcus hohokamensis]	diamond	600	95.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hohokamensis
31981703	31981703	PRJNA782235_P_NODE_22778_length_246_cov_0.890173_g22589_i0	PRJNA782235	22778	246	0.890173	2.18982558	Deinococcus	1298	Bacteria	Bacteria	77.8	1.74e-14	NR	WP_322475013.1	1298	g22589	i0	51.5	0.804878048780488	66	32	80.5	0	206	9	409	474	WP_322475013.1 MULTISPECIES: phage/plasmid primase, P4 family [Deinococcus]	diamond	198	77.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
32086025	32086025	PRJNA782235_P_NODE_23918_length_245_cov_0.895349_g23729_i0	PRJNA782235	23918	245	0.895349	2.19360505	Deinococcus	1298	Bacteria	Bacteria	88.2	5.480000000000001e-21	NR	WP_188974292.1	522487	g23729	i0	97.6	1.02857142857143	42	1	51.4	0	126	1	1	42	WP_188974292.1 transposase, partial [Deinococcus aerolatus]	diamond	252	88.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aerolatus
32171851	32171851	PRJNA782235_P_NODE_16278_length_251_cov_0.865169_g16089_i0	PRJNA782235	16278	251	0.865169	2.17157419	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	159	4.1999999999999995e-44	NR	WP_092264938.1	856736	g16089	i0	100	0.99203187250996006	83	0	99.2	0	3	251	308	390	WP_092264938.1 tetratricopeptide repeat-containing diguanylate cyclase [Deinococcus reticulitermitis]	diamond	249	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
32361760	32361760	PRJNA782235_P_NODE_12459_length_273_cov_2.870000_g12270_i0	PRJNA782235	12459	273	2.87	7.8351	uncultured Truepera sp.	543023	Bacteria	Bacteria	139	5.8899999999999994e-37	NR	CAA9562295.1	543023	g12270	i0	80.9	0.978021978021978	89	17	97.8	0	6	272	12	100	CAA9562295.1 MAG: Inner membrane ABC transporter permease protein YcjO [uncultured Truepera sp.]	diamond	267	139	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.

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