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

5 rows where bioproject = "PRJNA741997" 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
23674498	23674498	PRJNA741997_P_NODE_40879_length_340_cov_0.865169_g39759_i0	PRJNA741997	40879	340	0.865169	2.9415746	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1958035545\|gb\|CP064978.1\|	2030811	g39759	i0	100	0.0882352941176471	30	0	9	0	63	92	915567	915596	MAG: Candidatus Peregrinibacteria bacterium isolate Fred_18-Q3-R57-64_BAT3C.1_cln chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota			Candidatus Peregrinibacteria bacterium
27410592	27410592	PRJNA741997_P_NODE_78423_length_247_cov_1.770115_g77303_i0	PRJNA741997	78423	247	1.770115	4.37218405	Pseudomonadati	3379134	Bacteria	Bacteria	47.8	5.96e-4	NR	MDD5025828.1	2735830	g77303	i0	42.1	1.63967611336032	38	22	46.2	0	57	170	55	92	MDD5025828.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	405	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae bacterium
27968494	27968494	PRJNA741997_P_NODE_37025_length_357_cov_1.084507_g35905_i0	PRJNA741997	37025	357	1.084507	3.87168999	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	61.2	4.5e-8	NR	MDD4318729.1	2735830	g35905	i0	45.8	0.495798319327731	59	32	49.6	0	189	13	468	526	MDD4318729.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium]	diamond	177	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae bacterium
30715958	30715958	PRJNA741997_P_NODE_68814_length_257_cov_1.880435_g67694_i0	PRJNA741997	68814	257	1.880435	4.83271795	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	69.3	1.93e-11	NR	MBI5411671.1	2030811	g67694	i0	53.3	4.86770428015564	60	28	70	0	193	14	431	490	MBI5411671.1 type I DNA topoisomerase [Candidatus Peregrinibacteria bacterium]	diamond	1251	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota			Candidatus Peregrinibacteria bacterium
31727600	31727600	PRJNA741997_P_NODE_88457_length_242_cov_0.869822_g87337_i0	PRJNA741997	88457	242	0.869822	2.10496924	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	42.7	0.038	NR	MBI5412284.1	2030811	g87337	i0	34.4	0.756198347107438	61	38	75.6	1	216	34	1467	1525	MBI5412284.1 Ig-like domain-containing protein [Candidatus Peregrinibacteria bacterium]	diamond	183	42.7	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);;