RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA556992 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
525857 525857 PRJNA556992_P_NODE_234741_length_310_cov_3.240506_g232553_i0 PRJNA556992 234741 310 3.240506 10.0455686 Spiroplasma endosymbiont of Antitype chi 3066308 Bacteria Bacteria 52.8 0.029   NTclustered gi|2706542423|emb|OZ026467.1| 3066308 g232553 i0 100 0.0903225806451613 28 0 9 0 253 280 1245434 1245407 Spiroplasma endosymbiont of Antitype chi isolate 54779 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Antitype chi
528960 528960 PRJNA556992_P_NODE_461141_length_270_cov_14.482234_g458952_i0 PRJNA556992 461141 270 14.482234 39.1020318 uncultured Mycoplasma sp. 167967 Bacteria Bacteria 65.8 3.18e-6   NTclustered gi|2859863229|gb|PQ631166.1| 167967 g458952 i0 97.368 0.140740740740741 38 1 14 0 3 40 53 90 Uncultured Mycoplasma sp. clone 10 23S ribosomal RNA gene, partial sequence blastn 38 65.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma uncultured Mycoplasma sp.
2399619 2399619 PRJNA556992_P_NODE_1009642_length_229_cov_4.705128_g1007452_i0 PRJNA556992 1009642 229 4.705128 10.77474312 Spiroplasma 2132 Bacteria Bacteria 52.8 0.02   NTclustered gi|2477858052|gb|ON511089.1| 2133 g1007452 i0 100 1.34497816593886 28 0 12 0 72 99 68046 68073 Spiroplasma citri strain D4 plasmid unnamed, complete sequence blastn 308 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma citri
5626401 5626401 PRJNA556992_P_NODE_1057385_length_223_cov_4.413333_g1055195_i0 PRJNA556992 1057385 223 4.413333 9.84173259 Candidatus Hepatoplasma crinochetorum 295596 Bacteria Bacteria 407 3.67e-109   NTclustered gi|2416256950|dbj|AP027132.1| 295596 g1055195 i0 99.552 4.48430493273543 223 1 100 0 1 223 279937 280159 MAG: Candidatus Hepatoplasma crinochetorum Tokyo2021 DNA, complete genome blastn 1000 407 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Candidatus Hepatoplasmataceae Candidatus Hepatoplasma Candidatus Hepatoplasma crinochetorum
9458953 9458953 PRJNA556992_P_NODE_578868_length_260_cov_4.219251_g576679_i0 PRJNA556992 578868 260 4.219251 10.9700526 Mycoplasmopsis caviae 55603 Bacteria Bacteria 65.8 3.04e-6   NTclustered gi|2279713051|gb|CP101806.1| 55603 g576679 i0 93.182 0.169230769230769 44 3 17 0 10 53 691027 691070 Mycoplasmopsis caviae strain G122 chromosome, complete genome blastn 44 65.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis caviae
10731897 10731897 PRJNA556992_P_NODE_357749_length_281_cov_2.009615_g355560_i0 PRJNA556992 357749 281 2.009615 5.64701815 Metamycoplasma faucium 56142 Bacteria Bacteria 514 2.75e-141   NTclustered gi|2921905358|gb|CP182786.1| 56142 g355560 i0 99.644 2 281 1 100 0 1 281 116915 117195 Metamycoplasma faucium strain DC-333 chromosome, complete genome blastn 562 514 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
12005903 12005903 PRJNA556992_P_NODE_308250_length_287_cov_5.775701_g306061_i0 PRJNA556992 308250 287 5.775701 16.57626187 Mycoplasmopsis edwardii 53558 Bacteria Bacteria 56.5 0.002   NTclustered gi|2425261263|gb|CP114370.1| 53558 g306061 i0 94.595 0.128919860627178 37 1 13 1 78 114 352014 351979 Mycoplasmopsis edwardii strain felid995 chromosome, complete genome blastn 37 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis edwardii
13285041 13285041 PRJNA556992_P_NODE_620171_length_257_cov_2.472826_g617982_i0 PRJNA556992 620171 257 2.472826 6.35516282 Mycoplasmatota bacterium WC44 3076018 Bacteria Bacteria 67.6 8.35e-7   NTclustered gi|2878023906|gb|CP134881.1| 3076018 g617982 i0 100 3.34630350194553 36 0 14 0 108 143 1552407 1552442 Mycoplasmatota bacterium WC44 chromosome, complete genome blastn 860 67.6 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium WC44
13880601 13880601 PRJNA556992_P_NODE_543031_length_263_cov_3.842105_g540842_i0 PRJNA556992 543031 263 3.842105 10.10473615 Mollicutes 31969 Bacteria Bacteria 486 5.5499999999999986e-133   NTclustered gi|227438068|gb|FJ876260.1| 2121 g540842 i0 100 104 263 0 100 0 1 263 740 478 Mycoplasma orale strain MT-4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 27352 486 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma orale
14554536 14554536 PRJNA556992_P_NODE_210732_length_321_cov_3.362903_g208544_i0 PRJNA556992 210732 321 3.362903 10.79491863 Acholeplasma oculi 35623 Bacteria Bacteria 588 1.8599999999999994e-163   NTclustered gi|227438070|gb|FJ876262.1| 35623 g208544 i0 99.688 106.934579439252 321 1 100 0 1 321 635 315 Acholeplasma oculi strain Panangala 59 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence blastn 34326 588 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma oculi
16429880 16429880 PRJNA556992_P_NODE_679553_length_252_cov_3.877095_g677364_i0 PRJNA556992 679553 252 3.877095 9.7702794 Mesomycoplasma 2923352 Bacteria Bacteria 466 6.89e-127   NTclustered gi|1932032494|gb|CP064323.1| 2100 g677364 i0 100 69.0674603174603 252 0 100 0 1 252 444218 443967 Mesomycoplasma hyorhinis strain IMT49388 chromosome, complete genome blastn 17405 466 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
16430662 16430662 PRJNA556992_P_NODE_906333_length_240_cov_3.065868_g904143_i0 PRJNA556992 906333 240 3.065868 7.3580832 Candidatus Phytoplasma 33926 Bacteria Bacteria 267 7.08e-67   NTclustered gi|2722330186|gb|CP128414.1| 85620 g904143 i0 87.083 33.1833333333333 240 25 100 4 1 240 426595 426362 Candidatus Phytoplasma asteris strain M8, complete chromosome blastn 7964 267 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma asteris
18381192 18381192 PRJNA556992_P_NODE_492275_length_268_cov_1.456410_g490086_i0 PRJNA556992 492275 268 1.45641 3.9031788 Acholeplasma oculi 35623 Bacteria Bacteria 484 2.0399999999999996e-132   NTclustered gi|644983578|emb|LK028559.1| 35623 g490086 i0 99.254 612.574626865672 268 2 100 0 1 268 370547 370814 Acholeplasma oculi genome assembly Acholeplasma oculi strain 19L ,chromosome : 1 blastn 164170 484 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma oculi
19658541 19658541 PRJNA556992_P_NODE_722256_length_250_cov_1.305085_g720067_i0 PRJNA556992 722256 250 1.305085 3.2627125 Mycoplasmopsis arginini 2094 Bacteria Bacteria 52.8 0.023   NTclustered gi|2668342370|gb|CP143577.1| 2094 g720067 i0 100 0.336 28 0 11 0 114 141 529507 529480 Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome blastn 84 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
19658762 19658762 PRJNA556992_P_NODE_74036_length_445_cov_8.897849_g71860_i0 PRJNA556992 74036 445 8.897849 39.59542805 Spiroplasma endosymbiont of Melieria omissa 3139324 Bacteria Bacteria 54.7 0.012   NTclustered gi|2719904899|emb|OZ035012.1| 3139324 g71860 i0 100 0.128089887640449 29 0 7 0 151 179 1304158 1304130 Spiroplasma endosymbiont of Melieria omissa isolate 7b93cfef-5182-4d29-b531-169777273f43 genome assembly, chromosome: 1 blastn 57 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Melieria omissa
22202071 22202071 PRJNA556992_P_NODE_178818_length_339_cov_2.484962_g176630_i0 PRJNA556992 178818 339 2.484962 8.42402118 Acholeplasma oculi 35623 Bacteria Bacteria 621 1.95e-173   NTclustered gi|644983578|emb|LK028559.1| 35623 g176630 i0 99.705 112.469026548673 339 1 100 0 1 339 368581 368919 Acholeplasma oculi genome assembly Acholeplasma oculi strain 19L ,chromosome : 1 blastn 38127 621 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma oculi
22208398 22208398 PRJNA556992_P_NODE_647798_length_255_cov_1.928571_g645609_i0 PRJNA556992 647798 255 1.928571 4.91785605 Mesomycoplasma hyorhinis 2100 Bacteria Bacteria 52.8 0.023   NTclustered gi|2290922541|gb|CP102738.1| 2100 g645609 i0 100 0.109803921568627 28 0 11 0 2 29 237546 237573 Mesomycoplasma hyorhinis strain N36N21c chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
24750297 24750297 PRJNA556992_P_NODE_122600_length_381_cov_1.500000_g120413_i0 PRJNA556992 122600 381 1.5 5.715 Acholeplasma oculi 35623 Bacteria Bacteria 704 0   NTclustered gi|644983578|emb|LK028559.1| 35623 g120413 i0 100 302.244094488189 381 0 100 0 1 381 369901 369521 Acholeplasma oculi genome assembly Acholeplasma oculi strain 19L ,chromosome : 1 blastn 115155 704 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma oculi

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