RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA1192965" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1192965 · 28 ✖

analysis 1

tax_phylum 0

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
14349559 14349559 PRJNA1192965_P_NODE_2052_length_298_cov_1.026667_g2033_i0 PRJNA1192965 2052 298 1.026667 3.05946766 archaeon 1906665 Archaea Archaea 146 9.39e-41   NR RYH05201.1 1906665 g2033 i0 72.4 0.986577181208054 98 27 98.7 0 294 1 126 223 RYH05201.1 MAG: hypothetical protein EON65_45370 [archaeon] diamond 294 146 1 Archaea               archaeon
15070097 15070097 PRJNA1192965_P_NODE_3132_length_255_cov_1.653846_g3113_i0 PRJNA1192965 3132 255 1.653846 4.2173073 archaeon 1906665 Archaea Archaea 110 3.76e-27   NR RYH05201.1 1906665 g3113 i0 71.6 0.788235294117647 67 19 78.8 0 37 237 76 142 RYH05201.1 MAG: hypothetical protein EON65_45370 [archaeon] diamond 201 110 1 Archaea               archaeon
24546559 24546559 PRJNA1192965_P_NODE_3680_length_249_cov_0.875000_g3661_i0 PRJNA1192965 3680 249 0.875 2.17875 archaeon 1906665 Archaea Archaea 150 4.88e-41   NR RYH13265.1 1906665 g3661 i0 94 1 83 5 100 0 1 249 126 208 RYH13265.1 MAG: F0F1 ATP synthase subunit alpha [archaeon] diamond 249 150 1 Archaea               archaeon
24546570 24546570 PRJNA1192965_P_NODE_5120_length_241_cov_0.916667_g5101_i0 PRJNA1192965 5120 241 0.916667 2.20916747 archaeon 1906665 Archaea Archaea 134 2.39e-36   NR RYG65149.1 1906665 g5101 i0 80 1.9792531120332 80 16 99.6 0 1 240 65 144 RYG65149.1 MAG: MC/SLC25 family protein [archaeon] diamond 477 134 1 Archaea               archaeon
26660555 26660555 PRJNA1192965_P_NODE_3221_length_252_cov_1.530726_g3202_i0 PRJNA1192965 3221 252 1.530726 3.85742952 archaeon 1906665 Archaea Archaea 73.2 4.36e-14   NR MDP2436403.1 1906665 g3202 i0 54.4 0.678571428571429 57 26 67.9 0 1 171 36 92 MDP2436403.1 hypothetical protein [archaeon] diamond 171 73.2 1 Archaea               archaeon
26787674 26787674 PRJNA1192965_P_NODE_5081_length_241_cov_0.916667_g5062_i0 PRJNA1192965 5081 241 0.916667 2.20916747 archaeon 1906665 Archaea Archaea 73.2 1.79e-14   NR RYH29248.1 1906665 g5062 i0 58.2 0.684647302904564 55 23 68.5 0 168 4 18 72 RYH29248.1 MAG: hypothetical protein EON65_09240 [archaeon] diamond 165 73.2 1 Archaea               archaeon
27388606 27388606 PRJNA1192965_P_NODE_2963_length_261_cov_1.228723_g2944_i0 PRJNA1192965 2963 261 1.228723 3.20696703 archaeon 1906665 Archaea Archaea 105 1.57e-25   NR RYH31048.1 1906665 g2944 i0 54.2 0.954022988505747 83 38 95.4 0 259 11 51 133 RYH31048.1 MAG: hypothetical protein EON65_03565 [archaeon] diamond 249 105 1 Archaea               archaeon
27988390 27988390 PRJNA1192965_P_NODE_2265_length_287_cov_1.345794_g2246_i0 PRJNA1192965 2265 287 1.345794 3.86242878 archaeon 1906665 Archaea Archaea 173 1.15e-51   NR RYG67557.1 1906665 g2246 i0 84.2 0.993031358885017 95 15 99.3 0 285 1 49 143 RYG67557.1 MAG: hypothetical protein EON64_07185 [archaeon] diamond 285 173 1 Archaea               archaeon
28051470 28051470 PRJNA1192965_P_NODE_505_length_517_cov_1.204955_g486_i0 PRJNA1192965 505 517 1.204955 6.22961735 Promethearchaeati archaeon 2591838 Archaea Archaea 47.8 0.00868   NR NHJ40576.1 2591838 g486 i0 37.2 0.835589941972921 78 48 45.3 1 403 170 117 193 NHJ40576.1 DEAD/DEAH box helicase [Promethearchaeati archaeon] diamond 432 47.8 1 Archaea   Promethearchaeati           Promethearchaeati archaeon
28114497 28114497 PRJNA1192965_P_NODE_2845_length_264_cov_2.015707_g2826_i0 PRJNA1192965 2845 264 2.015707 5.32146648 archaeon 1906665 Archaea Archaea 132 2.41e-36   NR RYH18875.1 1906665 g2826 i0 79.3 0.988636363636364 87 18 98.9 0 262 2 122 208 RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] diamond 261 132 1 Archaea               archaeon
28398795 28398795 PRJNA1192965_P_NODE_4486_length_244_cov_1.801170_g4467_i0 PRJNA1192965 4486 244 1.80117 4.3948548 archaeon 1906665 Archaea Archaea 72 1.7e-12   NR RYH12831.1 1906665 g4467 i0 38.1 1.0327868852459 84 48 99.6 2 243 1 214 296 RYH12831.1 MAG: hypothetical protein EON65_37185 [archaeon] diamond 252 72 1 Archaea               archaeon
28808954 28808954 PRJNA1192965_P_NODE_5008_length_242_cov_0.911243_g4989_i0 PRJNA1192965 5008 242 0.911243 2.20520806 archaeon 1906665 Archaea Archaea 56.2 6.33e-7   NR RYH05838.1 1906665 g4989 i0 35 0.991735537190083 80 52 99.2 0 242 3 274 353 RYH05838.1 MAG: hypothetical protein EON65_43685, partial [archaeon] diamond 240 56.2 1 Archaea               archaeon
29787895 29787895 PRJNA1192965_P_NODE_4831_length_243_cov_0.905882_g4812_i0 PRJNA1192965 4831 243 0.905882 2.20129326 archaeon 1906665 Archaea Archaea 44.7 0.00752   NR MCQ2820914.1 1906665 g4812 i0 34.6 1 81 50 96.3 1 241 8 152 232 MCQ2820914.1 battenin family protein [archaeon] diamond 243 44.7 1 Archaea               archaeon
29946087 29946087 PRJNA1192965_P_NODE_5311_length_228_cov_2.832258_g5292_i0 PRJNA1192965 5311 228 2.832258 6.45754824 archaeon 1906665 Archaea Archaea 134 4.19e-39   NR RYH06909.1 1906665 g5292 i0 81.3 0.986842105263158 75 14 98.7 0 228 4 2 76 RYH06909.1 MAG: hypothetical protein EON65_42315 [archaeon] diamond 225 134 1 Archaea               archaeon
30009365 30009365 PRJNA1192965_P_NODE_3831_length_248_cov_0.880000_g3812_i0 PRJNA1192965 3831 248 0.88 2.1824 archaeon 1906665 Archaea Archaea 143 1.1599999999999999e-41   NR RYG68310.1 1906665 g3812 i0 86.6 0.991935483870968 82 11 99.2 0 247 2 3 84 RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] diamond 246 143 1 Archaea               archaeon
30040779 30040779 PRJNA1192965_P_NODE_3851_length_248_cov_0.880000_g3832_i0 PRJNA1192965 3851 248 0.88 2.1824 archaeon 1906665 Archaea Archaea 93.2 4.17e-22   NR RYH13419.1 1906665 g3832 i0 64.7 0.82258064516129 68 24 82.3 0 248 45 54 121 RYH13419.1 MAG: hypothetical protein EON65_35685 [archaeon] diamond 204 93.2 1 Archaea               archaeon
30040780 30040780 PRJNA1192965_P_NODE_4451_length_245_cov_0.895349_g4432_i0 PRJNA1192965 4451 245 0.895349 2.19360505 archaeon 1906665 Archaea Archaea 130 3.61e-36   NR RYH12729.1 1906665 g4432 i0 71.6 0.991836734693878 81 23 99.2 0 244 2 69 149 RYH12729.1 MAG: hypothetical protein EON65_37465 [archaeon] diamond 243 130 1 Archaea               archaeon
30072273 30072273 PRJNA1192965_P_NODE_3232_length_252_cov_1.016760_g3213_i0 PRJNA1192965 3232 252 1.01676 2.5622352 archaeon 1906665 Archaea Archaea 50.4 4.14e-5   NR RYH05419.1 1906665 g3213 i0 39 0.976190476190476 82 40 97.6 2 1 246 38 109 RYH05419.1 MAG: hypothetical protein EON65_44740, partial [archaeon] diamond 246 50.4 1 Archaea               archaeon
30577647 30577647 PRJNA1192965_P_NODE_1253_length_358_cov_2.161404_g1234_i0 PRJNA1192965 1253 358 2.161404 7.73782632 archaeon 1906665 Archaea Archaea 163 1.6299999999999998e-48   NR RYH29016.1 1906665 g1234 i0 68.4 0.955307262569832 114 36 95.5 0 16 357 53 166 RYH29016.1 MAG: hypothetical protein EON65_10010 [archaeon] diamond 342 163 1 Archaea               archaeon
30704200 30704200 PRJNA1192965_P_NODE_1994_length_301_cov_1.013158_g1975_i0 PRJNA1192965 1994 301 1.013158 3.04960558 archaeon 1906665 Archaea Archaea 150 1.3999999999999996e-41   NR RYH13372.1 1906665 g1975 i0 64 0.996677740863787 100 36 99.7 0 300 1 163 262 RYH13372.1 MAG: hypothetical protein EON65_35815 [archaeon] diamond 300 150 1 Archaea               archaeon
30767490 30767490 PRJNA1192965_P_NODE_5314_length_228_cov_2.483871_g5295_i0 PRJNA1192965 5314 228 2.483871 5.66322588 archaeon 1906665 Archaea Archaea 102 8.35e-25   NR RYH05654.1 1906665 g5295 i0 53.9 1 76 35 100 0 228 1 54 129 RYH05654.1 MAG: hypothetical protein EON65_44105, partial [archaeon] diamond 228 102 1 Archaea               archaeon
31209343 31209343 PRJNA1192965_P_NODE_4255_length_246_cov_0.890173_g4236_i0 PRJNA1192965 4255 246 0.890173 2.18982558 archaeon 1906665 Archaea Archaea 119 3.84e-32   NR RYG62853.1 1906665 g4236 i0 65.8 0.963414634146341 79 27 96.3 0 9 245 51 129 RYG62853.1 MAG: aldo/keto reductase [archaeon] diamond 237 119 1 Archaea               archaeon
31209345 31209345 PRJNA1192965_P_NODE_4875_length_242_cov_0.911243_g4856_i0 PRJNA1192965 4875 242 0.911243 2.20520806 archaeon 1906665 Archaea Archaea 52.8 9.01e-6   NR RYH06179.1 1906665 g4856 i0 47.5 0.731404958677686 59 31 73.1 0 11 187 49 107 RYH06179.1 MAG: hypothetical protein EON65_43210, partial [archaeon] diamond 177 52.8 1 Archaea               archaeon
31431157 31431157 PRJNA1192965_P_NODE_3796_length_248_cov_1.320000_g3777_i0 PRJNA1192965 3796 248 1.32 3.2736 archaeon 1906665 Archaea Archaea 106 1.09e-25   NR RYG65852.1 1906665 g3777 i0 70.8 0.786290322580645 65 19 78.6 0 24 218 80 144 RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon] diamond 195 106 1 Archaea               archaeon
31557944 31557944 PRJNA1192965_P_NODE_2396_length_282_cov_1.473684_g2377_i0 PRJNA1192965 2396 282 1.473684 4.15578888 archaeon 1906665 Archaea Archaea 99 6.689999999999999e-23   NR RYH05309.1 1906665 g2377 i0 64 0.914893617021277 86 26 90.4 2 255 1 6 87 RYH05309.1 MAG: hypothetical protein EON65_45060 [archaeon] diamond 258 99 1 Archaea               archaeon
31937187 31937187 PRJNA1192965_P_NODE_3497_length_250_cov_0.870056_g3478_i0 PRJNA1192965 3497 250 0.870056 2.17514 archaeon 1906665 Archaea Archaea 43.9 0.0153   NR MCQ2816898.1 1906665 g3478 i0 39.7 0.756 63 33 75.6 2 1 189 239 296 MCQ2816898.1 TLD domain-containing protein [archaeon] diamond 189 43.9 1 Archaea               archaeon
32475396 32475396 PRJNA1192965_P_NODE_3519_length_250_cov_0.870056_g3500_i0 PRJNA1192965 3519 250 0.870056 2.17514 archaeon 1906665 Archaea Archaea 129 6.71e-35   NR RYG65938.1 1906665 g3500 i0 67.5 2.988 83 27 99.6 0 2 250 135 217 RYG65938.1 MAG: MFS transporter [archaeon] diamond 747 129 1 Archaea               archaeon
32821994 32821994 PRJNA1192965_P_NODE_3120_length_255_cov_2.115385_g3101_i0 PRJNA1192965 3120 255 2.115385 5.39423175 archaeon 1906665 Archaea Archaea 59.3 3.49e-9   NR RYH00022.1 1906665 g3101 i0 54.8 1.35294117647059 62 25 71.8 2 186 4 1 60 RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] diamond 345 59.3 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);;