RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA758088" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA758088 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26682804 26682804 PRJNA758088_P_NODE_244261_length_272_cov_1.361809_g237290_i0 PRJNA758088 244261 272 1.361809 3.70412048 Pseudomonadati 3379134 Bacteria Bacteria 50.8 3.34e-5   NR WP_148129205.1 197 g237290 i0 65.5 0.970588235294118 29 10 32 0 3 89 1 29 WP_148129205.1 BspA family leucine-rich repeat surface protein, partial [Campylobacter jejuni] diamond 264 51.2 0.9921875 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27716765 27716765 PRJNA758088_P_NODE_212584_length_292_cov_1.301370_g205613_i0 PRJNA758088 212584 292 1.30137 3.8000004 Helicobacter pylori 210 Bacteria Bacteria 40.4 0.0348   NR GAA8932380.1 210 g205613 i0 90.2 0.421232876712329 41 4 42.1 0 3 125 2 42 GAA8932380.1 hypothetical protein Kyoto166A_4400 [Helicobacter pylori] diamond 123 40.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28158639 28158639 PRJNA758088_P_NODE_122225_length_379_cov_2.320261_g115254_i0 PRJNA758088 122225 379 2.320261 8.79378919 Campylobacterales bacterium 2268180 Bacteria Bacteria 93.6 2.67e-19   NR MBY0539904.1 2268180 g115254 i0 57.9 0.601583113456464 76 32 60.2 0 372 145 357 432 MBY0539904.1 hypothetical protein [Campylobacterales bacterium] diamond 228 93.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
28600559 28600559 PRJNA758088_P_NODE_139547_length_356_cov_1.346290_g132576_i0 PRJNA758088 139547 356 1.34629 4.7927924 Helicobacter pylori 210 Bacteria Bacteria 53.9 4.15e-7   NR GAA8683167.1 210 g132576 i0 73.3 0.252808988764045 30 8 25.3 0 356 267 1 30 GAA8683167.1 hypothetical protein Kyoto145A_0420 [Helicobacter pylori] diamond 90 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28610312 28610312 PRJNA758088_P_NODE_180327_length_316_cov_1.267490_g173356_i0 PRJNA758088 180327 316 1.26749 4.0052684 Pseudomonadati 3379134 Bacteria Bacteria 202 3.9e-65   NR MCH3755768.1 195 g173356 i0 99 1.99367088607595 105 1 99.7 0 315 1 9 113 MCH3755768.1 ATP-binding cassette domain-containing protein [Campylobacter coli] diamond 630 204 0.990196078431373 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
28726780 28726780 PRJNA758088_P_NODE_344387_length_243_cov_1.358824_g337416_i0 PRJNA758088 344387 243 1.358824 3.30194232 Helicobacter pylori 210 Bacteria Bacteria 52 6.03e-7   NR GAA9104010.1 210 g337416 i0 87.5 0.296296296296296 24 3 29.6 0 158 87 4 27 GAA9104010.1 hypothetical protein Kyoto184A_09450 [Helicobacter pylori] diamond 72 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29042675 29042675 PRJNA758088_P_NODE_340388_length_244_cov_0.900585_g333417_i0 PRJNA758088 340388 244 0.900585 2.1974274 Helicobacter pylori 210 Bacteria Bacteria 52 7.07e-7   NR GAA8812112.1 210 g333417 i0 90.9 0.590163934426229 22 2 27 0 118 183 26 47 GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori] diamond 144 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31285188 31285188 PRJNA758088_P_NODE_248395_length_270_cov_0.893401_g241424_i0 PRJNA758088 248395 270 0.893401 2.4121827 uncultured Helicobacter sp. 175537 Bacteria Bacteria 75.1 5.87e-14   NR WP_300948534.1 175537 g241424 i0 51.7 3.04444444444444 60 29 66.7 0 255 76 91 150 WP_300948534.1 carbonic anhydrase [uncultured Helicobacter sp.] diamond 822 75.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
32519366 32519366 PRJNA758088_P_NODE_69539_length_515_cov_1.002262_g62587_i0 PRJNA758088 69539 515 1.002262 5.1616493 Campylobacterales bacterium 2268180 Bacteria Bacteria 121 1.47e-28   NR MBY0539904.1 2268180 g62587 i0 41.9 0.972815533980583 167 93 97.3 2 501 1 258 420 MBY0539904.1 hypothetical protein [Campylobacterales bacterium] diamond 501 121 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium

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);;