RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJEB11748" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 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
3844882 3844882 PRJEB11748_P_NODE_355744_length_195_cov_2.201493_g353561_i0 PRJEB11748 355744 195 2.201493 4.29291135 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 128 2.72e-25   NTclustered gi|2187163482|emb|OV788640.1| 658143 g353561 i0 80.347 1.62564102564103 173 31 88 3 1 171 741445 741616 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 317 128 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
3846649 3846649 PRJEB11748_P_NODE_91424_length_438_cov_1.724138_g89256_i0 PRJEB11748 91424 438 1.724138 7.55172444 Spiroplasma endosymbiont of Aspidapion aeneum 3066276 Bacteria Bacteria 52.8 0.042   NTclustered gi|2719904881|emb|OZ034994.1| 3066276 g89256 i0 96.875 0.0730593607305936 32 0 7 1 390 420 557463 557432 Spiroplasma endosymbiont of Aspidapion aeneum isolate 54746 genome assembly, chromosome: 1 blastn 32 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Aspidapion aeneum
11497698 11497698 PRJEB11748_P_NODE_59630_length_550_cov_12.971370_g57499_i0 PRJEB11748 59630 550 12.97137 71.342535 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 159 1.37e-46   NR HBD74452.1 1898209 g57499 i0 71.8 2.70545454545455 124 33 67.6 2 450 79 3 124 HBD74452.1 50S ribosomal protein L7/L12 [Acholeplasmataceae bacterium] diamond 1488 159 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
19141083 19141083 PRJEB11748_P_NODE_184776_length_297_cov_6.127119_g182593_i0 PRJEB11748 184776 297 6.127119 18.19754343 Mycoplasma incognitus 2101 Bacteria Bacteria 484 2.3e-132   NTclustered gi|150152|gb|M58403.1|MYCIS 2101 g182593 i0 98.551 52.1077441077441 276 1 92 3 1 274 1721 1447 Mycoplasma incognitus insertion sequence unknown genes blastn 15476 484 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma incognitus
22965882 22965882 PRJEB11748_P_NODE_109299_length_398_cov_9.026706_g107125_i0 PRJEB11748 109299 398 9.026706 35.92628988 Bacillati 1783272 Bacteria Bacteria 164 4.27e-44   NR MBS5778877.1 33015 g107125 i0 85.7 1.48492462311558 98 13 73.1 1 9 299 586 683 MBS5778877.1 DNA-directed RNA polymerase subunit beta [Acholeplasma sp.] diamond 591 164 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
22966323 22966323 PRJEB11748_P_NODE_12879_length_1321_cov_6.968254_g11717_i0 PRJEB11748 12879 1321 6.968254 92.05063534 Spiroplasma endosymbiont of Harpalus anxius 3077931 Bacteria Bacteria 571 8.389999999999997e-158   NTclustered gi|2813305944|emb|OZ187007.1| 3077931 g11717 i0 95.355 145.277062831188 366 5 56 6 142 503 751656 752013 Spiroplasma endosymbiont of Harpalus anxius isolate 66129c39-b7a8-4b37-864c-2d57ae6f9329 genome assembly, chromosome: 1 blastn 191911 571 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Harpalus anxius
28232724 28232724 PRJEB11748_P_NODE_145806_length_340_cov_14.118280_g143625_i0 PRJEB11748 145806 340 14.11828 48.002152 Mycoplasma sp. CAG:877 1262907 Bacteria Bacteria 101 7.209999999999999e-24   NR CCY80111.1 1262907 g143625 i0 65.3 0.635294117647059 72 25 63.5 0 216 1 80 151 CCY80111.1 putative uncharacterized protein [Mycoplasma sp. CAG:877] diamond 216 101 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. CAG:877
28416436 28416436 PRJEB11748_P_NODE_297626_length_220_cov_14.251572_g295443_i0 PRJEB11748 297626 220 14.251572 31.3534584 Bacillati 1783272 Bacteria Bacteria 77 2.27e-14   NR HHU54905.1 37628 g295443 i0 59.7 6.39545454545455 67 27 91.4 0 219 19 255 321 HHU54905.1 ribonuclease Y [Mollicutes bacterium] diamond 1407 77 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28485733 28485733 PRJEB11748_P_NODE_336927_length_203_cov_18.577465_g334744_i0 PRJEB11748 336927 203 18.577465 37.71225395 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 67.8 3.24e-11   NR HHW68913.1 2231116 g334744 i0 71.1 1.10837438423645 38 11 56.2 0 122 9 1 38 HHW68913.1 formate C-acetyltransferase [Mycoplasmatota bacterium] diamond 225 67.8 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
28991269 28991269 PRJEB11748_P_NODE_93268_length_433_cov_7.145161_g91100_i0 PRJEB11748 93268 433 7.145161 30.93854713 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 123 1.2499999999999998e-29   NR MFA6377143.1 1898209 g91100 i0 79.2 0.533487297921478 77 16 53.3 0 201 431 347 423 MFA6377143.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 231 123 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29432639 29432639 PRJEB11748_P_NODE_380990_length_178_cov_29.205128_g378807_i0 PRJEB11748 380990 178 29.205128 51.98512784 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 112 2.1e-27   NR HPG43329.1 1898209 g378807 i0 92.9 1.8876404494382 56 4 94.4 0 9 176 243 298 HPG43329.1 hemolysin family protein [Acholeplasmataceae bacterium] diamond 336 112 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29938270 29938270 PRJEB11748_P_NODE_345771_length_200_cov_4.294964_g343588_i0 PRJEB11748 345771 200 4.294964 8.589928 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 62.8 1.34e-9   NR HBY64827.1 1898209 g343588 i0 55 0.9 60 23 84 1 12 179 68 127 HBY64827.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 180 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30374670 30374670 PRJEB11748_P_NODE_342992_length_201_cov_4.264286_g340809_i0 PRJEB11748 342992 201 4.264286 8.57121486 FCB group 1783270 Bacteria Bacteria 118 6.17e-29   NR WP_011884509.1 2096 g340809 i0 86.2 23.2089552238806 65 9 97 0 4 198 442 506 WP_011884509.1 type I restriction endonuclease subunit R [Mycoplasmoides gallisepticum] diamond 4665 119 0.991596638655462 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides gallisepticum
30443728 30443728 PRJEB11748_P_NODE_206093_length_278_cov_19.078341_g203910_i0 PRJEB11748 206093 278 19.078341000000002 53.03778798 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 42 0.014   NR RKX66879.1 2231116 g203910 i0 54.3 0.377697841726619 35 16 37.8 0 21 125 1 35 RKX66879.1 MAG: hypothetical protein DRP42_02145 [Mycoplasmatota bacterium] diamond 105 42 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
30563470 30563470 PRJEB11748_P_NODE_301813_length_218_cov_16.770701_g299630_i0 PRJEB11748 301813 218 16.770701 36.56012818 Bacteria 2 Bacteria Bacteria 53.9 2.64e-6   NR HHX33224.1 37628 g299630 i0 44.4 1.56880733944954 54 30 74.3 0 42 203 158 211 HHX33224.1 tRNA pseudouridine(55) synthase TruB [Mollicutes bacterium] diamond 342 54.3 0.992633517495396 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30569820 30569820 PRJEB11748_P_NODE_385833_length_175_cov_6.105263_g383650_i0 PRJEB11748 385833 175 6.105263 10.68421025 Mollicutes bacterium 37628 Bacteria Bacteria 55.1 1.79e-8   NR HHU55001.1 37628 g383650 i0 75.8 0.565714285714286 33 8 56.6 0 104 6 1 33 HHU55001.1 hypothetical protein [Mollicutes bacterium] diamond 99 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30633055 30633055 PRJEB11748_P_NODE_342593_length_201_cov_7.400000_g340410_i0 PRJEB11748 342593 201 7.4 14.874 Mycoplasmopsis arginini 2094 Bacteria Bacteria 40.4 0.0388   NR MDI3350086.1 2094 g340410 i0 94.1 0.253731343283582 17 1 25.4 0 110 60 1 17 MDI3350086.1 hypothetical protein [Mycoplasmopsis arginini] diamond 51 40.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30949268 30949268 PRJEB11748_P_NODE_213314_length_272_cov_24.758294_g211131_i0 PRJEB11748 213314 272 24.758294 67.34255968 Mollicutes bacterium 37628 Bacteria Bacteria 58.9 1.05e-7   NR NLL02286.1 37628 g211131 i0 42.7 0.904411764705882 82 42 88.2 2 272 33 216 294 NLL02286.1 hypothetical protein [Mollicutes bacterium] diamond 246 58.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31069505 31069505 PRJEB11748_P_NODE_263355_length_239_cov_1.556180_g261172_i0 PRJEB11748 263355 239 1.55618 3.7192702 root 1 Root_unresolved Root_unresolved 63.2 1.69e-9   NR MCK9234822.1 1898209 g261172 i0 48.6 1.79497907949791 72 35 89.1 2 22 234 188 258 MCK9234822.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 429 63.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31512203 31512203 PRJEB11748_P_NODE_261836_length_240_cov_1.055866_g259653_i0 PRJEB11748 261836 240 1.055866 2.5340784 Bacillati 1783272 Bacteria Bacteria 81.3 9.65e-16   NR HHT38290.1 37628 g259653 i0 50 2.8375 76 38 95 0 236 9 640 715 HHT38290.1 signal peptidase I [Mollicutes bacterium] diamond 681 81.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31644579 31644579 PRJEB11748_P_NODE_271397_length_234_cov_4.000000_g269214_i0 PRJEB11748 271397 234 4 9.36 Mollicutes bacterium 37628 Bacteria Bacteria 82.4 3.52e-16   NR HHX17190.1 37628 g269214 i0 58.5 0.833333333333333 65 27 83.3 0 217 23 600 664 HHX17190.1 hypothetical protein [Mollicutes bacterium] diamond 195 82.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes 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);;