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

12 rows where analysis = "diamond", bioproject = "PRJNA874604" 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
6342243	6342243	PRJNA874604_P_NODE_82265_length_247_cov_0.885057_g81913_i0	PRJNA874604	82265	247	0.885057	2.18609079	Trueperaceae bacterium	2026798	Bacteria	Bacteria	117	5.35e-30	NR	HEX7004586.1	2026798	g81913	i0	68.3	3.78947368421053	82	26	99.6	0	1	246	15	96	HEX7004586.1 isocitrate lyase/phosphoenolpyruvate mutase family protein [Trueperaceae bacterium]	diamond	936	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
26683318	26683318	PRJNA874604_P_NODE_38061_length_315_cov_1.272727_g37709_i0	PRJNA874604	38061	315	1.272727	4.00909005	Bacteria	2	Bacteria	Bacteria	214	8.77e-63	NR	1TAQ_A	271	g37709	i0	100	3.96190476190476	104	0	99	0	313	2	92	195	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1248	214	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27947749	27947749	PRJNA874604_P_NODE_77585_length_248_cov_0.880000_g77233_i0	PRJNA874604	77585	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	89.7	5.8e-20	NR	WP_309570986.1	47478	g77233	i0	55.4	5.02016129032258	83	36	99.2	1	248	3	9	91	WP_309570986.1 hypothetical protein [Deinococcus sp.]	diamond	1245	90.1	0.995560488346282	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
29147887	29147887	PRJNA874604_P_NODE_99229_length_241_cov_0.916667_g98877_i0	PRJNA874604	99229	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	126	1.54e-31	NR	1TAQ_A	271	g98877	i0	100	2.37759336099585	64	0	79.7	0	240	49	769	832	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	573	126	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
29770788	29770788	PRJNA874604_P_NODE_83131_length_246_cov_1.618497_g82779_i0	PRJNA874604	83131	246	1.618497	3.98150262	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	147	1.78e-40	NR	WP_386842286.1	536443	g82779	i0	97.5	0.98780487804878	81	2	98.8	0	3	245	190	270	WP_386842286.1 glutamate ligase domain-containing protein [Deinococcus taklimakanensis]	diamond	243	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30348143	30348143	PRJNA874604_P_NODE_45672_length_293_cov_1.400000_g45320_i0	PRJNA874604	45672	293	1.4	4.102	root	1	Root_unresolved	Root_unresolved	187	5.03e-53	NR	1TAQ_A	271	g45320	i0	97.9	3.97269624573379	97	2	99.3	0	1	291	461	557	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1164	187	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
31192282	31192282	PRJNA874604_P_NODE_67695_length_252_cov_1.720670_g67343_i0	PRJNA874604	67695	252	1.72067	4.3360884	Deinococcales bacterium	2478479	Bacteria	Bacteria	67	1e-10	NR	MFN3267616.1	2478479	g67343	i0	57.4	0.55952380952381	47	20	56	0	250	110	310	356	MFN3267616.1 serine hydrolase domain-containing protein [Deinococcales bacterium]	diamond	141	67	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			Deinococcales bacterium
31224094	31224094	PRJNA874604_P_NODE_91475_length_244_cov_0.900585_g91123_i0	PRJNA874604	91475	244	0.900585	2.1974274	Deinococcus sp. YIM 134	47478	Bacteria	Bacteria	137	3.2299999999999997e-37	NR	WP_331823149.1	3118910	g91123	i0	88.9	0.995901639344262	81	9	99.6	0	244	2	234	314	WP_331823149.1 M20/M25/M40 family metallo-hydrolase [Deinococcus sp. YIM 134068]	diamond	243	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus lichenicola
31793385	31793385	PRJNA874604_P_NODE_83977_length_246_cov_0.890173_g83625_i0	PRJNA874604	83977	246	0.890173	2.18982558	Deinococcota bacterium	1913990	Bacteria	Bacteria	91.7	1.48e-19	NR	MDQ3398686.1	1913990	g83625	i0	62	0.865853658536585	71	27	86.6	0	2	214	186	256	MDQ3398686.1 hypothetical protein [Deinococcota bacterium]	diamond	213	91.7	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
32110003	32110003	PRJNA874604_P_NODE_81658_length_247_cov_0.885057_g81306_i0	PRJNA874604	81658	247	0.885057	2.18609079	Deinococcus navajonensis	309884	Bacteria	Bacteria	106	1.66e-24	NR	WP_380041348.1	309884	g81306	i0	65.9	0.995951417004049	82	26	97.2	1	242	3	416	497	WP_380041348.1 M14 family zinc carboxypeptidase [Deinococcus navajonensis]	diamond	246	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus navajonensis
32616011	32616011	PRJNA874604_P_NODE_55040_length_275_cov_1.252475_g54688_i0	PRJNA874604	55040	275	1.252475	3.44430625	Synergistales bacterium	2268201	Bacteria	Bacteria	99.4	1.5199999999999995e-23	NR	MFA0888825.1	2268201	g54688	i0	70.3	4.88727272727273	64	19	69.8	0	197	6	1	64	MFA0888825.1 NAD(P)H:quinone oxidoreductase [Synergistales bacterium]	diamond	1344	99.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
32647134	32647134	PRJNA874604_P_NODE_80520_length_247_cov_0.885057_g80168_i0	PRJNA874604	80520	247	0.885057	2.18609079	Deinococcus aestuarii	2774531	Bacteria	Bacteria	150	1.38e-42	NR	WP_246581259.1	2774531	g80168	i0	95.1	0.995951417004049	82	4	99.6	0	247	2	178	259	WP_246581259.1 bifunctional DNA primase/polymerase [Deinococcus aestuarii]	diamond	246	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii

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