RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA316313" 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

  • PRJNA316313 · 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
6766294 6766294 PRJNA316313_P_NODE_91666_length_212_cov_3.137143_g90280_i0 PRJNA316313 91666 212 3.137143 6.65074316 Campylobacter jejuni 197 Bacteria Bacteria 87.4 1.18e-20   NR WP_209410687.1 197 g90280 i0 100 0.580188679245283 41 0 58 0 210 88 46 86 WP_209410687.1 hypothetical protein, partial [Campylobacter jejuni] diamond 123 87.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
8039679 8039679 PRJNA316313_P_NODE_176907_length_187_cov_3.860000_g175521_i0 PRJNA316313 176907 187 3.86 7.2182 Pseudomonadati 3379134 Bacteria Bacteria 99 2.28e-25   NR WP_276148833.1 197 g175521 i0 75.8 7.9572192513369 62 12 99.5 1 1 186 28 86 WP_276148833.1 fatty acid desaturase, partial [Campylobacter jejuni] diamond 1488 100 0.99 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
18238544 18238544 PRJNA316313_P_NODE_26995_length_328_cov_6.494845_g25618_i0 PRJNA316313 26995 328 6.494845 21.3030916 Campylobacter jejuni 197 Bacteria Bacteria 135 6.16e-39   NR MCH3868474.1 197 g25618 i0 98.8 1.47256097560976 82 1 75 0 254 9 1 82 MCH3868474.1 hypothetical protein [Campylobacter jejuni] diamond 483 135 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
19512737 19512737 PRJNA316313_P_NODE_250976_length_187_cov_2.840000_g249590_i0 PRJNA316313 250976 187 2.84 5.3108 uncultured Campylobacter sp. 218934 Bacteria Bacteria 94.7 1.06e-21   NR WP_298945816.1 218934 g249590 i0 58.3 1.3475935828877 84 13 99.5 1 187 2 35 118 WP_298945816.1 SIR2 family NAD-dependent protein deacylase [uncultured Campylobacter sp.] diamond 252 94.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
26821485 26821485 PRJNA316313_P_NODE_17301_length_404_cov_22.811989_g15945_i0 PRJNA316313 17301 404 22.811989 92.16043556 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.0166   NR GAA8930966.1 210 g15945 i0 73.1 0.193069306930693 26 7 19.3 0 400 323 21 46 GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori] diamond 78 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26884914 26884914 PRJNA316313_P_NODE_8501_length_581_cov_5.691176_g7323_i0 PRJNA316313 8501 581 5.691176 33.06573256 Campylobacter jejuni 197 Bacteria Bacteria 65.9 5.73e-9   NR NHL33342.1 197 g7323 i0 32.2 2.36488812392427 149 88 73.3 4 1 426 162 304 NHL33342.1 hypothetical protein [Campylobacter jejuni] diamond 1374 65.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27200705 27200705 PRJNA316313_P_NODE_193802_length_187_cov_3.540000_g192416_i0 PRJNA316313 193802 187 3.54 6.6198 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0142   NR GAA6865288.1 210 g192416 i0 79.2 0.385026737967914 24 5 38.5 0 185 114 64 87 GAA6865288.1 hypothetical protein Kyoto206A_2320 [Helicobacter pylori] diamond 72 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27738261 27738261 PRJNA316313_P_NODE_362084_length_171_cov_2.111940_g360698_i0 PRJNA316313 362084 171 2.11194 3.6114174 Helicobacter pylori 210 Bacteria Bacteria 46.6 1e-4   NR GAA9037666.1 210 g360698 i0 96 0.87719298245614 25 1 43.9 0 170 96 13 37 GAA9037666.1 hypothetical protein Kyoto184A_00640 [Helicobacter pylori] diamond 150 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28179755 28179755 PRJNA316313_P_NODE_56506_length_250_cov_73.347418_g55120_i0 PRJNA316313 56506 250 73.347418 183.368545 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.0363   NR GAA9247141.1 210 g55120 i0 95.7 0.792 46 2 55.2 0 23 160 2 47 GAA9247141.1 hypothetical protein Kyoto199A_1050 [Helicobacter pylori] diamond 198 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28211371 28211371 PRJNA316313_P_NODE_474806_length_151_cov_2.833333_g473420_i0 PRJNA316313 474806 151 2.833333 4.27833283 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00179   NR GAA6820949.1 210 g473420 i0 47.4 0.754966887417219 38 20 75.5 0 8 121 1 38 GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori] diamond 114 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28544848 28544848 PRJNA316313_P_NODE_95227_length_209_cov_3.651163_g93841_i0 PRJNA316313 95227 209 3.651163 7.63093067 Pseudomonadati 3379134 Bacteria Bacteria 58.5 2.06e-9   NR GAA6953502.1 210 g93841 i0 70.6 2.49760765550239 34 10 48.8 0 175 74 13 46 GAA6953502.1 hypothetical protein Kyoto211A_0700 [Helicobacter pylori] diamond 522 58.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28653589 28653589 PRJNA316313_P_NODE_203487_length_187_cov_3.400000_g202101_i0 PRJNA316313 203487 187 3.4 6.358 Campylobacter sp. 2 205 Bacteria Bacteria 48.1 8.72e-5   NR WP_214120692.1 2836735 g202101 i0 84 0.401069518716578 25 4 40.1 0 1 75 67 91 WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01] diamond 75 48.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. 2018MI01
28905956 28905956 PRJNA316313_P_NODE_382508_length_159_cov_3.073770_g381122_i0 PRJNA316313 382508 159 3.07377 4.8872943 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00233   NR GAA9253554.1 210 g381122 i0 58.1 1.16981132075472 31 13 58.5 0 125 33 16 46 GAA9253554.1 hypothetical protein Kyoto199A_2770 [Helicobacter pylori] diamond 186 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29379767 29379767 PRJNA316313_P_NODE_370149_length_166_cov_2.550388_g368763_i0 PRJNA316313 370149 166 2.550388 4.23364408 Helicobacter pylori 210 Bacteria Bacteria 44.3 3.28e-4   NR GAA9194269.1 210 g368763 i0 94.4 0.325301204819277 18 1 32.5 0 45 98 1 18 GAA9194269.1 hypothetical protein Kyoto193A_4010 [Helicobacter pylori] diamond 54 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29523428 29523428 PRJNA316313_P_NODE_228810_length_187_cov_3.066667_g227424_i0 PRJNA316313 228810 187 3.066667 5.73466729 Arcobacter 28196 Bacteria Bacteria 44.7 0.00356   NR WP_118887296.1 1278212 g227424 i0 83.3 0.770053475935829 24 4 38.5 0 74 3 248 271 WP_118887296.1 molybdopterin molybdotransferase MoeA [Arcobacter suis] diamond 144 45.1 0.991130820399113 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis
29569104 29569104 PRJNA316313_P_NODE_154750_length_187_cov_4.493333_g153364_i0 PRJNA316313 154750 187 4.493333 8.40253271 uncultured Campylobacter sp. 218934 Bacteria Bacteria 82 4.53e-17   NR WP_297573340.1 218934 g153364 i0 72.7 1.05882352941176 66 13 97.9 1 3 185 112 177 WP_297573340.1 imidazole glycerol phosphate synthase subunit HisF [uncultured Campylobacter sp.] diamond 198 82 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
29663533 29663533 PRJNA316313_P_NODE_184310_length_187_cov_3.680000_g182924_i0 PRJNA316313 184310 187 3.68 6.8816 Helicobacter pylori 210 Bacteria Bacteria 45.8 8.1e-4   NR GAA8968878.1 210 g182924 i0 95.8 0.385026737967914 24 1 38.5 0 74 3 46 69 GAA8968878.1 hypothetical protein HpSP79_20860 [Helicobacter pylori] diamond 72 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29916731 29916731 PRJNA316313_P_NODE_378751_length_161_cov_3.185484_g377365_i0 PRJNA316313 378751 161 3.185484 5.12862924 Helicobacter pylori 210 Bacteria Bacteria 60.5 1.11e-10   NR GAA9176257.1 210 g377365 i0 75 2.6832298136646 36 9 67.1 0 113 6 3 38 GAA9176257.1 hypothetical protein Kyoto193A_0400 [Helicobacter pylori] diamond 432 60.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30881713 30881713 PRJNA316313_P_NODE_383394_length_158_cov_6.123967_g382008_i0 PRJNA316313 383394 158 6.123967 9.67586786 root 1 Root_unresolved Root_unresolved 50.1 2.76e-5   NR GAA9037473.1 210 g382008 i0 50 6.85443037974684 44 22 83.5 0 1 132 186 229 GAA9037473.1 hypothetical protein Kyoto184A_00560 [Helicobacter pylori] diamond 1083 50.4 0.994047619047619 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31306821 31306821 PRJNA316313_P_NODE_367095_length_167_cov_19.738462_g365709_i0 PRJNA316313 367095 167 19.738462 32.96323154 Helicobacter pylori 210 Bacteria Bacteria 40 0.0119   NR GAA6916578.1 210 g365709 i0 69.6 0.413173652694611 23 7 41.3 0 97 165 8 30 GAA6916578.1 hypothetical protein Kyoto207A_3550 [Helicobacter pylori] diamond 69 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31496781 31496781 PRJNA316313_P_NODE_115896_length_194_cov_4.694268_g114510_i0 PRJNA316313 115896 194 4.694268 9.10687992 Helicobacter pylori 210 Bacteria Bacteria 47 5.98e-5   NR GAA9192772.1 210 g114510 i0 86.4 0.34020618556701 22 3 34 0 24 89 2 23 GAA9192772.1 hypothetical protein Kyoto193A_3750 [Helicobacter pylori] diamond 66 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31496853 31496853 PRJNA316313_P_NODE_48836_length_263_cov_5.088496_g47451_i0 PRJNA316313 48836 263 5.088496 13.38274448 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00313   NR GAA6843347.1 210 g47451 i0 100 0.193916349809886 17 0 19.4 0 65 115 1 17 GAA6843347.1 hypothetical protein Kyoto200A_5030 [Helicobacter pylori] diamond 51 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31861776 31861776 PRJNA316313_P_NODE_261597_length_187_cov_2.706667_g260211_i0 PRJNA316313 261597 187 2.706667 5.06146729 Pseudomonadati 3379134 Bacteria Bacteria 55.8 3.37e-7   NR GAA8965433.1 210 g260211 i0 100 1.18716577540107 24 0 38.5 0 184 113 33 56 GAA8965433.1 hypothetical protein HpSP79_07860 [Helicobacter pylori] diamond 222 56.2 0.99288256227758 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31893562 31893562 PRJNA316313_P_NODE_483657_length_150_cov_5.398230_g482271_i0 PRJNA316313 483657 150 5.39823 8.097345 root 1 Root_unresolved Root_unresolved 43.1 0.00422   NR GAA9396157.1 210 g482271 i0 52.6 2.28 38 18 76 0 117 4 71 108 GAA9396157.1 hypothetical protein BTM418_15410 [Helicobacter pylori] diamond 342 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32065943 32065943 PRJNA316313_P_NODE_337158_length_185_cov_4.378378_g335772_i0 PRJNA316313 337158 185 4.378378 8.0999993 Helicobacter pylori 210 Bacteria Bacteria 42 0.0052   NR GAA9176789.1 210 g335772 i0 70.8 0.778378378378378 24 7 38.9 0 184 113 8 31 GAA9176789.1 hypothetical protein Kyoto193A_1110 [Helicobacter pylori] diamond 144 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32256320 32256320 PRJNA316313_P_NODE_99738_length_205_cov_8.125000_g98352_i0 PRJNA316313 99738 205 8.125 16.65625 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0399   NR GAA8930966.1 210 g98352 i0 41.7 0.702439024390244 48 16 70.2 2 60 203 1 36 GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori] diamond 144 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32336760 32336760 PRJNA316313_P_NODE_377259_length_162_cov_2.200000_g375873_i0 PRJNA316313 377259 162 2.2 3.564 Pseudomonadati 3379134 Bacteria Bacteria 40 0.0134   NR GAA6993167.1 210 g375873 i0 57.6 1.98148148148148 33 9 61.1 1 3 101 1 28 GAA6993167.1 hypothetical protein Kyoto211A_4860 [Helicobacter pylori] diamond 321 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32382444 32382444 PRJNA316313_P_NODE_216459_length_187_cov_3.180000_g215073_i0 PRJNA316313 216459 187 3.18 5.9466 Helicobacter pylori 210 Bacteria Bacteria 40 0.0362   NR GAA6889013.1 210 g215073 i0 45.1 0.818181818181818 51 28 81.8 0 153 1 25 75 GAA6889013.1 hypothetical protein Kyoto206A_5310 [Helicobacter pylori] diamond 153 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32382489 32382489 PRJNA316313_P_NODE_394479_length_153_cov_4.000000_g393093_i0 PRJNA316313 394479 153 4 6.12 Campylobacter jejuni 197 Bacteria Bacteria 46.6 4.6e-4   NR NHL33342.1 197 g393093 i0 38.8 1.92156862745098 49 29 96.1 1 152 6 119 166 NHL33342.1 hypothetical protein [Campylobacter jejuni] diamond 294 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32572449 32572449 PRJNA316313_P_NODE_102919_length_203_cov_4.373494_g101533_i0 PRJNA316313 102919 203 4.373494 8.87819282 Helicobacter pylori 210 Bacteria Bacteria 57.4 3.25e-9   NR GAA6795254.1 210 g101533 i0 65.7 1.03448275862069 35 12 51.7 0 115 11 4 38 GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori] diamond 210 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32603788 32603788 PRJNA316313_P_NODE_385540_length_157_cov_4.966667_g384154_i0 PRJNA316313 385540 157 4.966667 7.79766719 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.00525   NR GAA6916578.1 210 g384154 i0 85 0.382165605095541 20 3 38.2 0 2 61 8 27 GAA6916578.1 hypothetical protein Kyoto207A_3550 [Helicobacter pylori] diamond 60 40.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);;