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

4 rows where bioproject = "PRJNA849822", 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	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_species
27907504	27907504	PRJNA849822_P_NODE_25305_length_289_cov_0.916667_g25131_i0	PRJNA849822	25305	289	0.916667	2.64916763	Candidatus Peribacterales bacterium	2711152	Bacteria	Bacteria	79.3	9.31e-15	NR	HLC75740.1	2711152	g25131	i0	47.2	0.923875432525952	89	41	86.2	2	273	25	1859	1947	HLC75740.1 DUF4215 domain-containing protein [Candidatus Peribacterales bacterium]	diamond	267	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacterales bacterium
28444701	28444701	PRJNA849822_P_NODE_36686_length_249_cov_1.329545_g36512_i0	PRJNA849822	36686	249	1.329545	3.31056705	Candidatus Peribacterales bacterium	2711152	Bacteria	Bacteria	63.9	1.39e-9	NR	HLC75740.1	2711152	g36512	i0	51.8	0.674698795180723	56	22	61.4	1	2	154	1890	1945	HLC75740.1 DUF4215 domain-containing protein [Candidatus Peribacterales bacterium]	diamond	168	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacterales bacterium
31761630	31761630	PRJNA849822_P_NODE_15037_length_375_cov_1.562914_g14863_i0	PRJNA849822	15037	375	1.562914	5.8609275	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	101	5.42e-22	NR	MDD4319423.1	2735830	g14863	i0	47.6	0.992	124	56	95.2	5	361	5	304	423	MDD4319423.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	372	101	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae bacterium
31951462	31951462	PRJNA849822_P_NODE_41697_length_244_cov_0.894737_g41523_i0	PRJNA849822	41697	244	0.894737	2.18315828	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	48.5	3.17e-4	NR	MDD5025828.1	2735830	g41523	i0	42.1	0.467213114754098	38	22	46.7	0	113	226	55	92	MDD5025828.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	114	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae 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);;