RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA206070" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA206070 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
27926798 27926798 PRJNA206070_S_NODE_24085_length_178_cov_1.687943_g22209_i0 PRJNA206070 24085 178 1.687943 3.00453854 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 70.5 2.55e-12   NR WP_414596408.1 3228838 g22209 i0 54.5 0.926966292134832 55 22 92.7 2 166 2 379 430 WP_414596408.1 DNA polymerase [Candidatus Methanoprimaticola sp. MG2] diamond 165 70.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
28400415 28400415 PRJNA206070_S_NODE_23606_length_181_cov_1.083333_g21730_i0 PRJNA206070 23606 181 1.083333 1.96083273 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 76.6 1.76e-14   NR WP_414596398.1 3228838 g21730 i0 60 0.994475138121547 60 23 97.8 1 3 179 15 74 WP_414596398.1 hypothetical protein [Candidatus Methanoprimaticola sp. MG2] diamond 180 76.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
28873961 28873961 PRJNA206070_S_NODE_9188_length_412_cov_1.928000_g7315_i0 PRJNA206070 9188 412 1.928 7.94336 Candidatus Methanarcanum hacksteinii 2911857 Archaea Archaea 99.8 2.9400000000000003e-21   NR WP_400205513.1 2911857 g7315 i0 47.6 0.902912621359223 124 58 85.2 1 62 412 210 333 WP_400205513.1 hypothetical protein [Candidatus Methanarcanum hacksteinii] diamond 372 99.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales   Candidatus Methanarcanum Candidatus Methanarcanum hacksteinii
29852903 29852903 PRJNA206070_S_NODE_29191_length_157_cov_0.975000_g27315_i0 PRJNA206070 29191 157 0.975 1.53075 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 49.7 3.05e-5   NR WP_414596400.1 3228838 g27315 i0 55.8 0.821656050955414 43 19 82.2 0 26 154 112 154 WP_414596400.1 hypothetical protein [Candidatus Methanoprimaticola sp. MG2] diamond 129 49.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
29965449 29965449 PRJNA206070_S_NODE_25911_length_169_cov_1.181818_g24035_i0 PRJNA206070 25911 169 1.181818 1.99727242 root 1 Root_unresolved Root_unresolved 57.4 9.04e-8   NR MBP3386583.1 2517205 g24035 i0 47.9 2.57396449704142 48 25 85.2 0 166 23 256 303 MBP3386583.1 RNA-directed DNA polymerase [Candidatus Methanomethylophilaceae archaeon] diamond 435 57.8 0.993079584775087 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
29979181 29979181 PRJNA206070_S_NODE_7131_length_517_cov_3.460417_g5267_i0 PRJNA206070 7131 517 3.460417 17.89035589 Candidatus Methanarcanum hacksteinii 2911857 Archaea Archaea 206 1.02e-62   NR WP_400205505.1 2911857 g5267 i0 59.2 1.00967117988395 174 63 96.3 1 499 2 82 255 WP_400205505.1 hypothetical protein [Candidatus Methanarcanum hacksteinii] diamond 522 206 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales   Candidatus Methanarcanum Candidatus Methanarcanum hacksteinii
30421877 30421877 PRJNA206070_S_NODE_17713_length_228_cov_6.680628_g15837_i0 PRJNA206070 17713 228 6.680628 15.23183184 Methanomethylophilus alvi 1291540 Archaea Archaea 74.7 8.28e-14   NR WP_400236884.1 1291540 g15837 i0 54.7 2.96052631578947 75 29 98.7 2 228 4 169 238 WP_400236884.1 DNA polymerase, partial [Methanomethylophilus alvi] diamond 675 74.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Methanomethylophilus Methanomethylophilus alvi
30800550 30800550 PRJNA206070_S_NODE_4654_length_804_cov_4.014342_g2938_i0 PRJNA206070 4654 804 4.014342 32.27530968 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 133 8.369999999999999e-32   NR MBQ8643750.1 2517205 g2938 i0 39.2 1.03358208955224 181 95 62.3 5 297 797 1 180 MBQ8643750.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] diamond 831 133 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
31242941 31242941 PRJNA206070_S_NODE_18415_length_221_cov_1.206522_g16539_i0 PRJNA206070 18415 221 1.206522 2.66641362 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 60.8 1.59e-9   NR MBQ8372690.1 2517205 g16539 i0 55.2 1.76470588235294 58 26 78.7 0 9 182 6 63 MBQ8372690.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] diamond 390 60.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
31260846 31260846 PRJNA206070_S_NODE_12015_length_323_cov_8.961538_g10139_i0 PRJNA206070 12015 323 8.961538 28.94576774 root 1 Root_unresolved Root_unresolved 117 1.18e-29   NR WP_400236884.1 1291540 g10139 i0 56.2 1.95975232198142 105 41 97.5 2 1 315 169 268 WP_400236884.1 DNA polymerase, partial [Methanomethylophilus alvi] diamond 633 118 0.991525423728814 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Methanomethylophilus Methanomethylophilus alvi
31640293 31640293 PRJNA206070_S_NODE_12016_length_323_cov_7.793706_g10140_i0 PRJNA206070 12016 323 7.793706 25.17367038 root 1 Root_unresolved Root_unresolved 119 3.01e-30   NR WP_400236884.1 1291540 g10140 i0 57.1 1.95975232198142 105 40 97.5 2 1 315 169 268 WP_400236884.1 DNA polymerase, partial [Methanomethylophilus alvi] diamond 633 119 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Methanomethylophilus Methanomethylophilus alvi
31654021 31654021 PRJNA206070_S_NODE_30177_length_154_cov_1.119658_g28301_i0 PRJNA206070 30177 154 1.119658 1.72427332 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 48.1 1.39e-4   NR WP_414596398.1 3228838 g28301 i0 44.4 0.876623376623377 45 25 87.7 0 154 20 112 156 WP_414596398.1 hypothetical protein [Candidatus Methanoprimaticola sp. MG2] diamond 135 48.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
32318912 32318912 PRJNA206070_S_NODE_31579_length_150_cov_1.380531_g29703_i0 PRJNA206070 31579 150 1.380531 2.0707965 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 59.7 9.64e-9   NR WP_414596396.1 3228838 g29703 i0 74.3 0.7 35 9 70 0 38 142 183 217 WP_414596396.1 hypothetical protein [Candidatus Methanoprimaticola sp. MG2] diamond 105 59.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
32476972 32476972 PRJNA206070_S_NODE_26079_length_168_cov_1.671756_g24203_i0 PRJNA206070 26079 168 1.671756 2.80855008 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 73.2 1.62e-13   NR WP_414596396.1 3228838 g24203 i0 81.8 0.785714285714286 44 8 78.6 0 133 2 3 46 WP_414596396.1 hypothetical protein [Candidatus Methanoprimaticola sp. MG2] diamond 132 73.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
32886383 32886383 PRJNA206070_S_NODE_26780_length_165_cov_1.828125_g24904_i0 PRJNA206070 26780 165 1.828125 3.01640625 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 87.8 7.22e-19   NR WP_414596407.1 3228838 g24904 i0 66.7 0.981818181818182 54 18 98.2 0 163 2 15 68 WP_414596407.1 phage DNA encapsidation protein [Candidatus Methanoprimaticola sp. MG2] diamond 162 87.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2

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