RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1215774" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1215774 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
5434749 5434749 PRJNA1215774_P_NODE_75945_length_246_cov_1.335260_g75625_i0 PRJNA1215774 75945 246 1.33526 3.2847396 Mycoplasma sp. HU2 2108 Bacteria Bacteria 108 3.51e-25   NR WP_050517820.1 1664275 g75625 i0 93.5 0.75609756097561 62 4 75.6 0 59 244 381 442 WP_050517820.1 HsdM family class I SAM-dependent methyltransferase [Mycoplasma sp. HU2014] diamond 186 108 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
6148601 6148601 PRJNA1215774_P_NODE_79705_length_244_cov_0.900585_g79385_i0 PRJNA1215774 79705 244 0.900585 2.1974274 Mycoplasma sp. HU2 2108 Bacteria Bacteria 115 1.12e-30   NR WP_050517634.1 1664275 g79385 i0 100 0.725409836065574 59 0 72.5 0 29 205 82 140 WP_050517634.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 177 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
25271672 25271672 PRJNA1215774_P_NODE_18980_length_496_cov_1.274232_g18661_i0 PRJNA1215774 18980 496 1.274232 6.32019072 Mycoplasma sp. HU2 2108 Bacteria Bacteria 202 6.910000000000001e-58   NR WP_082160329.1 1664275 g18661 i0 85.7 1.35483870967742 112 16 67.7 0 365 30 248 359 WP_082160329.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 672 202 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
27325588 27325588 PRJNA1215774_P_NODE_5243_length_961_cov_2.514640_g4987_i0 PRJNA1215774 5243 961 2.51464 24.1656904 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 302 1.89e-100   NR WP_322536767.1 2107 g4987 i0 98.8 0.527575442247659 169 2 52.8 0 700 194 1 169 WP_322536767.1 hypothetical protein [Mycoplasmopsis pulmonis] diamond 507 302 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
27515065 27515065 PRJNA1215774_P_NODE_48323_length_303_cov_1.921739_g48003_i0 PRJNA1215774 48323 303 1.921739 5.82286917 Mycoplasma sp. HU2 2108 Bacteria Bacteria 171 5.59e-51   NR WP_050517684.1 1664275 g48003 i0 99 1 101 1 100 0 303 1 44 144 WP_050517684.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 303 171 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
28367429 28367429 PRJNA1215774_P_NODE_65586_length_257_cov_1.673913_g65266_i0 PRJNA1215774 65586 257 1.673913 4.30195641 Mycoplasma sp. HU2 2108 Bacteria Bacteria 133 1.64e-38   NR WP_050517821.1 1664275 g65266 i0 87 0.898832684824903 77 10 89.9 0 232 2 11 87 WP_050517821.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 231 133 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
29125608 29125608 PRJNA1215774_P_NODE_10949_length_662_cov_2.056027_g10638_i0 PRJNA1215774 10949 662 2.056027 13.61089874 Mycoplasma sp. HU2 2108 Bacteria Bacteria 162 6.96e-48   NR WP_050517747.1 1664275 g10638 i0 95.8 0.435045317220544 96 4 43.5 0 345 58 1 96 WP_050517747.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 288 162 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
29333584 29333584 PRJNA1215774_P_NODE_73369_length_248_cov_0.880000_g73049_i0 PRJNA1215774 73369 248 0.88 2.1824 FCB group 1783270 Bacteria Bacteria 50.4 6.89e-5   NR WP_027121981.1 29560 g73049 i0 38.8 5.85483870967742 49 30 59.3 0 148 2 229 277 WP_027121981.1 DnaJ domain-containing protein [[Mycoplasma] imitans] diamond 1452 50.8 0.992125984251969 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides [Mycoplasma] imitans
30672873 30672873 PRJNA1215774_P_NODE_70173_length_250_cov_0.870056_g69853_i0 PRJNA1215774 70173 250 0.870056 2.17514 Mycoplasma sp. HU2 2108 Bacteria Bacteria 168 3.02e-50   NR WP_050517386.1 1664275 g69853 i0 100 0.972 81 0 97.2 0 248 6 171 251 WP_050517386.1 alpha/beta fold hydrolase [Mycoplasma sp. HU2014] diamond 243 168 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30989082 30989082 PRJNA1215774_P_NODE_60554_length_269_cov_2.122449_g60234_i0 PRJNA1215774 60554 269 2.122449 5.70938781 Mycoplasma sp. HU2 2108 Bacteria Bacteria 164 1.4499999999999998e-47   NR WP_050517532.1 1664275 g60234 i0 98.9 0.992565055762082 89 1 99.3 0 269 3 196 284 WP_050517532.1 lipoprotein [Mycoplasma sp. HU2014] diamond 267 164 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31178254 31178254 PRJNA1215774_P_NODE_60275_length_270_cov_1.563452_g59955_i0 PRJNA1215774 60275 270 1.563452 4.2213204 Mycoplasma sp. HU2 2108 Bacteria Bacteria 155 4.66e-43   NR WP_050517540.1 1664275 g59955 i0 97.8 0.988888888888889 89 2 98.9 0 3 269 205 293 WP_050517540.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 267 155 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31400058 31400058 PRJNA1215774_P_NODE_55676_length_282_cov_1.277512_g55356_i0 PRJNA1215774 55676 282 1.277512 3.60258384 Mycoplasma sp. HU2 2108 Bacteria Bacteria 147 1.32e-38   NR WP_050517788.1 1664275 g55356 i0 81.1 0.957446808510638 90 17 95.7 0 11 280 511 600 WP_050517788.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 270 147 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31589850 31589850 PRJNA1215774_P_NODE_49236_length_300_cov_1.925110_g48916_i0 PRJNA1215774 49236 300 1.92511 5.77533 Mycoplasma sp. HU2 2108 Bacteria Bacteria 95.5 1.9e-22   NR WP_050517464.1 1664275 g48916 i0 97.8 0.45 45 1 45 0 255 121 72 116 WP_050517464.1 Panacea domain-containing protein [Mycoplasma sp. HU2014] diamond 135 95.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31842554 31842554 PRJNA1215774_P_NODE_83577_length_241_cov_1.833333_g83257_i0 PRJNA1215774 83577 241 1.833333 4.41833253 Spiroplasma phoeniceum 47835 Bacteria Bacteria 84.3 4.45e-17   NR WP_114565136.1 47835 g83257 i0 51.3 0.970954356846473 78 36 97.1 1 2 235 127 202 WP_114565136.1 HNH endonuclease signature motif containing protein [Spiroplasma phoeniceum] diamond 234 84.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma phoeniceum
32127672 32127672 PRJNA1215774_P_NODE_22058_length_457_cov_1.804688_g21738_i0 PRJNA1215774 22058 457 1.804688 8.24742416 Mycoplasma sp. HU2 2108 Bacteria Bacteria 207 1.09e-59   NR WP_050517626.1 1664275 g21738 i0 87 0.807439824945295 123 16 80.7 0 436 68 270 392 WP_050517626.1 MAG6410 family transglutaminase-related lipoprotein [Mycoplasma sp. HU2014] diamond 369 207 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32539027 32539027 PRJNA1215774_P_NODE_45539_length_312_cov_2.259414_g45219_i0 PRJNA1215774 45539 312 2.259414 7.04937168 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 79.3 1.28e-16   NR WP_322536765.1 2107 g45219 i0 80.4 0.490384615384615 51 10 49 0 2 154 61 111 WP_322536765.1 phage holin [Mycoplasmopsis pulmonis] diamond 153 79.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
32853722 32853722 PRJNA1215774_P_NODE_60740_length_269_cov_1.413265_g60420_i0 PRJNA1215774 60740 269 1.413265 3.80168285 Mycoplasma sp. HU2 2108 Bacteria Bacteria 43.5 0.0271   NR WP_235443359.1 1664275 g60420 i0 97.1 0.769516728624535 69 2 77 0 269 63 161 229 WP_235443359.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 207 43.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014

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