RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA312615" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312615 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
16955116 16955116 PRJNA312615_P_NODE_13334_length_338_cov_0.934256_g13183_i0 PRJNA312615 13334 338 0.934256 3.15778528 Mycoplasma sp. HU2 2108 Bacteria Bacteria 78.2 8.14e-16   NR WP_160314997.1 1664275 g13183 i0 75.5 1.88165680473373 53 13 47 0 62 220 78 130 WP_160314997.1 hypothetical protein, partial [Mycoplasma sp. HU2014] diamond 636 78.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
27674730 27674730 PRJNA312615_P_NODE_55304_length_164_cov_0.886957_g55153_i0 PRJNA312615 55304 164 0.886957 1.45460948 Malacoplasma sp. 2791014 Bacteria Bacteria 79.3 1.49e-15   NR MEF9985415.1 2791014 g55153 i0 80.4 0.932926829268293 51 10 93.3 0 164 12 369 419 MEF9985415.1 replication initiation protein [Malacoplasma sp.] diamond 153 79.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
28274310 28274310 PRJNA312615_P_NODE_56606_length_163_cov_0.894737_g56455_i0 PRJNA312615 56606 163 0.894737 1.45842131 Mycoplasma putrefaciens 2123 Bacteria Bacteria 74.3 3.34e-14   NR WP_014035245.1 2123 g56455 i0 66.7 1.98773006134969 54 18 99.4 0 163 2 82 135 WP_014035245.1 NAD(+)/NADH kinase [Mycoplasma putrefaciens] diamond 324 74.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma putrefaciens
28716555 28716555 PRJNA312615_P_NODE_55467_length_164_cov_0.886957_g55316_i0 PRJNA312615 55467 164 0.886957 1.45460948 Mycoplasmopsis bovis 28903 Bacteria Bacteria 63.9 3.19e-10   NR WP_013456010.1 28903 g55316 i0 78 0.75 41 9 75 0 164 42 211 251 WP_013456010.1 Cof-type HAD-IIB family hydrolase [Mycoplasmopsis bovis] diamond 123 63.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
29586204 29586204 PRJNA312615_P_NODE_7390_length_451_cov_1.325871_g7240_i0 PRJNA312615 7390 451 1.325871 5.97967821 Mycoplasma 2093 Bacteria Bacteria 159 5.09e-45   NR AME13688.1 2103 g7240 i0 63.1 11.2416851441242 130 48 86.5 0 449 60 67 196 AME13688.1 putative transposase InsK for insertion sequence IS150 [Mycoplasma mycoides subsp. mycoides] diamond 5070 160 0.99375 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
29965544 29965544 PRJNA312615_P_NODE_33431_length_212_cov_1.024540_g33280_i0 PRJNA312615 33431 212 1.02454 2.1720248 Mycoplasma 2093 Bacteria Bacteria 59.7 2.2e-8   NR CBW54506.1 862259 g33280 i0 58.6 10.9245283018868 58 24 82.1 0 25 198 197 254 CBW54506.1 IS1296 I transposase protein A [Mycoplasma mycoides subsp. capri LC str. 95010] diamond 2316 60.1 0.993344425956739 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
30895905 30895905 PRJNA312615_P_NODE_39674_length_195_cov_1.013699_g39523_i0 PRJNA312615 39674 195 1.013699 1.97671305 Aster yellows phytoplasma 35779 Bacteria Bacteria 50.8 1.34e-6   NR AAO61994.1 35779 g39523 i0 50 0.769230769230769 50 25 76.9 0 151 2 3 52 AAO61994.1 conserved hypothetical protein, partial [Aster yellows phytoplasma] diamond 150 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Aster yellows phytoplasma
31179776 31179776 PRJNA312615_P_NODE_28115_length_231_cov_0.736264_g27964_i0 PRJNA312615 28115 231 0.736264 1.70076984 Mycoplasma yeatsii 51365 Bacteria Bacteria 90.9 3.55e-19   NR WP_004429417.1 51365 g27964 i0 63.5 0.961038961038961 74 27 96.1 0 229 8 826 899 WP_004429417.1 magnesium-translocating P-type ATPase [Mycoplasma yeatsii] diamond 222 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
31496588 31496588 PRJNA312615_P_NODE_54116_length_165_cov_0.879310_g53965_i0 PRJNA312615 54116 165 0.87931 1.4508615 Mycoplasma mycoides 2102 Bacteria Bacteria 62.8 1.12e-9   NR WP_013729831.1 2102 g53965 i0 56.4 15 55 24 100 0 165 1 209 263 WP_013729831.1 transposase [Mycoplasma mycoides] diamond 2475 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
32129254 32129254 PRJNA312615_P_NODE_31858_length_217_cov_1.041667_g31707_i0 PRJNA312615 31858 217 1.041667 2.26041739 Mycoplasma sp. HU2 2108 Bacteria Bacteria 84.7 1.91e-17   NR WP_050517428.1 1664275 g31707 i0 56.3 0.981566820276498 71 31 98.2 0 3 215 265 335 WP_050517428.1 HU family DNA-binding protein [Mycoplasma sp. HU2014] diamond 213 84.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32872797 32872797 PRJNA312615_P_NODE_22340_length_258_cov_1.464115_g22189_i0 PRJNA312615 22340 258 1.464115 3.7774167 Bacteria 2 Bacteria Bacteria 99.8 2.45e-22   NR WP_004430208.1 51365 g22189 i0 80.3 1.53488372093023 66 13 76.7 0 253 56 205 270 WP_004430208.1 FAD-dependent oxidoreductase [Mycoplasma yeatsii] diamond 396 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii

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