RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1074408" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1074408 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
12944705 12944705 PRJNA1074408_S_NODE_10171_length_150_cov_0.897196_g10041_i0 PRJNA1074408 10171 150 0.897196 1.345794 Mycoplasma wenyonii 65123 Bacteria Bacteria 83.6 2.63e-17   NR WP_112665764.1 65123 g10041 i0 79.6 0.98 49 10 98 0 149 3 237 285 WP_112665764.1 DnaJ domain-containing protein [Mycoplasma wenyonii] diamond 147 83.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26718876 26718876 PRJNA1074408_S_NODE_7001_length_177_cov_1.067164_g6871_i0 PRJNA1074408 7001 177 1.067164 1.88888028 [Mycoplasma] mobile 2118 Bacteria Bacteria 75.1 2.62e-14   NR WP_011264716.1 2118 g6871 i0 56.9 0.983050847457627 58 25 98.3 0 176 3 140 197 WP_011264716.1 ABC transporter ATP-binding protein [[Mycoplasma] mobile] diamond 174 75.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma [Mycoplasma] mobile
26814380 26814380 PRJNA1074408_S_NODE_7621_length_170_cov_1.511811_g7491_i0 PRJNA1074408 7621 170 1.511811 2.5700787 Malacoplasma sp. 2791014 Bacteria Bacteria 65.5 9.32e-12   NR MDE7075572.1 2791014 g7491 i0 53.6 1.88823529411765 56 26 98.8 0 1 168 36 91 MDE7075572.1 hypothetical protein [Malacoplasma sp.] diamond 321 65.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
27035821 27035821 PRJNA1074408_S_NODE_3282_length_255_cov_1.584906_g3152_i0 PRJNA1074408 3282 255 1.584906 4.0415103 Malacoplasma muris 2119 Bacteria Bacteria 86.7 3.93e-18   NR WP_412032264.1 2119 g3152 i0 53 3.90588235294118 83 39 97.6 0 254 6 76 158 WP_412032264.1 translation elongation factor Ts [Malacoplasma muris] diamond 996 86.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
27352155 27352155 PRJNA1074408_S_NODE_7823_length_168_cov_1.152000_g7693_i0 PRJNA1074408 7823 168 1.152 1.93536 Mycoplasma wenyonii 65123 Bacteria Bacteria 90.9 1.05e-19   NR WP_112665012.1 65123 g7693 i0 85.2 0.964285714285714 54 8 96.4 0 2 163 138 191 WP_112665012.1 hypothetical protein [Mycoplasma wenyonii] diamond 162 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28078060 28078060 PRJNA1074408_S_NODE_5185_length_203_cov_1.500000_g5055_i0 PRJNA1074408 5185 203 1.5 3.045 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 110 2.19e-28   NR WP_187149713.1 432608 g5055 i0 84.8 0.975369458128079 66 10 97.5 0 198 1 10 75 WP_187149713.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 198 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28867472 28867472 PRJNA1074408_S_NODE_3488_length_247_cov_1.176471_g3358_i0 PRJNA1074408 3488 247 1.176471 2.90588337 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 136 2.57e-39   NR WP_187150736.1 432608 g3358 i0 98.4 0.777327935222672 64 1 77.7 0 17 208 1 64 WP_187150736.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 192 136 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29562003 29562003 PRJNA1074408_S_NODE_4870_length_210_cov_1.377246_g4740_i0 PRJNA1074408 4870 210 1.377246 2.8922166 Mycoplasma wenyonii 65123 Bacteria Bacteria 126 8.78e-34   NR WP_112665189.1 65123 g4740 i0 95.7 0.985714285714286 69 3 98.6 0 209 3 1 69 WP_112665189.1 translation elongation factor Ts [Mycoplasma wenyonii] diamond 207 126 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30098901 30098901 PRJNA1074408_S_NODE_1932_length_328_cov_2.635088_g1802_i0 PRJNA1074408 1932 328 2.635088 8.64308864 Mycoplasma sp. 2108 Bacteria Bacteria 44.7 0.0205   NR MBD5445756.1 2108 g1802 i0 48.1 0.475609756097561 52 26 47.6 1 30 185 539 589 MBD5445756.1 hypothetical protein [Mycoplasma sp.] diamond 156 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
30509761 30509761 PRJNA1074408_S_NODE_6233_length_186_cov_1.573427_g6103_i0 PRJNA1074408 6233 186 1.573427 2.92657422 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 102 1.73e-23   NR WP_187150740.1 432608 g6103 i0 100 0.790322580645161 49 0 79 0 147 1 80 128 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 147 102 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31679191 31679191 PRJNA1074408_S_NODE_4057_length_230_cov_1.540107_g3927_i0 PRJNA1074408 4057 230 1.540107 3.5422461 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 62.8 2.78e-9   NR WP_187150740.1 432608 g3927 i0 53.3 0.782608695652174 60 27 78.3 1 3 182 969 1027 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 180 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31805808 31805808 PRJNA1074408_S_NODE_9357_length_154_cov_1.351351_g9227_i0 PRJNA1074408 9357 154 1.351351 2.08108054 Mycoplasma amphoriforme 273136 Bacteria Bacteria 45.8 4.98e-4   NR WP_343251789.1 273136 g9227 i0 38.8 0.954545454545455 49 30 95.5 0 1 147 93 141 WP_343251789.1 CinA family protein [Mycoplasma amphoriforme] diamond 147 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma amphoriforme
32785480 32785480 PRJNA1074408_S_NODE_10080_length_150_cov_1.542056_g9950_i0 PRJNA1074408 10080 150 1.542056 2.313084 Mycoplasma ovis 171632 Bacteria Bacteria 83.6 4.15e-17   NR WP_024071642.1 171632 g9950 i0 81.6 0.98 49 9 98 0 2 148 248 296 WP_024071642.1 type I DNA topoisomerase [Mycoplasma ovis] diamond 147 83.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
32785482 32785482 PRJNA1074408_S_NODE_4460_length_220_cov_1.084746_g4330_i0 PRJNA1074408 4460 220 1.084746 2.3864412 Mycoplasmoides fastidiosum 92758 Bacteria Bacteria 45.1 0.00317   NR WP_256547184.1 92758 g4330 i0 34.4 0.872727272727273 64 42 87.3 0 29 220 108 171 WP_256547184.1 dephospho-CoA kinase [Mycoplasmoides fastidiosum] diamond 192 45.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides fastidiosum

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