metadata: contig_metadata: 21 rows where bioproject = "PRJNA680334", tax_kingdom = "Pseudomonadati" and tax

21 rows where bioproject = "PRJNA680334", 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
650434	650434	PRJNA680334_S_NODE_85841_length_161_cov_3.679688_g85355_i0	PRJNA680334	85841	161	3.679688	5.92429768	Campylobacter gracilis	824	Bacteria	Bacteria	270	3.389999999999999e-68	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g85355	i0	96.894	2	161	5	100	0	1	161	1908263	1908423	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	322	270	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
1169182	1169182	PRJNA680334_S_NODE_24361_length_239_cov_5.247573_g23875_i0	PRJNA680334	24361	239	5.247573	12.54169947	Aliarcobacter	2321111	Bacteria	Bacteria	424	3.95e-114	NTclustered	gi\|2305706618\|gb\|CP104378.1\|	28197	g23875	i0	98.739	75.4225941422594	238	3	99	0	1	238	443899	443662	Aliarcobacter butzleri strain P1100 chromosome, complete genome	blastn	18026	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
1169222	1169222	PRJNA680334_S_NODE_36441_length_211_cov_18.219101_g35955_i0	PRJNA680334	36441	211	18.219101	38.44230311	Arcobacteraceae	2808963	Bacteria	Bacteria	383	5.79e-102	NTclustered	gi\|2441000239\|gb\|OQ396395.1\|	28197	g35955	i0	100	245.009478672986	207	0	98	0	1	207	217	11	Aliarcobacter butzleri strain KK509 23S ribosomal RNA gene, partial sequence	blastn	51697	383	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
1925223	1925223	PRJNA680334_S_NODE_103242_length_152_cov_2.075630_g102756_i0	PRJNA680334	103242	152	2.07563	3.1549576	Campylobacter gracilis	824	Bacteria	Bacteria	254	3.17e-63	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g102756	i0	96.711	2	152	5	100	0	1	152	2203897	2203746	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	304	254	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
10097832	10097832	PRJNA680334_S_NODE_1048_length_645_cov_13.890523_g637_i0	PRJNA680334	1048	645	13.890523	89.59387335	Arcobacteraceae	2808963	Bacteria	Bacteria	778	0	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g637	i0	88.668	396.606201550388	653	55	99	12	1	643	850144	850787	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	255811	778	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
10097857	10097857	PRJNA680334_S_NODE_13988_length_283_cov_20.596000_g13502_i0	PRJNA680334	13988	283	20.596	58.28668	Aliarcobacter	2321111	Bacteria	Bacteria	512	9.97e-141	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g13502	i0	99.643	393.049469964664	280	1	99	0	1	280	849972	849693	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	111233	512	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
10098056	10098056	PRJNA680334_S_NODE_71868_length_171_cov_1.876812_g71382_i0	PRJNA680334	71868	171	1.876812	3.20934852	Aliarcobacter	2321111	Bacteria	Bacteria	300	4.63e-77	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g71382	i0	98.246	8	171	3	100	0	1	171	1179385	1179555	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	1368	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
15953324	15953324	PRJNA680334_S_NODE_90053_length_159_cov_1.761905_g89567_i0	PRJNA680334	90053	159	1.761905	2.80142895	Helicobacter pylori	210	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2641560259\|gb\|CP078186.1\|	210	g89567	i0	100	0.176100628930818	28	0	18	0	127	154	1607843	1607870	Helicobacter pylori strain HpGP-USA-433 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
17747125	17747125	PRJNA680334_S_NODE_45074_length_198_cov_3.375758_g44588_i0	PRJNA680334	45074	198	3.375758	6.68400084	Arcobacteraceae	2808963	Bacteria	Bacteria	364	1.9399999999999995e-96	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g44588	i0	100	381.878787878788	197	0	99	0	1	197	850344	850148	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	75612	364	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
17747165	17747165	PRJNA680334_S_NODE_56914_length_184_cov_3.033113_g56428_i0	PRJNA680334	56914	184	3.033113	5.58092792	Aliarcobacter	2321111	Bacteria	Bacteria	274	3.0799999999999997e-69	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g56428	i0	97.5	18.9021739130435	160	4	87	0	19	178	1636352	1636193	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	3478	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
19020950	19020950	PRJNA680334_S_NODE_107455_length_150_cov_2.153846_g106969_i0	PRJNA680334	107455	150	2.153846	3.230769	Campylobacter	194	Bacteria	Bacteria	276	6.660000000000001e-70	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g106969	i0	100	222.846666666667	149	0	99	0	2	150	1033048	1032900	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	33427	276	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20295584	20295584	PRJNA680334_S_NODE_27556_length_230_cov_7.888325_g27070_i0	PRJNA680334	27556	230	7.888325	18.1431475	Arcobacteraceae	2808963	Bacteria	Bacteria	424	3.78e-114	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g27070	i0	100	377.691304347826	229	0	99	0	2	230	850824	851052	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	86869	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
22326748	22326748	PRJNA680334_S_NODE_21718_length_248_cov_3.879070_g21232_i0	PRJNA680334	21718	248	3.87907	9.6200936	Campylobacter jejuni	197	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g21232	i0	98.79	99.4677419354839	248	3	100	0	1	248	1467078	1466831	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	24668	442	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
24121226	24121226	PRJNA680334_S_NODE_44759_length_198_cov_9.696970_g44273_i0	PRJNA680334	44759	198	9.69697	19.2000006	Campylobacterales	213849	Bacteria	Bacteria	344	2.53e-90	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g44273	i0	97.98	255.015151515152	198	4	100	0	1	198	43415	43218	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	50493	344	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
24875549	24875549	PRJNA680334_S_NODE_23800_length_241_cov_3.802885_g23314_i0	PRJNA680334	23800	241	3.802885	9.16495285	Aliarcobacter butzleri	28197	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|345468266\|dbj\|AP012047.1\|	944546	g23314	i0	100	66.0954356846473	241	0	100	0	1	241	1410265	1410505	Arcobacter butzleri ED-1 DNA, complete genome	blastn	15929	446	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
27461302	27461302	PRJNA680334_S_NODE_43303_length_200_cov_26.449102_g42817_i0	PRJNA680334	43303	200	26.449102	52.898204	Helicobacter pylori	210	Bacteria	Bacteria	70.1	6.43e-14	NR	GAA8948737.1	210	g42817	i0	68	0.75	50	15	75	1	200	51	8	56	GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori]	diamond	150	70.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28471659	28471659	PRJNA680334_P_NODE_166_length_224_cov_5.061538_g165_i0	PRJNA680334	166	224	5.061538	11.33784512	Helicobacter pylori	210	Bacteria	Bacteria	45.4	3.65e-4	NR	GAA9127427.1	210	g165	i0	89.5	0.254464285714286	19	2	25.4	0	64	120	1	19	GAA9127427.1 hypothetical protein Kyoto190A_1400 [Helicobacter pylori]	diamond	57	45.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29450091	29450091	PRJNA680334_P_NODE_710_length_153_cov_2.524194_g709_i0	PRJNA680334	710	153	2.524194	3.86201682	Helicobacter pylori	210	Bacteria	Bacteria	42.7	8.88e-4	NR	GAA9038474.1	210	g709	i0	94.1	0.333333333333333	17	1	33.3	0	88	138	1	17	GAA9038474.1 hypothetical protein Kyoto184A_01180 [Helicobacter pylori]	diamond	51	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30619014	30619014	PRJNA680334_S_NODE_96573_length_155_cov_3.459016_g96087_i0	PRJNA680334	96573	155	3.459016	5.3614748	Sulfurimonas sp.	2022749	Bacteria	Bacteria	57	1.03e-7	NR	WP_294928611.1	2022749	g96087	i0	51	0.987096774193548	51	25	98.7	0	154	2	124	174	WP_294928611.1 AAA family ATPase [Sulfurimonas sp.]	diamond	153	57	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
30998291	30998291	PRJNA680334_S_NODE_56434_length_184_cov_17.033113_g55948_i0	PRJNA680334	56434	184	17.033113	31.34092792	Helicobacter pylori	210	Bacteria	Bacteria	41.2	0.00516	NR	GAA9228604.1	210	g55948	i0	53.6	0.456521739130435	28	13	45.7	0	5	88	1	28	GAA9228604.1 hypothetical protein Kyoto198A_4520 [Helicobacter pylori]	diamond	84	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31579251	31579251	PRJNA680334_S_NODE_7176_length_346_cov_77.255591_g6690_i0	PRJNA680334	7176	346	77.255591	267.30434486	Pseudomonadati	3379134	Bacteria	Bacteria	42	0.0181	NR	GAA8979103.1	210	g6690	i0	80	0.320809248554913	20	4	17.3	0	182	123	1	20	GAA8979103.1 hypothetical protein Kyoto181A_5090 [Helicobacter pylori]	diamond	111	42	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);;