RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA631796 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
27219661 27219661 PRJNA631796_S_NODE_64922_length_220_cov_1.496855_g64755_i0 PRJNA631796 64922 220 1.496855 3.293081 Pseudomonadati 3379134 Bacteria Bacteria 58.9 1.01e-9   NR GAA9176259.1 210 g64755 i0 49.3 1.81363636363636 67 9 90 2 213 16 7 49 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 399 59.3 0.993254637436762 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27725645 27725645 PRJNA631796_S_NODE_74404_length_214_cov_1.516340_g74237_i0 PRJNA631796 74404 214 1.51634 3.2449676 Pseudomonadati 3379134 Bacteria Bacteria 52.4 5.71e-7   NR GAA6835236.1 210 g74237 i0 84.6 2.94392523364486 26 4 36.4 0 208 131 5 30 GAA6835236.1 hypothetical protein Kyoto200A_4550 [Helicobacter pylori] diamond 630 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28249290 28249290 PRJNA631796_S_NODE_67706_length_218_cov_1.796178_g67539_i0 PRJNA631796 67706 218 1.796178 3.91566804 Helicobacter pylori 210 Bacteria Bacteria 68.2 2.04e-13   NR GAA8812112.1 210 g67539 i0 78.4 0.509174311926605 37 8 50.9 0 39 149 1 37 GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori] diamond 111 68.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28293484 28293484 PRJNA631796_S_NODE_100186_length_206_cov_1.262069_g100019_i0 PRJNA631796 100186 206 1.262069 2.59986214 Pseudomonadati 3379134 Bacteria Bacteria 61.6 5.68e-11   NR GAA9037979.1 210 g100019 i0 71.1 1.63106796116505 38 11 55.3 0 195 82 2 39 GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori] diamond 336 62 0.993548387096774 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28817489 28817489 PRJNA631796_S_NODE_40068_length_240_cov_1.474860_g39901_i0 PRJNA631796 40068 240 1.47486 3.539664 Helicobacter pylori 210 Bacteria Bacteria 60.8 1.92e-10   NR GAA6795286.1 210 g39901 i0 82.9 0.4375 35 5 42.5 1 236 135 6 40 GAA6795286.1 hypothetical protein Kyoto200A_0270 [Helicobacter pylori] diamond 105 60.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30270746 30270746 PRJNA631796_S_NODE_49092_length_232_cov_1.134503_g48925_i0 PRJNA631796 49092 232 1.134503 2.63204696 Helicobacter pylori 210 Bacteria Bacteria 56.2 1.23e-8   NR GAA8950290.1 210 g48925 i0 92.3 0.336206896551724 26 2 33.6 0 9 86 1 26 GAA8950290.1 hypothetical protein Kyoto181A_1480 [Helicobacter pylori] diamond 78 56.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31895103 31895103 PRJNA631796_S_NODE_134577_length_188_cov_2.133858_g134410_i0 PRJNA631796 134577 188 2.133858 4.01165304 Pseudomonadati 3379134 Bacteria Bacteria 52.8 2.42e-7   NR GAA9036680.1 210 g134410 i0 72.7 1.45212765957447 33 9 52.7 0 176 78 5 37 GAA9036680.1 hypothetical protein Kyoto181A_9030 [Helicobacter pylori] diamond 273 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32199062 32199062 PRJNA631796_S_NODE_16198_length_275_cov_1.247664_g16031_i0 PRJNA631796 16198 275 1.247664 3.431076 Helicobacter pylori 210 Bacteria Bacteria 54.7 1.44e-7   NR GAA6835236.1 210 g16031 i0 82.8 1.50545454545455 29 5 31.6 0 224 138 4 32 GAA6835236.1 hypothetical protein Kyoto200A_4550 [Helicobacter pylori] diamond 414 54.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);;