metadata: contig_metadata: 2 rows where bioproject = "PRJNA741997", tax_clade = "Bacteria candidate phyla" and tax

2 rows where bioproject = "PRJNA741997", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Aminicenantota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	lowcoverage_flag	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_genus	tax_species
30820997	30820997	PRJNA741997_P_NODE_52354_length_297_cov_1.375000_g51234_i0	PRJNA741997	52354	297	1.375	4.08375	Bacillati	1783272	Bacteria	Bacteria	101	5.42e-24		NR	RPI99687.1	2052149	g51234	i0	52.6	4.8989898989899	97	45	98	1	296	6	125	220	RPI99687.1 MAG: aspartate carbamoyltransferase, partial [Candidatus Aminicenantes bacterium]	diamond	1455	101	1	Bacteria	Bacteria candidate phyla		Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
32843713	32843713	PRJNA741997_P_NODE_66420_length_263_cov_1.315789_g65300_i0	PRJNA741997	66420	263	1.315789	3.46052507	Bacteria	2	Bacteria	Bacteria	53.9	5.59e-6		NR	OQB57801.1	1852831	g65300	i0	45.6	7.28897338403042	68	36	77.6	1	206	3	153	219	OQB57801.1 MAG: Serine/threonine-protein kinase PrkC [Candidatus Aminicenantes bacterium ADurb.Bin147]	diamond	1917	54.3	0.992633517495396	Bacteria	Bacteria candidate phyla		Candidatus Aminicenantota					Candidatus Aminicenantes bacterium ADurb.Bin147

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