RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 23 ✖

bioproject 1

  • PRJNA1067370 · 23 ✖

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
2731038 2731038 PRJNA1067370_P_NODE_102823_length_244_cov_1.105263_g102274_i0 PRJNA1067370 102823 244 1.105263 2.69684172 Mycoplasma feriruminatoris 1179777 Bacteria Bacteria 124 4.599999999999999e-24   NTclustered gi|2483644534|gb|CP113499.1| 1179777 g102274 i0 81.879 1.95491803278689 149 26 61 1 77 224 73259 73111 Mycoplasma feriruminatoris strain L15407 chromosome, complete genome blastn 477 124 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feriruminatoris
5283746 5283746 PRJNA1067370_P_NODE_53785_length_289_cov_1.425926_g53236_i0 PRJNA1067370 53785 289 1.425926 4.12092614 Candidatus Phytoplasma citri 180978 Bacteria Bacteria 173 3.6e-52   NR MDO8079108.1 180978 g53236 i0 83 2.94809688581315 94 16 97.6 0 282 1 1 94 MDO8079108.1 hypothetical protein [Candidatus Phytoplasma citri] diamond 852 173 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma citri
6116463 6116463 PRJNA1067370_P_NODE_76225_length_255_cov_1.928571_g75676_i0 PRJNA1067370 76225 255 1.928571 4.91785605 Mycoplasmopsis 2767358 Bacteria Bacteria 472 1.5e-128   NTclustered gi|1874468068|gb|CP058969.1| 28903 g75676 i0 100 140.094117647059 255 0 100 0 1 255 229708 229962 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 35724 472 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
13766563 13766563 PRJNA1067370_P_NODE_33051_length_343_cov_1.148148_g32503_i0 PRJNA1067370 33051 343 1.148148 3.93814764 Mycoplasma 2093 Bacteria Bacteria 628 1.1799999999999997e-175   NTclustered gi|2294785939|gb|CP103424.1| 51364 g32503 i0 99.708 193.985422740525 343 1 100 0 1 343 270258 269916 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 66537 628 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
15040836 15040836 PRJNA1067370_P_NODE_103972_length_244_cov_0.900585_g103423_i0 PRJNA1067370 103972 244 0.900585 2.1974274 Mesomycoplasma 2923352 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1720621726|gb|CP035041.1| 2100 g103423 i0 100 16.5204918032787 244 0 100 0 1 244 511560 511803 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4031 451 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15040999 15040999 PRJNA1067370_P_NODE_79652_length_251_cov_0.865169_g79103_i0 PRJNA1067370 79652 251 0.865169 2.17157419 Mesomycoplasma 2923352 Bacteria Bacteria 464 2.47e-126   NTclustered gi|1720621726|gb|CP035041.1| 2100 g79103 i0 100 15 251 0 100 0 1 251 253162 253412 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3765 464 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
16315798 16315798 PRJNA1067370_P_NODE_99593_length_245_cov_0.895349_g99044_i0 PRJNA1067370 99593 245 0.895349 2.19360505 Mesomycoplasma 2923352 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2713084492|gb|CP150431.1| 2100 g99044 i0 100 216.318367346939 245 0 100 0 1 245 303163 303407 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 52998 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
16757984 16757984 PRJNA1067370_P_NODE_73534_length_259_cov_1.741935_g72985_i0 PRJNA1067370 73534 259 1.741935 4.51161165 Mycoplasmopsis gallopavonis 76629 Bacteria Bacteria 52.8 0.024   NTclustered gi|1563802541|emb|LR215032.1| 76629 g72985 i0 94.286 0.135135135135135 35 1 14 1 78 112 261010 261043 Mycoplasma gallopavonis strain NCTC10186 genome assembly, plasmid: 2 blastn 35 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis gallopavonis
17590954 17590954 PRJNA1067370_P_NODE_115874_length_239_cov_2.060241_g115325_i0 PRJNA1067370 115874 239 2.060241 4.92397599 Mycoplasmopsis 2767358 Bacteria Bacteria 442 1.0899999999999994e-119   NTclustered gi|1874468068|gb|CP058969.1| 28903 g115325 i0 100 98.7615062761506 239 0 100 0 1 239 544261 544023 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 23604 442 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
17591127 17591127 PRJNA1067370_P_NODE_90874_length_248_cov_0.880000_g90325_i0 PRJNA1067370 90874 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 459 1.13e-124   NTclustered gi|365822471|gb|JN935874.1| 51364 g90325 i0 100 159.004032258065 248 0 100 0 1 248 941 1188 Mycoplasma cottewii strain VIS 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 39433 459 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
21857928 21857928 PRJNA1067370_P_NODE_82058_length_250_cov_3.112994_g81509_i0 PRJNA1067370 82058 250 3.112994 7.782485 Mycoplasma capricolum 2095 Bacteria Bacteria 183 7.7e-42   NTclustered gi|1822115085|gb|CP041700.1| 40480 g81509 i0 83.085 36.996 201 34 80 0 14 214 968085 968285 Mycoplasma capricolum subsp. capripneumoniae strain 05021 chromosome, complete genome blastn 9249 183 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma capricolum
23965693 23965693 PRJNA1067370_P_NODE_61499_length_277_cov_2.441176_g60950_i0 PRJNA1067370 61499 277 2.441176 6.76205752 Mycoplasmopsis 2767358 Bacteria Bacteria 512 9.73e-141   NTclustered gi|1874468068|gb|CP058969.1| 28903 g60950 i0 100 100.12274368231 277 0 100 0 1 277 555170 555446 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 27734 512 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
23965737 23965737 PRJNA1067370_P_NODE_84059_length_250_cov_0.870056_g83510_i0 PRJNA1067370 84059 250 0.870056 2.17514 Mycoplasmopsis 2767358 Bacteria Bacteria 462 8.83e-126   NTclustered gi|2111402438|gb|CP068733.1| 28903 g83510 i0 100 101 250 0 100 0 1 250 365922 366171 Mycoplasmopsis bovis strain J81 chromosome, complete genome blastn 25250 462 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
24406432 24406432 PRJNA1067370_P_NODE_102620_length_244_cov_1.350877_g102071_i0 PRJNA1067370 102620 244 1.350877 3.29613988 Mycoplasmopsis citelli 171281 Bacteria Bacteria 54.7 0.006   NTclustered gi|1563803758|emb|LR215036.1| 171281 g102071 i0 100 0.237704918032787 29 0 12 0 165 193 524176 524148 Mycoplasma citelli strain NCTC10181 genome assembly, chromosome: 1 blastn 58 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis citelli
27509698 27509698 PRJNA1067370_P_NODE_36323_length_331_cov_1.174419_g35775_i0 PRJNA1067370 36323 331 1.174419 3.88732689 Spiroplasma floricola 216937 Bacteria Bacteria 92.8 1.85e-20   NR WP_100916376.1 216937 g35775 i0 55.6 3.5166163141994 99 40 89.7 3 298 2 2 96 WP_100916376.1 SDR family oxidoreductase [Spiroplasma floricola] diamond 1164 92.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma floricola
27572788 27572788 PRJNA1067370_P_NODE_92544_length_247_cov_1.327586_g91995_i0 PRJNA1067370 92544 247 1.327586 3.27913742 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 45.8 0.00322   NR MFV0288246.1 2023991 g91995 i0 43.1 0.704453441295547 58 30 70.4 2 196 23 215 269 MFV0288246.1 hypothetical protein [Mycoplasmatales bacterium] diamond 174 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
27793871 27793871 PRJNA1067370_P_NODE_39804_length_320_cov_0.935223_g39256_i0 PRJNA1067370 39804 320 0.935223 2.9927136 Spiroplasma cantharicola 362837 Bacteria Bacteria 49.7 3.33e-4   NR ALD66451.1 362837 g39256 i0 30 0.9375 100 64 93.8 2 13 312 260 353 ALD66451.1 DNA uptake protein [Spiroplasma cantharicola] diamond 300 49.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma cantharicola
28046348 28046348 PRJNA1067370_P_NODE_7945_length_638_cov_1.794690_g7419_i0 PRJNA1067370 7945 638 1.79469 11.4501222 Mycoplasma feriruminatoris 1179777 Bacteria Bacteria 48.9 0.00759   NR WP_239759469.1 1179777 g7419 i0 27.4 1.06269592476489 226 115 90.8 11 40 618 200 409 WP_239759469.1 DUF2326 domain-containing protein [Mycoplasma feriruminatoris] diamond 678 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feriruminatoris
28772465 28772465 PRJNA1067370_P_NODE_33307_length_342_cov_1.144981_g32759_i0 PRJNA1067370 33307 342 1.144981 3.91583502 Haloplasma contractile 471825 Bacteria Bacteria 79 9.27e-15   NR WP_008824560.1 471825 g32759 i0 36 2.87719298245614 111 70 97.4 1 1 333 165 274 WP_008824560.1 alpha/beta fold hydrolase [Haloplasma contractile] diamond 984 79 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae Haloplasma Haloplasma contractile
29435232 29435232 PRJNA1067370_P_NODE_108710_length_243_cov_0.905882_g108161_i0 PRJNA1067370 108710 243 0.905882 2.20129326 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 111 2.9500000000000003e-27   NR MCK9234933.1 1898209 g108161 i0 64.6 0.975308641975309 79 28 97.5 0 239 3 264 342 MCK9234933.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 237 111 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31710711 31710711 PRJNA1067370_P_NODE_34537_length_337_cov_1.473485_g33989_i0 PRJNA1067370 34537 337 1.473485 4.96564445 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 101 4.7e-23   NR MDR1234481.1 2685873 g33989 i0 45.3 1.83382789317507 106 58 94.4 0 3 320 165 270 MDR1234481.1 NAD(P)-dependent alcohol dehydrogenase [Mycoplasmataceae bacterium] diamond 618 101 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
31868754 31868754 PRJNA1067370_P_NODE_43057_length_311_cov_0.987395_g42509_i0 PRJNA1067370 43057 311 0.987395 3.07079845 Candidatus Phytoplasma citri 180978 Bacteria Bacteria 100 2.58e-22   NR MDO8079048.1 180978 g42509 i0 50.9 1.04180064308682 108 46 97.4 2 306 4 254 361 MDO8079048.1 hypothetical protein [Candidatus Phytoplasma citri] diamond 324 100 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma citri
32216933 32216933 PRJNA1067370_P_NODE_113638_length_241_cov_0.916667_g113089_i0 PRJNA1067370 113638 241 0.916667 2.20916747 Candidatus Phytoplasma citri 180978 Bacteria Bacteria 73.9 3.55e-13   NR MDO8079048.1 180978 g113089 i0 48.1 1.00829875518672 81 40 98.3 1 241 5 254 334 MDO8079048.1 hypothetical protein [Candidatus Phytoplasma citri] diamond 243 73.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma citri

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