RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA715462" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA715462 · 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
7084856 7084856 PRJNA715462_P_NODE_51726_length_251_cov_0.865169_g50930_i0 PRJNA715462 51726 251 0.865169 2.17157419 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 63.5 7.06e-11   NR MBR2055756.1 2685873 g50930 i0 64.6 0.573705179282869 48 17 57.4 0 249 106 51 98 MBR2055756.1 hypothetical protein [Mycoplasmataceae bacterium] diamond 144 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
12671811 12671811 PRJNA715462_P_NODE_15030_length_503_cov_1.123256_g14235_i0 PRJNA715462 15030 503 1.123256 5.64997768 root 1 Root_unresolved Root_unresolved 120 1.3099999999999998e-31   NR MDI4567532.1 2108 g14235 i0 50.4 13.2226640159046 125 61 74.6 1 439 65 18 141 MDI4567532.1 30S ribosomal protein S9 [Mycoplasma sp.] diamond 6651 121 0.991735537190083 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
26734981 26734981 PRJNA715462_P_NODE_60181_length_246_cov_0.890173_g59385_i0 PRJNA715462 60181 246 0.890173 2.18982558 Malacoplasma sp. 2791014 Bacteria Bacteria 43.9 0.0145   NR MCF0227332.1 2791014 g59385 i0 40.7 1.31707317073171 54 29 62.2 1 2 154 318 371 MCF0227332.1 leucine-rich repeat protein [Malacoplasma sp.] diamond 324 43.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
31125822 31125822 PRJNA715462_P_NODE_64575_length_243_cov_1.564706_g63779_i0 PRJNA715462 64575 243 1.564706 3.80223558 Paracholeplasma manati 591373 Bacteria Bacteria 164 2.3899999999999994e-48   NR WP_263608320.1 591373 g63779 i0 100 0.975308641975309 79 0 97.5 0 239 3 149 227 WP_263608320.1 thymidylate synthase [Paracholeplasma manati] diamond 237 164 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Paracholeplasma Paracholeplasma manati
31980061 31980061 PRJNA715462_P_NODE_63098_length_244_cov_0.900585_g62302_i0 PRJNA715462 63098 244 0.900585 2.1974274 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 122 1.7999999999999998e-33   NR MBR3571256.1 2685873 g62302 i0 79.4 1.69672131147541 68 14 83.6 0 5 208 84 151 MBR3571256.1 rRNA maturation RNase YbeY [Mycoplasmataceae bacterium] diamond 414 122 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
32296940 32296940 PRJNA715462_P_NODE_40319_length_280_cov_1.352657_g39523_i0 PRJNA715462 40319 280 1.352657 3.7874396 Mesomycoplasma moatsii 171287 Bacteria Bacteria 141 1.19e-37   NR WP_022935309.1 171287 g39523 i0 84.5 0.9 84 13 90 0 29 280 232 315 WP_022935309.1 FAD-dependent oxidoreductase [Mesomycoplasma moatsii] diamond 252 141 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma moatsii

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