RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA641707 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
21558733 21558733 PRJNA641707_P_NODE_203917_length_196_cov_17.721088_g201254_i0 PRJNA641707 203917 196 17.721088 34.73333248 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 73.9 1.31e-13   NR HXN54616.1 2023991 g201254 i0 50.6 1.33163265306122 87 19 96.4 1 6 194 179 265 HXN54616.1 F0F1 ATP synthase subunit alpha [Mycoplasmatales bacterium] diamond 261 73.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
26998449 26998449 PRJNA641707_P_NODE_310262_length_161_cov_7.991071_g307599_i0 PRJNA641707 310262 161 7.991071 12.86562431 Metamycoplasma 2895509 Bacteria Bacteria 42 0.0211   NR WP_273776244.1 29559 g307599 i0 47.8 2.38509316770186 46 24 85.7 0 145 8 14 59 WP_273776244.1 hypothetical protein [Metamycoplasma hyosynoviae] diamond 384 42.4 0.990566037735849 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hyosynoviae
27175751 27175751 PRJNA641707_P_NODE_268462_length_175_cov_2.126984_g265799_i0 PRJNA641707 268462 175 2.126984 3.722222 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 88.2 3.23e-20   NR MCI9181797.1 2053494 g265799 i0 68.4 0.977142857142857 57 18 97.7 0 5 175 30 86 MCI9181797.1 phosphohydrolase [Acholeplasmatales bacterium] diamond 171 88.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
28786263 28786263 PRJNA641707_P_NODE_221867_length_192_cov_18.916084_g219204_i0 PRJNA641707 221867 192 18.916084 36.31888128 Candidatus Hennigella equi 3083104 Bacteria Bacteria 47 5.95e-4   NR MBQ0045511.1 3083104 g219204 i0 50 1.265625 34 17 53.1 0 125 24 187 220 MBQ0045511.1 [FeFe] hydrogenase, group A [Candidatus Hennigella equi] diamond 243 47 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Candidatus Hennigella Candidatus Hennigella equi
28976097 28976097 PRJNA641707_P_NODE_75628_length_246_cov_12.903553_g72965_i0 PRJNA641707 75628 246 12.903553 31.74274038 Acholeplasma sp. 33015 Bacteria Bacteria 107 1.46e-27   NR HHT55820.1 33015 g72965 i0 73.4 1.9390243902439 79 16 96.3 1 242 6 46 119 HHT55820.1 50S ribosomal protein L10 [Acholeplasma sp.] diamond 477 107 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
29386542 29386542 PRJNA641707_P_NODE_320809_length_157_cov_9.546296_g318146_i0 PRJNA641707 320809 157 9.546296 14.98768472 Mesomycoplasma hyorhinis 2100 Bacteria Bacteria 51.6 6.98e-6   NR WP_146420433.1 2100 g318146 i0 100 0.496815286624204 26 0 49.7 0 154 77 220 245 WP_146420433.1 16S rRNA (cytidine(1402)-2'-O)-methyltransferase [Mesomycoplasma hyorhinis] diamond 78 51.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
30491916 30491916 PRJNA641707_P_NODE_223613_length_192_cov_6.321678_g220950_i0 PRJNA641707 223613 192 6.321678 12.13762176 Candidatus Mycoplasma haematohominis 1494318 Bacteria Bacteria 92 8.09e-20   NR WP_216082922.1 1494318 g220950 i0 70.8 1.015625 65 15 95.3 1 188 6 367 431 WP_216082922.1 DNA-directed RNA polymerase subunit beta [Candidatus Mycoplasma haematohominis] diamond 195 92 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematohominis
30713030 30713030 PRJNA641707_P_NODE_285934_length_168_cov_4.831933_g283271_i0 PRJNA641707 285934 168 4.831933 8.11764744 Mycoplasma mycoides 2102 Bacteria Bacteria 55.1 5.93e-8   NR WP_011166940.1 2102 g283271 i0 50 0.928571428571429 52 26 92.9 0 9 164 5 56 WP_011166940.1 BspA family leucine-rich repeat surface protein [Mycoplasma mycoides] diamond 156 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
31250131 31250131 PRJNA641707_P_NODE_218855_length_193_cov_10.201389_g216192_i0 PRJNA641707 218855 193 10.201389 19.68868077 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 40.4 0.0198   NR MDY0140225.1 3018265 g216192 i0 39.6 0.823834196891192 53 30 79.3 1 34 186 4 56 MDY0140225.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 159 40.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales 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);;