RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA565584", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

  • Bacillati · 8 ✖

bioproject 1

  • PRJNA565584 · 8 ✖

analysis 1

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
27016012 27016012 PRJNA565584_P_NODE_190242_length_246_cov_1.335260_g189090_i0 PRJNA565584 190242 246 1.33526 3.2847396 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 90.1 2.41e-19   NR NMA05205.1 1898209 g189090 i0 52.6 0.951219512195122 78 36 93.9 1 15 245 203 280 NMA05205.1 ribose-phosphate pyrophosphokinase [Acholeplasmataceae bacterium] diamond 234 90.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
27142254 27142254 PRJNA565584_P_NODE_205822_length_243_cov_0.905882_g204670_i0 PRJNA565584 205822 243 0.905882 2.20129326 Acholeplasma oculi 35623 Bacteria Bacteria 87.4 7.2e-18   NR WP_045749794.1 35623 g204670 i0 54.3 1 81 37 100 0 1 243 492 572 WP_045749794.1 InlB B-repeat-containing protein [Acholeplasma oculi] diamond 243 87.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma oculi
27932166 27932166 PRJNA565584_P_NODE_12465_length_940_cov_5.079585_g11482_i0 PRJNA565584 12465 940 5.079585 47.748099 Mycoplasma sp. CAG:472 1262904 Bacteria Bacteria 64.3 4.07e-8   NR CDE37919.1 1262904 g11482 i0 42.3 0.309574468085106 97 44 27.4 4 277 20 108 203 CDE37919.1 ribulose-phosphate 3-epimerase [Mycoplasma sp. CAG:472] diamond 291 64.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. CAG:472
28261438 28261438 PRJNA565584_P_NODE_157306_length_257_cov_2.239130_g156154_i0 PRJNA565584 157306 257 2.23913 5.7545641 Mollicutes 31969 Bacteria Bacteria 53.1 3.32e-6   NR WP_406617768.1 2117 g156154 i0 69.2 7.66926070038911 39 12 45.5 0 6 122 101 139 WP_406617768.1 adenine phosphoribosyltransferase [Mycoplasmopsis lipophila] diamond 1971 53.5 0.992523364485981 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis lipophila
29398299 29398299 PRJNA565584_P_NODE_69649_length_356_cov_1.371025_g68498_i0 PRJNA565584 69649 356 1.371025 4.880849 FCB group 1783270 Bacteria Bacteria 89.7 4.56e-18   NR WP_015637812.1 59748 g68498 i0 45.4 3.29494382022472 108 57 91 1 324 1 123 228 WP_015637812.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Phytoplasma australiense] diamond 1173 89.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australiense
30458905 30458905 PRJNA565584_P_NODE_144053_length_266_cov_1.595855_g142901_i0 PRJNA565584 144053 266 1.595855 4.2449743 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 142 3.94e-41   NR MCI7555106.1 2231116 g142901 i0 70.2 0.947368421052632 84 25 94.7 0 263 12 77 160 MCI7555106.1 hypothetical protein [Mycoplasmatota bacterium] diamond 252 142 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
31849431 31849431 PRJNA565584_P_NODE_60377_length_382_cov_2.349515_g59226_i0 PRJNA565584 60377 382 2.349515 8.9751473 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 81.6 1.52e-15   NR QWB96199.1 2231116 g59226 i0 58.2 1.17801047120419 67 28 52.6 0 84 284 89 155 QWB96199.1 SDR family NAD(P)-dependent oxidoreductase [Mycoplasmatota bacterium] diamond 450 81.6 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
32021365 32021365 PRJNA565584_P_NODE_67298_length_362_cov_1.598616_g66147_i0 PRJNA565584 67298 362 1.598616 5.78698992 Mycoplasma 2093 Bacteria Bacteria 53.9 1.58e-5   NR WP_216567878.1 398174 g66147 i0 27.7 1.85635359116022 112 71 87 2 327 13 44 152 WP_216567878.1 site-specific DNA-methyltransferase [Mycoplasma zalophidermidis] diamond 672 53.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma zalophidermidis

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