RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA981359 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
26646171 26646171 PRJNA981359_S_NODE_10081_length_419_cov_1.531792_g9981_i0 PRJNA981359 10081 419 1.531792 6.41820848 Helicobacter pylori 210 Bacteria Bacteria 67.8 4.75e-12   NR GAA9183445.1 210 g9981 i0 60.6 0.47255369928401 66 26 47.3 0 419 222 3 68 GAA9183445.1 hypothetical protein Kyoto193A_2760 [Helicobacter pylori] diamond 198 67.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26937263 26937263 PRJNA981359_S_NODE_46762_length_287_cov_3.172897_g46662_i0 PRJNA981359 46762 287 3.172897 9.10621439 root 1 Root_unresolved Root_unresolved 57.4 1.28e-7   NR GAA8949042.1 210 g46662 i0 54.2 2.02787456445993 48 22 50.2 0 10 153 105 152 GAA8949042.1 hypothetical protein Kyoto181A_0860 [Helicobacter pylori] diamond 582 57.8 0.993079584775087 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27215747 27215747 PRJNA981359_S_NODE_30722_length_325_cov_3.357143_g30622_i0 PRJNA981359 30722 325 3.357143 10.91071475 Helicobacter pylori 210 Bacteria Bacteria 50.4 1.85e-5   NR GAA9191319.1 210 g30622 i0 52.6 0.350769230769231 38 18 35.1 0 111 224 28 65 GAA9191319.1 hypothetical protein Kyoto193A_3570 [Helicobacter pylori] diamond 114 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27342602 27342602 PRJNA981359_S_NODE_71043_length_245_cov_0.877907_g70943_i0 PRJNA981359 71043 245 0.877907 2.15087215 Helicobacter pylori 210 Bacteria Bacteria 45.1 0.00114   NR GAA6796932.1 210 g70943 i0 52.5 1.48163265306122 40 19 49 0 244 125 37 76 GAA6796932.1 hypothetical protein Kyoto200A_1190 [Helicobacter pylori] diamond 363 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27595151 27595151 PRJNA981359_S_NODE_42044_length_298_cov_0.786667_g41944_i0 PRJNA981359 42044 298 0.786667 2.34426766 Helicobacter pylori 210 Bacteria Bacteria 100 2.96e-23   NR GAA8853825.1 210 g41944 i0 61.4 0.835570469798658 83 32 83.6 0 2 250 196 278 GAA8853825.1 hypothetical protein Kyoto154A_0760 [Helicobacter pylori] diamond 249 100 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27658367 27658367 PRJNA981359_S_NODE_50284_length_280_cov_1.806763_g50184_i0 PRJNA981359 50284 280 1.806763 5.0589364 Helicobacter pylori 210 Bacteria Bacteria 64.7 2.97e-11   NR GAA9176142.1 210 g50184 i0 69.8 0.460714285714286 43 13 46.1 0 278 150 50 92 GAA9176142.1 hypothetical protein Kyoto193A_0160 [Helicobacter pylori] diamond 129 64.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27910509 27910509 PRJNA981359_S_NODE_71565_length_244_cov_1.000000_g71465_i0 PRJNA981359 71565 244 1 2.44 Helicobacter pylori 210 Bacteria Bacteria 68.9 1.68e-13   NR GAA9230378.1 210 g71465 i0 50 0.663934426229508 54 27 66.4 0 207 46 2 55 GAA9230378.1 hypothetical protein Kyoto198A_4700 [Helicobacter pylori] diamond 162 68.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28163444 28163444 PRJNA981359_S_NODE_50885_length_279_cov_1.257282_g50785_i0 PRJNA981359 50885 279 1.257282 3.50781678 Helicobacter pylori 210 Bacteria Bacteria 40 0.0447   NR GAA8795519.1 210 g50785 i0 71.4 0.301075268817204 28 8 30.1 0 86 3 11 38 GAA8795519.1 hypothetical protein Kyoto149A_0380 [Helicobacter pylori] diamond 84 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28352718 28352718 PRJNA981359_S_NODE_31006_length_325_cov_0.928571_g30906_i0 PRJNA981359 31006 325 0.928571 3.01785575 Helicobacter pylori 210 Bacteria Bacteria 74.7 1.97e-14   NR GAA8857246.1 210 g30906 i0 54.7 0.590769230769231 64 29 59.1 0 15 206 51 114 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 192 74.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28637187 28637187 PRJNA981359_S_NODE_807_length_827_cov_1.228117_g747_i0 PRJNA981359 807 827 1.228117 10.15652759 Helicobacter pylori 210 Bacteria Bacteria 189 8.729999999999997e-55   NR GAA8906475.1 210 g747 i0 59.5 3.99395405078597 158 64 57.3 0 822 349 147 304 GAA8906475.1 hypothetical protein Kyoto166A_0510 [Helicobacter pylori] diamond 3303 189 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29016161 29016161 PRJNA981359_S_NODE_37368_length_308_cov_3.944681_g37268_i0 PRJNA981359 37368 308 3.944681 12.14961748 Helicobacter pylori 210 Bacteria Bacteria 57.8 1.01e-8   NR GAA9046884.1 210 g37268 i0 62.5 0.38961038961039 40 13 39 1 265 146 22 59 GAA9046884.1 hypothetical protein Kyoto184A_03270 [Helicobacter pylori] diamond 120 57.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29205472 29205472 PRJNA981359_S_NODE_28829_length_331_cov_0.899225_g28729_i0 PRJNA981359 28829 331 0.899225 2.97643475 Helicobacter pylori 210 Bacteria Bacteria 46.6 5.46e-4   NR GAA9208316.1 210 g28729 i0 61 1.11480362537764 41 16 37.2 0 128 6 3 43 GAA9208316.1 hypothetical protein Kyoto198A_0220 [Helicobacter pylori] diamond 369 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29552375 29552375 PRJNA981359_S_NODE_8070_length_441_cov_1.138587_g7970_i0 PRJNA981359 8070 441 1.138587 5.02116867 Helicobacter pylori 210 Bacteria Bacteria 53.1 2.55e-6   NR GAA8734769.1 210 g7970 i0 73.7 0.258503401360544 38 10 25.9 0 102 215 28 65 GAA8734769.1 hypothetical protein Kyoto147A_1700 [Helicobacter pylori] diamond 114 53.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29963187 29963187 PRJNA981359_S_NODE_6051_length_475_cov_0.791045_g5952_i0 PRJNA981359 6051 475 0.791045 3.75746375 Helicobacter pylori 210 Bacteria Bacteria 62.8 1.25e-9   NR GAA6910794.1 210 g5952 i0 66.7 0.265263157894737 42 14 26.5 0 8 133 51 92 GAA6910794.1 hypothetical protein Kyoto207A_2810 [Helicobacter pylori] diamond 126 62.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30437330 30437330 PRJNA981359_S_NODE_41253_length_299_cov_3.185841_g41153_i0 PRJNA981359 41253 299 3.185841 9.52566459 Helicobacter pylori 210 Bacteria Bacteria 57 1.31e-8   NR GAA6806475.1 210 g41153 i0 80.6 0.311036789297659 31 6 31.1 0 1 93 5 35 GAA6806475.1 hypothetical protein Kyoto200A_2840 [Helicobacter pylori] diamond 93 57 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30658216 30658216 PRJNA981359_S_NODE_70133_length_246_cov_0.901734_g70033_i0 PRJNA981359 70133 246 0.901734 2.21826564 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.00276   NR GAA9209244.1 210 g70033 i0 67.9 0.341463414634146 28 9 34.1 0 219 136 63 90 GAA9209244.1 hypothetical protein Kyoto198A_1610 [Helicobacter pylori] diamond 84 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30942744 30942744 PRJNA981359_S_NODE_61274_length_259_cov_0.817204_g61174_i0 PRJNA981359 61274 259 0.817204 2.11655836 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.019   NR GAA6795719.1 210 g61174 i0 48.4 0.359073359073359 31 16 35.9 0 71 163 1 31 GAA6795719.1 hypothetical protein Kyoto200A_0590 [Helicobacter pylori] diamond 93 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31385253 31385253 PRJNA981359_S_NODE_66856_length_250_cov_0.881356_g66756_i0 PRJNA981359 66856 250 0.881356 2.20339 Helicobacter pylori 210 Bacteria Bacteria 45.8 3.84e-4   NR GAA6999957.1 210 g66756 i0 44.7 1.128 47 26 56.4 0 249 109 31 77 GAA6999957.1 hypothetical protein Kyoto211A_5590 [Helicobacter pylori] diamond 282 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31385254 31385254 PRJNA981359_S_NODE_69456_length_247_cov_0.844828_g69356_i0 PRJNA981359 69456 247 0.844828 2.08672516 Helicobacter pylori 210 Bacteria Bacteria 82 1.95e-17   NR GAA9040756.1 210 g69356 i0 56.9 0.874493927125506 72 31 87.4 0 32 247 23 94 GAA9040756.1 hypothetical protein Kyoto184A_02080 [Helicobacter pylori] diamond 216 82 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31606517 31606517 PRJNA981359_S_NODE_66196_length_251_cov_0.876404_g66096_i0 PRJNA981359 66196 251 0.876404 2.19977404 Helicobacter pylori 210 Bacteria Bacteria 55.1 2.65e-7   NR GAA8796835.1 210 g66096 i0 61.4 0.525896414342629 44 17 52.6 0 139 8 70 113 GAA8796835.1 hypothetical protein Kyoto149A_1170 [Helicobacter pylori] diamond 132 55.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31859425 31859425 PRJNA981359_S_NODE_12737_length_398_cov_1.138462_g12637_i0 PRJNA981359 12737 398 1.138462 4.53107876 Helicobacter pylori 210 Bacteria Bacteria 67.4 3.23e-12   NR GAA6797768.1 210 g12637 i0 61.7 0.35427135678392 47 18 35.4 0 302 162 1 47 GAA6797768.1 hypothetical protein Kyoto200A_1380 [Helicobacter pylori] diamond 141 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32144350 32144350 PRJNA981359_S_NODE_56618_length_267_cov_3.082474_g56518_i0 PRJNA981359 56618 267 3.082474 8.23020558 Helicobacter pylori 210 Bacteria Bacteria 67.8 1.26e-12   NR GAA8565153.1 210 g56518 i0 96.4 0.314606741573034 28 1 31.5 0 266 183 41 68 GAA8565153.1 hypothetical protein oki142_14710 [Helicobacter pylori] diamond 84 67.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32460848 32460848 PRJNA981359_S_NODE_48479_length_284_cov_1.312796_g48379_i0 PRJNA981359 48479 284 1.312796 3.72834064 Helicobacter pylori 210 Bacteria Bacteria 45.1 0.00195   NR GAA8806702.1 210 g48379 i0 56.4 0.411971830985915 39 17 41.2 0 8 124 11 49 GAA8806702.1 hypothetical protein Kyoto149A_2640 [Helicobacter pylori] diamond 117 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32555963 32555963 PRJNA981359_S_NODE_49659_length_281_cov_2.774038_g49559_i0 PRJNA981359 49659 281 2.774038 7.79504678 Helicobacter pylori 210 Bacteria Bacteria 68.6 6.8e-12   NR GAA9039287.1 210 g49559 i0 43.5 0.907473309608541 85 47 89.7 1 261 10 14 98 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 255 68.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32713062 32713062 PRJNA981359_S_NODE_42880_length_296_cov_1.273543_g42780_i0 PRJNA981359 42880 296 1.273543 3.76968728 Helicobacter pylori 210 Bacteria Bacteria 77.8 1.42e-16   NR GAA9183445.1 210 g42780 i0 63.2 0.689189189189189 68 25 68.9 0 285 82 1 68 GAA9183445.1 hypothetical protein Kyoto193A_2760 [Helicobacter pylori] diamond 204 77.8 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);;