metadata: contig_metadata: 14 rows where bioproject = "PRJNA454503", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJNA454503", 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
4269419	4269419	PRJNA454503_P_NODE_37704_length_229_cov_2.321429_g37375_i0	PRJNA454503	37704	229	2.321429	5.31607241	Arcobacter sp. 15-2	3374109	Bacteria	Bacteria	379	8.249999999999999e-101	NTclustered	gi\|2862971141\|dbj\|AP038804.1\|	3374109	g37375	i0	96.507	245.864628820961	229	8	100	0	1	229	342180	341952	Arcobacter sp. 15-2 DNA, complete genome	blastn	56303	379	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. 15-2
16396287	16396287	PRJNA454503_P_NODE_45353_length_220_cov_2.823899_g45024_i0	PRJNA454503	45353	220	2.823899	6.2125778	Arcobacteraceae	2808963	Bacteria	Bacteria	398	2.1699999999999996e-106	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g45024	i0	99.541	368.090909090909	218	1	99	0	3	220	851612	851829	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	80980	401	0.992518703241895	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
18294626	18294626	PRJNA454503_P_NODE_89995_length_190_cov_2.015504_g89666_i0	PRJNA454503	89995	190	2.015504	3.8294576	Campylobacter concisus	199	Bacteria	Bacteria	324	3.13e-84	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g89666	i0	97.368	12	190	5	100	0	1	190	1055391	1055580	Campylobacter concisus strain RMIT-O23 chromosome	blastn	2280	324	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19568269	19568269	PRJNA454503_P_NODE_43996_length_222_cov_1.614907_g43667_i0	PRJNA454503	43996	222	1.614907	3.58509354	uncultured Helicobacter sp.	175537	Bacteria	Bacteria	137	8.98e-36	NR	WP_299327541.1	175537	g43667	i0	90.5	1	74	7	100	0	1	222	88	161	WP_299327541.1 OmpP1/FadL family transporter [uncultured Helicobacter sp.]	diamond	222	137	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	uncultured Helicobacter sp.
20220136	20220136	PRJNA454503_P_NODE_7436_length_413_cov_0.909091_g7107_i0	PRJNA454503	7436	413	0.909091	3.75454583	Arcobacter	28196	Bacteria	Bacteria	669	0	NTclustered	gi\|2907625684\|emb\|OZ223244.1\|	2808971	g7107	i0	96.107	401.796610169492	411	14	99	2	1	411	470249	469841	MAG: Arcobacteraceae bacterium isolate d8a8449e-00d2-4365-b2ae-71d708214a40 genome assembly, chromosome: 5	blastn	165942	669	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
22119013	22119013	PRJNA454503_P_NODE_45158_length_221_cov_1.312500_g44829_i0	PRJNA454503	45158	221	1.3125	2.900625	Campylobacter showae	204	Bacteria	Bacteria	315	2.26e-81	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g44829	i0	92.308	7.76018099547511	221	17	100	0	1	221	222706	222926	Campylobacter showae genome assembly, chromosome: I	blastn	1715	315	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
28529060	28529060	PRJNA454503_P_NODE_59767_length_210_cov_0.872483_g59438_i0	PRJNA454503	59767	210	0.872483	1.8322143	Campylobacterota bacterium	2026809	Bacteria	Bacteria	92	1.04e-19	NR	NPA59219.1	2026809	g59438	i0	62.3	1.97142857142857	69	26	98.6	0	3	209	654	722	NPA59219.1 glycosyltransferase [Campylobacterota bacterium]	diamond	414	92	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29791666	29791666	PRJNA454503_P_NODE_79391_length_204_cov_0.909091_g79062_i0	PRJNA454503	79391	204	0.909091	1.85454564	unclassified Sulfurospirillum	2618290	Bacteria	Bacteria	117	3.95e-30	NR	WP_037959241.1	2618290	g79062	i0	77.3	0.970588235294118	66	15	97.1	0	203	6	109	174	WP_037959241.1 MULTISPECIES: NAD-dependent epimerase/dehydratase family protein [unclassified Sulfurospirillum]	diamond	198	117	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum
30329435	30329435	PRJNA454503_P_NODE_30692_length_238_cov_1.988701_g30363_i0	PRJNA454503	30692	238	1.988701	4.73310838	Helicobacter pylori	210	Bacteria	Bacteria	48.1	4.65e-5	NR	GAA8948737.1	210	g30363	i0	50	0.957983193277311	54	17	55.5	1	193	62	3	56	GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori]	diamond	228	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30960919	30960919	PRJNA454503_P_NODE_30274_length_239_cov_1.460674_g29945_i0	PRJNA454503	30274	239	1.460674	3.49101086	Helicobacter pylori	210	Bacteria	Bacteria	87.8	1.28e-19	NR	WP_322377330.1	210	g29945	i0	97.6	0.514644351464435	41	1	51.5	0	123	1	1	41	WP_322377330.1 KilA-N domain-containing protein [Helicobacter pylori]	diamond	123	87.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31371916	31371916	PRJNA454503_P_NODE_68016_length_207_cov_0.890411_g67687_i0	PRJNA454503	68016	207	0.890411	1.84315077	Campylobacter coli	195	Bacteria	Bacteria	120	9.149999999999999e-34	NR	WP_289858361.1	195	g67687	i0	82.6	1	69	12	100	0	1	207	2	70	WP_289858361.1 DUF6950 family protein, partial [Campylobacter coli]	diamond	207	120	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
31403523	31403523	PRJNA454503_P_NODE_37296_length_230_cov_1.538462_g36967_i0	PRJNA454503	37296	230	1.538462	3.5384626	Campylobacter sp. 2	205	Bacteria	Bacteria	85.5	4.73e-19	NR	WP_214120692.1	2836735	g36967	i0	64.9	0.965217391304348	74	23	95.2	2	12	230	63	134	WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01]	diamond	222	85.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. 2018MI01
32004422	32004422	PRJNA454503_P_NODE_78978_length_204_cov_0.909091_g78649_i0	PRJNA454503	78978	204	0.909091	1.85454564	Helicobacter pylori	210	Bacteria	Bacteria	42	0.00395	NR	GAA9140559.1	210	g78649	i0	61	0.602941176470588	41	16	60.3	0	123	1	4	44	GAA9140559.1 hypothetical protein Kyoto190A_3310 [Helicobacter pylori]	diamond	123	42	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32415850	32415850	PRJNA454503_P_NODE_86979_length_200_cov_2.719424_g86650_i0	PRJNA454503	86979	200	2.719424	5.438848	Helicobacter pylori	210	Bacteria	Bacteria	73.9	7.77e-16	NR	GAA8692375.1	210	g86650	i0	73.3	0.675	45	12	67.5	0	136	2	1	45	GAA8692375.1 hypothetical protein Kyoto145A_2350 [Helicobacter pylori]	diamond	135	73.9	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);;