metadata: contig_metadata: 14 rows where bioproject = "PRJNA986481" and tax

14 rows where bioproject = "PRJNA986481" 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
4801550	4801550	PRJNA986481_P_NODE_41124_length_262_cov_1.309859_g40599_i0	PRJNA986481	41124	262	1.309859	3.43183058	Nitrosophilus kaiyonis	2930200	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2329051130\|dbj\|AP025696.1\|	2930200	g40599	i0	100	0.106870229007634	28	0	11	0	175	202	680831	680858	Nitrosophilus sp. MOT50 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitrosophilus	Nitrosophilus kaiyonis
6076744	6076744	PRJNA986481_P_NODE_31965_length_289_cov_1.683333_g31440_i0	PRJNA986481	31965	289	1.683333	4.86483237	Campylobacterales bacterium	2268180	Bacteria	Bacteria	153	3.58e-41	NR	MBD3840670.1	2268180	g31440	i0	78.6	2.65743944636678	84	18	87.2	0	253	2	357	440	MBD3840670.1 5-histidylcysteine sulfoxide synthase [Campylobacterales bacterium]	diamond	768	153	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
6076771	6076771	PRJNA986481_P_NODE_33565_length_282_cov_1.690987_g33040_i0	PRJNA986481	33565	282	1.690987	4.76858334	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1679706893\|gb\|CP021072.1\|	1032070	g33040	i0	100	0.198581560283688	28	0	10	0	74	101	210876	210849	Arcobacter cryaerophilus ATCC 43158 strain LMG 9904 genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
8626988	8626988	PRJNA986481_P_NODE_62447_length_227_cov_6.707865_g61922_i0	PRJNA986481	62447	227	6.707865	15.22685355	Arcobacter ellisii	913109	Bacteria	Bacteria	385	1.76e-102	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g61922	i0	100	353.753303964758	208	0	92	0	20	227	953668	953875	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	80302	385	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
9901405	9901405	PRJNA986481_P_NODE_14428_length_431_cov_16.808901_g13903_i0	PRJNA986481	14428	431	16.808901	72.44636331	Helicobacter pylori	210	Bacteria	Bacteria	58.4	8.94e-4	NTclustered	gi\|2641629600\|gb\|CP078226.1\|	210	g13903	i0	100	0.359628770301624	31	0	7	0	76	106	1619221	1619191	Helicobacter pylori strain HpGP-USA-204 chromosome, complete genome	blastn	155	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
23925987	23925987	PRJNA986481_P_NODE_28019_length_310_cov_1.402299_g27494_i0	PRJNA986481	28019	310	1.402299	4.3471269	Campylobacter sp. GTC17093	3382266	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2866683719\|dbj\|AP038832.1\|	3382266	g27494	i0	100	0.2	30	0	10	0	263	292	694606	694577	Campylobacter sp. GTC17093 DNA, complete genome	blastn	62	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. GTC17093
23926454	23926454	PRJNA986481_P_NODE_56399_length_245_cov_1.030612_g55874_i0	PRJNA986481	56399	245	1.030612	2.5249994	Aliarcobacter butzleri	28197	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2305706618\|gb\|CP104378.1\|	28197	g55874	i0	100	0.114285714285714	28	0	11	0	34	61	523970	523943	Aliarcobacter butzleri strain P1100 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
28169376	28169376	PRJNA986481_P_NODE_3545_length_809_cov_4.463158_g3166_i0	PRJNA986481	3545	809	4.463158	36.10694822	Sulfuricurvum	286130	Bacteria	Bacteria	49.3	0.0064	NR	WP_013460495.1	148813	g3166	i0	34.4	0.637824474660074	61	40	22.6	0	108	290	81	141	WP_013460495.1 class I SAM-dependent methyltransferase [Sulfuricurvum kujiense]	diamond	516	49.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfuricurvum	Sulfuricurvum kujiense
28289561	28289561	PRJNA986481_P_NODE_22306_length_347_cov_2.147651_g21781_i0	PRJNA986481	22306	347	2.147651	7.45234897	Campylobacterota bacterium	2026809	Bacteria	Bacteria	75.9	1.4e-13	NR	MCL4431196.1	2026809	g21781	i0	68	0.432276657060519	50	16	43.2	0	327	178	255	304	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	150	75.9	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
28763234	28763234	PRJNA986481_P_NODE_37207_length_267_cov_1.376147_g36682_i0	PRJNA986481	37207	267	1.376147	3.67431249	Desulfurellaceae bacterium	2614253	Bacteria	Bacteria	42.7	0.0493	NR	MCE2487225.1	2614253	g36682	i0	31.3	0.752808988764045	67	41	75.3	1	42	242	260	321	MCE2487225.1 CocE/NonD family hydrolase [Desulfurellaceae bacterium]	diamond	201	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales	Desulfurellaceae		Desulfurellaceae bacterium
28763236	28763236	PRJNA986481_P_NODE_3787_length_788_cov_2.990528_g3402_i0	PRJNA986481	3787	788	2.990528	23.56536064	Campylobacterota bacterium	2026809	Bacteria	Bacteria	48.1	0.0302	NR	MCL4431195.1	2026809	g3402	i0	38.1	0.319796954314721	84	46	30.1	3	396	160	925	1007	MCL4431195.1 reverse transcriptase domain-containing protein [Campylobacterota bacterium]	diamond	252	48.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29773600	29773600	PRJNA986481_P_NODE_8551_length_557_cov_2.318898_g8042_i0	PRJNA986481	8551	557	2.318898	12.91626186	Sulfurimonas sp. RIFOXYB12_FULL_35_9	1802256	Bacteria	Bacteria	133	1.2499999999999998e-32	NR	WP_294879171.1	1802256	g8042	i0	46.2	0.850987432675045	158	77	85.1	4	22	495	168	317	WP_294879171.1 response regulator receiver domain [Sulfurimonas sp. RIFOXYB12_FULL_35_9]	diamond	474	133	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp. RIFOXYB12_FULL_35_9
29900238	29900238	PRJNA986481_P_NODE_8911_length_545_cov_7.465726_g8398_i0	PRJNA986481	8911	545	7.465726	40.6882067	Helicobacter pylori	210	Bacteria	Bacteria	102	1.89e-25	NR	GAA8993091.1	210	g8398	i0	97.9	0.258715596330275	47	1	25.9	0	123	263	1	47	GAA8993091.1 hypothetical protein Kyoto181A_6120 [Helicobacter pylori]	diamond	141	102	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30437419	30437419	PRJNA986481_P_NODE_24673_length_330_cov_3.021352_g24148_i0	PRJNA986481	24673	330	3.021352	9.9704616	Campylobacterota bacterium	2026809	Bacteria	Bacteria	70.1	2.46e-11	NR	MCL4431893.1	2026809	g24148	i0	33.6	0.972727272727273	107	66	96.4	4	9	326	329	431	MCL4431893.1 response regulator receiver domain [Campylobacterota bacterium]	diamond	321	70.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota 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);;