metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA1112809" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA1112809" 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
12973091	12973091	PRJNA1112809_P_NODE_137051_length_277_cov_1.019608_g133776_i0	PRJNA1112809	137051	277	1.019608	2.82431416	Petrotogaceae bacterium	2819251	Bacteria	Bacteria	73.9	1.37e-14	NR	MBP7237489.1	2819251	g133776	i0	87.8	0.444043321299639	41	5	44.4	0	156	34	1	41	MBP7237489.1 PRD domain-containing protein [Petrotogaceae bacterium]	diamond	123	73.9	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae		Petrotogaceae bacterium
15521761	15521761	PRJNA1112809_P_NODE_129633_length_285_cov_1.250000_g126358_i0	PRJNA1112809	129633	285	1.25	3.5625	Trueperaceae bacterium	2026798	Bacteria	Bacteria	171	2.65e-50	NR	HNR00700.1	2026798	g126358	i0	87.2	1.97894736842105	94	12	98.9	0	2	283	132	225	HNR00700.1 cystathionine gamma-lyase [Trueperaceae bacterium]	diamond	564	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
16325871	16325871	PRJNA1112809_P_NODE_168233_length_250_cov_0.870056_g164958_i0	PRJNA1112809	168233	250	0.870056	2.17514	Deinococcus yunweiensis	367282	Bacteria	Bacteria	137	3.66e-36	NR	WP_412027026.1	367282	g164958	i0	69.8	1.152	96	15	98.4	2	3	248	253	348	WP_412027026.1 hypothetical protein [Deinococcus yunweiensis]	diamond	288	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
26972847	26972847	PRJNA1112809_P_NODE_106142_length_319_cov_1.878049_g102867_i0	PRJNA1112809	106142	319	1.878049	5.99097631	Thermotogota bacterium	2053689	Bacteria	Bacteria	86.3	2.09e-17	NR	RKX40512.1	2053689	g102867	i0	74.5	2.40752351097179	51	13	48	0	154	2	1	51	RKX40512.1 MAG: L-erythro-3,5-diaminohexanoate dehydrogenase [Thermotogota bacterium]	diamond	768	86.3	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
27004565	27004565	PRJNA1112809_P_NODE_80462_length_381_cov_2.344156_g77187_i0	PRJNA1112809	80462	381	2.344156	8.93123436	Deinococcales bacterium	2478479	Bacteria	Bacteria	156	9.13e-45	NR	HWG84700.1	2478479	g77187	i0	62.7	0.992125984251969	126	47	99.2	0	2	379	78	203	HWG84700.1 amino acid ABC transporter permease [Deinococcales bacterium]	diamond	378	156	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			Deinococcales bacterium
27731565	27731565	PRJNA1112809_P_NODE_128744_length_286_cov_1.291080_g125469_i0	PRJNA1112809	128744	286	1.29108	3.6924888	Deinococcus aquatilis	519440	Bacteria	Bacteria	134	5.46e-39	NR	WP_083922326.1	519440	g125469	i0	97.6	0.891608391608392	85	2	89.2	0	269	15	1	85	WP_083922326.1 PAAR domain-containing protein [Deinococcus aquatilis]	diamond	255	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquatilis
28362617	28362617	PRJNA1112809_P_NODE_147246_length_266_cov_1.595855_g143971_i0	PRJNA1112809	147246	266	1.595855	4.2449743	Fervidobacterium sp.	1871331	Bacteria	Bacteria	169	2.04e-48	NR	MDM7321098.1	1871331	g143971	i0	96.6	0.992481203007519	88	3	99.2	0	2	265	17	104	MDM7321098.1 VWA-like domain-containing protein [Fervidobacterium sp.]	diamond	264	169	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
28489133	28489133	PRJNA1112809_P_NODE_182587_length_245_cov_0.872093_g179312_i0	PRJNA1112809	182587	245	0.872093	2.13662785	Deinococcus sp. Arct2-2	2568653	Bacteria	Bacteria	77.4	2.18e-14	NR	WP_136365014.1	2568653	g179312	i0	87.2	1.88571428571429	39	5	47.8	0	129	245	259	297	WP_136365014.1 transposase [Deinococcus sp. Arct2-2]	diamond	462	77.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Arct2-2
29373184	29373184	PRJNA1112809_P_NODE_186269_length_243_cov_1.452941_g182994_i0	PRJNA1112809	186269	243	1.452941	3.53064663	Deinococcus fonticola	2528713	Bacteria	Bacteria	60.5	2.07e-8	NR	WP_135230627.1	2528713	g182994	i0	87.5	0.395061728395062	32	4	39.5	0	1	96	376	407	WP_135230627.1 hypothetical protein [Deinococcus fonticola]	diamond	96	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
29783495	29783495	PRJNA1112809_P_NODE_120031_length_297_cov_1.375000_g116756_i0	PRJNA1112809	120031	297	1.375	4.08375	Deinococcus yavapaiensis	309889	Bacteria	Bacteria	139	1.08e-39	NR	WP_110886926.1	309889	g116756	i0	75	0.848484848484849	84	21	84.8	0	43	294	12	95	WP_110886926.1 DUF427 domain-containing protein [Deinococcus yavapaiensis]	diamond	252	139	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
30564263	30564263	PRJNA1112809_P_NODE_191973_length_241_cov_1.672619_g188698_i0	PRJNA1112809	191973	241	1.672619	4.03101179	Bacteria	2	Bacteria	Bacteria	53.9	4.07e-6	NR	WP_347241448.1	275	g188698	i0	52.4	2.51452282157676	42	20	52.3	0	241	116	363	404	WP_347241448.1 glycosyltransferase family 4 protein [Thermus sp.]	diamond	606	53.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
30627563	30627563	PRJNA1112809_P_NODE_124893_length_290_cov_1.958525_g121618_i0	PRJNA1112809	124893	290	1.958525	5.6797225	Bacteria	2	Bacteria	Bacteria	47.8	0.00111	NR	WP_170131105.1	309889	g121618	i0	38.4	2.80344827586207	86	52	89	1	260	3	83	167	WP_170131105.1 hypothetical protein [Deinococcus yavapaiensis]	diamond	813	47.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
30763085	30763085	PRJNA1112809_P_NODE_161294_length_253_cov_1.511111_g158019_i0	PRJNA1112809	161294	253	1.511111	3.82311083	Fervidobacterium sp.	1871331	Bacteria	Bacteria	163	7.96e-45	NR	HOH53832.1	1871331	g158019	i0	97.6	2.95256916996047	83	2	98.4	0	3	251	248	330	HOH53832.1 preprotein translocase subunit SecA [Fervidobacterium sp.]	diamond	747	163	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
30763113	30763113	PRJNA1112809_P_NODE_52434_length_522_cov_1.977728_g49169_i0	PRJNA1112809	52434	522	1.977728	10.32374016	Deinococcus apachensis	309886	Bacteria	Bacteria	112	1.9899999999999999e-25	NR	WP_019584686.1	309886	g49169	i0	57.6	1.1551724137931	92	39	52.9	0	26	301	384	475	WP_019584686.1 hypothetical protein [Deinococcus apachensis]	diamond	603	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus apachensis
31512955	31512955	PRJNA1112809_P_NODE_184936_length_244_cov_0.900585_g181661_i0	PRJNA1112809	184936	244	0.900585	2.1974274	Deinococcus	1298	Bacteria	Bacteria	63.5	2.19e-10	NR	WP_041221842.1	68909	g181661	i0	91.4	0.885245901639344	35	3	43	0	138	242	3	37	WP_041221842.1 hypothetical protein [Deinococcus geothermalis]	diamond	216	63.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
32848967	32848967	PRJNA1112809_P_NODE_145100_length_268_cov_1.938462_g141825_i0	PRJNA1112809	145100	268	1.938462	5.1950781599999996	Deinococcota bacterium	1913990	Bacteria	Bacteria	77.4	3.08e-14	NR	MEY4531830.1	1913990	g141825	i0	47.7	1.97014925373134	88	45	98.5	1	267	4	144	230	MEY4531830.1 undecaprenyl-phosphate galactose phosphotransferase WbaP [Deinococcota bacterium]	diamond	528	77.4	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
32903059	32903059	PRJNA1112809_P_NODE_183000_length_244_cov_1.994152_g179725_i0	PRJNA1112809	183000	244	1.994152	4.86573088	Deinococcus	1298	Bacteria	Bacteria	66.2	1.12e-11	NR	WP_224607214.1	1656887	g179725	i0	55.1	1.20491803278689	49	22	60.2	0	159	13	6	54	WP_224607214.1 ACT domain-containing protein [Deinococcus multiflagellatus]	diamond	294	66.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus multiflagellatus

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