RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA315399" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315399 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
26599258 26599258 PRJNA315399_P_NODE_327041_length_176_cov_2.784173_g326593_i0 PRJNA315399 327041 176 2.784173 4.90014448 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 43.9 0.00531   NR NLH44821.1 1898209 g326593 i0 84.6 0.443181818181818 26 4 44.3 0 89 166 1 26 NLH44821.1 YggS family pyridoxal phosphate-dependent enzyme [Acholeplasmataceae bacterium] diamond 78 43.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
27091910 27091910 PRJNA315399_P_NODE_466342_length_154_cov_5.786325_g465894_i0 PRJNA315399 466342 154 5.786325 8.9109405 Bacillati 1783272 Bacteria Bacteria 49.7 3.95e-5   NR MCI5543048.1 37628 g465894 i0 37.5 3.74025974025974 48 30 93.5 0 2 145 206 253 MCI5543048.1 signal peptidase I [Mollicutes bacterium] diamond 576 49.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
27137190 27137190 PRJNA315399_P_NODE_446462_length_156_cov_8.663866_g446014_i0 PRJNA315399 446462 156 8.663866 13.51563096 Anaeroplasmataceae bacterium 2793037 Bacteria Bacteria 75.1 2.56e-14   NR MDE5868172.1 2793037 g446014 i0 78.3 13.1153846153846 46 10 88.5 0 147 10 14 59 MDE5868172.1 tRNA dihydrouridine synthase DusB [Anaeroplasmataceae bacterium] diamond 2046 75.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae   Anaeroplasmataceae bacterium
27137202 27137202 PRJNA315399_P_NODE_511262_length_150_cov_3.371681_g510814_i0 PRJNA315399 511262 150 3.371681 5.0575215 Mycoplasma sp. E35C 2801918 Bacteria Bacteria 41.6 0.0108   NR WP_222926408.1 2801918 g510814 i0 38.9 1.08 54 28 98 1 4 150 16 69 WP_222926408.1 ribonuclease P protein component [Mycoplasma sp. E35C] diamond 162 41.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. E35C
27706597 27706597 PRJNA315399_P_NODE_317224_length_177_cov_16.678571_g316776_i0 PRJNA315399 317224 177 16.678571 29.52107067 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 48.9 7.36e-5   NR NLH46748.1 1898209 g316776 i0 95.8 0.813559322033898 24 1 40.7 0 6 77 167 190 NLH46748.1 F420-0:Gamma-glutamyl ligase [Acholeplasmataceae bacterium] diamond 144 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28179575 28179575 PRJNA315399_P_NODE_261406_length_181_cov_3.041667_g260958_i0 PRJNA315399 261406 181 3.041667 5.50541727 Mollicutes bacterium 37628 Bacteria Bacteria 60.8 1.66e-9   NR MCI5542891.1 37628 g260958 i0 100 0.414364640883978 25 0 41.4 0 180 106 79 103 MCI5542891.1 helix-hairpin-helix domain-containing protein [Mollicutes bacterium] diamond 75 60.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28211208 28211208 PRJNA315399_P_NODE_263726_length_181_cov_2.513889_g263278_i0 PRJNA315399 263726 181 2.513889 4.55013909 Mesomycoplasma ovipneumoniae 29562 Bacteria Bacteria 43.5 0.00633   NR WP_337896608.1 29562 g263278 i0 100 0.331491712707182 20 0 33.1 0 76 17 22 41 WP_337896608.1 replication initiator protein A, partial [Mesomycoplasma ovipneumoniae] diamond 60 43.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma ovipneumoniae
28211245 28211245 PRJNA315399_P_NODE_486346_length_152_cov_5.843478_g485898_i0 PRJNA315399 486346 152 5.843478 8.88208656 Mollicutes bacterium 37628 Bacteria Bacteria 94 9.63e-21   NR MCI7068307.1 37628 g485898 i0 100 2.72368421052632 46 0 90.8 0 11 148 398 443 MCI7068307.1 EAL domain-containing protein [Mollicutes bacterium] diamond 414 94 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28260243 28260243 PRJNA315399_P_NODE_383086_length_163_cov_8.349206_g382638_i0 PRJNA315399 383086 163 8.349206 13.60920578 Ureaplasma 2129 Bacteria Bacteria 42 0.0243   NR MBU3830771.1 2838770 g382638 i0 66.7 0.957055214723926 27 9 49.7 0 71 151 5 31 MBU3830771.1 APC family permease [Candidatus Ureaplasma intestinipullorum] diamond 156 42.4 0.990566037735849 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Candidatus Ureaplasma intestinipullorum
28464105 28464105 PRJNA315399_P_NODE_211046_length_184_cov_4.136054_g210598_i0 PRJNA315399 211046 184 4.136054 7.61033936 Candidatus Hepatoplasma crinochetorum 295596 Bacteria Bacteria 46.6 6.57e-4   NR CRX37334.1 295596 g210598 i0 100 0.358695652173913 22 0 35.9 0 109 174 9 30 CRX37334.1 | stp | Serine/threonine phosphatase stp |:213122 Forward [Candidatus Hepatoplasma crinochetorum] diamond 66 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Candidatus Hepatoplasmataceae Candidatus Hepatoplasma Candidatus Hepatoplasma crinochetorum
28810901 28810901 PRJNA315399_P_NODE_104408_length_199_cov_10.283951_g103960_i0 PRJNA315399 104408 199 10.283951 20.46506249 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 85.1 2.38e-17   NR HEY8364887.1 2862752 g103960 i0 61.9 0.949748743718593 63 24 95 0 6 194 234 296 HEY8364887.1 hypothetical protein [Haloplasmataceae bacterium] diamond 189 85.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
29758467 29758467 PRJNA315399_S_NODE_172091_length_155_cov_5.245763_g171890_i0 PRJNA315399 172091 155 5.245763 8.13093265 Candidatus Izimaplasma bacterium N/A Bacteria Bacteria 40.4 0.0346   NR MCF7925387.1 2315156 g171890 i0 47.5 0.774193548387097 40 20 75.5 1 136 20 29 68 MCF7925387.1 nuclear transport factor 2 family protein [Candidatus Izimaplasma bacterium] diamond 120 40.4 1 Bacteria   Bacillati Mycoplasmatota Candidatus Izimaplasma       Candidatus Izimaplasma bacterium
30137210 30137210 PRJNA315399_P_NODE_392612_length_162_cov_5.952000_g392164_i0 PRJNA315399 392612 162 5.952 9.64224 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 91.3 1.02e-19   NR HEY8364887.1 2862752 g392164 i0 89.4 0.87037037037037 47 5 87 0 150 10 159 205 HEY8364887.1 hypothetical protein [Haloplasmataceae bacterium] diamond 141 91.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
30485211 30485211 PRJNA315399_P_NODE_416973_length_160_cov_1.243902_g416525_i0 PRJNA315399 416973 160 1.243902 1.9902432 Metamycoplasma hominis 2098 Bacteria Bacteria 43.9 0.0018600000000000001   NR WP_368319148.1 2098 g416525 i0 51.3 5.19375 39 19 73.1 0 127 11 3 41 WP_368319148.1 leucine-rich repeat domain-containing protein, partial [Metamycoplasma hominis] diamond 831 43.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hominis
30579721 30579721 PRJNA315399_S_NODE_194113_length_151_cov_1.649123_g193912_i0 PRJNA315399 194113 151 1.649123 2.49017573 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 89 5.34e-19   NR MCI5521906.1 2231116 g193912 i0 97.7 0.874172185430464 44 1 87.4 0 133 2 32 75 MCI5521906.1 ATP-binding cassette domain-containing protein [Mycoplasmatota bacterium] diamond 132 89 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
30660586 30660586 PRJNA315399_S_NODE_76693_length_191_cov_5.272727_g76492_i0 PRJNA315399 76693 191 5.272727 10.07090857 Bacillati 1783272 Bacteria Bacteria 68.6 8.87e-13   NR MCI7527288.1 37628 g76492 i0 46.8 4.79057591623037 62 33 97.4 0 3 188 68 129 MCI7527288.1 hypothetical protein [Mollicutes bacterium] diamond 915 68.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30959147 30959147 PRJNA315399_P_NODE_343534_length_171_cov_4.246269_g343086_i0 PRJNA315399 343534 171 4.246269 7.26111999 Mycoplasma anserisalpingitidis 519450 Bacteria Bacteria 46.6 4.59e-4   NR WP_146309085.1 519450 g343086 i0 61.8 2.33333333333333 34 13 59.6 0 117 16 1 34 WP_146309085.1 NAD(P)H-dependent oxidoreductase [Mycoplasma anserisalpingitidis] diamond 399 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma anserisalpingitidis
31243430 31243430 PRJNA315399_P_NODE_40475_length_251_cov_6.154206_g40028_i0 PRJNA315399 40475 251 6.154206 15.44705706 Mollicutes bacterium 37628 Bacteria Bacteria 45.4 0.00441   NR MCI7634034.1 37628 g40028 i0 79.2 0.286852589641434 24 5 28.7 0 17 88 330 353 MCI7634034.1 hypothetical protein [Mollicutes bacterium] diamond 72 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31275032 31275032 PRJNA315399_P_NODE_194575_length_185_cov_4.398649_g194127_i0 PRJNA315399 194575 185 4.398649 8.13750065 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 47.8 2.19e-4   NR MCI9652881.1 2053494 g194127 i0 95.7 0.372972972972973 23 1 37.3 0 13 81 27 49 MCI9652881.1 RluA family pseudouridine synthase [Acholeplasmatales bacterium] diamond 69 47.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
31496703 31496703 PRJNA315399_P_NODE_336396_length_173_cov_5.161765_g335948_i0 PRJNA315399 336396 173 5.161765 8.92985345 Mollicutes bacterium 37628 Bacteria Bacteria 44.3 0.00289   NR HHT38119.1 37628 g335948 i0 66.7 0.936416184971098 27 9 46.8 0 91 11 6 32 HHT38119.1 hypothetical protein [Mollicutes bacterium] diamond 162 44.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31545774 31545774 PRJNA315399_P_NODE_53736_length_233_cov_4.897959_g53288_i0 PRJNA315399 53736 233 4.897959 11.41224447 FCB group 1783270 Bacteria Bacteria 42.4 0.0214   NR WP_282460058.1 2094 g53288 i0 64.5 0.798283261802575 31 11 39.9 0 30 122 1 31 WP_282460058.1 DUF6291 domain-containing protein, partial [Mycoplasmopsis arginini] diamond 186 42.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32414126 32414126 PRJNA315399_S_NODE_27539_length_254_cov_6.285714_g27338_i0 PRJNA315399 27539 254 6.285714 15.96571356 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 89.7 1.24e-18   NR HEY8364887.1 2862752 g27338 i0 69.5 0.696850393700787 59 18 69.7 0 13 189 230 288 HEY8364887.1 hypothetical protein [Haloplasmataceae bacterium] diamond 177 89.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae 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);;