RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA870096" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA870096 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
3400661 3400661 PRJNA870096_S_NODE_21923_length_386_cov_3.481050_g20263_i0 PRJNA870096 21923 386 3.48105 13.436853 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 63.5 8.92e-9   NR HXN54563.1 2023991 g20263 i0 42.2 0.645077720207254 83 42 59.8 1 28 258 360 442 HXN54563.1 NADH-quinone oxidoreductase subunit M [Mycoplasmatales bacterium] diamond 249 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
3401448 3401448 PRJNA870096_S_NODE_8863_length_622_cov_3.428325_g7357_i0 PRJNA870096 8863 622 3.428325 21.3241815 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 78.6 7.54e-15   NR HXN54406.1 2023991 g7357 i0 48.8 0.405144694533762 84 43 40.5 0 601 350 29 112 HXN54406.1 30S ribosomal protein S13 [Mycoplasmatales bacterium] diamond 252 78.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
5952774 5952774 PRJNA870096_S_NODE_11945_length_533_cov_7.402041_g10340_i0 PRJNA870096 11945 533 7.402041 39.45287853 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 163 1.77e-48   NR HXN54586.1 2023991 g10340 i0 69.7 0.613508442776735 109 33 61.4 0 206 532 11 119 HXN54586.1 30S ribosomal protein S12 [Mycoplasmatales bacterium] diamond 327 163 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
15265250 15265250 PRJNA870096_S_NODE_4132_length_918_cov_10.784000_g3136_i0 PRJNA870096 4132 918 10.784 98.99712 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 288 1.7e-92   NR HXN54616.1 2023991 g3136 i0 74.1 0.630718954248366 193 50 63.1 0 892 314 93 285 HXN54616.1 F0F1 ATP synthase subunit alpha [Mycoplasmatales bacterium] diamond 579 288 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
26675041 26675041 PRJNA870096_S_NODE_107001_length_171_cov_1.820312_g105337_i0 PRJNA870096 107001 171 1.820312 3.11273352 Mycoplasma wenyonii 65123 Bacteria Bacteria 72 5e-13   NR WP_258393892.1 65123 g105337 i0 92.1 0.666666666666667 38 3 66.7 0 58 171 164 201 WP_258393892.1 DHH family phosphoesterase [Mycoplasma wenyonii] diamond 114 72 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26675051 26675051 PRJNA870096_S_NODE_91481_length_184_cov_1.361702_g89817_i0 PRJNA870096 91481 184 1.361702 2.50553168 Candidatus Ureaplasma intestinipullorum 2838770 Bacteria Bacteria 86.7 3.76e-18   NR MBU3830945.1 2838770 g89817 i0 63.3 0.978260869565217 60 22 97.8 0 182 3 308 367 MBU3830945.1 tRNA 4-thiouridine(8) synthase ThiI [Candidatus Ureaplasma intestinipullorum] diamond 180 86.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Candidatus Ureaplasma intestinipullorum
26936636 26936636 PRJNA870096_S_NODE_123322_length_160_cov_1.948718_g121658_i0 PRJNA870096 123322 160 1.948718 3.1179488 Bacteria 2 Bacteria Bacteria 44.3 0.00155   NR HXN54566.1 2023991 g121658 i0 34.7 1.85625 49 32 91.9 0 8 154 63 111 HXN54566.1 hypothetical protein [Mycoplasmatales bacterium] diamond 297 44.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
28097422 28097422 PRJNA870096_S_NODE_143505_length_151_cov_0.888889_g141841_i0 PRJNA870096 143505 151 0.888889 1.34222239 Mycoplasma wenyonii 65123 Bacteria Bacteria 60.8 4.14e-9   NR WP_112665167.1 65123 g141841 i0 100 0.576158940397351 29 0 57.6 0 63 149 500 528 WP_112665167.1 amino acid--tRNA ligase-related protein [Mycoplasma wenyonii] diamond 87 60.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28286703 28286703 PRJNA870096_S_NODE_101626_length_175_cov_1.901515_g99962_i0 PRJNA870096 101626 175 1.901515 3.32765125 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 63.9 5.07e-10   NR WP_187150752.1 432608 g99962 i0 56.1 0.977142857142857 57 25 97.7 0 172 2 259 315 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 171 63.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28823394 28823394 PRJNA870096_S_NODE_146908_length_150_cov_0.897196_g145244_i0 PRJNA870096 146908 150 0.897196 1.345794 Mycoplasma ovis 171632 Bacteria Bacteria 83.2 5.84e-17   NR WP_024071349.1 171632 g145244 i0 79.6 0.98 49 10 98 0 150 4 419 467 WP_024071349.1 sigma-70 family RNA polymerase sigma factor [Mycoplasma ovis] diamond 147 83.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
28855082 28855082 PRJNA870096_S_NODE_20808_length_397_cov_4.485876_g19148_i0 PRJNA870096 20808 397 4.485876 17.80892772 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 102 3.7e-25   NR HXN54402.1 2023991 g19148 i0 44.2 0.974811083123426 129 71 96.7 1 8 391 1 129 HXN54402.1 30S ribosomal protein S8 [Mycoplasmatales bacterium] diamond 387 102 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
29265514 29265514 PRJNA870096_S_NODE_27429_length_343_cov_5.240000_g25765_i0 PRJNA870096 27429 343 5.24 17.9732 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 54.7 5.24e-6   NR HXN54449.1 2023991 g25765 i0 46.2 0.454810495626822 52 28 45.5 0 106 261 93 144 HXN54449.1 30S ribosomal protein S2 [Mycoplasmatales bacterium] diamond 156 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
29265525 29265525 PRJNA870096_S_NODE_83929_length_192_cov_1.046980_g82265_i0 PRJNA870096 83929 192 1.04698 2.0102016 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 130 3.66e-34   NR WP_281178727.1 432608 g82265 i0 98.4 1 64 1 100 0 1 192 350 413 WP_281178727.1 MFS transporter [Candidatus Mycoplasma haematobovis] diamond 192 130 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29549696 29549696 PRJNA870096_S_NODE_5810_length_777_cov_4.024523_g4563_i0 PRJNA870096 5810 777 4.024523 31.27054371 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 67.4 4.07e-9   NR HXN54601.1 2023991 g4563 i0 32.8 0.494208494208494 128 86 49.4 0 388 5 117 244 HXN54601.1 hypothetical protein [Mycoplasmatales bacterium] diamond 384 67.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
29992061 29992061 PRJNA870096_S_NODE_106271_length_172_cov_1.116279_g104607_i0 PRJNA870096 106271 172 1.116279 1.91999988 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 73.2 2.58e-13   NR WP_187150752.1 432608 g104607 i0 66.7 0.994186046511628 57 18 97.7 1 170 3 903 959 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 171 73.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29992067 29992067 PRJNA870096_S_NODE_41751_length_274_cov_2.774892_g40087_i0 PRJNA870096 41751 274 2.774892 7.60320408 Mycoplasma sp. HU2 2108 Bacteria Bacteria 135 3.52e-39   NR WP_050517313.1 1664275 g40087 i0 100 0.821167883211679 75 0 82.1 0 50 274 1 75 WP_050517313.1 hypothetical protein, partial [Mycoplasma sp. HU2014] diamond 225 135 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30529038 30529038 PRJNA870096_S_NODE_34413_length_304_cov_2.977011_g32749_i0 PRJNA870096 34413 304 2.977011 9.05011344 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 79 7.9e-16   NR HXN54403.1 2023991 g32749 i0 42.6 0.996710526315789 101 57 98.7 1 304 5 63 163 HXN54403.1 hypothetical protein [Mycoplasmatales bacterium] diamond 303 79 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
30592236 30592236 PRJNA870096_S_NODE_57233_length_232_cov_1.523810_g55569_i0 PRJNA870096 57233 232 1.52381 3.5352392 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 52 3.74e-6   NR HXN54411.1 2023991 g55569 i0 60 0.452586206896552 35 14 45.3 0 208 104 92 126 HXN54411.1 uL14 family ribosomal protein [Mycoplasmatales bacterium] diamond 105 52 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
31509071 31509071 PRJNA870096_S_NODE_69736_length_210_cov_1.119760_g68072_i0 PRJNA870096 69736 210 1.11976 2.351496 Mycoplasma wenyonii 65123 Bacteria Bacteria 87.8 4.9300000000000006e-21   NR RAO94856.1 65123 g68072 i0 100 0.614285714285714 43 0 61.4 0 23 151 15 57 RAO94856.1 TrkH family potassium uptake protein, partial [Mycoplasma wenyonii] diamond 129 87.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31920138 31920138 PRJNA870096_S_NODE_17557_length_434_cov_20.398977_g15909_i0 PRJNA870096 17557 434 20.398977 88.53156018 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 101 3.88e-25   NR HXN54605.1 2023991 g15909 i0 69.1 0.559907834101382 81 25 56 0 338 96 1 81 HXN54605.1 ATP synthase subunit C family protein [Mycoplasmatales bacterium] diamond 243 101 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
32015043 32015043 PRJNA870096_S_NODE_144078_length_151_cov_0.888889_g142414_i0 PRJNA870096 144078 151 0.888889 1.34222239 Mycoplasma wenyonii 65123 Bacteria Bacteria 43.9 0.00311   NR WP_112665163.1 65123 g142414 i0 72.4 0.576158940397351 29 8 57.6 0 127 41 116 144 WP_112665163.1 hypothetical protein [Mycoplasma wenyonii] diamond 87 43.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32836279 32836279 PRJNA870096_S_NODE_37200_length_292_cov_1.682731_g35536_i0 PRJNA870096 37200 292 1.682731 4.91357452 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 63.9 2.4e-9   NR HXN54413.1 2023991 g35536 i0 51.7 0.595890410958904 58 28 59.6 0 175 2 664 721 HXN54413.1 hypothetical protein [Mycoplasmatales bacterium] diamond 174 63.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales 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);;