RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where bioproject = "PRJNA1255065", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 33 ✖

tax_phylum 1

  • Campylobacterota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1255065 · 33 ✖

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
9981624 9981624 PRJNA1255065_P_NODE_82868_length_196_cov_1.231293_g80640_i0 PRJNA1255065 82868 196 1.231293 2.41333428 Campylobacter 194 Bacteria Bacteria 335 1.5e-87   NTclustered gi|2305955962|gb|CP012549.1| 1660063 g80640 i0 97.449 233.051020408163 196 5 100 0 1 196 819705 819900 Campylobacter sp. RM16187, complete genome blastn 45678 335 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. RM16187
22036600 22036600 PRJNA1255065_P_NODE_121258_length_167_cov_0.881356_g119030_i0 PRJNA1255065 121258 167 0.881356 1.47186452 Campylobacter lari 201 Bacteria Bacteria 52.8 0.014   NTclustered gi|2878623141|gb|CP176598.1| 488545 g119030 i0 100 0.167664670658683 28 0 17 0 102 129 278815 278788 Campylobacter lari subsp. concheus strain RM19156 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
24005177 24005177 PRJNA1255065_P_NODE_152379_length_162_cov_0.920354_g150151_i0 PRJNA1255065 152379 162 0.920354 1.49097348 Sulfurospirillum 57665 Bacteria Bacteria 300 4.36e-77   NTclustered gi|507148369|ref|NR_103172.1| 44674 g150151 i0 100 223.006172839506 162 0 100 0 1 162 1000 839 Sulfurospirillum barnesii strain SES-3 23S ribosomal RNA gene, complete sequence blastn 36127 300 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum barnesii
25279180 25279180 PRJNA1255065_P_NODE_126740_length_166_cov_0.888889_g124512_i0 PRJNA1255065 126740 166 0.888889 1.47555574 Sulfurospirillum 57665 Bacteria Bacteria 307 2.69e-79   NTclustered gi|757804895|dbj|AP014723.1| 1581011 g124512 i0 100 175.295180722892 166 0 100 0 1 166 1860665 1860830 Sulfurospirillum sp. UCH001 DNA, complete genome blastn 29099 307 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum sp. UCH001
26789117 26789117 PRJNA1255065_P_NODE_135841_length_164_cov_0.904348_g133613_i0 PRJNA1255065 135841 164 0.904348 1.48313072 Helicobacter pylori 210 Bacteria Bacteria 43.1 7.48e-4   NR GAA8701437.1 210 g133613 i0 63 0.49390243902439 27 10 49.4 0 6 86 18 44 GAA8701437.1 hypothetical protein Kyoto145A_3300 [Helicobacter pylori] diamond 81 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26852553 26852553 PRJNA1255065_P_NODE_111121_length_168_cov_0.873950_g108893_i0 PRJNA1255065 111121 168 0.87395 1.468236 Helicobacter pylori 210 Bacteria Bacteria 47 4.39e-5   NR GAA6904105.1 210 g108893 i0 51.1 0.839285714285714 47 19 76.8 1 39 167 19 65 GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori] diamond 141 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27800517 27800517 PRJNA1255065_P_NODE_136844_length_164_cov_0.904348_g134616_i0 PRJNA1255065 136844 164 0.904348 1.48313072 Campylobacter jejuni 197 Bacteria Bacteria 41.2 0.016   NR WP_215424964.1 197 g134616 i0 60 0.457317073170732 25 10 45.7 0 100 26 17 41 WP_215424964.1 hypothetical protein, partial [Campylobacter jejuni] diamond 75 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
28273812 28273812 PRJNA1255065_P_NODE_105366_length_169_cov_0.866667_g103138_i0 PRJNA1255065 105366 169 0.866667 1.46466723 Helicobacter pylori 210 Bacteria Bacteria 38.9 0.047   NR GAA8856038.1 210 g103138 i0 44.1 0.603550295857988 34 19 60.4 0 52 153 14 47 GAA8856038.1 hypothetical protein Kyoto154A_2020 [Helicobacter pylori] diamond 102 38.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28354921 28354921 PRJNA1255065_P_NODE_120606_length_167_cov_0.881356_g118378_i0 PRJNA1255065 120606 167 0.881356 1.47186452 root 1 Root_unresolved Root_unresolved 42.7 0.00321   NR GAA9044369.1 210 g118378 i0 60 1.11377245508982 30 12 53.9 0 61 150 56 85 GAA9044369.1 hypothetical protein Kyoto184A_02810 [Helicobacter pylori] diamond 186 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28639367 28639367 PRJNA1255065_P_NODE_110987_length_168_cov_0.873950_g108759_i0 PRJNA1255065 110987 168 0.87395 1.468236 root 1 Root_unresolved Root_unresolved 42 0.00528   NR GAA9181004.1 210 g108759 i0 55 1.32142857142857 40 18 71.4 0 139 20 33 72 GAA9181004.1 hypothetical protein Kyoto193A_2430 [Helicobacter pylori] diamond 222 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29270452 29270452 PRJNA1255065_P_NODE_153249_length_162_cov_0.920354_g151021_i0 PRJNA1255065 153249 162 0.920354 1.49097348 root 1 Root_unresolved Root_unresolved 47.4 2.79e-5   NR GAA9043165.1 210 g151021 i0 58.3 3.33333333333333 36 15 66.7 0 115 8 1 36 GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori] diamond 540 47.8 0.99163179916318 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29536917 29536917 PRJNA1255065_P_NODE_146450_length_163_cov_0.912281_g144222_i0 PRJNA1255065 146450 163 0.912281 1.48701803 Helicobacter pylori 210 Bacteria Bacteria 88.6 1.27e-20   NR MDO7823221.1 210 g144222 i0 97.8 0.846625766871166 46 1 84.7 0 26 163 2 47 MDO7823221.1 hypothetical protein [Helicobacter pylori] diamond 138 88.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29649144 29649144 PRJNA1255065_P_NODE_153090_length_162_cov_0.920354_g150862_i0 PRJNA1255065 153090 162 0.920354 1.49097348 root 1 Root_unresolved Root_unresolved 50.8 9.94e-7   NR GAA9119080.1 210 g150862 i0 70.3 3.01851851851852 37 11 68.5 0 161 51 20 56 GAA9119080.1 hypothetical protein Kyoto184A_10410 [Helicobacter pylori] diamond 489 50.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29820860 29820860 PRJNA1255065_P_NODE_110651_length_168_cov_1.050420_g108423_i0 PRJNA1255065 110651 168 1.05042 1.7647056 Helicobacter pylori 210 Bacteria Bacteria 56.2 5.4e-9   NR GAA8950290.1 210 g108423 i0 100 0.428571428571429 24 0 42.9 0 146 75 1 24 GAA8950290.1 hypothetical protein Kyoto181A_1480 [Helicobacter pylori] diamond 72 56.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29965402 29965402 PRJNA1255065_P_NODE_151411_length_162_cov_0.920354_g149183_i0 PRJNA1255065 151411 162 0.920354 1.49097348 root 1 Root_unresolved Root_unresolved 62.8 1.38e-10   NR GAA9396157.1 210 g149183 i0 64.1 4.98148148148148 39 14 72.2 0 10 126 87 125 GAA9396157.1 hypothetical protein BTM418_15410 [Helicobacter pylori] diamond 807 62.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30123159 30123159 PRJNA1255065_P_NODE_131872_length_165_cov_0.896552_g129644_i0 PRJNA1255065 131872 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 45.1 3.06e-4   NR GAA8909605.1 210 g129644 i0 56.1 1.38181818181818 41 17 72.7 1 120 1 20 60 GAA8909605.1 hypothetical protein Kyoto166A_1730 [Helicobacter pylori] diamond 228 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30199986 30199986 PRJNA1255065_P_NODE_92932_length_182_cov_1.563910_g90704_i0 PRJNA1255065 92932 182 1.56391 2.8463162 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.0121   NR GAA6966759.1 210 g90704 i0 37.5 0.791208791208791 48 30 79.1 0 3 146 10 57 GAA6966759.1 hypothetical protein Kyoto211A_2750 [Helicobacter pylori] diamond 144 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30313411 30313411 PRJNA1255065_P_NODE_74992_length_209_cov_1.950000_g72764_i0 PRJNA1255065 74992 209 1.95 4.0755 Pseudomonadati 3379134 Bacteria Bacteria 122 2.1e-34   NR MCH3865037.1 197 g72764 i0 89.6 3.81818181818182 67 7 96.2 0 208 8 17 83 MCH3865037.1 ATP-binding protein [Campylobacter jejuni] diamond 798 122 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
30453217 30453217 PRJNA1255065_P_NODE_94913_length_180_cov_1.190840_g92685_i0 PRJNA1255065 94913 180 1.19084 2.143512 Helicobacter pylori 210 Bacteria Bacteria 53.9 1.07e-7   NR GAA8968912.1 210 g92685 i0 55.3 0.783333333333333 47 21 78.3 0 143 3 1 47 GAA8968912.1 hypothetical protein Kyoto181A_4280 [Helicobacter pylori] diamond 141 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30516131 30516131 PRJNA1255065_P_NODE_124093_length_166_cov_0.888889_g121865_i0 PRJNA1255065 124093 166 0.888889 1.47555574 Desulfurellales bacterium 2482794 Bacteria Bacteria 65.1 2.31e-11   NR TXH42226.1 2482794 g121865 i0 69.8 0.77710843373494 43 13 77.7 0 38 166 3 45 TXH42226.1 MAG: hypothetical protein E6Q97_36120 [Desulfurellales bacterium] diamond 129 65.1 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30769000 30769000 PRJNA1255065_P_NODE_137474_length_164_cov_0.904348_g135246_i0 PRJNA1255065 137474 164 0.904348 1.48313072 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.00591   NR GAA8956022.1 210 g135246 i0 50 0.621951219512195 34 17 62.2 0 102 1 9 42 GAA8956022.1 hypothetical protein Kyoto181A_3010 [Helicobacter pylori] diamond 102 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31021695 31021695 PRJNA1255065_P_NODE_108175_length_169_cov_0.866667_g105947_i0 PRJNA1255065 108175 169 0.866667 1.46466723 Helicobacter pylori 210 Bacteria Bacteria 58.2 2.69e-9   NR GAA9055256.1 210 g105947 i0 61.5 0.692307692307692 39 15 69.2 0 52 168 32 70 GAA9055256.1 hypothetical protein Kyoto184A_04420 [Helicobacter pylori] diamond 117 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31591001 31591001 PRJNA1255065_P_NODE_79336_length_202_cov_1.000000_g77108_i0 PRJNA1255065 79336 202 1 2.02 Helicobacter pylori 210 Bacteria Bacteria 82.4 6.71e-19   NR GAA9224321.1 210 g77108 i0 100 1.0990099009901 37 0 55 0 1 111 4 40 GAA9224321.1 hypothetical protein Kyoto198A_4090 [Helicobacter pylori] diamond 222 82.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31685542 31685542 PRJNA1255065_P_NODE_131817_length_165_cov_0.896552_g129589_i0 PRJNA1255065 131817 165 0.896552 1.4793108 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.00845   NR GAA9041684.1 210 g129589 i0 35.8 0.963636363636364 53 34 96.4 0 159 1 11 63 GAA9041684.1 hypothetical protein Kyoto184A_02200 [Helicobacter pylori] diamond 159 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31685552 31685552 PRJNA1255065_P_NODE_93257_length_182_cov_1.172932_g91029_i0 PRJNA1255065 93257 182 1.172932 2.13473624 Helicobacter pylori 210 Bacteria Bacteria 38.9 0.043   NR GAA8413610.1 210 g91029 i0 57.6 0.543956043956044 33 14 54.4 0 111 13 3 35 GAA8413610.1 hypothetical protein Hpkin62_14730 [Helicobacter pylori] diamond 99 38.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31735066 31735066 PRJNA1255065_P_NODE_152037_length_162_cov_0.920354_g149809_i0 PRJNA1255065 152037 162 0.920354 1.49097348 root 1 Root_unresolved Root_unresolved 42.4 0.00411   NR WP_240373706.1 195 g149809 i0 53.8 3.74074074074074 52 18 94.4 2 161 9 6 52 WP_240373706.1 hypothetical protein, partial [Campylobacter coli] diamond 606 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
32019954 32019954 PRJNA1255065_P_NODE_117178_length_167_cov_0.881356_g114950_i0 PRJNA1255065 117178 167 0.881356 1.47186452 root 1 Root_unresolved Root_unresolved 63.5 2.92e-11   NR WP_240384377.1 197 g114950 i0 62 15.9161676646707 50 16 84.4 1 147 7 34 83 WP_240384377.1 hypothetical protein, partial [Campylobacter jejuni] diamond 2658 63.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32096928 32096928 PRJNA1255065_P_NODE_126818_length_166_cov_0.888889_g124590_i0 PRJNA1255065 126818 166 0.888889 1.47555574 Helicobacter pylori 210 Bacteria Bacteria 47.8 1.91e-5   NR GAA9062696.1 210 g124590 i0 49 0.885542168674699 49 25 88.6 0 162 16 19 67 GAA9062696.1 hypothetical protein Kyoto184A_05270 [Helicobacter pylori] diamond 147 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32223594 32223594 PRJNA1255065_P_NODE_100658_length_173_cov_1.677419_g98430_i0 PRJNA1255065 100658 173 1.677419 2.90193487 Helicobacter pylori 210 Bacteria Bacteria 55.5 1.01e-8   NR GAA9037979.1 210 g98430 i0 75.8 0.572254335260116 33 7 57.2 1 53 151 4 35 GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori] diamond 99 55.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32255559 32255559 PRJNA1255065_P_NODE_90918_length_185_cov_1.147059_g88690_i0 PRJNA1255065 90918 185 1.147059 2.12205915 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0395   NR GAA8685008.1 210 g88690 i0 50 0.583783783783784 36 18 58.4 0 33 140 28 63 GAA8685008.1 hypothetical protein Kyoto145A_1190 [Helicobacter pylori] diamond 108 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32540165 32540165 PRJNA1255065_P_NODE_142139_length_163_cov_0.912281_g139911_i0 PRJNA1255065 142139 163 0.912281 1.48701803 Helicobacter pylori 210 Bacteria Bacteria 55.1 4.05e-8   NR GAA9055256.1 210 g139911 i0 56 0.920245398773006 50 21 92 1 14 163 5 53 GAA9055256.1 hypothetical protein Kyoto184A_04420 [Helicobacter pylori] diamond 150 55.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32760458 32760458 PRJNA1255065_P_NODE_75940_length_208_cov_0.861635_g73712_i0 PRJNA1255065 75940 208 0.861635 1.7922008 Campylobacter coli 195 Bacteria Bacteria 45.8 0.00109   NR RJF56794.1 195 g73712 i0 45.1 0.735576923076923 51 28 73.6 0 53 205 20 70 RJF56794.1 hypothetical protein D4Z76_09165, partial [Campylobacter coli] diamond 153 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
32778153 32778153 PRJNA1255065_P_NODE_118220_length_167_cov_0.881356_g115992_i0 PRJNA1255065 118220 167 0.881356 1.47186452 root 1 Root_unresolved Root_unresolved 48.9 8.36e-5   NR GAA6899356.1 210 g115992 i0 60.4 4.31137724550898 48 17 82.6 2 162 25 18 65 GAA6899356.1 hypothetical protein Kyoto207A_1070 [Helicobacter pylori] diamond 720 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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