RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1074408" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1074408 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1465591 1465591 PRJNA1074408_S_NODE_6802_length_179_cov_1.411765_g6672_i0 PRJNA1074408 6802 179 1.411765 2.52705935 Malacoplasma muris 2119 Bacteria Bacteria 279 6.39e-71   NTclustered gi|299851933|gb|HM135461.1| 2119 g6672 i0 94.972 134.888268156425 179 8 100 1 1 179 318 495 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 24145 279 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
2741676 2741676 PRJNA1074408_S_NODE_5403_length_199_cov_1.538462_g5273_i0 PRJNA1074408 5403 199 1.538462 3.06153938 Mycoplasma wenyonii 65123 Bacteria Bacteria 335 1.5299999999999996e-87   NTclustered gi|395455868|gb|CP003703.1| 1197325 g5273 i0 96.985 1 199 6 100 0 1 199 36199 36001 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 199 335 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
3567148 3567148 PRJNA1074408_S_NODE_4943_length_208_cov_1.454545_g4813_i0 PRJNA1074408 4943 208 1.454545 3.0254536 Mycoplasmoidales 2790996 Bacteria Bacteria 318 1.63e-82   NTclustered gi|1563789200|emb|LR214962.1| 2115 g4813 i0 94.231 298.096153846154 208 12 100 0 1 208 355660 355867 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 blastn 62004 318 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
10394284 10394284 PRJNA1074408_S_NODE_6629_length_181_cov_1.391304_g6499_i0 PRJNA1074408 6629 181 1.391304 2.51826024 Mycoplasma amphoriforme 273136 Bacteria Bacteria 91.6 3.26e-14   NTclustered gi|633894721|emb|HG937516.1| 572419 g6499 i0 96.364 2.33149171270718 55 2 30 0 1 55 824898 824844 Mycoplasma amphoriforme A39 complete genome blastn 422 91.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma amphoriforme
12495330 12495330 PRJNA1074408_S_NODE_3850_length_235_cov_2.744792_g3720_i0 PRJNA1074408 3850 235 2.744792 6.4502612 Mycoplasmoidales 2790996 Bacteria Bacteria 281 2.47e-71   NTclustered gi|1563789200|emb|LR214962.1| 2115 g3720 i0 88.511 116.914893617021 235 24 99 3 1 233 358056 358289 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 blastn 27475 283 0.992932862190813 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
15493645 15493645 PRJNA1074408_S_NODE_6613_length_181_cov_1.739130_g6483_i0 PRJNA1074408 6613 181 1.73913 3.1478253 Mycoplasma ovis 171632 Bacteria Bacteria 156 1.14e-33   NTclustered gi|566058721|gb|CP006935.1| 1415773 g6483 i0 91.964 3.55801104972376 112 8 62 1 68 179 6078 6188 Mycoplasma ovis str. Michigan, complete genome blastn 644 156 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
24416912 24416912 PRJNA1074408_S_NODE_3820_length_236_cov_2.487047_g3690_i0 PRJNA1074408 3820 236 2.487047 5.86943092 Malacoplasma microti 38746 Bacteria Bacteria 316 6.8e-82   NTclustered gi|299851939|gb|HM135466.1| 38746 g3690 i0 91.102 100.03813559322 236 18 100 3 1 236 1476 1708 Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence blastn 23609 316 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma microti

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