metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA631119" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA631119" 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
11355212	11355212	PRJNA631119_P_NODE_19289_length_301_cov_1.276316_g19171_i0	PRJNA631119	19289	301	1.276316	3.84171116	Mesotoga sp.	2053577	Bacteria	Bacteria	155	3.559999999999999e-42	NR	MCB1222954.1	2053577	g19171	i0	71	0.996677740863787	100	29	99.7	0	1	300	129	228	MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.]	diamond	300	155	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp.
27472710	27472710	PRJNA631119_P_NODE_35883_length_245_cov_0.895349_g35765_i0	PRJNA631119	35883	245	0.895349	2.19360505	FCB group	1783270	Bacteria	Bacteria	45.1	0.00541	NR	MEY4529876.1	1913990	g35765	i0	32.1	1.93469387755102	78	51	93.1	1	1	228	47	124	MEY4529876.1 hypothetical protein [Deinococcota bacterium]	diamond	474	45.1	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
27757079	27757079	PRJNA631119_P_NODE_32624_length_249_cov_0.875000_g32506_i0	PRJNA631119	32624	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	127	6.12e-33	NR	WP_110886524.1	309889	g32506	i0	69.9	7.98795180722892	83	25	100	0	249	1	247	329	WP_110886524.1 acyl-CoA dehydrogenase family protein [Deinococcus yavapaiensis]	diamond	1989	128	0.9921875	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
28407369	28407369	PRJNA631119_P_NODE_22806_length_283_cov_1.428571_g22688_i0	PRJNA631119	22806	283	1.428571	4.04285593	Thermotogaceae bacterium	2268206	Bacteria	Bacteria	45.4	0.00307	NR	MDI3471901.1	2268206	g22688	i0	32.9	0.80565371024735	76	49	79.5	2	17	241	4	78	MDI3471901.1 uncharacterized protein [Thermotogaceae bacterium]	diamond	228	45.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae		Thermotogaceae bacterium
31072996	31072996	PRJNA631119_P_NODE_36015_length_245_cov_0.895349_g35897_i0	PRJNA631119	36015	245	0.895349	2.19360505	FCB group	1783270	Bacteria	Bacteria	57	3.62e-7	NR	MDX2007146.1	1955249	g35897	i0	42.5	2.75510204081633	80	40	98	1	245	6	126	199	MDX2007146.1 G8 domain-containing protein [Meiothermus sp.]	diamond	675	57	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.

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