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

2 rows where bioproject = "PRJNA867519", 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
19088479	19088479	PRJNA867519_P_NODE_18975_length_280_cov_1.487923_g18821_i0	PRJNA867519	18975	280	1.487923	4.1661844	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	104	6.93e-25		NR	MBI5413010.1	2030811	g18821	i0	47.8	0.985714285714286	92	48	98.6	0	5	280	6	97	MBI5413010.1 uridine phosphorylase [Candidatus Peregrinibacteria bacterium]	diamond	276	104	1	Bacteria	Bacteria candidate phyla		Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
30529010	30529010	PRJNA867519_P_NODE_5693_length_454_cov_1.212598_g5539_i0	PRJNA867519	5693	454	1.212598	5.50519492	Candidatus Peribacterales bacterium	2711152	Bacteria	Bacteria	46.2	0.0211		NR	HLC76253.1	2711152	g5539	i0	32.6	0.568281938325991	86	51	52.9	3	423	184	1028	1112	HLC76253.1 hypothetical protein [Candidatus Peribacterales bacterium]	diamond	258	46.2	1	Bacteria	Bacteria candidate phyla		Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales			Candidatus Peribacterales 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);;