RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA1241156" 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

  • PRJNA1241156 · 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
10553643 10553643 PRJNA1241156_S_NODE_14869_length_389_cov_13.820809_g14409_i0 PRJNA1241156 14869 389 13.820809 53.76294701 Helicobacter pylori 210 Bacteria Bacteria 124 3.7299999999999997e-34   NR WP_322538256.1 210 g14409 i0 77.2 0.609254498714653 79 18 60.9 0 28 264 2 80 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 237 124 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
15653128 15653128 PRJNA1241156_S_NODE_54793_length_264_cov_39.072398_g54333_i0 PRJNA1241156 54793 264 39.072398 103.15113072 Helicobacter pylori 210 Bacteria Bacteria 74.7 2.32e-15   NR GAA8565153.1 210 g54333 i0 96.8 0.352272727272727 31 1 35.2 0 93 1 40 70 GAA8565153.1 hypothetical protein oki142_14710 [Helicobacter pylori] diamond 93 74.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26661753 26661753 PRJNA1241156_S_NODE_42101_length_296_cov_32.296443_g41641_i0 PRJNA1241156 42101 296 32.296443 95.59747128 Helicobacter pylori 210 Bacteria Bacteria 79.7 3.58e-17   NR GAA8565153.1 210 g41641 i0 94.1 0.344594594594595 34 2 34.5 0 102 1 37 70 GAA8565153.1 hypothetical protein oki142_14710 [Helicobacter pylori] diamond 102 79.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26788862 26788862 PRJNA1241156_S_NODE_33641_length_320_cov_1.545126_g33181_i0 PRJNA1241156 33641 320 1.545126 4.9444032 Helicobacter pylori 210 Bacteria Bacteria 44.3 0.00417   NR GAA9209820.1 210 g33181 i0 61.8 0.31875 34 13 31.9 0 54 155 11 44 GAA9209820.1 hypothetical protein Kyoto198A_1890 [Helicobacter pylori] diamond 102 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26915349 26915349 PRJNA1241156_S_NODE_30082_length_330_cov_4.439024_g29622_i0 PRJNA1241156 30082 330 4.439024 14.6487792 Sulfurospirillum tamanense 2813362 Bacteria Bacteria 152 2.13e-45   NR WP_205458348.1 2813362 g29622 i0 93.1 0.654545454545455 72 5 65.5 0 329 114 40 111 WP_205458348.1 toxin-antitoxin system TumE family protein [Sulfurospirillum tamanense] diamond 216 152 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum tamanense
27231584 27231584 PRJNA1241156_S_NODE_24703_length_348_cov_2.400000_g24243_i0 PRJNA1241156 24703 348 2.4 8.352 Sulfurospirillum tamanense 2813362 Bacteria Bacteria 158 6.35e-45   NR WP_205458519.1 2813362 g24243 i0 86.2 0.810344827586207 94 13 81 0 339 58 49 142 WP_205458519.1 GTP 3',8-cyclase MoaA [Sulfurospirillum tamanense] diamond 282 158 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum tamanense
28147586 28147586 PRJNA1241156_S_NODE_21845_length_358_cov_4.761905_g21385_i0 PRJNA1241156 21845 358 4.761905 17.0476199 Helicobacter pylori 210 Bacteria Bacteria 45.1 0.00292   NR GAA6978086.1 210 g21385 i0 53.7 0.343575418994413 41 19 34.4 0 124 2 43 83 GAA6978086.1 hypothetical protein Kyoto211A_3420 [Helicobacter pylori] diamond 123 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28178745 28178745 PRJNA1241156_S_NODE_59066_length_255_cov_7.438679_g58606_i0 PRJNA1241156 59066 255 7.438679 18.96863145 Helicobacter pylori 210 Bacteria Bacteria 46.2 5.23e-4   NR GAA9128289.1 210 g58606 i0 70.3 0.870588235294118 37 10 43.5 1 66 176 65 100 GAA9128289.1 hypothetical protein Kyoto190A_1620 [Helicobacter pylori] diamond 222 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28512805 28512805 PRJNA1241156_S_NODE_64507_length_244_cov_4.029851_g64047_i0 PRJNA1241156 64507 244 4.029851 9.83283644 root 1 Root_unresolved Root_unresolved 57.4 1.82e-8   NR GAA8950681.1 210 g64047 i0 44.6 1.59836065573771 65 36 79.9 0 242 48 3 67 GAA8950681.1 hypothetical protein Kyoto181A_1580 [Helicobacter pylori] diamond 390 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28544622 28544622 PRJNA1241156_S_NODE_60327_length_253_cov_1.861905_g59867_i0 PRJNA1241156 60327 253 1.861905 4.71061965 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.01e-5   NR GAA9253554.1 210 g59867 i0 53.3 5.90513833992095 45 20 52.2 1 152 21 20 64 GAA9253554.1 hypothetical protein Kyoto199A_2770 [Helicobacter pylori] diamond 1494 50.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28715846 28715846 PRJNA1241156_S_NODE_48287_length_280_cov_4.063291_g47827_i0 PRJNA1241156 48287 280 4.063291 11.3772148 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.0218   NR GAA9099266.1 210 g47827 i0 34.5 1.81071428571429 84 53 88.9 2 268 20 77 159 GAA9099266.1 hypothetical protein Taitung37_13780 [Helicobacter pylori] diamond 507 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28747339 28747339 PRJNA1241156_S_NODE_44267_length_291_cov_1.915323_g43807_i0 PRJNA1241156 44267 291 1.915323 5.57358993 Helicobacter pylori 210 Bacteria Bacteria 70.1 2.54e-13   NR GAA8855521.1 210 g43807 i0 54.7 0.65979381443299 64 28 66 1 281 90 4 66 GAA8855521.1 hypothetical protein Kyoto154A_1840 [Helicobacter pylori] diamond 192 70.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29000298 29000298 PRJNA1241156_S_NODE_44508_length_290_cov_3.319838_g44048_i0 PRJNA1241156 44508 290 3.319838 9.6275302 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.00294   NR GAA9043165.1 210 g44048 i0 64.3 0.703448275862069 28 10 29 0 168 85 14 41 GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori] diamond 204 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29694198 29694198 PRJNA1241156_S_NODE_27650_length_338_cov_1.952542_g27190_i0 PRJNA1241156 27650 338 1.952542 6.59959196 Helicobacter pylori 210 Bacteria Bacteria 70.1 1.06e-11   NR GAA6795622.1 210 g27190 i0 67.4 12.2041420118343 43 14 38.2 0 177 305 150 192 GAA6795622.1 hypothetical protein Kyoto200A_0460 [Helicobacter pylori] diamond 4125 70.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30073429 30073429 PRJNA1241156_S_NODE_20312_length_364_cov_4.386293_g19852_i0 PRJNA1241156 20312 364 4.386293 15.96610652 Helicobacter pylori 210 Bacteria Bacteria 43.1 0.012   NR GAA9041684.1 210 g19852 i0 32.8 0.527472527472527 64 41 51.1 1 19 204 10 73 GAA9041684.1 hypothetical protein Kyoto184A_02200 [Helicobacter pylori] diamond 192 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30358403 30358403 PRJNA1241156_S_NODE_41352_length_299_cov_1.253906_g40892_i0 PRJNA1241156 41352 299 1.253906 3.74917894 Helicobacter pylori 210 Bacteria Bacteria 53.5 7.6e-6   NR GAA8734012.1 210 g40892 i0 33.8 2.96989966555184 74 49 74.2 0 243 22 130 203 GAA8734012.1 hypothetical protein Kyoto147A_1470 [Helicobacter pylori] diamond 888 53.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30736962 30736962 PRJNA1241156_S_NODE_64214_length_245_cov_1.589109_g63754_i0 PRJNA1241156 64214 245 1.589109 3.89331705 Helicobacter pylori 210 Bacteria Bacteria 45.4 0.00332   NR GAA9038731.1 210 g63754 i0 61.3 1.37142857142857 31 12 38 0 12 104 161 191 GAA9038731.1 hypothetical protein Kyoto184A_01380 [Helicobacter pylori] diamond 336 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31053311 31053311 PRJNA1241156_S_NODE_22355_length_356_cov_5.108626_g21895_i0 PRJNA1241156 22355 356 5.108626 18.18670856 Helicobacter pylori 210 Bacteria Bacteria 55.1 3.67e-7   NR GAA9051873.1 210 g21895 i0 50 0.48876404494382 58 25 48.9 1 52 225 4 57 GAA9051873.1 hypothetical protein Kyoto184A_04040 [Helicobacter pylori] diamond 174 55.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31305826 31305826 PRJNA1241156_S_NODE_46195_length_286_cov_1.320988_g45735_i0 PRJNA1241156 46195 286 1.320988 3.77802568 Helicobacter pylori 210 Bacteria Bacteria 57 3.43e-7   NR GAA8734012.1 210 g45735 i0 50.9 2.23426573426573 55 25 55.6 1 230 72 32 86 GAA8734012.1 hypothetical protein Kyoto147A_1470 [Helicobacter pylori] diamond 639 57 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31653625 31653625 PRJNA1241156_S_NODE_34857_length_316_cov_5.516484_g34397_i0 PRJNA1241156 34857 316 5.516484 17.43208944 Helicobacter pylori 210 Bacteria Bacteria 55.5 9.79e-7   NR GAA9039287.1 210 g34397 i0 59.1 0.417721518987342 44 14 38 1 122 3 4 47 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 132 55.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31875089 31875089 PRJNA1241156_S_NODE_35957_length_313_cov_5.151852_g35497_i0 PRJNA1241156 35957 313 5.151852 16.12529676 Helicobacter pylori 210 Bacteria Bacteria 44.3 0.00257   NR GAA6935188.1 210 g35497 i0 54.1 0.354632587859425 37 17 35.5 0 53 163 18 54 GAA6935188.1 hypothetical protein Kyoto207A_5030 [Helicobacter pylori] diamond 111 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31906862 31906862 PRJNA1241156_S_NODE_21137_length_361_cov_2.861635_g20677_i0 PRJNA1241156 21137 361 2.861635 10.33050235 Helicobacter pylori 210 Bacteria Bacteria 49.7 2.04e-5   NR GAA8966937.1 210 g20677 i0 61.1 0.656509695290859 36 14 29.9 0 213 320 16 51 GAA8966937.1 hypothetical protein Kyoto181A_4130 [Helicobacter pylori] diamond 237 49.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31906863 31906863 PRJNA1241156_S_NODE_31697_length_325_cov_5.212766_g31237_i0 PRJNA1241156 31697 325 5.212766 16.9414895 Helicobacter sp. 12S 218 Bacteria Bacteria 64.3 2.31e-9   NR WP_095225670.1 1476199 g31237 i0 50.8 0.544615384615385 59 29 54.5 0 303 127 313 371 WP_095225670.1 restriction endonuclease subunit S [Helicobacter sp. 12S02634-8] diamond 177 64.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. 12S02634-8
31970095 31970095 PRJNA1241156_S_NODE_53998_length_266_cov_5.641256_g53538_i0 PRJNA1241156 53998 266 5.641256 15.00574096 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0187   NR GAA9083901.1 210 g53538 i0 40.6 0.360902255639098 32 19 36.1 0 123 28 6 37 GAA9083901.1 hypothetical protein Kyoto184A_07720 [Helicobacter pylori] diamond 96 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31970096 31970096 PRJNA1241156_S_NODE_71478_length_223_cov_7.911111_g71018_i0 PRJNA1241156 71478 223 7.911111 17.64177753 Helicobacter pylori 210 Bacteria Bacteria 54.3 1.31e-7   NR GAA9043861.1 210 g71018 i0 63.4 1.00896860986547 41 15 55.2 0 204 82 17 57 GAA9043861.1 hypothetical protein Kyoto184A_02700 [Helicobacter pylori] diamond 225 54.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32033457 32033457 PRJNA1241156_S_NODE_16518_length_380_cov_43.317507_g16058_i0 PRJNA1241156 16518 380 43.317507 164.6065266 Helicobacter pylori 210 Bacteria Bacteria 143 1.66e-41   NR WP_322538256.1 210 g16058 i0 97.2 0.560526315789474 71 2 56.1 0 3 215 37 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 213 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32065008 32065008 PRJNA1241156_S_NODE_57518_length_259_cov_0.990741_g57058_i0 PRJNA1241156 57518 259 0.990741 2.56601919 Helicobacter pylori 210 Bacteria Bacteria 47 8.46e-5   NR GAA8706462.1 210 g57058 i0 52.4 0.486486486486487 42 18 48.6 1 33 158 1 40 GAA8706462.1 hypothetical protein Kyoto145A_3610 [Helicobacter pylori] diamond 126 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32399747 32399747 PRJNA1241156_S_NODE_35979_length_313_cov_4.807407_g35519_i0 PRJNA1241156 35979 313 4.807407 15.04718391 root 1 Root_unresolved Root_unresolved 54.3 7.35e-7   NR GAA9128289.1 210 g35519 i0 60.5 0.824281150159744 43 17 41.2 0 170 298 21 63 GAA9128289.1 hypothetical protein Kyoto190A_1620 [Helicobacter pylori] diamond 258 54.7 0.992687385740402 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32476587 32476587 PRJNA1241156_S_NODE_53339_length_268_cov_2.173333_g52879_i0 PRJNA1241156 53339 268 2.173333 5.82453244 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0244   NR GAA8913412.1 210 g52879 i0 55.2 0.324626865671642 29 13 32.5 0 218 132 29 57 GAA8913412.1 hypothetical protein Kyoto166A_2650 [Helicobacter pylori] diamond 87 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32652029 32652029 PRJNA1241156_S_NODE_24340_length_349_cov_4.300654_g23880_i0 PRJNA1241156 24340 349 4.300654 15.00928246 root 1 Root_unresolved Root_unresolved 54.7 3.86e-6   NR GAA9246106.1 210 g23880 i0 38.8 2.75071633237822 80 42 62.8 2 298 80 81 160 GAA9246106.1 hypothetical protein Kyoto199A_0220 [Helicobacter pylori] diamond 960 54.7 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);;