RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA642647", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 11 ✖

tax_kingdom 1

  • Bacillati · 11 ✖

bioproject 1

  • PRJNA642647 · 11 ✖

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
27713474 27713474 PRJNA642647_P_NODE_3684_length_185_cov_4.013514_g3634_i0 PRJNA642647 3684 185 4.013514 7.4250009 Mycoplasmopsis arginini 2094 Bacteria Bacteria 96.3 1.2600000000000002e-21   NR WP_282460143.1 2094 g3634 i0 74.6 0.956756756756757 59 15 95.7 0 183 7 262 320 WP_282460143.1 glycosyltransferase family 9 protein, partial [Mycoplasmopsis arginini] diamond 177 96.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27870838 27870838 PRJNA642647_P_NODE_1605_length_275_cov_4.462185_g1555_i0 PRJNA642647 1605 275 4.462185 12.27100875 Mycoplasmopsis arginini 2094 Bacteria Bacteria 119 1.57e-29   NR WP_282460145.1 2094 g1555 i0 64.7 0.927272727272727 85 30 92.7 0 8 262 336 420 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 255 119 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28091910 28091910 PRJNA642647_P_NODE_5025_length_166_cov_2.937984_g4975_i0 PRJNA642647 5025 166 2.937984 4.87705344 Mycoplasmopsis arginini 2094 Bacteria Bacteria 52.4 1.54e-6   NR WP_282459919.1 2094 g4975 i0 96 0.903614457831325 25 1 45.2 0 166 92 84 108 WP_282459919.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 150 52.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29701865 29701865 PRJNA642647_P_NODE_2710_length_211_cov_1.683908_g2660_i0 PRJNA642647 2710 211 1.683908 3.55304588 Mycoplasmopsis arginini 2094 Bacteria Bacteria 57.4 1.42e-7   NR WP_282460165.1 2094 g2660 i0 53.6 1.96208530805687 69 30 98.1 2 3 209 100 166 WP_282460165.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 414 57.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29796838 29796838 PRJNA642647_P_NODE_4231_length_176_cov_1.093525_g4181_i0 PRJNA642647 4231 176 1.093525 1.924604 Candidatus Pelethenecus sp. 3022886 Bacteria Bacteria 56.2 2.6e-7   NR HRF69838.1 3022886 g4181 i0 49.2 1.00568181818182 59 24 97.2 2 173 3 167 221 HRF69838.1 hypothetical protein [Candidatus Pelethenecus sp.] diamond 177 56.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes     Candidatus Pelethenecus Candidatus Pelethenecus sp.
30397707 30397707 PRJNA642647_P_NODE_3553_length_188_cov_2.278146_g3503_i0 PRJNA642647 3553 188 2.278146 4.28291448 Mycoplasmopsis arginini 2094 Bacteria Bacteria 61.2 1.64e-10   NR WP_282460117.1 2094 g3503 i0 84.4 0.51063829787234 32 5 51.1 0 97 2 30 61 WP_282460117.1 ssDNA-binding protein, partial [Mycoplasmopsis arginini] diamond 96 61.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32275122 32275122 PRJNA642647_P_NODE_3258_length_195_cov_2.044304_g3208_i0 PRJNA642647 3258 195 2.044304 3.9863928 Bacteria 2 Bacteria Bacteria 102 2.25e-24   NR MDI3348981.1 2094 g3208 i0 70.3 2.95384615384615 64 19 98.5 0 194 3 121 184 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 576 102 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32420901 32420901 PRJNA642647_P_NODE_3919_length_181_cov_2.930556_g3869_i0 PRJNA642647 3919 181 2.930556 5.30430636 Mycoplasmopsis arginini 2094 Bacteria Bacteria 62 2.33e-9   NR MDI3348981.1 2094 g3869 i0 66.7 1.29281767955801 39 13 64.6 0 1 117 297 335 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 234 62 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32579169 32579169 PRJNA642647_P_NODE_1639_length_271_cov_2.085470_g1589_i0 PRJNA642647 1639 271 2.08547 5.6516237 Mycoplasmopsis arginini 2094 Bacteria Bacteria 142 1.1e-40   NR WP_282460170.1 2094 g1589 i0 78.7 0.985239852398524 89 19 98.5 0 268 2 43 131 WP_282460170.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 267 142 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32641671 32641671 PRJNA642647_P_NODE_1480_length_286_cov_2.626506_g1430_i0 PRJNA642647 1480 286 2.626506 7.51180716 Mycoplasmopsis arginini 2094 Bacteria Bacteria 106 1.2099999999999999e-24   NR WP_282460145.1 2094 g1430 i0 65.1 0.870629370629371 83 27 87.1 1 286 38 270 350 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 249 106 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32767816 32767816 PRJNA642647_P_NODE_3240_length_195_cov_4.094937_g3190_i0 PRJNA642647 3240 195 4.094937 7.98512715 Mycoplasmopsis arginini 2094 Bacteria Bacteria 87.4 2.19e-20   NR MDI3349724.1 2094 g3190 i0 90 1.53846153846154 50 5 76.9 0 195 46 67 116 MDI3349724.1 hypothetical protein [Mycoplasmopsis arginini] diamond 300 87.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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