metadata: contig_metadata: 5 rows where bioproject = "PRJNA379145", tax_kingdom = "Thermotogati" and tax

5 rows where bioproject = "PRJNA379145", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"

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
8054065	8054065	PRJNA379145_P_NODE_33447_length_370_cov_2.077151_g31305_i0	PRJNA379145	33447	370	2.077151	7.6854587	Thermotogae	188708	Bacteria	Bacteria	108	1.04e-26	NR	WP_072862210.1	287990	g31305	i0	57.9	7.95405405405405	95	39	77	1	44	328	10	103	WP_072862210.1 macro domain-containing protein [Marinitoga hydrogenitolerans]	diamond	2943	109	0.990825688073395	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga hydrogenitolerans
15703796	15703796	PRJNA379145_P_NODE_6113_length_1228_cov_6.786611_g5366_i0	PRJNA379145	6113	1228	6.786611	83.33958308	PVC group	1783257	Bacteria	Bacteria	245	1.27e-73	NR	WP_041082339.1	1508420	g5366	i0	40.4	1.79560260586319	359	200	87.2	7	1135	65	40	386	WP_041082339.1 serpin family protein [Thermotoga profunda]	diamond	2205	245	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga profunda
26695010	26695010	PRJNA379145_P_NODE_50181_length_232_cov_2.386935_g48027_i0	PRJNA379145	50181	232	2.386935	5.5376892	Petrotogaceae bacterium	2819251	Bacteria	Bacteria	40.4	0.0381	NR	HOT30906.1	2819251	g48027	i0	52.6	0.491379310344828	38	18	49.1	0	3	116	14	51	HOT30906.1 hypothetical protein [Petrotogaceae bacterium]	diamond	114	40.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae		Petrotogaceae bacterium
27707217	27707217	PRJNA379145_P_NODE_56004_length_204_cov_2.339181_g53850_i0	PRJNA379145	56004	204	2.339181	4.77192924	Thermotogota bacterium	2053689	Bacteria	Bacteria	51.6	1.04e-5	NR	MEA1885386.1	2053689	g53850	i0	57.1	2.26470588235294	42	18	61.8	0	64	189	167	208	MEA1885386.1 response regulator [Thermotogota bacterium]	diamond	462	51.6	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32667033	32667033	PRJNA379145_P_NODE_260_length_3448_cov_4.500146_g209_i0	PRJNA379145	260	3448	4.500146	155.16503408	Kosmotogaceae bacterium	2053567	Bacteria	Bacteria	341	2.67e-100	NR	MFO7882767.1	2053567	g209	i0	33.9	0.528132250580046	607	357	50.6	16	2638	893	12	599	MFO7882767.1 alpha-amylase family glycosyl hydrolase [Kosmotogaceae bacterium]	diamond	1821	341	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae		Kosmotogaceae bacterium

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