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

12 rows where analysis = "diamond", bioproject = "PRJNA741997" 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
721601	721601	PRJNA741997_P_NODE_66801_length_262_cov_1.444444_g65681_i0	PRJNA741997	66801	262	1.444444	3.78444328	Deinococcus	1298	Bacteria	Bacteria	87.4	5.22e-20	NR	WP_019010841.1	519440	g65681	i0	58.3	1.88931297709924	84	34	95	1	12	260	3	86	WP_019010841.1 DUF1304 domain-containing protein [Deinococcus aquatilis]	diamond	495	87.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquatilis
21124007	21124007	PRJNA741997_P_NODE_38737_length_349_cov_0.913043_g37617_i0	PRJNA741997	38737	349	0.913043	3.18652007	root	1	Root_unresolved	Root_unresolved	138	3.69e-36	NR	WP_310582884.1	47478	g37617	i0	79.3	2.3810888252149	87	18	74.8	0	89	349	375	461	WP_310582884.1 aminopeptidase [Deinococcus sp.]	diamond	831	138	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
22398964	22398964	PRJNA741997_P_NODE_50378_length_304_cov_1.229437_g49258_i0	PRJNA741997	50378	304	1.229437	3.73748848	root	1	Root_unresolved	Root_unresolved	99	2.76e-24	NR	WP_236100038.1	47054	g49258	i0	58.1	6.49342105263158	93	39	91.8	0	282	4	13	105	WP_236100038.1 MULTISPECIES: 50S ribosomal protein L20 [Dethiosulfovibrio]	diamond	1974	100	0.99	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio
27684723	27684723	PRJNA741997_P_NODE_58604_length_281_cov_1.283654_g57484_i0	PRJNA741997	58604	281	1.283654	3.60706774	Deinococcus budaensis	1665626	Bacteria	Bacteria	43.1	0.00797	NR	WP_184028251.1	1665626	g57484	i0	34.4	0.683274021352313	64	38	64.1	2	36	215	18	81	WP_184028251.1 hypothetical protein [Deinococcus budaensis]	diamond	192	43.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
28104802	28104802	PRJNA741997_P_NODE_41425_length_337_cov_2.208333_g40305_i0	PRJNA741997	41425	337	2.208333	7.44208221	Bacteria	2	Bacteria	Bacteria	103	3.68e-25	NR	MDO4264703.1	47478	g40305	i0	50.5	5.18991097922849	101	48	89.9	1	307	5	3	101	MDO4264703.1 NAD(P)H-dependent oxidoreductase [Deinococcus sp.]	diamond	1749	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28389070	28389070	PRJNA741997_P_NODE_90526_length_233_cov_2.368750_g89406_i0	PRJNA741997	90526	233	2.36875	5.5191875	root	1	Root_unresolved	Root_unresolved	106	4.77e-25	NR	RKX49497.1	28240	g89406	i0	62.2	19.1330472103004	74	28	95.3	0	230	9	160	233	RKX49497.1 MAG: acyl-CoA synthetase, partial [Thermotoga sp.]	diamond	4458	107	0.990654205607477	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp.
29326113	29326113	PRJNA741997_P_NODE_57909_length_282_cov_2.186603_g56789_i0	PRJNA741997	57909	282	2.186603	6.16622046	Synergistaceae bacterium	2053624	Bacteria	Bacteria	69.3	4.12e-12	NR	MDR2523788.1	2053624	g56789	i0	41.5	3.88297872340426	94	40	88.3	3	251	3	23	112	MDR2523788.1 TerD family protein [Synergistaceae bacterium]	diamond	1095	69.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29578552	29578552	PRJNA741997_P_NODE_38170_length_351_cov_1.884892_g37050_i0	PRJNA741997	38170	351	1.884892	6.61597092	Deinococcus misasensis	392413	Bacteria	Bacteria	48.5	0.00122	NR	WP_034337211.1	392413	g37050	i0	37.1	0.897435897435897	105	53	82.1	4	330	43	12	112	WP_034337211.1 DUF5060 domain-containing protein [Deinococcus misasensis]	diamond	315	48.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
29778271	29778271	PRJNA741997_P_NODE_52731_length_296_cov_1.076233_g51611_i0	PRJNA741997	52731	296	1.076233	3.18564968	Bacteria	2	Bacteria	Bacteria	47.8	0.0011	NR	WP_189002764.1	392414	g51611	i0	69	0.587837837837838	29	9	29.4	0	6	92	235	263	WP_189002764.1 hypothetical protein [Deinococcus roseus]	diamond	174	47.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
30874013	30874013	PRJNA741997_P_NODE_62914_length_271_cov_1.555556_g61794_i0	PRJNA741997	62914	271	1.555556	4.21555676	Trueperaceae bacterium	2026798	Bacteria	Bacteria	42	0.0398	NR	MFO7546763.1	2026798	g61794	i0	37.1	0.774907749077491	70	39	77.5	1	35	244	64	128	MFO7546763.1 hypothetical protein [Trueperaceae bacterium]	diamond	210	42	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
32329163	32329163	PRJNA741997_P_NODE_74359_length_250_cov_0.870056_g73239_i0	PRJNA741997	74359	250	0.870056	2.17514	Synergistaceae bacterium	2053624	Bacteria	Bacteria	47.4	7.39e-5	NR	HOU32647.1	2053624	g73239	i0	41.8	0.804	67	34	80.4	3	36	236	6	67	HOU32647.1 hypothetical protein [Synergistaceae bacterium]	diamond	201	47.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32802144	32802144	PRJNA741997_P_NODE_18640_length_537_cov_1.806034_g17526_i0	PRJNA741997	18640	537	1.806034	9.69840258	Thermus brockianus	56956	Bacteria	Bacteria	60.5	3.8e-7	NR	WP_244363811.1	56956	g17526	i0	48.5	1.4804469273743	130	64	70.9	1	156	536	181	310	WP_244363811.1 RCC1 domain-containing protein [Thermus brockianus]	diamond	795	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus

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