RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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

  • PRJNA1111448 · 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
10420943 10420943 PRJNA1111448_S_NODE_120769_length_251_cov_0.865169_g119946_i0 PRJNA1111448 120769 251 0.865169 2.17157419 Mycoplasma wenyonii 65123 Bacteria Bacteria 161 7.32e-48   NR WP_112665557.1 65123 g119946 i0 100 0.99203187250996006 83 0 99.2 0 2 250 66 148 WP_112665557.1 purine-nucleoside phosphorylase [Mycoplasma wenyonii] diamond 249 161 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
21894361 21894361 PRJNA1111448_S_NODE_132498_length_244_cov_1.807018_g131675_i0 PRJNA1111448 132498 244 1.807018 4.40912392 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 55.1 9.52e-8   NR WP_187150749.1 432608 g131675 i0 57.9 0.467213114754098 38 16 46.7 0 115 2 7 44 WP_187150749.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 114 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26814781 26814781 PRJNA1111448_S_NODE_46261_length_357_cov_1.355634_g45438_i0 PRJNA1111448 46261 357 1.355634 4.83961338 Mycoplasma wenyonii 65123 Bacteria Bacteria 172 6.85e-47   NR WP_112665565.1 65123 g45438 i0 80 0.840336134453782 100 19 83.2 1 44 340 104 203 WP_112665565.1 ABC transporter permease [Mycoplasma wenyonii] diamond 300 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26909669 26909669 PRJNA1111448_S_NODE_137162_length_242_cov_0.911243_g136339_i0 PRJNA1111448 137162 242 0.911243 2.20520806 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 164 2.38e-48   NR WP_187150618.1 432608 g136339 i0 100 0.991735537190083 80 0 99.2 0 240 1 72 151 WP_187150618.1 ATP-binding cassette domain-containing protein [Candidatus Mycoplasma haematobovis] diamond 240 164 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27352544 27352544 PRJNA1111448_S_NODE_34583_length_392_cov_1.956113_g33760_i0 PRJNA1111448 34583 392 1.956113 7.66796296 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 98.2 8.220000000000001e-21   NR WP_187150752.1 432608 g33760 i0 60.9 0.704081632653061 92 35 70.4 1 307 32 250 340 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 276 98.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27731541 27731541 PRJNA1111448_S_NODE_82004_length_293_cov_1.645455_g81181_i0 PRJNA1111448 82004 293 1.645455 4.82118315 Mycoplasma wenyonii 65123 Bacteria Bacteria 125 9.599999999999999e-32   NR WP_181454157.1 65123 g81181 i0 78.2 0.798634812286689 78 17 79.9 0 292 59 192 269 WP_181454157.1 ABC transporter permease, partial [Mycoplasma wenyonii] diamond 234 125 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27857465 27857465 PRJNA1111448_S_NODE_65585_length_318_cov_0.942857_g64762_i0 PRJNA1111448 65585 318 0.942857 2.99828526 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 125 1.17e-30   NR WP_187150740.1 432608 g64762 i0 82.9 0.660377358490566 70 12 66 0 76 285 1152 1221 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 210 125 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27983778 27983778 PRJNA1111448_S_NODE_137565_length_242_cov_0.911243_g136742_i0 PRJNA1111448 137565 242 0.911243 2.20520806 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 159 8.86e-44   NR WP_187150101.1 432608 g136742 i0 100 0.991735537190083 80 0 99.2 0 241 2 472 551 WP_187150101.1 translation elongation factor 4 [Candidatus Mycoplasma haematobovis] diamond 240 159 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28331063 28331063 PRJNA1111448_S_NODE_32466_length_400_cov_1.360856_g31643_i0 PRJNA1111448 32466 400 1.360856 5.443424 Mycoplasma wenyonii 65123 Bacteria Bacteria 208 3.9799999999999995e-61   NR WP_112665399.1 65123 g31643 i0 99.1 0.81 108 1 81 0 63 386 527 634 WP_112665399.1 hypothetical protein [Mycoplasma wenyonii] diamond 324 208 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28362572 28362572 PRJNA1111448_S_NODE_129786_length_246_cov_0.890173_g128963_i0 PRJNA1111448 129786 246 0.890173 2.18982558 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 86.7 1.27e-17   NR WP_187150751.1 432608 g128963 i0 47.6 1.02439024390244 84 40 97.6 1 244 5 149 232 WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 252 86.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28394208 28394208 PRJNA1111448_S_NODE_139166_length_241_cov_0.916667_g138343_i0 PRJNA1111448 139166 241 0.916667 2.20916747 Mycoplasma wenyonii 65123 Bacteria Bacteria 169 1.29e-49   NR WP_112665102.1 65123 g138343 i0 98.7 0.983402489626556 79 1 98.3 0 3 239 74 152 WP_112665102.1 tRNA 2-thiouridine(34) synthase MnmA [Mycoplasma wenyonii] diamond 237 169 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28520671 28520671 PRJNA1111448_S_NODE_61507_length_325_cov_1.222222_g60684_i0 PRJNA1111448 61507 325 1.222222 3.9722215 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 97.1 1.27e-21   NR WP_187149649.1 432608 g60684 i0 46.7 0.969230769230769 105 56 96.9 0 3 317 45 149 WP_187149649.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 315 97.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28773052 28773052 PRJNA1111448_S_NODE_138067_length_241_cov_1.994048_g137244_i0 PRJNA1111448 138067 241 1.994048 4.80565568 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 112 9.93e-27   NR WP_187150751.1 432608 g137244 i0 64.6 0.983402489626556 79 28 98.3 0 2 238 424 502 WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 237 112 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28962837 28962837 PRJNA1111448_S_NODE_110748_length_260_cov_1.647059_g109925_i0 PRJNA1111448 110748 260 1.647059 4.2823534 Mycoplasma wenyonii 65123 Bacteria Bacteria 93.2 8.879999999999999e-23   NR WP_112665253.1 65123 g109925 i0 76.2 0.726923076923077 63 15 72.7 0 190 2 1 63 WP_112665253.1 hypothetical protein [Mycoplasma wenyonii] diamond 189 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29215417 29215417 PRJNA1111448_S_NODE_134569_length_243_cov_1.358824_g133746_i0 PRJNA1111448 134569 243 1.358824 3.30194232 Mycoplasma wenyonii 65123 Bacteria Bacteria 160 2.82e-48   NR WP_112665271.1 65123 g133746 i0 95 0.987654320987654 80 4 98.8 0 3 242 3 82 WP_112665271.1 hypothetical protein [Mycoplasma wenyonii] diamond 240 160 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29593707 29593707 PRJNA1111448_S_NODE_129230_length_246_cov_1.335260_g128407_i0 PRJNA1111448 129230 246 1.33526 3.2847396 Mycoplasma wenyonii 65123 Bacteria Bacteria 102 2.6e-25   NR WP_148268015.1 65123 g128407 i0 79.7 0.719512195121951 59 12 72 0 198 22 104 162 WP_148268015.1 hypothetical protein [Mycoplasma wenyonii] diamond 177 102 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30162385 30162385 PRJNA1111448_S_NODE_85272_length_289_cov_1.402778_g84449_i0 PRJNA1111448 85272 289 1.402778 4.05402842 Mycoplasma wenyonii 65123 Bacteria Bacteria 192 5.19e-58   NR RAO95376.1 65123 g84449 i0 99 1.99307958477509 96 1 99.7 0 1 288 113 208 RAO95376.1 tyrosine--tRNA ligase [Mycoplasma wenyonii] diamond 576 192 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30447146 30447146 PRJNA1111448_S_NODE_97893_length_274_cov_1.149254_g97070_i0 PRJNA1111448 97893 274 1.149254 3.14895596 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 162 1.42e-45   NR WP_187150165.1 432608 g97070 i0 97.7 0.941605839416058 86 2 94.2 0 260 3 319 404 WP_187150165.1 TrkH family potassium uptake protein [Candidatus Mycoplasma haematobovis] diamond 258 162 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30478680 30478680 PRJNA1111448_S_NODE_124673_length_249_cov_0.875000_g123850_i0 PRJNA1111448 124673 249 0.875 2.17875 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 87.8 1.5e-18   NR WP_187149649.1 432608 g123850 i0 51.9 0.975903614457831 81 39 97.6 0 244 2 2 82 WP_187149649.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 243 87.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30699630 30699630 PRJNA1111448_S_NODE_126034_length_248_cov_0.880000_g125211_i0 PRJNA1111448 126034 248 0.88 2.1824 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 156 2.17e-45   NR WP_187150242.1 432608 g125211 i0 97.6 0.991935483870968 82 2 99.2 0 248 3 16 97 WP_187150242.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 246 156 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30785705 30785705 PRJNA1111448_S_NODE_78514_length_298_cov_1.324444_g77691_i0 PRJNA1111448 78514 298 1.324444 3.94684312 Mycoplasma 2093 Bacteria Bacteria 103 1.6000000000000002e-23   NR WP_112665132.1 65123 g77691 i0 89.7 1.17785234899329 58 6 58.4 0 73 246 43 100 WP_112665132.1 MFS transporter [Mycoplasma wenyonii] diamond 351 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31110287 31110287 PRJNA1111448_S_NODE_107895_length_263_cov_1.526316_g107072_i0 PRJNA1111448 107895 263 1.526316 4.01421108 Mycoplasma wenyonii 65123 Bacteria Bacteria 102 6.57e-23   NR WP_112664977.1 65123 g107072 i0 94.3 0.604562737642586 53 3 60.5 0 261 103 622 674 WP_112664977.1 cysteine peptidase family C39 domain-containing protein [Mycoplasma wenyonii] diamond 159 102 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31141695 31141695 PRJNA1111448_S_NODE_103215_length_268_cov_1.405128_g102392_i0 PRJNA1111448 103215 268 1.405128 3.76574304 Mycoplasma ovis 171632 Bacteria Bacteria 78.6 1.21e-15   NR WP_024071079.1 171632 g102392 i0 67.3 0.548507462686567 49 16 54.9 0 5 151 72 120 WP_024071079.1 hypothetical protein [Mycoplasma ovis] diamond 147 78.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
31204833 31204833 PRJNA1111448_S_NODE_71735_length_308_cov_0.982979_g70912_i0 PRJNA1111448 71735 308 0.982979 3.02757532 Mycoplasma wenyonii 65123 Bacteria Bacteria 188 3.06e-54   NR WP_112664957.1 65123 g70912 i0 96.1 0.993506493506494 102 4 99.4 0 307 2 262 363 WP_112664957.1 DNA polymerase III subunit gamma/tau [Mycoplasma wenyonii] diamond 306 188 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31901127 31901127 PRJNA1111448_S_NODE_125097_length_248_cov_1.782857_g124274_i0 PRJNA1111448 125097 248 1.782857 4.42148536 Mycoplasma wenyonii 65123 Bacteria Bacteria 79 1.19e-15   NR WP_112665347.1 65123 g124274 i0 100 0.435483870967742 36 0 43.5 0 137 30 199 234 WP_112665347.1 hypothetical protein [Mycoplasma wenyonii] diamond 108 79 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32565869 32565869 PRJNA1111448_S_NODE_134499_length_243_cov_1.523529_g133676_i0 PRJNA1111448 134499 243 1.523529 3.70217547 Mycoplasma wenyonii 65123 Bacteria Bacteria 77.4 8.67e-15   NR WP_146737518.1 65123 g133676 i0 95.2 0.518518518518518 42 2 51.9 0 143 18 47 88 WP_146737518.1 hypothetical protein, partial [Mycoplasma wenyonii] diamond 126 77.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32817454 32817454 PRJNA1111448_S_NODE_143100_length_227_cov_2.500000_g142277_i0 PRJNA1111448 143100 227 2.5 5.675 Mycoplasma wenyonii 65123 Bacteria Bacteria 115 6.35e-31   NR WP_112665179.1 65123 g142277 i0 100 0.740088105726872 56 0 74 0 170 3 32 87 WP_112665179.1 NAD(P)H-dependent oxidoreductase [Mycoplasma wenyonii] diamond 168 115 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);;