RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1233465 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
25554014 25554014 PRJNA1233465f_S_NODE_162785_length_194_cov_0.931034_g160505_i0 PRJNA1233465 162785 194 0.931034 1.80620596 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 99.8 7.32e-25   NR MDV3146697.1 101513 g160505 i0 70 10.4690721649485 60 18 92.8 0 1 180 66 125 MDV3146697.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 2031 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
25623535 25623535 PRJNA1233465f_S_NODE_253897_length_163_cov_1.657895_g251617_i0 PRJNA1233465 253897 163 1.657895 2.70236885 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 89.7 3.17e-19   NR HHU56010.1 1898209 g251617 i0 86.5 0.957055214723926 52 7 95.7 0 161 6 81 132 HHU56010.1 ATP-binding cassette domain-containing protein [Acholeplasmataceae bacterium] diamond 156 89.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32931473 32931473 PRJNA1233465a_S_NODE_141241_length_200_cov_1.483444_g139967_i0 PRJNA1233465 141241 200 1.483444 2.966888 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 88.6 7.360000000000001e-21   NR HHU55992.1 1898209 g139967 i0 65.6 0.96 64 22 96 0 1 192 8 71 HHU55992.1 ribonuclease P protein component [Acholeplasmataceae bacterium] diamond 192 88.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32941086 32941086 PRJNA1233465f_S_NODE_140961_length_206_cov_1.280255_g138681_i0 PRJNA1233465 140961 206 1.280255 2.6373253 Candidatus Phytoplasma 33926 Bacteria Bacteria 43.9 0.00762   NR MDV3143386.1 101513 g138681 i0 42.6 3.42233009708738 47 27 68.4 0 13 153 79 125 MDV3143386.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 705 43.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32950969 32950969 PRJNA1233465f_S_NODE_119386_length_221_cov_1.889535_g117106_i0 PRJNA1233465 119386 221 1.889535 4.17587235 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 53.1 5.2e-6   NR MDV3143360.1 101513 g117106 i0 49.1 0.773755656108597 57 28 77.4 1 2 172 119 174 MDV3143360.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 171 53.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32968772 32968772 PRJNA1233465f_S_NODE_54858_length_308_cov_3.289575_g52578_i0 PRJNA1233465 54858 308 3.289575 10.131891 Mycoplasma sp. E35C 2801918 Bacteria Bacteria 85.1 4.92e-19   NR WP_222926259.1 2801918 g52578 i0 53.7 0.652597402597403 67 30 65.3 1 201 1 1 66 WP_222926259.1 thioredoxin [Mycoplasma sp. E35C] diamond 201 85.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. E35C
32984781 32984781 PRJNA1233465e_S_NODE_33243_length_306_cov_2.887160_g31933_i0 PRJNA1233465 33243 306 2.88716 8.8347096 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 48.9 2.23e-4   NR MFA5067047.1 3018265 g31933 i0 39.1 0.676470588235294 69 37 62.7 2 201 10 97 165 MFA5067047.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 207 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
32985431 32985431 PRJNA1233465f_S_NODE_208299_length_175_cov_1.190476_g206019_i0 PRJNA1233465 208299 175 1.190476 2.083333 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 45.8 0.00118   NR MDV3193911.1 101513 g206019 i0 52.5 0.685714285714286 40 19 68.6 0 170 51 46 85 MDV3193911.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 120 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33001131 33001131 PRJNA1233465d_S_NODE_17851_length_378_cov_2.474164_g16741_i0 PRJNA1233465 17851 378 2.474164 9.35233992 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 45.1 0.0045   NR MDV3181263.1 2754999 g16741 i0 86.4 0.174603174603175 22 3 17.5 0 298 233 83 104 MDV3181263.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 66 45.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33009391 33009391 PRJNA1233465f_S_NODE_158963_length_196_cov_0.850340_g156683_i0 PRJNA1233465 158963 196 0.85034 1.6666664 root 1 Root_unresolved Root_unresolved 44.7 0.00405   NR MDV3143360.1 101513 g156683 i0 57.1 2.15816326530612 35 15 53.6 0 88 192 172 206 MDV3143360.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 423 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33035117 33035117 PRJNA1233465d_S_NODE_121324_length_169_cov_1.083333_g120213_i0 PRJNA1233465 121324 169 1.083333 1.83083277 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 39.7 0.0384   NR MDV3194015.1 101513 g120213 i0 61.3 0.550295857988166 31 12 55 0 45 137 17 47 MDV3194015.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 93 39.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33036765 33036765 PRJNA1233465f_S_NODE_51604_length_316_cov_3.119850_g49324_i0 PRJNA1233465 51604 316 3.11985 9.858726 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 45.1 0.00265   NR MDV3181263.1 2754999 g49324 i0 86.4 0.208860759493671 22 3 20.9 0 73 138 83 104 MDV3181263.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 66 45.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33036867 33036867 PRJNA1233465f_S_NODE_74460_length_271_cov_0.990991_g72180_i0 PRJNA1233465 74460 271 0.990991 2.68558561 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 110 7.73e-27   NR MDV3183805.1 101513 g72180 i0 55.6 1.99261992619926 90 40 99.6 0 2 271 113 202 MDV3183805.1 DDE-type integrase/transposase/recombinase [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 540 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33051556 33051556 PRJNA1233465b_S_NODE_132461_length_247_cov_11.121212_g130776_i0 PRJNA1233465 132461 247 11.121212 27.46939364 Mycoplasmopsis arginini 2094 Bacteria Bacteria 83.6 1.64e-16   NR WP_206602619.1 2094 g130776 i0 64.8 4.31174089068826 71 25 86.2 0 220 8 484 554 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 1065 83.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
33053727 33053727 PRJNA1233465f_S_NODE_29605_length_398_cov_1.851003_g27338_i0 PRJNA1233465 29605 398 1.851003 7.36699194 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 49.3 3.7e-4   NR MFA5067047.1 3018265 g27338 i0 39.1 0.520100502512563 69 37 48.2 2 189 380 97 165 MFA5067047.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 207 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
33060580 33060580 PRJNA1233465f_S_NODE_83109_length_258_cov_3.133971_g80829_i0 PRJNA1233465 83109 258 3.133971 8.08564518 PVC group 1783257 Bacteria Bacteria 99.8 1.07e-24   NR WP_148695068.1 2094 g80829 i0 87 2.51162790697674 54 7 62.8 0 1 162 78 131 WP_148695068.1 NADH-quinone oxidoreductase subunit J, partial [Mycoplasmopsis arginini] diamond 648 99.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
33069231 33069231 PRJNA1233465d_S_NODE_13669_length_422_cov_3.595174_g12563_i0 PRJNA1233465 13669 422 3.595174 15.17163428 Mycoplasmopsis arginini 2094 Bacteria Bacteria 114 1.24e-26   NR WP_206602619.1 2094 g12563 i0 98.1 2.63744075829384 53 1 37.7 0 6 164 429 481 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 1113 115 0.991304347826087 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
33138310 33138310 PRJNA1233465e_S_NODE_35087_length_299_cov_1.660000_g33777_i0 PRJNA1233465 35087 299 1.66 4.9634 Mycoplasma sp. E35C 2801918 Bacteria Bacteria 79.7 5.84e-17   NR WP_222926259.1 2801918 g33777 i0 55.9 0.591973244147157 59 25 59.2 1 123 299 1 58 WP_222926259.1 thioredoxin [Mycoplasma sp. E35C] diamond 177 79.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. E35C
33145711 33145711 PRJNA1233465d_S_NODE_61863_length_222_cov_2.063584_g60752_i0 PRJNA1233465 61863 222 2.063584 4.58115648 root 1 Root_unresolved Root_unresolved 96.3 3.71e-21   NR WP_206602619.1 2094 g60752 i0 100 2.43243243243243 45 0 60.8 0 48 182 321 365 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 540 96.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
33155909 33155909 PRJNA1233465f_S_NODE_235040_length_167_cov_0.864407_g232760_i0 PRJNA1233465 235040 167 0.864407 1.44355969 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 70.9 1.07e-12   NR MDV3183805.1 101513 g232760 i0 60 0.988023952095808 55 22 98.8 0 1 165 133 187 MDV3183805.1 DDE-type integrase/transposase/recombinase [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 165 70.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33162912 33162912 PRJNA1233465f_S_NODE_57336_length_302_cov_3.581028_g55056_i0 PRJNA1233465 57336 302 3.581028 10.81470456 root 1 Root_unresolved Root_unresolved 96.3 1.09e-20   NR WP_206602619.1 2094 g55056 i0 100 1.78807947019868 45 0 44.7 0 268 134 321 365 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 540 96.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
33172222 33172222 PRJNA1233465e_S_NODE_107432_length_187_cov_1.478261_g106122_i0 PRJNA1233465 107432 187 1.478261 2.76434807 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 69.3 1.55e-12   NR MDV3193991.1 101513 g106122 i0 59.7 1.98930481283422 62 25 99.5 0 187 2 41 102 MDV3193991.1 Ty1/Copia family ribonuclease HI [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 372 69.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33172455 33172455 PRJNA1233465e_S_NODE_31352_length_314_cov_2.366038_g30042_i0 PRJNA1233465 31352 314 2.366038 7.42935932 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 45.1 0.00257   NR MDV3181263.1 2754999 g30042 i0 86.4 0.210191082802548 22 3 21 0 242 177 83 104 MDV3181263.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 66 45.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
33173068 33173068 PRJNA1233465f_S_NODE_202072_length_177_cov_1.351562_g199792_i0 PRJNA1233465 202072 177 1.351562 2.39226474 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 47.8 2.68e-4   NR MDV3143336.1 101513 g199792 i0 39.7 1.06779661016949 63 34 100 1 177 1 61 123 MDV3143336.1 DDE-type integrase/transposase/recombinase [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 189 47.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum

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