RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA558770 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
26635659 26635659 PRJNA558770_P_NODE_240501_length_234_cov_2.527638_g238496_i0 PRJNA558770 240501 234 2.527638 5.91467292 Arcobacter caeni 1912877 Bacteria Bacteria 50.8 4.5e-5   NR WP_108558809.1 1912877 g238496 i0 100 0.307692307692308 24 0 30.8 0 161 232 190 213 WP_108558809.1 NADH-quinone oxidoreductase subunit NuoN [Arcobacter caeni] diamond 72 50.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter caeni
27458343 27458343 PRJNA558770_P_NODE_391083_length_173_cov_1.144928_g389078_i0 PRJNA558770 391083 173 1.144928 1.98072544 Campylobacter jejuni 197 Bacteria Bacteria 64.3 8.97e-12   NR WP_230132287.1 197 g389078 i0 54.2 1.02312138728324 59 23 98.8 2 172 2 23 79 WP_230132287.1 hypothetical protein, partial [Campylobacter jejuni] diamond 177 64.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27458356 27458356 PRJNA558770_P_NODE_97663_length_234_cov_13.020101_g95658_i0 PRJNA558770 97663 234 13.020101 30.46703634 Helicobacter rodentium 59617 Bacteria Bacteria 52.8 9.59e-6   NR WP_354669714.1 59617 g95658 i0 84 0.320512820512821 25 4 32.1 0 1 75 222 246 WP_354669714.1 reverse transcriptase domain-containing protein [Helicobacter rodentium] diamond 75 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter rodentium
27552650 27552650 PRJNA558770_P_NODE_97924_length_234_cov_12.954774_g95919_i0 PRJNA558770 97924 234 12.954774 30.31417116 Helicobacter pylori 210 Bacteria Bacteria 44.3 0.0019   NR GAA8919759.1 210 g95919 i0 94.7 0.474358974358974 19 1 24.4 0 62 6 1 19 GAA8919759.1 hypothetical protein Kyoto166A_3640 [Helicobacter pylori] diamond 111 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28026598 28026598 PRJNA558770_P_NODE_337765_length_233_cov_4.287879_g335760_i0 PRJNA558770 337765 233 4.287879 9.99075807 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.00143   NR GAA9044670.1 210 g335760 i0 89.5 0.244635193133047 19 2 24.5 0 59 3 3 21 GAA9044670.1 hypothetical protein Kyoto184A_02860 [Helicobacter pylori] diamond 57 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28373700 28373700 PRJNA558770_P_NODE_230006_length_234_cov_2.804020_g228001_i0 PRJNA558770 230006 234 2.80402 6.5614068 Arcobacter acticola 1849015 Bacteria Bacteria 49.7 1.13e-4   NR WP_172127001.1 1849015 g228001 i0 92 0.320512820512821 25 2 32.1 0 2 76 197 221 WP_172127001.1 ABC transporter permease [Arcobacter acticola] diamond 75 49.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter acticola
28405419 28405419 PRJNA558770_P_NODE_388526_length_182_cov_2.857143_g386521_i0 PRJNA558770 388526 182 2.857143 5.20000026 Helicobacter pylori 210 Bacteria Bacteria 62 5.44e-11   NR WP_316479284.1 210 g386521 i0 100 0.412087912087912 25 0 41.2 0 77 3 15 39 WP_316479284.1 hypothetical protein, partial [Helicobacter pylori] diamond 75 62 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28437084 28437084 PRJNA558770_P_NODE_326346_length_233_cov_7.171717_g324341_i0 PRJNA558770 326346 233 7.171717 16.71010061 Campylobacterota bacterium 2026809 Bacteria Bacteria 57 2.35e-7   NR GHS90015.1 2026809 g324341 i0 100 0.309012875536481 24 0 30.9 0 160 231 136 159 GHS90015.1 hypothetical protein FACS189487_11260 [Campylobacterota bacterium] diamond 72 57 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28689742 28689742 PRJNA558770_P_NODE_246927_length_234_cov_2.376884_g244922_i0 PRJNA558770 246927 234 2.376884 5.56190856 Sulfuricurvum sp. 2025608 Bacteria Bacteria 85.1 8.53e-18   NR WP_299971277.1 2025608 g244922 i0 62.3 1.97435897435897 77 12 98.7 1 232 2 18 77 WP_299971277.1 4-hydroxy-3-methylbut-2-enyl diphosphate reductase [Sulfuricurvum sp.] diamond 462 85.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfuricurvum Sulfuricurvum sp.
28689748 28689748 PRJNA558770_P_NODE_266947_length_234_cov_1.964824_g264942_i0 PRJNA558770 266947 234 1.964824 4.59768816 Desulfurellales bacterium 2482794 Bacteria Bacteria 63.9 1.08e-9   NR TXH53471.1 2482794 g264942 i0 43.4 0.974358974358974 76 16 97.4 1 232 5 159 207 TXH53471.1 MAG: heat-shock protein Hsp70 [Desulfurellales bacterium] diamond 228 63.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28784084 28784084 PRJNA558770_P_NODE_319747_length_233_cov_8.974747_g317742_i0 PRJNA558770 319747 233 8.974747 20.91116051 Helicobacter typhlonius 76936 Bacteria Bacteria 96.3 2.72e-21   NR WP_347295388.1 76936 g317742 i0 60 2.18884120171674 85 20 91.4 1 3 215 260 344 WP_347295388.1 transposase [Helicobacter typhlonius] diamond 510 96.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
28861318 28861318 PRJNA558770_P_NODE_190008_length_234_cov_4.185930_g188003_i0 PRJNA558770 190008 234 4.18593 9.7950762 Bacteria 2 Bacteria Bacteria 51.2 2.01e-6   NR WP_160239728.1 76936 g188003 i0 96 1.6025641025641 25 1 32.1 0 75 1 11 35 WP_160239728.1 transposon-transfer assisting family protein [Helicobacter typhlonius] diamond 375 51.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
29100049 29100049 PRJNA558770_P_NODE_140368_length_234_cov_7.160804_g138363_i0 PRJNA558770 140368 234 7.160804 16.75628136 Campylobacter concisus 199 Bacteria Bacteria 45.1 0.00522   NR MBS6285799.1 199 g138363 i0 68 0.320512820512821 25 8 32.1 0 234 160 7 31 MBS6285799.1 hypothetical protein [Campylobacter concisus] diamond 75 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
29604826 29604826 PRJNA558770_P_NODE_250170_length_234_cov_2.306533_g248165_i0 PRJNA558770 250170 234 2.306533 5.39728722 Campylobacter coli 195 Bacteria Bacteria 46.2 3.38e-4   NR WP_234899305.1 195 g248165 i0 100 0.294871794871795 23 0 29.5 0 229 161 40 62 WP_234899305.1 hypothetical protein, partial [Campylobacter coli] diamond 69 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
29667930 29667930 PRJNA558770_P_NODE_132270_length_234_cov_7.894472_g130265_i0 PRJNA558770 132270 234 7.894472 18.47306448 Aliarcobacter butzleri 28197 Bacteria Bacteria 45.1 0.00513   NR MCG3718125.1 28197 g130265 i0 95.8 2.15384615384615 24 1 30.8 0 3 74 283 306 MCG3718125.1 VCBS domain-containing protein [Aliarcobacter butzleri] diamond 504 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
30219278 30219278 PRJNA558770_P_NODE_167372_length_234_cov_5.316583_g165367_i0 PRJNA558770 167372 234 5.316583 12.44080422 Arcobacter 28196 Bacteria Bacteria 52.4 1.36e-5   NR WP_108557776.1 1912877 g165367 i0 100 0.923076923076923 24 0 30.8 0 2 73 56 79 WP_108557776.1 hypothetical protein [Arcobacter caeni] diamond 216 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter caeni
30426880 30426880 PRJNA558770_P_NODE_19993_length_444_cov_16.266504_g18123_i0 PRJNA558770 19993 444 16.266504 72.22327776 Helicobacter typhlonius 76936 Bacteria Bacteria 157 1.2499999999999997e-42   NR WP_334090207.1 76936 g18123 i0 88.1 0.567567567567568 84 10 56.8 0 352 101 227 310 WP_334090207.1 ISLre2 family transposase [Helicobacter typhlonius] diamond 252 157 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
30489681 30489681 PRJNA558770_P_NODE_197153_length_234_cov_3.894472_g195148_i0 PRJNA558770 197153 234 3.894472 9.11306448 uncultured Campylobacter sp. 218934 Bacteria Bacteria 53.9 1.49e-6   NR WP_299025782.1 218934 g195148 i0 100 0.294871794871795 23 0 29.5 0 75 7 34 56 WP_299025782.1 D-glycero-alpha-D-manno-heptose-1,7-bisphosphate 7-phosphatase [uncultured Campylobacter sp.] diamond 69 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
30521250 30521250 PRJNA558770_P_NODE_358533_length_232_cov_8.583756_g356528_i0 PRJNA558770 358533 232 8.583756 19.91431392 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.00626   NR GAA9209418.1 210 g356528 i0 72.7 0.568965517241379 22 6 28.4 0 226 161 1 22 GAA9209418.1 hypothetical protein Kyoto198A_1710 [Helicobacter pylori] diamond 132 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30552696 30552696 PRJNA558770_P_NODE_236453_length_234_cov_2.633166_g234448_i0 PRJNA558770 236453 234 2.633166 6.16160844 Campylobacter jejuni 197 Bacteria Bacteria 54.7 5.38e-7   NR WP_323470850.1 197 g234448 i0 96 0.320512820512821 25 1 32.1 0 1 75 125 149 WP_323470850.1 hypothetical protein, partial [Campylobacter jejuni] diamond 75 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
30552715 30552715 PRJNA558770_P_NODE_282693_length_234_cov_1.693467_g280688_i0 PRJNA558770 282693 234 1.693467 3.96271278 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0424   NR GAA8857246.1 210 g280688 i0 65.2 0.884615384615385 23 8 29.5 0 72 4 79 101 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 207 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30819678 30819678 PRJNA558770_P_NODE_279374_length_234_cov_1.743719_g277369_i0 PRJNA558770 279374 234 1.743719 4.08030246 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.0027   NR OHD99964.1 1802252 g277369 i0 83.3 9.23076923076923 24 4 30.8 0 75 4 384 407 OHD99964.1 MAG: lysine--tRNA ligase, partial [Sulfurimonas sp. RIFCSPLOWO2_02_FULL_36_28] diamond 2160 46.2 0.991341991341991 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp. RIFCSPLOWO2_02_FULL_36_28
31532813 31532813 PRJNA558770_P_NODE_120096_length_234_cov_9.201005_g118091_i0 PRJNA558770 120096 234 9.201005 21.5303517 Helicobacter pylori 210 Bacteria Bacteria 53.9 2.06e-7   NR GAA6966648.1 210 g118091 i0 44.8 0.858974358974359 67 11 85.9 1 10 210 1 41 GAA6966648.1 hypothetical protein Kyoto211A_2720 [Helicobacter pylori] diamond 201 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31564547 31564547 PRJNA558770_P_NODE_26816_length_407_cov_2.696237_g24864_i0 PRJNA558770 26816 407 2.696237 10.97368459 Helicobacter pylori 210 Bacteria Bacteria 51.2 9.38e-6   NR GAA8930966.1 210 g24864 i0 91.3 0.16953316953317 23 2 17 0 243 175 24 46 GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori] diamond 69 51.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31596142 31596142 PRJNA558770_P_NODE_217096_length_234_cov_3.180905_g215091_i0 PRJNA558770 217096 234 3.180905 7.4433177 Helicobacter pylori 210 Bacteria Bacteria 55.8 2.42e-8   NR GAA8930966.1 210 g215091 i0 48.4 0.82051282051282 64 11 82.1 1 233 42 3 44 GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori] diamond 192 55.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31943688 31943688 PRJNA558770_P_NODE_265357_length_234_cov_1.994975_g263352_i0 PRJNA558770 265357 234 1.994975 4.6682415 Campylobacterota bacterium 2026809 Bacteria Bacteria 47 7.03e-4   NR MCI0500248.1 2026809 g263352 i0 87 0.294871794871795 23 3 29.5 0 230 162 139 161 MCI0500248.1 transposase [Campylobacterota bacterium] diamond 69 47 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
31943721 31943721 PRJNA558770_P_NODE_47117_length_313_cov_2.989209_g45115_i0 PRJNA558770 47117 313 2.989209 9.35622417 Helicobacter pylori 210 Bacteria Bacteria 50.4 4.92e-6   NR GAA9176821.1 210 g45115 i0 46 0.603833865814696 63 10 60.4 1 200 12 1 39 GAA9176821.1 hypothetical protein Kyoto193A_1140 [Helicobacter pylori] diamond 189 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32070400 32070400 PRJNA558770_P_NODE_179498_length_234_cov_4.668342_g177493_i0 PRJNA558770 179498 234 4.668342 10.92392028 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 44.7 0.00692   NR MCD4757341.1 2808971 g177493 i0 86.4 0.282051282051282 22 3 28.2 0 9 74 733 754 MCD4757341.1 MMPL family transporter [Arcobacteraceae bacterium] diamond 66 44.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium
32084440 32084440 PRJNA558770_P_NODE_144918_length_234_cov_6.793970_g142913_i0 PRJNA558770 144918 234 6.79397 15.8978898 Bacteria 2 Bacteria Bacteria 66.2 1.67e-10   NR WP_334090207.1 76936 g142913 i0 93.9 2.11538461538462 33 2 42.3 0 2 100 364 396 WP_334090207.1 ISLre2 family transposase [Helicobacter typhlonius] diamond 495 66.6 0.993993993993994 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
32306265 32306265 PRJNA558770_P_NODE_206299_length_234_cov_3.542714_g204294_i0 PRJNA558770 206299 234 3.542714 8.28995076 Campylobacter 194 Bacteria Bacteria 55.8 1.81e-7   NR WP_141090211.1 199 g204294 i0 100 6.73076923076923 25 0 32.1 0 1 75 80 104 WP_141090211.1 FAD-binding protein, partial [Campylobacter concisus] diamond 1575 55.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus

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