RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 28 ✖

bioproject 1

  • PRJNA1214993 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
1605079 1605079 PRJNA1214993_P_NODE_23022_length_247_cov_0.896552_g22836_i0 PRJNA1214993 23022 247 0.896552 2.21448344 archaeon 1906665 Archaea Archaea 71.2 1.06e-13   NR RYH29248.1 1906665 g22836 i0 64.7 0.619433198380567 51 18 61.9 0 90 242 18 68 RYH29248.1 MAG: hypothetical protein EON65_09240 [archaeon] diamond 153 71.2 1 Archaea               archaeon
2881260 2881260 PRJNA1214993_P_NODE_23583_length_246_cov_0.901734_g23397_i0 PRJNA1214993 23583 246 0.901734 2.21826564 archaeon 1906665 Archaea Archaea 74.3 3.94e-15   NR RYG51560.1 1906665 g23397 i0 47.1 0.853658536585366 70 37 85.4 0 211 2 22 91 RYG51560.1 MAG: hypothetical protein EON66_10625 [archaeon] diamond 210 74.3 1 Archaea               archaeon
7983689 7983689 PRJNA1214993_P_NODE_14707_length_289_cov_1.217593_g14521_i0 PRJNA1214993 14707 289 1.217593 3.51884377 archaeon 1906665 Archaea Archaea 174 5.21e-53   NR MDP2436545.1 1906665 g14521 i0 83.2 16.7647058823529 95 16 98.6 0 287 3 13 107 MDP2436545.1 50S ribosomal protein L16 [archaeon] diamond 4845 174 1 Archaea               archaeon
11809076 11809076 PRJNA1214993_P_NODE_8790_length_367_cov_1.591837_g8604_i0 PRJNA1214993 8790 367 1.591837 5.84204179 archaeon 1906665 Archaea Archaea 201 2.32e-63   NR MDP2437167.1 1906665 g8604 i0 85.8 0.980926430517711 120 14 95.6 1 352 2 1 120 MDP2437167.1 50S ribosomal protein L5 [archaeon] diamond 360 201 1 Archaea               archaeon
16907483 16907483 PRJNA1214993_P_NODE_22454_length_248_cov_0.891429_g22268_i0 PRJNA1214993 22454 248 0.891429 2.21074392 archaeon 1906665 Archaea Archaea 129 8.230000000000001e-36   NR MDP2437167.1 1906665 g22268 i0 86.1 0.955645161290323 79 8 91.9 1 21 248 2 80 MDP2437167.1 50S ribosomal protein L5 [archaeon] diamond 237 129 1 Archaea               archaeon
26914399 26914399 PRJNA1214993_P_NODE_24702_length_244_cov_0.912281_g24516_i0 PRJNA1214993 24702 244 0.912281 2.22596564 archaeon 1906665 Archaea Archaea 82 1.28e-16   NR MDP2439760.1 1906665 g24516 i0 54.4 0.971311475409836 79 31 95.9 2 3 236 20 94 MDP2439760.1 YrhK family protein [archaeon] diamond 237 82 1 Archaea               archaeon
27072620 27072620 PRJNA1214993_P_NODE_16362_length_276_cov_1.536946_g16176_i0 PRJNA1214993 16362 276 1.536946 4.24197096 archaeon 1906665 Archaea Archaea 127 5.41e-33   NR RYY85487.1 1906665 g16176 i0 60 0.978260869565217 90 36 97.8 0 5 274 144 233 RYY85487.1 MAG: hypothetical protein EON63_07395 [archaeon] diamond 270 127 1 Archaea               archaeon
27104102 27104102 PRJNA1214993_P_NODE_20742_length_251_cov_0.865169_g20556_i0 PRJNA1214993 20742 251 0.865169 2.17157419 archaeon 1906665 Archaea Archaea 140 1.19e-39   NR RYG58925.1 1906665 g20556 i0 75.9 0.99203187250996006 83 20 99.2 0 250 2 15 97 RYG58925.1 MAG: 30S ribosomal protein S2, partial [archaeon] diamond 249 140 1 Archaea               archaeon
27325557 27325557 PRJNA1214993_P_NODE_19443_length_254_cov_1.292818_g19257_i0 PRJNA1214993 19443 254 1.292818 3.28375772 archaeon 1906665 Archaea Archaea 147 7.42e-40   NR MDP2437555.1 1906665 g19257 i0 82.1 0.992125984251969 84 15 99.2 0 2 253 319 402 MDP2437555.1 T-complex protein 1 subunit delta [archaeon] diamond 252 147 1 Archaea               archaeon
27609825 27609825 PRJNA1214993_P_NODE_15304_length_284_cov_1.478673_g15118_i0 PRJNA1214993 15304 284 1.478673 4.19943132 archaeon 1906665 Archaea Archaea 105 4.6e-25   NR RYH27425.1 1906665 g15118 i0 59.5 0.887323943661972 84 34 88.7 0 281 30 84 167 RYH27425.1 MAG: fatty acid hydroxylase family protein [archaeon] diamond 252 105 1 Archaea               archaeon
27641527 27641527 PRJNA1214993_P_NODE_14104_length_294_cov_1.049774_g13918_i0 PRJNA1214993 14104 294 1.049774 3.08633556 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 46.2 0.0042   NR MBI4450367.1 2026803 g13918 i0 28.4 0.969387755102041 95 57 91.8 3 6 275 295 383 MBI4450367.1 hypothetical protein [Candidatus Woesearchaeota archaeon] diamond 285 46.2 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
28367399 28367399 PRJNA1214993_P_NODE_21646_length_249_cov_0.886364_g21460_i0 PRJNA1214993 21646 249 0.886364 2.20704636 archaeon 1906665 Archaea Archaea 57.8 1.97e-7   NR RYG68276.1 1906665 g21460 i0 31.5 0.879518072289157 73 50 88 0 230 12 274 346 RYG68276.1 MAG: hypothetical protein EON64_05525 [archaeon] diamond 219 57.8 1 Archaea               archaeon
29175861 29175861 PRJNA1214993_P_NODE_1769_length_783_cov_1.963380_g1606_i0 PRJNA1214993 1769 783 1.96338 15.3732654 root 1 Root_unresolved Root_unresolved 117 5.0700000000000006e-27   NR NCP97750.1 1906665 g1606 i0 52.9 2.30651340996169 119 54 45.2 2 460 107 208 325 NCP97750.1 hypothetical protein [archaeon] diamond 1806 117 1 Archaea               archaeon
29220186 29220186 PRJNA1214993_P_NODE_21209_length_250_cov_0.881356_g21023_i0 PRJNA1214993 21209 250 0.881356 2.20339 archaeon 1906665 Archaea Archaea 40.8 0.0239   NR MDP2436356.1 1906665 g21023 i0 61.3 0.372 31 12 37.2 0 95 3 5 35 MDP2436356.1 hypothetical protein [archaeon] diamond 93 40.8 1 Archaea               archaeon
29346422 29346422 PRJNA1214993_P_NODE_3209_length_590_cov_6.193424_g3028_i0 PRJNA1214993 3209 590 6.193424 36.5412016 archaeon 1906665 Archaea Archaea 275 2.65e-91   NR MCQ2821492.1 1906665 g3028 i0 72.3 1.98305084745763 195 54 99.2 0 589 5 2 196 MCQ2821492.1 50S ribosomal protein L15e [archaeon] diamond 1170 275 1 Archaea               archaeon
29535775 29535775 PRJNA1214993_P_NODE_26130_length_242_cov_0.911243_g25944_i0 PRJNA1214993 26130 242 0.911243 2.20520806 archaeon 1906665 Archaea Archaea 95.9 7.38e-21   NR RYH17279.1 1906665 g25944 i0 46.9 1.00413223140496 81 42 99.2 1 240 1 304 384 RYH17279.1 MAG: ATP-binding cassette domain-containing protein [archaeon] diamond 243 95.9 1 Archaea               archaeon
30028453 30028453 PRJNA1214993_P_NODE_23691_length_246_cov_0.901734_g23505_i0 PRJNA1214993 23691 246 0.901734 2.21826564 root 1 Root_unresolved Root_unresolved 50.8 5.3e-5   NR MDP6200300.1 2666344 g23505 i0 64.7 4.03658536585366 34 12 41.5 0 155 54 474 507 MDP6200300.1 putative Ig domain-containing protein [Poseidonia sp.] diamond 993 51.2 0.9921875 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae Candidatus Poseidonia Poseidonia sp.
30230597 30230597 PRJNA1214993_P_NODE_20812_length_251_cov_0.865169_g20626_i0 PRJNA1214993 20812 251 0.865169 2.17157419 archaeon 1906665 Archaea Archaea 54.7 2.59e-6   NR RYH19147.1 1906665 g20626 i0 38.2 1.06374501992032 89 44 94.4 2 251 15 1163 1250 RYH19147.1 MAG: hypothetical protein EON65_26445 [archaeon] diamond 267 54.7 1 Archaea               archaeon
30420574 30420574 PRJNA1214993_P_NODE_25993_length_242_cov_0.923077_g25807_i0 PRJNA1214993 25993 242 0.923077 2.23384634 archaeon 1906665 Archaea Archaea 146 1.4699999999999999e-43   NR RYG58906.1 1906665 g25807 i0 90 0.991735537190083 80 8 99.2 0 3 242 27 106 RYG58906.1 MAG: hypothetical protein EON64_20810, partial [archaeon] diamond 240 146 1 Archaea               archaeon
30704505 30704505 PRJNA1214993_P_NODE_22414_length_248_cov_0.891429_g22228_i0 PRJNA1214993 22414 248 0.891429 2.21074392 archaeon 1906665 Archaea Archaea 119 1.05e-32   NR RYG63904.1 1906665 g22228 i0 72 0.991935483870968 82 23 99.2 0 2 247 29 110 RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] diamond 246 119 1 Archaea               archaeon
30736095 30736095 PRJNA1214993_P_NODE_19774_length_253_cov_0.866667_g19588_i0 PRJNA1214993 19774 253 0.866667 2.19266751 archaeon 1906665 Archaea Archaea 102 1.15e-24   NR RYG98538.1 1906665 g19588 i0 69.1 0.806324110671937 68 21 80.6 0 49 252 2 69 RYG98538.1 MAG: hypothetical protein EON65_51320 [archaeon] diamond 204 102 1 Archaea               archaeon
30736114 30736114 PRJNA1214993_P_NODE_9534_length_354_cov_1.110320_g9348_i0 PRJNA1214993 9534 354 1.11032 3.9305328 archaeon 1906665 Archaea Archaea 45.1 0.0134   NR MDP2438732.1 1906665 g9348 i0 32.5 0.966101694915254 114 64 89 3 31 345 5 114 MDP2438732.1 hypothetical protein [archaeon] diamond 342 45.1 1 Archaea               archaeon
30799215 30799215 PRJNA1214993_P_NODE_17734_length_266_cov_1.435233_g17548_i0 PRJNA1214993 17734 266 1.435233 3.81771978 archaeon 1906665 Archaea Archaea 111 2.5100000000000004e-27   NR RYY35779.1 1906665 g17548 i0 65.5 0.981203007518797 87 28 97 2 7 264 196 281 RYY35779.1 MAG: aldehyde dehydrogenase family protein, partial [archaeon] diamond 261 111 1 Archaea               archaeon
30830919 30830919 PRJNA1214993_P_NODE_17034_length_271_cov_1.575758_g16848_i0 PRJNA1214993 17034 271 1.575758 4.27030418 Promethearchaeota archaeon 2053489 Archaea Archaea 44.3 0.0139   NR NHI91685.1 2053489 g16848 i0 42.9 1.36162361623616 49 28 54.2 0 268 122 155 203 NHI91685.1 GTP-binding protein [Promethearchaeota archaeon] diamond 369 44.3 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
30957523 30957523 PRJNA1214993_P_NODE_25094_length_244_cov_0.871345_g24908_i0 PRJNA1214993 25094 244 0.871345 2.1260818 Candidatus Iainarchaeum archaeon 3101447 Archaea Archaea 49.3 1.85e-4   NR RLG70075.1 2026736 g24908 i0 41.8 0.823770491803279 67 39 82.4 0 2 202 508 574 RLG70075.1 MAG: threonine--tRNA ligase [Candidatus Iainarchaeum archaeon] diamond 201 49.3 1 Archaea   Nanobdellati Candidatus Iainarchaeota       Candidatus Iainarchaeum Candidatus Iainarchaeum archaeon
31039645 31039645 PRJNA1214993_P_NODE_11655_length_323_cov_0.832000_g11469_i0 PRJNA1214993 11655 323 0.832 2.68736 root 1 Root_unresolved Root_unresolved 139 3.44e-38   NR MDP2438418.1 1906665 g11469 i0 60 2.95356037151703 105 42 97.5 0 321 7 148 252 MDP2438418.1 MaoC/PaaZ C-terminal domain-containing protein [archaeon] diamond 954 140 0.992857142857143 Archaea               archaeon
31273364 31273364 PRJNA1214993_P_NODE_24755_length_244_cov_0.912281_g24569_i0 PRJNA1214993 24755 244 0.912281 2.22596564 archaeon 1906665 Archaea Archaea 139 4.14e-38   NR RYG67480.1 1906665 g24569 i0 81.5 0.995901639344262 81 15 99.6 0 1 243 30 110 RYG67480.1 MAG: ADP-forming succinate--CoA ligase subunit beta [archaeon] diamond 243 139 1 Archaea               archaeon
31513841 31513841 PRJNA1214993_P_NODE_23516_length_246_cov_0.901734_g23330_i0 PRJNA1214993 23516 246 0.901734 2.21826564 Stenosarchaea group 2290931 Archaea Archaea 43.5 0.0149   NR TFG00615.1 2053489 g23330 i0 33.3 1.71951219512195 84 48 92.7 3 228 1 95 178 TFG00615.1 MAG: GTP-binding protein [Promethearchaeota archaeon] diamond 423 43.5 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota 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);;