metadata: contig_metadata: 16 rows where bioproject = "PRJNA312107", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA312107", 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
2928217	2928217	PRJNA312107_P_NODE_20963_length_167_cov_0.881356_g20797_i0	PRJNA312107	20963	167	0.881356	1.47186452	Campylobacter ureolyticus	827	Bacteria	Bacteria	300	4.53e-77	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g20797	i0	98.817	3.03592814371257	169	0	100	1	1	167	849175	849343	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	507	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
5481079	5481079	PRJNA312107_P_NODE_22025_length_166_cov_0.888889_g21859_i0	PRJNA312107	22025	166	0.888889	1.47555574	Campylobacter ureolyticus	827	Bacteria	Bacteria	101	1.9599999999999994e-23	NR	WP_269499316.1	827	g21859	i0	100	0.975903614457831	54	0	97.6	0	164	3	126	179	WP_269499316.1 anaerobic C4-dicarboxylate transporter [Campylobacter ureolyticus]	diamond	162	101	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
7441562	7441562	PRJNA312107_P_NODE_17406_length_175_cov_1.238095_g17240_i0	PRJNA312107	17406	175	1.238095	2.16666625	Campylobacter	194	Bacteria	Bacteria	311	2.2e-80	NTclustered	gi\|1861376917\|gb\|CP053828.1\|	91353	g17240	i0	98.851	237.965714285714	174	2	99	0	2	175	360504	360331	Campylobacter hyointestinalis subsp. lawsonii strain CHY5 chromosome, complete genome	blastn	41644	311	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hyointestinalis
13131366	13131366	PRJNA312107_P_NODE_22231_length_166_cov_0.888889_g22065_i0	PRJNA312107	22231	166	0.888889	1.47555574	Campylobacter ureolyticus	827	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g22065	i0	100	3	166	0	100	0	1	166	1311987	1312152	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	498	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
13817033	13817033	PRJNA312107_P_NODE_23371_length_164_cov_1.678261_g23205_i0	PRJNA312107	23371	164	1.678261	2.75234804	Aliarcobacter	2321111	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g23205	i0	100	370.94512195122	164	0	100	0	1	164	141	304	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	60835	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
16366094	16366094	PRJNA312107_P_NODE_17093_length_177_cov_0.765625_g16927_i0	PRJNA312107	17093	177	0.765625	1.35515625	Campylobacter	194	Bacteria	Bacteria	316	4.799999999999999e-82	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g16927	i0	98.87	249.045197740113	177	2	100	0	1	177	1034197	1034373	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	44081	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
17641271	17641271	PRJNA312107_P_NODE_16374_length_181_cov_1.181818_g16208_i0	PRJNA312107	16374	181	1.181818	2.13909058	Campylobacterales	213849	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|434932\|emb\|X67760.1\|	202	g16208	i0	100	365.795580110497	181	0	100	0	1	181	583	403	C.mucosalis 23S rRNA gene	blastn	66209	335	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter mucosalis
21465359	21465359	PRJNA312107_P_NODE_25637_length_162_cov_0.920354_g25471_i0	PRJNA312107	25637	162	0.920354	1.49097348	Arcobacteraceae	2808963	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g25471	i0	98.765	399.339506172839	162	2	100	0	1	162	1733648	1733487	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	64693	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
24015467	24015467	PRJNA312107_P_NODE_19079_length_169_cov_0.866667_g18913_i0	PRJNA312107	19079	169	0.866667	1.46466723	Campylobacter	194	Bacteria	Bacteria	281	1.65e-71	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g18913	i0	97.006	2.96449704142012	167	5	99	0	1	167	1233773	1233607	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	501	281	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
24603659	24603659	PRJNA312107_P_NODE_21700_length_166_cov_0.888889_g21534_i0	PRJNA312107	21700	166	0.888889	1.47555574	Campylobacter ureolyticus	827	Bacteria	Bacteria	285	1.26e-72	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g21534	i0	97.59	4	166	4	100	0	1	166	804484	804319	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	664	285	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
27674707	27674707	PRJNA312107_P_NODE_23604_length_164_cov_0.904348_g23438_i0	PRJNA312107	23604	164	0.904348	1.48313072	Desulfurellales bacterium	2482794	Bacteria	Bacteria	96.7	1.3399999999999999e-24	NR	TXH56862.1	2482794	g23438	i0	91.8	0.896341463414634	49	4	89.6	0	16	162	18	66	TXH56862.1 MAG: hypothetical protein E6Q97_05560, partial [Desulfurellales bacterium]	diamond	147	96.7	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
29870685	29870685	PRJNA312107_P_NODE_23151_length_165_cov_0.896552_g22985_i0	PRJNA312107	23151	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	68.6	9.96e-12	NR	TXH47520.1	2482794	g22985	i0	55.8	8.49090909090909	52	23	94.5	0	157	2	576	627	TXH47520.1 MAG: ATP-dependent DNA helicase [Desulfurellales bacterium]	diamond	1401	68.6	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
30706038	30706038	PRJNA312107_P_NODE_23814_length_164_cov_0.904348_g23648_i0	PRJNA312107	23814	164	0.904348	1.48313072	Desulfurellales bacterium	2482794	Bacteria	Bacteria	65.9	8.77e-11	NR	TXH54718.1	2482794	g23648	i0	52.8	0.969512195121951	53	25	97	0	162	4	281	333	TXH54718.1 MAG: hypothetical protein E6Q97_10270 [Desulfurellales bacterium]	diamond	159	65.9	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
31116654	31116654	PRJNA312107_P_NODE_25175_length_163_cov_0.912281_g25009_i0	PRJNA312107	25175	163	0.912281	1.48701803	Desulfurellales bacterium	2482794	Bacteria	Bacteria	51.2	9.26e-6	NR	TXH43037.1	2482794	g25009	i0	64.4	0.828220858895706	45	16	82.8	0	23	157	83	127	TXH43037.1 MAG: hypothetical protein E6Q97_34840 [Desulfurellales bacterium]	diamond	135	51.2	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
32273410	32273410	PRJNA312107_P_NODE_26758_length_152_cov_2.330097_g26592_i0	PRJNA312107	26758	152	2.330097	3.54174744	Pseudomonadati	3379134	Bacteria	Bacteria	61.2	2.15e-10	NR	GAA9176272.1	210	g26592	i0	100	1.53947368421053	26	0	51.3	0	4	81	1	26	GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori]	diamond	234	61.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32540621	32540621	PRJNA312107_P_NODE_19019_length_169_cov_0.866667_g18853_i0	PRJNA312107	19019	169	0.866667	1.46466723	Desulfurellales bacterium	2482794	Bacteria	Bacteria	62.4	2.52e-10	NR	TXH50016.1	2482794	g18853	i0	48.2	0.994082840236686	56	29	99.4	0	168	1	62	117	TXH50016.1 MAG: hypothetical protein E6Q97_21245 [Desulfurellales bacterium]	diamond	168	62.4	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales 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);;