contig_metadata
35 rows where bioproject = "PRJNA1002816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000856 | 1000856 | PRJNA1002816_P_NODE_14441_length_287_cov_1.434579_g14281_i0 | PRJNA1002816 | 14441 | 287 | 1.434579 | 4.11724173 | archaeon | 1906665 | Archaea | Archaea | 176 | 4.79e-51 | NR | MDP2435088.1 | 1906665 | g14281 | i0 | 89.5 | 0.993031358885017 | 95 | 10 | 99.3 | 0 | 2 | 286 | 106 | 200 | MDP2435088.1 tubulin beta chain [archaeon] | diamond | 285 | 176 | 1 | Archaea | archaeon | ||||||||
| 1427747 | 1427747 | PRJNA1002816_P_NODE_6482_length_445_cov_2.193548_g6322_i0 | PRJNA1002816 | 6482 | 445 | 2.193548 | 9.7612886 | archaeon | 1906665 | Archaea | Archaea | 197 | 1.8e-59 | NR | RYG67981.1 | 1906665 | g6322 | i0 | 70.5 | 1.9685393258427 | 146 | 40 | 98.4 | 1 | 440 | 3 | 154 | 296 | RYG67981.1 MAG: malate dehydrogenase [archaeon] | diamond | 876 | 197 | 1 | Archaea | archaeon | ||||||||
| 3979250 | 3979250 | PRJNA1002816_P_NODE_15944_length_269_cov_1.964286_g15784_i0 | PRJNA1002816 | 15944 | 269 | 1.964286 | 5.28392934 | archaeon | 1906665 | Archaea | Archaea | 160 | 7.83e-45 | NR | MDP2437013.1 | 1906665 | g15784 | i0 | 87.6 | 0.992565055762082 | 89 | 11 | 99.3 | 0 | 269 | 3 | 356 | 444 | MDP2437013.1 adenosylhomocysteinase [archaeon] | diamond | 267 | 160 | 1 | Archaea | archaeon | ||||||||
| 4828934 | 4828934 | PRJNA1002816_P_NODE_8824_length_378_cov_1.249180_g8664_i0 | PRJNA1002816 | 8824 | 378 | 1.24918 | 4.7219004 | archaeon | 1906665 | Archaea | Archaea | 230 | 9.38e-72 | NR | MDP2434733.1 | 1906665 | g8664 | i0 | 85.6 | 0.992063492063492 | 125 | 18 | 99.2 | 0 | 377 | 3 | 162 | 286 | MDP2434733.1 60S ribosomal protein L3 [archaeon] | diamond | 375 | 230 | 1 | Archaea | archaeon | ||||||||
| 6531175 | 6531175 | PRJNA1002816_P_NODE_6386_length_448_cov_1.514667_g6226_i0 | PRJNA1002816 | 6386 | 448 | 1.514667 | 6.78570816 | archaeon | 1906665 | Archaea | Archaea | 239 | 3.18e-77 | NR | MDP2437012.1 | 1906665 | g6226 | i0 | 83.7 | 0.984375 | 147 | 24 | 98.4 | 0 | 6 | 446 | 43 | 189 | MDP2437012.1 S6e family ribosomal protein [archaeon] | diamond | 441 | 239 | 1 | Archaea | archaeon | ||||||||
| 9080318 | 9080318 | PRJNA1002816_P_NODE_16148_length_267_cov_1.252577_g15988_i0 | PRJNA1002816 | 16148 | 267 | 1.252577 | 3.34438059 | archaeon | 1906665 | Archaea | Archaea | 137 | 3.14e-35 | NR | MDP2439127.1 | 1906665 | g15988 | i0 | 77.5 | 1 | 89 | 20 | 100 | 0 | 1 | 267 | 49 | 137 | MDP2439127.1 molecular chaperone HtpG [archaeon] | diamond | 267 | 137 | 1 | Archaea | archaeon | ||||||||
| 16303392 | 16303392 | PRJNA1002816_P_NODE_20573_length_242_cov_0.911243_g20413_i0 | PRJNA1002816 | 20573 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 138 | 4.95e-39 | NR | MDP2436279.1 | 1906665 | g20413 | i0 | 80 | 0.991735537190083 | 80 | 16 | 99.2 | 0 | 2 | 241 | 14 | 93 | MDP2436279.1 hypothetical protein [archaeon] | diamond | 240 | 138 | 1 | Archaea | archaeon | ||||||||
| 16729740 | 16729740 | PRJNA1002816_P_NODE_14554_length_286_cov_1.262911_g14394_i0 | PRJNA1002816 | 14554 | 286 | 1.262911 | 3.61192546 | archaeon | 1906665 | Archaea | Archaea | 72.8 | 5.82e-13 | NR | MDP2437012.1 | 1906665 | g14394 | i0 | 75.4 | 0.597902097902098 | 57 | 14 | 59.8 | 0 | 285 | 115 | 182 | 238 | MDP2437012.1 S6e family ribosomal protein [archaeon] | diamond | 171 | 72.8 | 1 | Archaea | archaeon | ||||||||
| 17578725 | 17578725 | PRJNA1002816_P_NODE_12354_length_315_cov_0.954545_g12194_i0 | PRJNA1002816 | 12354 | 315 | 0.954545 | 3.00681675 | archaeon | 1906665 | Archaea | Archaea | 57.8 | 3.9e-7 | NR | MDP2438999.1 | 1906665 | g12194 | i0 | 51.9 | 0.752380952380952 | 79 | 35 | 75.2 | 1 | 253 | 17 | 78 | 153 | MDP2438999.1 hypothetical protein [archaeon] | diamond | 237 | 57.8 | 1 | Archaea | archaeon | ||||||||
| 20554042 | 20554042 | PRJNA1002816_P_NODE_16437_length_263_cov_1.342105_g16277_i0 | PRJNA1002816 | 16437 | 263 | 1.342105 | 3.52973615 | archaeon | 1906665 | Archaea | Archaea | 133 | 1.14e-37 | NR | MDP2439536.1 | 1906665 | g16277 | i0 | 69.9 | 10.5399239543726 | 83 | 25 | 94.7 | 0 | 5 | 253 | 20 | 102 | MDP2439536.1 hypothetical protein [archaeon] | diamond | 2772 | 133 | 1 | Archaea | archaeon | ||||||||
| 21829857 | 21829857 | PRJNA1002816_P_NODE_8298_length_391_cov_1.172956_g8138_i0 | PRJNA1002816 | 8298 | 391 | 1.172956 | 4.58625796 | archaeon | 1906665 | Archaea | Archaea | 208 | 4.18e-65 | NR | MDP2436818.1 | 1906665 | g8138 | i0 | 77.2 | 0.974424552429668 | 127 | 29 | 97.4 | 0 | 381 | 1 | 69 | 195 | MDP2436818.1 50S ribosomal protein L2 [archaeon] | diamond | 381 | 208 | 1 | Archaea | archaeon | ||||||||
| 23105180 | 23105180 | PRJNA1002816_P_NODE_21079_length_232_cov_2.553459_g20919_i0 | PRJNA1002816 | 21079 | 232 | 2.553459 | 5.92402488 | archaeon | 1906665 | Archaea | Archaea | 154 | 1.1499999999999999e-42 | NR | MDP2436838.1 | 1906665 | g20919 | i0 | 86.8 | 0.982758620689655 | 76 | 10 | 98.3 | 0 | 231 | 4 | 73 | 148 | MDP2436838.1 inorganic diphosphatase [archaeon] | diamond | 228 | 154 | 1 | Archaea | archaeon | ||||||||
| 26622827 | 26622827 | PRJNA1002816_P_NODE_20281_length_243_cov_0.905882_g20121_i0 | PRJNA1002816 | 20281 | 243 | 0.905882 | 2.20129326 | archaeon | 1906665 | Archaea | Archaea | 112 | 8.150000000000001e-27 | NR | MDP2437935.1 | 1906665 | g20121 | i0 | 66.3 | 0.987654320987654 | 80 | 25 | 98.8 | 2 | 241 | 2 | 375 | 452 | MDP2437935.1 hypothetical protein [archaeon] | diamond | 240 | 112 | 1 | Archaea | archaeon | ||||||||
| 26686140 | 26686140 | PRJNA1002816_P_NODE_18321_length_249_cov_0.875000_g18161_i0 | PRJNA1002816 | 18321 | 249 | 0.875 | 2.17875 | archaeon | 1906665 | Archaea | Archaea | 48.9 | 8.23e-5 | NR | MDP2436043.1 | 1906665 | g18161 | i0 | 58.8 | 0.409638554216867 | 34 | 14 | 41 | 0 | 142 | 41 | 35 | 68 | MDP2436043.1 hypothetical protein [archaeon] | diamond | 102 | 48.9 | 1 | Archaea | archaeon | ||||||||
| 26844808 | 26844808 | PRJNA1002816_P_NODE_18661_length_248_cov_0.880000_g18501_i0 | PRJNA1002816 | 18661 | 248 | 0.88 | 2.1824 | archaeon | 1906665 | Archaea | Archaea | 137 | 1.19e-38 | NR | MDP2437352.1 | 1906665 | g18501 | i0 | 81.7 | 0.991935483870968 | 82 | 15 | 99.2 | 0 | 248 | 3 | 114 | 195 | MDP2437352.1 TCP-1/cpn60 chaperonin family protein [archaeon] | diamond | 246 | 137 | 1 | Archaea | archaeon | ||||||||
| 26907869 | 26907869 | PRJNA1002816_P_NODE_18982_length_247_cov_0.885057_g18822_i0 | PRJNA1002816 | 18982 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 100 | 1.5099999999999998e-23 | NR | MDP2435546.1 | 1906665 | g18822 | i0 | 71.2 | 0.801619433198381 | 66 | 19 | 80.2 | 0 | 43 | 240 | 8 | 73 | MDP2435546.1 30S ribosomal protein S2 [archaeon] | diamond | 198 | 100 | 1 | Archaea | archaeon | ||||||||
| 27065933 | 27065933 | PRJNA1002816_P_NODE_12902_length_308_cov_1.268085_g12742_i0 | PRJNA1002816 | 12902 | 308 | 1.268085 | 3.9057018 | archaeon | 1906665 | Archaea | Archaea | 190 | 5.88e-60 | NR | MDP2438463.1 | 1906665 | g12742 | i0 | 88.2 | 0.993506493506494 | 102 | 12 | 99.4 | 0 | 3 | 308 | 2 | 103 | MDP2438463.1 MC/SLC25 family protein [archaeon] | diamond | 306 | 190 | 1 | Archaea | archaeon | ||||||||
| 27223911 | 27223911 | PRJNA1002816_P_NODE_14123_length_291_cov_1.357798_g13963_i0 | PRJNA1002816 | 14123 | 291 | 1.357798 | 3.95119218 | Halovenus rubra | 869890 | Archaea | Archaea | 43.5 | 0.032 | NR | WP_267637460.1 | 869890 | g13963 | i0 | 29.9 | 0.896907216494845 | 87 | 55 | 89.7 | 1 | 26 | 286 | 222 | 302 | WP_267637460.1 hypothetical protein [Halovenus rubra] | diamond | 261 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halovenus | Halovenus rubra | |
| 27319069 | 27319069 | PRJNA1002816_P_NODE_14723_length_284_cov_1.170616_g14563_i0 | PRJNA1002816 | 14723 | 284 | 1.170616 | 3.32454944 | archaeon | 1906665 | Archaea | Archaea | 64.7 | 4.72e-11 | NR | MDP2439853.1 | 1906665 | g14563 | i0 | 38 | 0.834507042253521 | 79 | 49 | 83.5 | 0 | 1 | 237 | 16 | 94 | MDP2439853.1 hypothetical protein [archaeon] | diamond | 237 | 64.7 | 1 | Archaea | archaeon | ||||||||
| 27508596 | 27508596 | PRJNA1002816_P_NODE_16223_length_266_cov_1.181347_g16063_i0 | PRJNA1002816 | 16223 | 266 | 1.181347 | 3.14238302 | archaeon | 1906665 | Archaea | Archaea | 130 | 5.18e-33 | NR | MDP2435572.1 | 1906665 | g16063 | i0 | 73.8 | 0.947368421052632 | 84 | 17 | 94.7 | 1 | 3 | 254 | 213 | 291 | MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon] | diamond | 252 | 130 | 1 | Archaea | archaeon | ||||||||
| 27761320 | 27761320 | PRJNA1002816_P_NODE_14304_length_289_cov_0.995370_g14144_i0 | PRJNA1002816 | 14304 | 289 | 0.99537 | 2.8766193 | archaeon | 1906665 | Archaea | Archaea | 120 | 1.0299999999999998e-31 | NR | MDP2436999.1 | 1906665 | g14144 | i0 | 64.6 | 0.996539792387543 | 96 | 34 | 99.7 | 0 | 288 | 1 | 92 | 187 | MDP2436999.1 60S ribosomal protein L13 [archaeon] | diamond | 288 | 120 | 1 | Archaea | archaeon | ||||||||
| 27950509 | 27950509 | PRJNA1002816_P_NODE_11645_length_325_cov_1.253968_g11485_i0 | PRJNA1002816 | 11645 | 325 | 1.253968 | 4.075396 | archaeon | 1906665 | Archaea | Archaea | 122 | 1.09e-31 | NR | MDP2437927.1 | 1906665 | g11485 | i0 | 65.3 | 0.876923076923077 | 95 | 29 | 87.7 | 1 | 40 | 324 | 6 | 96 | MDP2437927.1 50S ribosomal protein L10 [archaeon] | diamond | 285 | 122 | 1 | Archaea | archaeon | ||||||||
| 28108176 | 28108176 | PRJNA1002816_P_NODE_14445_length_287_cov_1.415888_g14285_i0 | PRJNA1002816 | 14445 | 287 | 1.415888 | 4.06359856 | archaeon | 1906665 | Archaea | Archaea | 45.4 | 0.0074 | NR | MDP2435053.1 | 1906665 | g14285 | i0 | 33.3 | 1.00348432055749 | 96 | 55 | 95.1 | 2 | 12 | 284 | 1105 | 1196 | MDP2435053.1 hypothetical protein [archaeon] | diamond | 288 | 45.4 | 1 | Archaea | archaeon | ||||||||
| 28802710 | 28802710 | PRJNA1002816_P_NODE_12848_length_309_cov_0.978814_g12688_i0 | PRJNA1002816 | 12848 | 309 | 0.978814 | 3.02453526 | archaeon | 1906665 | Archaea | Archaea | 60.8 | 7.89e-9 | NR | MDP2439353.1 | 1906665 | g12688 | i0 | 67.4 | 0.41747572815534 | 43 | 14 | 41.7 | 0 | 131 | 3 | 1 | 43 | MDP2439353.1 ubiquinol-cytochrome c reductase iron-sulfur subunit [archaeon] | diamond | 129 | 60.8 | 1 | Archaea | archaeon | ||||||||
| 28834521 | 28834521 | PRJNA1002816_P_NODE_18768_length_247_cov_1.327586_g18608_i0 | PRJNA1002816 | 18768 | 247 | 1.327586 | 3.27913742 | archaeon | 1906665 | Archaea | Archaea | 63.9 | 2e-10 | NR | MDP2438187.1 | 1906665 | g18608 | i0 | 65.5 | 0.704453441295547 | 58 | 15 | 66.8 | 2 | 247 | 83 | 94 | 149 | MDP2438187.1 30S ribosomal protein S17e [archaeon] | diamond | 174 | 63.9 | 1 | Archaea | archaeon | ||||||||
| 28961107 | 28961107 | PRJNA1002816_P_NODE_18148_length_249_cov_0.875000_g17988_i0 | PRJNA1002816 | 18148 | 249 | 0.875 | 2.17875 | archaeon | 1906665 | Archaea | Archaea | 97.1 | 2.51e-22 | NR | MDP2434719.1 | 1906665 | g17988 | i0 | 78.1 | 0.771084337349398 | 64 | 14 | 77.1 | 0 | 3 | 194 | 92 | 155 | MDP2434719.1 hypothetical protein [archaeon] | diamond | 192 | 97.1 | 1 | Archaea | archaeon | ||||||||
| 29245035 | 29245035 | PRJNA1002816_P_NODE_17589_length_251_cov_0.865169_g17429_i0 | PRJNA1002816 | 17589 | 251 | 0.865169 | 2.17157419 | archaeon | 1906665 | Archaea | Archaea | 95.9 | 1.2e-21 | NR | MDP2437415.1 | 1906665 | g17429 | i0 | 57.7 | 0.932270916334661 | 78 | 32 | 93.2 | 1 | 249 | 16 | 185 | 261 | MDP2437415.1 hypothetical protein [archaeon] | diamond | 234 | 95.9 | 1 | Archaea | archaeon | ||||||||
| 29308074 | 29308074 | PRJNA1002816_P_NODE_7589_length_410_cov_1.599407_g7429_i0 | PRJNA1002816 | 7589 | 410 | 1.599407 | 6.5575687 | archaeon | 1906665 | Archaea | Archaea | 172 | 1.34e-50 | NR | MDP2435546.1 | 1906665 | g7429 | i0 | 69 | 0.848780487804878 | 116 | 36 | 84.9 | 0 | 349 | 2 | 1 | 116 | MDP2435546.1 30S ribosomal protein S2 [archaeon] | diamond | 348 | 172 | 1 | Archaea | archaeon | ||||||||
| 29623386 | 29623386 | PRJNA1002816_P_NODE_14450_length_287_cov_1.369159_g14290_i0 | PRJNA1002816 | 14450 | 287 | 1.369159 | 3.92948633 | archaeon | 1906665 | Archaea | Archaea | 68.9 | 3.89e-11 | NR | MDP2434861.1 | 1906665 | g14290 | i0 | 59.6 | 1.18118466898955 | 57 | 22 | 58.5 | 1 | 120 | 287 | 13 | 69 | MDP2434861.1 hypothetical protein [archaeon] | diamond | 339 | 68.9 | 1 | Archaea | archaeon | ||||||||
| 30729529 | 30729529 | PRJNA1002816_P_NODE_17614_length_251_cov_0.865169_g17454_i0 | PRJNA1002816 | 17614 | 251 | 0.865169 | 2.17157419 | archaeon | 1906665 | Archaea | Archaea | 65.9 | 2.14e-11 | NR | MDP2436409.1 | 1906665 | g17454 | i0 | 63.5 | 0.621513944223108 | 52 | 17 | 62.2 | 1 | 158 | 3 | 4 | 53 | MDP2436409.1 SH3 domain-containing protein [archaeon] | diamond | 156 | 65.9 | 1 | Archaea | archaeon | ||||||||
| 31139913 | 31139913 | PRJNA1002816_P_NODE_15375_length_276_cov_1.694581_g15215_i0 | PRJNA1002816 | 15375 | 276 | 1.694581 | 4.67704356 | archaeon | 1906665 | Archaea | Archaea | 127 | 5.51e-32 | NR | MDP2435017.1 | 1906665 | g15215 | i0 | 72.5 | 0.989130434782609 | 91 | 21 | 94.6 | 2 | 275 | 15 | 375 | 465 | MDP2435017.1 type III PLP-dependent enzyme [archaeon] | diamond | 273 | 127 | 1 | Archaea | archaeon | ||||||||
| 31361786 | 31361786 | PRJNA1002816_P_NODE_19976_length_244_cov_0.900585_g19816_i0 | PRJNA1002816 | 19976 | 244 | 0.900585 | 2.1974274 | archaeon | 1906665 | Archaea | Archaea | 143 | 1.79e-41 | NR | MDP2439543.1 | 1906665 | g19816 | i0 | 85 | 0.983606557377049 | 80 | 12 | 98.4 | 0 | 242 | 3 | 60 | 139 | MDP2439543.1 peptidase dimerization domain-containing protein [archaeon] | diamond | 240 | 143 | 1 | Archaea | archaeon | ||||||||
| 31804314 | 31804314 | PRJNA1002816_P_NODE_19937_length_244_cov_0.900585_g19777_i0 | PRJNA1002816 | 19937 | 244 | 0.900585 | 2.1974274 | archaeon | 1906665 | Archaea | Archaea | 68.6 | 2.88e-11 | NR | MDP2439538.1 | 1906665 | g19777 | i0 | 55.8 | 0.639344262295082 | 52 | 23 | 63.9 | 0 | 164 | 9 | 1 | 52 | MDP2439538.1 metallophosphoesterase [archaeon] | diamond | 156 | 68.6 | 1 | Archaea | archaeon | ||||||||
| 32374114 | 32374114 | PRJNA1002816_P_NODE_7859_length_403_cov_0.790909_g7699_i0 | PRJNA1002816 | 7859 | 403 | 0.790909 | 3.18736327 | archaeon | 1906665 | Archaea | Archaea | 142 | 1.86e-40 | NR | RYG68310.1 | 1906665 | g7699 | i0 | 67.5 | 2.60545905707196 | 117 | 36 | 85.6 | 2 | 35 | 379 | 3 | 119 | RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] | diamond | 1050 | 142 | 1 | Archaea | archaeon | ||||||||
| 32784091 | 32784091 | PRJNA1002816_P_NODE_19260_length_246_cov_0.890173_g19100_i0 | PRJNA1002816 | 19260 | 246 | 0.890173 | 2.18982558 | archaeon | 1906665 | Archaea | Archaea | 76.6 | 4.42e-14 | NR | MDP2439363.1 | 1906665 | g19100 | i0 | 66.7 | 0.695121951219512 | 57 | 19 | 69.5 | 0 | 241 | 71 | 619 | 675 | MDP2439363.1 V-type ATPase subunit a family protein [archaeon] | diamond | 171 | 76.6 | 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);;