metadata: contig_metadata: 8 rows where bioproject = "PRJNA757618", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA757618", 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
2008221	2008221	PRJNA757618_P_NODE_12022_length_328_cov_1.215686_g10970_i0	PRJNA757618	12022	328	1.215686	3.98745008	Campylobacter jejuni	197	Bacteria	Bacteria	207	5.149999999999999e-67	NR	MEA8955119.1	197	g10970	i0	97.2	0.996951219512195	109	3	99.7	0	327	1	12	120	MEA8955119.1 GMP synthase (glutamine-hydrolyzing) [Campylobacter jejuni]	diamond	327	207	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
5836090	5836090	PRJNA757618_P_NODE_31505_length_250_cov_0.881356_g30453_i0	PRJNA757618	31505	250	0.881356	2.20339	Campylobacter gracilis	824	Bacteria	Bacteria	418	1.9399999999999998e-112	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g30453	i0	96.8	2	250	8	100	0	1	250	1884549	1884300	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	500	418	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
8855579	8855579	PRJNA757618_P_NODE_46107_length_243_cov_0.911765_g45055_i0	PRJNA757618	46107	243	0.911765	2.21558895	Campylobacter	194	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g45055	i0	100	230.288065843621	243	0	100	0	1	243	1541	1299	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	55960	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
26650987	26650987	PRJNA757618_P_NODE_10501_length_346_cov_1.630037_g9449_i0	PRJNA757618	10501	346	1.630037	5.63992802	Bacteria	2	Bacteria	Bacteria	136	4.569999999999999e-37	NR	MBV5277773.1	2268179	g9449	i0	60	1.95086705202312	110	44	95.4	0	2	331	36	145	MBV5277773.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	675	137	0.992700729927007	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
27842468	27842468	PRJNA757618_P_NODE_22444_length_267_cov_1.206186_g21392_i0	PRJNA757618	22444	267	1.206186	3.22051662	Helicobacter pylori	210	Bacteria	Bacteria	58.5	3.04e-9	NR	GAA6859275.1	210	g21392	i0	45.6	1.52808988764045	68	12	76.4	1	236	33	1	43	GAA6859275.1 hypothetical protein Kyoto206A_0900 [Helicobacter pylori]	diamond	408	58.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27968925	27968925	PRJNA757618_P_NODE_24025_length_261_cov_1.526596_g22973_i0	PRJNA757618	24025	261	1.526596	3.98441556	Helicobacter pylori	210	Bacteria	Bacteria	56.2	3.22e-8	NR	GAA6775601.1	210	g22973	i0	55.1	0.563218390804598	49	22	56.3	0	238	92	1	49	GAA6775601.1 hypothetical protein Kyoto199A_4750 [Helicobacter pylori]	diamond	147	56.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30969378	30969378	PRJNA757618_P_NODE_14354_length_307_cov_1.700855_g13302_i0	PRJNA757618	14354	307	1.700855	5.22162485	Campylobacter jejuni	197	Bacteria	Bacteria	48.1	1.76e-4	NR	MFK0578766.1	197	g13302	i0	53.5	0.420195439739414	43	20	42	0	3	131	67	109	MFK0578766.1 hypothetical protein [Campylobacter jejuni]	diamond	129	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
32551007	32551007	PRJNA757618_P_NODE_13439_length_315_cov_0.983471_g12387_i0	PRJNA757618	13439	315	0.983471	3.09793365	Campylobacter jejuni	197	Bacteria	Bacteria	52	1.39e-5	NR	WP_323470850.1	197	g12387	i0	36.1	0.685714285714286	72	42	65.7	2	6	212	74	144	WP_323470850.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	216	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni

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