RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1072736" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 22 ✖

bioproject 1

  • PRJNA1072736 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
22692734 22692734 PRJNA1072736_S_NODE_3218_length_205_cov_2.370370_g3213_i0 PRJNA1072736 3218 205 2.37037 4.8592585 Paenibacillus 44249 Bacteria Bacteria 96.3 1.16e-21   NR WP_240647383.1 393251 g3213 i0 67.6 2.95609756097561 68 22 99.5 0 205 2 234 301 WP_240647383.1 3-dehydroquinate synthase [Paenibacillus nanensis] diamond 606 96.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus nanensis
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
27288606 27288606 PRJNA1072736_S_NODE_1983_length_244_cov_2.338308_g1978_i0 PRJNA1072736 1983 244 2.338308 5.70547152 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 45.1 0.00434   NR WP_395587210.1 251699 g1978 i0 40 0.983606557377049 80 42 92.2 4 229 5 126 204 WP_395587210.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 240 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27731081 27731081 PRJNA1072736_S_NODE_2244_length_233_cov_2.878947_g2239_i0 PRJNA1072736 2244 233 2.878947 6.70794651 Shigella sonnei 624 Bacteria Bacteria 82.8 9.47e-19   NR WP_353763804.1 624 g2239 i0 95.5 0.566523605150215 44 2 56.7 0 102 233 38 81 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 132 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
27754101 27754101 PRJNA1072736_S_NODE_2964_length_211_cov_3.017857_g2959_i0 PRJNA1072736 2964 211 3.017857 6.36767827 root 1 Root_unresolved Root_unresolved 42.4 0.00431   NR WP_217900948.1 573 g2959 i0 54.8 0.881516587677725 31 13 42.7 1 2 91 3 33 WP_217900948.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 186 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27848443 27848443 PRJNA1072736_S_NODE_7544_length_151_cov_1.472222_g7539_i0 PRJNA1072736 7544 151 1.472222 2.22305522 Faecousia 2840588 Bacteria Bacteria 60.1 8.1e-9   NR MCI6850052.1 1898207 g7539 i0 86.5 2.20529801324503 37 5 73.5 0 150 40 50 86 MCI6850052.1 translation initiation factor IF-2 [Clostridiales bacterium] diamond 333 60.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
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
29561933 29561933 PRJNA1072736_S_NODE_6230_length_162_cov_1.218487_g6225_i0 PRJNA1072736 6230 162 1.218487 1.97394894 Actinomycetota bacterium 2900548 Bacteria Bacteria 43.5 0.00305   NR MBW3537026.1 2900548 g6225 i0 38.6 0.814814814814815 44 27 81.5 0 155 24 79 122 MBW3537026.1 transcriptional repressor [Actinomycetota bacterium] diamond 132 43.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
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
30446708 30446708 PRJNA1072736_S_NODE_5213_length_173_cov_1.392308_g5208_i0 PRJNA1072736 5213 173 1.392308 2.40869284 Piscicoccus intestinalis 746033 Bacteria Bacteria 42.4 0.0197   NR WP_068430052.1 746033 g5208 i0 47.5 0.69364161849711 40 21 69.4 0 45 164 205 244 WP_068430052.1 universal stress protein [Piscicoccus intestinalis] diamond 120 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae Piscicoccus Piscicoccus intestinalis
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
31047146 31047146 PRJNA1072736_S_NODE_7555_length_151_cov_1.305556_g7550_i0 PRJNA1072736 7555 151 1.305556 1.97138956 Desulfosarcina sp. 2027861 Bacteria Bacteria 41.2 0.0277   NR WP_410287501.1 2027861 g7550 i0 56.8 0.735099337748344 37 12 65.6 2 119 21 79 115 WP_410287501.1 dTDP-4-dehydrorhamnose 3,5-epimerase [Desulfosarcina sp.] diamond 111 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina Desulfosarcina sp.
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
32312335 32312335 PRJNA1072736_S_NODE_1559_length_264_cov_1.647059_g1554_i0 PRJNA1072736 1559 264 1.647059 4.34823576 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 112 1.8e-27   NR RLA04755.1 1913989 g1554 i0 68.6 1.95454545454545 86 27 97.7 0 260 3 77 162 RLA04755.1 MAG: hypothetical protein DRQ45_00060 [Gammaproteobacteria bacterium] diamond 516 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
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);;