RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 13 ✖

analysis 1

  • diamond · 13 ✖

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