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

5 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax_phylum = "Gemmatimonadota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
26750439	26750439	PRJNA1068830_P_NODE_85461_length_244_cov_0.912281_g84758_i0	PRJNA1068830	85461	244	0.912281	2.22596564	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	57	1.78e-7	NR	MFB3112079.1	2448054	g84758	i0	50.8	3.20901639344262	63	29	77.5	1	51	239	128	188	MFB3112079.1 CAP domain-containing protein [Gemmatimonadales bacterium]	diamond	783	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
27003909	27003909	PRJNA1068830_P_NODE_60722_length_279_cov_1.514563_g60019_i0	PRJNA1068830	60722	279	1.514563	4.22563077	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	52.4	2.36e-5	NR	HEV8362459.1	2026741	g60019	i0	45.2	1	93	48	100	2	1	279	156	245	HEV8362459.1 glycosyltransferase family 39 protein [Gemmatimonadaceae bacterium]	diamond	279	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
27415276	27415276	PRJNA1068830_P_NODE_83363_length_245_cov_1.360465_g82660_i0	PRJNA1068830	83363	245	1.360465	3.33313925	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.8	3.62e-5	NR	NNE08328.1	2026742	g82660	i0	36.3	0.979591836734694	80	37	98	2	242	3	45	110	NNE08328.1 iron-sulfur cluster repair di-iron protein [Gemmatimonadota bacterium]	diamond	240	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29435446	29435446	PRJNA1068830_P_NODE_90770_length_227_cov_2.331169_g90067_i0	PRJNA1068830	90770	227	2.331169	5.29175363	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	50.4	5.83e-5	NR	HEV7993743.1	2026741	g90067	i0	37.9	1.71806167400881	66	40	87.2	1	24	221	554	618	HEV7993743.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium]	diamond	390	50.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
29877908	29877908	PRJNA1068830_P_NODE_63691_length_272_cov_1.306533_g62988_i0	PRJNA1068830	63691	272	1.306533	3.5537697600000002	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	82.8	4.18e-16	NR	HEY6061030.1	2448054	g62988	i0	47.2	2.94485294117647	89	43	98.2	1	270	4	296	380	HEY6061030.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	801	82.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales 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);;