RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 15 ✖

bioproject 1

  • PRJNA352850 · 15 ✖

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
2346961 2346961 PRJNA352850_P_NODE_64042_length_286_cov_1.814346_g61209_i0 PRJNA352850 64042 286 1.814346 5.18902956 Mesomycoplasma 2923352 Bacteria Bacteria 527 3.5999999999999986e-145   NTclustered gi|2713084492|gb|CP150431.1| 2100 g61209 i0 100 19.027972027972 285 0 99 0 2 286 262755 263039 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 5442 527 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3621793 3621793 PRJNA352850_P_NODE_34663_length_442_cov_1.208651_g31832_i0 PRJNA352850 34663 442 1.208651 5.34223742 Mesomycoplasma 2923352 Bacteria Bacteria 817 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g31832 i0 100 101.493212669683 442 0 100 0 1 442 598018 598459 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 44860 817 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3621988 3621988 PRJNA352850_P_NODE_46583_length_359_cov_1.493548_g43750_i0 PRJNA352850 46583 359 1.493548 5.36183732 Mesomycoplasma 2923352 Bacteria Bacteria 664 0   NTclustered gi|2713084492|gb|CP150431.1| 2100 g43750 i0 100 19.091922005571 359 0 100 0 1 359 76182 76540 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 6854 664 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3622395 3622395 PRJNA352850_P_NODE_75303_length_258_cov_1.464115_g72470_i0 PRJNA352850 75303 258 1.464115 3.7774167 Mesomycoplasma 2923352 Bacteria Bacteria 477 3.2699999999999985e-130   NTclustered gi|1720621726|gb|CP035041.1| 2100 g72470 i0 100 15 258 0 100 0 1 258 492194 492451 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3870 477 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
4898874 4898874 PRJNA352850_P_NODE_26424_length_534_cov_1.835052_g23601_i0 PRJNA352850 26424 534 1.835052 9.79917768 Mesomycoplasma 2923352 Bacteria Bacteria 981 0   NTclustered gi|1563681465|emb|LR214949.1| 2100 g23601 i0 99.813 15.5767790262172 534 1 100 0 1 534 298758 298225 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 8318 981 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
6174718 6174718 PRJNA352850_P_NODE_78085_length_253_cov_1.254902_g75252_i0 PRJNA352850 78085 253 1.254902 3.17490206 Mesomycoplasma 2923352 Bacteria Bacteria 468 1.92e-127   NTclustered gi|2713084492|gb|CP150431.1| 2100 g75252 i0 100 15.8735177865613 253 0 100 0 1 253 368149 367897 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 4016 468 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8723881 8723881 PRJNA352850_P_NODE_45687_length_364_cov_0.971429_g42854_i0 PRJNA352850 45687 364 0.971429 3.53600156 Mycoplasmopsis 2767358 Bacteria Bacteria 673 0   NTclustered gi|1874468068|gb|CP058969.1| 28903 g42854 i0 100 100.054945054945 364 0 100 0 1 364 463172 463535 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 36420 673 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
9999349 9999349 PRJNA352850_P_NODE_38888_length_408_cov_1.119777_g36056_i0 PRJNA352850 38888 408 1.119777 4.56869016 Mesomycoplasma 2923352 Bacteria Bacteria 737 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g36056 i0 99.265 15.968137254902 408 3 100 0 1 408 655849 656256 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 6515 743 0.991924629878869 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
11274969 11274969 PRJNA352850_P_NODE_73749_length_261_cov_1.443396_g70916_i0 PRJNA352850 73749 261 1.443396 3.76726356 Mycoplasmopsis 2767358 Bacteria Bacteria 477 3.3099999999999986e-130   NTclustered gi|2496025365|gb|CP123300.1| 28903 g70916 i0 99.617 188.011494252874 261 1 100 0 1 261 482976 483236 Mycoplasmopsis bovis strain 15DD0238 chromosome, complete genome blastn 49071 477 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
11875361 11875361 PRJNA352850_P_NODE_77310_length_254_cov_2.224390_g74477_i0 PRJNA352850 77310 254 2.22439 5.6499506 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 431 2.539999999999999e-116   NTclustered gi|1563796921|emb|LR215008.1| 2107 g74477 i0 97.255 179.066929133858 255 6 100 1 1 254 798409 798155 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 45483 431 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
17648710 17648710 PRJNA352850_P_NODE_30734_length_480_cov_4.229698_g27905_i0 PRJNA352850 30734 480 4.229698 20.3025504 Mollicutes 31969 Bacteria Bacteria 876 0   NTclustered gi|1563681465|emb|LR214949.1| 2100 g27905 i0 99.583 101.160416666667 480 2 100 0 1 480 19701 19222 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 48557 876 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18923148 18923148 PRJNA352850_P_NODE_71855_length_265_cov_0.944444_g69022_i0 PRJNA352850 71855 265 0.944444 2.5027766 Mesomycoplasma 2923352 Bacteria Bacteria 490 4.3299999999999986e-134   NTclustered gi|2713084492|gb|CP150431.1| 2100 g69022 i0 100 15 265 0 100 0 1 265 784673 784409 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3975 490 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
20197121 20197121 PRJNA352850_P_NODE_28956_length_501_cov_1.064159_g26129_i0 PRJNA352850 28956 501 1.064159 5.33143659 Mycoplasmopsis 2767358 Bacteria Bacteria 920 0   NTclustered gi|2111402438|gb|CP068733.1| 28903 g26129 i0 99.8 157.884231536926 501 1 100 0 1 501 10755 11255 Mycoplasmopsis bovis strain J81 chromosome, complete genome blastn 79100 920 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
20197818 20197818 PRJNA352850_P_NODE_7656_length_1335_cov_5.576205_g5623_i0 PRJNA352850 7656 1335 5.576205 74.44233675 Mycoplasmopsis 2767358 Bacteria Bacteria 2466 0   NTclustered gi|1874468068|gb|CP058969.1| 28903 g5623 i0 100 100.041198501873 1335 0 100 0 1 1335 519298 520632 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 133555 2466 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
29853756 29853756 PRJNA352850_P_NODE_37951_length_414_cov_4.630137_g35119_i0 PRJNA352850 37951 414 4.630137 19.16876718 Mycoplasma sp. 2108 Bacteria Bacteria 126 4.41e-31   NR MBQ2349429.1 2108 g35119 i0 65 0.72463768115942 100 34 72.5 1 332 33 429 527 MBQ2349429.1 hypothetical protein [Mycoplasma sp.] diamond 300 126 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.

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