RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA661142" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA661142 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
8281317 8281317 PRJNA661142_P_NODE_1867_length_564_cov_41.796117_g1805_i0 PRJNA661142 1867 564 41.796117 235.73009988 Mycoplasma yeatsii 51365 Bacteria Bacteria 94.4 1.13e-18   NR WP_004429563.1 51365 g1805 i0 58.6 0.526595744680851 99 40 52.7 1 531 235 8 105 WP_004429563.1 BspA family leucine-rich repeat surface protein [Mycoplasma yeatsii] diamond 297 94.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
12107500 12107500 PRJNA661142_P_NODE_230_length_1145_cov_23.381387_g204_i0 PRJNA661142 230 1145 23.381387 267.71688115 Mycoplasma sp. HU2 2108 Bacteria Bacteria 306 6.49e-93   NR WP_050517625.1 1664275 g204 i0 85 0.505676855895197 193 29 50.6 0 941 363 95 287 WP_050517625.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 579 306 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
13382145 13382145 PRJNA661142_P_NODE_1051_length_706_cov_4.748858_g996_i0 PRJNA661142 1051 706 4.748858 33.52693748 Mycoplasma sp. HU2 2108 Bacteria Bacteria 158 8.05e-44   NR WP_201342698.1 1664275 g996 i0 100 1.0070821529745 79 0 33.6 0 699 463 157 235 WP_201342698.1 transposase, partial [Mycoplasma sp. HU2014] diamond 711 158 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
17206189 17206189 PRJNA661142_P_NODE_814_length_773_cov_78.660221_g763_i0 PRJNA661142 814 773 78.660221 608.04350833 Mycoplasma sp. HU2 2108 Bacteria Bacteria 195 6.59e-53   NR WP_050517139.1 1664275 g763 i0 84.7 0.430789133247089 111 17 43.1 0 452 120 943 1053 WP_050517139.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 333 195 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
22305370 22305370 PRJNA661142_P_NODE_1158_length_682_cov_170.586098_g1102_i0 PRJNA661142 1158 682 170.586098 1163.39718836 Mesomycoplasma ovipneumoniae 29562 Bacteria Bacteria 222 2.8299999999999998e-68   NR WP_313319801.1 29562 g1102 i0 67.1 2.08504398826979 158 52 69.5 0 631 158 141 298 WP_313319801.1 Eco57I restriction-modification methylase domain-containing protein [Mesomycoplasma ovipneumoniae] diamond 1422 222 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma ovipneumoniae
24854379 24854379 PRJNA661142_P_NODE_280_length_1091_cov_7.194818_g204_i1 PRJNA661142 280 1091 7.194818 78.49546438 Mycoplasma sp. HU2 2108 Bacteria Bacteria 333 2.45e-103   NR WP_050517625.1 1664275 g204 i1 92.7 0.53070577451879 193 14 53.1 0 151 729 95 287 WP_050517625.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 579 333 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
26701400 26701400 PRJNA661142_P_NODE_9081_length_239_cov_8.142105_g9016_i0 PRJNA661142 9081 239 8.142105 19.45963095 Mycoplasma sp. HU2 2108 Bacteria Bacteria 155 1.9899999999999992e-43   NR WP_201342703.1 1664275 g9016 i0 97.5 0.99163179916318 79 2 99.2 0 237 1 58 136 WP_201342703.1 transposase [Mycoplasma sp. HU2014] diamond 237 155 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
27239348 27239348 PRJNA661142_P_NODE_3423_length_425_cov_20.050532_g3359_i0 PRJNA661142 3423 425 20.050532 85.214761 Mycoplasma yeatsii 51365 Bacteria Bacteria 210 7.77e-64   NR WP_004427752.1 51365 g3359 i0 82.6 0.931764705882353 132 23 93.2 0 396 1 54 185 WP_004427752.1 hypothetical protein [Mycoplasma yeatsii] diamond 396 210 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
27808158 27808158 PRJNA661142_P_NODE_3544_length_418_cov_10.195122_g3480_i0 PRJNA661142 3544 418 10.195122 42.61560996 Mycoplasma sp. HU2 2108 Bacteria Bacteria 159 9.44e-44   NR WP_235443351.1 1664275 g3480 i0 88.8 0.638755980861244 89 10 63.9 0 268 2 47 135 WP_235443351.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 267 159 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
28407894 28407894 PRJNA661142_P_NODE_4686_length_359_cov_15.619355_g4621_i0 PRJNA661142 4686 359 15.619355 56.07348445 Mycoplasma sp. HU2 2108 Bacteria Bacteria 109 1.74e-25   NR WP_050517873.1 1664275 g4621 i0 100 0.467966573816156 56 0 46.8 0 33 200 36 91 WP_050517873.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 168 109 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
29860217 29860217 PRJNA661142_P_NODE_8851_length_245_cov_2.500000_g8786_i0 PRJNA661142 8851 245 2.5 6.125 Mycoplasma sp. HU2 2108 Bacteria Bacteria 69.3 3.59e-13   NR KNG79339.1 1664275 g8786 i0 100 1.10204081632653 30 0 36.7 0 92 3 26 55 KNG79339.1 ISMbov5-related transposase, partial [Mycoplasma sp. HU2014] diamond 270 69.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30429350 30429350 PRJNA661142_P_NODE_9773_length_221_cov_1.186047_g9708_i0 PRJNA661142 9773 221 1.186047 2.62116387 Mycoplasma sp. HU2 2108 Bacteria Bacteria 61.2 1.83e-10   NR WP_050517356.1 1664275 g9708 i0 97 0.447963800904977 33 1 44.8 0 3 101 35 67 WP_050517356.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 99 61.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30681487 30681487 PRJNA661142_P_NODE_6873_length_291_cov_12.454545_g6808_i0 PRJNA661142 6873 291 12.454545 36.24272595 Mycoplasma sp. HU2 2108 Bacteria Bacteria 110 2.38e-28   NR WP_050517805.1 1664275 g6808 i0 81 0.597938144329897 58 11 59.8 0 80 253 5 62 WP_050517805.1 hypothetical protein [Mycoplasma sp. HU2014] diamond 174 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31598590 31598590 PRJNA661142_P_NODE_9376_length_231_cov_5.604396_g9311_i0 PRJNA661142 9376 231 5.604396 12.94615476 Mycoplasma sp. HU2 2108 Bacteria Bacteria 93.2 1.76e-22   NR WP_327138671.1 1664275 g9311 i0 91.5 0.61038961038961 47 4 61 0 142 2 64 110 WP_327138671.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 141 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32199563 32199563 PRJNA661142_P_NODE_6878_length_291_cov_3.652893_g6813_i0 PRJNA661142 6878 291 3.652893 10.62991863 Mycoplasma sp. HU2 2108 Bacteria Bacteria 189 6.67e-59   NR WP_050517732.1 1664275 g6813 i0 100 1 97 0 100 0 291 1 121 217 WP_050517732.1 copper homeostasis protein CutC [Mycoplasma sp. HU2014] diamond 291 189 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32641796 32641796 PRJNA661142_P_NODE_4000_length_392_cov_1.344023_g3935_i0 PRJNA661142 4000 392 1.344023 5.26857016 Mycoplasmopsis arginini 2094 Bacteria Bacteria 87.8 3.19e-17   NR WP_206602619.1 2094 g3935 i0 73.6 2.43367346938776 53 14 40.6 0 115 273 429 481 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 954 87.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32641799 32641799 PRJNA661142_P_NODE_7180_length_284_cov_5.872340_g7115_i0 PRJNA661142 7180 284 5.87234 16.6774456 Mycoplasma sp. HU2 2108 Bacteria Bacteria 142 8.06e-41   NR KNG79401.1 1664275 g7115 i0 100 0.707746478873239 67 0 70.8 0 239 39 1 67 KNG79401.1 ISMmy1-related transposase, partial [Mycoplasma sp. HU2014] diamond 201 142 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32767957 32767957 PRJNA661142_P_NODE_2800_length_471_cov_27.075829_g2737_i0 PRJNA661142 2800 471 27.075829 127.52715459 Mycoplasma sp. HU2 2108 Bacteria Bacteria 207 3.56e-60   NR WP_082160329.1 1664275 g2737 i0 94.2 0.764331210191083 120 7 76.4 0 112 471 40 159 WP_082160329.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 360 207 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32893831 32893831 PRJNA661142_P_NODE_2920_length_460_cov_12.990268_g2857_i0 PRJNA661142 2920 460 12.990268 59.7552328 Mycoplasma cottewii 51364 Bacteria Bacteria 119 5.27e-28   NR WP_259430272.1 51364 g2857 i0 67.4 1.25217391304348 89 28 58 1 125 391 534 621 WP_259430272.1 BspA family leucine-rich repeat surface protein [Mycoplasma cottewii] diamond 576 119 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii

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