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

4 rows where bioproject = "PRJNA924320", 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_species
27625078	27625078	PRJNA924320_S_NODE_13564_length_271_cov_2.265766_g13422_i0	PRJNA924320	13564	271	2.265766	6.14022586	Candidatus Peribacteria bacterium RIFCSPHIGHO2_	2053688	Bacteria	Bacteria	45.8	0.00294	NR	OGJ56652.1	1801914	g13422	i0	44.1	2.6789667896679	59	33	65.3	0	94	270	29	87	OGJ56652.1 MAG: hypothetical protein A2706_00465 [Candidatus Peribacteria bacterium RIFCSPHIGHO2_01_FULL_51_35]	diamond	726	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium RIFCSPHIGHO2_01_FULL_51_35
30530134	30530134	PRJNA924320_S_NODE_21173_length_227_cov_0.859551_g21031_i0	PRJNA924320	21173	227	0.859551	1.95118077	Candidatus Peregrinibacteria bacterium Greene	2030811	Bacteria	Bacteria	70.5	4.93e-12	NR	TSC57184.1	2017151	g21031	i0	47.2	0.951541850220264	72	38	95.2	0	224	9	217	288	TSC57184.1 MAG: hypothetical protein Greene041662_1035, partial [Candidatus Peregrinibacteria bacterium Greene0416_62]	diamond	216	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium Greene0416_62
31043339	31043339	PRJNA924320_S_NODE_11735_length_289_cov_1.275000_g11593_i0	PRJNA924320	11735	289	1.275	3.68475	Pseudomonadati	3379134	Bacteria	Bacteria	45.4	0.00707	NR	MCC7196718.1	2030811	g11593	i0	38.6	2.15916955017301	70	37	66.4	2	240	49	23	92	MCC7196718.1 CCA tRNA nucleotidyltransferase [Candidatus Peregrinibacteria bacterium]	diamond	624	45.8	0.991266375545852	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
31359276	31359276	PRJNA924320_S_NODE_55176_length_162_cov_0.902655_g55034_i0	PRJNA924320	55176	162	0.902655	1.4623011	Bacillati	1783272	Bacteria	Bacteria	41.2	0.0435	NR	MEI7510949.1	2030811	g55034	i0	38	2.77777777777778	50	31	92.6	0	9	158	416	465	MEI7510949.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Peregrinibacteria bacterium]	diamond	450	41.6	0.990384615384615	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);;