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

8 rows where bioproject = "PRJNA946307", 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_order	tax_species
7305329	7305329	PRJNA946307_P_NODE_40346_length_212_cov_4.766871_g39472_i0	PRJNA946307	40346	212	4.766871	10.10576652	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	187	4.9e-43	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g39472	i0	84.103	92.7075471698113	195	30	92	1	19	212	627371	627177	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	19654	187	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria		Candidatus Peribacteria bacterium
27853362	27853362	PRJNA946307_P_NODE_70844_length_199_cov_3.060000_g69970_i0	PRJNA946307	70844	199	3.06	6.0894	Bacteria	2	Bacteria	Bacteria	75.5	6.03e-14	NR	OGJ82098.1	1801940	g69970	i0	40.5	3.49748743718593	116	14	92	1	184	2	439	554	OGJ82098.1 MAG: hypothetical protein A3J91_05125, partial [Candidatus Peribacteria bacterium RIFOXYC2_FULL_58_10]	diamond	696	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria		Candidatus Peribacteria bacterium RIFOXYC2_FULL_58_10
28604503	28604503	PRJNA946307_P_NODE_142907_length_166_cov_3.222222_g142033_i0	PRJNA946307	142907	166	3.222222	5.34888852	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	92.8	3.03e-20	NR	HVW66523.1	2735830	g142033	i0	86.3	0.921686746987952	51	7	92.2	0	1	153	243	293	HVW66523.1 ribonuclease J [Candidatus Peribacteraceae bacterium]	diamond	153	92.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae bacterium
28793800	28793800	PRJNA946307_P_NODE_168867_length_157_cov_2.638889_g167993_i0	PRJNA946307	168867	157	2.638889	4.14305573	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	45.8	3.21e-4	NR	MBI2636288.1	2030811	g167993	i0	56.8	0.840764331210191	44	16	84.1	1	152	21	77	117	MBI2636288.1 diacylglycerol kinase [Candidatus Peregrinibacteria bacterium]	diamond	132	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota			Candidatus Peregrinibacteria bacterium
28856943	28856943	PRJNA946307_P_NODE_43348_length_211_cov_3.413580_g42474_i0	PRJNA946307	43348	211	3.41358	7.2026538	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	63.9	2.25e-10	NR	MDB4978035.1	2053688	g42474	i0	82.1	0.398104265402844	28	5	39.8	0	98	15	50	77	MDB4978035.1 recombinase [Candidatus Peribacteria bacterium]	diamond	84	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria		Candidatus Peribacteria bacterium
29899231	29899231	PRJNA946307_P_NODE_61351_length_204_cov_5.554839_g60477_i0	PRJNA946307	61351	204	5.554839	11.33187156	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	84.3	4.35e-17	NR	MDD4627855.1	2735830	g60477	i0	53.3	4.04411764705882	92	14	92.6	1	15	203	368	459	MDD4627855.1 UDP-N-acetylglucosamine 2-epimerase [Candidatus Peribacteraceae bacterium]	diamond	825	84.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae bacterium
30663998	30663998	PRJNA946307_P_NODE_147433_length_165_cov_2.456897_g146559_i0	PRJNA946307	147433	165	2.456897	4.05388005	Bacteria	2	Bacteria	Bacteria	48.9	8.1e-5	NR	MEI7510720.1	2030811	g146559	i0	48.8	5.96363636363636	43	22	78.2	0	24	152	93	135	MEI7510720.1 tRNA pseudouridine(55) synthase TruB [Candidatus Peregrinibacteria bacterium]	diamond	984	49.3	0.991886409736308	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota			Candidatus Peregrinibacteria bacterium
32460003	32460003	PRJNA946307_P_NODE_37819_length_216_cov_1.161677_g36945_i0	PRJNA946307	37819	216	1.161677	2.50922232	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	108	1.17e-25	NR	HVW66650.1	2735830	g36945	i0	79.4	0.875	63	13	87.5	0	202	14	191	253	HVW66650.1 translational GTPase TypA [Candidatus Peribacteraceae bacterium]	diamond	189	108	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales	Candidatus Peribacteraceae 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);;