metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA770826" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA770826" 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
2482120	2482120	PRJNA770826_P_NODE_30742_length_167_cov_0.881356_g30571_i0	PRJNA770826	30742	167	0.881356	1.47186452	root	1	Root_unresolved	Root_unresolved	97.1	3.08e-23	NR	MDB5045407.1	47478	g30571	i0	76.4	24.6467065868263	55	13	98.8	0	2	166	164	218	MDB5045407.1 6-phosphogluconate dehydrogenase [Deinococcus sp.]	diamond	4116	97.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
26936217	26936217	PRJNA770826_P_NODE_6762_length_319_cov_1.759259_g6591_i0	PRJNA770826	6762	319	1.759259	5.61203621	Bacteria	2	Bacteria	Bacteria	108	6.09e-25	NR	WP_110528403.1	370471	g6591	i0	57.9	15.0470219435737	107	42	99.7	3	2	319	290	394	WP_110528403.1 MULTISPECIES: NAD-dependent malic enzyme [unclassified Meiothermus]	diamond	4800	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus
27179508	27179508	PRJNA770826_P_NODE_35022_length_165_cov_0.896552_g34851_i0	PRJNA770826	35022	165	0.896552	1.4793108	Kosmotoga sp.	1955248	Bacteria	Bacteria	69.7	2.25e-13	NR	TYB88804.1	1955248	g34851	i0	54.5	3	55	25	100	0	165	1	73	127	TYB88804.1 MAG: MaoC family dehydratase [Kosmotoga sp.]	diamond	495	69.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga sp.
27811604	27811604	PRJNA770826_P_NODE_15644_length_204_cov_1.677419_g15473_i0	PRJNA770826	15644	204	1.677419	3.42193476	Deinococcus hopiensis	309885	Bacteria	Bacteria	67.4	4.36e-11	NR	WP_170928889.1	309885	g15473	i0	64.4	1.91176470588235	45	16	66.2	0	69	203	43	87	WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis]	diamond	390	67.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
28136864	28136864	PRJNA770826_P_NODE_7565_length_298_cov_1.610442_g7394_i0	PRJNA770826	7565	298	1.610442	4.79911716	Bacteria	2	Bacteria	Bacteria	97.8	1.3e-22	NR	WP_033191857.1	2422	g7394	i0	57.6	6.66442953020134	92	38	92.6	1	1	276	66	156	WP_033191857.1 MULTISPECIES: 50S ribosomal protein L1 [Fervidobacterium]	diamond	1986	98.6	0.991886409736308	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium
28158946	28158946	PRJNA770826_P_NODE_23525_length_169_cov_0.866667_g23354_i0	PRJNA770826	23525	169	0.866667	1.46466723	Thermotogota bacterium	2053689	Bacteria	Bacteria	42.4	0.00454	NR	MCD6238231.1	2053689	g23354	i0	42.2	1.36686390532544	45	23	74.6	1	167	42	26	70	MCD6238231.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatC [Thermotogota bacterium]	diamond	231	42.4	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
28695658	28695658	PRJNA770826_P_NODE_38887_length_163_cov_1.368421_g38716_i0	PRJNA770826	38887	163	1.368421	2.23052623	Synergistaceae bacterium	2053624	Bacteria	Bacteria	73.6	3.97e-14	NR	HOO64696.1	2053624	g38716	i0	62.3	0.975460122699387	53	20	97.5	0	3	161	86	138	HOO64696.1 TIGR00266 family protein [Synergistaceae bacterium]	diamond	159	73.6	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28727074	28727074	PRJNA770826_P_NODE_4587_length_402_cov_1.600567_g4416_i0	PRJNA770826	4587	402	1.600567	6.43427934	Thermus arciformis	482827	Bacteria	Bacteria	169	8.6199999999999985e-47	NR	WP_093005720.1	482827	g4416	i0	59.7	17.8358208955224	134	54	100	0	402	1	11	144	WP_093005720.1 NAD-dependent malic enzyme [Thermus arciformis]	diamond	7170	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus arciformis
30306511	30306511	PRJNA770826_P_NODE_19412_length_184_cov_1.155556_g19241_i0	PRJNA770826	19412	184	1.155556	2.12622304	Synergistaceae bacterium	2053624	Bacteria	Bacteria	81.6	1.39e-17	NR	MBQ7665751.1	2053624	g19241	i0	61	2.90217391304348	59	23	96.2	0	6	182	48	106	MBQ7665751.1 hypoxanthine phosphoribosyltransferase [Synergistaceae bacterium]	diamond	534	81.6	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31443719	31443719	PRJNA770826_P_NODE_6976_length_314_cov_1.064151_g6805_i0	PRJNA770826	6976	314	1.064151	3.34143414	Petrotoga sp. 9PWA.NaAc.5.4	1434328	Bacteria	Bacteria	104	9.85e-26	NR	WP_121958620.1	1434328	g6805	i0	56.2	3.39171974522293	89	38	84.1	1	50	313	10	98	WP_121958620.1 macro domain-containing protein [Petrotoga sp. 9PWA.NaAc.5.4]	diamond	1065	104	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp. 9PWA.NaAc.5.4
32076433	32076433	PRJNA770826_P_NODE_44098_length_154_cov_2.485714_g43927_i0	PRJNA770826	44098	154	2.485714	3.82799956	Deinococcus cellulosilyticus	401558	Bacteria	Bacteria	97.4	4.76e-22	NR	WP_146884523.1	401558	g43927	i0	72.5	1.98701298701299	51	14	99.4	0	1	153	250	300	WP_146884523.1 glycoside hydrolase family 30 protein [Deinococcus cellulosilyticus]	diamond	306	97.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus

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