RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1196438 · 24 ✖

analysis 1

  • diamond · 24 ✖

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