RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
26676482 26676482 PRJNA939369_S_NODE_71061_length_243_cov_1.205882_g70644_i0 PRJNA939369 71061 243 1.205882 2.93029326 Helicobacter pylori 210 Bacteria Bacteria 55.8 2.01e-8   NR GAA6952165.1 210 g70644 i0 60.5 0.530864197530864 43 17 53.1 0 219 91 3 45 GAA6952165.1 hypothetical protein Kyoto207A_5990 [Helicobacter pylori] diamond 129 55.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27720501 27720501 PRJNA939369_S_NODE_55004_length_251_cov_0.865169_g54587_i0 PRJNA939369 55004 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 52 3.33e-6   NR GAA8954509.1 210 g54587 i0 54.5 3.15537848605578 44 20 52.6 0 30 161 59 102 GAA8954509.1 hypothetical protein Kyoto181A_2710 [Helicobacter pylori] diamond 792 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27877892 27877892 PRJNA939369_S_NODE_49365_length_259_cov_1.225806_g48948_i0 PRJNA939369 49365 259 1.225806 3.17483754 Helicobacter pylori 210 Bacteria Bacteria 44.7 6.63e-4   NR GAA8856488.1 210 g48948 i0 56.4 0.451737451737452 39 16 44 1 121 234 10 48 GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori] diamond 117 44.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28137653 28137653 PRJNA939369_S_NODE_46065_length_265_cov_1.005208_g45648_i0 PRJNA939369 46065 265 1.005208 2.6638012 Bacteria 2 Bacteria Bacteria 77 1.83e-15   NR WP_203061690.1 210 g45648 i0 74.1 18.9509433962264 54 14 61.1 0 187 26 32 85 WP_203061690.1 ead/Ea22-like family protein, partial [Helicobacter pylori] diamond 5022 77 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28800302 28800302 PRJNA939369_S_NODE_66427_length_246_cov_0.739884_g66010_i0 PRJNA939369 66427 246 0.739884 1.82011464 Bacteria 2 Bacteria Bacteria 45.8 2.09e-4   NR GAA9260203.1 210 g66010 i0 73.1 0.902439024390244 26 7 31.7 0 88 165 1 26 GAA9260203.1 hypothetical protein Kyoto199A_4430 [Helicobacter pylori] diamond 222 46.2 0.991341991341991 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28824835 28824835 PRJNA939369_S_NODE_76968_length_241_cov_0.875000_g76551_i0 PRJNA939369 76968 241 0.875 2.10875 Helicobacter pylori 210 Bacteria Bacteria 75.1 6.36e-16   NR GAA9178338.1 210 g76551 i0 61.1 0.672199170124481 54 21 67.2 0 183 22 4 57 GAA9178338.1 hypothetical protein Kyoto193A_1850 [Helicobacter pylori] diamond 162 75.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28958619 28958619 PRJNA939369_S_NODE_53488_length_252_cov_2.340782_g53071_i0 PRJNA939369 53488 252 2.340782 5.89877064 Bacteria 2 Bacteria Bacteria 47.4 5.41e-5   NR GAA9176257.1 210 g53071 i0 76.9 0.642857142857143 26 6 31 0 228 151 1 26 GAA9176257.1 hypothetical protein Kyoto193A_0400 [Helicobacter pylori] diamond 162 47.8 0.99163179916318 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29684294 29684294 PRJNA939369_S_NODE_9930_length_425_cov_1.303977_g9513_i0 PRJNA939369 9930 425 1.303977 5.54190225 root 1 Root_unresolved Root_unresolved 86.3 1.12e-18   NR WP_238408432.1 210 g9513 i0 78.2 7.37647058823529 55 12 38.8 0 257 421 30 84 WP_238408432.1 DUF1398 family protein, partial [Helicobacter pylori] diamond 3135 86.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29779307 29779307 PRJNA939369_S_NODE_9791_length_427_cov_1.474576_g9374_i0 PRJNA939369 9791 427 1.474576 6.29643952 Bacteria 2 Bacteria Bacteria 160 3.73e-46   NR WP_227574815.1 195 g9374 i0 59.7 17.1990632318501 129 52 90.6 0 388 2 98 226 WP_227574815.1 AAA family ATPase, partial [Campylobacter coli] diamond 7344 160 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
29898752 29898752 PRJNA939369_S_NODE_5031_length_541_cov_11.241453_g4615_i0 PRJNA939369 5031 541 11.241453 60.81626073 Helicobacter pylori 210 Bacteria Bacteria 79.3 1.69e-15   NR GAA6899797.1 210 g4615 i0 64.1 0.354898336414048 64 23 35.5 0 203 394 54 117 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 192 79.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30498993 30498993 PRJNA939369_S_NODE_66413_length_246_cov_0.780347_g65996_i0 PRJNA939369 66413 246 0.780347 1.91965362 Helicobacter pylori 210 Bacteria Bacteria 63.2 1.29e-9   NR GAA8854026.1 210 g65996 i0 72.7 1.60975609756098 44 12 53.7 0 165 34 97 140 GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori] diamond 396 63.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30783304 30783304 PRJNA939369_S_NODE_56574_length_250_cov_1.107345_g56157_i0 PRJNA939369 56574 250 1.107345 2.7683625 Helicobacter pylori 210 Bacteria Bacteria 68.2 6.08e-13   NR GAA6863873.1 210 g56157 i0 53.4 0.696 58 27 69.6 0 218 45 8 65 GAA6863873.1 hypothetical protein Kyoto206A_2050 [Helicobacter pylori] diamond 174 68.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31130576 31130576 PRJNA939369_S_NODE_65175_length_246_cov_0.890173_g64758_i0 PRJNA939369 65175 246 0.890173 2.18982558 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.0105   NR GAA9051861.1 210 g64758 i0 46.5 0.524390243902439 43 23 52.4 0 1 129 44 86 GAA9051861.1 hypothetical protein Kyoto184A_04030 [Helicobacter pylori] diamond 129 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31193668 31193668 PRJNA939369_S_NODE_52695_length_254_cov_1.000000_g52278_i0 PRJNA939369 52695 254 1 2.54 Helicobacter pylori 210 Bacteria Bacteria 67.8 2.53e-12   NR GAA6899797.1 210 g52278 i0 42.5 0.862204724409449 73 42 86.2 0 6 224 29 101 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 219 67.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31415434 31415434 PRJNA939369_S_NODE_3456_length_624_cov_4.003630_g3053_i0 PRJNA939369 3456 624 4.00363 24.9826512 Helicobacter pylori 210 Bacteria Bacteria 78.2 9.53e-15   NR GAA6899797.1 210 g3053 i0 55.7 0.336538461538462 70 31 33.7 0 291 82 27 96 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 210 78.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31921520 31921520 PRJNA939369_S_NODE_71017_length_243_cov_1.282353_g70600_i0 PRJNA939369 71017 243 1.282353 3.11611779 Helicobacter pylori 210 Bacteria Bacteria 65.9 1.24e-11   NR GAA6899797.1 210 g70600 i0 43.5 0.851851851851852 69 39 85.2 0 32 238 12 80 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 207 65.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32364670 32364670 PRJNA939369_S_NODE_74799_length_242_cov_0.875740_g74382_i0 PRJNA939369 74799 242 0.87574 2.1192908 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.00621   NR GAA9246637.1 210 g74382 i0 73.9 0.285123966942149 23 6 28.5 0 30 98 1 23 GAA9246637.1 hypothetical protein Kyoto199A_0580 [Helicobacter pylori] diamond 69 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32491244 32491244 PRJNA939369_S_NODE_38539_length_279_cov_110.631068_g38122_i0 PRJNA939369 38539 279 110.631068 308.66067972 Helicobacter pylori 210 Bacteria Bacteria 80.1 7.48e-18   NR GAA8838853.1 210 g38122 i0 92.5 0.43010752688172 40 3 43 0 277 158 4 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 120 80.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32743449 32743449 PRJNA939369_S_NODE_49560_length_259_cov_0.790323_g49143_i0 PRJNA939369 49560 259 0.790323 2.04693657 Helicobacter pylori 210 Bacteria Bacteria 40 0.0421   NR GAA8734611.1 210 g49143 i0 69.6 0.266409266409266 23 7 26.6 0 90 22 1 23 GAA8734611.1 hypothetical protein Kyoto147A_1680 [Helicobacter pylori] diamond 69 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32781628 32781628 PRJNA939369_S_NODE_36280_length_285_cov_0.905660_g35863_i0 PRJNA939369 36280 285 0.90566 2.581131 root 1 Root_unresolved Root_unresolved 91.3 5.6200000000000006e-21   NR WP_227579456.1 195 g35863 i0 58.1 32.3578947368421 74 31 77.9 0 24 245 76 149 WP_227579456.1 serine/threonine protein phosphatase, partial [Campylobacter coli] diamond 9222 91.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli

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);;