RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
25513458 25513458 PRJEB20058_P_NODE_115641_length_373_cov_2.141026_g112826_i0 PRJEB20058 115641 373 2.141026 7.98602698 Metamycoplasma faucium 56142 Bacteria Bacteria 660 0   NTclustered gi|2921905358|gb|CP182786.1| 56142 g112826 i0 99.449 51.112600536193 363 2 97 0 11 373 502478 502116 Metamycoplasma faucium strain DC-333 chromosome, complete genome blastn 19065 660 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
25515424 25515424 PRJEB20058_P_NODE_160377_length_299_cov_4.752101_g157554_i0 PRJEB20058 160377 299 4.752101 14.20878199 Mesomycoplasma ovipneumoniae 29562 Bacteria Bacteria 56.5 0.002   NTclustered gi|2582038664|gb|CP134944.1| 29562 g157554 i0 100 0.193979933110368 30 0 10 0 128 157 64766 64795 Mesomycoplasma ovipneumoniae strain MoS3261N22A chromosome, complete genome blastn 58 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma ovipneumoniae
25519508 25519508 PRJEB20058_P_NODE_33913_length_721_cov_3.090909_g31348_i0 PRJEB20058 33913 721 3.090909 22.28545389 Spiroplasma endosymbiont of Asaphidion curtum 3066281 Bacteria Bacteria 58.4 0.002   NTclustered gi|2719904888|emb|OZ035001.1| 3066281 g31348 i0 94.595 0.194174757281553 37 2 5 0 137 173 316363 316399 Spiroplasma endosymbiont of Asaphidion curtum isolate 54750 genome assembly, chromosome: 1 blastn 140 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Asaphidion curtum
25615408 25615408 PRJEB20058_P_NODE_94425_length_421_cov_8.402778_g91624_i0 PRJEB20058 94425 421 8.402778 35.37569538 Mycoplasmopsis 2767358 Bacteria Bacteria 56.5 0.003   NTclustered gi|1563792347|emb|LR214972.1| 29553 g91624 i0 100 2.29928741092637 30 0 7 0 359 388 244825 244796 Mycoplasma bovirhinis strain NCTC10118 genome assembly, chromosome: 1 blastn 968 56.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovirhinis
25658016 25658016 PRJEB20058_P_NODE_84034_length_450_cov_10.043702_g81246_i0 PRJEB20058 84034 450 10.043702 45.196659 Spiroplasma endosymbiont of Othius punctulatus 3066289 Bacteria Bacteria 56.5 0.003   NTclustered gi|2706542394|emb|OZ026449.1| 3066289 g81246 i0 100 0.0666666666666667 30 0 7 0 175 204 691707 691678 Spiroplasma endosymbiont of Othius punctulatus isolate 54758 genome assembly, chromosome: 1 blastn 30 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Othius punctulatus
25790746 25790746 PRJEB20058_P_NODE_242771_length_209_cov_9.222973_g239946_i0 PRJEB20058 242771 209 9.222973 19.27601357 Ureaplasma diversum 42094 Bacteria Bacteria 71.3 5.06e-8   NTclustered gi|365822491|gb|JN935894.1| 42094 g239946 i0 78.761 21.0047846889952 113 19 53 5 1 111 2154 2045 Ureaplasma diversum strain T95 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 4390 71.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma diversum
25921554 25921554 PRJEB20058_P_NODE_112012_length_380_cov_16.517241_g109199_i0 PRJEB20058 112012 380 16.517241 62.7655158 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 385 3.14e-102   NTclustered gi|2187152066|emb|OV788644.1| 658143 g109199 i0 87.106 130.602631578947 349 33 91 12 10 353 394348 394007 uncultured Tenericutes bacterium isolate min17_bin35 genome assembly, chromosome: 1 blastn 49629 385 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
26333452 26333452 PRJEB20058_P_NODE_201271_length_255_cov_4.520619_g198447_i0 PRJEB20058 201271 255 4.520619 11.52757845 Mesomycoplasma lagogenitalium 171286 Bacteria Bacteria 158 4.769999999999999e-34   NTclustered gi|2495165145|gb|CP122979.1| 171286 g198447 i0 87.5 50.0705882352941 136 17 53 0 95 230 898224 898359 Mesomycoplasma lagogenitalium strain 12MS chromosome, complete genome blastn 12768 158 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma lagogenitalium
26466764 26466764 PRJEB20058_P_NODE_132520_length_341_cov_11.257143_g129700_i0 PRJEB20058 132520 341 11.257143 38.38685763 Mycoplasmopsis pullorum 48003 Bacteria Bacteria 490 5.76e-134   NTclustered gi|1114069901|gb|CP017813.1| 48003 g129700 i0 94.357 2.97067448680352 319 18 94 0 23 341 38003 38321 Mycoplasmopsis pullorum strain B359_6, complete genome blastn 1013 490 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pullorum

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