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

14 rows where bioproject = "PRJNA889065", 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
863345	863345	PRJNA889065_S_NODE_20681_length_214_cov_1.842105_g20443_i0	PRJNA889065	20681	214	1.842105	3.9421047	Arcobacter porcinus	1935204	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1739646276\|gb\|CP036246.2\|	1935204	g20443	i0	94.444	0.168224299065421	36	1	16	1	121	155	644646	644611	Arcobacter porcinus strain CCUG 56899 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter porcinus
8895107	8895107	PRJNA889065_S_NODE_4347_length_445_cov_3.485075_g4113_i0	PRJNA889065	4347	445	3.485075	15.50858375	Campylobacter	194	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|1153133932\|gb\|CP012548.1\|	1660067	g4113	i0	100	0.325842696629214	29	0	7	0	253	281	883498	883526	Campylobacter pinnipediorum subsp. pinnipediorum strain RM17262 chromosome, complete genome	blastn	145	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter pinnipediorum
16166007	16166007	PRJNA889065_S_NODE_10993_length_289_cov_2.764228_g10755_i0	PRJNA889065	10993	289	2.764228	7.98861892	Campylobacterota bacterium DY0563	3396279	Bacteria	Bacteria	60.2	1.6e-4	NTclustered	gi\|2901665857\|gb\|CP179914.1\|	3396279	g10755	i0	100	0.608996539792388	32	0	11	0	98	129	833143	833112	Campylobacterota bacterium DY0563 chromosome, complete genome	blastn	176	60.2	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium DY0563
23815518	23815518	PRJNA889065_S_NODE_20299_length_216_cov_1.722543_g20061_i0	PRJNA889065	20299	216	1.722543	3.72069288	Campylobacter concisus	199	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|1376253191\|gb\|CP021643.1\|	199	g20061	i0	100	0.12962962962963	28	0	13	0	79	106	12463	12436	Campylobacter concisus strain P2CDO4 plasmid pICON, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
26612168	26612168	PRJNA889065_S_NODE_35021_length_161_cov_2.338983_g34783_i0	PRJNA889065	35021	161	2.338983	3.7657626300000002	Sulfurospirillum tamanense	2813362	Bacteria	Bacteria	99	8.579999999999999e-23	NR	WP_205459584.1	2813362	g34783	i0	94.3	0.987577639751553	53	3	98.8	0	2	160	125	177	WP_205459584.1 tetrahydrodipicolinate N-succinyltransferase N-terminal domain-containing protein [Sulfurospirillum tamanense]	diamond	159	99	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum tamanense
28161149	28161149	PRJNA889065_S_NODE_8805_length_321_cov_2.025180_g8567_i0	PRJNA889065	8805	321	2.02518	6.5008278	Helicobacter pylori	210	Bacteria	Bacteria	45.8	0.00222	NR	GAA9248560.1	210	g8567	i0	69	0.271028037383178	29	9	27.1	0	254	168	13	41	GAA9248560.1 hypothetical protein Kyoto199A_1460 [Helicobacter pylori]	diamond	87	45.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28760745	28760745	PRJNA889065_S_NODE_39507_length_151_cov_1.194444_g39269_i0	PRJNA889065	39507	151	1.194444	1.80361044	Helicobacter pylori	210	Bacteria	Bacteria	77	3.79e-17	NR	GAA9180441.1	210	g39269	i0	77.3	1.64900662251656	44	9	87.4	1	134	3	1	43	GAA9180441.1 hypothetical protein Kyoto193A_2360 [Helicobacter pylori]	diamond	249	77	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29644512	29644512	PRJNA889065_S_NODE_19770_length_219_cov_1.568182_g19532_i0	PRJNA889065	19770	219	1.568182	3.43431858	Helicobacter pylori	210	Bacteria	Bacteria	63.5	5.46e-11	NR	GAA6860864.1	210	g19532	i0	63.5	1.41095890410959	52	16	67.1	2	1	147	31	82	GAA6860864.1 hypothetical protein Kyoto206A_1490 [Helicobacter pylori]	diamond	309	63.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30655733	30655733	PRJNA889065_S_NODE_16333_length_240_cov_2.918782_g16095_i0	PRJNA889065	16333	240	2.918782	7.0050768	Helicobacter pylori	210	Bacteria	Bacteria	43.5	0.0018600000000000001	NR	GAA9193880.1	210	g16095	i0	62.1	0.3625	29	11	36.3	0	229	143	32	60	GAA9193880.1 hypothetical protein Kyoto193A_3910 [Helicobacter pylori]	diamond	87	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30655747	30655747	PRJNA889065_S_NODE_7933_length_337_cov_6.193878_g7695_i0	PRJNA889065	7933	337	6.193878	20.87336886	Helicobacter pylori	210	Bacteria	Bacteria	134	2.16e-38	NR	WP_322538256.1	210	g7695	i0	95.5	0.596439169139466	67	3	59.6	0	1	201	41	107	WP_322538256.1 hypothetical protein, partial [Helicobacter pylori]	diamond	201	134	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30782190	30782190	PRJNA889065_S_NODE_23214_length_202_cov_1.446541_g22976_i0	PRJNA889065	23214	202	1.446541	2.92201282	Sulfurimonas sp. hsl 1-7	3058392	Bacteria	Bacteria	88.2	8.53e-19	NR	WP_304544073.1	3058392	g22976	i0	62.1	0.98019801980198	66	25	98	0	2	199	25	90	WP_304544073.1 UDP-glucose 4-epimerase GalE [Sulfurimonas sp. hsl 1-7]	diamond	198	88.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas microaerophilic
31137307	31137307	PRJNA889065_S_NODE_4235_length_449_cov_4.376847_g4001_i0	PRJNA889065	4235	449	4.376847	19.65204303	Bacteria	2	Bacteria	Bacteria	47.4	0.00673	NR	WP_128986689.1	1054034	g4001	i0	29.7	2.74610244988864	138	88	89.5	4	448	47	112	244	WP_128986689.1 thiolase family protein [Arcobacter cloacae]	diamond	1233	47.8	0.99163179916318	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter cloacae
32490152	32490152	PRJNA889065_S_NODE_14099_length_258_cov_1.888372_g13861_i0	PRJNA889065	14099	258	1.888372	4.87199976	Helicobacter pylori	210	Bacteria	Bacteria	52.8	8.96e-7	NR	GAA9237335.1	210	g13861	i0	41.8	0.779069767441861	67	39	77.9	0	204	4	2	68	GAA9237335.1 hypothetical protein Kyoto198A_5510 [Helicobacter pylori]	diamond	201	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32773597	32773597	PRJNA889065_S_NODE_13360_length_264_cov_1.868778_g13122_i0	PRJNA889065	13360	264	1.868778	4.93357392	Helicobacter pylori	210	Bacteria	Bacteria	51.2	4.03e-6	NR	GAA8565153.1	210	g13122	i0	91.3	0.261363636363636	23	2	26.1	0	69	1	39	61	GAA8565153.1 hypothetical protein oki142_14710 [Helicobacter pylori]	diamond	69	51.2	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);;