RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA975724" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA975724 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
7324814 7324814 PRJNA975724_S_NODE_70126_length_262_cov_1.910053_g69945_i0 PRJNA975724 70126 262 1.910053 5.00433886 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 105 4.189999999999999e-24   NR WP_187150751.1 432608 g69945 i0 59 0.893129770992366 78 32 89.3 0 26 259 433 510 WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 234 105 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27689840 27689840 PRJNA975724_S_NODE_89724_length_242_cov_1.366864_g89543_i0 PRJNA975724 89724 242 1.366864 3.30781088 Mycoplasma wenyonii 65123 Bacteria Bacteria 143 7.82e-40   NR WP_014849821.1 65123 g89543 i0 93.3 1.8595041322314 75 5 93 0 242 18 221 295 WP_014849821.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Mycoplasma wenyonii] diamond 450 143 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28005391 28005391 PRJNA975724_S_NODE_68525_length_265_cov_1.203125_g68344_i0 PRJNA975724 68525 265 1.203125 3.18828125 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 95.1 1.92e-20   NR WP_187150752.1 432608 g68344 i0 61 0.871698113207547 77 30 87.2 0 31 261 714 790 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 231 95.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28478826 28478826 PRJNA975724_S_NODE_67886_length_266_cov_1.196891_g67705_i0 PRJNA975724 67886 266 1.196891 3.18373006 Mycoplasma ovis 171632 Bacteria Bacteria 131 2.51e-34   NR WP_024070817.1 171632 g67705 i0 71.9 1.00375939849624 89 24 99.2 1 264 1 74 162 WP_024070817.1 ATP-binding protein [Mycoplasma ovis] diamond 267 131 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
28857556 28857556 PRJNA975724_S_NODE_45228_length_307_cov_2.534188_g45047_i0 PRJNA975724 45228 307 2.534188 7.77995716 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 82.8 6.53e-16   NR WP_187150751.1 432608 g45047 i0 62.7 0.576547231270358 59 22 57.7 0 5 181 415 473 WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 177 82.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28920654 28920654 PRJNA975724_S_NODE_75868_length_254_cov_1.751381_g75687_i0 PRJNA975724 75868 254 1.751381 4.44850774 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 124 6.92e-32   NR WP_187150144.1 432608 g75687 i0 100 0.755905511811024 64 0 75.6 0 254 63 42 105 WP_187150144.1 HAD hydrolase family protein [Candidatus Mycoplasma haematobovis] diamond 192 124 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28984262 28984262 PRJNA975724_S_NODE_68508_length_265_cov_1.203125_g68327_i0 PRJNA975724 68508 265 1.203125 3.18828125 Mycoplasma wenyonii 65123 Bacteria Bacteria 44.3 0.0132   NR WP_112665923.1 65123 g68327 i0 68.8 0.362264150943396 32 10 36.2 0 166 261 65 96 WP_112665923.1 hypothetical protein [Mycoplasma wenyonii] diamond 96 44.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29267943 29267943 PRJNA975724_S_NODE_64789_length_271_cov_1.166667_g64608_i0 PRJNA975724 64789 271 1.166667 3.16166757 Mycoplasma wenyonii 65123 Bacteria Bacteria 47.4 0.00103   NR WP_146737534.1 65123 g64608 i0 37.9 0.730627306273063 66 38 69.7 2 82 270 119 184 WP_146737534.1 hypothetical protein [Mycoplasma wenyonii] diamond 198 47.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29520701 29520701 PRJNA975724_S_NODE_59930_length_279_cov_1.121359_g59749_i0 PRJNA975724 59930 279 1.121359 3.12859161 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 170 6.42e-52   NR WP_245633525.1 432608 g59749 i0 100 0.989247311827957 92 0 98.9 0 277 2 47 138 WP_245633525.1 ribosome-recycling factor [Candidatus Mycoplasma haematobovis] diamond 276 170 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29804835 29804835 PRJNA975724_S_NODE_13051_length_426_cov_1.249292_g12870_i0 PRJNA975724 13051 426 1.249292 5.32198392 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 133 6.26e-35   NR WP_187149649.1 432608 g12870 i0 50.4 0.97887323943662 139 68 97.2 1 426 13 27 165 WP_187149649.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 417 133 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29868105 29868105 PRJNA975724_S_NODE_67691_length_266_cov_1.554404_g67510_i0 PRJNA975724 67691 266 1.554404 4.13471464 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 84 9.47e-17   NR WP_187150734.1 432608 g67510 i0 60.9 0.721804511278195 64 23 72.2 1 263 72 30 91 WP_187150734.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 192 84 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29931429 29931429 PRJNA975724_S_NODE_41191_length_317_cov_1.262295_g41010_i0 PRJNA975724 41191 317 1.262295 4.00147515 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 115 2.36e-29   NR WP_187150390.1 432608 g41010 i0 92.1 0.596214511041009 63 5 59.6 0 244 56 60 122 WP_187150390.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 189 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30437046 30437046 PRJNA975724_S_NODE_58693_length_281_cov_1.326923_g58512_i0 PRJNA975724 58693 281 1.326923 3.72865363 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 105 4.12e-26   NR WP_187150359.1 432608 g58512 i0 77.8 0.768683274021352 72 16 76.9 0 276 61 29 100 WP_187150359.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 216 105 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30657904 30657904 PRJNA975724_S_NODE_31953_length_342_cov_1.070632_g31772_i0 PRJNA975724 31953 342 1.070632 3.66156144 Mycoplasma wenyonii 65123 Bacteria Bacteria 93.2 8.79e-20   NR WP_112665339.1 65123 g31772 i0 100 0.385964912280702 44 0 38.6 0 222 91 250 293 WP_112665339.1 phosphatidate cytidylyltransferase [Mycoplasma wenyonii] diamond 132 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30689390 30689390 PRJNA975724_S_NODE_67213_length_267_cov_1.190722_g67032_i0 PRJNA975724 67213 267 1.190722 3.17922774 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 69.3 2.32e-11   NR WP_187150740.1 432608 g67032 i0 100 0.348314606741573 31 0 34.8 0 93 1 33 63 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 93 69.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30720998 30720998 PRJNA975724_S_NODE_49074_length_299_cov_1.703540_g48893_i0 PRJNA975724 49074 299 1.70354 5.0935846 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 85.9 1.2e-18   NR WP_187149648.1 432608 g48893 i0 47.5 0.993311036789298 99 51 99.3 1 297 1 33 130 WP_187149648.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 297 85.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31169442 31169442 PRJNA975724_S_NODE_50115_length_297_cov_1.375000_g49934_i0 PRJNA975724 50115 297 1.375 4.08375 Mycoplasma 2093 Bacteria Bacteria 102 5.96e-23   NR WP_014858110.1 141391 g49934 i0 52.6 2.95959595959596 97 46 98 0 5 295 4 100 WP_014858110.1 signal recognition particle receptor subunit alpha [Candidatus Mycoplasma haematolamae] diamond 879 103 0.990291262135922 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematolamae
31226517 31226517 PRJNA975724_S_NODE_78475_length_251_cov_1.056180_g78294_i0 PRJNA975724 78475 251 1.05618 2.6510118 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 49.3 2.07e-4   NR WP_187150740.1 432608 g78294 i0 57.5 0.47808764940239 40 17 47.8 0 124 5 1073 1112 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 120 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31448104 31448104 PRJNA975724_S_NODE_78356_length_251_cov_1.297753_g78175_i0 PRJNA975724 78356 251 1.297753 3.25736003 Mycoplasma wenyonii 65123 Bacteria Bacteria 158 9.02e-44   NR WP_112665559.1 65123 g78175 i0 89.2 0.99203187250996006 83 9 99.2 0 2 250 192 274 WP_112665559.1 type I restriction-modification system subunit M [Mycoplasma wenyonii] diamond 249 158 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31795805 31795805 PRJNA975724_S_NODE_90897_length_241_cov_1.375000_g90716_i0 PRJNA975724 90897 241 1.375 3.31375 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 140 4.379999999999999e-40   NR WP_187149711.1 432608 g90716 i0 100 0.896265560165975 72 0 89.6 0 1 216 20 91 WP_187149711.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 216 140 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32524012 32524012 PRJNA975724_S_NODE_63519_length_273_cov_1.155000_g63338_i0 PRJNA975724 63519 273 1.155 3.15315 Mycoplasma ovis 171632 Bacteria Bacteria 151 1.32e-44   NR WP_024071280.1 171632 g63338 i0 93.3 0.989010989010989 90 6 98.9 0 271 2 38 127 WP_024071280.1 30S ribosomal protein S13 [Mycoplasma ovis] diamond 270 151 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
32555667 32555667 PRJNA975724_S_NODE_54459_length_289_cov_1.069444_g54278_i0 PRJNA975724 54459 289 1.069444 3.09069316 Mycoplasma wenyonii 65123 Bacteria Bacteria 177 1.53e-54   NR WP_112665913.1 65123 g54278 i0 91.7 0.996539792387543 96 8 99.7 0 1 288 32 127 WP_112665913.1 hypothetical protein [Mycoplasma wenyonii] diamond 288 177 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32775747 32775747 PRJNA975724_S_NODE_70880_length_261_cov_1.819149_g70699_i0 PRJNA975724 70880 261 1.819149 4.74797889 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 112 1.47e-26   NR WP_187150740.1 432608 g70699 i0 74.3 0.804597701149425 70 18 80.5 0 220 11 1152 1221 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 210 112 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis

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