metadata: contig_metadata: 27 rows where bioproject = "PRJNA939369", tax_kingdom = "Pseudomonadati" and tax

27 rows where bioproject = "PRJNA939369", 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
3465172	3465172	PRJNA939369_S_NODE_38643_length_279_cov_1.868932_g38226_i0	PRJNA939369	38643	279	1.868932	5.21432028	Helicobacter gastrofelis	2849642	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2065538474\|dbj\|AP024819.1\|	2849642	g38226	i0	100	0.100358422939068	28	0	10	0	142	169	1226367	1226340	Helicobacter sp. NHP19-012 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter gastrofelis
4742730	4742730	PRJNA939369_S_NODE_43464_length_269_cov_16.979592_g43047_i0	PRJNA939369	43464	269	16.979592	45.67510248	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g43047	i0	100	0.104089219330855	28	0	10	0	143	170	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
7292441	7292441	PRJNA939369_S_NODE_30846_length_298_cov_1.777778_g30429_i0	PRJNA939369	30846	298	1.777778	5.29777844	Helicobacter rodentium	59617	Bacteria	Bacteria	451	2.34e-122	NTclustered	gi\|50957140\|gb\|AY596225.1\|	59617	g30429	i0	94.521	128.231543624161	292	16	98	0	4	295	1538	1829	Helicobacter rodentium strain MIT 95-1707 23S ribosomal RNA gene, partial sequence	blastn	38213	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter rodentium
12393567	12393567	PRJNA939369_S_NODE_44930_length_267_cov_1.046392_g44513_i0	PRJNA939369	44930	267	1.046392	2.79386664	Poseidonibacter lekithochrous	1904463	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1850313845\|gb\|CP054052.1\|	1904463	g44513	i0	92.105	0.142322097378277	38	3	14	0	163	200	1360266	1360303	Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome	blastn	38	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter lekithochrous
13667935	13667935	PRJNA939369_S_NODE_3291_length_634_cov_4.602496_g2890_i0	PRJNA939369	3291	634	4.602496	29.17982464	Helicobacter sp. MIT 99-5507	152489	Bacteria	Bacteria	1096	0	NTclustered	gi\|50957179\|gb\|AY596264.1\|	152489	g2890	i0	98.395	147.017350157729	623	10	98	0	12	634	1089	467	Helicobacter sp. MIT 99-5507 23S ribosomal RNA gene, partial sequence	blastn	93209	1096	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. MIT 99-5507
20040936	20040936	PRJNA939369_S_NODE_2856_length_672_cov_3.457429_g2460_i0	PRJNA939369	2856	672	3.457429	23.23392288	Helicobacter sp. MIT 99-5507	152489	Bacteria	Bacteria	1230	0	NTclustered	gi\|50957179\|gb\|AY596264.1\|	152489	g2460	i0	99.851	139.712797619048	669	1	99	0	4	672	1675	1007	Helicobacter sp. MIT 99-5507 23S ribosomal RNA gene, partial sequence	blastn	93887	1230	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. MIT 99-5507
25482664	25482664	PRJNA939369_S_NODE_59520_length_249_cov_0.875000_g59103_i0	PRJNA939369	59520	249	0.875	2.17875	Arcobacter	28196	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1847331607\|gb\|CP053835.1\|	873191	g59103	i0	94.595	0.29718875502008	37	1	15	1	136	172	2566064	2566099	Arcobacter defluvii strain LMG 25694 chromosome, complete genome	blastn	74	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter defluvii
26676482	26676482	PRJNA939369_S_NODE_71061_length_243_cov_1.205882_g70644_i0	PRJNA939369	71061	243	1.205882	2.93029326	Helicobacter pylori	210	Bacteria	Bacteria	55.8	2.01e-8	NR	GAA6952165.1	210	g70644	i0	60.5	0.530864197530864	43	17	53.1	0	219	91	3	45	GAA6952165.1 hypothetical protein Kyoto207A_5990 [Helicobacter pylori]	diamond	129	55.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27720501	27720501	PRJNA939369_S_NODE_55004_length_251_cov_0.865169_g54587_i0	PRJNA939369	55004	251	0.865169	2.17157419	Helicobacter pylori	210	Bacteria	Bacteria	52	3.33e-6	NR	GAA8954509.1	210	g54587	i0	54.5	3.15537848605578	44	20	52.6	0	30	161	59	102	GAA8954509.1 hypothetical protein Kyoto181A_2710 [Helicobacter pylori]	diamond	792	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27877892	27877892	PRJNA939369_S_NODE_49365_length_259_cov_1.225806_g48948_i0	PRJNA939369	49365	259	1.225806	3.17483754	Helicobacter pylori	210	Bacteria	Bacteria	44.7	6.63e-4	NR	GAA8856488.1	210	g48948	i0	56.4	0.451737451737452	39	16	44	1	121	234	10	48	GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori]	diamond	117	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28137653	28137653	PRJNA939369_S_NODE_46065_length_265_cov_1.005208_g45648_i0	PRJNA939369	46065	265	1.005208	2.6638012	Bacteria	2	Bacteria	Bacteria	77	1.83e-15	NR	WP_203061690.1	210	g45648	i0	74.1	18.9509433962264	54	14	61.1	0	187	26	32	85	WP_203061690.1 ead/Ea22-like family protein, partial [Helicobacter pylori]	diamond	5022	77	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28800302	28800302	PRJNA939369_S_NODE_66427_length_246_cov_0.739884_g66010_i0	PRJNA939369	66427	246	0.739884	1.82011464	Bacteria	2	Bacteria	Bacteria	45.8	2.09e-4	NR	GAA9260203.1	210	g66010	i0	73.1	0.902439024390244	26	7	31.7	0	88	165	1	26	GAA9260203.1 hypothetical protein Kyoto199A_4430 [Helicobacter pylori]	diamond	222	46.2	0.991341991341991	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28824835	28824835	PRJNA939369_S_NODE_76968_length_241_cov_0.875000_g76551_i0	PRJNA939369	76968	241	0.875	2.10875	Helicobacter pylori	210	Bacteria	Bacteria	75.1	6.36e-16	NR	GAA9178338.1	210	g76551	i0	61.1	0.672199170124481	54	21	67.2	0	183	22	4	57	GAA9178338.1 hypothetical protein Kyoto193A_1850 [Helicobacter pylori]	diamond	162	75.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28958619	28958619	PRJNA939369_S_NODE_53488_length_252_cov_2.340782_g53071_i0	PRJNA939369	53488	252	2.340782	5.89877064	Bacteria	2	Bacteria	Bacteria	47.4	5.41e-5	NR	GAA9176257.1	210	g53071	i0	76.9	0.642857142857143	26	6	31	0	228	151	1	26	GAA9176257.1 hypothetical protein Kyoto193A_0400 [Helicobacter pylori]	diamond	162	47.8	0.99163179916318	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29684294	29684294	PRJNA939369_S_NODE_9930_length_425_cov_1.303977_g9513_i0	PRJNA939369	9930	425	1.303977	5.54190225	root	1	Root_unresolved	Root_unresolved	86.3	1.12e-18	NR	WP_238408432.1	210	g9513	i0	78.2	7.37647058823529	55	12	38.8	0	257	421	30	84	WP_238408432.1 DUF1398 family protein, partial [Helicobacter pylori]	diamond	3135	86.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29779307	29779307	PRJNA939369_S_NODE_9791_length_427_cov_1.474576_g9374_i0	PRJNA939369	9791	427	1.474576	6.29643952	Bacteria	2	Bacteria	Bacteria	160	3.73e-46	NR	WP_227574815.1	195	g9374	i0	59.7	17.1990632318501	129	52	90.6	0	388	2	98	226	WP_227574815.1 AAA family ATPase, partial [Campylobacter coli]	diamond	7344	160	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29898752	29898752	PRJNA939369_S_NODE_5031_length_541_cov_11.241453_g4615_i0	PRJNA939369	5031	541	11.241453	60.81626073	Helicobacter pylori	210	Bacteria	Bacteria	79.3	1.69e-15	NR	GAA6899797.1	210	g4615	i0	64.1	0.354898336414048	64	23	35.5	0	203	394	54	117	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	192	79.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30498993	30498993	PRJNA939369_S_NODE_66413_length_246_cov_0.780347_g65996_i0	PRJNA939369	66413	246	0.780347	1.91965362	Helicobacter pylori	210	Bacteria	Bacteria	63.2	1.29e-9	NR	GAA8854026.1	210	g65996	i0	72.7	1.60975609756098	44	12	53.7	0	165	34	97	140	GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori]	diamond	396	63.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30783304	30783304	PRJNA939369_S_NODE_56574_length_250_cov_1.107345_g56157_i0	PRJNA939369	56574	250	1.107345	2.7683625	Helicobacter pylori	210	Bacteria	Bacteria	68.2	6.08e-13	NR	GAA6863873.1	210	g56157	i0	53.4	0.696	58	27	69.6	0	218	45	8	65	GAA6863873.1 hypothetical protein Kyoto206A_2050 [Helicobacter pylori]	diamond	174	68.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31130576	31130576	PRJNA939369_S_NODE_65175_length_246_cov_0.890173_g64758_i0	PRJNA939369	65175	246	0.890173	2.18982558	Helicobacter pylori	210	Bacteria	Bacteria	42.4	0.0105	NR	GAA9051861.1	210	g64758	i0	46.5	0.524390243902439	43	23	52.4	0	1	129	44	86	GAA9051861.1 hypothetical protein Kyoto184A_04030 [Helicobacter pylori]	diamond	129	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31193668	31193668	PRJNA939369_S_NODE_52695_length_254_cov_1.000000_g52278_i0	PRJNA939369	52695	254	1	2.54	Helicobacter pylori	210	Bacteria	Bacteria	67.8	2.53e-12	NR	GAA6899797.1	210	g52278	i0	42.5	0.862204724409449	73	42	86.2	0	6	224	29	101	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	219	67.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31415434	31415434	PRJNA939369_S_NODE_3456_length_624_cov_4.003630_g3053_i0	PRJNA939369	3456	624	4.00363	24.9826512	Helicobacter pylori	210	Bacteria	Bacteria	78.2	9.53e-15	NR	GAA6899797.1	210	g3053	i0	55.7	0.336538461538462	70	31	33.7	0	291	82	27	96	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	210	78.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31921520	31921520	PRJNA939369_S_NODE_71017_length_243_cov_1.282353_g70600_i0	PRJNA939369	71017	243	1.282353	3.11611779	Helicobacter pylori	210	Bacteria	Bacteria	65.9	1.24e-11	NR	GAA6899797.1	210	g70600	i0	43.5	0.851851851851852	69	39	85.2	0	32	238	12	80	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	207	65.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32364670	32364670	PRJNA939369_S_NODE_74799_length_242_cov_0.875740_g74382_i0	PRJNA939369	74799	242	0.87574	2.1192908	Helicobacter pylori	210	Bacteria	Bacteria	42.4	0.00621	NR	GAA9246637.1	210	g74382	i0	73.9	0.285123966942149	23	6	28.5	0	30	98	1	23	GAA9246637.1 hypothetical protein Kyoto199A_0580 [Helicobacter pylori]	diamond	69	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32491244	32491244	PRJNA939369_S_NODE_38539_length_279_cov_110.631068_g38122_i0	PRJNA939369	38539	279	110.631068	308.66067972	Helicobacter pylori	210	Bacteria	Bacteria	80.1	7.48e-18	NR	GAA8838853.1	210	g38122	i0	92.5	0.43010752688172	40	3	43	0	277	158	4	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	120	80.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32743449	32743449	PRJNA939369_S_NODE_49560_length_259_cov_0.790323_g49143_i0	PRJNA939369	49560	259	0.790323	2.04693657	Helicobacter pylori	210	Bacteria	Bacteria	40	0.0421	NR	GAA8734611.1	210	g49143	i0	69.6	0.266409266409266	23	7	26.6	0	90	22	1	23	GAA8734611.1 hypothetical protein Kyoto147A_1680 [Helicobacter pylori]	diamond	69	40	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32781628	32781628	PRJNA939369_S_NODE_36280_length_285_cov_0.905660_g35863_i0	PRJNA939369	36280	285	0.90566	2.581131	root	1	Root_unresolved	Root_unresolved	91.3	5.6200000000000006e-21	NR	WP_227579456.1	195	g35863	i0	58.1	32.3578947368421	74	31	77.9	0	24	245	76	149	WP_227579456.1 serine/threonine protein phosphatase, partial [Campylobacter coli]	diamond	9222	91.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli

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);;