RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA312615", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 21 ✖

tax_phylum 1

  • Mycoplasmatota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312615 · 21 ✖

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
2339161 2339161 PRJNA312615_P_NODE_34882_length_208_cov_0.867925_g34731_i0 PRJNA312615 34882 208 0.867925 1.8052840000000001 Mesomycoplasma 2923352 Bacteria Bacteria 359 9.59e-95   NTclustered gi|1450419971|emb|LS991950.1| 2100 g34731 i0 97.63 419.600961538462 211 2 100 2 1 208 159455 159245 Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1 blastn 87277 359 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
2928783 2928783 PRJNA312615_P_NODE_28843_length_228_cov_1.139665_g28692_i0 PRJNA312615 28843 228 1.139665 2.5984362 Mycoplasma capricolum 2095 Bacteria Bacteria 178 3.21e-40   NTclustered gi|1822115773|gb|CP041701.1| 40480 g28692 i0 82.915 7.85526315789474 199 33 87 1 31 228 334369 334567 Mycoplasma capricolum subsp. capripneumoniae strain 8991 chromosome, complete genome blastn 1791 178 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma capricolum
3614741 3614741 PRJNA312615_P_NODE_55483_length_164_cov_0.886957_g55332_i0 PRJNA312615 55483 164 0.886957 1.45460948 Mycoplasmopsis 2767358 Bacteria Bacteria 193 7.73e-45   NTclustered gi|1874468068|gb|CP058969.1| 28903 g55332 i0 87.805 52.280487804878 164 20 100 0 1 164 575316 575479 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 8574 193 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
6755656 6755656 PRJNA312615_P_NODE_23106_length_254_cov_0.839024_g22955_i0 PRJNA312615 23106 254 0.839024 2.13112096 Mycoplasma cottewii 51364 Bacteria Bacteria 359 1.21e-94   NTclustered gi|2294785939|gb|CP103424.1| 51364 g22955 i0 94.068 0.929133858267717 236 14 93 0 2 237 524074 524309 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 236 359 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
7441606 7441606 PRJNA312615_P_NODE_11466_length_365_cov_1.212025_g11316_i0 PRJNA312615 11466 365 1.212025 4.42389125 Mycoplasma 2093 Bacteria Bacteria 263 1.47e-65   NTclustered gi|1450425804|emb|LS991954.1| 2123 g11316 i0 80.347 3.83835616438356 346 68 95 0 15 360 642209 642554 Mycoplasma putrefaciens strain NCTC10155 genome assembly, chromosome: 1 blastn 1401 263 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma putrefaciens
9992121 9992121 PRJNA312615_P_NODE_38848_length_197_cov_1.054054_g38697_i0 PRJNA312615 38848 197 1.054054 2.07648638 Mesomycoplasma 2923352 Bacteria Bacteria 329 7.04e-86   NTclustered gi|1450419971|emb|LS991950.1| 2100 g38697 i0 98.913 16.507614213198 184 2 93 0 14 197 643303 643486 Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1 blastn 3252 329 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
10582015 10582015 PRJNA312615_P_NODE_26009_length_240_cov_1.010471_g25858_i0 PRJNA312615 26009 240 1.010471 2.4251304 Mycoplasma cottewii 51364 Bacteria Bacteria 276 1.1799999999999998e-69   NTclustered gi|2294785939|gb|CP103424.1| 51364 g25858 i0 87.983 0.970833333333333 233 28 97 0 3 235 391009 391241 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 233 276 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
14407165 14407165 PRJNA312615_P_NODE_33892_length_210_cov_2.260870_g33741_i0 PRJNA312615 33892 210 2.26087 4.747827 Mesomycoplasma hyorhinis 2100 Bacteria Bacteria 388 1.24e-103   NTclustered gi|1052538474|gb|CP016817.1| 2100 g33741 i0 100 96.4095238095238 210 0 100 0 1 210 22427 22218 Mesomycoplasma hyorhinis strain MDBK-IPV, complete genome blastn 20246 388 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15091606 15091606 PRJNA312615_P_NODE_312_length_1480_cov_3.231307_g267_i0 PRJNA312615 312 1480 3.231307 47.8233436 Mesomycoplasma 2923352 Bacteria Bacteria 2721 0   NTclustered gi|1563681465|emb|LR214949.1| 2100 g267 i0 99.865 21.4175675675676 1480 1 100 1 1 1480 646499 647977 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 31698 2721 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15091818 15091818 PRJNA312615_P_NODE_48272_length_173_cov_1.233871_g48121_i0 PRJNA312615 48272 173 1.233871 2.13459683 Mycoplasma 2093 Bacteria Bacteria 196 6.339999999999999e-46   NTclustered gi|1851159111|gb|CP054256.1| 2102 g48121 i0 87.574 97.6242774566474 169 21 98 0 1 169 1139822 1139990 Mycoplasma mycoides strain T1/44 GP chromosome, complete genome blastn 16889 196 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
16955116 16955116 PRJNA312615_P_NODE_13334_length_338_cov_0.934256_g13183_i0 PRJNA312615 13334 338 0.934256 3.15778528 Mycoplasma sp. HU2 2108 Bacteria Bacteria 78.2 8.14e-16   NR WP_160314997.1 1664275 g13183 i0 75.5 1.88165680473373 53 13 47 0 62 220 78 130 WP_160314997.1 hypothetical protein, partial [Mycoplasma sp. HU2014] diamond 636 78.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
27674730 27674730 PRJNA312615_P_NODE_55304_length_164_cov_0.886957_g55153_i0 PRJNA312615 55304 164 0.886957 1.45460948 Malacoplasma sp. 2791014 Bacteria Bacteria 79.3 1.49e-15   NR MEF9985415.1 2791014 g55153 i0 80.4 0.932926829268293 51 10 93.3 0 164 12 369 419 MEF9985415.1 replication initiation protein [Malacoplasma sp.] diamond 153 79.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
28274310 28274310 PRJNA312615_P_NODE_56606_length_163_cov_0.894737_g56455_i0 PRJNA312615 56606 163 0.894737 1.45842131 Mycoplasma putrefaciens 2123 Bacteria Bacteria 74.3 3.34e-14   NR WP_014035245.1 2123 g56455 i0 66.7 1.98773006134969 54 18 99.4 0 163 2 82 135 WP_014035245.1 NAD(+)/NADH kinase [Mycoplasma putrefaciens] diamond 324 74.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma putrefaciens
28716555 28716555 PRJNA312615_P_NODE_55467_length_164_cov_0.886957_g55316_i0 PRJNA312615 55467 164 0.886957 1.45460948 Mycoplasmopsis bovis 28903 Bacteria Bacteria 63.9 3.19e-10   NR WP_013456010.1 28903 g55316 i0 78 0.75 41 9 75 0 164 42 211 251 WP_013456010.1 Cof-type HAD-IIB family hydrolase [Mycoplasmopsis bovis] diamond 123 63.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
29586204 29586204 PRJNA312615_P_NODE_7390_length_451_cov_1.325871_g7240_i0 PRJNA312615 7390 451 1.325871 5.97967821 Mycoplasma 2093 Bacteria Bacteria 159 5.09e-45   NR AME13688.1 2103 g7240 i0 63.1 11.2416851441242 130 48 86.5 0 449 60 67 196 AME13688.1 putative transposase InsK for insertion sequence IS150 [Mycoplasma mycoides subsp. mycoides] diamond 5070 160 0.99375 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
29965544 29965544 PRJNA312615_P_NODE_33431_length_212_cov_1.024540_g33280_i0 PRJNA312615 33431 212 1.02454 2.1720248 Mycoplasma 2093 Bacteria Bacteria 59.7 2.2e-8   NR CBW54506.1 862259 g33280 i0 58.6 10.9245283018868 58 24 82.1 0 25 198 197 254 CBW54506.1 IS1296 I transposase protein A [Mycoplasma mycoides subsp. capri LC str. 95010] diamond 2316 60.1 0.993344425956739 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
30895905 30895905 PRJNA312615_P_NODE_39674_length_195_cov_1.013699_g39523_i0 PRJNA312615 39674 195 1.013699 1.97671305 Aster yellows phytoplasma 35779 Bacteria Bacteria 50.8 1.34e-6   NR AAO61994.1 35779 g39523 i0 50 0.769230769230769 50 25 76.9 0 151 2 3 52 AAO61994.1 conserved hypothetical protein, partial [Aster yellows phytoplasma] diamond 150 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Aster yellows phytoplasma
31179776 31179776 PRJNA312615_P_NODE_28115_length_231_cov_0.736264_g27964_i0 PRJNA312615 28115 231 0.736264 1.70076984 Mycoplasma yeatsii 51365 Bacteria Bacteria 90.9 3.55e-19   NR WP_004429417.1 51365 g27964 i0 63.5 0.961038961038961 74 27 96.1 0 229 8 826 899 WP_004429417.1 magnesium-translocating P-type ATPase [Mycoplasma yeatsii] diamond 222 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
31496588 31496588 PRJNA312615_P_NODE_54116_length_165_cov_0.879310_g53965_i0 PRJNA312615 54116 165 0.87931 1.4508615 Mycoplasma mycoides 2102 Bacteria Bacteria 62.8 1.12e-9   NR WP_013729831.1 2102 g53965 i0 56.4 15 55 24 100 0 165 1 209 263 WP_013729831.1 transposase [Mycoplasma mycoides] diamond 2475 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
32129254 32129254 PRJNA312615_P_NODE_31858_length_217_cov_1.041667_g31707_i0 PRJNA312615 31858 217 1.041667 2.26041739 Mycoplasma sp. HU2 2108 Bacteria Bacteria 84.7 1.91e-17   NR WP_050517428.1 1664275 g31707 i0 56.3 0.981566820276498 71 31 98.2 0 3 215 265 335 WP_050517428.1 HU family DNA-binding protein [Mycoplasma sp. HU2014] diamond 213 84.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32872797 32872797 PRJNA312615_P_NODE_22340_length_258_cov_1.464115_g22189_i0 PRJNA312615 22340 258 1.464115 3.7774167 Bacteria 2 Bacteria Bacteria 99.8 2.45e-22   NR WP_004430208.1 51365 g22189 i0 80.3 1.53488372093023 66 13 76.7 0 253 56 205 270 WP_004430208.1 FAD-dependent oxidoreductase [Mycoplasma yeatsii] diamond 396 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii

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