RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB27957", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB27957 · 6 ✖

analysis 1

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
7675685 7675685 PRJEB27957_P_NODE_67507_length_206_cov_1.299363_g67397_i0 PRJEB27957 67507 206 1.299363 2.67668778 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 191 3.66e-44   NTclustered gi|2040452726|gb|CP074573.1| 2231116 g67397 i0 84.5 787.718446601942 200 24 97 5 1 199 2237232 2237039 Tenericutes bacterium strain zrk4 chromosome, complete genome blastn 162270 191 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
14051522 14051522 PRJEB27957_P_NODE_115972_length_165_cov_0.896552_g115862_i0 PRJEB27957 115972 165 0.896552 1.4793108 Mycoplasmataceae bacterium T2110 363696 Bacteria Bacteria 200 4.659999999999998e-47   NTclustered gi|83962876|gb|DQ318957.1| 363696 g115862 i0 88.485 46.2909090909091 165 19 100 0 1 165 288 124 Mycoplasmataceae bacterium T2110 16S ribosomal RNA gene, partial sequence blastn 7638 200 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium T2110
17875011 17875011 PRJEB27957_P_NODE_4255_length_567_cov_4.281853_g4152_i0 PRJEB27957 4255 567 4.281853 24.27810651 Spiroplasma tabanidicola 324079 Bacteria Bacteria 56.5 0.004   NTclustered gi|1780488998|gb|CP046276.1| 324079 g4152 i0 96.97 0.0582010582010582 33 1 6 0 286 318 412154 412186 Spiroplasma tabanidicola strain TAUS-1 chromosome, complete genome blastn 33 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma tabanidicola
19148903 19148903 PRJEB27957_P_NODE_33836_length_270_cov_0.941176_g33726_i0 PRJEB27957 33836 270 0.941176 2.5411752 Spiroplasma litorale 216942 Bacteria Bacteria 52.8 0.025   NTclustered gi|915477727|gb|CP012357.1| 216942 g33726 i0 100 0.103703703703704 28 0 10 0 56 83 302531 302558 Spiroplasma litorale strain TN-1, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma litorale
24249242 24249242 PRJEB27957_P_NODE_54580_length_224_cov_1.188571_g54470_i0 PRJEB27957 54580 224 1.188571 2.66239904 Malacoplasma muris 2119 Bacteria Bacteria 52.8 0.02   NTclustered gi|2890642799|gb|CP177248.1| 2119 g54470 i0 100 0.125 28 0 13 0 61 88 506612 506639 Malacoplasma muris strain RIII-4 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
24249244 24249244 PRJEB27957_P_NODE_5940_length_505_cov_1.353070_g5834_i0 PRJEB27957 5940 505 1.35307 6.8330035 Metamycoplasma spumans 92406 Bacteria Bacteria 52.8 0.049   NTclustered gi|2783350961|gb|CP163393.1| 92406 g5834 i0 100 0.0554455445544554 28 0 6 0 59 86 332295 332322 Metamycoplasma spumans strain 385A chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma spumans

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