RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Bacillati · 7 ✖

bioproject 1

  • PRJNA600413 · 7 ✖

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
6245932 6245932 PRJNA600413_P_NODE_38865_length_231_cov_1.384615_g38164_i0 PRJNA600413 38865 231 1.384615 3.19846065 Candidatus Phytoplasma 33926 Bacteria Bacteria 422 1.37e-113   NTclustered gi|2445403178|gb|OQ448205.1| 2155 g38164 i0 99.567 100 231 1 100 0 1 231 414 184 Candidatus Phytoplasma sp. clone Yazd 16S ribosomal RNA gene, partial sequence blastn 23100 422 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Phytoplasma sp.
8794919 8794919 PRJNA600413_P_NODE_28267_length_267_cov_1.307339_g27566_i0 PRJNA600413 28267 267 1.307339 3.49059513 Mollicutes 31969 Bacteria Bacteria 488 1.5699999999999998e-133   NTclustered gi|1958638472|gb|MW498281.1| 2100 g27566 i0 99.625 99.9026217228464 267 1 100 0 1 267 1208 942 Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence blastn 26674 488 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
13327394 13327394 PRJNA600413_P_NODE_146031_length_161_cov_0.910714_g145330_i0 PRJNA600413 146031 161 0.910714 1.46624954 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 135 1.2900000000000002e-27   NTclustered gi|2187163482|emb|OV788640.1| 658143 g145330 i0 82.099 4.80745341614907 162 26 100 3 1 161 373498 373657 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 774 135 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
19699546 19699546 PRJNA600413_P_NODE_118916_length_165_cov_0.879310_g118215_i0 PRJNA600413 118916 165 0.87931 1.4508615 Spiroplasma endosymbiont of Virgichneumon dumeticola 3139323 Bacteria Bacteria 99 1.75e-16   NTclustered gi|2806755735|emb|OZ183478.1| 3139323 g118215 i0 77.778 0.981818181818182 162 34 98 2 3 163 1381655 1381495 Spiroplasma endosymbiont of Virgichneumon dumeticola isolate 1d0b8646-e6ec-424d-883d-cc2662152a42 genome assembly, chromosome: 1 blastn 162 99 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Virgichneumon dumeticola
30377960 30377960 PRJNA600413_P_NODE_21932_length_304_cov_1.792157_g21231_i0 PRJNA600413 21932 304 1.792157 5.44815728 Bacillati 1783272 Bacteria Bacteria 48.9 3.26e-4   NR WP_044635349.1 86660 g21231 i0 37.5 2.52631578947368 64 32 60.2 2 120 302 35 93 WP_044635349.1 adenylate kinase family protein [Mesomycoplasma dispar] diamond 768 48.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma dispar
31407269 31407269 PRJNA600413_P_NODE_41556_length_225_cov_0.869318_g40855_i0 PRJNA600413 41556 225 0.869318 1.9559655 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 106 5.74e-25   NR MCK9234807.1 1898209 g40855 i0 63.5 0.986666666666667 74 27 98.7 0 225 4 220 293 MCK9234807.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 222 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32419534 32419534 PRJNA600413_P_NODE_114279_length_166_cov_0.871795_g113578_i0 PRJNA600413 114279 166 0.871795 1.4471797 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 96.3 1.8300000000000003e-21   NR HXN54441.1 2023991 g113578 i0 76.4 0.993975903614458 55 13 99.4 0 166 2 236 290 HXN54441.1 reverse transcriptase family protein [Mycoplasmatales bacterium] diamond 165 96.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales 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);;