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

4 rows where bioproject = "PRJNA379145", 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
27927767	27927767	PRJNA379145_P_NODE_17945_length_646_cov_2.104405_g16171_i0	PRJNA379145	17945	646	2.104405	13.5944563	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	76.6	3.15e-12	NR	MBT4917127.1	2030811	g16171	i0	37.4	0.571207430340557	123	72	55.3	3	115	471	39	160	MBT4917127.1 homeobox domain-containing protein [Candidatus Peregrinibacteria bacterium]	diamond	369	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota			Candidatus Peregrinibacteria bacterium
27927841	27927841	PRJNA379145_P_NODE_6045_length_1234_cov_3.598668_g5308_i0	PRJNA379145	6045	1234	3.598668	44.40756312	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	47	0.0171	NR	HCI03865.1	2053688	g5308	i0	39.3	0.148298217179903	61	30	13.6	2	1051	1218	55	113	HCI03865.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	183	47	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria		Candidatus Peribacteria bacterium
30738382	30738382	PRJNA379145_P_NODE_56094_length_204_cov_1.637427_g53940_i0	PRJNA379145	56094	204	1.637427	3.34035108	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	58.5	5.92e-8	NR	MDD5055196.1	2735830	g53940	i0	60.9	0.676470588235294	46	18	67.6	0	151	14	809	854	MDD5055196.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	138	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae bacterium
30770249	30770249	PRJNA379145_P_NODE_9774_length_965_cov_23.983906_g8641_i0	PRJNA379145	9774	965	23.983906	231.4446929	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	293	6.06e-95	NR	MBI5413010.1	2030811	g8641	i0	52.1	1.79689119170984	292	137	89.8	2	896	30	2	293	MBI5413010.1 uridine phosphorylase [Candidatus Peregrinibacteria bacterium]	diamond	1734	293	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota			Candidatus Peregrinibacteria 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);;