RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1004255 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
26622832 26622832 PRJNA1004255_S_NODE_15141_length_167_cov_1.516129_g14933_i0 PRJNA1004255 15141 167 1.516129 2.53193543 Mycoplasma wenyonii 65123 Bacteria Bacteria 57.4 8.99e-8   NR WP_014850129.1 65123 g14933 i0 68.4 0.682634730538922 38 12 68.3 0 53 166 511 548 WP_014850129.1 RNB domain-containing ribonuclease [Mycoplasma wenyonii] diamond 114 57.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26812956 26812956 PRJNA1004255_S_NODE_5621_length_252_cov_5.272727_g5413_i0 PRJNA1004255 5621 252 5.272727 13.28727204 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 72 3.96e-13   NR WP_187149919.1 432608 g5413 i0 56.7 0.714285714285714 60 26 71.4 0 182 3 81 140 WP_187149919.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 180 72 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26876528 26876528 PRJNA1004255_S_NODE_5181_length_260_cov_2.382488_g4973_i0 PRJNA1004255 5181 260 2.382488 6.1944688 Mycoplasma wenyonii 65123 Bacteria Bacteria 43.5 0.0197   NR WP_112665295.1 65123 g4973 i0 60 0.403846153846154 35 14 40.4 0 100 204 7 41 WP_112665295.1 hypothetical protein [Mycoplasma wenyonii] diamond 105 43.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26907885 26907885 PRJNA1004255_S_NODE_1702_length_376_cov_4.480480_g1494_i0 PRJNA1004255 1702 376 4.48048 16.8466048 Mycoplasma wenyonii 65123 Bacteria Bacteria 164 5.799999999999998e-44   NR WP_112665122.1 65123 g1494 i0 95.2 0.670212765957447 84 4 67 0 374 123 921 1004 WP_112665122.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 252 164 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27121513 27121513 PRJNA1004255_S_NODE_15702_length_164_cov_1.942149_g15494_i0 PRJNA1004255 15702 164 1.942149 3.18512436 Mycoplasma 2093 Bacteria Bacteria 63.9 3.16e-10   NR WP_112665343.1 65123 g15494 i0 79.4 1.24390243902439 34 7 62.2 0 1 102 6 39 WP_112665343.1 DUF5385 family protein [Mycoplasma wenyonii] diamond 204 63.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27319088 27319088 PRJNA1004255_S_NODE_3263_length_304_cov_3.402299_g3055_i0 PRJNA1004255 3263 304 3.402299 10.34298896 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 119 7.13e-29   NR WP_187150740.1 432608 g3055 i0 75.7 0.690789473684211 70 17 69.1 0 212 3 48 117 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 210 119 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27350800 27350800 PRJNA1004255_S_NODE_3783_length_289_cov_3.239837_g3575_i0 PRJNA1004255 3783 289 3.239837 9.36312893 Mycoplasma wenyonii 65123 Bacteria Bacteria 167 2.6499999999999997e-46   NR WP_112665000.1 65123 g3575 i0 88.4 0.986159169550173 95 11 98.6 0 3 287 199 293 WP_112665000.1 CHC2 zinc finger domain-containing protein [Mycoplasma wenyonii] diamond 285 167 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27476866 27476866 PRJNA1004255_S_NODE_9143_length_209_cov_1.379518_g8935_i0 PRJNA1004255 9143 209 1.379518 2.88319262 Mycoplasma wenyonii 65123 Bacteria Bacteria 111 2.34e-28   NR WP_146737519.1 65123 g8935 i0 98.2 0.818181818181818 57 1 81.8 0 173 3 1 57 WP_146737519.1 hypothetical protein [Mycoplasma wenyonii] diamond 171 111 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27634858 27634858 PRJNA1004255_S_NODE_8144_length_219_cov_4.875000_g7936_i0 PRJNA1004255 8144 219 4.875 10.67625 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 88.6 8.33e-19   NR WP_187150290.1 432608 g7936 i0 95.6 0.616438356164384 45 2 61.6 0 135 1 80 124 WP_187150290.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 135 88.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28076671 28076671 PRJNA1004255_S_NODE_3265_length_304_cov_2.521073_g3057_i0 PRJNA1004255 3265 304 2.521073 7.66406192 Mycoplasma wenyonii 65123 Bacteria Bacteria 70.1 1.5e-11   NR WP_146737539.1 65123 g3057 i0 48.3 0.878289473684211 89 46 87.8 0 37 303 37 125 WP_146737539.1 hypothetical protein [Mycoplasma wenyonii] diamond 267 70.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28108189 28108189 PRJNA1004255_S_NODE_3725_length_290_cov_8.165992_g3517_i0 PRJNA1004255 3725 290 8.165992 23.6813768 Mycoplasma wenyonii 65123 Bacteria Bacteria 99 7.37e-22   NR WP_112665726.1 65123 g3517 i0 80 0.827586206896552 80 16 82.8 0 3 242 378 457 WP_112665726.1 spermidine/putrescine ABC transporter substrate-binding protein, partial [Mycoplasma wenyonii] diamond 240 99 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28108190 28108190 PRJNA1004255_S_NODE_4085_length_282_cov_3.062762_g3877_i0 PRJNA1004255 4085 282 3.062762 8.63698884 Mycoplasma wenyonii 65123 Bacteria Bacteria 50.8 7.89e-5   NR RAO95282.1 65123 g3877 i0 96 0.265957446808511 25 1 26.6 0 76 2 1 25 RAO95282.1 helicase DnaB [Mycoplasma wenyonii] diamond 75 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28360808 28360808 PRJNA1004255_S_NODE_4046_length_283_cov_2.329167_g3838_i0 PRJNA1004255 4046 283 2.329167 6.59154261 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 134 5.43e-34   NR WP_187150752.1 432608 g3838 i0 98.7 0.80565371024735 76 1 80.6 0 278 51 1259 1334 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 228 134 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28929297 28929297 PRJNA1004255_S_NODE_16268_length_161_cov_2.788136_g16060_i0 PRJNA1004255 16268 161 2.788136 4.48889896 Mycoplasma wenyonii 65123 Bacteria Bacteria 76.6 5.59e-15   NR WP_146737518.1 65123 g16060 i0 100 0.745341614906832 40 0 74.5 0 3 122 78 117 WP_146737518.1 hypothetical protein, partial [Mycoplasma wenyonii] diamond 120 76.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29339858 29339858 PRJNA1004255_S_NODE_19049_length_150_cov_1.757009_g18841_i0 PRJNA1004255 19049 150 1.757009 2.6355135 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 55.1 4.46e-7   NR WP_187149882.1 432608 g18841 i0 71.7 1.06 53 11 98 1 148 2 147 199 WP_187149882.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 159 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29402864 29402864 PRJNA1004255_S_NODE_4449_length_274_cov_1.831169_g4241_i0 PRJNA1004255 4449 274 1.831169 5.01740306 Mycoplasma wenyonii 65123 Bacteria Bacteria 99 1.8e-23   NR WP_110555201.1 65123 g4241 i0 80.6 0.733576642335766 67 13 73.4 0 203 3 15 81 WP_110555201.1 nucleotide exchange factor GrpE [Mycoplasma wenyonii] diamond 201 99 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29402866 29402866 PRJNA1004255_S_NODE_7249_length_229_cov_4.537634_g7041_i0 PRJNA1004255 7249 229 4.537634 10.39118186 Mycoplasma wenyonii 65123 Bacteria Bacteria 117 6.61e-29   NR WP_112664928.1 65123 g7041 i0 80 0.91703056768559 70 14 91.7 0 224 15 284 353 WP_112664928.1 aldehyde dehydrogenase family protein [Mycoplasma wenyonii] diamond 210 117 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29434135 29434135 PRJNA1004255_S_NODE_13690_length_175_cov_2.136364_g13482_i0 PRJNA1004255 13690 175 2.136364 3.738637 Mycoplasma wenyonii 65123 Bacteria Bacteria 65.9 1.02e-10   NR WP_181454157.1 65123 g13482 i0 70 0.857142857142857 50 15 85.7 0 174 25 346 395 WP_181454157.1 ABC transporter permease, partial [Mycoplasma wenyonii] diamond 150 65.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29686745 29686745 PRJNA1004255_S_NODE_14710_length_169_cov_4.849206_g14502_i0 PRJNA1004255 14710 169 4.849206 8.19515814 Mycoplasma wenyonii 65123 Bacteria Bacteria 95.5 3.15e-21   NR WP_112665157.1 65123 g14502 i0 94.3 1.88165680473373 53 3 94.1 0 3 161 111 163 WP_112665157.1 CTP synthase [Mycoplasma wenyonii] diamond 318 95.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30128927 30128927 PRJNA1004255_S_NODE_4452_length_274_cov_1.393939_g4244_i0 PRJNA1004255 4452 274 1.393939 3.81939286 Mycoplasma wenyonii 65123 Bacteria Bacteria 93.2 9.21e-20   NR WP_112665778.1 65123 g4244 i0 81 0.635036496350365 58 11 63.5 0 174 1 361 418 WP_112665778.1 magnesium transporter [Mycoplasma wenyonii] diamond 174 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30413895 30413895 PRJNA1004255_S_NODE_9453_length_206_cov_1.846626_g9245_i0 PRJNA1004255 9453 206 1.846626 3.80404956 Mycoplasma wenyonii 65123 Bacteria Bacteria 50.8 3.1e-5   NR WP_146737514.1 65123 g9245 i0 45 0.87378640776699 60 33 87.4 0 206 27 273 332 WP_146737514.1 hypothetical protein [Mycoplasma wenyonii] diamond 180 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30508417 30508417 PRJNA1004255_S_NODE_12833_length_180_cov_2.401460_g12625_i0 PRJNA1004255 12833 180 2.40146 4.322628 Mycoplasma wenyonii 65123 Bacteria Bacteria 47.8 2.04e-4   NR WP_112665800.1 65123 g12625 i0 61.7 1 60 18 91.7 1 2 166 121 180 WP_112665800.1 hypothetical protein [Mycoplasma wenyonii] diamond 180 47.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30761260 30761260 PRJNA1004255_S_NODE_17794_length_154_cov_5.828829_g17586_i0 PRJNA1004255 17794 154 5.828829 8.97639666 Mycoplasma wenyonii 65123 Bacteria Bacteria 92.8 2.54e-20   NR WP_112664957.1 65123 g17586 i0 92 0.974025974025974 50 4 97.4 0 153 4 317 366 WP_112664957.1 DNA polymerase III subunit gamma/tau [Mycoplasma wenyonii] diamond 150 92.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31139925 31139925 PRJNA1004255_S_NODE_16115_length_162_cov_1.689076_g15907_i0 PRJNA1004255 16115 162 1.689076 2.73630312 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 68.6 1e-11   NR WP_187150740.1 432608 g15907 i0 71.2 0.962962962962963 52 15 96.3 0 162 7 293 344 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 156 68.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31930910 31930910 PRJNA1004255_S_NODE_12917_length_179_cov_7.882353_g12709_i0 PRJNA1004255 12917 179 7.882353 14.10941187 Mycoplasma ovis 171632 Bacteria Bacteria 82.8 5.34e-19   NR WP_024071294.1 171632 g12709 i0 88.9 1.50837988826816 45 5 75.4 0 1 135 44 88 WP_024071294.1 uS17 family ribosomal protein [Mycoplasma ovis] diamond 270 82.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
31994299 31994299 PRJNA1004255_S_NODE_1578_length_386_cov_6.008746_g1370_i0 PRJNA1004255 1578 386 6.008746 23.19375956 Mycoplasma wenyonii 65123 Bacteria Bacteria 147 4.55e-40   NR WP_112665806.1 65123 g1370 i0 84.5 0.652849740932642 84 13 65.3 0 135 386 3 86 WP_112665806.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii] diamond 252 147 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32057531 32057531 PRJNA1004255_S_NODE_10738_length_195_cov_2.967105_g10530_i0 PRJNA1004255 10738 195 2.967105 5.78585475 Mycoplasma wenyonii 65123 Bacteria Bacteria 106 4.21e-26   NR WP_112665349.1 65123 g10530 i0 100 0.815384615384615 53 0 81.5 0 1 159 2 54 WP_112665349.1 GTPase [Mycoplasma wenyonii] diamond 159 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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