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

9 rows where bioproject = "PRJNA917598", 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
3446817	3446817	PRJNA917598_P_NODE_39023_length_367_cov_3.598639_g38079_i0	PRJNA917598	39023	367	3.598639	13.20700513	Bacteria	2	Bacteria	Bacteria	81.3	3.84e-15	NR	MCA9378390.1	2030811	g38079	i0	88.1	1.0299727520436	42	5	34.3	0	202	327	6	47	MCA9378390.1 hypothetical protein [Candidatus Peregrinibacteria bacterium]	diamond	378	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
17473714	17473714	PRJNA917598_P_NODE_22594_length_488_cov_1.484337_g21652_i0	PRJNA917598	22594	488	1.484337	7.24356456	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	243	2.63e-59	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g21652	i0	75.967	1.30327868852459	491	106	99	9	3	487	759675	759191	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	636	243	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
21299260	21299260	PRJNA917598_P_NODE_95017_length_241_cov_1.452381_g94073_i0	PRJNA917598	95017	241	1.452381	3.50023821	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	261	3.31e-65	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g94073	i0	89.1	88.9460580912863	211	21	87	2	32	241	626061	625852	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	21436	261	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
28351018	28351018	PRJNA917598_P_NODE_29146_length_426_cov_1.742210_g28202_i0	PRJNA917598	29146	426	1.74221	7.4218146	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	45.4	0.0203	NR	MDR2189677.1	2053688	g28202	i0	40	0.422535211267606	60	36	42.3	0	133	312	176	235	MDR2189677.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	180	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
29930068	29930068	PRJNA917598_P_NODE_5691_length_1022_cov_1.730242_g4973_i0	PRJNA917598	5691	1022	1.730242	17.68307324	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	162	4.87e-43	NR	PCI25124.1	2030811	g4973	i0	38	0.73385518590998	250	143	71.6	5	772	41	9	252	PCI25124.1 MAG: hypothetical protein COB57_02820 [Candidatus Peregrinibacteria bacterium]	diamond	750	162	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
30341148	30341148	PRJNA917598_P_NODE_83872_length_248_cov_2.457143_g82928_i0	PRJNA917598	83872	248	2.457143	6.09371464	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	51.2	3.13e-6	NR	MDR2411065.1	2053688	g82928	i0	54	0.604838709677419	50	23	60.5	0	23	172	19	68	MDR2411065.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	150	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
30593280	30593280	PRJNA917598_P_NODE_79033_length_252_cov_1.089385_g78089_i0	PRJNA917598	79033	252	1.089385	2.7452502	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	72.8	1.15e-14	NR	MDR1987693.1	2053688	g78089	i0	50.7	0.845238095238095	71	34	83.3	1	252	43	13	83	MDR1987693.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	213	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
31036017	31036017	PRJNA917598_P_NODE_76515_length_258_cov_1.086486_g75571_i0	PRJNA917598	76515	258	1.086486	2.80313388	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	42.7	0.0033	NR	MDR1988544.1	2053688	g75571	i0	56.3	0.372093023255814	32	14	37.2	0	139	44	14	45	MDR1988544.1 hypothetical protein [Candidatus Peribacteria bacterium]	diamond	96	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
31106062	31106062	PRJNA917598_P_NODE_40535_length_360_cov_2.282230_g39591_i0	PRJNA917598	40535	360	2.28223	8.216028	Bacteria	2	Bacteria	Bacteria	50.8	2.96e-5	NR	USN57755.1	2053688	g39591	i0	45.7	1.15	46	25	38.3	0	141	278	27	72	USN57755.1 MAG: hypothetical protein H6767_05195 [Candidatus Peribacteria bacterium]	diamond	414	50.8	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);;