metadata: contig_metadata: 14 rows where bioproject = "PRJNA773778", tax_phylum = "Campylobacterota" and tax

14 rows where bioproject = "PRJNA773778", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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
5035575	5035575	PRJNA773778_S_NODE_21044_length_323_cov_1.312000_g20894_i0	PRJNA773778	21044	323	1.312	4.23776	Bacteria	2	Bacteria	Bacteria	592	1.4499999999999999e-164	NTclustered	gi\|2323240586\|gb\|CP109819.1\|	195	g20894	i0	99.69	101.188854489164	323	1	100	0	1	323	741052	740730	Campylobacter coli strain CC21NB04a chromosome, complete genome	blastn	32684	592	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
13961284	13961284	PRJNA773778_S_NODE_43431_length_247_cov_0.885057_g43281_i0	PRJNA773778	43431	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	63.9	1.03e-5	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g43281	i0	100	16.4048582995951	34	0	14	0	214	247	1292721	1292688	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	4052	63.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
20333746	20333746	PRJNA773778_S_NODE_34296_length_268_cov_2.400000_g34146_i0	PRJNA773778	34296	268	2.4	6.432	root	1	Root_unresolved	Root_unresolved	427	3.49e-115	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g34146	i0	99.573	89.1940298507463	234	1	87	0	35	268	1303418	1303185	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	23904	427	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25433895	25433895	PRJNA773778_S_NODE_17560_length_345_cov_3.400735_g17410_i0	PRJNA773778	17560	345	3.400735	11.73253575	Campylobacter	194	Bacteria	Bacteria	545	1.23e-150	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g17410	i0	95.349	11.9130434782609	344	15	99	1	1	343	1523064	1523407	Campylobacter rectus strain ATCC 33238, complete genome	blastn	4110	545	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
26936234	26936234	PRJNA773778_S_NODE_43782_length_247_cov_0.844828_g43632_i0	PRJNA773778	43782	247	0.844828	2.08672516	root	1	Root_unresolved	Root_unresolved	101	5.87e-24	NR	GAA6899356.1	210	g43632	i0	75.4	23.4655870445344	69	17	83.8	0	214	8	44	112	GAA6899356.1 hypothetical protein Kyoto207A_1070 [Helicobacter pylori]	diamond	5796	101	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28569174	28569174	PRJNA773778_S_NODE_49207_length_234_cov_2.273292_g49057_i0	PRJNA773778	49207	234	2.273292	5.31950328	Helicobacter pylori	210	Bacteria	Bacteria	47	1.45e-4	NR	GAA9208316.1	210	g49057	i0	60.5	1.65384615384615	43	17	55.1	0	186	58	3	45	GAA9208316.1 hypothetical protein Kyoto198A_0220 [Helicobacter pylori]	diamond	387	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30021932	30021932	PRJNA773778_S_NODE_36531_length_261_cov_2.250000_g36381_i0	PRJNA773778	36531	261	2.25	5.8725	Arcobacter sp.	1872629	Bacteria	Bacteria	63.5	2.24e-10	NR	MCP4969891.1	1872629	g36381	i0	43.1	0.827586206896552	72	40	81.6	1	257	45	57	128	MCP4969891.1 hypothetical protein [Arcobacter sp.]	diamond	216	63.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp.
30274780	30274780	PRJNA773778_S_NODE_11252_length_411_cov_2.005917_g11102_i0	PRJNA773778	11252	411	2.005917	8.24431887	Helicobacter pylori	210	Bacteria	Bacteria	89.7	4.72e-19	NR	GAB0054170.1	210	g11102	i0	67.7	1.81021897810219	62	20	45.3	0	333	148	146	207	GAB0054170.1 hypothetical protein YGH029_14930 [Helicobacter pylori]	diamond	744	89.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30274788	30274788	PRJNA773778_S_NODE_6972_length_491_cov_0.811005_g6822_i0	PRJNA773778	6972	491	0.811005	3.98203455	Helicobacter pylori	210	Bacteria	Bacteria	73.2	2.57e-13	NR	GAA6899797.1	210	g6822	i0	60.9	0.391038696537678	64	25	39.1	0	390	199	54	117	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	192	73.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30338185	30338185	PRJNA773778_S_NODE_44052_length_246_cov_1.277457_g43902_i0	PRJNA773778	44052	246	1.277457	3.14254422	Helicobacter pylori	210	Bacteria	Bacteria	48.1	6.48e-5	NR	GAA8686254.1	210	g43902	i0	100	0.292682926829268	24	0	29.3	0	206	135	1	24	GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori]	diamond	72	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30338186	30338186	PRJNA773778_S_NODE_44372_length_246_cov_0.890173_g44222_i0	PRJNA773778	44372	246	0.890173	2.18982558	Campylobacter sp.	205	Bacteria	Bacteria	119	1.9999999999999998e-33	NR	WP_321231676.1	205	g44222	i0	93	0.695121951219512	57	4	69.5	0	46	216	1	57	WP_321231676.1 hypothetical protein [Campylobacter sp.]	diamond	171	119	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp.
30947741	30947741	PRJNA773778_S_NODE_48714_length_241_cov_0.875000_g48564_i0	PRJNA773778	48714	241	0.875	2.10875	root	1	Root_unresolved	Root_unresolved	60.8	9.37e-10	NR	GAA6966350.1	210	g48564	i0	62.7	3.06224066390041	51	19	63.5	0	53	205	5	55	GAA6966350.1 hypothetical protein Kyoto211A_2690 [Helicobacter pylori]	diamond	738	61.2	0.993464052287582	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31253990	31253990	PRJNA773778_S_NODE_32395_length_275_cov_0.787129_g32245_i0	PRJNA773778	32395	275	0.787129	2.16460475	Helicobacter pylori	210	Bacteria	Bacteria	40.4	0.0385	NR	GAA8959078.1	210	g32245	i0	45.1	0.556363636363636	51	27	54.5	1	214	65	4	54	GAA8959078.1 hypothetical protein Kyoto181A_3410 [Helicobacter pylori]	diamond	153	40.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31854940	31854940	PRJNA773778_S_NODE_45377_length_245_cov_0.877907_g45227_i0	PRJNA773778	45377	245	0.877907	2.15087215	Helicobacter pylori	210	Bacteria	Bacteria	55.8	9.02e-8	NR	GAA8918764.1	210	g45227	i0	67.5	1.46938775510204	40	13	49	0	235	116	56	95	GAA8918764.1 hypothetical protein Kyoto166A_3530 [Helicobacter pylori]	diamond	360	55.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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