RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA976345 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
26709183 26709183 PRJNA976345_P_NODE_57381_length_233_cov_19.111111_g55773_i0 PRJNA976345 57381 233 19.111111 44.52888863 Helicobacter pylori 210 Bacteria Bacteria 103 7.45e-27   NR GAA9165282.1 210 g55773 i0 94 0.643776824034335 50 3 64.4 0 1 150 3 52 GAA9165282.1 hypothetical protein Kyoto190A_5390 [Helicobacter pylori] diamond 150 103 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27626477 27626477 PRJNA976345_P_NODE_140144_length_170_cov_6.318519_g138536_i0 PRJNA976345 140144 170 6.318519 10.7414823 Helicobacter pylori 210 Bacteria Bacteria 65.1 1.67e-12   NR GAA8948601.1 210 g138536 i0 100 0.511764705882353 29 0 51.2 0 1 87 17 45 GAA8948601.1 hypothetical protein Kyoto181A_0400 [Helicobacter pylori] diamond 87 65.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27632601 27632601 PRJNA976345_P_NODE_183844_length_154_cov_2.168067_g182236_i0 PRJNA976345 183844 154 2.168067 3.33882318 root 1 Root_unresolved Root_unresolved 48.9 2.53e-5   NR GAA8908272.1 210 g182236 i0 53.5 2.16233766233766 43 19 83.8 1 6 134 9 50 GAA8908272.1 hypothetical protein Kyoto166A_1320 [Helicobacter pylori] diamond 333 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28390295 28390295 PRJNA976345_P_NODE_77606_length_208_cov_2.034682_g75998_i0 PRJNA976345 77606 208 2.034682 4.23213856 Bacteria 2 Bacteria Bacteria 114 4.67e-29   NR WP_198936540.1 210 g75998 i0 76.5 7.84615384615385 68 16 98.1 0 206 3 8 75 WP_198936540.1 hypothetical protein, partial [Helicobacter pylori] diamond 1632 114 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29142087 29142087 PRJNA976345_P_NODE_13509_length_464_cov_4.375291_g11935_i0 PRJNA976345 13509 464 4.375291 20.30135024 Sulfurovum sp. 1969726 Bacteria Bacteria 59.7 4.25e-7   NR MCB4762193.1 1969726 g11935 i0 27.7 2.73491379310345 141 89 89.2 4 458 45 301 431 MCB4762193.1 endonuclease/exonuclease/phosphatase family protein [Sulfurovum sp.] diamond 1269 59.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
29242858 29242858 PRJNA976345_P_NODE_154489_length_164_cov_2.457364_g152881_i0 PRJNA976345 154489 164 2.457364 4.03007696 Bacteria 2 Bacteria Bacteria 113 4.44e-30   NR PUB99708.1 210 g152881 i0 100 3.95121951219512 54 0 98.8 0 1 162 108 161 PUB99708.1 hypothetical protein C2S07_01860, partial [Helicobacter pylori] diamond 648 113 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30310908 30310908 PRJNA976345_P_NODE_179192_length_156_cov_1.264463_g177584_i0 PRJNA976345 179192 156 1.264463 1.97256228 Helicobacter pylori 210 Bacteria Bacteria 63.2 1.76e-11   NR WP_316458338.1 210 g177584 i0 97.4 0.75 39 1 75 0 151 35 41 79 WP_316458338.1 hypothetical protein, partial [Helicobacter pylori] diamond 117 63.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31353308 31353308 PRJNA976345_P_NODE_6176_length_733_cov_3.223496_g4835_i0 PRJNA976345 6176 733 3.223496 23.62822568 Sulfurovum sp. 1969726 Bacteria Bacteria 78.2 1.83e-12   NR MCB4781053.1 1969726 g4835 i0 32.7 1.67394270122783 211 118 81.4 9 696 100 59 257 MCB4781053.1 reverse transcriptase family protein [Sulfurovum sp.] diamond 1227 78.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
31511560 31511560 PRJNA976345_P_NODE_21716_length_361_cov_4.343558_g20116_i0 PRJNA976345 21716 361 4.343558 15.68024438 Campylobacterota bacterium 2026809 Bacteria Bacteria 45.8 0.00995   NR RLA60805.1 2026809 g20116 i0 41.5 0.54016620498615 65 35 52.4 2 335 147 48 111 RLA60805.1 MAG: hypothetical protein DRQ89_12255 [Campylobacterota bacterium] diamond 195 45.8 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
31897132 31897132 PRJNA976345_P_NODE_144097_length_169_cov_1.276119_g142489_i0 PRJNA976345 144097 169 1.276119 2.15664111 Bacteria 2 Bacteria Bacteria 119 1.23e-32   NR PUB99708.1 210 g142489 i0 100 2.92899408284024 55 0 97.6 0 3 167 13 67 PUB99708.1 hypothetical protein C2S07_01860, partial [Helicobacter pylori] diamond 495 119 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32017432 32017432 PRJNA976345_P_NODE_108478_length_184_cov_2.234899_g106870_i0 PRJNA976345 108478 184 2.234899 4.11221416 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0087   NR GAA6889013.1 210 g106870 i0 76.9 0.423913043478261 26 6 42.4 0 107 184 1 26 GAA6889013.1 hypothetical protein Kyoto206A_5310 [Helicobacter pylori] diamond 78 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32118761 32118761 PRJNA976345_P_NODE_22058_length_358_cov_4.866873_g20458_i0 PRJNA976345 22058 358 4.866873 17.42340534 Pseudomonadati 3379134 Bacteria Bacteria 109 4.59e-25   NR MCB4773443.1 1969726 g20458 i0 42.7 1.9608938547486 117 66 98 1 8 358 92 207 MCB4773443.1 reverse transcriptase family protein [Sulfurovum sp.] diamond 702 109 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
32593266 32593266 PRJNA976345_P_NODE_168679_length_159_cov_1.919355_g167071_i0 PRJNA976345 168679 159 1.919355 3.05177445 Pseudomonadati 3379134 Bacteria Bacteria 100 9.96e-26   NR MCH3765066.1 195 g167071 i0 94.2 3.88679245283019 52 3 98.1 0 158 3 46 97 MCH3765066.1 hypothetical protein [Campylobacter coli] diamond 618 100 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);;