RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1069776 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
23137389 23137389 PRJNA1069776_S_NODE_55639_length_150_cov_1.757009_g55325_i0 PRJNA1069776 55639 150 1.757009 2.6355135 Sulfurospirillum sp. 2053622 Bacteria Bacteria 98.2 2.12e-24   NR MBP9566668.1 2053622 g55325 i0 90 3 50 5 100 0 1 150 3 52 MBP9566668.1 dCTP deaminase [Sulfurospirillum sp.] diamond 450 98.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum sp.
26624118 26624118 PRJNA1069776_S_NODE_13961_length_272_cov_4.519651_g13647_i0 PRJNA1069776 13961 272 4.519651 12.29345072 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00555   NR GAA9020730.1 210 g13647 i0 66.7 0.297794117647059 27 9 29.8 0 202 122 24 50 GAA9020730.1 hypothetical protein Kyoto181A_7750 [Helicobacter pylori] diamond 81 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27352069 27352069 PRJNA1069776_S_NODE_53583_length_151_cov_7.296296_g53269_i0 PRJNA1069776 53583 151 7.296296 11.01740696 Helicobacter pylori 210 Bacteria Bacteria 81.6 2.58e-18   NR GAA8565231.1 210 g53269 i0 81.6 0.973509933774834 49 9 97.4 0 148 2 68 116 GAA8565231.1 hypothetical protein oki142_14730 [Helicobacter pylori] diamond 147 81.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27375339 27375339 PRJNA1069776_S_NODE_49803_length_156_cov_3.283186_g49489_i0 PRJNA1069776 49803 156 3.283186 5.12177016 Pseudomonadati 3379134 Bacteria Bacteria 41.2 0.0381   NR GAA8854026.1 210 g49489 i0 53.5 3.17307692307692 43 18 78.8 1 33 155 153 195 GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori] diamond 495 41.6 0.990384615384615 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27762588 27762588 PRJNA1069776_S_NODE_7964_length_329_cov_12.671329_g7650_i0 PRJNA1069776 7964 329 12.671329 41.68867241 Helicobacter pylori 210 Bacteria Bacteria 45.1 0.00109   NR GAA9020855.1 210 g7650 i0 58.8 0.310030395136778 34 14 31 0 123 224 24 57 GAA9020855.1 hypothetical protein Kyoto181A_7760 [Helicobacter pylori] diamond 102 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28235645 28235645 PRJNA1069776_S_NODE_13746_length_274_cov_3.341991_g13432_i0 PRJNA1069776 13746 274 3.341991 9.15705534 Helicobacter pylori 210 Bacteria Bacteria 45.1 0.00115   NR GAA9181004.1 210 g13432 i0 49 0.558394160583942 51 24 53.6 1 152 6 17 67 GAA9181004.1 hypothetical protein Kyoto193A_2430 [Helicobacter pylori] diamond 153 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28457082 28457082 PRJNA1069776_S_NODE_21766_length_227_cov_1.304348_g21452_i0 PRJNA1069776 21766 227 1.304348 2.96086996 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00431   NR GAA6904105.1 210 g21452 i0 71 0.819383259911894 31 9 41 0 42 134 38 68 GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori] diamond 186 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29214963 29214963 PRJNA1069776_S_NODE_2889_length_438_cov_14.777215_g2576_i0 PRJNA1069776 2889 438 14.777215 64.7242017 Helicobacter pylori 210 Bacteria Bacteria 180 5.89e-56   NR WP_322538256.1 210 g2576 i0 96.7 0.63013698630137 92 3 63 0 437 162 16 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 276 180 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29435447 29435447 PRJNA1069776_S_NODE_13330_length_277_cov_4.735043_g13016_i0 PRJNA1069776 13330 277 4.735043 13.11606911 Helicobacter pylori 210 Bacteria Bacteria 78.6 1.79e-16   NR WP_322538264.1 210 g13016 i0 46.5 1.86281588447653 86 46 93.1 0 275 18 29 114 WP_322538264.1 hypothetical protein, partial [Helicobacter pylori] diamond 516 78.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29530522 29530522 PRJNA1069776_S_NODE_11290_length_294_cov_13.171315_g10976_i0 PRJNA1069776 11290 294 13.171315 38.7236661 Helicobacter pylori 210 Bacteria Bacteria 53.9 7.83e-7   NR GAA6860864.1 210 g10976 i0 46.8 0.806122448979592 79 29 71.4 4 225 16 22 96 GAA6860864.1 hypothetical protein Kyoto206A_1490 [Helicobacter pylori] diamond 237 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30288917 30288917 PRJNA1069776_S_NODE_36432_length_180_cov_6.583942_g36118_i0 PRJNA1069776 36432 180 6.583942 11.8510956 Helicobacter pylori 210 Bacteria Bacteria 60.5 2.72e-10   NR GAA8807669.1 210 g36118 i0 74.3 2.35 35 7 55 1 69 167 43 77 GAA8807669.1 hypothetical protein Kyoto149A_2730 [Helicobacter pylori] diamond 423 60.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30383722 30383722 PRJNA1069776_S_NODE_39833_length_173_cov_3.823077_g39519_i0 PRJNA1069776 39833 173 3.823077 6.61392321 Helicobacter pylori 210 Bacteria Bacteria 86.3 5.25e-20   NR GAA8565231.1 210 g39519 i0 89.6 0.832369942196532 48 5 83.2 0 147 4 75 122 GAA8565231.1 hypothetical protein oki142_14730 [Helicobacter pylori] diamond 144 86.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30478208 30478208 PRJNA1069776_S_NODE_28873_length_200_cov_3.662420_g28559_i0 PRJNA1069776 28873 200 3.66242 7.32484 Helicobacter pylori 210 Bacteria Bacteria 52.4 4.72e-7   NR GAA9049242.1 210 g28559 i0 63.4 1.275 41 15 61.5 0 71 193 10 50 GAA9049242.1 hypothetical protein Kyoto184A_03710 [Helicobacter pylori] diamond 255 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30825597 30825597 PRJNA1069776_S_NODE_4474_length_385_cov_6.558480_g4160_i0 PRJNA1069776 4474 385 6.55848 25.250148 Helicobacter pylori 210 Bacteria Bacteria 46.2 0.0102   NR WP_231231432.1 210 g4160 i0 38.8 0.522077922077922 67 41 52.2 0 221 21 102 168 WP_231231432.1 hypothetical protein [Helicobacter pylori] diamond 201 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30983792 30983792 PRJNA1069776_S_NODE_14554_length_267_cov_14.508929_g14240_i0 PRJNA1069776 14554 267 14.508929 38.73884043 Campylobacterales bacterium 2268180 Bacteria Bacteria 95.5 7.45e-22   NR MBE0495806.1 2268180 g14240 i0 83.9 0.696629213483146 62 10 69.7 0 186 1 1 62 MBE0495806.1 zinc ribbon domain-containing protein [Campylobacterales bacterium] diamond 186 95.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
31259624 31259624 PRJNA1069776_S_NODE_17915_length_246_cov_6.231527_g17601_i0 PRJNA1069776 17915 246 6.231527 15.32955642 Pseudomonadati 3379134 Bacteria Bacteria 53.9 4.63e-7   NR GAA9125261.1 210 g17601 i0 84.6 1.86585365853659 26 4 31.7 0 16 93 1 26 GAA9125261.1 hypothetical protein Kyoto190A_0780 [Helicobacter pylori] diamond 459 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31331232 31331232 PRJNA1069776_S_NODE_17376_length_250_cov_2.086957_g17062_i0 PRJNA1069776 17376 250 2.086957 5.2173925 Helicobacter pylori 210 Bacteria Bacteria 46.6 4.09e-4   NR WP_322538264.1 210 g17062 i0 32.5 1.92 80 54 96 0 1 240 33 112 WP_322538264.1 hypothetical protein, partial [Helicobacter pylori] diamond 480 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31512797 31512797 PRJNA1069776_S_NODE_31296_length_193_cov_4.726667_g30982_i0 PRJNA1069776 31296 193 4.726667 9.12246731 root 1 Root_unresolved Root_unresolved 49.3 2.95e-5   NR GAA8684133.1 210 g30982 i0 43.5 1.36787564766839 46 26 71.5 0 42 179 66 111 GAA8684133.1 hypothetical protein Kyoto145A_0980 [Helicobacter pylori] diamond 264 49.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31647430 31647430 PRJNA1069776_S_NODE_26697_length_207_cov_3.512195_g26383_i0 PRJNA1069776 26697 207 3.512195 7.27024365 Helicobacter pylori 210 Bacteria Bacteria 57 8.03e-9   NR GAA9043165.1 210 g26383 i0 65.7 1.01449275362319 35 12 50.7 0 44 148 9 43 GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori] diamond 210 57 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32406979 32406979 PRJNA1069776_S_NODE_22559_length_223_cov_3.394444_g22245_i0 PRJNA1069776 22559 223 3.394444 7.56961012 Helicobacter pylori 210 Bacteria Bacteria 81.6 1.13e-16   NR GAA6795622.1 210 g22245 i0 70 0.672645739910314 50 12 63.2 1 172 32 98 147 GAA6795622.1 hypothetical protein Kyoto200A_0460 [Helicobacter pylori] diamond 150 81.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32438799 32438799 PRJNA1069776_S_NODE_5859_length_358_cov_8.057143_g5545_i0 PRJNA1069776 5859 358 8.057143 28.84457194 Helicobacter pylori 210 Bacteria Bacteria 108 8.78e-28   NR WP_322538256.1 210 g5545 i0 65 0.670391061452514 80 28 67 0 358 119 28 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 240 108 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32816975 32816975 PRJNA1069776_S_NODE_4100_length_394_cov_12.635328_g3786_i0 PRJNA1069776 4100 394 12.635328 49.78319232 Helicobacter pylori 210 Bacteria Bacteria 60.5 6.03e-9   NR GAA8950681.1 210 g3786 i0 54.1 1.90355329949239 61 24 43.4 3 228 58 42 102 GAA8950681.1 hypothetical protein Kyoto181A_1580 [Helicobacter pylori] diamond 750 60.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32848454 32848454 PRJNA1069776_S_NODE_7580_length_334_cov_7.092784_g7266_i0 PRJNA1069776 7580 334 7.092784 23.68989856 Helicobacter pylori 210 Bacteria Bacteria 59.3 2.6e-9   NR GAA8714325.1 210 g7266 i0 58.1 0.38622754491018 43 18 38.6 0 118 246 1 43 GAA8714325.1 hypothetical protein Kyoto145A_4230 [Helicobacter pylori] diamond 129 59.3 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);;