RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 28 ✖

tax_clade 1

bioproject 1

  • PRJNA613025 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
11352179 11352179 PRJNA613025_S_NODE_14209_length_292_cov_2.843621_g14055_i0 PRJNA613025 14209 292 2.843621 8.30337332 uncultured marine group II/III euryarchaeote AD1 1457711 Archaea Archaea 65.1 2.54e-11   NR AIE90946.1 1457711 g14055 i0 44.9 0.914383561643836 89 45 87.3 1 9 263 6 94 AIE90946.1 hypothetical protein [uncultured marine group II/III euryarchaeote AD1000_09_E08] diamond 267 65.1 1 Archaea   Methanobacteriati Methanobacteriota         uncultured marine group II/III euryarchaeote AD1000_09_E08
19718690 19718690 PRJNA613025_S_NODE_6416_length_569_cov_2.053846_g6266_i0 PRJNA613025 6416 569 2.053846 11.68638374 archaeon 1906665 Archaea Archaea 296 2.27e-98   NR RYG64625.1 1906665 g6266 i0 76.7 0.996485061511424 189 44 99.6 0 567 1 12 200 RYG64625.1 MAG: 50S ribosomal protein L3, partial [archaeon] diamond 567 296 1 Archaea               archaeon
22268668 22268668 PRJNA613025_S_NODE_12258_length_333_cov_1.830986_g12104_i0 PRJNA613025 12258 333 1.830986 6.09718338 archaeon 1906665 Archaea Archaea 163 2.81e-48   NR RYH25290.1 1906665 g12104 i0 89.7 0.783783783783784 87 9 78.4 0 3 263 120 206 RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] diamond 261 163 1 Archaea               archaeon
26859128 26859128 PRJNA613025_S_NODE_33201_length_162_cov_0.902655_g33047_i0 PRJNA613025 33201 162 0.902655 1.4623011 archaeon 1906665 Archaea Archaea 82.8 9.66e-19   NR RYH29492.1 1906665 g33047 i0 86.5 1.92592592592593 52 7 96.3 0 156 1 17 68 RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] diamond 312 82.8 1 Archaea               archaeon
26953551 26953551 PRJNA613025_S_NODE_20102_length_219_cov_1.182353_g19948_i0 PRJNA613025 20102 219 1.182353 2.58935307 archaeon 1906665 Archaea Archaea 86.7 9.44e-20   NR RYH28872.1 1906665 g19948 i0 84.3 0.698630136986301 51 8 69.9 0 155 3 4 54 RYH28872.1 MAG: hypothetical protein EON65_10545 [archaeon] diamond 153 86.7 1 Archaea               archaeon
27206459 27206459 PRJNA613025_S_NODE_23622_length_196_cov_1.040816_g23468_i0 PRJNA613025 23622 196 1.040816 2.03999936 archaeon 1906665 Archaea Archaea 64.7 9.67e-12   NR RYH28873.1 1906665 g23468 i0 75 0.612244897959184 40 10 61.2 0 196 77 49 88 RYH28873.1 MAG: hypothetical protein EON65_10550 [archaeon] diamond 120 64.7 1 Archaea               archaeon
27238268 27238268 PRJNA613025_S_NODE_26223_length_182_cov_2.030075_g26069_i0 PRJNA613025 26223 182 2.030075 3.6947365 archaeon 1906665 Archaea Archaea 102 2.06e-26   NR RYG63904.1 1906665 g26069 i0 88.3 0.989010989010989 60 7 98.9 0 2 181 47 106 RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] diamond 180 102 1 Archaea               archaeon
27396533 27396533 PRJNA613025_S_NODE_32323_length_163_cov_1.789474_g32169_i0 PRJNA613025 32323 163 1.789474 2.91684262 archaeon 1906665 Archaea Archaea 114 6.2899999999999995e-30   NR RYH25290.1 1906665 g32169 i0 98.1 0.993865030674847 54 1 99.4 0 1 162 45 98 RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] diamond 162 114 1 Archaea               archaeon
27649034 27649034 PRJNA613025_S_NODE_13564_length_305_cov_1.726562_g13410_i0 PRJNA613025 13564 305 1.726562 5.2660141 archaeon 1906665 Archaea Archaea 59.7 1.34e-8   NR MDP2436403.1 1906665 g13410 i0 43.5 0.678688524590164 69 29 67.9 1 70 276 31 89 MDP2436403.1 hypothetical protein [archaeon] diamond 207 59.7 1 Archaea               archaeon
27712525 27712525 PRJNA613025_S_NODE_30344_length_167_cov_0.864407_g30190_i0 PRJNA613025 30344 167 0.864407 1.44355969 archaeon 1906665 Archaea Archaea 86.7 4.43e-18   NR RYH25598.1 1906665 g30190 i0 80.4 0.916167664670659 51 10 91.6 0 155 3 263 313 RYH25598.1 MAG: pyruvate, phosphate dikinase, partial [archaeon] diamond 153 86.7 1 Archaea               archaeon
27933099 27933099 PRJNA613025_S_NODE_22485_length_203_cov_0.850649_g22331_i0 PRJNA613025 22485 203 0.850649 1.72681747 Halovivax cerinus 1487865 Archaea Archaea 42 0.04   NR WP_256532648.1 1487865 g22331 i0 40 0.738916256157635 50 27 73.9 1 34 183 33 79 WP_256532648.1 hypothetical protein [Halovivax cerinus] diamond 150 42 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halovivax Halovivax cerinus
27933111 27933111 PRJNA613025_S_NODE_9045_length_430_cov_2.664042_g8893_i0 PRJNA613025 9045 430 2.664042 11.4553806 archaeon 1906665 Archaea Archaea 100 4.07e-24   NR RYH28340.1 1906665 g8893 i0 64.5 0.767441860465116 110 35 76.7 1 2 331 11 116 RYH28340.1 MAG: 50S ribosomal protein P1 [archaeon] diamond 330 100 1 Archaea               archaeon
28090922 28090922 PRJNA613025_S_NODE_29545_length_169_cov_0.908333_g29391_i0 PRJNA613025 29545 169 0.908333 1.53508277 Halarchaeum sp. 2022601 Archaea Archaea 40.4 0.0289   NR MFB6077581.1 2022601 g29391 i0 46 0.887573964497041 50 23 88.8 2 155 6 40 85 MFB6077581.1 hypothetical protein [Halarchaeum sp.] diamond 150 40.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halarchaeum Halarchaeum sp.
28185469 28185469 PRJNA613025_S_NODE_27506_length_177_cov_1.195312_g27352_i0 PRJNA613025 27506 177 1.195312 2.11570224 archaeon 1906665 Archaea Archaea 87 1.05e-20   NR RYG67183.1 1906665 g27352 i0 74.1 0.983050847457627 58 15 98.3 0 176 3 20 77 RYG67183.1 MAG: hypothetical protein EON64_08020 [archaeon] diamond 174 87 1 Archaea               archaeon
28691069 28691069 PRJNA613025_S_NODE_14047_length_295_cov_2.626016_g13893_i0 PRJNA613025 14047 295 2.626016 7.7467472 archaeon 1906665 Archaea Archaea 97.1 7.84e-24   NR RYH00022.1 1906665 g13893 i0 72.2 0.803389830508475 79 22 80.3 0 294 58 20 98 RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] diamond 237 97.1 1 Archaea               archaeon
29164738 29164738 PRJNA613025_S_NODE_24529_length_191_cov_1.077465_g24375_i0 PRJNA613025 24529 191 1.077465 2.05795815 Nanobdellota archaeon 2026764 Archaea Archaea 76.3 2.86e-14   NR MCA9485224.1 2026764 g24375 i0 51.6 0.973821989528796 62 30 97.4 0 189 4 228 289 MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] diamond 186 76.3 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29196228 29196228 PRJNA613025_S_NODE_32789_length_163_cov_0.877193_g32635_i0 PRJNA613025 32789 163 0.877193 1.42982459 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 61.2 3.8e-9   NR MCX6817786.1 3121606 g32635 i0 68.2 1.61963190184049 44 13 81 1 159 28 270 312 MCX6817786.1 VWA domain-containing protein [Candidatus Aenigmatarchaeota archaeon] diamond 264 61.2 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
29669312 29669312 PRJNA613025_S_NODE_33410_length_162_cov_0.867257_g33256_i0 PRJNA613025 33410 162 0.867257 1.40495634 archaeon 1906665 Archaea Archaea 73.6 1.65e-13   NR RYG70422.1 1906665 g33256 i0 60.4 0.981481481481482 53 21 98.1 0 3 161 664 716 RYG70422.1 MAG: hypothetical protein EON64_00215 [archaeon] diamond 159 73.6 1 Archaea               archaeon
30365048 30365048 PRJNA613025_S_NODE_26312_length_182_cov_1.150376_g26158_i0 PRJNA613025 26312 182 1.150376 2.09368432 archaeon 1906665 Archaea Archaea 95.1 7.209999999999999e-24   NR RYG99347.1 1906665 g26158 i0 80 0.989010989010989 60 12 98.9 0 3 182 15 74 RYG99347.1 MAG: hypothetical protein EON65_50365 [archaeon] diamond 180 95.1 1 Archaea               archaeon
30870129 30870129 PRJNA613025_S_NODE_23514_length_196_cov_2.299320_g23360_i0 PRJNA613025 23514 196 2.29932 4.5066672 archaeon 1906665 Archaea Archaea 92.4 8.789999999999999e-23   NR RYG60021.1 1906665 g23360 i0 75.4 0.994897959183674 65 16 99.5 0 195 1 7 71 RYG60021.1 MAG: hypothetical protein EON64_19665 [archaeon] diamond 195 92.4 1 Archaea               archaeon
31028332 31028332 PRJNA613025_S_NODE_29455_length_169_cov_1.275000_g29301_i0 PRJNA613025 29455 169 1.275 2.15475 archaeon 1906665 Archaea Archaea 45.4 0.00158   NR MDP2435053.1 1906665 g29301 i0 51.2 0.727810650887574 41 17 72.8 1 5 127 420 457 MDP2435053.1 hypothetical protein [archaeon] diamond 123 45.4 1 Archaea               archaeon
31122551 31122551 PRJNA613025_S_NODE_16255_length_260_cov_1.023697_g16101_i0 PRJNA613025 16255 260 1.023697 2.6616122 archaeon 1906665 Archaea Archaea 140 2.24e-39   NR RYH18875.1 1906665 g16101 i0 80.2 0.992307692307692 86 15 99.2 1 3 260 152 235 RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] diamond 258 140 1 Archaea               archaeon
31913584 31913584 PRJNA613025_S_NODE_10977_length_365_cov_1.772152_g10823_i0 PRJNA613025 10977 365 1.772152 6.4683548 archaeon 1906665 Archaea Archaea 122 1.96e-33   NR RYG61134.1 1906665 g10823 i0 70.7 0.673972602739726 82 24 67.4 0 3 248 33 114 RYG61134.1 MAG: hypothetical protein EON64_18795 [archaeon] diamond 246 122 1 Archaea               archaeon
31945063 31945063 PRJNA613025_S_NODE_25077_length_188_cov_1.100719_g24923_i0 PRJNA613025 25077 188 1.100719 2.06935172 archaeon 1906665 Archaea Archaea 104 8.83e-26   NR RYH14964.1 1906665 g24923 i0 80.6 0.98936170212766 62 12 98.9 0 3 188 7 68 RYH14964.1 MAG: glutathione S-transferase family protein [archaeon] diamond 186 104 1 Archaea               archaeon
31945070 31945070 PRJNA613025_S_NODE_34117_length_159_cov_2.781818_g33963_i0 PRJNA613025 34117 159 2.781818 4.42309062 archaeon 1906665 Archaea Archaea 97.1 1.23e-24   NR RYH04918.1 1906665 g33963 i0 90.6 2 53 5 100 0 159 1 6 58 RYH04918.1 MAG: 50S ribosomal protein L24 [archaeon] diamond 318 97.1 1 Archaea               archaeon
31976832 31976832 PRJNA613025_S_NODE_31218_length_165_cov_1.275862_g31064_i0 PRJNA613025 31218 165 1.275862 2.1051723 archaeon 1906665 Archaea Archaea 81.6 9.14e-19   NR RYH13702.1 1906665 g31064 i0 79.6 0.890909090909091 49 10 89.1 0 19 165 2 50 RYH13702.1 MAG: 50S ribosomal protein L4 [archaeon] diamond 147 81.6 1 Archaea               archaeon
32483257 32483257 PRJNA613025_S_NODE_33099_length_162_cov_0.902655_g32945_i0 PRJNA613025 33099 162 0.902655 1.4623011 archaeon 1906665 Archaea Archaea 84.3 1.56e-19   NR RYG59363.1 1906665 g32945 i0 76.4 1.01851851851852 55 12 100 1 162 1 36 90 RYG59363.1 MAG: hypothetical protein EON64_20310, partial [archaeon] diamond 165 84.3 1 Archaea               archaeon
32735622 32735622 PRJNA613025_S_NODE_34140_length_159_cov_2.300000_g33986_i0 PRJNA613025 34140 159 2.3 3.657 archaeon 1906665 Archaea Archaea 68.2 6.92e-14   NR RYH07630.1 1906665 g33986 i0 96.9 0.60377358490566 32 1 60.4 0 157 62 3 34 RYH07630.1 MAG: hypothetical protein EON65_41610, partial [archaeon] diamond 96 68.2 1 Archaea               archaeon

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