RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA680334 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27461302 27461302 PRJNA680334_S_NODE_43303_length_200_cov_26.449102_g42817_i0 PRJNA680334 43303 200 26.449102 52.898204 Helicobacter pylori 210 Bacteria Bacteria 70.1 6.43e-14   NR GAA8948737.1 210 g42817 i0 68 0.75 50 15 75 1 200 51 8 56 GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori] diamond 150 70.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28471659 28471659 PRJNA680334_P_NODE_166_length_224_cov_5.061538_g165_i0 PRJNA680334 166 224 5.061538 11.33784512 Helicobacter pylori 210 Bacteria Bacteria 45.4 3.65e-4   NR GAA9127427.1 210 g165 i0 89.5 0.254464285714286 19 2 25.4 0 64 120 1 19 GAA9127427.1 hypothetical protein Kyoto190A_1400 [Helicobacter pylori] diamond 57 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29450091 29450091 PRJNA680334_P_NODE_710_length_153_cov_2.524194_g709_i0 PRJNA680334 710 153 2.524194 3.86201682 Helicobacter pylori 210 Bacteria Bacteria 42.7 8.88e-4   NR GAA9038474.1 210 g709 i0 94.1 0.333333333333333 17 1 33.3 0 88 138 1 17 GAA9038474.1 hypothetical protein Kyoto184A_01180 [Helicobacter pylori] diamond 51 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30619014 30619014 PRJNA680334_S_NODE_96573_length_155_cov_3.459016_g96087_i0 PRJNA680334 96573 155 3.459016 5.3614748 Sulfurimonas sp. 2022749 Bacteria Bacteria 57 1.03e-7   NR WP_294928611.1 2022749 g96087 i0 51 0.987096774193548 51 25 98.7 0 154 2 124 174 WP_294928611.1 AAA family ATPase [Sulfurimonas sp.] diamond 153 57 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.
30998291 30998291 PRJNA680334_S_NODE_56434_length_184_cov_17.033113_g55948_i0 PRJNA680334 56434 184 17.033113 31.34092792 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.00516   NR GAA9228604.1 210 g55948 i0 53.6 0.456521739130435 28 13 45.7 0 5 88 1 28 GAA9228604.1 hypothetical protein Kyoto198A_4520 [Helicobacter pylori] diamond 84 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31579251 31579251 PRJNA680334_S_NODE_7176_length_346_cov_77.255591_g6690_i0 PRJNA680334 7176 346 77.255591 267.30434486 Pseudomonadati 3379134 Bacteria Bacteria 42 0.0181   NR GAA8979103.1 210 g6690 i0 80 0.320809248554913 20 4 17.3 0 182 123 1 20 GAA8979103.1 hypothetical protein Kyoto181A_5090 [Helicobacter pylori] diamond 111 42 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);;