contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA857143" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9770990 | 9770990 | PRJNA857143_S_NODE_11508_length_645_cov_4.351399_g10499_i0 | PRJNA857143 | 11508 | 645 | 4.351399 | 28.06652355 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 266 | 7.05e-79 | NR | MES1911981.1 | 1215613 | g10499 | i0 | 72.5 | 11.4883720930233 | 211 | 57 | 98.1 | 1 | 2 | 634 | 187 | 396 | MES1911981.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 7410 | 266 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 11046663 | 11046663 | PRJNA857143_S_NODE_11969_length_635_cov_19.028470_g10950_i0 | PRJNA857143 | 11969 | 635 | 19.02847 | 120.8307845 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 2.36e-80 | NR | ADK47156.1 | 323453 | g10950 | i0 | 83.4 | 0.68503937007874 | 145 | 24 | 68.5 | 0 | 609 | 175 | 1 | 145 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 435 | 246 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 13598149 | 13598149 | PRJNA857143_S_NODE_7771_length_744_cov_9.345753_g6871_i0 | PRJNA857143 | 7771 | 744 | 9.345753 | 69.53240232 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 1.6899999999999999e-74 | NR | ADK26622.1 | 323453 | g6871 | i0 | 85.4 | 0.524193548387097 | 130 | 19 | 52.4 | 0 | 7 | 396 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 390 | 232 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 17421261 | 17421261 | PRJNA857143_S_NODE_126274_length_286_cov_3.032864_g125181_i0 | PRJNA857143 | 126274 | 286 | 3.032864 | 8.67399104 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.39e-15 | NR | BBE07970.1 | 1928728 | g125181 | i0 | 66.1 | 1.91958041958042 | 62 | 19 | 65 | 1 | 284 | 99 | 132 | 191 | BBE07970.1 Ras-related protein Rac1 [Paulinella micropora] | diamond | 549 | 77.8 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 21246487 | 21246487 | PRJNA857143_S_NODE_72277_length_351_cov_1.377698_g71184_i0 | PRJNA857143 | 72277 | 351 | 1.377698 | 4.83571998 | Gymnophrys sp. ATCC 5 | 2170314 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 9.75e-42 | NR | ADK90077.1 | 646463 | g71184 | i0 | 77.1 | 0.82051282051282 | 96 | 22 | 82.1 | 0 | 62 | 349 | 96 | 191 | ADK90077.1 HSP90, partial [Gymnophrys sp. ATCC 50923] | diamond | 288 | 150 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 27055164 | 27055164 | PRJNA857143_S_NODE_164382_length_256_cov_1.278689_g163289_i0 | PRJNA857143 | 164382 | 256 | 1.278689 | 3.27344384 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 9.26e-7 | NR | MES1913617.1 | 1215613 | g163289 | i0 | 40 | 0.8203125 | 70 | 31 | 76.2 | 2 | 199 | 5 | 111 | 174 | MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 210 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27529010 | 27529010 | PRJNA857143_S_NODE_87623_length_328_cov_2.117647_g86530_i0 | PRJNA857143 | 87623 | 328 | 2.117647 | 6.94588216 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 3.65e-26 | NR | AAT09082.1 | 227086 | g86530 | i0 | 54.5 | 0.804878048780488 | 88 | 40 | 80.5 | 0 | 3 | 266 | 143 | 230 | AAT09082.1 glutathione-s-transferase [Bigelowiella natans] | diamond | 264 | 107 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 27529013 | 27529013 | PRJNA857143_S_NODE_95023_length_319_cov_1.268293_g93930_i0 | PRJNA857143 | 95023 | 319 | 1.268293 | 4.04585467 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 9.43e-7 | NR | MES1907960.1 | 1215613 | g93930 | i0 | 50 | 0.489028213166144 | 52 | 26 | 48.9 | 0 | 1 | 156 | 829 | 880 | MES1907960.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 156 | 57 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28697450 | 28697450 | PRJNA857143_S_NODE_56207_length_381_cov_3.331169_g55114_i0 | PRJNA857143 | 56207 | 381 | 3.331169 | 12.69175389 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.2399999999999998e-29 | NR | MES1907830.1 | 1215613 | g55114 | i0 | 53.5 | 1 | 127 | 58 | 99.2 | 1 | 380 | 3 | 1547 | 1673 | MES1907830.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 381 | 123 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29234106 | 29234106 | PRJNA857143_S_NODE_77009_length_343_cov_1.818519_g75916_i0 | PRJNA857143 | 77009 | 343 | 1.818519 | 6.23752017 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 5.48e-45 | NR | YP_009118075.1 | 372086 | g75916 | i0 | 72.8 | 0.997084548104956 | 114 | 31 | 99.7 | 0 | 342 | 1 | 4 | 117 | YP_009118075.1 NADH dehydrogenase subunit 3 [Paracercomonas marina] | diamond | 342 | 152 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 29486382 | 29486382 | PRJNA857143_S_NODE_4870_length_877_cov_32.578358_g4133_i0 | PRJNA857143 | 4870 | 877 | 32.578358 | 285.71219966 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.12e-35 | NR | ADK26624.1 | 323453 | g4133 | i0 | 72.3 | 0.636259977194983 | 94 | 26 | 32.2 | 0 | 1 | 282 | 183 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 558 | 139 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29486386 | 29486386 | PRJNA857143_S_NODE_96930_length_317_cov_0.860656_g95837_i0 | PRJNA857143 | 96930 | 317 | 0.860656 | 2.72827952 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 6.55e-29 | NR | MES1913326.1 | 1215613 | g95837 | i0 | 57.1 | 1.98738170347003 | 105 | 45 | 99.4 | 0 | 316 | 2 | 272 | 376 | MES1913326.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 630 | 119 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29802280 | 29802280 | PRJNA857143_S_NODE_79511_length_339_cov_2.639098_g78418_i0 | PRJNA857143 | 79511 | 339 | 2.639098 | 8.94654222 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 7.2e-39 | NR | ADK26624.1 | 323453 | g78418 | i0 | 59.3 | 1 | 113 | 46 | 100 | 0 | 339 | 1 | 159 | 271 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 339 | 141 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29991928 | 29991928 | PRJNA857143_S_NODE_165391_length_255_cov_1.714286_g164298_i0 | PRJNA857143 | 165391 | 255 | 1.714286 | 4.3714293 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 6.33e-18 | NR | MES1908186.1 | 1215613 | g164298 | i0 | 52.6 | 0.894117647058824 | 76 | 36 | 89.4 | 0 | 6 | 233 | 354 | 429 | MES1908186.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 228 | 87.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30592117 | 30592117 | PRJNA857143_S_NODE_80133_length_338_cov_3.603774_g79040_i0 | PRJNA857143 | 80133 | 338 | 3.603774 | 12.18075612 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 3.16e-12 | NR | MES1912552.1 | 1215613 | g79040 | i0 | 83.8 | 1.36686390532544 | 37 | 6 | 32.8 | 0 | 326 | 216 | 313 | 349 | MES1912552.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 462 | 72.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30750227 | 30750227 | PRJNA857143_S_NODE_49814_length_396_cov_5.390093_g48721_i0 | PRJNA857143 | 49814 | 396 | 5.390093 | 21.34476828 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 7.4e-23 | NR | AAT09085.1 | 227086 | g48721 | i0 | 58.3 | 1.09090909090909 | 72 | 30 | 54.5 | 0 | 394 | 179 | 38 | 109 | AAT09085.1 ubiquitin conjugating enzyme [Bigelowiella natans] | diamond | 432 | 96.3 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 30750231 | 30750231 | PRJNA857143_S_NODE_65874_length_362_cov_1.737024_g64781_i0 | PRJNA857143 | 65874 | 362 | 1.737024 | 6.28802688 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 3.83e-7 | NR | ACO54851.1 | 1561963 | g64781 | i0 | 65.3 | 0.406077348066298 | 49 | 17 | 40.6 | 0 | 360 | 214 | 323 | 371 | ACO54851.1 calreticulin [Amorphochlora amoebiformis] | diamond | 147 | 58.5 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 31477341 | 31477341 | PRJNA857143_S_NODE_164916_length_255_cov_3.390110_g163823_i0 | PRJNA857143 | 164916 | 255 | 3.39011 | 8.6447805 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 6.05e-8 | NR | MES1906893.1 | 1215613 | g163823 | i0 | 55.4 | 0.658823529411765 | 56 | 24 | 64.7 | 1 | 254 | 90 | 431 | 486 | MES1906893.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 168 | 59.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31824905 | 31824905 | PRJNA857143_S_NODE_167217_length_254_cov_1.292818_g166124_i0 | PRJNA857143 | 167217 | 254 | 1.292818 | 3.28375772 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.3099999999999999e-23 | NR | MES1909875.1 | 1215613 | g166124 | i0 | 67.8 | 0.696850393700787 | 59 | 19 | 69.7 | 0 | 2 | 178 | 240 | 298 | MES1909875.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 177 | 102 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31920019 | 31920019 | PRJNA857143_S_NODE_122557_length_290_cov_1.437788_g121464_i0 | PRJNA857143 | 122557 | 290 | 1.437788 | 4.1695852 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 3.26e-21 | NR | MES1909771.1 | 1215613 | g121464 | i0 | 46.3 | 1.96551724137931 | 95 | 51 | 98.3 | 0 | 6 | 290 | 104 | 198 | MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 570 | 97.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32331692 | 32331692 | PRJNA857143_S_NODE_12559_length_624_cov_35.156080_g11535_i0 | PRJNA857143 | 12559 | 624 | 35.15608 | 219.3739392 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 5.78e-45 | NR | MES1911029.1 | 1215613 | g11535 | i0 | 52.8 | 0.774038461538462 | 161 | 70 | 75.5 | 2 | 580 | 110 | 147 | 305 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 483 | 161 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32529555 | 32529555 | PRJNA857143_S_NODE_152139_length_265_cov_1.338542_g151046_i0 | PRJNA857143 | 152139 | 265 | 1.338542 | 3.5471363 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 2.44e-30 | NR | ADK26624.1 | 323453 | g151046 | i0 | 65.1 | 1.93584905660377 | 86 | 28 | 95.1 | 1 | 6 | 257 | 23 | 108 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 513 | 119 | 0.991596638655462 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 32553107 | 32553107 | PRJNA857143_S_NODE_131579_length_282_cov_1.105263_g130486_i0 | PRJNA857143 | 131579 | 282 | 1.105263 | 3.11684166 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 1.23e-12 | NR | MES1910251.1 | 1215613 | g130486 | i0 | 59 | 0.648936170212766 | 61 | 24 | 63.8 | 1 | 278 | 99 | 298 | 358 | MES1910251.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 183 | 72.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32678546 | 32678546 | PRJNA857143_S_NODE_80220_length_338_cov_2.649057_g79127_i0 | PRJNA857143 | 80220 | 338 | 2.649057 | 8.95381266 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00569 | NR | MES1916146.1 | 1215613 | g79127 | i0 | 35.8 | 1.18934911242604 | 67 | 41 | 59.5 | 1 | 259 | 59 | 2 | 66 | MES1916146.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 402 | 43.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32836168 | 32836168 | PRJNA857143_S_NODE_163840_length_256_cov_1.994536_g162747_i0 | PRJNA857143 | 163840 | 256 | 1.994536 | 5.10601216 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 4.92e-6 | NR | MES1909105.1 | 1215613 | g162747 | i0 | 50.7 | 0.85546875 | 73 | 36 | 85.5 | 0 | 14 | 232 | 336 | 408 | MES1909105.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 219 | 53.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;