RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA596870", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA596870 · 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
20970864 20970864 PRJNA596870_P_NODE_37377_length_243_cov_1.735294_g37244_i0 PRJNA596870 37377 243 1.735294 4.21676442 Aliarcobacter vitoriensis 2011099 Bacteria Bacteria 52.8 0.022   NTclustered gi|2922069336|gb|CP182882.1| 2011099 g37244 i0 100 0.11522633744856 28 0 12 0 95 122 1371343 1371370 Aliarcobacter vitoriensis strain BNI-4100 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter vitoriensis
26921617 26921617 PRJNA596870_P_NODE_16482_length_324_cov_2.039841_g16349_i0 PRJNA596870 16482 324 2.039841 6.60908484 Helicobacter pylori 210 Bacteria Bacteria 43.5 0.00344   NR GAA9125607.1 210 g16349 i0 60.6 0.305555555555556 33 13 30.6 0 103 5 16 48 GAA9125607.1 hypothetical protein Kyoto190A_0930 [Helicobacter pylori] diamond 99 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28090440 28090440 PRJNA596870_P_NODE_9985_length_400_cov_1.412844_g9852_i0 PRJNA596870 9985 400 1.412844 5.651376 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0499   NR GAA8856509.1 210 g9852 i0 53.1 0.24 32 15 24 0 1 96 22 53 GAA8856509.1 hypothetical protein Kyoto154A_2060 [Helicobacter pylori] diamond 96 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28753537 28753537 PRJNA596870_P_NODE_15327_length_335_cov_0.881679_g15194_i0 PRJNA596870 15327 335 0.881679 2.95362465 Helicobacter pylori 210 Bacteria Bacteria 47 3.6e-4   NR GAA8909605.1 210 g15194 i0 42.4 0.591044776119403 66 23 48.4 2 93 254 3 65 GAA8909605.1 hypothetical protein Kyoto166A_1730 [Helicobacter pylori] diamond 198 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32261462 32261462 PRJNA596870_P_NODE_28478_length_253_cov_1.711111_g28345_i0 PRJNA596870 28478 253 1.711111 4.32911083 Helicobacter pylori 210 Bacteria Bacteria 47 7.6e-4   NR GAA9039287.1 210 g28345 i0 36.6 0.841897233201581 71 41 79.4 1 204 4 74 144 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 213 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32640257 32640257 PRJNA596870_P_NODE_29100_length_251_cov_0.865169_g28967_i0 PRJNA596870 29100 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.019   NR GAA8856509.1 210 g28967 i0 47.2 0.430278884462151 36 18 41.8 1 186 82 22 57 GAA8856509.1 hypothetical protein Kyoto154A_2060 [Helicobacter pylori] diamond 108 41.2 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);;