RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where bioproject = "PRJNA558770" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA558770 · 31 ✖

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
1815193 1815193 PRJNA558770_P_NODE_219762_length_234_cov_3.100503_g217757_i0 PRJNA558770 219762 234 3.100503 7.25517702 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 117 7.33e-22   NTclustered gi|2187152065|emb|OV788643.1| 658143 g217757 i0 95.89 1.85470085470085 73 1 30 1 5 75 933332 933260 uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1 blastn 434 117 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
1816770 1816770 PRJNA558770_P_NODE_328002_length_233_cov_6.737374_g325997_i0 PRJNA558770 328002 233 6.737374 15.69808142 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 87.9 5.72e-13   NTclustered gi|2621717558|emb|OY775910.1| 1898209 g325997 i0 87.838 3.55364806866953 74 9 32 0 160 233 771429 771356 MAG: Acholeplasmataceae bacterium isolate 79d77305-d387-4e48-9b67-53dfc1ec32a7 genome assembly, chromosome: 1 blastn 828 87.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
3089933 3089933 PRJNA558770_P_NODE_191563_length_234_cov_4.120603_g189558_i0 PRJNA558770 191563 234 4.120603 9.64221102 Spiroplasma endosymbiont of Rhagonycha fulva 3066280 Bacteria Bacteria 56.5 0.002   NTclustered gi|2802839268|emb|OZ181653.1| 3066280 g189558 i0 96.97 0.141025641025641 33 1 14 0 161 193 633807 633839 Spiroplasma endosymbiont of Rhagonycha fulva isolate 54749 genome assembly, chromosome: 1 blastn 33 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Rhagonycha fulva
4957981 4957981 PRJNA558770_P_NODE_393784_length_164_cov_1.961240_g391779_i0 PRJNA558770 393784 164 1.96124 3.2164336 Mollicutes 31969 Bacteria Bacteria 303 3.42e-78   NTclustered gi|1958638505|gb|MW498314.1| 2100 g391779 i0 100 123.256097560976 164 0 100 0 1 164 1294 1131 Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence blastn 20214 303 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
5644443 5644443 PRJNA558770_P_NODE_290525_length_234_cov_1.557789_g288520_i0 PRJNA558770 290525 234 1.557789 3.64522626 Metamycoplasma salivarium 2124 Bacteria Bacteria 139 1.56e-28   NTclustered gi|1563679190|emb|LR214939.1| 2124 g288520 i0 100 1.24786324786325 75 0 62 0 1 75 156909 156983 Mycoplasma salivarium strain NCTC10113 genome assembly, plasmid: 2 blastn 292 139 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma salivarium
8192600 8192600 PRJNA558770_P_NODE_231067_length_234_cov_2.773869_g229062_i0 PRJNA558770 231067 234 2.773869 6.49085346 Mycoplasma bradburyae 2963128 Bacteria Bacteria 54.7 0.006   NTclustered gi|2274227125|gb|CP101414.1| 2963128 g229062 i0 83.051 0.252136752136752 59 10 25 0 5 63 908452 908394 Mycoplasma bradburyae strain T158 chromosome, complete genome blastn 59 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma bradburyae
22215894 22215894 PRJNA558770_P_NODE_178458_length_234_cov_4.718593_g176453_i0 PRJNA558770 178458 234 4.718593 11.04150762 Metamycoplasma canadense 29554 Bacteria Bacteria 52.8 0.021   NTclustered gi|675242197|dbj|AP014631.1| 29554 g176453 i0 100 0.363247863247863 28 0 12 0 168 195 439889 439916 Mycoplasma canadense DNA, complete genome, strain: HAZ360_1 blastn 85 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma canadense
27015556 27015556 PRJNA558770_P_NODE_211562_length_234_cov_3.361809_g209557_i0 PRJNA558770 211562 234 3.361809 7.86663306 Mycoplasmopsis arginini 2094 Bacteria Bacteria 49.7 1.31e-5   NR WP_282459939.1 2094 g209557 i0 100 0.307692307692308 24 0 30.8 0 231 160 23 46 WP_282459939.1 phage head closure protein, partial [Mycoplasmopsis arginini] diamond 72 49.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27078920 27078920 PRJNA558770_P_NODE_269722_length_234_cov_1.914573_g267717_i0 PRJNA558770 269722 234 1.914573 4.48010082 Tenericutes bacterium MO-XQ 1911684 Bacteria Bacteria 53.5 5.27e-6   NR AUD62972.1 1911684 g267717 i0 76 0.935897435897436 25 6 32.1 0 234 160 269 293 AUD62972.1 hypothetical protein BK010_04990 [Tenericutes bacterium MO-XQ] diamond 219 53.5 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium MO-XQ
27679489 27679489 PRJNA558770_P_NODE_238684_length_234_cov_2.572864_g236679_i0 PRJNA558770 238684 234 2.572864 6.02050176 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 45.4 0.00383   NR MCM1514471.1 2088 g236679 i0 75 0.307692307692308 24 6 30.8 0 160 231 463 486 MCM1514471.1 toprim domain-containing protein [Anaeroplasma bactoclasticum] diamond 72 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
27742617 27742617 PRJNA558770_P_NODE_265604_length_234_cov_1.989950_g263599_i0 PRJNA558770 265604 234 1.98995 4.656483 Mycoplasmopsis arginini 2094 Bacteria Bacteria 88.6 6.2e-21   NR WP_282460103.1 2094 g263599 i0 63.6 0.987179487179487 77 1 98.7 1 4 234 33 82 WP_282460103.1 hypothetical protein [Mycoplasmopsis arginini] diamond 231 88.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27899970 27899970 PRJNA558770_P_NODE_192085_length_234_cov_4.100503_g190080_i0 PRJNA558770 192085 234 4.100503 9.59517702 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 67.8 4.88e-11   NR HEY8365051.1 2862752 g190080 i0 48.7 0.974358974358974 76 15 97.4 1 3 230 264 315 HEY8365051.1 hypothetical protein [Haloplasmataceae bacterium] diamond 228 67.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
28184065 28184065 PRJNA558770_P_NODE_153746_length_234_cov_6.160804_g151741_i0 PRJNA558770 153746 234 6.160804 14.41628136 Mycoplasmopsis arginini 2094 Bacteria Bacteria 53.1 3.13e-6   NR WP_282460164.1 2094 g151741 i0 92 0.320512820512821 25 2 32.1 0 2 76 149 173 WP_282460164.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 75 53.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28184094 28184094 PRJNA558770_P_NODE_244926_length_234_cov_2.422111_g242921_i0 PRJNA558770 244926 234 2.422111 5.66773974 Mycoplasmopsis arginini 2094 Bacteria Bacteria 42.7 0.00724   NR MDI3350086.1 2094 g242921 i0 81 0.269230769230769 21 4 26.9 0 223 161 75 95 MDI3350086.1 hypothetical protein [Mycoplasmopsis arginini] diamond 63 42.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28626559 28626559 PRJNA558770_P_NODE_223387_length_234_cov_2.994975_g221382_i0 PRJNA558770 223387 234 2.994975 7.0082415 Mycoplasmopsis arginini 2094 Bacteria Bacteria 56.2 8.35e-8   NR WP_282459881.1 2094 g221382 i0 100 0.307692307692308 24 0 30.8 0 160 231 87 110 WP_282459881.1 hypothetical protein [Mycoplasmopsis arginini] diamond 72 56.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28658074 28658074 PRJNA558770_P_NODE_262547_length_234_cov_2.050251_g260542_i0 PRJNA558770 262547 234 2.050251 4.79758734 Haploplasma axanthum 29552 Bacteria Bacteria 45.1 0.00225   NR WP_026390886.1 29552 g260542 i0 80 0.320512820512821 25 5 32.1 0 1 75 118 142 WP_026390886.1 ribose 5-phosphate isomerase B [Haploplasma axanthum] diamond 75 45.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Haploplasma Haploplasma axanthum
28878875 28878875 PRJNA558770_P_NODE_389948_length_177_cov_1.823944_g387943_i0 PRJNA558770 389948 177 1.823944 3.22838088 Mycoplasmopsis arginini 2094 Bacteria Bacteria 118 1.61e-32   NR WP_282457347.1 2094 g387943 i0 94.6 0.949152542372881 56 3 94.9 0 8 175 4 59 WP_282457347.1 hypothetical protein [Mycoplasmopsis arginini] diamond 168 118 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29541935 29541935 PRJNA558770_P_NODE_52350_length_295_cov_2.092308_g50347_i0 PRJNA558770 52350 295 2.092308 6.1723086 Mycoplasmopsis arginini 2094 Bacteria Bacteria 63.5 7.54e-11   NR WP_282460007.1 2094 g50347 i0 100 0.274576271186441 27 0 27.5 0 241 161 1 27 WP_282460007.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 81 63.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29826038 29826038 PRJNA558770_P_NODE_212311_length_234_cov_3.336683_g210306_i0 PRJNA558770 212311 234 3.336683 7.80783822 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 48.9 1.83e-4   NR MCM1514466.1 2088 g210306 i0 100 0.282051282051282 22 0 28.2 0 74 9 231 252 MCM1514466.1 AAA family ATPase [Anaeroplasma bactoclasticum] diamond 66 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
30015870 30015870 PRJNA558770_P_NODE_54631_length_285_cov_11.816000_g52627_i0 PRJNA558770 54631 285 11.816 33.6756 Mycoplasmopsis arginini 2094 Bacteria Bacteria 122 3.84e-33   NR WP_282460193.1 2094 g52627 i0 100 1.24210526315789 59 0 62.1 0 179 3 86 144 WP_282460193.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 354 122 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30141681 30141681 PRJNA558770_P_NODE_256992_length_234_cov_2.155779_g254987_i0 PRJNA558770 256992 234 2.155779 5.04452286 Mycoplasmopsis arginini 2094 Bacteria Bacteria 68.2 5.67e-12   NR WP_282460150.1 2094 g254987 i0 60.3 1 78 2 100 1 234 1 47 95 WP_282460150.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 234 68.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30963696 30963696 PRJNA558770_P_NODE_165734_length_234_cov_5.407035_g163729_i0 PRJNA558770 165734 234 5.407035 12.6524619 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 48.5 2.85e-4   NR MCM1514470.1 2088 g163729 i0 91.7 0.307692307692308 24 2 30.8 0 232 161 192 215 MCM1514470.1 hypothetical protein [Anaeroplasma bactoclasticum] diamond 72 48.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
31311139 31311139 PRJNA558770_P_NODE_245755_length_234_cov_2.402010_g243750_i0 PRJNA558770 245755 234 2.40201 5.6207034 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 46.6 2.48e-4   NR MCI9182919.1 2053494 g243750 i0 100 0.243589743589744 19 0 24.4 0 57 1 1 19 MCI9182919.1 hypothetical protein [Acholeplasmatales bacterium] diamond 57 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
31342950 31342950 PRJNA558770_P_NODE_396476_length_155_cov_1.783333_g394471_i0 PRJNA558770 396476 155 1.783333 2.76416615 Mycoplasmopsis arginini 2094 Bacteria Bacteria 99.4 7.58e-25   NR WP_282460155.1 2094 g394471 i0 94.1 0.987096774193548 51 3 98.7 0 3 155 71 121 WP_282460155.1 glycoside hydrolase family 19 protein, partial [Mycoplasmopsis arginini] diamond 153 99.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31374631 31374631 PRJNA558770_P_NODE_199376_length_234_cov_3.804020_g197371_i0 PRJNA558770 199376 234 3.80402 8.9014068 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 42.7 0.0328   NR MCM1514469.1 2088 g197371 i0 79.2 0.307692307692308 24 5 30.8 0 74 3 480 503 MCM1514469.1 hypothetical protein [Anaeroplasma bactoclasticum] diamond 72 42.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
31975510 31975510 PRJNA558770_P_NODE_310098_length_233_cov_12.207071_g308093_i0 PRJNA558770 310098 233 12.207071 28.44247543 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 45.8 5.17e-4   NR MDV3180609.1 2754999 g308093 i0 72 0.321888412017167 25 7 32.2 0 233 159 23 47 MDV3180609.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 75 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32038793 32038793 PRJNA558770_P_NODE_167378_length_234_cov_5.316583_g165373_i0 PRJNA558770 167378 234 5.316583 12.44080422 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 50.8 3.81e-5   NR MCM1514466.1 2088 g165373 i0 100 0.320512820512821 25 0 32.1 0 234 160 57 81 MCM1514466.1 AAA family ATPase [Anaeroplasma bactoclasticum] diamond 75 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
32038833 32038833 PRJNA558770_P_NODE_367078_length_232_cov_1.446701_g365073_i0 PRJNA558770 367078 232 1.446701 3.35634632 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 87.8 4.45e-18   NR MCM1514471.1 2088 g365073 i0 62.3 0.995689655172414 77 6 99.6 1 232 2 120 173 MCM1514471.1 toprim domain-containing protein [Anaeroplasma bactoclasticum] diamond 231 87.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
32102034 32102034 PRJNA558770_P_NODE_204158_length_234_cov_3.628141_g202153_i0 PRJNA558770 204158 234 3.628141 8.48984994 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 50.8 2.72e-6   NR HHU80974.1 1898209 g202153 i0 95.7 0.294871794871795 23 1 29.5 0 4 72 38 60 HHU80974.1 helix-turn-helix domain-containing protein [Acholeplasmataceae bacterium] diamond 69 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32418564 32418564 PRJNA558770_P_NODE_251739_length_234_cov_2.271357_g249734_i0 PRJNA558770 251739 234 2.271357 5.31497538 Mycoplasmopsis arginini 2094 Bacteria Bacteria 50.4 6.88e-6   NR WP_282460149.1 2094 g249734 i0 49.2 0.782051282051282 61 11 78.2 1 5 187 36 76 WP_282460149.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 183 50.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32608107 32608107 PRJNA558770_P_NODE_215280_length_234_cov_3.241206_g213275_i0 PRJNA558770 215280 234 3.241206 7.58442204 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 48.9 2.13e-4   NR MFO7969916.1 3018265 g213275 i0 40 0.961538461538462 75 23 96.2 1 2 226 196 248 MFO7969916.1 DUF5906 domain-containing protein [Candidatus Izemoplasmatales bacterium] diamond 225 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales 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);;