RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA785164", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

  • Bacillati · 6 ✖

bioproject 1

  • PRJNA785164 · 6 ✖

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
27906253 27906253 PRJNA785164_P_NODE_39925_length_285_cov_1.688679_g39460_i0 PRJNA785164 39925 285 1.688679 4.81273515 Mycoplasmopsis arginini 2094 Bacteria Bacteria 105 1.0099999999999999e-24   NR MDI3348981.1 2094 g39460 i0 50 3.41052631578947 112 32 92.6 1 266 3 202 313 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 972 105 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29358981 29358981 PRJNA785164_P_NODE_35109_length_306_cov_1.300429_g34644_i0 PRJNA785164 35109 306 1.300429 3.97931274 Mycoplasmopsis arginini 2094 Bacteria Bacteria 96.3 5.51e-23   NR WP_282459086.1 2094 g34644 i0 43.6 0.990196078431373 101 55 97.1 1 304 8 39 139 WP_282459086.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 303 96.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30338477 30338477 PRJNA785164_P_NODE_62332_length_241_cov_0.916667_g61867_i0 PRJNA785164 62332 241 0.916667 2.20916747 Mycoplasmopsis arginini 2094 Bacteria Bacteria 103 6.0999999999999996e-24   NR WP_282460145.1 2094 g61867 i0 66.7 0.933609958506224 75 25 93.4 0 15 239 80 154 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 225 103 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30464809 30464809 PRJNA785164_P_NODE_53113_length_249_cov_1.068182_g52648_i0 PRJNA785164 53113 249 1.068182 2.65977318 Candidatus Pelethenecus sp. 3022886 Bacteria Bacteria 62.4 4.66e-9   NR HRF69841.1 3022886 g52648 i0 37 0.975903614457831 81 50 96.4 1 8 247 411 491 HRF69841.1 hypothetical protein [Candidatus Pelethenecus sp.] diamond 243 62.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes     Candidatus Pelethenecus Candidatus Pelethenecus sp.
32614453 32614453 PRJNA785164_P_NODE_15760_length_502_cov_1.773893_g15295_i0 PRJNA785164 15760 502 1.773893 8.90494286 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 45.1 0.00548   NR MFA5067967.1 3018265 g15295 i0 40.7 0.352589641434263 59 35 35.3 0 428 252 15 73 MFA5067967.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 177 45.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
32686510 32686510 PRJNA785164_P_NODE_12260_length_596_cov_4.481836_g11803_i0 PRJNA785164 12260 596 4.481836 26.71174256 Bacillati 1783272 Bacteria Bacteria 120 4.97e-32   NR WP_369124487.1 2094 g11803 i0 98.2 0.860738255033557 56 1 28.2 0 44 211 1 56 WP_369124487.1 endonuclease domain-containing protein [Mycoplasmopsis arginini] diamond 513 120 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);;