RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA798511", tax_kingdom = "Bacillati" 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

  • Bacillati · 12 ✖

bioproject 1

  • PRJNA798511 · 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
790864 790864 PRJNA798511_P_NODE_64661_length_303_cov_2.343478_g60395_i0 PRJNA798511 64661 303 2.343478 7.10073834 Mycoplasma sp. NEAQ87857 2683967 Bacteria Bacteria 54.7 0.008   NTclustered gi|1787253220|gb|CP045542.1| 2683967 g60395 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
2067108 2067108 PRJNA798511_P_NODE_96562_length_245_cov_1.046512_g92296_i0 PRJNA798511 96562 245 1.046512 2.5639544 Spiroplasma endosymbiont of Antitype chi 3066308 Bacteria Bacteria 56.5 0.002   NTclustered gi|2706542423|emb|OZ026467.1| 3066308 g92296 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
7169306 7169306 PRJNA798511_P_NODE_75186_length_277_cov_1.357843_g70920_i0 PRJNA798511 75186 277 1.357843 3.76122511 Mycoplasmopsis agassizii 33922 Bacteria Bacteria 65.8 3.27e-6   NTclustered gi|2789550291|gb|CP166874.1| 33922 g70920 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
7169639 7169639 PRJNA798511_P_NODE_99746_length_243_cov_0.905882_g95480_i0 PRJNA798511 99746 243 0.905882 2.20129326 Candidatus Tyloplasma litorale 3132031 Bacteria Bacteria 54.7 0.006   NTclustered gi|2413215879|dbj|AP027078.1| 3132031 g95480 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
10146268 10146268 PRJNA798511_P_NODE_72428_length_283_cov_1.566667_g68162_i0 PRJNA798511 72428 283 1.566667 4.43366761 Mycoplasmopsis 2767358 Bacteria Bacteria 518 2.14e-142   NTclustered gi|2111402438|gb|CP068733.1| 28903 g68162 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
10995241 10995241 PRJNA798511_P_NODE_92449_length_248_cov_0.880000_g88183_i0 PRJNA798511 92449 248 0.88 2.1824 Mesomycoplasma moatsii 171287 Bacteria Bacteria 54.7 0.006   NTclustered gi|2860287645|gb|CP174166.1| 171287 g88183 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
11421609 11421609 PRJNA798511_P_NODE_75649_length_276_cov_1.369458_g71383_i0 PRJNA798511 75649 276 1.369458 3.77970408 Spiroplasma 2132 Bacteria Bacteria 52.8 0.025   NTclustered gi|2208027045|gb|CP093047.1| 2138 g71383 i0 100 0.507246376811594 28 0 10 0 219 246 49205 49178 Spiroplasma poulsonii strain sHy chromosome, complete genome blastn 140 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma poulsonii
16093494 16093494 PRJNA798511_P_NODE_69953_length_289_cov_1.782407_g65687_i0 PRJNA798511 69953 289 1.782407 5.15115623 Mycoplasmopsis glycophila 171285 Bacteria Bacteria 52.8 0.027   NTclustered gi|1563800497|emb|LR215024.1| 171285 g65687 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
17367963 17367963 PRJNA798511_P_NODE_101934_length_242_cov_0.875740_g97668_i0 PRJNA798511 101934 242 0.87574 2.1192908 Mycoplasmoides gallisepticum 2096 Bacteria Bacteria 54.7 0.006   NTclustered gi|1752988855|gb|CP044225.1| 2096 g97668 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
23743215 23743215 PRJNA798511_P_NODE_4199_length_2697_cov_36.970655_g3158_i0 PRJNA798511 4199 2697 36.970655 997.09856535 Candidatus Phytoplasma cynodontis 72990 Bacteria Bacteria 56.5 0.022   NTclustered gi|2511947619|gb|CP126225.1| 72990 g3158 i0 100 0.0111234705228031 30 0 1 0 226 255 435024 434995 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
23744000 23744000 PRJNA798511_P_NODE_92959_length_248_cov_0.880000_g88693_i0 PRJNA798511 92959 248 0.88 2.1824 Malacoplasma iowae 2116 Bacteria Bacteria 52.8 0.022   NTclustered gi|2624197841|gb|CP129198.1| 2116 g88693 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
27938472 27938472 PRJNA798511_P_NODE_69205_length_291_cov_1.573394_g64939_i0 PRJNA798511 69205 291 1.573394 4.57857654 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 98.2 2.17e-21   NR HXN54441.1 2023991 g64939 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);;