RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA939369" 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

  • PRJNA939369 · 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
25140522 25140522 PRJNA939369_S_NODE_44900_length_267_cov_1.092784_g44483_i0 PRJNA939369 44900 267 1.092784 2.91773328 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 88.2 2.71e-19   NR WP_187150359.1 432608 g44483 i0 76.3 0.662921348314607 59 14 66.3 0 213 37 15 73 WP_187150359.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 177 88.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26644916 26644916 PRJNA939369_S_NODE_56801_length_250_cov_0.870056_g56384_i0 PRJNA939369 56801 250 0.870056 2.17514 Mycoplasma wenyonii 65123 Bacteria Bacteria 143 2.05e-37   NR WP_112665122.1 65123 g56384 i0 98.6 0.876 73 1 87.6 0 225 7 514 586 WP_112665122.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 219 143 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27214487 27214487 PRJNA939369_S_NODE_63322_length_247_cov_0.885057_g62905_i0 PRJNA939369 63322 247 0.885057 2.18609079 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 119 9.71e-33   NR WP_187149895.1 432608 g62905 i0 93.7 0.765182186234818 63 4 76.5 0 191 3 8 70 WP_187149895.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 189 119 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27348285 27348285 PRJNA939369_S_NODE_73943_length_242_cov_0.911243_g73526_i0 PRJNA939369 73943 242 0.911243 2.20520806 Bacillati 1783272 Bacteria Bacteria 53.9 4.21e-6   NR OPZ37538.1 1852922 g73526 i0 46.8 3.58264462809917 77 33 91.7 3 21 242 2 73 OPZ37538.1 MAG: Arabinogalactan endo-1,4-beta-galactosidase precursor [Tenericutes bacterium ADurb.BinA155] diamond 867 53.9 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.BinA155
27657052 27657052 PRJNA939369_S_NODE_68044_length_245_cov_0.895349_g67627_i0 PRJNA939369 68044 245 0.895349 2.19360505 Mycoplasma wenyonii 65123 Bacteria Bacteria 161 4.109999999999999e-48   NR WP_112665740.1 65123 g67627 i0 100 0.991836734693878 81 0 99.2 0 244 2 120 200 WP_112665740.1 hypothetical protein [Mycoplasma wenyonii] diamond 243 161 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27720490 27720490 PRJNA939369_S_NODE_37344_length_282_cov_1.459330_g36927_i0 PRJNA939369 37344 282 1.45933 4.1153106 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 106 4.33e-27   NR WP_187150301.1 432608 g36927 i0 95.2 0.659574468085106 62 2 64.9 1 253 71 2 63 WP_187150301.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 186 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27751792 27751792 PRJNA939369_S_NODE_25724_length_314_cov_1.356846_g25307_i0 PRJNA939369 25724 314 1.356846 4.26049644 Aster yellows phytoplasma 35779 Bacteria Bacteria 50.1 1.07e-5   NR AAO61994.1 35779 g25307 i0 55.3 0.449044585987261 47 21 44.9 0 304 164 12 58 AAO61994.1 conserved hypothetical protein, partial [Aster yellows phytoplasma] diamond 141 50.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Aster yellows phytoplasma
28004429 28004429 PRJNA939369_S_NODE_69605_length_244_cov_0.900585_g69188_i0 PRJNA939369 69605 244 0.900585 2.1974274 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 52.4 1.54e-5   NR HHX80656.1 1898209 g69188 i0 43.1 1.75819672131148 72 41 88.5 0 244 29 572 643 HHX80656.1 tail fiber domain-containing protein [Acholeplasmataceae bacterium] diamond 429 52.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28958617 28958617 PRJNA939369_S_NODE_46468_length_264_cov_1.209424_g46051_i0 PRJNA939369 46468 264 1.209424 3.19287936 root 1 Root_unresolved Root_unresolved 45.4 0.00525   NR MBO5712133.1 2053494 g46051 i0 50 1.20454545454545 38 17 43.2 1 259 146 184 219 MBO5712133.1 hypothetical protein [Acholeplasmatales bacterium] diamond 318 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
29558178 29558178 PRJNA939369_S_NODE_8830_length_443_cov_1.378378_g8413_i0 PRJNA939369 8830 443 1.378378 6.10621454 Bacillati 1783272 Bacteria Bacteria 145 1.57e-39   NR NLK12740.1 2155 g8413 i0 62.8 1.53047404063205 113 42 76.5 0 2 340 197 309 NLK12740.1 hypothetical protein [Phytoplasma sp.] diamond 678 145 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Phytoplasma sp.
29898743 29898743 PRJNA939369_S_NODE_21831_length_329_cov_1.511719_g21414_i0 PRJNA939369 21831 329 1.511719 4.97355551 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 61.2 3.42e-8   NR WP_187150740.1 432608 g21414 i0 59.6 0.474164133738602 52 21 47.4 0 165 10 1073 1124 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 156 61.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29930435 29930435 PRJNA939369_S_NODE_64831_length_246_cov_1.138728_g64414_i0 PRJNA939369 64831 246 1.138728 2.80127088 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 67 1.1e-10   NR WP_187150752.1 432608 g64414 i0 49.3 0.890243902439024 73 36 87.8 1 23 238 741 813 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 219 67 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30025184 30025184 PRJNA939369_S_NODE_70791_length_243_cov_1.582353_g70374_i0 PRJNA939369 70791 243 1.582353 3.84511779 Mycoplasma wenyonii 65123 Bacteria Bacteria 65.1 4.99e-10   NR WP_112665122.1 65123 g70374 i0 60.4 0.654320987654321 53 20 65.4 1 83 241 417 468 WP_112665122.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 159 65.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30056483 30056483 PRJNA939369_S_NODE_38331_length_280_cov_1.115942_g37914_i0 PRJNA939369 38331 280 1.115942 3.1246376 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 50.1 1.57e-4   NR HHT82746.1 1898209 g37914 i0 35.9 2.93571428571429 92 55 98.6 2 280 5 2 89 HHT82746.1 ribonucleoside triphosphate reductase [Acholeplasmataceae bacterium] diamond 822 50.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30561884 30561884 PRJNA939369_S_NODE_64313_length_247_cov_0.862069_g63896_i0 PRJNA939369 64313 247 0.862069 2.12931043 Mycoplasma sp. 2108 Bacteria Bacteria 157 1.5099999999999998e-45   NR MBQ2349600.1 2108 g63896 i0 100 1.96761133603239 81 0 98.4 0 3 245 150 230 MBQ2349600.1 hypothetical protein [Mycoplasma sp.] diamond 486 157 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
31921511 31921511 PRJNA939369_S_NODE_53797_length_252_cov_1.262570_g53380_i0 PRJNA939369 53797 252 1.26257 3.1816764 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 105 2.5699999999999997e-24   NR WP_187150752.1 432608 g53380 i0 62.7 1.97619047619048 83 30 98.8 1 250 2 110 191 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 498 105 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32016419 32016419 PRJNA939369_S_NODE_61338_length_248_cov_0.880000_g60921_i0 PRJNA939369 61338 248 0.88 2.1824 Mycoplasma wenyonii 65123 Bacteria Bacteria 44.7 0.00574   NR WP_146737506.1 65123 g60921 i0 40 0.483870967741935 40 24 48.4 0 63 182 98 137 WP_146737506.1 hypothetical protein [Mycoplasma wenyonii] diamond 120 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32111421 32111421 PRJNA939369_S_NODE_57198_length_250_cov_0.870056_g56781_i0 PRJNA939369 57198 250 0.870056 2.17514 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 142 6.149999999999998e-41   NR WP_187149803.1 432608 g56781 i0 96.1 0.924 77 3 92.4 0 231 1 1 77 WP_187149803.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 231 142 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32340101 32340101 PRJNA939369_S_NODE_579_length_1397_cov_3.269637_g358_i0 PRJNA939369 579 1397 3.269637 45.67682889 FCB group 1783270 Bacteria Bacteria 289 2.85e-85   NR MBR6288242.1 2053494 g358 i0 50.7 1.8167501789549 304 130 63.6 5 15 902 526 817 MBR6288242.1 peptidoglycan-binding protein [Acholeplasmatales bacterium] diamond 2538 291 0.993127147766323 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales 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);;