RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA883229" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA883229 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2135318 2135318 PRJNA883229_P_NODE_11902_length_248_cov_1.542857_g11856_i0 PRJNA883229 11902 248 1.542857 3.82628536 Tenericutes bacterium ADurb.BinA155 1852922 Bacteria Bacteria 127 6.96e-33   NR OPZ34782.1 1852922 g11856 i0 89.4 1.62096774193548 66 7 79.8 0 201 4 3 68 OPZ34782.1 MAG: S-adenosylmethionine synthase [Tenericutes bacterium ADurb.BinA155] diamond 402 127 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.BinA155
27750573 27750573 PRJNA883229_P_NODE_11444_length_249_cov_0.886364_g11398_i0 PRJNA883229 11444 249 0.886364 2.20704636 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 158 4.2399999999999995e-45   NR MBO5542746.1 2053494 g11398 i0 97.6 2 83 2 100 0 1 249 257 339 MBO5542746.1 hypothetical protein [Acholeplasmatales bacterium] diamond 498 158 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
28034649 28034649 PRJNA883229_P_NODE_12025_length_248_cov_0.891429_g11979_i0 PRJNA883229 12025 248 0.891429 2.21074392 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 80.1 2.74e-15   NR MBR6071957.1 2053494 g11979 i0 51.8 1.00403225806452 83 39 99.2 1 1 246 18 100 MBR6071957.1 hypothetical protein [Acholeplasmatales bacterium] diamond 249 80.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
28137372 28137372 PRJNA883229_P_NODE_5005_length_308_cov_1.234043_g4959_i0 PRJNA883229 5005 308 1.234043 3.80085244 Bacillati 1783272 Bacteria Bacteria 87.8 1.47e-18   NR MCI7224879.1 37628 g4959 i0 58.8 1.99675324675325 68 28 66.2 0 1 204 185 252 MCI7224879.1 hypothetical protein [Mollicutes bacterium] diamond 615 87.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28792121 28792121 PRJNA883229_P_NODE_12127_length_248_cov_0.891429_g12081_i0 PRJNA883229 12127 248 0.891429 2.21074392 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 148 7.2e-40   NR MBR6288188.1 2053494 g12081 i0 91.5 0.991935483870968 82 7 99.2 0 248 3 340 421 MBR6288188.1 DEAD/DEAH box helicase [Acholeplasmatales bacterium] diamond 246 148 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
29392293 29392293 PRJNA883229_P_NODE_7009_length_274_cov_1.592040_g6963_i0 PRJNA883229 7009 274 1.59204 4.3621896 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 90.9 3.39e-19   NR MBO5542377.1 2053494 g6963 i0 97.8 0.985401459854015 45 1 49.3 0 3 137 313 357 MBO5542377.1 1-deoxy-D-xylulose-5-phosphate synthase [Acholeplasmatales bacterium] diamond 270 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
29486670 29486670 PRJNA883229_P_NODE_13290_length_246_cov_1.473988_g13244_i0 PRJNA883229 13290 246 1.473988 3.62601048 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 124 5.88e-31   NR MBQ9520509.1 2053494 g13244 i0 79 0.98780487804878 81 17 98.8 0 244 2 432 512 MBQ9520509.1 DNA repair protein RecN [Acholeplasmatales bacterium] diamond 243 124 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
29707486 29707486 PRJNA883229_P_NODE_16070_length_242_cov_1.840237_g16024_i0 PRJNA883229 16070 242 1.840237 4.45337354 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 139 7.46e-40   NR MBQ9520050.1 2053494 g16024 i0 87.5 0.991735537190083 80 10 99.2 0 242 3 84 163 MBQ9520050.1 indolepyruvate oxidoreductase subunit beta [Acholeplasmatales bacterium] diamond 240 139 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
30149916 30149916 PRJNA883229_P_NODE_13192_length_247_cov_0.896552_g13146_i0 PRJNA883229 13192 247 0.896552 2.21448344 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 169 1.3899999999999998e-48   NR MBQ6784147.1 2053494 g13146 i0 100 0.995951417004049 82 0 99.6 0 246 1 69 150 MBQ6784147.1 hypothetical protein [Acholeplasmatales bacterium] diamond 246 169 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
30782049 30782049 PRJNA883229_P_NODE_15134_length_244_cov_0.912281_g15088_i0 PRJNA883229 15134 244 0.912281 2.22596564 Mollicutes bacterium 37628 Bacteria Bacteria 46.2 0.00183   NR MDD6402955.1 37628 g15088 i0 33.3 0.885245901639344 72 48 88.5 0 218 3 107 178 MDD6402955.1 hypothetical protein [Mollicutes bacterium] diamond 216 46.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31319248 31319248 PRJNA883229_P_NODE_12955_length_247_cov_0.896552_g12909_i0 PRJNA883229 12955 247 0.896552 2.21448344 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 65.1 3.22e-10   NR MBQ7640924.1 2053494 g12909 i0 60.3 0.704453441295547 58 22 70.4 1 69 242 1 57 MBQ7640924.1 amino acid ABC transporter permease [Acholeplasmatales bacterium] diamond 174 65.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
31667127 31667127 PRJNA883229_P_NODE_11817_length_249_cov_0.886364_g11771_i0 PRJNA883229 11817 249 0.886364 2.20704636 Mollicutes bacterium 37628 Bacteria Bacteria 157 1.4499999999999998e-42   NR MDD6402856.1 37628 g11771 i0 90.2 0.987951807228916 82 8 98.8 0 4 249 15 96 MDD6402856.1 glycosyltransferase [Mollicutes bacterium] diamond 246 157 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
32331993 32331993 PRJNA883229_P_NODE_5259_length_302_cov_1.362445_g5213_i0 PRJNA883229 5259 302 1.362445 4.1145839 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 167 1.41e-48   NR WP_211321093.1 2088 g5213 i0 78 2.98013245033113 100 22 99.3 0 1 300 3 102 WP_211321093.1 transposase [Anaeroplasma bactoclasticum] diamond 900 167 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum

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