RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA980839" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA980839 · 32 ✖

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
960516 960516 PRJNA980839_P_NODE_89381_length_390_cov_1.457413_g85597_i0 PRJNA980839 89381 390 1.457413 5.6839107 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 721 0   NTclustered gi|307624329|gb|CP001995.1| 637387 g85597 i0 100 4.28205128205128 390 0 100 0 1 390 205293 204904 Mycoplasma fermentans JER, complete genome blastn 1670 721 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
2545518 2545518 PRJNA980839_P_NODE_138482_length_299_cov_1.575221_g134698_i0 PRJNA980839 138482 299 1.575221 4.70991079 Metamycoplasmataceae 2895623 Bacteria Bacteria 553 6.25e-153   NTclustered gi|1563788636|emb|LR214955.1| 2115 g134698 i0 100 5 299 0 100 0 1 299 291789 292087 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 1495 553 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
2546052 2546052 PRJNA980839_P_NODE_35602_length_812_cov_1.987821_g32130_i0 PRJNA980839 35602 812 1.987821 16.14110652 Metamycoplasmataceae 2895623 Bacteria Bacteria 1458 0   NTclustered gi|1563790706|emb|LR214966.1| 2115 g32130 i0 99.138 31.6366995073892 812 3 100 2 1 812 43062 42255 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 12 blastn 25689 1463 0.996582365003418 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
3822088 3822088 PRJNA980839_P_NODE_194663_length_252_cov_2.357542_g190879_i0 PRJNA980839 194663 252 2.357542 5.94100584 Metamycoplasmataceae 2895623 Bacteria Bacteria 466 6.89e-127   NTclustered gi|1563788636|emb|LR214955.1| 2115 g190879 i0 100 9.0515873015873 252 0 100 0 1 252 431136 431387 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 2281 466 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
5098406 5098406 PRJNA980839_P_NODE_186104_length_258_cov_2.043243_g182320_i0 PRJNA980839 186104 258 2.043243 5.27156694 Metamycoplasmataceae 2895623 Bacteria Bacteria 477 3.2699999999999985e-130   NTclustered gi|1563788636|emb|LR214955.1| 2115 g182320 i0 100 5 258 0 100 0 1 258 432859 432602 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 1290 477 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
6373776 6373776 PRJNA980839_P_NODE_117085_length_329_cov_1.851562_g113301_i0 PRJNA980839 117085 329 1.851562 6.09163898 Metamycoplasmataceae 2895623 Bacteria Bacteria 597 3.169999999999999e-166   NTclustered gi|1563790706|emb|LR214966.1| 2115 g113301 i0 99.392 5.63525835866261 329 2 100 0 1 329 33369 33697 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 12 blastn 1854 597 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
7647858 7647858 PRJNA980839_P_NODE_134806_length_303_cov_7.295652_g131022_i0 PRJNA980839 134806 303 7.295652 22.10582556 Metamycoplasmataceae 2895623 Bacteria Bacteria 549 8.209999999999997e-152   NTclustered gi|209552648|gb|FJ226561.1| 2115 g131022 i0 99.34 170.049504950495 303 2 100 0 1 303 1447 1145 Mycoplasma fermentans strain PG-18 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence blastn 51525 549 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
7647977 7647977 PRJNA980839_P_NODE_158746_length_279_cov_2.402913_g154962_i0 PRJNA980839 158746 279 2.402913 6.70412727 Metamycoplasmataceae 2895623 Bacteria Bacteria 510 3.5299999999999996e-140   NTclustered gi|1563788636|emb|LR214955.1| 2115 g154962 i0 99.642 5 279 1 100 0 1 279 434332 434054 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 1395 510 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
7648100 7648100 PRJNA980839_P_NODE_183726_length_260_cov_1.572193_g179942_i0 PRJNA980839 183726 260 1.572193 4.0877018 Metamycoplasmataceae 2895623 Bacteria Bacteria 475 1.1899999999999999e-129   NTclustered gi|1563788636|emb|LR214955.1| 2115 g179942 i0 99.615 5.92307692307692 260 1 100 0 1 260 128129 128388 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 1540 475 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
7648714 7648714 PRJNA980839_P_NODE_89806_length_388_cov_3.031746_g86022_i0 PRJNA980839 89806 388 3.031746 11.76317448 Metamycoplasmataceae 2895623 Bacteria Bacteria 695 0   NTclustered gi|1563788636|emb|LR214955.1| 2115 g86022 i0 98.969 5 388 4 100 0 1 388 107811 107424 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 1940 701 0.991440798858773 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
8922567 8922567 PRJNA980839_P_NODE_103407_length_355_cov_1.443262_g99623_i0 PRJNA980839 103407 355 1.443262 5.1235801 Mycoplasmopsis 2767358 Bacteria Bacteria 586 7.449999999999997e-163   NTclustered gi|2627174|dbj|D64083.1| 2115 g99623 i0 99.688 16.3605633802817 320 1 100 0 36 355 1215 896 Mycoplasma fermentans mRNA for M161Ag, complete cds blastn 5808 586 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
8922837 8922837 PRJNA980839_P_NODE_151787_length_285_cov_2.250000_g148003_i0 PRJNA980839 151787 285 2.25 6.4125 Mesomycoplasma 2923352 Bacteria Bacteria 527 3.59e-145   NTclustered gi|1720621726|gb|CP035041.1| 2100 g148003 i0 100 16.1263157894737 285 0 100 0 1 285 776672 776388 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4596 527 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8923145 8923145 PRJNA980839_P_NODE_217687_length_246_cov_0.890173_g213903_i0 PRJNA980839 217687 246 0.890173 2.18982558 Mesomycoplasma 2923352 Bacteria Bacteria 449 6.74e-122   NTclustered gi|2713084492|gb|CP150431.1| 2100 g213903 i0 99.593 16 246 1 100 0 1 246 648405 648160 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3936 449 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8923159 8923159 PRJNA980839_P_NODE_222607_length_245_cov_0.895349_g218823_i0 PRJNA980839 222607 245 0.895349 2.19360505 Metamycoplasmataceae 2895623 Bacteria Bacteria 448 2.41e-121   NTclustered gi|1563790706|emb|LR214966.1| 2115 g218823 i0 99.592 89.4 245 1 100 0 1 245 48414 48658 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 12 blastn 21903 448 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
8923181 8923181 PRJNA980839_P_NODE_226227_length_244_cov_0.900585_g222443_i0 PRJNA980839 226227 244 0.900585 2.1974274 Metamycoplasmataceae 2895623 Bacteria Bacteria 449 6.68e-122   NTclustered gi|1563790706|emb|LR214966.1| 2115 g222443 i0 100 4.97950819672131 243 0 99 0 2 244 38979 38737 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 12 blastn 1215 449 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
11160697 11160697 PRJNA980839_P_NODE_143209_length_293_cov_10.609091_g139425_i0 PRJNA980839 143209 293 10.609091 31.08463663 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 514 2.88e-141   NTclustered gi|2620084710|gb|CP138194.1| 2231116 g139425 i0 98.955 99.7167235494881 287 3 98 0 1 287 162838 162552 MAG: Mycoplasmatota bacterium isolate Ac_bin3.5 chromosome, complete genome blastn 29217 514 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
11473947 11473947 PRJNA980839_P_NODE_207049_length_249_cov_0.875000_g203265_i0 PRJNA980839 207049 249 0.875 2.17875 Metamycoplasmataceae 2895623 Bacteria Bacteria 460 3.16e-125   NTclustered gi|1563788636|emb|LR214955.1| 2115 g203265 i0 100 17.1646586345382 249 0 100 0 1 249 435509 435261 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 4274 460 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
11474010 11474010 PRJNA980839_P_NODE_223549_length_244_cov_2.450292_g219765_i0 PRJNA980839 223549 244 2.450292 5.97871248 Metamycoplasmataceae 2895623 Bacteria Bacteria 390 4.11e-104   NTclustered gi|1563790593|emb|LR214965.1| 2115 g219765 i0 95.492 14.233606557377 244 11 100 0 1 244 40456 40213 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 11 blastn 3473 390 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
12749351 12749351 PRJNA980839_P_NODE_187970_length_257_cov_1.581522_g184186_i0 PRJNA980839 187970 257 1.581522 4.06451154 Metamycoplasmataceae 2895623 Bacteria Bacteria 472 1.51e-128   NTclustered gi|1563788636|emb|LR214955.1| 2115 g184186 i0 100 8.43190661478599 255 0 99 0 1 255 433669 433415 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 2167 472 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
14985008 14985008 PRJNA980839_P_NODE_134852_length_303_cov_3.221739_g131068_i0 PRJNA980839 134852 303 3.221739 9.76186917 Mycoplasma sp. 2108 Bacteria Bacteria 555 1.7599999999999995e-153   NTclustered gi|407350|dbj|D17585.1|MYCOTC 2108 g131068 i0 99.67 6.99009900990099 303 1 100 0 1 303 433 131 Mycoplasma sp. otc gene for ornithine transcarbamylase, partial cds blastn 2118 555 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
15297883 15297883 PRJNA980839_P_NODE_168312_length_272_cov_1.055276_g164528_i0 PRJNA980839 168312 272 1.055276 2.87035072 Metamycoplasmataceae 2895623 Bacteria Bacteria 503 5.729999999999998e-138   NTclustered gi|1563788636|emb|LR214955.1| 2115 g164528 i0 100 10.3419117647059 272 0 100 0 1 272 107139 107410 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 2813 503 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
16572635 16572635 PRJNA980839_P_NODE_183233_length_260_cov_2.133690_g179449_i0 PRJNA980839 183233 260 2.13369 5.547594 Mesomycoplasma 2923352 Bacteria Bacteria 481 2.55e-131   NTclustered gi|1720621726|gb|CP035041.1| 2100 g179449 i0 100 22.6423076923077 260 0 100 0 1 260 361715 361456 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 5887 481 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19120979 19120979 PRJNA980839_P_NODE_100335_length_361_cov_2.645833_g96551_i0 PRJNA980839 100335 361 2.645833 9.55145713 Mesomycoplasma 2923352 Bacteria Bacteria 667 0   NTclustered gi|2713084492|gb|CP150431.1| 2100 g96551 i0 100 14.9916897506925 361 0 100 0 1 361 672285 671925 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 5412 667 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21672354 21672354 PRJNA980839_P_NODE_164837_length_274_cov_2.248756_g161053_i0 PRJNA980839 164837 274 2.248756 6.16159144 Mesomycoplasma 2923352 Bacteria Bacteria 507 4.47e-139   NTclustered gi|1720621726|gb|CP035041.1| 2100 g161053 i0 100 15.014598540146 274 0 100 0 1 274 643679 643406 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4114 507 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
22947748 22947748 PRJNA980839_P_NODE_176138_length_265_cov_2.817708_g172354_i0 PRJNA980839 176138 265 2.817708 7.4669262 Metamycoplasmataceae 2895623 Bacteria Bacteria 451 2.04e-122   NTclustered gi|1563790229|emb|LR214963.1| 2115 g172354 i0 97.368 5.0188679245283 266 6 100 1 1 265 164852 165117 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 9 blastn 1330 451 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
22947937 22947937 PRJNA980839_P_NODE_221438_length_245_cov_0.895349_g217654_i0 PRJNA980839 221438 245 0.895349 2.19360505 Metamycoplasmataceae 2895623 Bacteria Bacteria 436 5.229999999999999e-118   NTclustered gi|1563790593|emb|LR214965.1| 2115 g217654 i0 98.776 46.1918367346939 245 3 100 0 1 245 42503 42259 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 11 blastn 11317 436 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
22947939 22947939 PRJNA980839_P_NODE_221778_length_245_cov_0.895349_g217994_i0 PRJNA980839 221778 245 0.895349 2.19360505 Mesomycoplasma 2923352 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2713084492|gb|CP150431.1| 2100 g217994 i0 100 15 245 0 100 0 1 245 571902 572146 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3675 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
25496452 25496452 PRJNA980839_P_NODE_165100_length_274_cov_1.666667_g161316_i0 PRJNA980839 165100 274 1.666667 4.56666758 Metamycoplasmataceae 2895623 Bacteria Bacteria 507 4.47e-139   NTclustered gi|1563790593|emb|LR214965.1| 2115 g161316 i0 100 6.0036496350365 274 0 100 0 1 274 41080 40807 Mycoplasma fermentans strain NCTC10117 genome assembly, plasmid: 11 blastn 1645 507 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
27026230 27026230 PRJNA980839_P_NODE_218102_length_246_cov_0.890173_g214318_i0 PRJNA980839 218102 246 0.890173 2.18982558 Mycoplasmopsis arginini 2094 Bacteria Bacteria 100 1.18e-25   NR WP_369124529.1 2094 g214318 i0 92.5 0.646341463414634 53 4 64.6 0 245 87 45 97 WP_369124529.1 helix-turn-helix domain-containing protein [Mycoplasmopsis arginini] diamond 159 100 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29016135 29016135 PRJNA980839_P_NODE_231448_length_243_cov_0.876471_g227664_i0 PRJNA980839 231448 243 0.876471 2.12982453 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 46.6 0.00164   NR MBR4495755.1 2053494 g227664 i0 79.2 0.296296296296296 24 5 29.6 0 243 172 396 419 MBR4495755.1 hypothetical protein [Acholeplasmatales bacterium] diamond 72 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
29363182 29363182 PRJNA980839_P_NODE_198569_length_251_cov_0.865169_g194785_i0 PRJNA980839 198569 251 0.865169 2.17157419 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 122 2.66e-30   NR WP_122530570.1 2115 g194785 i0 100 1.50597609561753 63 0 75.3 0 249 61 510 572 WP_122530570.1 hypothetical protein [Mycoplasmopsis fermentans] diamond 378 122 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
30626402 30626402 PRJNA980839_P_NODE_203173_length_250_cov_0.870056_g199389_i0 PRJNA980839 203173 250 0.870056 2.17514 Spiroplasma monobiae 2136 Bacteria Bacteria 161 3.2899999999999993e-46   NR WP_101780827.1 2136 g199389 i0 100 0.996 83 0 99.6 0 2 250 240 322 WP_101780827.1 DNA cytosine methyltransferase [Spiroplasma monobiae] diamond 249 161 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma monobiae

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