contig_metadata
33 rows where bioproject = "PRJDB14274" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1282832 | 1282832 | PRJDB14274_S_NODE_9322_length_209_cov_0.878378_g9244_i0 | PRJDB14274 | 9322 | 209 | 0.878378 | 1.83581002 | archaeon | 1906665 | Archaea | Archaea | 118 | 2.79e-29 | NR | RYG65186.1 | 1906665 | g9244 | i0 | 85.5 | 0.990430622009569 | 69 | 10 | 99 | 0 | 1 | 207 | 286 | 354 | RYG65186.1 MAG: hypothetical protein EON64_12455 [archaeon] | diamond | 207 | 118 | 1 | Archaea | archaeon | ||||||||
| 3531592 | 3531592 | PRJDB14274_S_NODE_4063_length_305_cov_2.684426_g3985_i0 | PRJDB14274 | 4063 | 305 | 2.684426 | 8.1874993 | archaeon | 1906665 | Archaea | Archaea | 188 | 4.55e-57 | NR | RYH04926.1 | 1906665 | g3985 | i0 | 90.1 | 0.99344262295082 | 101 | 10 | 99.3 | 0 | 1 | 303 | 70 | 170 | RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] | diamond | 303 | 188 | 1 | Archaea | archaeon | ||||||||
| 5110957 | 5110957 | PRJDB14274_S_NODE_1645_length_475_cov_2.707729_g1567_i0 | PRJDB14274 | 1645 | 475 | 2.707729 | 12.86171275 | archaeon | 1906665 | Archaea | Archaea | 202 | 3.3e-64 | NR | RYH05217.1 | 1906665 | g1567 | i0 | 88.1 | 0.688421052631579 | 109 | 13 | 68.8 | 0 | 474 | 148 | 25 | 133 | RYH05217.1 MAG: 50S ribosomal protein L15 [archaeon] | diamond | 327 | 202 | 1 | Archaea | archaeon | ||||||||
| 7660859 | 7660859 | PRJDB14274_S_NODE_5267_length_272_cov_1.739336_g5189_i0 | PRJDB14274 | 5267 | 272 | 1.739336 | 4.73099392 | archaeon | 1906665 | Archaea | Archaea | 169 | 2.26e-50 | NR | RYG64625.1 | 1906665 | g5189 | i0 | 86.7 | 0.992647058823529 | 90 | 12 | 99.3 | 0 | 1 | 270 | 169 | 258 | RYG64625.1 MAG: 50S ribosomal protein L3, partial [archaeon] | diamond | 270 | 169 | 1 | Archaea | archaeon | ||||||||
| 13734450 | 13734450 | PRJDB14274_S_NODE_7151_length_237_cov_1.170455_g7073_i0 | PRJDB14274 | 7151 | 237 | 1.170455 | 2.77397835 | archaeon | 1906665 | Archaea | Archaea | 135 | 1.26e-36 | NR | RYH04926.1 | 1906665 | g7073 | i0 | 84.6 | 0.987341772151899 | 78 | 12 | 98.7 | 0 | 3 | 236 | 161 | 238 | RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] | diamond | 234 | 135 | 1 | Archaea | archaeon | ||||||||
| 14036592 | 14036592 | PRJDB14274_S_NODE_1252_length_538_cov_2.389937_g1176_i0 | PRJDB14274 | 1252 | 538 | 2.389937 | 12.85786106 | archaeon | 1906665 | Archaea | Archaea | 276 | 1.22e-90 | NR | RYG64625.1 | 1906665 | g1176 | i0 | 78.5 | 0.986988847583643 | 177 | 38 | 98.7 | 0 | 531 | 1 | 1 | 177 | RYG64625.1 MAG: 50S ribosomal protein L3, partial [archaeon] | diamond | 531 | 276 | 1 | Archaea | archaeon | ||||||||
| 14036593 | 14036593 | PRJDB14274_S_NODE_1272_length_536_cov_2.046316_g1196_i0 | PRJDB14274 | 1272 | 536 | 2.046316 | 10.96825376 | archaeon | 1906665 | Archaea | Archaea | 259 | 3.77e-86 | NR | RYH30694.1 | 1906665 | g1196 | i0 | 86.1 | 3.38059701492537 | 151 | 21 | 84.5 | 0 | 513 | 61 | 1 | 151 | RYH30694.1 MAG: 30S ribosomal protein S15 [archaeon] | diamond | 1812 | 259 | 1 | Archaea | archaeon | ||||||||
| 14036623 | 14036623 | PRJDB14274_S_NODE_812_length_657_cov_32.563758_g740_i0 | PRJDB14274 | 812 | 657 | 32.563758 | 213.94389006 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 63.9 | 3.02e-5 | NTclustered | gi|2573961727|gb|CP133596.1| | 2268204 | g740 | i0 | 100 | 0.0974124809741248 | 34 | 0 | 5 | 0 | 599 | 632 | 518155 | 518122 | MAG: Thermoplasmatales archaeon isolate BR_05 chromosome, complete genome | blastn | 64 | 63.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 17860376 | 17860376 | PRJDB14274_S_NODE_1635_length_476_cov_4.216867_g1557_i0 | PRJDB14274 | 1635 | 476 | 4.216867 | 20.07228692 | archaeon | 1906665 | Archaea | Archaea | 226 | 3.3699999999999995e-72 | NR | RYH25290.1 | 1906665 | g1557 | i0 | 93.2 | 0.743697478991597 | 118 | 8 | 74.4 | 0 | 3 | 356 | 89 | 206 | RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] | diamond | 354 | 226 | 1 | Archaea | archaeon | ||||||||
| 26684070 | 26684070 | PRJDB14274_S_NODE_1861_length_445_cov_7.169271_g1783_i0 | PRJDB14274 | 1861 | 445 | 7.169271 | 31.90325595 | archaeon | 1906665 | Archaea | Archaea | 113 | 2.05e-29 | NR | RYH00022.1 | 1906665 | g1783 | i0 | 67.7 | 0.667415730337079 | 99 | 31 | 66.7 | 1 | 355 | 59 | 1 | 98 | RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] | diamond | 297 | 113 | 1 | Archaea | archaeon | ||||||||
| 27000565 | 27000565 | PRJDB14274_S_NODE_4602_length_289_cov_1.228070_g4524_i0 | PRJDB14274 | 4602 | 289 | 1.22807 | 3.5491223 | archaeon | 1906665 | Archaea | Archaea | 91.7 | 6.09e-22 | NR | RYH17538.1 | 1906665 | g4524 | i0 | 68.6 | 0.726643598615917 | 70 | 21 | 72.7 | 1 | 44 | 253 | 1 | 69 | RYH17538.1 MAG: hypothetical protein EON65_28465 [archaeon] | diamond | 210 | 91.7 | 1 | Archaea | archaeon | ||||||||
| 27063995 | 27063995 | PRJDB14274_S_NODE_7602_length_230_cov_1.136095_g7524_i0 | PRJDB14274 | 7602 | 230 | 1.136095 | 2.6130185 | archaeon | 1906665 | Archaea | Archaea | 117 | 2.63e-32 | NR | RYG60404.1 | 1906665 | g7524 | i0 | 77.5 | 2.77826086956522 | 71 | 16 | 92.6 | 0 | 1 | 213 | 14 | 84 | RYG60404.1 MAG: hypothetical protein EON64_19315, partial [archaeon] | diamond | 639 | 117 | 1 | Archaea | archaeon | ||||||||
| 27063998 | 27063998 | PRJDB14274_S_NODE_8362_length_219_cov_2.126582_g8284_i0 | PRJDB14274 | 8362 | 219 | 2.126582 | 4.65721458 | archaeon | 1906665 | Archaea | Archaea | 62 | 6.51e-10 | NR | RYG68310.1 | 1906665 | g8284 | i0 | 60.9 | 0.945205479452055 | 69 | 21 | 90.4 | 5 | 1 | 198 | 88 | 153 | RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] | diamond | 207 | 62 | 1 | Archaea | archaeon | ||||||||
| 27126799 | 27126799 | PRJDB14274_S_NODE_5362_length_270_cov_1.244019_g5284_i0 | PRJDB14274 | 5362 | 270 | 1.244019 | 3.3588513 | uncultured archaeon | 115547 | Archaea | Archaea | 43.5 | 0.0122 | NR | QBM02692.1 | 115547 | g5284 | i0 | 35.7 | 0.622222222222222 | 56 | 36 | 62.2 | 0 | 237 | 70 | 45 | 100 | QBM02692.1 hypothetical protein [uncultured archaeon] | diamond | 168 | 43.5 | 1 | Archaea | uncultured archaeon | ||||||||
| 27253561 | 27253561 | PRJDB14274_S_NODE_9623_length_206_cov_3.282759_g9545_i0 | PRJDB14274 | 9623 | 206 | 3.282759 | 6.76248354 | archaeon | 1906665 | Archaea | Archaea | 133 | 4.1e-38 | NR | RYG68310.1 | 1906665 | g9545 | i0 | 91.2 | 0.990291262135922 | 68 | 6 | 99 | 0 | 206 | 3 | 5 | 72 | RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] | diamond | 204 | 133 | 1 | Archaea | archaeon | ||||||||
| 27696170 | 27696170 | PRJDB14274_S_NODE_2704_length_373_cov_1.301282_g2626_i0 | PRJDB14274 | 2704 | 373 | 1.301282 | 4.85378186 | archaeon | 1906665 | Archaea | Archaea | 103 | 1.3899999999999998e-23 | NR | RYH20254.1 | 1906665 | g2626 | i0 | 51.5 | 0.828418230563003 | 103 | 50 | 82.8 | 0 | 367 | 59 | 247 | 349 | RYH20254.1 MAG: hypothetical protein EON65_24020 [archaeon] | diamond | 309 | 103 | 1 | Archaea | archaeon | ||||||||
| 27696181 | 27696181 | PRJDB14274_S_NODE_6644_length_245_cov_1.559783_g6566_i0 | PRJDB14274 | 6644 | 245 | 1.559783 | 3.82146835 | archaeon | 1906665 | Archaea | Archaea | 111 | 8.800000000000001e-30 | NR | RYH18874.1 | 1906665 | g6566 | i0 | 67.9 | 0.955102040816327 | 78 | 23 | 95.5 | 1 | 4 | 237 | 27 | 102 | RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon] | diamond | 234 | 111 | 1 | Archaea | archaeon | ||||||||
| 27948455 | 27948455 | PRJDB14274_S_NODE_3565_length_325_cov_1.518939_g3487_i0 | PRJDB14274 | 3565 | 325 | 1.518939 | 4.93655175 | archaeon | 1906665 | Archaea | Archaea | 153 | 1.7199999999999998e-45 | NR | RYG63904.1 | 1906665 | g3487 | i0 | 87.6 | 0.821538461538462 | 89 | 11 | 82.2 | 0 | 322 | 56 | 40 | 128 | RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] | diamond | 267 | 153 | 1 | Archaea | archaeon | ||||||||
| 27980031 | 27980031 | PRJDB14274_S_NODE_1665_length_472_cov_2.576642_g1587_i0 | PRJDB14274 | 1665 | 472 | 2.576642 | 12.16175024 | archaeon | 1906665 | Archaea | Archaea | 121 | 3.0199999999999997e-32 | NR | RYH28340.1 | 1906665 | g1587 | i0 | 67.5 | 0.76271186440678 | 120 | 35 | 76.3 | 1 | 458 | 99 | 1 | 116 | RYH28340.1 MAG: 50S ribosomal protein P1 [archaeon] | diamond | 360 | 121 | 1 | Archaea | archaeon | ||||||||
| 28068810 | 28068810 | PRJDB14274_S_NODE_2225_length_410_cov_2.068768_g2147_i0 | PRJDB14274 | 2225 | 410 | 2.068768 | 8.4819488 | root | 1 | Root_unresolved | Root_unresolved | 151 | 4.0799999999999996e-43 | NR | RYG58925.1 | 1906665 | g2147 | i0 | 80.5 | 2.5390243902439 | 87 | 17 | 63.7 | 0 | 409 | 149 | 137 | 223 | RYG58925.1 MAG: 30S ribosomal protein S2, partial [archaeon] | diamond | 1041 | 151 | 1 | Archaea | archaeon | ||||||||
| 28264002 | 28264002 | PRJDB14274_S_NODE_3186_length_343_cov_1.326241_g3108_i0 | PRJDB14274 | 3186 | 343 | 1.326241 | 4.54900663 | archaeon | 1906665 | Archaea | Archaea | 176 | 6.58e-50 | NR | RYG65186.1 | 1906665 | g3108 | i0 | 81.1 | 0.927113702623907 | 106 | 19 | 92.7 | 1 | 3 | 320 | 429 | 533 | RYG65186.1 MAG: hypothetical protein EON64_12455 [archaeon] | diamond | 318 | 176 | 1 | Archaea | archaeon | ||||||||
| 28358764 | 28358764 | PRJDB14274_S_NODE_7786_length_227_cov_2.234940_g7708_i0 | PRJDB14274 | 7786 | 227 | 2.23494 | 5.0733138 | archaeon | 1906665 | Archaea | Archaea | 107 | 1.6600000000000002e-26 | NR | RYH18875.1 | 1906665 | g7708 | i0 | 72 | 0.991189427312775 | 75 | 21 | 99.1 | 0 | 1 | 225 | 115 | 189 | RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] | diamond | 225 | 107 | 1 | Archaea | archaeon | ||||||||
| 28422230 | 28422230 | PRJDB14274_S_NODE_5526_length_266_cov_1.385366_g5448_i0 | PRJDB14274 | 5526 | 266 | 1.385366 | 3.68507356 | archaeon | 1906665 | Archaea | Archaea | 77.8 | 1.43e-15 | NR | RYG67202.1 | 1906665 | g5448 | i0 | 44.9 | 2.80827067669173 | 89 | 47 | 99.2 | 2 | 264 | 1 | 33 | 120 | RYG67202.1 MAG: hypothetical protein EON64_07960 [archaeon] | diamond | 747 | 77.8 | 1 | Archaea | archaeon | ||||||||
| 28800740 | 28800740 | PRJDB14274_S_NODE_1808_length_451_cov_1.984615_g1730_i0 | PRJDB14274 | 1808 | 451 | 1.984615 | 8.95061365 | archaeon | 1906665 | Archaea | Archaea | 145 | 3.5e-41 | NR | RYG68742.1 | 1906665 | g1730 | i0 | 76.8 | 0.658536585365854 | 99 | 23 | 65.9 | 0 | 449 | 153 | 62 | 160 | RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] | diamond | 297 | 145 | 1 | Archaea | archaeon | ||||||||
| 29684691 | 29684691 | PRJDB14274_S_NODE_9870_length_205_cov_0.902778_g9792_i0 | PRJDB14274 | 9870 | 205 | 0.902778 | 1.8506949 | archaeon | 1906665 | Archaea | Archaea | 107 | 2.64e-25 | NR | RYH13809.1 | 1906665 | g9792 | i0 | 74.6 | 0.980487804878049 | 67 | 17 | 98 | 0 | 5 | 205 | 206 | 272 | RYH13809.1 MAG: VWA domain-containing protein [archaeon] | diamond | 201 | 107 | 1 | Archaea | archaeon | ||||||||
| 30380376 | 30380376 | PRJDB14274_S_NODE_9693_length_206_cov_1.234483_g9615_i0 | PRJDB14274 | 9693 | 206 | 1.234483 | 2.54303498 | archaeon | 1906665 | Archaea | Archaea | 64.3 | 5.18e-10 | NR | RYH20254.1 | 1906665 | g9615 | i0 | 52.6 | 0.830097087378641 | 57 | 27 | 83 | 0 | 173 | 3 | 1 | 57 | RYH20254.1 MAG: hypothetical protein EON65_24020 [archaeon] | diamond | 171 | 64.3 | 1 | Archaea | archaeon | ||||||||
| 30443305 | 30443305 | PRJDB14274_S_NODE_8853_length_213_cov_1.559211_g8775_i0 | PRJDB14274 | 8853 | 213 | 1.559211 | 3.32111943 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 42.7 | 0.0259 | NR | WP_048085055.1 | 2162 | g8775 | i0 | 41.9 | 0.605633802816901 | 43 | 25 | 60.6 | 0 | 162 | 34 | 145 | 187 | WP_048085055.1 ABC-ATPase domain-containing protein [Methanobacterium formicicum] | diamond | 129 | 42.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 30601011 | 30601011 | PRJDB14274_S_NODE_4353_length_296_cov_1.378723_g4275_i0 | PRJDB14274 | 4353 | 296 | 1.378723 | 4.08102008 | archaeon | 1906665 | Archaea | Archaea | 134 | 9.42e-37 | NR | RYH18875.1 | 1906665 | g4275 | i0 | 72.4 | 0.993243243243243 | 98 | 25 | 99.3 | 1 | 3 | 296 | 108 | 203 | RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] | diamond | 294 | 134 | 1 | Archaea | archaeon | ||||||||
| 30790687 | 30790687 | PRJDB14274_S_NODE_7654_length_229_cov_1.547619_g7576_i0 | PRJDB14274 | 7654 | 229 | 1.547619 | 3.54404751 | archaeon | 1906665 | Archaea | Archaea | 83.6 | 6.77e-19 | NR | RYG96209.1 | 1906665 | g7576 | i0 | 67.3 | 0.720524017467249 | 55 | 18 | 72.1 | 0 | 229 | 65 | 43 | 97 | RYG96209.1 MAG: hypothetical protein EON65_54770, partial [archaeon] | diamond | 165 | 83.6 | 1 | Archaea | archaeon | ||||||||
| 31075152 | 31075152 | PRJDB14274_S_NODE_7515_length_231_cov_1.370588_g7437_i0 | PRJDB14274 | 7515 | 231 | 1.370588 | 3.16605828 | Archaeoglobaceae archaeon | 2511821 | Archaea | Archaea | 42.7 | 0.0298 | NR | HID42582.1 | 2511821 | g7437 | i0 | 32.8 | 0.87012987012987 | 67 | 44 | 85.7 | 1 | 32 | 229 | 103 | 169 | HID42582.1 hypothetical protein [Archaeoglobaceae archaeon] | diamond | 201 | 42.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobaceae archaeon | |||
| 31581140 | 31581140 | PRJDB14274_S_NODE_8496_length_218_cov_0.891720_g8418_i0 | PRJDB14274 | 8496 | 218 | 0.89172 | 1.9439496 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 104 | 3.96e-24 | NR | MFB5612793.1 | 2026886 | g8418 | i0 | 81.8 | 1.85779816513761 | 66 | 12 | 90.8 | 0 | 218 | 21 | 505 | 570 | MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] | diamond | 405 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 31802222 | 31802222 | PRJDB14274_S_NODE_6697_length_244_cov_2.000000_g6619_i0 | PRJDB14274 | 6697 | 244 | 2 | 4.88 | archaeon | 1906665 | Archaea | Archaea | 141 | 1.27e-41 | NR | RYH06909.1 | 1906665 | g6619 | i0 | 84.6 | 0.959016393442623 | 78 | 12 | 95.9 | 0 | 236 | 3 | 1 | 78 | RYH06909.1 MAG: hypothetical protein EON65_42315 [archaeon] | diamond | 234 | 141 | 1 | Archaea | archaeon | ||||||||
| 32023943 | 32023943 | PRJDB14274_S_NODE_3538_length_326_cov_1.422642_g3460_i0 | PRJDB14274 | 3538 | 326 | 1.422642 | 4.63781292 | archaeon | 1906665 | Archaea | Archaea | 181 | 2.24e-56 | NR | RYH28872.1 | 1906665 | g3460 | i0 | 87.9 | 0.911042944785276 | 99 | 12 | 91.1 | 0 | 27 | 323 | 4 | 102 | RYH28872.1 MAG: hypothetical protein EON65_10545 [archaeon] | diamond | 297 | 181 | 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);;