RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA832865" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA832865 · 12 ✖

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
822142 822142 PRJNA832865_S_NODE_103641_length_245_cov_1.046512_g98555_i0 PRJNA832865 103641 245 1.046512 2.5639544 Spiroplasma endosymbiont of Antitype chi 3066308 Bacteria Bacteria 56.5 0.002   NTclustered gi|2706542423|emb|OZ026467.1| 3066308 g98555 i0 96.97 0.13469387755102 33 1 13 0 79 111 1680217 1680249 Spiroplasma endosymbiont of Antitype chi isolate 54779 genome assembly, chromosome: 1 blastn 33 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Antitype chi
823648 823648 PRJNA832865_S_NODE_72621_length_289_cov_1.782407_g67535_i0 PRJNA832865 72621 289 1.782407 5.15115623 Mycoplasmopsis glycophila 171285 Bacteria Bacteria 52.8 0.027   NTclustered gi|1563800497|emb|LR215024.1| 171285 g67535 i0 100 0.0968858131487889 28 0 10 0 103 130 675724 675751 Mycoplasma glycophilum strain NCTC10194 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis glycophila
2099513 2099513 PRJNA832865_S_NODE_99562_length_248_cov_0.880000_g94476_i0 PRJNA832865 99562 248 0.88 2.1824 Malacoplasma iowae 2116 Bacteria Bacteria 52.8 0.022   NTclustered gi|2624197841|gb|CP129198.1| 2116 g94476 i0 100 0.451612903225806 28 0 11 0 78 105 1214370 1214343 Malacoplasma iowae strain M818 chromosome, complete genome blastn 112 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
4650525 4650525 PRJNA832865_S_NODE_107204_length_243_cov_0.905882_g102118_i0 PRJNA832865 107204 243 0.905882 2.20129326 Candidatus Tyloplasma litorale 3132031 Bacteria Bacteria 54.7 0.006   NTclustered gi|2413215879|dbj|AP027078.1| 3132031 g102118 i0 100 0.119341563786008 29 0 12 0 16 44 233209 233181 MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Candidatus Hepatoplasmataceae Candidatus Tyloplasma Candidatus Tyloplasma litorale
11027298 11027298 PRJNA832865_S_NODE_66429_length_303_cov_2.343478_g61343_i0 PRJNA832865 66429 303 2.343478 7.10073834 Mycoplasma sp. NEAQ87857 2683967 Bacteria Bacteria 54.7 0.008   NTclustered gi|1787253220|gb|CP045542.1| 2683967 g61343 i0 100 0.392739273927393 29 0 10 0 228 256 97844 97872 Mycoplasma sp. NEAQ87857 chromosome, complete genome blastn 119 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. NEAQ87857
11432448 11432448 PRJNA832865_S_NODE_75449_length_283_cov_1.566667_g70363_i0 PRJNA832865 75449 283 1.566667 4.43366761 Mycoplasmopsis 2767358 Bacteria Bacteria 518 2.14e-142   NTclustered gi|2111402438|gb|CP068733.1| 28903 g70363 i0 99.647 188.031802120141 283 1 100 0 1 283 725610 725328 Mycoplasmopsis bovis strain J81 chromosome, complete genome blastn 53213 518 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
16126284 16126284 PRJNA832865_S_NODE_78593_length_277_cov_1.357843_g73507_i0 PRJNA832865 78593 277 1.357843 3.76122511 Mycoplasmopsis agassizii 33922 Bacteria Bacteria 65.8 3.27e-6   NTclustered gi|2789550291|gb|CP166874.1| 33922 g73507 i0 97.368 2.05776173285199 38 1 14 0 224 261 873172 873135 Mycoplasmopsis agassizii strain 55P4 chromosome, complete genome blastn 570 65.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis agassizii
21225346 21225346 PRJNA832865_S_NODE_50977_length_354_cov_2.213523_g45891_i0 PRJNA832865 50977 354 2.213523 7.83587142 Mycoplasmopsis bovis 28903 Bacteria Bacteria 52.8 0.033   NTclustered gi|1951506854|gb|CP058507.1| 28903 g45891 i0 100 0.0790960451977401 28 0 8 0 189 216 198808 198781 Mycoplasmopsis bovis strain Mb116 chromosome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
22500780 22500780 PRJNA832865_S_NODE_99038_length_248_cov_0.880000_g93952_i0 PRJNA832865 99038 248 0.88 2.1824 Mesomycoplasma moatsii 171287 Bacteria Bacteria 54.7 0.006   NTclustered gi|2860287645|gb|CP174166.1| 171287 g93952 i0 88.889 0.362903225806452 45 3 18 1 98 142 416243 416201 Mesomycoplasma moatsii strain MK 405 chromosome, complete genome blastn 90 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma moatsii
23774588 23774588 PRJNA832865_S_NODE_109579_length_242_cov_0.875740_g104493_i0 PRJNA832865 109579 242 0.87574 2.1192908 Mycoplasmoides gallisepticum 2096 Bacteria Bacteria 54.7 0.006   NTclustered gi|1752988855|gb|CP044225.1| 2096 g104493 i0 100 0.119834710743802 29 0 12 0 63 91 561050 561078 Mycoplasmoides gallisepticum strain ts-11 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides gallisepticum
25049300 25049300 PRJNA832865_S_NODE_3620_length_2752_cov_33.733483_g2562_i0 PRJNA832865 3620 2752 33.733483 928.34545216 Candidatus Phytoplasma cynodontis 72990 Bacteria Bacteria 56.5 0.022   NTclustered gi|2511947619|gb|CP126225.1| 72990 g2562 i0 100 0.0109011627906977 30 0 1 0 2501 2530 434995 435024 MAG: Candidatus Phytoplasma cynodontis isolate GY2015 chromosome, complete genome blastn 30 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma cynodontis
27465562 27465562 PRJNA832865_S_NODE_71763_length_291_cov_1.573394_g66677_i0 PRJNA832865 71763 291 1.573394 4.57857654 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 98.2 2.17e-21   NR HXN54441.1 2023991 g66677 i0 62.9 0.721649484536082 70 26 72.2 0 216 7 240 309 HXN54441.1 reverse transcriptase family protein [Mycoplasmatales bacterium] diamond 210 98.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium

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