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

5 rows where bioproject = "PRJNA565584", 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
26762821	26762821	PRJNA565584_P_NODE_169501_length_251_cov_0.865169_g168349_i0	PRJNA565584	169501	251	0.865169	2.17157419	Thermotogaceae bacterium	2268206	Bacteria	Bacteria	42.7	0.0385	NR	MDI3472548.1	2268206	g168349	i0	39.7	0.693227091633466	58	28	61	2	199	47	79	136	MDI3472548.1 putative pyruvate formate lyase activating enzyme [Thermotogaceae bacterium]	diamond	174	42.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae		Thermotogaceae bacterium
28198338	28198338	PRJNA565584_P_NODE_64146_length_371_cov_1.033557_g62995_i0	PRJNA565584	64146	371	1.033557	3.83449647	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	57.8	8.66e-7	NR	MCD6104362.1	1968895	g62995	i0	27.4	5.96765498652291	113	68	91.4	2	2	340	700	798	MCD6104362.1 leucine--tRNA ligase [Thermosipho sp. (in: thermotogales)]	diamond	2214	57.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
29146079	29146079	PRJNA565584_P_NODE_34509_length_516_cov_1.270880_g33358_i0	PRJNA565584	34509	516	1.27088	6.5577408	Bacteria	2	Bacteria	Bacteria	103	5.84e-25	NR	WP_128080917.1	2335	g33358	i0	45.6	5.90697674418605	125	60	71.5	4	462	94	6	124	WP_128080917.1 MULTISPECIES: glycine cleavage system protein GcvH [Thermotoga]	diamond	3048	104	0.990384615384615	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga
29384710	29384710	PRJNA565584_P_NODE_164009_length_253_cov_1.405556_g162857_i0	PRJNA565584	164009	253	1.405556	3.55605668	Mesotoga sp.	2053577	Bacteria	Bacteria	141	1.52e-40	NR	HRV01115.1	2053577	g162857	i0	79.5	0.984189723320158	83	17	98.4	0	251	3	85	167	HRV01115.1 hypothetical protein [Mesotoga sp.]	diamond	249	141	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp.
31280058	31280058	PRJNA565584_P_NODE_39175_length_480_cov_1.319410_g38024_i0	PRJNA565584	39175	480	1.31941	6.333168	Thermotoga sp.	28240	Bacteria	Bacteria	89.7	1.07e-17	NR	RKX53024.1	28240	g38024	i0	48.1	0.9875	79	41	49.4	0	365	129	247	325	RKX53024.1 MAG: phosphoglycerate kinase [Thermotoga sp.]	diamond	474	89.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga 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);;