RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA675042", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Mycoplasmatota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA675042 · 16 ✖

analysis 1

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
1921916 1921916 PRJNA675042_P_NODE_107782_length_251_cov_0.865169_g107332_i0 PRJNA675042 107782 251 0.865169 2.17157419 [Mycoplasma] phocae 142651 Bacteria Bacteria 54.7 0.006   NTclustered gi|1432057116|gb|CP029295.1| 142651 g107332 i0 100 0.115537848605578 29 0 12 0 67 95 133600 133572 [Mycoplasma] phocae strain 105 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma [Mycoplasma] phocae
1922651 1922651 PRJNA675042_P_NODE_174102_length_242_cov_0.881657_g173652_i0 PRJNA675042 174102 242 0.881657 2.13360994 Mesomycoplasma neurolyticum 2120 Bacteria Bacteria 52.8 0.022   NTclustered gi|1563683120|emb|LR214951.1| 2120 g173652 i0 100 0.115702479338843 28 0 12 0 160 187 146626 146599 Mycoplasma neurolyticum strain NCTC10166 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma neurolyticum
1923126 1923126 PRJNA675042_P_NODE_46202_length_331_cov_1.155039_g45752_i0 PRJNA675042 46202 331 1.155039 3.82317909 Mycoplasma sp. 1018B 2967302 Bacteria Bacteria 52.8 0.031   NTclustered gi|2282847479|gb|CP102084.1| 2967302 g45752 i0 100 0.0845921450151057 28 0 8 0 285 312 485370 485397 Mycoplasma sp. 1018B chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. 1018B
4996167 4996167 PRJNA675042_P_NODE_133464_length_247_cov_0.885057_g133014_i0 PRJNA675042 133464 247 0.885057 2.18609079 Mycoplasmopsis 2767358 Bacteria Bacteria 52.8 0.022   NTclustered gi|1441443143|gb|CP022589.1| 28903 g133014 i0 100 4.19433198380567 28 0 11 0 137 164 1002454 1002481 Mycoplasmopsis bovis strain NADC18 chromosome, complete genome blastn 1036 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
8299676 8299676 PRJNA675042_P_NODE_155807_length_244_cov_0.900585_g155357_i0 PRJNA675042 155807 244 0.900585 2.1974274 Candidatus Phytoplasma cynodontis 72990 Bacteria Bacteria 54.7 0.006   NTclustered gi|2511947619|gb|CP126225.1| 72990 g155357 i0 94.444 0.147540983606557 36 1 14 1 95 129 231386 231351 MAG: Candidatus Phytoplasma cynodontis isolate GY2015 chromosome, complete genome blastn 36 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma cynodontis
9574664 9574664 PRJNA675042_P_NODE_133968_length_247_cov_0.885057_g133518_i0 PRJNA675042 133968 247 0.885057 2.18609079 Acholeplasma hippikon 264636 Bacteria Bacteria 52.8 0.022   NTclustered gi|1563812122|emb|LR215050.1| 264636 g133518 i0 100 0.11336032388664 28 0 11 0 191 218 1355722 1355749 Acholeplasma hippikon strain NCTC10172 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma hippikon
10850149 10850149 PRJNA675042_P_NODE_135549_length_247_cov_0.885057_g135099_i0 PRJNA675042 135549 247 0.885057 2.18609079 Mycoplasmopsis lipophila 2117 Bacteria Bacteria 56.5 0.002   NTclustered gi|2860286954|gb|CP174165.1| 2117 g135099 i0 90.698 0.287449392712551 43 2 17 2 68 110 691909 691869 Mycoplasmopsis lipophila strain MaBy chromosome, complete genome blastn 71 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis lipophila
12126941 12126941 PRJNA675042_P_NODE_95530_length_263_cov_1.005263_g95080_i0 PRJNA675042 95530 263 1.005263 2.64384169 Spiroplasma endosymbiont of Polydrusus pterygomalis 3139327 Bacteria Bacteria 56.5 0.002   NTclustered gi|2719437842|emb|OZ034964.1| 3139327 g95080 i0 96.97 0.125475285171103 33 1 13 0 221 253 441823 441855 Spiroplasma endosymbiont of Polydrusus pterygomalis isolate f60024fe-efdc-4729-9a9f-f0b2b2b8ca61 genome assembly, chromosome: 1 blastn 33 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Polydrusus pterygomalis
12647022 12647022 PRJNA675042_P_NODE_10830_length_490_cov_0.899281_g10382_i0 PRJNA675042 10830 490 0.899281 4.4064769 Candidatus Phytoplasma 33926 Bacteria Bacteria 63.9 2.21e-5   NTclustered gi|2470326911|gb|CP120448.1| 85620 g10382 i0 88.889 0.220408163265306 54 2 10 4 127 176 544375 544322 MAG: Candidatus Phytoplasma asteris isolate QS2022 chromosome, complete genome blastn 108 63.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma asteris
13401096 13401096 PRJNA675042_P_NODE_47271_length_329_cov_1.058594_g46821_i0 PRJNA675042 47271 329 1.058594 3.48277426 Spiroplasma helicoides 216938 Bacteria Bacteria 54.7 0.009   NTclustered gi|1060138310|gb|CP017015.1| 216938 g46821 i0 94.286 0.106382978723404 35 2 11 0 213 247 52666 52632 Spiroplasma helicoides strain TABS-2 chromosome, complete genome blastn 35 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma helicoides
13401357 13401357 PRJNA675042_P_NODE_65731_length_299_cov_1.362832_g65281_i0 PRJNA675042 65731 299 1.362832 4.07486768 Metamycoplasma hyosynoviae 29559 Bacteria Bacteria 52.8 0.028   NTclustered gi|2273368105|gb|CP101129.1| 29559 g65281 i0 100 0.374581939799331 28 0 9 0 113 140 734036 734009 Metamycoplasma hyosynoviae strain B7 chromosome, complete genome blastn 112 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hyosynoviae
13401739 13401739 PRJNA675042_P_NODE_96571_length_262_cov_0.820106_g96121_i0 PRJNA675042 96571 262 0.820106 2.14867772 uncultured Mollicutes bacterium 220137 Bacteria Bacteria 54.7 0.007   NTclustered gi|2187163481|emb|OV788639.1| 220137 g96121 i0 94.286 0.133587786259542 35 2 13 0 77 111 1406304 1406270 uncultured Mollicutes bacterium isolate min17_bin64 genome assembly, chromosome: 1 blastn 35 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       uncultured Mollicutes bacterium
14676248 14676248 PRJNA675042_P_NODE_5532_length_608_cov_0.951402_g5100_i0 PRJNA675042 5532 608 0.951402 5.78452416 Spiroplasma citri 2133 Bacteria Bacteria 54.7 0.017   NTclustered gi|1809111150|gb|CP047428.1| 2133 g5100 i0 94.444 0.0592105263157895 36 1 6 1 407 442 661310 661276 Spiroplasma citri strain BLH-13 chromosome, complete genome blastn 36 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma citri
14676263 14676263 PRJNA675042_P_NODE_55992_length_314_cov_1.224066_g55542_i0 PRJNA675042 55992 314 1.224066 3.84356724 Candidatus Phytoplasma cynodontis 72990 Bacteria Bacteria 52.8 0.029   NTclustered gi|2511947619|gb|CP126225.1| 72990 g55542 i0 100 0.089171974522293 28 0 9 0 164 191 417853 417826 MAG: Candidatus Phytoplasma cynodontis isolate GY2015 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma cynodontis
15949316 15949316 PRJNA675042_P_NODE_178773_length_241_cov_0.916667_g178323_i0 PRJNA675042 178773 241 0.916667 2.20916747 Spiroplasma endosymbiont of Antitype chi 3066308 Bacteria Bacteria 52.8 0.022   NTclustered gi|2706542423|emb|OZ026467.1| 3066308 g178323 i0 100 0.348547717842324 28 0 12 0 110 137 349264 349291 Spiroplasma endosymbiont of Antitype chi isolate 54779 genome assembly, chromosome: 1 blastn 84 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Antitype chi
24872381 24872381 PRJNA675042_P_NODE_14500_length_449_cov_0.768617_g14050_i0 PRJNA675042 14500 449 0.768617 3.45109033 Mycoplasmopsis columbina 114881 Bacteria Bacteria 54.7 0.012   NTclustered gi|1563806405|emb|LR215041.1| 114881 g14050 i0 100 0.0645879732739421 29 0 6 0 281 309 762666 762638 Mycoplasma columbinum strain NCTC10178 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis columbina

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