RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA764222" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA764222 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
3296110 3296110 PRJNA764222_S_NODE_5283_length_306_cov_1.988417_g5125_i0 PRJNA764222 5283 306 1.988417 6.08455602 Helicobacter pylori 210 Bacteria Bacteria 67.4 2.2e-12   NR GAA6904105.1 210 g5125 i0 55.6 0.529411764705882 54 19 48 1 203 57 18 71 GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori] diamond 162 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
21147096 21147096 PRJNA764222_S_NODE_13897_length_239_cov_2.145833_g13739_i0 PRJNA764222 13897 239 2.145833 5.12854087 root 1 Root_unresolved Root_unresolved 66.6 4.44e-12   NR WP_369084025.1 210 g13739 i0 64.2 10.3430962343096 53 19 66.5 0 81 239 42 94 WP_369084025.1 hypothetical protein, partial [Helicobacter pylori] diamond 2472 67 0.994029850746269 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26799974 26799974 PRJNA764222_S_NODE_20121_length_209_cov_1.000000_g19963_i0 PRJNA764222 20121 209 1 2.09 Helicobacter pylori 210 Bacteria Bacteria 57.4 2.68e-8   NR GAA8857246.1 210 g19963 i0 62.5 1.14832535885167 40 15 57.4 0 186 67 44 83 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 240 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26863695 26863695 PRJNA764222_S_NODE_24421_length_190_cov_4.629371_g24263_i0 PRJNA764222 24421 190 4.629371 8.7958049 Helicobacter pylori 210 Bacteria Bacteria 49.7 3.7e-6   NR GAA9007946.1 210 g24263 i0 68.6 0.552631578947368 35 11 55.3 0 181 77 9 43 GAA9007946.1 hypothetical protein Kyoto181A_6970 [Helicobacter pylori] diamond 105 49.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27622031 27622031 PRJNA764222_S_NODE_6544_length_291_cov_4.061475_g6386_i0 PRJNA764222 6544 291 4.061475 11.81889225 Helicobacter pylori 210 Bacteria Bacteria 45.4 0.00284   NR GAA8908272.1 210 g6386 i0 63.3 3.61855670103093 30 11 30.9 0 69 158 4 33 GAA8908272.1 hypothetical protein Kyoto166A_1320 [Helicobacter pylori] diamond 1053 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27653640 27653640 PRJNA764222_S_NODE_24324_length_191_cov_1.770833_g24166_i0 PRJNA764222 24324 191 1.770833 3.38229103 Campylobacter jejuni 197 Bacteria Bacteria 40 0.0376   NR WP_341549736.1 197 g24166 i0 41 1.90052356020942 61 35 94.2 1 182 3 7 67 WP_341549736.1 hypothetical protein, partial [Campylobacter jejuni] diamond 363 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27685348 27685348 PRJNA764222_S_NODE_9504_length_266_cov_2.913242_g9346_i0 PRJNA764222 9504 266 2.913242 7.74922372 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.0358   NR GAA9051873.1 210 g9346 i0 51.1 0.823308270676692 47 22 53 1 250 110 43 88 GAA9051873.1 hypothetical protein Kyoto184A_04040 [Helicobacter pylori] diamond 219 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28158881 28158881 PRJNA764222_S_NODE_26125_length_184_cov_1.145985_g25967_i0 PRJNA764222 26125 184 1.145985 2.1086124 Helicobacter pylori 210 Bacteria Bacteria 50.1 5.1e-6   NR GAA9209820.1 210 g25967 i0 51.1 0.733695652173913 45 22 73.4 0 136 2 35 79 GAA9209820.1 hypothetical protein Kyoto198A_1890 [Helicobacter pylori] diamond 135 50.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28168314 28168314 PRJNA764222_S_NODE_8785_length_272_cov_1.373333_g8627_i0 PRJNA764222 8785 272 1.373333 3.73546576 Campylobacterales 213849 Bacteria Bacteria 48.5 8.47e-5   NR WP_341549733.1 197 g8627 i0 50.9 1.93014705882353 53 24 58.5 1 170 12 57 107 WP_341549733.1 reverse transcriptase domain-containing protein, partial [Campylobacter jejuni] diamond 525 48.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
28221625 28221625 PRJNA764222_S_NODE_21826_length_201_cov_2.097403_g21668_i0 PRJNA764222 21826 201 2.097403 4.21578003 Helicobacter pylori 210 Bacteria Bacteria 87.4 1.86e-20   NR WP_322538256.1 210 g21668 i0 63.6 0.985074626865672 66 24 98.5 0 1 198 42 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 198 87.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28221627 28221627 PRJNA764222_S_NODE_4466_length_318_cov_4.125461_g4308_i0 PRJNA764222 4466 318 4.125461 13.11896598 Helicobacter pylori 210 Bacteria Bacteria 47 2.96e-4   NR GAA6889013.1 210 g4308 i0 39.3 1.11320754716981 56 34 52.8 0 17 184 18 73 GAA6889013.1 hypothetical protein Kyoto206A_5310 [Helicobacter pylori] diamond 354 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28537749 28537749 PRJNA764222_S_NODE_29747_length_170_cov_2.154472_g29589_i0 PRJNA764222 29747 170 2.154472 3.6626024 Helicobacter pylori 210 Bacteria Bacteria 45.8 1.02e-4   NR GAA9211266.1 210 g29589 i0 63.2 1.18235294117647 38 11 61.8 2 10 114 22 59 GAA9211266.1 hypothetical protein Kyoto198A_2380 [Helicobacter pylori] diamond 201 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28673506 28673506 PRJNA764222_S_NODE_14007_length_238_cov_4.005236_g13849_i0 PRJNA764222 14007 238 4.005236 9.53246168 root 1 Root_unresolved Root_unresolved 47 8.06e-5   NR GAA8730091.1 210 g13849 i0 51 1.23529411764706 49 24 61.8 0 159 13 4 52 GAA8730091.1 hypothetical protein Kyoto145A_5310 [Helicobacter pylori] diamond 294 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29642320 29642320 PRJNA764222_S_NODE_18570_length_216_cov_1.508876_g18412_i0 PRJNA764222 18570 216 1.508876 3.25917216 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.0491   NR GAA8908272.1 210 g18412 i0 80 0.277777777777778 20 4 27.8 0 62 3 32 51 GAA8908272.1 hypothetical protein Kyoto166A_1320 [Helicobacter pylori] diamond 60 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29673885 29673885 PRJNA764222_S_NODE_15050_length_233_cov_1.994624_g14892_i0 PRJNA764222 15050 233 1.994624 4.64747392 Helicobacter pylori 210 Bacteria Bacteria 40 0.0275   NR GAA8956022.1 210 g14892 i0 54.8 0.399141630901288 31 14 39.9 0 182 90 11 41 GAA8956022.1 hypothetical protein Kyoto181A_3010 [Helicobacter pylori] diamond 93 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29768817 29768817 PRJNA764222_S_NODE_10991_length_256_cov_2.282297_g10833_i0 PRJNA764222 10991 256 2.282297 5.84268032 Helicobacter pylori 210 Bacteria Bacteria 97.1 6.08e-24   NR WP_322538256.1 210 g10833 i0 95.7 0.55078125 47 2 55.1 0 1 141 61 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 141 97.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30179442 30179442 PRJNA764222_S_NODE_13812_length_239_cov_4.291667_g13654_i0 PRJNA764222 13812 239 4.291667 10.25708413 Helicobacter pylori 210 Bacteria Bacteria 45.8 4.34e-4   NR GAA6805891.1 210 g13654 i0 38.7 0.778242677824268 62 38 77.8 0 231 46 16 77 GAA6805891.1 hypothetical protein Kyoto200A_2780 [Helicobacter pylori] diamond 186 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30369644 30369644 PRJNA764222_S_NODE_33492_length_156_cov_2.339450_g33334_i0 PRJNA764222 33492 156 2.33945 3.649542 Helicobacter pylori 210 Bacteria Bacteria 53.5 9.05e-8   NR GAA9131483.1 210 g33334 i0 64.7 4.57692307692308 34 12 65.4 0 51 152 37 70 GAA9131483.1 hypothetical protein Kyoto190A_2210 [Helicobacter pylori] diamond 714 53.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30473713 30473713 PRJNA764222_S_NODE_15493_length_231_cov_1.092391_g15335_i0 PRJNA764222 15493 231 1.092391 2.52342321 root 1 Root_unresolved Root_unresolved 68.9 1.73e-12   NR GAA9250408.1 210 g15335 i0 50 16.6493506493506 80 34 96.1 2 224 3 46 125 GAA9250408.1 hypothetical protein Kyoto199A_2030 [Helicobacter pylori] diamond 3846 68.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31222021 31222021 PRJNA764222_S_NODE_14535_length_235_cov_4.340426_g14377_i0 PRJNA764222 14535 235 4.340426 10.2000011 Helicobacter pylori 210 Bacteria Bacteria 58.9 1.49e-9   NR GAA9129654.1 210 g14377 i0 58 1.27659574468085 50 21 63.8 0 232 83 10 59 GAA9129654.1 hypothetical protein Kyoto190A_1920 [Helicobacter pylori] diamond 300 58.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31412095 31412095 PRJNA764222_S_NODE_7896_length_279_cov_2.629310_g7738_i0 PRJNA764222 7896 279 2.62931 7.3357749 Helicobacter pylori 210 Bacteria Bacteria 56.6 4.59e-7   NR GAA8734012.1 210 g7738 i0 52.1 4.73118279569892 48 22 50.5 1 141 1 173 220 GAA8734012.1 hypothetical protein Kyoto147A_1470 [Helicobacter pylori] diamond 1320 56.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31570426 31570426 PRJNA764222_S_NODE_5856_length_299_cov_2.388889_g5698_i0 PRJNA764222 5856 299 2.388889 7.14277811 Helicobacter pylori 210 Bacteria Bacteria 48.5 2.73e-5   NR GAA8701437.1 210 g5698 i0 75 0.280936454849498 28 7 28.1 0 3 86 17 44 GAA8701437.1 hypothetical protein Kyoto145A_3300 [Helicobacter pylori] diamond 84 48.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31601991 31601991 PRJNA764222_S_NODE_8796_length_271_cov_5.616071_g8638_i0 PRJNA764222 8796 271 5.616071 15.21955241 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.00761   NR GAA8964696.1 210 g8638 i0 47.8 1.01845018450184 46 22 49.8 2 200 66 3 47 GAA8964696.1 hypothetical protein Kyoto181A_3970 [Helicobacter pylori] diamond 276 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31728239 31728239 PRJNA764222_S_NODE_30477_length_168_cov_1.256198_g30319_i0 PRJNA764222 30477 168 1.256198 2.11041264 Helicobacter pylori 210 Bacteria Bacteria 38.9 0.0443   NR GAA8900389.1 210 g30319 i0 57.1 0.5 28 12 50 0 80 163 14 41 GAA8900389.1 hypothetical protein Kyoto154A_5990 [Helicobacter pylori] diamond 84 38.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31791398 31791398 PRJNA764222_S_NODE_6457_length_292_cov_3.342857_g6299_i0 PRJNA764222 6457 292 3.342857 9.76114244 Campylobacter jejuni 197 Bacteria Bacteria 53.5 4.77e-7   NR WP_240373355.1 197 g6299 i0 50 0.554794520547945 54 27 55.5 0 130 291 15 68 WP_240373355.1 hypothetical protein, partial [Campylobacter jejuni] diamond 162 53.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31886422 31886422 PRJNA764222_S_NODE_26337_length_183_cov_1.779412_g26179_i0 PRJNA764222 26337 183 1.779412 3.25632396 Helicobacter pylori 210 Bacteria Bacteria 43.5 0.00408   NR GAA8857246.1 210 g26179 i0 55.2 0.475409836065574 29 13 47.5 0 182 96 46 74 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 87 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32181006 32181006 PRJNA764222_S_NODE_7338_length_284_cov_2.497890_g7180_i0 PRJNA764222 7338 284 2.49789 7.0940076 root 1 Root_unresolved Root_unresolved 52.8 5.73e-7   NR GAA8856488.1 210 g7180 i0 53.3 0.897887323943662 45 21 47.5 0 95 229 3 47 GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori] diamond 255 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32329797 32329797 PRJNA764222_S_NODE_23379_length_195_cov_1.358108_g23221_i0 PRJNA764222 23379 195 1.358108 2.6483106 Helicobacter pylori 210 Bacteria Bacteria 39.3 0.0387   NR GAA9069800.1 210 g23221 i0 48.7 0.6 39 17 58.5 2 140 27 7 43 GAA9069800.1 hypothetical protein Kyoto184A_06320 [Helicobacter pylori] diamond 117 39.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32865837 32865837 PRJNA764222_S_NODE_13260_length_242_cov_2.917949_g13102_i0 PRJNA764222 13260 242 2.917949 7.06143658 Helicobacter pylori 210 Bacteria Bacteria 45.4 5.71e-4   NR GAA6805833.1 210 g13102 i0 53.8 0.483471074380165 39 18 48.3 0 130 14 46 84 GAA6805833.1 hypothetical protein Kyoto200A_2750 [Helicobacter pylori] diamond 117 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32897200 32897200 PRJNA764222_S_NODE_14880_length_234_cov_1.652406_g14722_i0 PRJNA764222 14880 234 1.652406 3.86663004 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.00273   NR GAA9038383.1 210 g14722 i0 57.6 0.884615384615385 33 14 42.3 0 126 224 30 62 GAA9038383.1 hypothetical protein Kyoto184A_01150 [Helicobacter pylori] diamond 207 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32897207 32897207 PRJNA764222_S_NODE_32000_length_163_cov_2.672414_g31842_i0 PRJNA764222 32000 163 2.672414 4.35603482 Helicobacter pylori 210 Bacteria Bacteria 50.1 3.23e-6   NR GAA8565153.1 210 g31842 i0 87 0.423312883435583 23 3 42.3 0 94 162 42 64 GAA8565153.1 hypothetical protein oki142_14710 [Helicobacter pylori] diamond 69 50.1 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);;