metadata: contig_metadata: 5 rows where bioproject = "PRJNA641707" and tax_phylum = "Candidatus Peregrinibacteriota"

5 rows where bioproject = "PRJNA641707" 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_genus	tax_species
8266568	8266568	PRJNA641707_P_NODE_209547_length_195_cov_11.705479_g206884_i0	PRJNA641707	209547	195	11.705479	22.82568405	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	75	3.6e-9	NTclustered	gi\|1958006436\|gb\|CP064962.1\|	2030811	g206884	i0	88.525	3.11282051282051	61	7	31	0	135	195	211916	211856	MAG: Candidatus Peregrinibacteria bacterium isolate Aved_18-Q3-R54-62_BAT3C.344 chromosome, complete genome	blastn	607	75	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
13370277	13370277	PRJNA641707_P_NODE_339011_length_150_cov_8.029703_g336348_i0	PRJNA641707	339011	150	8.029703	12.0445545	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	99	1.55e-16	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g336348	i0	84.615	4.70666666666667	104	11	68	5	48	149	813885	813785	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	706	99	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria			Candidatus Peribacteria bacterium
17194761	17194761	PRJNA641707_P_NODE_60854_length_272_cov_21.470852_g58193_i0	PRJNA641707	60854	272	21.470852	58.40071744	Candidatus Peribacter riflensis	1735162	Bacteria	Bacteria	99	3.16e-16	NTclustered	gi\|946529367\|gb\|CP013062.1\|	1735162	g58193	i0	86.813	16.8786764705882	91	9	32	3	166	253	972988	972898	MAG: Candidatus Peribacter riflensis, complete genome	blastn	4591	99	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacter	Candidatus Peribacter riflensis
18467455	18467455	PRJNA641707_P_NODE_296675_length_165_cov_4.284483_g294012_i0	PRJNA641707	296675	165	4.284483	7.06939695	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	73.1	1.06e-8	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g294012	i0	100	0.690909090909091	39	0	24	0	23	61	627457	627419	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	114	73.1	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria			Candidatus Peribacteria bacterium
32326232	32326232	PRJNA641707_P_NODE_69699_length_251_cov_6.094059_g67036_i0	PRJNA641707	69699	251	6.094059	15.29608809	Candidatus Peregrinibacteria bacterium GW2	2030811	Bacteria	Bacteria	52.8	4.51e-6	NR	KKT76633.1	1619057	g67036	i0	60	0.47808764940239	40	16	47.8	0	74	193	120	159	KKT76633.1 MAG: hypothetical protein UW70_C0016G0012 [Candidatus Peregrinibacteria bacterium GW2011_GWA2_44_7]	diamond	120	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium GW2011_GWA2_44_7

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);;