metadata: contig_metadata: 2 rows where bioproject = "PRJNA669701", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Peregrinibacteriota"

2 rows where bioproject = "PRJNA669701", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Peregrinibacteriota"

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
26892004	26892004	PRJNA669701_P_NODE_145281_length_234_cov_2.583851_g144886_i0	PRJNA669701	145281	234	2.583851	6.04621134	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	90.1	5.14e-20		NR	MCK5019913.1	2735830	g144886	i0	63.9	0.782051282051282	61	20	78.2	1	19	201	172	230	MCK5019913.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	183	90.1	1	Bacteria	Bacteria candidate phyla		Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales			Candidatus Peribacteraceae bacterium
32560085	32560085	PRJNA669701_P_NODE_140159_length_241_cov_1.839286_g139764_i0	PRJNA669701	140159	241	1.839286	4.43267926	root	1	Root_unresolved	Root_unresolved	43.9	0.0128		NR	MDB4979126.1	2053688	g139764	i0	41.2	1.07053941908714	51	28	61	1	193	47	142	192	MDB4979126.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	258	44.3	0.99097065462754	Bacteria	Bacteria candidate phyla		Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria 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);;