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

4 rows where bioproject = "PRJNA690592", 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
27683015	27683015	PRJNA690592_S_NODE_149724_length_277_cov_1.509804_g148710_i0	PRJNA690592	149724	277	1.509804	4.18215708	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	57.4	2.15e-8	NR	MBI5152798.1	2030811	g148710	i0	52.5	0.63898916967509	59	27	62.8	1	23	196	19	77	MBI5152798.1 RNA-binding protein [Candidatus Peregrinibacteria bacterium]	diamond	177	57.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
29083479	29083479	PRJNA690592_S_NODE_88488_length_344_cov_1.649446_g87474_i0	PRJNA690592	88488	344	1.649446	5.67409424	Bacteria	2	Bacteria	Bacteria	45.4	0.0128	NR	QQR83436.1	2030811	g87474	i0	35.3	1.55232558139535	85	53	73.3	2	313	62	441	524	QQR83436.1 MAG: hypothetical protein IPJ72_06645 [Candidatus Peregrinibacteria bacterium]	diamond	534	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
30252067	30252067	PRJNA690592_S_NODE_76452_length_366_cov_1.576792_g75438_i0	PRJNA690592	76452	366	1.576792	5.77105872	Bacteria	2	Bacteria	Bacteria	114	4.26e-28	NR	MBI5412353.1	2030811	g75438	i0	52.8	2.01639344262295	123	54	100	2	366	1	141	260	MBI5412353.1 uridine phosphorylase [Candidatus Peregrinibacteria bacterium]	diamond	738	114	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
30650896	30650896	PRJNA690592_S_NODE_147753_length_279_cov_1.116505_g146739_i0	PRJNA690592	147753	279	1.116505	3.11504895	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	58.2	3.65e-8	NR	MCB9809857.1	2053688	g146739	i0	60.4	0.516129032258065	48	17	49.5	1	279	142	99	146	MCB9809857.1 50S ribosomal protein L13 [Candidatus Peribacteria bacterium]	diamond	144	58.2	1	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);;