contig_metadata
31 rows where bioproject = "PRJNA760976" and tax_superkingdom = "Archaea"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5845977 | 5845977 | PRJNA760976_P_NODE_50345_length_247_cov_0.885057_g50024_i0 | PRJNA760976 | 50345 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 91.3 | 1.95e-21 | NR | MDP2439833.1 | 1906665 | g50024 | i0 | 46.8 | 0.959514170040486 | 79 | 42 | 96 | 0 | 239 | 3 | 13 | 91 | MDP2439833.1 thioredoxin domain-containing protein [archaeon] | diamond | 237 | 91.3 | 1 | Archaea | archaeon | ||||||||
| 12221936 | 12221936 | PRJNA760976_P_NODE_11310_length_429_cov_3.258427_g10990_i0 | PRJNA760976 | 11310 | 429 | 3.258427 | 13.97865183 | archaeon | 1906665 | Archaea | Archaea | 122 | 4.53e-33 | NR | MDP2439821.1 | 1906665 | g10990 | i0 | 65.5 | 0.811188811188811 | 116 | 37 | 79 | 1 | 413 | 75 | 1 | 116 | MDP2439821.1 eS25 family ribosomal protein [archaeon] | diamond | 348 | 122 | 1 | Archaea | archaeon | ||||||||
| 12221973 | 12221973 | PRJNA760976_P_NODE_21210_length_342_cov_1.137546_g20889_i0 | PRJNA760976 | 21210 | 342 | 1.137546 | 3.89040732 | archaeon | 1906665 | Archaea | Archaea | 123 | 3.01e-33 | NR | MDP2438822.1 | 1906665 | g20889 | i0 | 84.9 | 0.640350877192982 | 73 | 11 | 64 | 0 | 221 | 3 | 1 | 73 | MDP2438822.1 50S ribosomal protein L11 [archaeon] | diamond | 219 | 123 | 1 | Archaea | archaeon | ||||||||
| 12222086 | 12222086 | PRJNA760976_P_NODE_8850_length_471_cov_1.537688_g8531_i0 | PRJNA760976 | 8850 | 471 | 1.537688 | 7.24251048 | archaeon | 1906665 | Archaea | Archaea | 214 | 2.68e-68 | NR | MDP2434214.1 | 1906665 | g8531 | i0 | 79.7 | 0.942675159235669 | 148 | 30 | 94.3 | 0 | 7 | 450 | 1 | 148 | MDP2434214.1 50S ribosomal protein L19e [archaeon] | diamond | 444 | 214 | 1 | Archaea | archaeon | ||||||||
| 14771310 | 14771310 | PRJNA760976_P_NODE_47092_length_253_cov_1.266667_g46771_i0 | PRJNA760976 | 47092 | 253 | 1.266667 | 3.20466751 | archaeon | 1906665 | Archaea | Archaea | 155 | 2.6299999999999997e-45 | NR | MDP2435760.1 | 1906665 | g46771 | i0 | 90.4 | 0.984189723320158 | 83 | 8 | 98.4 | 0 | 249 | 1 | 117 | 199 | MDP2435760.1 30S ribosomal protein S3 [archaeon] | diamond | 249 | 155 | 1 | Archaea | archaeon | ||||||||
| 16507877 | 16507877 | PRJNA760976_P_NODE_15093_length_385_cov_1.900641_g14772_i0 | PRJNA760976 | 15093 | 385 | 1.900641 | 7.31746785 | archaeon | 1906665 | Archaea | Archaea | 189 | 4.95e-57 | NR | MDP2437415.1 | 1906665 | g14772 | i0 | 71.4 | 4.87792207792208 | 126 | 36 | 98.2 | 0 | 7 | 384 | 1 | 126 | MDP2437415.1 hypothetical protein [archaeon] | diamond | 1878 | 189 | 1 | Archaea | archaeon | ||||||||
| 18593990 | 18593990 | PRJNA760976_P_NODE_13355_length_402_cov_1.167173_g13035_i0 | PRJNA760976 | 13355 | 402 | 1.167173 | 4.69203546 | archaeon | 1906665 | Archaea | Archaea | 231 | 8.48e-76 | NR | MDP2435192.1 | 1906665 | g13035 | i0 | 95.9 | 0.902985074626866 | 121 | 4 | 90.3 | 1 | 363 | 1 | 1 | 120 | MDP2435192.1 F-actin-capping protein subunit beta [archaeon] | diamond | 363 | 231 | 1 | Archaea | archaeon | ||||||||
| 19869242 | 19869242 | PRJNA760976_P_NODE_27016_length_314_cov_1.307054_g26695_i0 | PRJNA760976 | 27016 | 314 | 1.307054 | 4.10414956 | archaeon | 1906665 | Archaea | Archaea | 160 | 4.419999999999999e-47 | NR | MDP2436279.1 | 1906665 | g26695 | i0 | 82.3 | 0.917197452229299 | 96 | 17 | 91.7 | 0 | 289 | 2 | 1 | 96 | MDP2436279.1 hypothetical protein [archaeon] | diamond | 288 | 160 | 1 | Archaea | archaeon | ||||||||
| 27021520 | 27021520 | PRJNA760976_P_NODE_15422_length_382_cov_1.453074_g15101_i0 | PRJNA760976 | 15422 | 382 | 1.453074 | 5.55074268 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 57 | 1.8e-6 | NR | MFH0986869.1 | 2250274 | g15101 | i0 | 37.9 | 0.683246073298429 | 87 | 45 | 62.8 | 2 | 358 | 119 | 193 | 277 | MFH0986869.1 hypothetical protein [Candidatus Micrarchaeota archaeon] | diamond | 261 | 57 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 27653557 | 27653557 | PRJNA760976_P_NODE_46524_length_254_cov_1.668508_g46203_i0 | PRJNA760976 | 46524 | 254 | 1.668508 | 4.23801032 | archaeon | 1906665 | Archaea | Archaea | 99.8 | 3.1999999999999997e-25 | NR | MDP2438881.1 | 1906665 | g46203 | i0 | 55.6 | 0.956692913385827 | 81 | 35 | 95.7 | 1 | 6 | 248 | 1 | 80 | MDP2438881.1 hypothetical protein [archaeon] | diamond | 243 | 99.8 | 1 | Archaea | archaeon | ||||||||
| 27779812 | 27779812 | PRJNA760976_P_NODE_55124_length_242_cov_0.911243_g54803_i0 | PRJNA760976 | 55124 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 102 | 1.5899999999999999e-24 | NR | MDP2439172.1 | 1906665 | g54803 | i0 | 65.7 | 0.867768595041322 | 70 | 24 | 86.8 | 0 | 241 | 32 | 206 | 275 | MDP2439172.1 S1 RNA-binding domain-containing protein [archaeon] | diamond | 210 | 102 | 1 | Archaea | archaeon | ||||||||
| 28262799 | 28262799 | PRJNA760976_P_NODE_51966_length_245_cov_0.895349_g51645_i0 | PRJNA760976 | 51966 | 245 | 0.895349 | 2.19360505 | Methanothrix | 2222 | Archaea | Archaea | 48.9 | 2.58e-4 | NR | WP_157863671.1 | 2223 | g51645 | i0 | 45.3 | 6.26938775510204 | 64 | 30 | 77.1 | 3 | 202 | 14 | 8 | 67 | WP_157863671.1 trypsin-like serine protease [Methanothrix soehngenii] | diamond | 1536 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 28316495 | 28316495 | PRJNA760976_P_NODE_48526_length_250_cov_0.870056_g48205_i0 | PRJNA760976 | 48526 | 250 | 0.870056 | 2.17514 | archaeon | 1906665 | Archaea | Archaea | 99 | 6.86e-22 | NR | MDP2435499.1 | 1906665 | g48205 | i0 | 58.5 | 0.984 | 82 | 34 | 98.4 | 0 | 4 | 249 | 612 | 693 | MDP2435499.1 hypothetical protein [archaeon] | diamond | 246 | 99 | 1 | Archaea | archaeon | ||||||||
| 28474344 | 28474344 | PRJNA760976_P_NODE_48066_length_251_cov_0.865169_g47745_i0 | PRJNA760976 | 48066 | 251 | 0.865169 | 2.17157419 | archaeon | 1906665 | Archaea | Archaea | 124 | 7.6399999999999995e-34 | NR | MDP2434989.1 | 1906665 | g47745 | i0 | 87.2 | 0.932270916334661 | 78 | 10 | 93.2 | 0 | 238 | 5 | 114 | 191 | MDP2434989.1 ankyrin repeat domain-containing protein [archaeon] | diamond | 234 | 124 | 1 | Archaea | archaeon | ||||||||
| 28505882 | 28505882 | PRJNA760976_P_NODE_48627_length_250_cov_0.870056_g48306_i0 | PRJNA760976 | 48627 | 250 | 0.870056 | 2.17514 | archaeon | 1906665 | Archaea | Archaea | 86.7 | 8.85e-20 | NR | MDP2438202.1 | 1906665 | g48306 | i0 | 47.1 | 1.02 | 85 | 43 | 99.6 | 1 | 2 | 250 | 24 | 108 | MDP2438202.1 hypothetical protein [archaeon] | diamond | 255 | 86.7 | 1 | Archaea | archaeon | ||||||||
| 28505883 | 28505883 | PRJNA760976_P_NODE_51467_length_246_cov_0.861272_g51146_i0 | PRJNA760976 | 51467 | 246 | 0.861272 | 2.11872912 | archaeon | 1906665 | Archaea | Archaea | 75.9 | 1.31e-15 | NR | MDP2438964.1 | 1906665 | g51146 | i0 | 52.7 | 0.902439024390244 | 74 | 31 | 85.4 | 1 | 237 | 28 | 27 | 100 | MDP2438964.1 hypothetical protein [archaeon] | diamond | 222 | 75.9 | 1 | Archaea | archaeon | ||||||||
| 28663819 | 28663819 | PRJNA760976_P_NODE_22747_length_333_cov_1.750000_g22426_i0 | PRJNA760976 | 22747 | 333 | 1.75 | 5.8275 | archaeon | 1906665 | Archaea | Archaea | 121 | 2.95e-29 | NR | MDP2439127.1 | 1906665 | g22426 | i0 | 71.4 | 0.81981981981982 | 91 | 25 | 81.1 | 1 | 270 | 1 | 2 | 92 | MDP2439127.1 molecular chaperone HtpG [archaeon] | diamond | 273 | 121 | 1 | Archaea | archaeon | ||||||||
| 28821317 | 28821317 | PRJNA760976_P_NODE_48608_length_250_cov_0.870056_g48287_i0 | PRJNA760976 | 48608 | 250 | 0.870056 | 2.17514 | archaeon | 1906665 | Archaea | Archaea | 99.8 | 3.25e-24 | NR | MDP2436035.1 | 1906665 | g48287 | i0 | 58.7 | 0.9 | 75 | 31 | 90 | 0 | 227 | 3 | 12 | 86 | MDP2436035.1 peroxiredoxin [archaeon] | diamond | 225 | 99.8 | 1 | Archaea | archaeon | ||||||||
| 28852969 | 28852969 | PRJNA760976_P_NODE_41648_length_267_cov_1.231959_g41327_i0 | PRJNA760976 | 41648 | 267 | 1.231959 | 3.28933053 | archaeon | 1906665 | Archaea | Archaea | 72.8 | 1.19e-12 | NR | MDP2434733.1 | 1906665 | g41327 | i0 | 83.7 | 0.48314606741573 | 43 | 7 | 48.3 | 0 | 2 | 130 | 358 | 400 | MDP2434733.1 60S ribosomal protein L3 [archaeon] | diamond | 129 | 72.8 | 1 | Archaea | archaeon | ||||||||
| 28916094 | 28916094 | PRJNA760976_P_NODE_29148_length_305_cov_2.849138_g28827_i0 | PRJNA760976 | 29148 | 305 | 2.849138 | 8.6898709 | archaeon | 1906665 | Archaea | Archaea | 144 | 6.53e-42 | NR | MDP2438488.1 | 1906665 | g28827 | i0 | 70.2 | 0.924590163934426 | 94 | 28 | 92.5 | 0 | 282 | 1 | 1 | 94 | MDP2438488.1 KOW motif-containing protein [archaeon] | diamond | 282 | 144 | 1 | Archaea | archaeon | ||||||||
| 29137623 | 29137623 | PRJNA760976_P_NODE_3509_length_696_cov_2.268058_g3206_i0 | PRJNA760976 | 3509 | 696 | 2.268058 | 15.78568368 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 121 | 4.44e-30 | NR | HWG91149.1 | 2806419 | g3206 | i0 | 32.6 | 0.741379310344828 | 172 | 116 | 74.1 | 0 | 582 | 67 | 6 | 177 | HWG91149.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 516 | 121 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29989978 | 29989978 | PRJNA760976_P_NODE_56011_length_241_cov_1.375000_g55690_i0 | PRJNA760976 | 56011 | 241 | 1.375 | 3.31375 | archaeon | 1906665 | Archaea | Archaea | 96.7 | 5.2e-22 | NR | MDP2437415.1 | 1906665 | g55690 | i0 | 59.5 | 0.983402489626556 | 79 | 30 | 98.3 | 1 | 239 | 3 | 204 | 280 | MDP2437415.1 hypothetical protein [archaeon] | diamond | 237 | 96.7 | 1 | Archaea | archaeon | ||||||||
| 30495601 | 30495601 | PRJNA760976_P_NODE_33153_length_292_cov_0.817352_g32832_i0 | PRJNA760976 | 33153 | 292 | 0.817352 | 2.38666784 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 88.6 | 4.03e-18 | NR | TXT59832.1 | 2053489 | g32832 | i0 | 47.9 | 0.965753424657534 | 94 | 45 | 96.6 | 2 | 290 | 9 | 356 | 445 | TXT59832.1 MAG: Cyclic 2,3-diphosphoglycerate synthetase [Promethearchaeota archaeon] | diamond | 282 | 88.6 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30811406 | 30811406 | PRJNA760976_P_NODE_6714_length_524_cov_0.895787_g6396_i0 | PRJNA760976 | 6714 | 524 | 0.895787 | 4.69392388 | archaeon | 1906665 | Archaea | Archaea | 264 | 1.7e-86 | NR | MDP2437012.1 | 1906665 | g6396 | i0 | 78.9 | 0.950381679389313 | 166 | 35 | 95 | 0 | 25 | 522 | 1 | 166 | MDP2437012.1 S6e family ribosomal protein [archaeon] | diamond | 498 | 264 | 1 | Archaea | archaeon | ||||||||
| 30937947 | 30937947 | PRJNA760976_P_NODE_55114_length_242_cov_0.911243_g54793_i0 | PRJNA760976 | 55114 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 73.2 | 3.58e-13 | NR | MDP2435090.1 | 1906665 | g54793 | i0 | 40.7 | 1.00413223140496 | 81 | 47 | 99.2 | 1 | 241 | 2 | 78 | 158 | MDP2435090.1 elongation of very long chain fatty acids protein [archaeon] | diamond | 243 | 73.2 | 1 | Archaea | archaeon | ||||||||
| 31601891 | 31601891 | PRJNA760976_P_NODE_28516_length_308_cov_1.276596_g28195_i0 | PRJNA760976 | 28516 | 308 | 1.276596 | 3.93191568 | archaeon | 1906665 | Archaea | Archaea | 56.2 | 1.11e-6 | NR | MDP2434431.1 | 1906665 | g28195 | i0 | 57.9 | 0.555194805194805 | 57 | 19 | 53.6 | 2 | 120 | 284 | 226 | 279 | MDP2434431.1 hypothetical protein [archaeon] | diamond | 171 | 56.2 | 1 | Archaea | archaeon | ||||||||
| 31822983 | 31822983 | PRJNA760976_P_NODE_14997_length_386_cov_1.476038_g14676_i0 | PRJNA760976 | 14997 | 386 | 1.476038 | 5.69750668 | archaeon | 1906665 | Archaea | Archaea | 152 | 2.2299999999999993e-42 | NR | MDP2438433.1 | 1906665 | g14676 | i0 | 64.7 | 0.924870466321243 | 119 | 41 | 92.5 | 1 | 364 | 8 | 1 | 118 | MDP2438433.1 guanylate kinase [archaeon] | diamond | 357 | 152 | 1 | Archaea | archaeon | ||||||||
| 32139608 | 32139608 | PRJNA760976_P_NODE_48598_length_250_cov_0.870056_g48277_i0 | PRJNA760976 | 48598 | 250 | 0.870056 | 2.17514 | archaeon | 1906665 | Archaea | Archaea | 87.4 | 7.58e-18 | NR | MDP2434858.1 | 1906665 | g48277 | i0 | 73.3 | 0.72 | 60 | 16 | 72 | 0 | 1 | 180 | 514 | 573 | MDP2434858.1 AAA family ATPase [archaeon] | diamond | 180 | 87.4 | 1 | Archaea | archaeon | ||||||||
| 32424337 | 32424337 | PRJNA760976_P_NODE_48559_length_250_cov_0.870056_g48238_i0 | PRJNA760976 | 48559 | 250 | 0.870056 | 2.17514 | archaeon | 1906665 | Archaea | Archaea | 100 | 4.7199999999999996e-23 | NR | MDP2439270.1 | 1906665 | g48238 | i0 | 60.2 | 0.996 | 83 | 33 | 99.6 | 0 | 250 | 2 | 268 | 350 | MDP2439270.1 replication factor C small subunit [archaeon] | diamond | 249 | 100 | 1 | Archaea | archaeon | ||||||||
| 32551174 | 32551174 | PRJNA760976_P_NODE_51559_length_245_cov_2.238372_g51238_i0 | PRJNA760976 | 51559 | 245 | 2.238372 | 5.4840114 | archaeon | 1906665 | Archaea | Archaea | 98.6 | 7.949999999999999e-23 | NR | MDP2435546.1 | 1906665 | g51238 | i0 | 67.2 | 0.783673469387755 | 64 | 21 | 78.4 | 0 | 52 | 243 | 1 | 64 | MDP2435546.1 30S ribosomal protein S2 [archaeon] | diamond | 192 | 98.6 | 1 | Archaea | archaeon | ||||||||
| 32582602 | 32582602 | PRJNA760976_P_NODE_16059_length_377_cov_1.368421_g15738_i0 | PRJNA760976 | 16059 | 377 | 1.368421 | 5.15894717 | archaeon | 1906665 | Archaea | Archaea | 149 | 1.3399999999999996e-43 | NR | MDP2436531.1 | 1906665 | g15738 | i0 | 62.9 | 0.923076923076923 | 116 | 42 | 92.3 | 1 | 356 | 9 | 1 | 115 | MDP2436531.1 translation initiation factor IF-5A [archaeon] | diamond | 348 | 149 | 1 | Archaea | archaeon |
Advanced export
JSON shape: default, array, newline-delimited
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);;