RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

38 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 38 ✖

tax_clade 1

bioproject 1

  • PRJEB12366 · 38 ✖

analysis 1

  • diamond · 38 ✖
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
5123165 5123165 PRJEB12366_P_NODE_4985_length_373_cov_1.843195_g4795_i0 PRJEB12366 4985 373 1.843195 6.87511735 archaeon 1906665 Archaea Archaea 189 1.02e-56   NR RYH13701.1 1906665 g4795 i0 75.8 2.96782841823056 124 30 99.7 0 372 1 155 278 RYH13701.1 MAG: 50S ribosomal protein L4 [archaeon] diamond 1107 189 1 Archaea               archaeon
5123188 5123188 PRJEB12366_P_NODE_6885_length_305_cov_1.251852_g6695_i0 PRJEB12366 6885 305 1.251852 3.8181486 archaeon 1906665 Archaea Archaea 107 1.68e-27   NR RYH28354.1 1906665 g6695 i0 64.6 0.80655737704918 82 29 80.7 0 248 3 1 82 RYH28354.1 MAG: ABC-F family ATP-binding cassette domain-containing protein [archaeon] diamond 246 107 1 Archaea               archaeon
6398896 6398896 PRJEB12366_P_NODE_20426_length_150_cov_1.000000_g20236_i0 PRJEB12366 20426 150 1 1.5 archaeon 1906665 Archaea Archaea 99 4.24e-23   NR RYG67480.1 1906665 g20236 i0 96 1 50 2 100 0 1 150 223 272 RYG67480.1 MAG: ADP-forming succinate--CoA ligase subunit beta [archaeon] diamond 150 99 1 Archaea               archaeon
12464787 12464787 PRJEB12366_P_NODE_5150_length_366_cov_1.960725_g4960_i0 PRJEB12366 5150 366 1.960725 7.1762535 archaeon 1906665 Archaea Archaea 103 3.0799999999999994e-24   NR RYH18875.1 1906665 g4960 i0 68.1 0.590163934426229 72 20 59 1 150 365 63 131 RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] diamond 216 103 1 Archaea               archaeon
17872400 17872400 PRJEB12366_P_NODE_3835_length_432_cov_1.909320_g3645_i0 PRJEB12366 3835 432 1.90932 8.2482624 archaeon 1906665 Archaea Archaea 216 2.2799999999999999e-69   NR RYH30694.1 1906665 g3645 i0 90.2 0.854166666666667 123 12 85.4 0 4 372 29 151 RYH30694.1 MAG: 30S ribosomal protein S15 [archaeon] diamond 369 216 1 Archaea               archaeon
19146293 19146293 PRJEB12366_P_NODE_5476_length_352_cov_1.375394_g5286_i0 PRJEB12366 5476 352 1.375394 4.84138688 archaeon 1906665 Archaea Archaea 199 2.72e-63   NR RYH06910.1 1906665 g5286 i0 82.8 2.95738636363636 116 20 98.9 0 3 350 47 162 RYH06910.1 MAG: hypothetical protein EON65_42320 [archaeon] diamond 1041 199 1 Archaea               archaeon
21697469 21697469 PRJEB12366_P_NODE_14778_length_186_cov_1.271523_g14588_i0 PRJEB12366 14778 186 1.271523 2.36503278 archaeon 1906665 Archaea Archaea 117 4.42e-31   NR RYH14017.1 1906665 g14588 i0 90.2 0.983870967741935 61 6 98.4 0 3 185 102 162 RYH14017.1 MAG: molecular chaperone DnaK, partial [archaeon] diamond 183 117 1 Archaea               archaeon
22662592 22662592 PRJEB12366_P_NODE_6478_length_317_cov_1.361702_g6288_i0 PRJEB12366 6478 317 1.361702 4.31659534 archaeon 1906665 Archaea Archaea 195 1.4600000000000004e-59   NR RYH04926.1 1906665 g6288 i0 92.4 0.993690851735016 105 8 99.4 0 3 317 78 182 RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] diamond 315 195 1 Archaea               archaeon
24246527 24246527 PRJEB12366_P_NODE_10720_length_229_cov_1.639175_g10530_i0 PRJEB12366 10720 229 1.639175 3.75371075 archaeon 1906665 Archaea Archaea 137 6.64e-39   NR RYH25290.1 1906665 g10530 i0 93.2 0.96943231441048 74 5 96.9 0 227 6 101 174 RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] diamond 222 137 1 Archaea               archaeon
24246535 24246535 PRJEB12366_P_NODE_12700_length_205_cov_1.411765_g12510_i0 PRJEB12366 12700 205 1.411765 2.89411825 archaeon 1906665 Archaea Archaea 97.8 3e-24   NR RYH05217.1 1906665 g12510 i0 87.3 0.804878048780488 55 7 80.5 0 203 39 79 133 RYH05217.1 MAG: 50S ribosomal protein L15 [archaeon] diamond 165 97.8 1 Archaea               archaeon
26589515 26589515 PRJEB12366_P_NODE_11141_length_223_cov_2.159574_g10951_i0 PRJEB12366 11141 223 2.159574 4.81585002 archaeon 1906665 Archaea Archaea 51.2 2.82e-5   NR RYH05451.1 1906665 g10951 i0 34.8 0.928251121076233 69 43 90.1 1 3 203 313 381 RYH05451.1 MAG: hypothetical protein EON65_44650 [archaeon] diamond 207 51.2 1 Archaea               archaeon
26621436 26621436 PRJEB12366_P_NODE_10561_length_231_cov_1.933673_g10371_i0 PRJEB12366 10561 231 1.933673 4.46678463 archaeon 1906665 Archaea Archaea 101 6.359999999999999e-23   NR RYH05451.1 1906665 g10371 i0 67.1 0.987012987012987 76 23 98.7 1 229 2 218 291 RYH05451.1 MAG: hypothetical protein EON65_44650 [archaeon] diamond 228 101 1 Archaea               archaeon
26621447 26621447 PRJEB12366_P_NODE_16761_length_171_cov_0.875000_g16571_i0 PRJEB12366 16761 171 0.875 1.49625 archaeon 1906665 Archaea Archaea 90.5 7.430000000000001e-21   NR RYH17153.1 1906665 g16571 i0 74.5 0.964912280701754 55 14 96.5 0 2 166 33 87 RYH17153.1 MAG: hypothetical protein EON65_29020 [archaeon] diamond 165 90.5 1 Archaea               archaeon
26621455 26621455 PRJEB12366_P_NODE_19861_length_152_cov_1.709402_g19671_i0 PRJEB12366 19861 152 1.709402 2.59829104 archaeon 1906665 Archaea Archaea 42.4 0.0147   NR RYH20254.1 1906665 g19671 i0 44.4 0.888157894736842 45 25 88.8 0 12 146 286 330 RYH20254.1 MAG: hypothetical protein EON65_24020 [archaeon] diamond 135 42.4 1 Archaea               archaeon
26843345 26843345 PRJEB12366_P_NODE_14241_length_190_cov_1.522581_g14051_i0 PRJEB12366 14241 190 1.522581 2.8929039 archaeon 1906665 Archaea Archaea 107 3.51e-28   NR RYG63904.1 1906665 g14051 i0 88.9 0.994736842105263 63 7 99.5 0 2 190 45 107 RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] diamond 189 107 1 Archaea               archaeon
27001164 27001164 PRJEB12366_P_NODE_16342_length_174_cov_1.136691_g16152_i0 PRJEB12366 16342 174 1.136691 1.97784234 archaeon 1906665 Archaea Archaea 45.4 0.00141   NR RYH25295.1 1906665 g16152 i0 36.8 0.982758620689655 57 33 98.3 1 173 3 165 218 RYH25295.1 MAG: hypothetical protein EON65_15580, partial [archaeon] diamond 171 45.4 1 Archaea               archaeon
27064593 27064593 PRJEB12366_P_NODE_17802_length_164_cov_0.930233_g17612_i0 PRJEB12366 17802 164 0.930233 1.52558212 archaeon 1906665 Archaea Archaea 51.2 8.58e-7   NR RYG94268.1 1906665 g17612 i0 40.8 0.896341463414634 49 29 89.6 0 3 149 13 61 RYG94268.1 MAG: hypothetical protein EON65_57780 [archaeon] diamond 147 51.2 1 Archaea               archaeon
27222451 27222451 PRJEB12366_P_NODE_20003_length_152_cov_1.017094_g19813_i0 PRJEB12366 20003 152 1.017094 1.54598288 archaeon 1906665 Archaea Archaea 62.8 9.05e-10   NR RYH13809.1 1906665 g19813 i0 71.8 0.769736842105263 39 11 77 0 3 119 242 280 RYH13809.1 MAG: VWA domain-containing protein [archaeon] diamond 117 62.8 1 Archaea               archaeon
27380865 27380865 PRJEB12366_P_NODE_11343_length_221_cov_1.075269_g11153_i0 PRJEB12366 11343 221 1.075269 2.37634449 archaeon 1906665 Archaea Archaea 127 2.05e-36   NR RYH06909.1 1906665 g11153 i0 80.6 0.97737556561086 72 14 97.7 0 220 5 22 93 RYH06909.1 MAG: hypothetical protein EON65_42315 [archaeon] diamond 216 127 1 Archaea               archaeon
27507204 27507204 PRJEB12366_P_NODE_5923_length_336_cov_2.411960_g5733_i0 PRJEB12366 5923 336 2.41196 8.1041856 archaeon 1906665 Archaea Archaea 100 9.15e-25   NR RYH28340.1 1906665 g5733 i0 68.1 0.616071428571429 69 22 61.6 0 281 75 1 69 RYH28340.1 MAG: 50S ribosomal protein P1 [archaeon] diamond 207 100 1 Archaea               archaeon
27633394 27633394 PRJEB12366_P_NODE_13764_length_194_cov_1.477987_g13574_i0 PRJEB12366 13764 194 1.477987 2.86729478 archaeon 1906665 Archaea Archaea 73.6 5.78e-15   NR RYG61134.1 1906665 g13574 i0 71.1 0.695876288659794 45 13 69.6 0 189 55 70 114 RYG61134.1 MAG: hypothetical protein EON64_18795 [archaeon] diamond 135 73.6 1 Archaea               archaeon
27917347 27917347 PRJEB12366_P_NODE_3045_length_494_cov_1.577342_g2859_i0 PRJEB12366 3045 494 1.577342 7.79206948 Nitrosopumilus sp. 2024843 Archaea Archaea 94.4 1.09e-19   NR MDA7495390.1 2024843 g2859 i0 36.6 0.92914979757085 153 81 90.5 5 47 493 160 300 MDA7495390.1 hypothetical protein [Nitrosopumilus sp.] diamond 459 94.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
28138728 28138728 PRJEB12366_P_NODE_12825_length_203_cov_2.708333_g12635_i0 PRJEB12366 12825 203 2.708333 5.49791599 archaeon 1906665 Archaea Archaea 114 6.019999999999999e-31   NR RYH18874.1 1906665 g12635 i0 72.7 0.975369458128079 66 18 97.5 0 2 199 17 82 RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon] diamond 198 114 1 Archaea               archaeon
28138745 28138745 PRJEB12366_P_NODE_20385_length_150_cov_1.043478_g20195_i0 PRJEB12366 20385 150 1.043478 1.565217 archaeon 1906665 Archaea Archaea 92.8 2.29e-20   NR RYH11047.1 1906665 g20195 i0 83.3 0.96 48 8 96 0 148 5 450 497 RYH11047.1 MAG: hypothetical protein EON65_39055 [archaeon] diamond 144 92.8 1 Archaea               archaeon
28769869 28769869 PRJEB12366_P_NODE_11587_length_218_cov_1.311475_g11397_i0 PRJEB12366 11587 218 1.311475 2.8590155 archaeon 1906665 Archaea Archaea 82.4 1.37e-18   NR RYG66002.1 1906665 g11397 i0 73.1 0.715596330275229 52 14 71.6 0 58 213 17 68 RYG66002.1 MAG: hypothetical protein EON64_10710, partial [archaeon] diamond 156 82.4 1 Archaea               archaeon
29205895 29205895 PRJEB12366_P_NODE_11929_length_213_cov_2.146067_g11739_i0 PRJEB12366 11929 213 2.146067 4.57112271 Methanobacteriota 28890 Archaea Archaea 50.8 3.24e-5   NR WP_163485142.1 60847 g11739 i0 32.4 7.07042253521127 74 41 91.5 1 203 9 31 104 WP_163485142.1 ribonuclease Z [Halogeometricum borinquense] diamond 1506 51.2 0.9921875 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halogeometricum Halogeometricum borinquense
30064495 30064495 PRJEB12366_P_NODE_14232_length_190_cov_1.548387_g14042_i0 PRJEB12366 14232 190 1.548387 2.9419353 archaeon 1906665 Archaea Archaea 119 1.61e-32   NR RYH03712.1 1906665 g14042 i0 93.7 0.994736842105263 63 4 99.5 0 189 1 84 146 RYH03712.1 MAG: hypothetical protein EON65_47145 [archaeon] diamond 189 119 1 Archaea               archaeon
30159138 30159138 PRJEB12366_P_NODE_13332_length_198_cov_1.717791_g13142_i0 PRJEB12366 13332 198 1.717791 3.40122618 archaeon 1906665 Archaea Archaea 60.5 1.13e-8   NR RYH31494.1 1906665 g13142 i0 50.8 0.954545454545455 63 29 93.9 2 196 11 472 533 RYH31494.1 MAG: hypothetical protein EON65_02550, partial [archaeon] diamond 189 60.5 1 Archaea               archaeon
30412476 30412476 PRJEB12366_P_NODE_14573_length_187_cov_1.960526_g14383_i0 PRJEB12366 14573 187 1.960526 3.66618362 archaeon 1906665 Archaea Archaea 120 3.46e-32   NR RYG65124.1 1906665 g14383 i0 93.4 0.978609625668449 61 4 97.9 0 3 185 149 209 RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon] diamond 183 120 1 Archaea               archaeon
30569890 30569890 PRJEB12366_P_NODE_19793_length_153_cov_1.016949_g19603_i0 PRJEB12366 19793 153 1.016949 1.55593197 archaeon 1906665 Archaea Archaea 84.7 1.15e-17   NR RYH23153.1 1906665 g19603 i0 83 0.92156862745098 47 8 92.2 0 1 141 63 109 RYH23153.1 MAG: hypothetical protein EON65_18220, partial [archaeon] diamond 141 84.7 1 Archaea               archaeon
30696435 30696435 PRJEB12366_P_NODE_3034_length_495_cov_1.547826_g2848_i0 PRJEB12366 3034 495 1.547826 7.6617387 archaeon 1906665 Archaea Archaea 157 3.8399999999999997e-42   NR RYH05451.1 1906665 g2848 i0 84.9 0.563636363636364 93 14 56.4 0 1 279 413 505 RYH05451.1 MAG: hypothetical protein EON65_44650 [archaeon] diamond 279 157 1 Archaea               archaeon
31802845 31802845 PRJEB12366_P_NODE_11697_length_216_cov_2.198895_g11507_i0 PRJEB12366 11697 216 2.198895 4.7496132 archaeon 1906665 Archaea Archaea 139 3.82e-41   NR RYY77943.1 1906665 g11507 i0 91.5 0.986111111111111 71 6 98.6 0 215 3 5 75 RYY77943.1 MAG: 30S ribosomal protein S17 [archaeon] diamond 213 139 1 Archaea               archaeon
31992817 31992817 PRJEB12366_P_NODE_12958_length_202_cov_1.724551_g12768_i0 PRJEB12366 12958 202 1.724551 3.48359302 archaeon 1906665 Archaea Archaea 68.2 2.01e-11   NR RYH28353.1 1906665 g12768 i0 60.9 0.683168316831683 46 18 68.3 0 27 164 126 171 RYH28353.1 MAG: ABC-F family ATP-binding cassette domain-containing protein [archaeon] diamond 138 68.2 1 Archaea               archaeon
32119531 32119531 PRJEB12366_P_NODE_13398_length_198_cov_0.981595_g13208_i0 PRJEB12366 13398 198 0.981595 1.9435581 archaeon 1906665 Archaea Archaea 104 4.8200000000000006e-27   NR RYG66081.1 1906665 g13208 i0 85.7 0.954545454545455 63 9 95.5 0 196 8 57 119 RYG66081.1 MAG: GTP-binding protein, partial [archaeon] diamond 189 104 1 Archaea               archaeon
32119547 32119547 PRJEB12366_P_NODE_19798_length_153_cov_1.016949_g19608_i0 PRJEB12366 19798 153 1.016949 1.55593197 archaeon 1906665 Archaea Archaea 77.4 3.93e-15   NR RYG65161.1 1906665 g19608 i0 84.2 0.745098039215686 38 6 74.5 0 1 114 293 330 RYG65161.1 MAG: hypothetical protein EON64_12505 [archaeon] diamond 114 77.4 1 Archaea               archaeon
32246291 32246291 PRJEB12366_P_NODE_10358_length_234_cov_1.778894_g10168_i0 PRJEB12366 10358 234 1.778894 4.1626119600000004 archaeon 1906665 Archaea Archaea 154 1.53e-41   NR RYG69930.1 1906665 g10168 i0 92.1 0.974358974358974 76 6 97.4 0 2 229 464 539 RYG69930.1 MAG: hypothetical protein EON64_01505 [archaeon] diamond 228 154 1 Archaea               archaeon
32404274 32404274 PRJEB12366_P_NODE_9519_length_247_cov_2.075472_g9329_i0 PRJEB12366 9519 247 2.075472 5.12641584 archaeon 1906665 Archaea Archaea 149 1.68e-44   NR RYH28872.1 1906665 g9329 i0 86.6 0.995951417004049 82 11 99.6 0 2 247 5 86 RYH28872.1 MAG: hypothetical protein EON65_10545 [archaeon] diamond 246 149 1 Archaea               archaeon
32656505 32656505 PRJEB12366_P_NODE_11080_length_224_cov_1.740741_g10890_i0 PRJEB12366 11080 224 1.740741 3.89925984 archaeon 1906665 Archaea Archaea 99 5.26e-25   NR RYH00022.1 1906665 g10890 i0 65.7 0.9375 70 24 93.8 0 214 5 14 83 RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] diamond 210 99 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);;