RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJEB20058", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 22 ✖

tax_phylum 1

  • Mycoplasmatota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 22 ✖

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
25513458 25513458 PRJEB20058_P_NODE_115641_length_373_cov_2.141026_g112826_i0 PRJEB20058 115641 373 2.141026 7.98602698 Metamycoplasma faucium 56142 Bacteria Bacteria 660 0   NTclustered gi|2921905358|gb|CP182786.1| 56142 g112826 i0 99.449 51.112600536193 363 2 97 0 11 373 502478 502116 Metamycoplasma faucium strain DC-333 chromosome, complete genome blastn 19065 660 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
25515424 25515424 PRJEB20058_P_NODE_160377_length_299_cov_4.752101_g157554_i0 PRJEB20058 160377 299 4.752101 14.20878199 Mesomycoplasma ovipneumoniae 29562 Bacteria Bacteria 56.5 0.002   NTclustered gi|2582038664|gb|CP134944.1| 29562 g157554 i0 100 0.193979933110368 30 0 10 0 128 157 64766 64795 Mesomycoplasma ovipneumoniae strain MoS3261N22A chromosome, complete genome blastn 58 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma ovipneumoniae
25519508 25519508 PRJEB20058_P_NODE_33913_length_721_cov_3.090909_g31348_i0 PRJEB20058 33913 721 3.090909 22.28545389 Spiroplasma endosymbiont of Asaphidion curtum 3066281 Bacteria Bacteria 58.4 0.002   NTclustered gi|2719904888|emb|OZ035001.1| 3066281 g31348 i0 94.595 0.194174757281553 37 2 5 0 137 173 316363 316399 Spiroplasma endosymbiont of Asaphidion curtum isolate 54750 genome assembly, chromosome: 1 blastn 140 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Asaphidion curtum
25615408 25615408 PRJEB20058_P_NODE_94425_length_421_cov_8.402778_g91624_i0 PRJEB20058 94425 421 8.402778 35.37569538 Mycoplasmopsis 2767358 Bacteria Bacteria 56.5 0.003   NTclustered gi|1563792347|emb|LR214972.1| 29553 g91624 i0 100 2.29928741092637 30 0 7 0 359 388 244825 244796 Mycoplasma bovirhinis strain NCTC10118 genome assembly, chromosome: 1 blastn 968 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovirhinis
25658016 25658016 PRJEB20058_P_NODE_84034_length_450_cov_10.043702_g81246_i0 PRJEB20058 84034 450 10.043702 45.196659 Spiroplasma endosymbiont of Othius punctulatus 3066289 Bacteria Bacteria 56.5 0.003   NTclustered gi|2706542394|emb|OZ026449.1| 3066289 g81246 i0 100 0.0666666666666667 30 0 7 0 175 204 691707 691678 Spiroplasma endosymbiont of Othius punctulatus isolate 54758 genome assembly, chromosome: 1 blastn 30 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Othius punctulatus
25790746 25790746 PRJEB20058_P_NODE_242771_length_209_cov_9.222973_g239946_i0 PRJEB20058 242771 209 9.222973 19.27601357 Ureaplasma diversum 42094 Bacteria Bacteria 71.3 5.06e-8   NTclustered gi|365822491|gb|JN935894.1| 42094 g239946 i0 78.761 21.0047846889952 113 19 53 5 1 111 2154 2045 Ureaplasma diversum strain T95 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 4390 71.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma diversum
25921554 25921554 PRJEB20058_P_NODE_112012_length_380_cov_16.517241_g109199_i0 PRJEB20058 112012 380 16.517241 62.7655158 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 385 3.14e-102   NTclustered gi|2187152066|emb|OV788644.1| 658143 g109199 i0 87.106 130.602631578947 349 33 91 12 10 353 394348 394007 uncultured Tenericutes bacterium isolate min17_bin35 genome assembly, chromosome: 1 blastn 49629 385 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
26333452 26333452 PRJEB20058_P_NODE_201271_length_255_cov_4.520619_g198447_i0 PRJEB20058 201271 255 4.520619 11.52757845 Mesomycoplasma lagogenitalium 171286 Bacteria Bacteria 158 4.769999999999999e-34   NTclustered gi|2495165145|gb|CP122979.1| 171286 g198447 i0 87.5 50.0705882352941 136 17 53 0 95 230 898224 898359 Mesomycoplasma lagogenitalium strain 12MS chromosome, complete genome blastn 12768 158 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma lagogenitalium
26466764 26466764 PRJEB20058_P_NODE_132520_length_341_cov_11.257143_g129700_i0 PRJEB20058 132520 341 11.257143 38.38685763 Mycoplasmopsis pullorum 48003 Bacteria Bacteria 490 5.76e-134   NTclustered gi|1114069901|gb|CP017813.1| 48003 g129700 i0 94.357 2.97067448680352 319 18 94 0 23 341 38003 38321 Mycoplasmopsis pullorum strain B359_6, complete genome blastn 1013 490 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pullorum
31322195 31322195 PRJEB20058_S_NODE_3535_length_349_cov_1.368056_g3497_i0 PRJEB20058 3535 349 1.368056 4.77451544 Acholeplasma 2147 Bacteria Bacteria 82.8 1.17e-15   NR HHU20864.1 33015 g3497 i0 72.7 6.63610315186246 55 15 47.3 0 4 168 196 250 HHU20864.1 vitamin B12-dependent ribonucleotide reductase [Acholeplasma sp.] diamond 2316 82.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
32910528 32910528 PRJEB20058_P_NODE_132601_length_341_cov_5.596429_g129781_i0 PRJEB20058 132601 341 5.596429 19.08382289 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 150 2.19e-41   NR NLH45543.1 1898209 g129781 i0 90 0.703812316715543 80 8 70.4 0 2 241 304 383 NLH45543.1 sugar transporter [Acholeplasmataceae bacterium] diamond 240 150 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32910655 32910655 PRJEB20058_P_NODE_152833_length_309_cov_34.971774_g150010_i0 PRJEB20058 152833 309 34.971774 108.06278166 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 52.8 2.07e-5   NR MFA5037951.1 3018265 g150010 i0 35.8 0.922330097087379 95 45 83.5 2 24 281 160 247 MFA5037951.1 FAD-dependent thymidylate synthase [Candidatus Izemoplasmatales bacterium] diamond 285 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
32980177 32980177 PRJEB20058_P_NODE_91339_length_429_cov_15.421196_g88540_i0 PRJEB20058 91339 429 15.421196 66.15693084 Mollicutes bacterium 37628 Bacteria Bacteria 64.3 3.33e-9   NR MCI5542430.1 37628 g88540 i0 48.6 0.93006993006993 74 34 51 2 22 240 147 217 MCI5542430.1 metallophosphoesterase [Mollicutes bacterium] diamond 399 64.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
32991510 32991510 PRJEB20058_P_NODE_41203_length_655_cov_9.215488_g38554_i0 PRJEB20058 41203 655 9.215488 60.3614464 FCB group 1783270 Bacteria Bacteria 74.7 7.76e-14   NR OQC09120.1 1852918 g38554 i0 68.9 0.421374045801527 45 14 20.6 0 586 452 26 70 OQC09120.1 MAG: hypothetical protein BWX74_00964 [Tenericutes bacterium ADurb.Bin087] diamond 276 74.7 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin087
32996665 32996665 PRJEB20058_P_NODE_248659_length_197_cov_5.970588_g245834_i0 PRJEB20058 248659 197 5.970588 11.76205836 Metamycoplasma hominis 2098 Bacteria Bacteria 46.6 2.51e-4   NR WP_176244279.1 2098 g245834 i0 60 0.913705583756345 30 12 45.7 0 26 115 78 107 WP_176244279.1 restriction endonuclease subunit S [Metamycoplasma hominis] diamond 180 46.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hominis
33030522 33030522 PRJEB20058_P_NODE_178884_length_277_cov_3.268519_g176061_i0 PRJEB20058 178884 277 3.268519 9.05379763 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 88.2 3.52e-19   NR MBR3832554.1 2685873 g176061 i0 51.4 0.8014440433213 74 36 80.1 0 34 255 6 79 MBR3832554.1 hypothetical protein [Mycoplasmataceae bacterium] diamond 222 88.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
33031234 33031234 PRJEB20058_P_NODE_82452_length_455_cov_8.500000_g79668_i0 PRJEB20058 82452 455 8.5 38.675 Mycoplasma sp. E35C 2801918 Bacteria Bacteria 50.8 4.8e-5   NR WP_222926259.1 2801918 g79668 i0 57.1 0.975824175824176 35 14 23.1 1 342 446 1 34 WP_222926259.1 thioredoxin [Mycoplasma sp. E35C] diamond 444 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. E35C
33047489 33047489 PRJEB20058_P_NODE_18341_length_967_cov_22.140177_g16335_i0 PRJEB20058 18341 967 22.140177 214.09551159 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 97.8 1.92e-18   NR MFA5037076.1 3018265 g16335 i0 26.1 1.8210961737332 306 205 89.7 7 938 72 148 449 MFA5037076.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 1761 97.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
33048034 33048034 PRJEB20058_P_NODE_63133_length_526_cov_233.348387_g60371_i0 PRJEB20058 63133 526 233.348387 1227.41251562 Candidatus Izemoplasmataceae bacterium 3107147 Bacteria Bacteria 52 2.5e-5   NR MFU8786588.1 3107147 g60371 i0 40 1.2319391634981 60 30 30.8 1 404 243 3 62 MFU8786588.1 IS66 family insertion sequence element accessory protein TnpA [Candidatus Izemoplasmataceae bacterium] diamond 648 52 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae   Candidatus Izemoplasmataceae bacterium
33116250 33116250 PRJEB20058_P_NODE_56767_length_557_cov_3.280242_g54015_i0 PRJEB20058 56767 557 3.280242 18.27094794 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 353 4.439999999999999e-118   NR NLH46840.1 1898209 g54015 i0 98.3 0.953321364452424 177 3 95.3 0 7 537 300 476 NLH46840.1 serine hydrolase [Acholeplasmataceae bacterium] diamond 531 353 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
33167360 33167360 PRJEB20058_P_NODE_50832_length_589_cov_48.382576_g48102_i0 PRJEB20058 50832 589 48.382576 284.97337264 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 184 1.21e-56   NR NLH44917.1 1898209 g48102 i0 92.7 0.488964346349745 96 7 48.9 0 166 453 1 96 NLH44917.1 LysM peptidoglycan-binding domain-containing protein [Acholeplasmataceae bacterium] diamond 288 184 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
33179163 33179163 PRJEB20058_P_NODE_43184_length_640_cov_3.138169_g40517_i0 PRJEB20058 43184 640 3.138169 20.0842816 PVC group 1783257 Bacteria Bacteria 64.7 2.41e-8   NR OQA77694.1 1852920 g40517 i0 34.1 4.5796875 126 79 57.2 3 251 616 1 126 OQA77694.1 MAG: YqaJ-like viral recombinase domain protein [Tenericutes bacterium ADurb.Bin239] diamond 2931 65.1 0.993855606758833 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.Bin239

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