RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA782235" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA782235 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2487798 2487798 PRJNA782235_P_NODE_25162_length_243_cov_1.811765_g24973_i0 PRJNA782235 25162 243 1.811765 4.40258895 Mycoplasma 2093 Bacteria Bacteria 444 3.09e-120   NTclustered gi|2294785939|gb|CP103424.1| 51364 g24973 i0 99.588 195.720164609054 243 1 100 0 1 243 270163 269921 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 47560 444 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
3314828 3314828 PRJNA782235_P_NODE_9983_length_289_cov_2.263889_g9794_i0 PRJNA782235 9983 289 2.263889 6.54263921 Mycoplasma yeatsii 51365 Bacteria Bacteria 518 2.19e-142   NTclustered gi|756767228|gb|CP007520.1| 743967 g9794 i0 98.962 146.993079584775 289 3 100 0 1 289 809617 809905 Mycoplasma yeatsii GM274B blastn 42481 518 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
9691938 9691938 PRJNA782235_P_NODE_7308_length_330_cov_1.684825_g7119_i0 PRJNA782235 7308 330 1.684825 5.5599225 Malacoplasma muris 2119 Bacteria Bacteria 525 1.5199999999999995e-144   NTclustered gi|299851933|gb|HM135461.1| 2119 g7119 i0 95.455 146.572727272727 330 14 100 1 1 330 335 663 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 48369 525 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
13966213 13966213 PRJNA782235_P_NODE_15051_length_258_cov_1.156757_g14862_i0 PRJNA782235 15051 258 1.156757 2.98443306 FCB group 1783270 Bacteria Bacteria 472 1.52e-128   NTclustered gi|1720621726|gb|CP035041.1| 2100 g14862 i0 99.612 99.9069767441861 258 1 100 0 1 258 428787 429044 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 25776 472 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19890322 19890322 PRJNA782235_P_NODE_5936_length_362_cov_1.065744_g5747_i0 PRJNA782235 5936 362 1.065744 3.85799328 Mycoplasma corogypsi 2106 Bacteria Bacteria 54.7 0.01   NTclustered gi|2860285583|gb|CP174163.1| 2106 g5747 i0 100 0.0801104972375691 29 0 8 0 330 358 335177 335149 Mycoplasma corogypsi strain BV1 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma corogypsi

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