RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA966993" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA966993 · 8 ✖

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
942421 942421 PRJNA966993_P_NODE_79101_length_256_cov_1.191257_g78649_i0 PRJNA966993 79101 256 1.191257 3.04961792 Candidatus Phytoplasma fraxini 35780 Bacteria Bacteria 54.7 0.006   NTclustered gi|2714275034|gb|CP146843.1| 35780 g78649 i0 96.875 0.234375 32 1 13 0 212 243 5945 5976 Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome blastn 60 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma fraxini
4770802 4770802 PRJNA966993_P_NODE_78304_length_257_cov_1.597826_g77852_i0 PRJNA966993 78304 257 1.597826 4.10641282 Spiroplasma clarkii 2139 Bacteria Bacteria 52.8 0.023   NTclustered gi|1199760831|gb|CP015819.1| 2139 g77852 i0 100 0.217898832684825 28 0 11 0 169 196 1285735 1285708 Spiroplasma clarkii strain CN-5 chromosome, complete genome blastn 56 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma clarkii
9870681 9870681 PRJNA966993_P_NODE_82188_length_251_cov_1.224719_g81736_i0 PRJNA966993 82188 251 1.224719 3.07404469 Candidatus Hepatoplasma vulgare 3132032 Bacteria Bacteria 60.2 1.36e-4   NTclustered gi|2416256354|dbj|AP027131.1| 3132032 g81736 i0 92.857 0.167330677290837 42 1 16 2 211 251 300786 300746 MAG: Candidatus Hepatoplasma vulgare Av-JP DNA, complete genome blastn 42 60.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Candidatus Hepatoplasmataceae Candidatus Hepatoplasma Candidatus Hepatoplasma vulgare
20068571 20068571 PRJNA966993_P_NODE_100036_length_238_cov_2.406061_g99584_i0 PRJNA966993 100036 238 2.406061 5.72642518 Spiroplasma culicicola 216935 Bacteria Bacteria 54.7 0.006   NTclustered gi|583840421|gb|CP006681.1| 1276246 g99584 i0 100 0.121848739495798 29 0 12 0 33 61 493100 493128 Spiroplasma culicicola AES-1, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma culicicola
20391853 20391853 PRJNA966993_P_NODE_24056_length_429_cov_1.946629_g23609_i0 PRJNA966993 24056 429 1.946629 8.35103841 Spiroplasma 2132 Bacteria Bacteria 54.7 0.012   NTclustered gi|2328117301|dbj|AP026933.1| 2141 g23609 i0 100 0.473193473193473 29 0 7 0 15 43 383291 383319 Spiroplasma ixodetis sHm DNA, complete genome blastn 203 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma ixodetis
28194292 28194292 PRJNA966993_P_NODE_43766_length_326_cov_1.818182_g43314_i0 PRJNA966993 43766 326 1.818182 5.92727332 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 62.4 7.87e-10   NR MCK9289962.1 1898209 g43314 i0 63.6 1.21472392638037 44 16 40.5 0 133 2 8 51 MCK9289962.1 thymidine kinase [Acholeplasmataceae bacterium] diamond 396 62.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28825777 28825777 PRJNA966993_P_NODE_99708_length_240_cov_2.682635_g99256_i0 PRJNA966993 99708 240 2.682635 6.438324 Candidatus Izimaplasma bacterium HR2 1541960 Bacteria Bacteria 45.4 0.00345   NR KFZ26575.1 1541960 g99256 i0 45.6 1.4375 57 31 71.3 0 68 238 178 234 KFZ26575.1 MAG: DNA ligase [Candidatus Izimaplasma bacterium HR2] diamond 345 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR2
30120536 30120536 PRJNA966993_P_NODE_30492_length_384_cov_5.257235_g30040_i0 PRJNA966993 30492 384 5.257235 20.1877824 Candidatus Moeniiplasma glomeromycotorum 1822367 Bacteria Bacteria 62 7.24e-9   NR MCE8162780.1 1822367 g30040 i0 31.3 0.7734375 99 66 77.3 1 358 62 81 177 MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum] diamond 297 62 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Candidatus Moeniiplasma Candidatus Moeniiplasma glomeromycotorum

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