RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where bioproject = "PRJNA1196438", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 34 ✖

tax_kingdom 1

  • Pseudomonadati · 34 ✖

bioproject 1

  • PRJNA1196438 · 34 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
3593857 3593857 PRJNA1196438_P_NODE_63583_length_253_cov_1.733333_g63156_i0 PRJNA1196438 63583 253 1.733333 4.38533249 Bacteria 2 Bacteria Bacteria 468 1.92e-127   NTclustered gi|1829627864|gb|CP048769.1| 197 g63156 i0 100 100 253 0 100 0 1 253 1416474 1416222 Campylobacter jejuni strain ZJB020 chromosome, complete genome blastn 25300 468 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
5426609 5426609 PRJNA1196438_P_NODE_6465_length_397_cov_3.037037_g6043_i0 PRJNA1196438 6465 397 3.037037 12.05703689 Desulfurellales bacterium 2482794 Bacteria Bacteria 129 3.58e-36   NR TXH41232.1 2482794 g6043 i0 70.7 0.748110831234257 99 27 74.8 1 388 92 4 100 TXH41232.1 MAG: DUF2312 domain-containing protein [Desulfurellales bacterium] diamond 297 129 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
7976252 7976252 PRJNA1196438_P_NODE_17867_length_312_cov_3.389121_g17441_i0 PRJNA1196438 17867 312 3.389121 10.57405752 Campylobacter ureolyticus 827 Bacteria Bacteria 60.2 1.74e-4   NTclustered gi|1966876394|gb|CP068487.1| 827 g17441 i0 91.111 0.288461538461538 45 3 14 1 88 131 327652 327608 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 90 60.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
8696179 8696179 PRJNA1196438_P_NODE_11387_length_317_cov_1.918033_g10961_i0 PRJNA1196438 11387 317 1.918033 6.08016461 Bacteria 2 Bacteria Bacteria 329 1.23e-85   NTclustered gi|2323232558|gb|CP109813.1| 195 g10961 i0 100 57.8296529968454 178 0 56 0 140 317 568540 568363 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 18332 329 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
10527338 10527338 PRJNA1196438_P_NODE_76129_length_242_cov_0.923077_g75702_i0 PRJNA1196438 76129 242 0.923077 2.23384634 Campylobacter hepaticus 1813019 Bacteria Bacteria 106 1.65e-18   NTclustered gi|1940031893|gb|CP065357.1| 1813019 g75702 i0 85.859 2.45454545454545 99 14 41 0 3 101 772595 772693 Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome blastn 594 106 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter hepaticus
14351940 14351940 PRJNA1196438_P_NODE_20192_length_312_cov_3.004184_g19766_i0 PRJNA1196438 20192 312 3.004184 9.37305408 Campylobacter concisus 199 Bacteria Bacteria 257 5.76e-64   NTclustered gi|1938730527|gb|CP049274.1| 199 g19766 i0 97.351 4.73717948717949 151 4 96 0 162 312 1714174 1714324 Campylobacter concisus strain P10CDO-S2 chromosome, complete genome blastn 1478 257 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
16900287 16900287 PRJNA1196438_P_NODE_46614_length_278_cov_2.741463_g46187_i0 PRJNA1196438 46614 278 2.741463 7.62126714 Campylobacter showae 204 Bacteria Bacteria 435 2.1700000000000003e-117   NTclustered gi|1483583565|emb|LT631545.1| 204 g46187 i0 94.946 16.2805755395683 277 14 99 0 2 278 1621941 1621665 Campylobacter showae strain B32_SW genome assembly, chromosome: I blastn 4526 435 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
18174482 18174482 PRJNA1196438_P_NODE_11835_length_313_cov_5.020833_g11409_i0 PRJNA1196438 11835 313 5.020833 15.71520729 Aliarcobacter lanthieri 1355374 Bacteria Bacteria 150 1.01e-31   NTclustered gi|2922095445|gb|CP182877.1| 1355374 g11409 i0 89.167 0.383386581469649 120 13 38 0 194 313 1741845 1741726 Aliarcobacter lanthieri strain BNI-4365 chromosome, complete genome blastn 120 150 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter lanthieri
20724898 20724898 PRJNA1196438_P_NODE_74917_length_243_cov_0.917647_g74490_i0 PRJNA1196438 74917 243 0.917647 2.22988221 Halarcobacter bivalviorum 663364 Bacteria Bacteria 52.8 0.022   NTclustered gi|1435902972|gb|CP031217.1| 663364 g74490 i0 100 0.230452674897119 28 0 12 0 171 198 2497282 2497255 Halarcobacter bivalviorum strain LMG 26154 chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter bivalviorum
22000162 22000162 PRJNA1196438_P_NODE_63258_length_253_cov_2.822222_g62831_i0 PRJNA1196438 63258 253 2.822222 7.14022166 Campylobacter ureolyticus 827 Bacteria Bacteria 399 7.119999999999998e-107   NTclustered gi|909715533|gb|CP012195.1| 1032069 g62831 i0 95.238 39.9644268774704 252 12 99 0 1 252 1221291 1221040 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 10111 399 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
25269486 25269486 PRJNA1196438_P_NODE_31660_length_300_cov_4.039648_g31234_i0 PRJNA1196438 31660 300 4.039648 12.118944 PVC group 1783257 Bacteria Bacteria 279 1.18e-70   NTclustered gi|2523954314|dbj|AP028341.1| 195 g31234 i0 100 96.5533333333333 151 0 100 0 1 151 158510 158660 Campylobacter coli BCH-10328 DNA, complete genome blastn 28966 279 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
26597380 26597380 PRJNA1196438_P_NODE_76821_length_241_cov_2.327381_g76394_i0 PRJNA1196438 76821 241 2.327381 5.60898821 Sulfuricurvum sp. 2025608 Bacteria Bacteria 52 1.92e-5   NR MDD5387603.1 2025608 g76394 i0 61.9 0.522821576763486 42 16 52.3 0 128 3 199 240 MDD5387603.1 hypothetical protein [Sulfuricurvum sp.] diamond 126 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfuricurvum Sulfuricurvum sp.
27167162 27167162 PRJNA1196438_P_NODE_74842_length_243_cov_1.435294_g74415_i0 PRJNA1196438 74842 243 1.435294 3.48776442 Sulfurimonas sp. 2022749 Bacteria Bacteria 122 2.68e-30   NR MCF6330020.1 2022749 g74415 i0 74.1 2.97530864197531 81 20 100 1 243 1 263 342 MCF6330020.1 N-6 DNA methylase [Sulfurimonas sp.] diamond 723 122 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.
27357123 27357123 PRJNA1196438_P_NODE_6563_length_395_cov_2.832298_g6141_i0 PRJNA1196438 6563 395 2.832298 11.1875771 Campylobacter jejuni 197 Bacteria Bacteria 68.2 5e-11   NR WP_126216423.1 197 g6141 i0 78.6 0.615189873417721 42 9 31.9 0 392 267 159 200 WP_126216423.1 IS607 family transposase [Campylobacter jejuni] diamond 243 68.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27376213 27376213 PRJNA1196438_P_NODE_24963_length_309_cov_3.076271_g24537_i0 PRJNA1196438 24963 309 3.076271 9.50567739 Bacteria 2 Bacteria Bacteria 73.6 1.21e-12   NR WP_257403149.1 201 g24537 i0 57.1 3.31067961165049 49 21 47.6 0 163 309 1 49 WP_257403149.1 aldolase catalytic domain-containing protein [Campylobacter lari] diamond 1023 74.3 0.990578734858681 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
27420400 27420400 PRJNA1196438_P_NODE_44003_length_282_cov_3.870813_g43576_i0 PRJNA1196438 44003 282 3.870813 10.91569266 Helicobacter pylori 210 Bacteria Bacteria 70.5 5.76e-14   NR GAA9176259.1 210 g43576 i0 71.4 0.446808510638298 42 11 43.6 1 281 159 9 50 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 126 70.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27514864 27514864 PRJNA1196438_P_NODE_51623_length_270_cov_5.233503_g51196_i0 PRJNA1196438 51623 270 5.233503 14.1304581 Helicobacter pylori 210 Bacteria Bacteria 63.2 1.74e-10   NR GAA8853361.1 210 g51196 i0 67.4 0.511111111111111 46 15 51.1 0 259 122 2 47 GAA8853361.1 hypothetical protein Kyoto154A_0330 [Helicobacter pylori] diamond 138 63.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27660257 27660257 PRJNA1196438_P_NODE_80104_length_233_cov_5.062500_g79677_i0 PRJNA1196438 80104 233 5.0625 11.795625 Campylobacter 194 Bacteria Bacteria 72.8 8.15e-13   NR EKN8003684.1 195 g79677 i0 50 3.81115879828326 74 37 95.3 0 228 7 88 161 EKN8003684.1 hypothetical protein [Campylobacter coli] diamond 888 72.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
27704689 27704689 PRJNA1196438_P_NODE_9384_length_343_cov_4.911111_g8960_i0 PRJNA1196438 9384 343 4.911111 16.84511073 Desulfurellales bacterium 2482794 Bacteria Bacteria 132 4.37e-33   NR TXH56976.1 2482794 g8960 i0 88.6 0.997084548104956 114 13 99.7 0 342 1 79 192 TXH56976.1 MAG: hypothetical protein E6Q97_05145, partial [Desulfurellales bacterium] diamond 342 132 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28714729 28714729 PRJNA1196438_P_NODE_48607_length_275_cov_2.529703_g48180_i0 PRJNA1196438 48607 275 2.529703 6.95668325 Desulfurellales bacterium 2482794 Bacteria Bacteria 139 3.1999999999999995e-36   NR TXH41244.1 2482794 g48180 i0 73 0.970909090909091 89 24 97.1 0 274 8 419 507 TXH41244.1 MAG: hypothetical protein E6Q97_38065 [Desulfurellales bacterium] diamond 267 139 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29081013 29081013 PRJNA1196438_P_NODE_84948_length_217_cov_5.395833_g84520_i0 PRJNA1196438 84948 217 5.395833 11.70895761 Pseudomonadati 3379134 Bacteria Bacteria 61.2 2.17e-10   NR GAA9246723.1 210 g84520 i0 43.9 1.83870967741935 66 21 91.2 1 200 3 1 50 GAA9246723.1 hypothetical protein Kyoto199A_0690 [Helicobacter pylori] diamond 399 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29125440 29125440 PRJNA1196438_P_NODE_7589_length_374_cov_3.441860_g7167_i0 PRJNA1196438 7589 374 3.44186 12.8725564 Desulfurellales bacterium 2482794 Bacteria Bacteria 62.8 1.12e-8   NR TXH56997.1 2482794 g7167 i0 72.1 0.344919786096257 43 12 34.5 0 372 244 257 299 TXH56997.1 MAG: class I SAM-dependent methyltransferase [Desulfurellales bacterium] diamond 129 62.8 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29188509 29188509 PRJNA1196438_P_NODE_66389_length_250_cov_5.242938_g65962_i0 PRJNA1196438 66389 250 5.242938 13.107345 Helicobacter pylori 210 Bacteria Bacteria 97.1 3.03e-24   NR GAA8683247.1 210 g65962 i0 98 0.612 51 1 61.2 0 76 228 35 85 GAA8683247.1 hypothetical protein Kyoto145A_0510 [Helicobacter pylori] diamond 153 97.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29282861 29282861 PRJNA1196438_P_NODE_81049_length_231_cov_4.329114_g80622_i0 PRJNA1196438 81049 231 4.329114 10.00025334 Campylobacter jejuni 197 Bacteria Bacteria 96.7 2.48e-21   NR WP_126216422.1 197 g80622 i0 65.3 2.80519480519481 72 25 93.5 0 1 216 304 375 WP_126216422.1 hypothetical protein [Campylobacter jejuni] diamond 648 96.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
29377723 29377723 PRJNA1196438_P_NODE_54929_length_266_cov_1.243523_g54502_i0 PRJNA1196438 54929 266 1.243523 3.30777118 Helicobacter pylori 210 Bacteria Bacteria 56.2 2.02e-8   NR GAA9176257.1 210 g54502 i0 66 1.74812030075188 50 17 56.4 0 265 116 1 50 GAA9176257.1 hypothetical protein Kyoto193A_0400 [Helicobacter pylori] diamond 465 56.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29883107 29883107 PRJNA1196438_P_NODE_3431_length_525_cov_4.955752_g3021_i0 PRJNA1196438 3431 525 4.955752 26.017698 Helicobacter pylori 210 Bacteria Bacteria 108 1.97e-27   NR WP_316479284.1 210 g3021 i0 94.3 0.302857142857143 53 3 30.3 0 399 241 15 67 WP_316479284.1 hypothetical protein, partial [Helicobacter pylori] diamond 159 108 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30483308 30483308 PRJNA1196438_P_NODE_8673_length_355_cov_2.666667_g8250_i0 PRJNA1196438 8673 355 2.666667 9.46666785 Desulfurellales bacterium 2482794 Bacteria Bacteria 80.9 5.21e-15   NR TXH57000.1 2482794 g8250 i0 92.7 0.346478873239437 41 3 34.6 0 232 354 1 41 TXH57000.1 MAG: DUF2800 domain-containing protein [Desulfurellales bacterium] diamond 123 80.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31178059 31178059 PRJNA1196438_P_NODE_62555_length_254_cov_2.756906_g62128_i0 PRJNA1196438 62555 254 2.756906 7.00254124 uncultured Helicobacter sp. 175537 Bacteria Bacteria 152 2.7199999999999994e-42   NR WP_300948877.1 175537 g62128 i0 89.3 1.98425196850394 84 9 99.2 0 252 1 14 97 WP_300948877.1 site-specific integrase [uncultured Helicobacter sp.] diamond 504 152 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
31368327 31368327 PRJNA1196438_P_NODE_87736_length_202_cov_4.449612_g87308_i0 PRJNA1196438 87736 202 4.449612 8.98821624 Sulfurospirillaceae bacterium 2932625 Bacteria Bacteria 70.5 3.67e-12   NR MDX1808585.1 2932625 g87308 i0 50 2.88118811881188 64 32 95 0 201 10 266 329 MDX1808585.1 cache domain-containing protein [Sulfurospirillaceae bacterium] diamond 582 70.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae   Sulfurospirillaceae bacterium
31558058 31558058 PRJNA1196438_P_NODE_4656_length_458_cov_1.963636_g4238_i0 PRJNA1196438 4656 458 1.963636 8.99345288 Helicobacter pylori 210 Bacteria Bacteria 119 2.39e-28   NR WP_162965965.1 210 g4238 i0 42.5 3.01310043668122 153 87 99.6 1 3 458 124 276 WP_162965965.1 Eco57I restriction-modification methylase domain-containing protein, partial [Helicobacter pylori] diamond 1380 119 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31608446 31608446 PRJNA1196438_P_NODE_70936_length_246_cov_2.930636_g70509_i0 PRJNA1196438 70936 246 2.930636 7.20936456 Pseudomonadati 3379134 Bacteria Bacteria 64.3 8.81e-10   NR WP_319088862.1 28200 g70509 i0 49.2 3.23170731707317 65 30 75.6 1 61 246 7 71 WP_319088862.1 HNH endonuclease signature motif containing protein [Aliarcobacter skirrowii] diamond 795 64.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter skirrowii
31956266 31956266 PRJNA1196438_P_NODE_8077_length_365_cov_2.767123_g7655_i0 PRJNA1196438 8077 365 2.7671230000000002 10.09999895 root 1 Root_unresolved Root_unresolved 139 6.73e-37   NR WP_300900450.1 59617 g7655 i0 91.9 1.82465753424658 74 6 60.8 0 363 142 215 288 WP_300900450.1 hypothetical protein, partial [Helicobacter rodentium] diamond 666 139 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter rodentium
32507254 32507254 PRJNA1196438_P_NODE_82759_length_228_cov_2.658065_g82332_i0 PRJNA1196438 82759 228 2.658065 6.0603882 Campylobacterales bacterium 2268180 Bacteria Bacteria 72.8 7.58e-13   NR HHS92137.1 2268180 g82332 i0 50 0.842105263157895 64 24 73.7 2 226 59 407 470 HHS92137.1 hypothetical protein [Campylobacterales bacterium] diamond 192 72.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
32538806 32538806 PRJNA1196438_P_NODE_11579_length_315_cov_1.318182_g11153_i0 PRJNA1196438 11579 315 1.318182 4.1522733 Desulfurellales bacterium 2482794 Bacteria Bacteria 89.7 1.42e-20   NR TXH57009.1 2482794 g11153 i0 44.9 0.933333333333333 98 54 93.3 0 20 313 1 98 TXH57009.1 MAG: hypothetical protein E6Q97_05330 [Desulfurellales bacterium] diamond 294 89.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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