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

5 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27010537	27010537	PRJNA188516_P_NODE_822_length_427_cov_1.566138_g772_i0	PRJNA188516	822	427	1.566138	6.68740926	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	67.4	1.1e-11	NR	RTL06915.1	2030827	g772	i0	62.5	0.337236533957845	48	18	33.7	0	146	3	36	83	RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium]	diamond	144	67.4	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
27926776	27926776	PRJNA188516_P_NODE_2725_length_207_cov_1.645570_g2675_i0	PRJNA188516	2725	207	1.64557	3.4063299	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	48.1	1.58e-4	NR	MEK7650155.1	2052139	g2675	i0	60.6	0.478260869565217	33	13	47.8	0	194	96	6	38	MEK7650155.1 50S ribosomal protein L6 [Patescibacteria group bacterium]	diamond	99	48.1	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
28179104	28179104	PRJNA188516_P_NODE_4046_length_169_cov_0.866667_g3996_i0	PRJNA188516	4046	169	0.866667	1.46466723	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	41.2	0.047	NR	TXH01601.1	2045217	g3996	i0	47.1	0.603550295857988	34	17	60.4	1	104	3	319	351	TXH01601.1 MAG: hypothetical protein E6P95_01485 [Candidatus Moraniibacteriota bacterium]	diamond	102	41.2	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
28368713	28368713	PRJNA188516_P_NODE_4746_length_167_cov_0.881356_g4696_i0	PRJNA188516	4746	167	0.881356	1.47186452	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	106	4.12e-27	NR	RKV92962.1	1917697	g4696	i0	98	0.898203592814371	50	1	89.8	0	18	167	1	50	RKV92962.1 MAG: hypothetical protein D8G53_13555, partial [Candidatus Saccharimonas sp.]	diamond	150	106	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
31179459	31179459	PRJNA188516_P_NODE_5535_length_164_cov_0.904348_g5485_i0	PRJNA188516	5535	164	0.904348	1.48313072	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	41.6	0.033	NR	HUR45991.1	2973664	g5485	i0	37.3	0.932926829268293	51	31	91.5	1	9	158	66	116	HUR45991.1 vitamin K epoxide reductase family protein [Candidatus Saccharimonadales bacterium]	diamond	153	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales 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);;