RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA725806", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 20 ✖

tax_kingdom 1

  • Bacillati · 20 ✖

bioproject 1

  • PRJNA725806 · 20 ✖

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
711663 711663 PRJNA725806_P_NODE_101021_length_196_cov_7.893082_g100719_i0 PRJNA725806 101021 196 7.893082 15.47044072 Mycoplasma sp. NEAQ87857 2683967 Bacteria Bacteria 52.8 0.017   NTclustered gi|1787253220|gb|CP045542.1| 2683967 g100719 i0 100 0.142857142857143 28 0 14 0 37 64 909070 909097 Mycoplasma sp. NEAQ87857 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. NEAQ87857
711720 711720 PRJNA725806_P_NODE_129481_length_179_cov_2.007042_g129179_i0 PRJNA725806 129481 179 2.007042 3.59260518 Mycoplasma nasistruthionis 353852 Bacteria Bacteria 58.4 3.26e-4   NTclustered gi|1680402357|gb|CP040825.1| 353852 g129179 i0 100 0.346368715083799 31 0 17 0 46 76 202396 202426 Mycoplasma nasistruthionis strain 2F1A chromosome, complete genome blastn 62 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma nasistruthionis
3263090 3263090 PRJNA725806_P_NODE_156963_length_165_cov_5.562500_g156661_i0 PRJNA725806 156963 165 5.5625 9.178125 Mycoplasmoides fastidiosum 92758 Bacteria Bacteria 52.8 0.014   NTclustered gi|2279714125|gb|CP101809.1| 92758 g156661 i0 100 0.16969696969697 28 0 17 0 44 71 1210966 1210993 Mycoplasmoides fastidiosum strain 4822 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides fastidiosum
4540427 4540427 PRJNA725806_P_NODE_95164_length_201_cov_1.579268_g94862_i0 PRJNA725806 95164 201 1.579268 3.17432868 Spiroplasma kunkelii 47834 Bacteria Bacteria 52.8 0.017   NTclustered gi|922842379|gb|CP010899.1| 273035 g94862 i0 100 0.139303482587065 28 0 14 0 4 31 40036 40063 Spiroplasma kunkelii CR2-3x, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma kunkelii
7090564 7090564 PRJNA725806_P_NODE_176786_length_157_cov_2.275000_g176484_i0 PRJNA725806 176786 157 2.275 3.57175 Mycoplasmopsis adleri 51362 Bacteria Bacteria 56.5 0.001   NTclustered gi|2860284679|gb|CP174162.1| 51362 g176484 i0 97.059 0.21656050955414 34 0 21 1 101 133 370970 371003 Mycoplasmopsis adleri strain G145 chromosome, complete genome blastn 34 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis adleri
8365222 8365222 PRJNA725806_P_NODE_51747_length_246_cov_2.282297_g51450_i0 PRJNA725806 51747 246 2.282297 5.61445062 Mesoplasma coleopterae 324078 Bacteria Bacteria 52.8 0.022   NTclustered gi|1359435478|gb|CP022510.1| 324078 g51450 i0 87.234 0.191056910569106 47 4 19 2 61 106 346611 346566 Mesoplasma coleopterae strain BARC 786 chromosome blastn 47 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma coleopterae
8847352 8847352 PRJNA725806_P_NODE_126347_length_180_cov_8.517483_g126045_i0 PRJNA725806 126347 180 8.517483 15.3314694 Metamycoplasma 2895509 Bacteria Bacteria 54.7 0.004   NTclustered gi|1860432571|gb|CP055146.1| 2098 g126045 i0 94.444 3 36 0 20 2 38 73 73667 73634 Metamycoplasma hominis strain SS10 chromosome, complete genome blastn 540 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hominis
11398076 11398076 PRJNA725806_P_NODE_25609_length_298_cov_95.869732_g25312_i0 PRJNA725806 25609 298 95.869732 285.69180136 root 1 Root_unresolved Root_unresolved 56.5 0.002   NTclustered gi|835318765|gb|CP011855.1| 2144 g25312 i0 100 5.19127516778523 30 0 10 0 132 161 154744 154773 Spiroplasma atrichopogonis strain GNAT3597, complete genome blastn 1547 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma mirum
14740952 14740952 PRJNA725806_P_NODE_30832_length_285_cov_2.661290_g30535_i0 PRJNA725806 30832 285 2.66129 7.5846765 Spiroplasma endosymbiont of Lasioglossum calceatum 3066318 Bacteria Bacteria 52.8 0.026   NTclustered gi|2706542406|emb|OZ026468.1| 3066318 g30535 i0 100 0.0982456140350877 28 0 10 0 30 57 274858 274831 Spiroplasma endosymbiont of Lasioglossum calceatum isolate 54787 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Lasioglossum calceatum
16014226 16014226 PRJNA725806_P_NODE_123513_length_182_cov_3.689655_g123211_i0 PRJNA725806 123513 182 3.689655 6.7151721 Mycoplasmopsis columbina 114881 Bacteria Bacteria 52.8 0.015   NTclustered gi|1563806405|emb|LR215041.1| 114881 g123211 i0 100 0.153846153846154 28 0 15 0 87 114 658105 658078 Mycoplasma columbinum strain NCTC10178 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis columbina
16497326 16497326 PRJNA725806_P_NODE_14793_length_341_cov_12.703947_g14503_i0 PRJNA725806 14793 341 12.703947 43.32045927 Mesoplasma 46239 Bacteria Bacteria 56.5 0.002   NTclustered gi|1359431967|gb|CP022506.1| 2151 g14503 i0 94.595 0.410557184750733 37 1 11 1 24 59 344021 344057 Mesoplasma florum strain W20 chromosome blastn 140 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma florum
18563706 18563706 PRJNA725806_P_NODE_57615_length_238_cov_2.333333_g57318_i0 PRJNA725806 57615 238 2.333333 5.55333254 Spiroplasma monobiae 2136 Bacteria Bacteria 52.8 0.021   NTclustered gi|1321358410|gb|CP025543.1| 1336748 g57318 i0 100 0.117647058823529 28 0 12 0 202 229 685602 685575 Spiroplasma monobiae MQ-1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma monobiae
18563718 18563718 PRJNA725806_P_NODE_62715_length_231_cov_10.211340_g62417_i0 PRJNA725806 62715 231 10.21134 23.5881954 Spiroplasma chrysopicola 216933 Bacteria Bacteria 52.8 0.021   NTclustered gi|506965883|gb|CP005077.1| 1276227 g62417 i0 100 0.121212121212121 28 0 12 0 39 66 911620 911593 Spiroplasma chrysopicola DF-1, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma chrysopicola
19046297 19046297 PRJNA725806_P_NODE_74795_length_218_cov_5.580110_g74494_i0 PRJNA725806 74795 218 5.58011 12.1646398 Mycoplasmopsis 2767358 Bacteria Bacteria 52.8 0.019   NTclustered gi|1563797793|emb|LR215010.1| 29555 g74494 i0 100 0.385321100917431 28 0 13 0 67 94 212099 212126 Mycoplasma canis strain NCTC10146 genome assembly, chromosome: 1 blastn 84 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis canis
21114323 21114323 PRJNA725806_P_NODE_131997_length_177_cov_8.278571_g131695_i0 PRJNA725806 131997 177 8.278571 14.65307067 Mycoplasma struthionis 538220 Bacteria Bacteria 54.7 0.004   NTclustered gi|1526087405|gb|CP034044.1| 538220 g131695 i0 100 0.163841807909605 29 0 16 0 27 55 163586 163558 Mycoplasma struthionis strain 237IA chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma struthionis
22389383 22389383 PRJNA725806_P_NODE_59758_length_235_cov_4.232323_g59460_i0 PRJNA725806 59758 235 4.232323 9.94595905 Metamycoplasma salivarium 2124 Bacteria Bacteria 52.8 0.021   NTclustered gi|1563679190|emb|LR214939.1| 2124 g59460 i0 100 0.238297872340426 28 0 12 0 96 123 184282 184255 Mycoplasma salivarium strain NCTC10113 genome assembly, plasmid: 2 blastn 56 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma salivarium
22871807 22871807 PRJNA725806_P_NODE_118078_length_185_cov_5.047297_g117776_i0 PRJNA725806 118078 185 5.047297 9.33749945 Mycoplasma 2093 Bacteria Bacteria 58.4 3.4e-4   NTclustered gi|2040369058|gb|CP065588.1| 40477 g117776 i0 94.737 4.16216216216216 38 1 20 1 144 180 642677 642640 Mycoplasma mycoides subsp. capri strain M-5 chromosome, complete genome blastn 770 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
24938185 24938185 PRJNA725806_P_NODE_112300_length_189_cov_1.967105_g111998_i0 PRJNA725806 112300 189 1.967105 3.71782845 Spiroplasma endosymbiont of Crioceris asparagi 3066286 Bacteria Bacteria 52.8 0.016   NTclustered gi|2706542422|emb|OZ026475.1| 3066286 g111998 i0 100 0.148148148148148 28 0 15 0 62 89 341436 341409 Spiroplasma endosymbiont of Crioceris asparagi isolate 54756 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Crioceris asparagi
26672071 26672071 PRJNA725806_P_NODE_117201_length_186_cov_1.812081_g116899_i0 PRJNA725806 117201 186 1.812081 3.37047066 Mycoplasmopsis arginini 2094 Bacteria Bacteria 45.1 0.00103   NR MDI3350356.1 2094 g116899 i0 79.2 0.387096774193548 24 5 38.7 0 150 79 1 24 MDI3350356.1 hypothetical protein [Mycoplasmopsis arginini] diamond 72 45.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27273548 27273548 PRJNA725806_P_NODE_66983_length_226_cov_8.063492_g66683_i0 PRJNA725806 66983 226 8.063492 18.22349192 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 42.4 0.0129   NR MCI5521490.1 2231116 g66683 i0 46.3 1.10176991150442 41 22 54.4 0 138 16 3 43 MCI5521490.1 ASCH domain-containing protein [Mycoplasmatota bacterium] diamond 249 42.4 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota 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);;