RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJNA1150539" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1150539 · 35 ✖

analysis 1

  • diamond · 35 ✖

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
26596817 26596817 PRJNA1150539_S_NODE_94021_length_249_cov_1.750000_g93425_i0 PRJNA1150539 94021 249 1.75 4.3575 Helicobacter pylori 210 Bacteria Bacteria 40 0.0336   NR GAA9046745.1 210 g93425 i0 45.5 0.397590361445783 33 18 39.8 0 143 241 9 41 GAA9046745.1 hypothetical protein Kyoto184A_03240 [Helicobacter pylori] diamond 99 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26787198 26787198 PRJNA1150539_S_NODE_34601_length_341_cov_5.723881_g34005_i0 PRJNA1150539 34601 341 5.723881 19.51843421 Helicobacter pylori 210 Bacteria Bacteria 47.4 1.16e-4   NR GAA8701437.1 210 g34005 i0 63.3 0.263929618768328 30 11 26.4 0 18 107 15 44 GAA8701437.1 hypothetical protein Kyoto145A_3300 [Helicobacter pylori] diamond 90 47.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26976940 26976940 PRJNA1150539_S_NODE_108162_length_229_cov_3.724359_g107566_i0 PRJNA1150539 108162 229 3.724359 8.52878211 Campylobacter jejuni 197 Bacteria Bacteria 52.4 6.56e-7   NR WP_240373355.1 197 g107566 i0 87 0.301310043668122 23 3 30.1 0 70 2 43 65 WP_240373355.1 hypothetical protein, partial [Campylobacter jejuni] diamond 69 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27185926 27185926 PRJNA1150539_S_NODE_63442_length_289_cov_2.472222_g62846_i0 PRJNA1150539 63442 289 2.472222 7.14472158 root 1 Root_unresolved Root_unresolved 54.3 1.26e-6   NR GAA9396157.1 210 g62846 i0 64.5 5.14878892733564 31 11 32.2 0 10 102 90 120 GAA9396157.1 hypothetical protein BTM418_15410 [Helicobacter pylori] diamond 1488 54.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27356530 27356530 PRJNA1150539_S_NODE_92923_length_250_cov_2.101695_g92327_i0 PRJNA1150539 92923 250 2.101695 5.2542375 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00444   NR GAA6873552.1 210 g92327 i0 59.5 0.444 37 15 44.4 0 2 112 13 49 GAA6873552.1 hypothetical protein Kyoto206A_4030 [Helicobacter pylori] diamond 111 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27640723 27640723 PRJNA1150539_S_NODE_41684_length_326_cov_4.407115_g41088_i0 PRJNA1150539 41684 326 4.407115 14.3671949 Helicobacter pylori 210 Bacteria Bacteria 42 0.029   NR GAA6971289.1 210 g41088 i0 48.9 0.414110429447853 45 18 36.8 1 138 19 25 69 GAA6971289.1 hypothetical protein Kyoto211A_3020 [Helicobacter pylori] diamond 135 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28145940 28145940 PRJNA1150539_S_NODE_74425_length_273_cov_2.695000_g73829_i0 PRJNA1150539 74425 273 2.695 7.35735 Helicobacter pylori 210 Bacteria Bacteria 67.4 1.58e-11   NR GAA8949042.1 210 g73829 i0 53.4 4.26373626373626 58 24 60.4 1 272 108 61 118 GAA8949042.1 hypothetical protein Kyoto181A_0860 [Helicobacter pylori] diamond 1164 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28493132 28493132 PRJNA1150539_S_NODE_32147_length_347_cov_3.806569_g31551_i0 PRJNA1150539 32147 347 3.806569 13.20879443 Helicobacter pylori 210 Bacteria Bacteria 45.4 8.11e-4   NR GAA8966937.1 210 g31551 i0 66.7 0.259365994236311 30 10 25.9 0 169 80 4 33 GAA8966937.1 hypothetical protein Kyoto181A_4130 [Helicobacter pylori] diamond 90 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28840280 28840280 PRJNA1150539_S_NODE_108008_length_230_cov_2.089172_g107412_i0 PRJNA1150539 108008 230 2.089172 4.8050956 Helicobacter pylori 210 Bacteria Bacteria 66.6 4.16e-12   NR WP_322538256.1 210 g107412 i0 58.2 0.717391304347826 55 23 71.7 0 217 53 53 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 165 66.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29333405 29333405 PRJNA1150539_S_NODE_80529_length_265_cov_2.328125_g79933_i0 PRJNA1150539 80529 265 2.328125 6.16953125 root 1 Root_unresolved Root_unresolved 46.2 0.00238   NR WP_341557095.1 197 g79933 i0 50 0.99622641509434 44 22 49.8 0 152 21 193 236 WP_341557095.1 RBD-like domain-containing protein, partial [Campylobacter jejuni] diamond 264 46.6 0.991416309012876 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
29503290 29503290 PRJNA1150539_S_NODE_54650_length_303_cov_2.308696_g54054_i0 PRJNA1150539 54650 303 2.308696 6.99534888 Helicobacter pylori 210 Bacteria Bacteria 52 1.46e-5   NR GAA9208922.1 210 g54054 i0 51 6.68316831683168 49 19 43.6 1 72 203 12 60 GAA9208922.1 hypothetical protein Kyoto198A_1360 [Helicobacter pylori] diamond 2025 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29554207 29554207 PRJNA1150539_S_NODE_102490_length_241_cov_1.952381_g101894_i0 PRJNA1150539 102490 241 1.952381 4.70523821 Bacteria 2 Bacteria Bacteria 47.8 5.09e-5   NR GAA6801467.1 210 g101894 i0 62.5 2.42738589211618 32 12 39.8 0 131 226 24 55 GAA6801467.1 hypothetical protein Kyoto200A_2170 [Helicobacter pylori] diamond 585 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29597802 29597802 PRJNA1150539_S_NODE_88910_length_255_cov_1.247253_g88314_i0 PRJNA1150539 88910 255 1.247253 3.18049515 Helicobacter pylori 210 Bacteria Bacteria 47.8 7.32e-5   NR GAA8706992.1 210 g88314 i0 51.6 0.364705882352941 31 15 36.5 0 155 247 35 65 GAA8706992.1 hypothetical protein Kyoto145A_3660 [Helicobacter pylori] diamond 93 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29629343 29629343 PRJNA1150539_S_NODE_30750_length_351_cov_1.658273_g30154_i0 PRJNA1150539 30750 351 1.658273 5.82053823 Helicobacter pylori 210 Bacteria Bacteria 47.8 7.88e-4   NR GAA6966708.1 210 g30154 i0 38.3 0.692307692307692 81 46 65.8 2 304 74 25 105 GAA6966708.1 hypothetical protein Kyoto211A_2740 [Helicobacter pylori] diamond 243 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29711904 29711904 PRJNA1150539_S_NODE_54510_length_303_cov_3.239130_g53914_i0 PRJNA1150539 54510 303 3.23913 9.8145639 root 1 Root_unresolved Root_unresolved 62.4 9.84e-10   NR GAA8857246.1 210 g53914 i0 65.8 1.10891089108911 38 13 37.6 0 300 187 39 76 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 336 62.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30103318 30103318 PRJNA1150539_S_NODE_18892_length_386_cov_4.964856_g18296_i0 PRJNA1150539 18892 386 4.964856 19.16434416 Helicobacter pylori 210 Bacteria Bacteria 51.6 4.44e-6   NR GAA8856488.1 210 g18296 i0 56.1 1.0259067357513 41 18 31.9 0 170 48 7 47 GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori] diamond 396 51.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30293461 30293461 PRJNA1150539_S_NODE_19032_length_386_cov_2.153355_g18436_i0 PRJNA1150539 19032 386 2.153355 8.3119503 Helicobacter pylori 210 Bacteria Bacteria 65.5 1.52e-10   NR GAA8857246.1 210 g18436 i0 48.2 0.83160621761658 56 26 43.5 1 85 252 37 89 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 321 65.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30451277 30451277 PRJNA1150539_S_NODE_91593_length_251_cov_4.539326_g90997_i0 PRJNA1150539 91593 251 4.539326 11.39370826 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00529   NR GAA9131483.1 210 g90997 i0 40.8 0.585657370517928 49 28 58.6 1 211 65 18 65 GAA9131483.1 hypothetical protein Kyoto190A_2210 [Helicobacter pylori] diamond 147 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30482683 30482683 PRJNA1150539_S_NODE_81633_length_264_cov_1.209424_g81037_i0 PRJNA1150539 81633 264 1.209424 3.19287936 Helicobacter pylori 210 Bacteria Bacteria 66.6 1.41e-11   NR GAA8857246.1 210 g81037 i0 59.2 1.75 49 17 52.3 1 25 162 61 109 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 462 66.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30514222 30514222 PRJNA1150539_S_NODE_63873_length_288_cov_4.627907_g63277_i0 PRJNA1150539 63873 288 4.627907 13.32837216 Helicobacter pylori 210 Bacteria Bacteria 70.9 8.5e-14   NR GAA6863873.1 210 g63277 i0 49.3 0.697916666666667 67 33 69.8 1 36 236 8 73 GAA6863873.1 hypothetical protein Kyoto206A_2050 [Helicobacter pylori] diamond 201 70.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30545800 30545800 PRJNA1150539_S_NODE_31753_length_348_cov_3.818182_g31157_i0 PRJNA1150539 31753 348 3.818182 13.28727336 Helicobacter pylori 210 Bacteria Bacteria 47.8 1.32e-4   NR GAA9020730.1 210 g31157 i0 60 1.14655172413793 40 15 33.6 1 201 85 13 52 GAA9020730.1 hypothetical protein Kyoto181A_7750 [Helicobacter pylori] diamond 399 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30608880 30608880 PRJNA1150539_S_NODE_97853_length_245_cov_3.255814_g97257_i0 PRJNA1150539 97853 245 3.255814 7.9767443 Helicobacter pylori 210 Bacteria Bacteria 40.4 0.0468   NR GAA8968912.1 210 g97257 i0 55.6 0.440816326530612 36 15 42.9 1 199 95 23 58 GAA8968912.1 hypothetical protein Kyoto181A_4280 [Helicobacter pylori] diamond 108 40.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30754862 30754862 PRJNA1150539_S_NODE_73934_length_274_cov_1.611940_g73338_i0 PRJNA1150539 73934 274 1.61194 4.4167156 root 1 Root_unresolved Root_unresolved 41.6 0.0268   NR GAA8913412.1 210 g73338 i0 57.6 0.722627737226277 33 13 35 1 162 67 28 60 GAA8913412.1 hypothetical protein Kyoto166A_2650 [Helicobacter pylori] diamond 198 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30925195 30925195 PRJNA1150539_S_NODE_74074_length_274_cov_1.149254_g73478_i0 PRJNA1150539 74074 274 1.149254 3.14895596 Campylobacter jejuni 197 Bacteria Bacteria 58.2 8.16e-9   NR WP_341549736.1 197 g73478 i0 51.7 1.37956204379562 60 26 65.7 1 94 273 7 63 WP_341549736.1 hypothetical protein, partial [Campylobacter jejuni] diamond 378 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31082942 31082942 PRJNA1150539_S_NODE_104295_length_238_cov_2.569697_g103699_i0 PRJNA1150539 104295 238 2.569697 6.11587886 Helicobacter pylori 210 Bacteria Bacteria 67.4 1.94e-11   NR GAA9038606.1 210 g103699 i0 69.8 8.07983193277311 43 13 54.2 0 155 27 41 83 GAA9038606.1 hypothetical protein Kyoto184A_01320 [Helicobacter pylori] diamond 1923 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31462578 31462578 PRJNA1150539_S_NODE_30176_length_352_cov_3.580645_g29580_i0 PRJNA1150539 30176 352 3.580645 12.6038704 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.0158   NR GAA9136539.1 210 g29580 i0 55 0.340909090909091 40 18 34.1 0 334 215 2 41 GAA9136539.1 hypothetical protein Kyoto190A_2700 [Helicobacter pylori] diamond 120 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31683588 31683588 PRJNA1150539_S_NODE_7717_length_470_cov_30.760705_g7123_i0 PRJNA1150539 7717 470 30.760705 144.5753135 Helicobacter pylori 210 Bacteria Bacteria 166 2.72e-50   NR WP_322538256.1 210 g7123 i0 95.2 0.536170212765957 84 4 53.6 0 22 273 24 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 252 166 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32031846 32031846 PRJNA1150539_S_NODE_86138_length_258_cov_2.048649_g85542_i0 PRJNA1150539 86138 258 2.048649 5.28551442 Campylobacter jejuni 197 Bacteria Bacteria 62 4.63e-10   NR WP_341550930.1 197 g85542 i0 55.8 0.604651162790698 52 22 59.3 1 106 258 10 61 WP_341550930.1 hypothetical protein, partial [Campylobacter jejuni] diamond 156 62 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32253553 32253553 PRJNA1150539_S_NODE_84658_length_260_cov_1.647059_g84062_i0 PRJNA1150539 84658 260 1.647059 4.2823534 Helicobacter pylori 210 Bacteria Bacteria 63.9 2.99e-11   NR GAA6904105.1 210 g84062 i0 63.3 0.565384615384615 49 18 56.5 0 7 153 23 71 GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori] diamond 147 63.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32272892 32272892 PRJNA1150539_S_NODE_64078_length_288_cov_2.446512_g63482_i0 PRJNA1150539 64078 288 2.446512 7.04595456 root 1 Root_unresolved Root_unresolved 60.1 4.55e-9   NR GAA8950930.1 210 g63482 i0 57.1 1.16666666666667 56 23 58.3 1 106 273 59 113 GAA8950930.1 hypothetical protein Kyoto181A_1790 [Helicobacter pylori] diamond 336 60.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32474923 32474923 PRJNA1150539_S_NODE_97859_length_245_cov_3.226744_g97263_i0 PRJNA1150539 97859 245 3.226744 7.9055228 Aliarcobacter sp. 2321116 Bacteria Bacteria 41.6 0.0378   NR MBP6713734.1 2321116 g97263 i0 37.5 0.685714285714286 56 33 68.6 1 56 223 20 73 MBP6713734.1 DUF2513 domain-containing protein [Aliarcobacter sp.] diamond 168 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter sp.
32663928 32663928 PRJNA1150539_S_NODE_98300_length_245_cov_1.476744_g97704_i0 PRJNA1150539 98300 245 1.476744 3.6180228 Helicobacter pylori 210 Bacteria Bacteria 42 0.00991   NR GAA8685008.1 210 g97704 i0 45.7 0.563265306122449 46 25 56.3 0 198 61 1 46 GAA8685008.1 hypothetical protein Kyoto145A_1190 [Helicobacter pylori] diamond 138 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32695474 32695474 PRJNA1150539_S_NODE_84340_length_260_cov_2.882353_g83744_i0 PRJNA1150539 84340 260 2.882353 7.4941178 Helicobacter pylori 210 Bacteria Bacteria 54.3 1.46e-6   NR GAA9039287.1 210 g83744 i0 56.8 1.65 44 19 50.8 0 245 114 45 88 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 429 54.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32840735 32840735 PRJNA1150539_S_NODE_35520_length_339_cov_4.120301_g34924_i0 PRJNA1150539 35520 339 4.120301 13.96782039 root 1 Root_unresolved Root_unresolved 60.1 7.63e-9   NR WP_240382657.1 197 g34924 i0 52.4 1.48672566371681 84 38 72.6 2 82 327 24 107 WP_240382657.1 hypothetical protein, partial [Campylobacter jejuni] diamond 504 60.5 0.993388429752066 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32852983 32852983 PRJNA1150539_S_NODE_61540_length_292_cov_2.068493_g60944_i0 PRJNA1150539 61540 292 2.068493 6.03999956 Helicobacter pylori 210 Bacteria Bacteria 42 0.0112   NR GAA6907280.1 210 g60944 i0 71.4 0.565068493150685 28 8 28.8 0 34 117 13 40 GAA6907280.1 hypothetical protein Kyoto207A_2440 [Helicobacter pylori] diamond 165 42 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);;