RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1072736" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1072736 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
26940734 26940734 PRJNA1072736_S_NODE_6002_length_164_cov_2.429752_g5997_i0 PRJNA1072736 6002 164 2.429752 3.98479328 Mycoplasma wenyonii 65123 Bacteria Bacteria 50.4 2.23e-5   NR WP_112665659.1 65123 g5997 i0 88 0.457317073170732 25 3 45.7 0 75 1 6 30 WP_112665659.1 phosphate ABC transporter ATP-binding protein [Mycoplasma wenyonii] diamond 75 50.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27130182 27130182 PRJNA1072736_S_NODE_5682_length_168_cov_1.048000_g5677_i0 PRJNA1072736 5682 168 1.048 1.76064 Mycoplasma wenyonii 65123 Bacteria Bacteria 93.6 8.139999999999999e-23   NR WP_112665651.1 65123 g5677 i0 90.6 1.89285714285714 53 5 94.6 0 168 10 78 130 WP_112665651.1 50S ribosomal protein L19 [Mycoplasma wenyonii] diamond 318 93.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27951862 27951862 PRJNA1072736_S_NODE_2225_length_234_cov_1.230366_g2220_i0 PRJNA1072736 2225 234 1.230366 2.87905644 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 83.6 2.13e-18   NR WP_187150565.1 432608 g2220 i0 90.7 0.551282051282051 43 4 55.1 0 130 2 76 118 WP_187150565.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 129 83.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28046473 28046473 PRJNA1072736_S_NODE_2325_length_230_cov_1.508021_g2320_i0 PRJNA1072736 2325 230 1.508021 3.4684483 Mycoplasma wenyonii 65123 Bacteria Bacteria 78.2 1.04e-14   NR WP_112664956.1 65123 g2320 i0 94.7 0.495652173913044 38 2 49.6 0 173 60 805 842 WP_112664956.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 114 78.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28109525 28109525 PRJNA1072736_S_NODE_3745_length_194_cov_2.172185_g3740_i0 PRJNA1072736 3745 194 2.172185 4.2140389 Mycoplasma wenyonii 65123 Bacteria Bacteria 103 2.75e-24   NR WP_014850035.1 65123 g3740 i0 86.9 0.943298969072165 61 8 94.3 0 194 12 316 376 WP_014850035.1 HD domain-containing protein [Mycoplasma wenyonii] diamond 183 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28583456 28583456 PRJNA1072736_S_NODE_6127_length_163_cov_1.425000_g6122_i0 PRJNA1072736 6127 163 1.425 2.32275 Mycoplasma wenyonii 65123 Bacteria Bacteria 58.2 4.62e-8   NR WP_014850166.1 65123 g6122 i0 100 0.533742331288344 29 0 53.4 0 2 88 748 776 WP_014850166.1 ATP-dependent zinc metalloprotease FtsH [Mycoplasma wenyonii] diamond 87 58.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28835826 28835826 PRJNA1072736_S_NODE_6788_length_157_cov_1.552632_g6783_i0 PRJNA1072736 6788 157 1.552632 2.43763224 Mycoplasma wenyonii 65123 Bacteria Bacteria 46.2 6.93e-4   NR WP_014849543.1 65123 g6783 i0 53.1 0.611464968152866 32 15 61.1 0 111 16 153 184 WP_014849543.1 hypothetical protein [Mycoplasma wenyonii] diamond 96 46.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30098839 30098839 PRJNA1072736_S_NODE_3632_length_196_cov_2.921569_g3627_i0 PRJNA1072736 3632 196 2.921569 5.72627524 Mycoplasma wenyonii 65123 Bacteria Bacteria 110 1.72e-26   NR WP_112665726.1 65123 g3627 i0 90.3 0.948979591836735 62 6 94.9 0 196 11 37 98 WP_112665726.1 spermidine/putrescine ABC transporter substrate-binding protein, partial [Mycoplasma wenyonii] diamond 186 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30257316 30257316 PRJNA1072736_S_NODE_6572_length_159_cov_1.206897_g6567_i0 PRJNA1072736 6572 159 1.206897 1.91896623 Mycoplasma wenyonii 65123 Bacteria Bacteria 99.8 9.85e-23   NR WP_112665098.1 65123 g6567 i0 92.3 0.981132075471698 52 4 98.1 0 3 158 670 721 WP_112665098.1 ATP-dependent helicase [Mycoplasma wenyonii] diamond 156 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30667686 30667686 PRJNA1072736_S_NODE_1753_length_254_cov_1.360190_g1748_i0 PRJNA1072736 1753 254 1.36019 3.4548826 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 99.4 5.969999999999999e-23   NR WP_187149913.1 432608 g1748 i0 97.9 0.566929133858268 48 1 56.7 0 144 1 163 210 WP_187149913.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 144 99.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31710904 31710904 PRJNA1072736_S_NODE_2037_length_242_cov_1.653266_g2032_i0 PRJNA1072736 2037 242 1.653266 4.00090372 Mycoplasma wenyonii 65123 Bacteria Bacteria 139 1.15e-39   NR WP_112665708.1 65123 g2032 i0 92 0.929752066115702 75 6 93 0 242 18 91 165 WP_112665708.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii] diamond 225 139 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32058840 32058840 PRJNA1072736_S_NODE_4518_length_182_cov_1.352518_g4513_i0 PRJNA1072736 4518 182 1.352518 2.46158276 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 93.6 7.76e-21   NR WP_187149882.1 432608 g4513 i0 87.9 0.956043956043956 58 7 95.6 0 174 1 90 147 WP_187149882.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 174 93.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32533703 32533703 PRJNA1072736_S_NODE_5819_length_166_cov_3.130081_g5814_i0 PRJNA1072736 5819 166 3.130081 5.19593446 Mycoplasma wenyonii 65123 Bacteria Bacteria 44.7 0.00208   NR WP_112665927.1 65123 g5814 i0 44.4 0.975903614457831 54 24 86.7 2 164 21 22 75 WP_112665927.1 hypothetical protein [Mycoplasma wenyonii] diamond 162 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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