RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA399711" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA399711 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
27913197 27913197 PRJNA399711_P_NODE_13985_length_178_cov_3.312057_g13919_i0 PRJNA399711 13985 178 3.312057 5.89546146 Bacteria 2 Bacteria Bacteria 39.7 0.0194   NR GAA8912035.1 210 g13919 i0 76.2 0.691011235955056 21 5 35.4 0 124 62 16 36 GAA8912035.1 hypothetical protein Kyoto166A_2340 [Helicobacter pylori] diamond 123 40 0.9925 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28938708 28938708 PRJNA399711_P_NODE_19148_length_164_cov_6.133858_g19082_i0 PRJNA399711 19148 164 6.133858 10.05952712 Helicobacter pylori 210 Bacteria Bacteria 67 4.78e-13   NR GAA8854446.1 210 g19082 i0 72.5 0.932926829268293 51 13 91.5 1 160 11 19 69 GAA8854446.1 hypothetical protein Kyoto154A_1380 [Helicobacter pylori] diamond 153 67 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31750405 31750405 PRJNA399711_P_NODE_12137_length_185_cov_9.283784_g12071_i0 PRJNA399711 12137 185 9.283784 17.1750004 Helicobacter pylori 210 Bacteria Bacteria 45.4 3.59e-4   NR GAA9044369.1 210 g12071 i0 80 0.405405405405405 25 5 40.5 0 166 92 54 78 GAA9044369.1 hypothetical protein Kyoto184A_02810 [Helicobacter pylori] diamond 75 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32825071 32825071 PRJNA399711_P_NODE_9480_length_199_cov_16.043210_g9414_i0 PRJNA399711 9480 199 16.04321 31.9259879 Helicobacter pylori 210 Bacteria Bacteria 49.7 3.07e-6   NR GAA6795642.1 210 g9414 i0 100 0.301507537688442 20 0 30.2 0 197 138 1 20 GAA6795642.1 hypothetical protein Kyoto200A_0470 [Helicobacter pylori] diamond 60 49.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32917513 32917513 PRJNA399711_S_NODE_27945_length_245_cov_2.971154_g27803_i0 PRJNA399711 27945 245 2.971154 7.2793273 Desulfurellales bacterium 2482794 Bacteria Bacteria 62.4 7.41e-10   NR TXH57698.1 2482794 g27803 i0 49.2 0.746938775510204 61 30 74.7 1 242 60 97 156 TXH57698.1 MAG: HK97 gp10 family phage protein [Desulfurellales bacterium] diamond 183 62.4 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32958422 32958422 PRJNA399711_S_NODE_30218_length_238_cov_4.890547_g30076_i0 PRJNA399711 30218 238 4.890547 11.63950186 Pseudomonadati 3379134 Bacteria Bacteria 57.4 8.79e-9   NR GAA9038100.1 210 g30076 i0 47.1 1.18487394957983 68 11 85.7 1 32 235 6 48 GAA9038100.1 hypothetical protein Kyoto184A_01000 [Helicobacter pylori] diamond 282 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33020328 33020328 PRJNA399711_S_NODE_67476_length_178_cov_7.978723_g67334_i0 PRJNA399711 67476 178 7.978723 14.20212694 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.00825   NR GAA9056084.1 210 g67334 i0 75 0.337078651685393 20 5 33.7 0 96 37 1 20 GAA9056084.1 hypothetical protein Kyoto184A_04520 [Helicobacter pylori] diamond 60 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33043774 33043774 PRJNA399711_S_NODE_98708_length_156_cov_0.941176_g98566_i0 PRJNA399711 98708 156 0.941176 1.46823456 Aliarcobacter 2321111 Bacteria Bacteria 92.8 8.25e-21   NR WP_237923586.1 28197 g98566 i0 86 4.80769230769231 50 7 96.2 0 2 151 251 300 WP_237923586.1 DNA (cytosine-5-)-methyltransferase [Aliarcobacter butzleri] diamond 750 93.6 0.991452991452991 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
33054594 33054594 PRJNA399711_S_NODE_92205_length_159_cov_6.254098_g92063_i0 PRJNA399711 92205 159 6.254098 9.94401582 Helicobacter pylori 210 Bacteria Bacteria 39.3 0.0387   NR GAA6988816.1 210 g92063 i0 53.2 0.886792452830189 47 17 88.7 1 155 15 18 59 GAA6988816.1 hypothetical protein Kyoto211A_4340 [Helicobacter pylori] diamond 141 39.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33122648 33122648 PRJNA399711_S_NODE_55911_length_191_cov_3.512987_g55769_i0 PRJNA399711 55911 191 3.512987 6.70980517 Campylobacter coli 195 Bacteria Bacteria 115 1.38e-28   NR WP_402370334.1 195 g55769 i0 88.9 0.989528795811518 63 7 99 0 3 191 17 79 WP_402370334.1 protein rep [Campylobacter coli] diamond 189 115 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
33139685 33139685 PRJNA399711_S_NODE_53919_length_193_cov_18.461538_g53777_i0 PRJNA399711 53919 193 18.461538 35.63076834 Campylobacterota bacterium 2026809 Bacteria Bacteria 43.5 0.00934   NR MEA3512836.1 2026809 g53777 i0 50 0.652849740932642 42 21 65.3 0 13 138 8 49 MEA3512836.1 DUF3800 domain-containing protein [Campylobacterota bacterium] diamond 126 43.5 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
33139754 33139754 PRJNA399711_S_NODE_64455_length_181_cov_7.451389_g64313_i0 PRJNA399711 64455 181 7.451389 13.48701409 Helicobacter pylori 210 Bacteria Bacteria 44.7 4.55e-4   NR GAA9243766.1 210 g64313 i0 78.3 0.38121546961326 23 5 38.1 0 2 70 3 25 GAA9243766.1 hypothetical protein Kyoto198A_5880 [Helicobacter pylori] diamond 69 44.7 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);;