RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA663960" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA663960 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
10832727 10832727 PRJNA663960_S_NODE_18829_length_271_cov_4.897321_g18593_i0 PRJNA663960 18829 271 4.897321 13.27173991 Sulfurospirillum tamanense 2813362 Bacteria Bacteria 153 7.03e-44   NR WP_205459884.1 2813362 g18593 i0 83.1 0.985239852398524 89 15 98.5 0 269 3 71 159 WP_205459884.1 signal recognition particle-docking protein FtsY [Sulfurospirillum tamanense] diamond 267 153 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum tamanense
26618782 26618782 PRJNA663960_S_NODE_28881_length_226_cov_1.424581_g28645_i0 PRJNA663960 28881 226 1.424581 3.21955306 root 1 Root_unresolved Root_unresolved 47.4 5.16e-4   NR GAA9176518.1 210 g28645 i0 65.1 3.53097345132743 43 14 55.8 1 128 3 95 137 GAA9176518.1 hypothetical protein Kyoto193A_0800 [Helicobacter pylori] diamond 798 47.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26638199 26638199 PRJNA663960_S_NODE_51521_length_169_cov_1.163934_g51285_i0 PRJNA663960 51521 169 1.163934 1.96704846 Helicobacter pylori 210 Bacteria Bacteria 114 3.5099999999999993e-31   NR WP_322538256.1 210 g51285 i0 96.4 0.976331360946746 55 2 97.6 0 3 167 53 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 165 114 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27112902 27112902 PRJNA663960_S_NODE_8242_length_353_cov_3.418301_g8006_i0 PRJNA663960 8242 353 3.418301 12.06660253 Helicobacter pylori 210 Bacteria Bacteria 42 0.0254   NR GAA8697141.1 210 g8006 i0 54.1 0.314447592067989 37 17 31.4 0 85 195 26 62 GAA8697141.1 hypothetical protein Kyoto145A_2860 [Helicobacter pylori] diamond 111 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27460832 27460832 PRJNA663960_S_NODE_14483_length_298_cov_3.326693_g14247_i0 PRJNA663960 14483 298 3.326693 9.91354514 Helicobacter pylori 210 Bacteria Bacteria 42 0.05   NR GAA9209329.1 210 g14247 i0 40 0.453020134228188 45 27 45.3 0 84 218 16 60 GAA9209329.1 hypothetical protein Kyoto198A_1640 [Helicobacter pylori] diamond 135 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27820290 27820290 PRJNA663960_S_NODE_57324_length_162_cov_0.886957_g57088_i0 PRJNA663960 57324 162 0.886957 1.43687034 root 1 Root_unresolved Root_unresolved 40.4 0.0132   NR GAA8957928.1 210 g57088 i0 51.4 1.37037037037037 37 16 64.8 1 162 58 15 51 GAA8957928.1 hypothetical protein Kyoto181A_3320 [Helicobacter pylori] diamond 222 40.8 0.990196078431373 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28281398 28281398 PRJNA663960_S_NODE_44226_length_183_cov_1.227941_g43990_i0 PRJNA663960 44226 183 1.227941 2.24713203 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0272   NR GAA6862807.1 210 g43990 i0 50 0.622950819672131 38 17 59 1 48 155 1 38 GAA6862807.1 hypothetical protein Kyoto206A_1910 [Helicobacter pylori] diamond 114 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28912824 28912824 PRJNA663960_S_NODE_36408_length_202_cov_0.987097_g36172_i0 PRJNA663960 36408 202 0.987097 1.99393594 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0197   NR GAA9174405.1 210 g36172 i0 63 0.400990099009901 27 10 40.1 0 82 2 27 53 GAA9174405.1 hypothetical protein Kyoto190A_6010 [Helicobacter pylori] diamond 81 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29039637 29039637 PRJNA663960_S_NODE_55948_length_163_cov_1.318966_g55712_i0 PRJNA663960 55948 163 1.318966 2.14991458 Helicobacter pylori 210 Bacteria Bacteria 58.2 1.09e-9   NR GAA9250341.1 210 g55712 i0 59.1 3.33128834355828 44 18 81 0 13 144 3 46 GAA9250341.1 hypothetical protein Kyoto199A_2020 [Helicobacter pylori] diamond 543 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29323419 29323419 PRJNA663960_S_NODE_38149_length_197_cov_1.700000_g37913_i0 PRJNA663960 38149 197 1.7 3.349 Helicobacter pylori 210 Bacteria Bacteria 92.4 1.81e-22   NR WP_322538256.1 210 g37913 i0 72.1 0.928934010152284 61 17 92.9 0 195 13 20 80 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 183 92.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29386824 29386824 PRJNA663960_S_NODE_55349_length_164_cov_0.871795_g55113_i0 PRJNA663960 55349 164 0.871795 1.4297438 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 45.8 9.43e-5   NR WP_222860981.1 28198 g55113 i0 57.5 0.731707317073171 40 17 73.2 0 164 45 12 51 WP_222860981.1 hypothetical protein, partial [Aliarcobacter cryaerophilus] diamond 120 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
30315261 30315261 PRJNA663960_S_NODE_62572_length_157_cov_1.390909_g62336_i0 PRJNA663960 62572 157 1.390909 2.18372713 root 1 Root_unresolved Root_unresolved 46.6 1.5e-4   NR GAA9039918.1 210 g62336 i0 63.6 2.48407643312102 33 12 63.1 0 1 99 33 65 GAA9039918.1 hypothetical protein Kyoto184A_01840 [Helicobacter pylori] diamond 390 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30744981 30744981 PRJNA663960_S_NODE_39374_length_194_cov_1.387755_g39138_i0 PRJNA663960 39374 194 1.387755 2.6922447 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.00577   NR GAA8857867.1 210 g39138 i0 63.3 0.463917525773196 30 10 46.4 1 158 69 2 30 GAA8857867.1 hypothetical protein Kyoto154A_2260 [Helicobacter pylori] diamond 90 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31073152 31073152 PRJNA663960_S_NODE_13575_length_304_cov_3.712062_g13339_i0 PRJNA663960 13575 304 3.712062 11.28466848 Campylobacterales 213849 Bacteria Bacteria 50.1 3.05e-5   NR WP_341549733.1 197 g13339 i0 50.9 0.967105263157895 53 24 52.3 1 180 22 57 107 WP_341549733.1 reverse transcriptase domain-containing protein, partial [Campylobacter jejuni] diamond 294 50.4 0.994047619047619 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31282056 31282056 PRJNA663960_S_NODE_50335_length_171_cov_1.233871_g50099_i0 PRJNA663960 50335 171 1.233871 2.10991941 Helicobacter pylori 210 Bacteria Bacteria 46.6 8.78e-5   NR GAA6860039.1 210 g50099 i0 83.3 0.421052631578947 24 4 42.1 0 97 168 3 26 GAA6860039.1 hypothetical protein Kyoto206A_1170 [Helicobacter pylori] diamond 72 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31579085 31579085 PRJNA663960_S_NODE_10676_length_327_cov_5.614286_g10440_i0 PRJNA663960 10676 327 5.614286 18.35871522 root 1 Root_unresolved Root_unresolved 57 2.13e-7   NR GAA9250408.1 210 g10440 i0 52.4 11.8899082568807 63 26 56 2 188 6 40 100 GAA9250408.1 hypothetical protein Kyoto199A_2030 [Helicobacter pylori] diamond 3888 57.4 0.993031358885017 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31978000 31978000 PRJNA663960_S_NODE_19378_length_268_cov_5.475113_g19142_i0 PRJNA663960 19378 268 5.475113 14.67330284 Helicobacter pylori 210 Bacteria Bacteria 40 0.0476   NR GAA6962098.1 210 g19142 i0 59.5 0.414179104477612 37 15 41.4 0 113 3 6 42 GAA6962098.1 hypothetical protein Kyoto211A_2340 [Helicobacter pylori] diamond 111 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32009738 32009738 PRJNA663960_S_NODE_33678_length_209_cov_4.000000_g33442_i0 PRJNA663960 33678 209 4 8.36 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 60.1 3.98e-10   NR WP_222860981.1 28198 g33442 i0 63 0.660287081339713 46 17 66 0 201 64 17 62 WP_222860981.1 hypothetical protein, partial [Aliarcobacter cryaerophilus] diamond 138 60.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
32136349 32136349 PRJNA663960_S_NODE_45678_length_180_cov_1.150376_g45442_i0 PRJNA663960 45678 180 1.150376 2.0706768 Helicobacter pylori 210 Bacteria Bacteria 56.6 4.77e-9   NR GAA9179107.1 210 g45442 i0 70.5 0.733333333333333 44 13 73.3 0 151 20 6 49 GAA9179107.1 hypothetical protein Kyoto193A_2120 [Helicobacter pylori] diamond 132 56.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32231420 32231420 PRJNA663960_S_NODE_61118_length_158_cov_3.216216_g60882_i0 PRJNA663960 61118 158 3.216216 5.08162128 Campylobacter coli 195 Bacteria Bacteria 50.8 1.12e-6   NR RJF75347.1 195 g60882 i0 54.9 0.968354430379747 51 23 96.8 0 1 153 11 61 RJF75347.1 hypothetical protein D4Z77_08730, partial [Campylobacter coli] diamond 153 50.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
32294840 32294840 PRJNA663960_S_NODE_57239_length_162_cov_0.886957_g57003_i0 PRJNA663960 57239 162 0.886957 1.43687034 Helicobacter pylori 210 Bacteria Bacteria 52.4 3.62e-7   NR GAA8706992.1 210 g57003 i0 53.1 0.907407407407407 49 23 90.7 0 147 1 7 55 GAA8706992.1 hypothetical protein Kyoto145A_3660 [Helicobacter pylori] diamond 147 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32811639 32811639 PRJNA663960_S_NODE_36320_length_202_cov_1.316129_g36084_i0 PRJNA663960 36320 202 1.316129 2.65858058 root 1 Root_unresolved Root_unresolved 65.9 2.25e-11   NR GAA8854467.1 210 g36084 i0 50 22.7079207920792 64 32 95 0 3 194 59 122 GAA8854467.1 hypothetical protein Kyoto154A_1460 [Helicobacter pylori] diamond 4587 65.9 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);;