RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJEB39643" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB39643 · 9 ✖

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
989453 989453 PRJEB39643_P_NODE_32401_length_326_cov_1.217391_g32208_i0 PRJEB39643 32401 326 1.217391 3.96869466 Mesomycoplasma 2923352 Bacteria Bacteria 52.8 0.031   NTclustered gi|1720621726|gb|CP035041.1| 2100 g32208 i0 100 1.28834355828221 28 0 9 0 7 34 724109 724082 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 420 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
2264790 2264790 PRJEB39643_P_NODE_41662_length_291_cov_7.344037_g41469_i0 PRJEB39643 41662 291 7.344037 21.37114767 Bacteria 2 Bacteria Bacteria 527 3.67e-145   NTclustered gi|1594359169|dbj|LC388759.1| 2135 g41469 i0 99.313 128.020618556701 291 2 100 0 1 291 481 771 Spiroplasma sp. 135_ISE6 gene for 16S rRNA, partial sequence blastn 37254 532 0.990601503759398 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma sp.
7710315 7710315 PRJEB39643_P_NODE_29447_length_339_cov_2.646617_g29254_i0 PRJEB39643 29447 339 2.646617 8.97203163 Candidatus Phytoplasma sacchari 2609813 Bacteria Bacteria 52.8 0.032   NTclustered gi|2421947116|gb|CP115156.1| 2609813 g29254 i0 92.105 0.112094395280236 38 2 11 1 68 105 264534 264570 Candidatus Phytoplasma sacchari strain SCWL1 chromosome, complete genome blastn 38 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma sacchari
7710356 7710356 PRJEB39643_P_NODE_32507_length_325_cov_2.444444_g32314_i0 PRJEB39643 32507 325 2.444444 7.944443 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 65.8 3.92e-6   NTclustered gi|2621786365|emb|OY782823.1| 1898209 g32314 i0 82.051 0.858461538461538 78 12 24 2 75 151 1270007 1269931 MAG: Acholeplasmataceae bacterium isolate 45ae5b24-82d0-47e0-b430-a4ed073fe207 genome assembly, chromosome: 1 blastn 279 65.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
16292149 16292149 PRJEB39643_P_NODE_24573_length_368_cov_2.759322_g24380_i0 PRJEB39643 24573 368 2.759322 10.15430496 Acholeplasma 2147 Bacteria Bacteria 52.8 0.035   NTclustered gi|1403529253|emb|LS483439.1| 2148 g24380 i0 90.244 0.334239130434783 41 2 11 2 174 213 338230 338191 Acholeplasma laidlawii strain NCTC10116 genome assembly, chromosome: 1 blastn 123 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
16634865 16634865 PRJEB39643_P_NODE_41774_length_291_cov_2.614679_g41581_i0 PRJEB39643 41774 291 2.614679 7.60871589 Mesoplasma melaleucae 81459 Bacteria Bacteria 510 3.7e-140   NTclustered gi|1285334491|gb|CP024964.1| 81459 g41581 i0 98.282 155.989690721649 291 5 100 0 1 291 516573 516863 Mesoplasma melaleucae strain M1 chromosome, complete genome blastn 45393 510 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma melaleucae
17909871 17909871 PRJEB39643_P_NODE_68155_length_276_cov_3.054187_g67962_i0 PRJEB39643 68155 276 3.054187 8.42955612 Mycoplasmopsis bovirhinis 29553 Bacteria Bacteria 56.5 0.002   NTclustered gi|1236047677|dbj|AP018135.1| 29553 g67962 i0 100 0.108695652173913 30 0 11 0 230 259 311620 311591 Mycoplasma bovirhinis DNA, complete genome, strain: HAZ141_2 blastn 30 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovirhinis
28037627 28037627 PRJEB39643_P_NODE_35185_length_314_cov_2.377593_g34992_i0 PRJEB39643 35185 314 2.377593 7.46564202 Mycoplasma 2093 Bacteria Bacteria 45.8 0.0045   NR MCR8613436.1 2108 g34992 i0 31.6 1.97770700636943 76 51 72.6 1 28 255 125 199 MCR8613436.1 uracil-DNA glycosylase [Mycoplasma sp.] diamond 621 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
32650343 32650343 PRJEB39643_P_NODE_79140_length_271_cov_1.555556_g78947_i0 PRJEB39643 79140 271 1.555556 4.21555676 Bacteria 2 Bacteria Bacteria 127 4.78e-35   NR MDO9628937.1 1898209 g78947 i0 73.8 2.65682656826568 80 21 88.6 0 241 2 1 80 MDO9628937.1 glutathione peroxidase [Acholeplasmataceae bacterium] diamond 720 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae 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);;