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

5 rows where analysis = "diamond", bioproject = "PRJNA627467" 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
17728691	17728691	PRJNA627467_P_NODE_21394_length_152_cov_3.155340_g21325_i0	PRJNA627467	21394	152	3.15534	4.7961168	Trueperaceae bacterium	2026798	Bacteria	Bacteria	87.8	1.38e-18	NR	MFA5567469.1	2026798	g21325	i0	78	2.96052631578947	50	11	98.7	0	2	151	244	293	MFA5567469.1 hypothetical protein [Trueperaceae bacterium]	diamond	450	87.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
27901667	27901667	PRJNA627467_P_NODE_18945_length_162_cov_0.902655_g18876_i0	PRJNA627467	18945	162	0.902655	1.4623011	Deinococcus marmoris	249408	Bacteria	Bacteria	48.1	1.55e-4	NR	WP_029483587.1	249408	g18876	i0	54.3	0.851851851851852	46	21	85.2	0	159	22	268	313	WP_029483587.1 aldo/keto reductase [Deinococcus marmoris]	diamond	138	48.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus marmoris
28704108	28704108	PRJNA627467_P_NODE_2747_length_316_cov_2.382022_g2679_i0	PRJNA627467	2747	316	2.382022	7.52718952	Deinococcus	1298	Bacteria	Bacteria	65.5	9.14e-10	NR	WP_184031579.1	1298	g2679	i0	93.8	0.930379746835443	32	2	30.4	0	314	219	32	63	WP_184031579.1 MULTISPECIES: Eco57I restriction-modification methylase domain-containing protein [Deinococcus]	diamond	294	65.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
30491402	30491402	PRJNA627467_P_NODE_9353_length_190_cov_1.794326_g9284_i0	PRJNA627467	9353	190	1.794326	3.4092194	Calidithermus chliarophilus	52023	Bacteria	Bacteria	48.5	7.79e-5	NR	WP_051304274.1	52023	g9284	i0	66.7	0.426315789473684	27	9	42.6	0	37	117	136	162	WP_051304274.1 EVE domain-containing protein [Calidithermus chliarophilus]	diamond	81	48.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus chliarophilus
32008878	32008878	PRJNA627467_P_NODE_16778_length_166_cov_1.547009_g16709_i0	PRJNA627467	16778	166	1.547009	2.56803494	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	50.4	2.43e-5	NR	WP_409152565.1	651822	g16709	i0	57.8	3.43373493975904	45	17	81.3	1	6	140	276	318	WP_409152565.1 Synerg-CTERM sorting domain-containing protein [Fretibacterium fastidiosum]	diamond	570	50.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum

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