RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA879067", 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 · 24 ✖

tax_kingdom 1

  • Bacillati · 24 ✖

bioproject 1

  • PRJNA879067 · 24 ✖

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
855365 855365 PRJNA879067_P_NODE_50621_length_519_cov_14.668161_g47139_i0 PRJNA879067 50621 519 14.668161 76.12775559 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 902 0   NTclustered gi|1563796921|emb|LR215008.1| 2107 g47139 i0 100 7.15414258188825 488 0 94 0 32 519 683379 682892 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 3713 902 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
2129281 2129281 PRJNA879067_P_NODE_11942_length_1408_cov_28.229213_g9611_i0 PRJNA879067 11942 1408 28.229213 397.46731904 Spiroplasma kunkelii 47834 Bacteria Bacteria 54.7 0.04   NTclustered gi|922842379|gb|CP010899.1| 273035 g9611 i0 87.755 0.0348011363636364 49 2 3 4 1037 1083 990159 990205 Spiroplasma kunkelii CR2-3x, complete genome blastn 49 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma kunkelii
3407327 3407327 PRJNA879067_P_NODE_9543_length_1604_cov_10.717831_g7493_i0 PRJNA879067 9543 1604 10.717831 171.91400924 Mycoplasmopsis bovis 28903 Bacteria Bacteria 56.5 0.013   NTclustered gi|1951472368|gb|CP058456.1| 28903 g7493 i0 94.595 0.0230673316708229 37 0 2 2 676 711 204897 204932 Mycoplasmopsis bovis strain Mb51 chromosome blastn 37 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
3791104 3791104 PRJNA879067_P_NODE_72183_length_376_cov_2.838284_g68698_i0 PRJNA879067 72183 376 2.838284 10.67194784 Mesomycoplasma 2923352 Bacteria Bacteria 651 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g68698 i0 100 15.0585106382979 352 0 94 0 1 352 649362 649011 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 5662 651 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
7233579 7233579 PRJNA879067_P_NODE_52646_length_503_cov_3.334884_g49162_i0 PRJNA879067 52646 503 3.334884 16.77446652 Spiroplasma gladiatoris 2143 Bacteria Bacteria 52.8 0.049   NTclustered gi|1600712168|gb|CP038013.1| 2143 g49162 i0 100 0.0556660039761431 28 0 6 0 92 119 122702 122729 Spiroplasma gladiatoris strain TG-1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma gladiatoris
8892156 8892156 PRJNA879067_P_NODE_77107_length_352_cov_1.250896_g73621_i0 PRJNA879067 77107 352 1.250896 4.40315392 Mycoplasmopsis 2767358 Bacteria Bacteria 593 4.409999999999998e-165   NTclustered gi|2590815714|gb|CP135997.1| 28903 g73621 i0 99.094 963.696022727273 331 1 93 2 24 352 730008 729678 Mycoplasmopsis bovis strain NX114 chromosome, complete genome blastn 339221 593 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
11057393 11057393 PRJNA879067_P_NODE_100289_length_261_cov_1.648936_g96803_i0 PRJNA879067 100289 261 1.648936 4.30372296 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 103 2.5699999999999997e-24   NR MCI6107433.1 2231116 g96803 i0 98.3 0.67816091954023 59 1 67.8 0 177 1 1 59 MCI6107433.1 hypothetical protein [Mycoplasmatota bacterium] diamond 177 103 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
12334173 12334173 PRJNA879067_P_NODE_42730_length_593_cov_3.457692_g39271_i0 PRJNA879067 42730 593 3.457692 20.50411356 Metamycoplasma salivarium 2124 Bacteria Bacteria 1031 0   NTclustered gi|1563679190|emb|LR214939.1| 2124 g39271 i0 99.472 1.91568296795953 568 2 96 1 1 568 631051 630485 Mycoplasma salivarium strain NCTC10113 genome assembly, plasmid: 2 blastn 1136 1031 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma salivarium
16158804 16158804 PRJNA879067_P_NODE_80253_length_338_cov_1.373585_g76767_i0 PRJNA879067 80253 338 1.373585 4.6427173 Spiroplasma syrphidicola 216945 Bacteria Bacteria 52.8 0.032   NTclustered gi|506966909|gb|CP005078.1| 1276229 g76767 i0 100 0.0828402366863905 28 0 8 0 224 251 120179 120206 Spiroplasma syrphidicola EA-1, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma syrphidicola
16541876 16541876 PRJNA879067_P_NODE_89633_length_300_cov_1.356828_g86147_i0 PRJNA879067 89633 300 1.356828 4.070484 Bacillati 1783272 Bacteria Bacteria 235 2.5799999999999997e-57   NTclustered gi|2187163482|emb|OV788640.1| 658143 g86147 i0 83.73 135.42 252 37 83 4 21 270 373740 373989 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 40626 235 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
17432849 17432849 PRJNA879067_P_NODE_30454_length_756_cov_66.843338_g27139_i0 PRJNA879067 30454 756 66.843338 505.33563528 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 1343 0   NTclustered gi|1563796921|emb|LR215008.1| 2107 g27139 i0 100 56.6587301587302 727 0 96 0 30 756 662477 661751 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 42834 1343 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
17433696 17433696 PRJNA879067_P_NODE_58194_length_462_cov_2.323907_g54709_i0 PRJNA879067 58194 462 2.323907 10.73645034 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 542 2.18e-149   NTclustered gi|2187163482|emb|OV788640.1| 658143 g54709 i0 88.043 2.01298701298701 460 51 99 3 3 460 948843 949300 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 930 542 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
17816514 17816514 PRJNA879067_P_NODE_45094_length_569_cov_3.449597_g41631_i0 PRJNA879067 45094 569 3.449597 19.62820693 Bacteria 2 Bacteria Bacteria 54.7 0.016   NTclustered gi|110005652|emb|AM285328.1| 2133 g41631 i0 100 0.855887521968366 29 0 5 0 357 385 4298 4270 Spiroplasma citri GII3-3X chromosome, contig ContigNP07 blastn 487 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma citri
18707440 18707440 PRJNA879067_P_NODE_76955_length_352_cov_5.046595_g73469_i0 PRJNA879067 76955 352 5.046595 17.7640144 Areca yellow leaf disease phytoplasma 927614 Bacteria Bacteria 145 1.87e-41   NR WP_374695591.1 927614 g73469 i0 67 0.903409090909091 106 35 90.3 0 29 346 72 177 WP_374695591.1 hypothetical protein [Areca yellow leaf disease phytoplasma] diamond 318 145 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Areca yellow leaf disease phytoplasma
20365501 20365501 PRJNA879067_P_NODE_70356_length_386_cov_2.674121_g66871_i0 PRJNA879067 70356 386 2.674121 10.32210706 Mesomycoplasma 2923352 Bacteria Bacteria 713 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g66871 i0 100 75.8238341968912 386 0 100 0 1 386 699535 699920 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 29268 713 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21256695 21256695 PRJNA879067_P_NODE_29617_length_771_cov_4.040115_g26318_i0 PRJNA879067 29617 771 4.040115 31.14928665 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 329 3.19e-85   NTclustered gi|2187152065|emb|OV788643.1| 658143 g26318 i0 76.245 2.12970168612192 703 120 90 39 81 771 768694 768027 uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1 blastn 1642 329 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
21257380 21257380 PRJNA879067_P_NODE_51237_length_514_cov_8.498866_g47753_i0 PRJNA879067 51237 514 8.498866 43.68417124 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 876 0   NTclustered gi|14089413|emb|AL445563.1| 2107 g47753 i0 99.379 7.35214007782101 483 3 94 0 32 514 86897 87379 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 1/3 blastn 3779 876 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
22530750 22530750 PRJNA879067_P_NODE_13238_length_1324_cov_7.581934_g10779_i0 PRJNA879067 13238 1324 7.581934 100.38480616 Ureaplasma diversum 42094 Bacteria Bacteria 58.4 0.003   NTclustered gi|764071633|gb|CP009770.1| 42094 g10779 i0 97.143 0.0264350453172205 35 0 3 1 901 935 531951 531984 Ureaplasma diversum strain ATCC 49782 genome blastn 35 58.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma diversum
24190721 24190721 PRJNA879067_P_NODE_70659_length_384_cov_14.295820_g67174_i0 PRJNA879067 70659 384 14.29582 54.8959488 Bacteria 2 Bacteria Bacteria 647 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g67174 i0 99.717 75.4114583333333 353 1 92 0 3 355 428771 429123 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 28958 647 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
25081977 25081977 PRJNA879067_P_NODE_72700_length_373_cov_11.596667_g69215_i0 PRJNA879067 72700 373 11.596667 43.25556791 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 130 1.59e-25   NTclustered gi|2187163482|emb|OV788640.1| 658143 g69215 i0 84.211 18.2493297587131 133 21 36 0 60 192 373596 373464 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 6807 130 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
27276651 27276651 PRJNA879067_P_NODE_81883_length_331_cov_1.492248_g78397_i0 PRJNA879067 81883 331 1.492248 4.93934088 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 64.7 4.86e-10   NR MCI6627448.1 2231116 g78397 i0 46.3 0.725075528700906 80 38 70.7 2 262 29 94 170 MCI6627448.1 zinc dependent phospholipase C family protein [Mycoplasmatota bacterium] diamond 240 64.7 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
27442812 27442812 PRJNA879067_P_NODE_111183_length_241_cov_0.916667_g107697_i0 PRJNA879067 111183 241 0.916667 2.20916747 Acholeplasma 2147 Bacteria Bacteria 104 1.86e-24   NR MFA7417061.1 33015 g107697 i0 65.2 4.28215767634855 69 24 85.9 0 208 2 1 69 MFA7417061.1 cysteine desulfurase [Acholeplasma sp.] diamond 1032 104 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
28318544 28318544 PRJNA879067_P_NODE_91726_length_292_cov_1.374429_g88240_i0 PRJNA879067 91726 292 1.374429 4.01333268 Mollicutes bacterium 37628 Bacteria Bacteria 167 1.5199999999999999e-46   NR MCI6788985.1 37628 g88240 i0 96.7 0.934931506849315 91 3 93.5 0 291 19 290 380 MCI6788985.1 ABC transporter ATP-binding protein/permease [Mollicutes bacterium] diamond 273 167 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30908489 30908489 PRJNA879067_P_NODE_26734_length_829_cov_4.728836_g23507_i0 PRJNA879067 26734 829 4.728836 39.20205044 Mollicutes bacterium 37628 Bacteria Bacteria 503 5.049999999999998e-170   NR MCI6788722.1 37628 g23507 i0 99.2 0.915560916767189 253 2 91.6 0 807 49 1 253 MCI6788722.1 Ig-like domain-containing protein [Mollicutes bacterium] diamond 759 503 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes 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);;