metadata: contig_metadata: 7 rows where bioproject = "PRJNA515078", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA515078", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
23439245	23439245	PRJNA515078_P_NODE_19219_length_198_cov_1.304348_g18986_i0	PRJNA515078	19219	198	1.304348	2.58260904	Helicobacter pylori	210	Bacteria	Bacteria	62.1	2.85e-5	NTclustered	gi\|2642558667\|gb\|CP079351.1\|	210	g18986	i0	91.304	2.68181818181818	46	2	23	2	98	142	1653785	1653829	Helicobacter pylori strain HpGP-MEX-043 chromosome, complete genome	blastn	531	62.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
24062919	24062919	PRJNA515078_P_NODE_32279_length_155_cov_0.983051_g32046_i0	PRJNA515078	32279	155	0.983051	1.52372905	Helicobacter cetorum	138563	Bacteria	Bacteria	78.2	1.71e-15	NR	WP_104748669.1	138563	g32046	i0	76.5	17.7677419354839	51	12	98.7	0	153	1	39	89	WP_104748669.1 ribose-phosphate pyrophosphokinase [Helicobacter cetorum]	diamond	2754	78.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cetorum
27171781	27171781	PRJNA515078_P_NODE_20262_length_193_cov_1.096154_g20029_i0	PRJNA515078	20262	193	1.096154	2.11557722	Helicobacter	209	Bacteria	Bacteria	42.4	0.0271	NR	WP_005220022.1	209	g20029	i0	68	0.38860103626943	25	8	38.9	0	2	76	50	74	WP_005220022.1 MULTISPECIES: BspA family leucine-rich repeat surface protein [Helicobacter]	diamond	75	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
29239968	29239968	PRJNA515078_P_NODE_29449_length_161_cov_1.217742_g29216_i0	PRJNA515078	29449	161	1.217742	1.96056462	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	1.7e-5	NR	NPA03392.1	2026809	g29216	i0	41.7	1.88198757763975	48	28	89.4	0	156	13	489	536	NPA03392.1 serpin family protein [Campylobacterota bacterium]	diamond	303	51.2	0.9921875	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29319235	29319235	PRJNA515078_P_NODE_9789_length_290_cov_1.233202_g9556_i0	PRJNA515078	9789	290	1.233202	3.5762858	Campylobacterota bacterium	2026809	Bacteria	Bacteria	72	1.87e-12	NR	MCL4431196.1	2026809	g9556	i0	37.6	0.962068965517241	93	55	95.2	2	4	279	2	92	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	279	72	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29413883	29413883	PRJNA515078_P_NODE_26089_length_170_cov_1.466165_g25856_i0	PRJNA515078	26089	170	1.466165	2.4924805	Poseidonibacter ostreae	2654171	Bacteria	Bacteria	51.6	1.03e-5	NR	WP_152189723.1	2654171	g25856	i0	48.9	2.73529411764706	47	24	82.9	0	28	168	415	461	WP_152189723.1 response regulator [Poseidonibacter ostreae]	diamond	465	51.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter ostreae
29856053	29856053	PRJNA515078_P_NODE_4431_length_457_cov_1.845238_g4199_i0	PRJNA515078	4431	457	1.845238	8.43273766	Campylobacter upsaliensis	28080	Bacteria	Bacteria	46.2	0.019	NR	EAM0278008.1	28080	g4199	i0	35.6	1.53610503282276	90	51	57.1	2	446	186	62	147	EAM0278008.1 hypothetical protein [Campylobacter upsaliensis]	diamond	702	46.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter upsaliensis

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