RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 12 ✖

bioproject 1

  • PRJNA533114 · 12 ✖

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
1780278 1780278 PRJNA533114_P_NODE_31002_length_410_cov_3.459941_g30750_i0 PRJNA533114 31002 410 3.459941 14.1857581 Spiroplasma poulsonii 2138 Bacteria Bacteria 54.7 0.011   NTclustered gi|2208028686|gb|CP093052.1| 2138 g30750 i0 100 0.0707317073170732 29 0 7 0 348 376 3223 3251 Spiroplasma poulsonii strain sHy plasmid unnamed5, complete sequence blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma poulsonii
6882448 6882448 PRJNA533114_P_NODE_23866_length_464_cov_2.148338_g23616_i0 PRJNA533114 23866 464 2.148338 9.96828832 Spiroplasma turonicum 216946 Bacteria Bacteria 58.4 0.001   NTclustered gi|973724893|gb|CP013860.1| 216946 g23616 i0 97.059 0.146551724137931 34 1 7 0 258 291 427364 427397 Spiroplasma turonicum strain Tab4c chromosome, complete genome blastn 68 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma turonicum
6882987 6882987 PRJNA533114_P_NODE_59686_length_308_cov_1.638298_g59434_i0 PRJNA533114 59686 308 1.638298 5.04595784 Mycoplasmopsis lipophila 2117 Bacteria Bacteria 52.8 0.029   NTclustered gi|2860286954|gb|CP174165.1| 2117 g59434 i0 96.875 0.103896103896104 32 0 10 1 36 66 240420 240389 Mycoplasmopsis lipophila strain MaBy chromosome, complete genome blastn 32 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis lipophila
9433837 9433837 PRJNA533114_P_NODE_78548_length_273_cov_2.310000_g78296_i0 PRJNA533114 78548 273 2.31 6.3063 Mycoplasmopsis bovis 28903 Bacteria Bacteria 52.8 0.025   NTclustered gi|1951472368|gb|CP058456.1| 28903 g78296 i0 100 0.102564102564103 28 0 10 0 67 94 911279 911252 Mycoplasmopsis bovis strain Mb51 chromosome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
15145584 15145584 PRJNA533114_P_NODE_10592_length_694_cov_1.123994_g10360_i0 PRJNA533114 10592 694 1.123994 7.80051836 Mollicutes 31969 Bacteria Bacteria 82.4 8.84e-11   NTclustered gi|1563802930|emb|LR215035.1| 171279 g10360 i0 87.324 5.00432276657061 71 9 10 0 478 548 451169 451099 Mycoplasma anatis strain NCTC10156 genome assembly, chromosome: 1 blastn 3473 82.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis anatis
17082509 17082509 PRJNA533114_P_NODE_43294_length_354_cov_2.188612_g43042_i0 PRJNA533114 43294 354 2.188612 7.74768648 Mycoplasmopsis bovis 28903 Bacteria Bacteria 52.8 0.033   NTclustered gi|1607238104|dbj|AP019558.1| 28903 g43042 i0 100 0.0790960451977401 28 0 8 0 281 308 612696 612669 Mycoplasma bovis KG4397 DNA, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
17082920 17082920 PRJNA533114_P_NODE_7834_length_798_cov_8.765517_g7629_i0 PRJNA533114 7834 798 8.765517 69.94882566 Candidatus Phytoplasma cynodontis 72990 Bacteria Bacteria 63.9 3.7e-5   NTclustered gi|2511947619|gb|CP126225.1| 72990 g7629 i0 95.122 0.0889724310776942 41 1 5 1 288 328 483878 483917 MAG: Candidatus Phytoplasma cynodontis isolate GY2015 chromosome, complete genome blastn 71 63.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma cynodontis
21519614 21519614 PRJNA533114_P_NODE_51837_length_328_cov_1.207843_g51585_i0 PRJNA533114 51837 328 1.207843 3.96172504 Acholeplasma 2147 Bacteria Bacteria 52.8 0.031   NTclustered gi|1403529253|emb|LS483439.1| 2148 g51585 i0 90.244 0.375 41 2 12 2 7 46 338230 338191 Acholeplasma laidlawii strain NCTC10116 genome assembly, chromosome: 1 blastn 123 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
23457065 23457065 PRJNA533114_P_NODE_26899_length_439_cov_2.262295_g26647_i0 PRJNA533114 26899 439 2.262295 9.93147505 Mycoplasmopsis arginini 2094 Bacteria Bacteria 270 1.0799999999999999e-67   NTclustered gi|761597645|dbj|AP014657.1| 2094 g26647 i0 82.043 68.5239179954442 323 52 73 4 119 438 630467 630786 Mycoplasma arginini DNA, complete genome, strain: HAZ145_1 blastn 30082 270 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29256319 29256319 PRJNA533114_P_NODE_105569_length_247_cov_0.885057_g105317_i0 PRJNA533114 105569 247 0.885057 2.18609079 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 49.7 1.31e-4   NR HHZ17997.1 1898209 g105317 i0 57.4 1.04453441295547 47 18 54.7 2 215 81 27 73 HHZ17997.1 molecular chaperone DnaJ [Acholeplasmataceae bacterium] diamond 258 49.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31088737 31088737 PRJNA533114_P_NODE_59635_length_308_cov_1.910638_g59383_i0 PRJNA533114 59635 308 1.910638 5.88476504 Tenericutes bacterium HGW-Tenericutes-3 2013846 Bacteria Bacteria 46.6 0.00359   NR PKK97495.1 2013846 g59383 i0 29.2 0.866883116883117 89 57 86.7 1 298 32 150 232 PKK97495.1 MAG: hypothetical protein CVV58_00985 [Tenericutes bacterium HGW-Tenericutes-3] diamond 267 46.6 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium HGW-Tenericutes-3
31815942 31815942 PRJNA533114_P_NODE_105257_length_247_cov_0.885057_g105005_i0 PRJNA533114 105257 247 0.885057 2.18609079 Mycoplasma sp. 2108 Bacteria Bacteria 78.2 1.27e-14   NR MBP5256944.1 2108 g105005 i0 50 0.97165991902834 80 38 97.2 1 242 3 137 214 MBP5256944.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Mycoplasma sp.] diamond 240 78.2 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);;