metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA561212" 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
28626780	28626780	PRJNA561212_P_NODE_8147_length_384_cov_1.877814_g7936_i0	PRJNA561212	8147	384	1.877814	7.21080576	Deinococcus koreensis	2054903	Bacteria	Bacteria	47	0.00558	NR	WP_103312724.1	2054903	g7936	i0	46.6	0.8671875	58	26	45.3	2	368	195	306	358	WP_103312724.1 elongation factor G [Deinococcus koreensis]	diamond	333	47	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus koreensis
29384419	29384419	PRJNA561212_P_NODE_22609_length_248_cov_1.285714_g22398_i0	PRJNA561212	22609	248	1.285714	3.18857072	Trueperaceae bacterium	2026798	Bacteria	Bacteria	47	0.00117	NR	HLV13062.1	2026798	g22398	i0	43.9	1.53629032258065	57	31	69	1	179	9	83	138	HLV13062.1 TspO/MBR family protein [Trueperaceae bacterium]	diamond	381	47	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29731397	29731397	PRJNA561212_P_NODE_9250_length_362_cov_1.231834_g9039_i0	PRJNA561212	9250	362	1.231834	4.45923908	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	51.6	1.03e-4	NR	MFN3328904.1	93466	g9039	i0	40.7	0.671270718232044	81	39	60.5	3	6	224	81	160	MFN3328904.1 LIM domain-containing protein [Fervidobacterium pennivorans]	diamond	243	51.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
30124385	30124385	PRJNA561212_P_NODE_11592_length_326_cov_0.889328_g11381_i0	PRJNA561212	11592	326	0.889328	2.89920928	Bacteria	2	Bacteria	Bacteria	111	1.01e-26	NR	WP_229365136.1	274	g11381	i0	61.2	10.4539877300613	103	30	94.8	2	317	9	76	168	WP_229365136.1 S8 family peptidase [Thermus thermophilus]	diamond	3408	112	0.991071428571429	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus

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