contig_metadata
21 rows where bioproject = "PRJNA384462" and tax_clade = "Haptista"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5509025 | 5509025 | PRJNA384462_S_NODE_1865_length_381_cov_2.774096_g1749_i0 | PRJNA384462 | 1865 | 381 | 2.774096 | 10.56930576 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 189 | 2.6599999999999996e-56 | NR | KAL1521514.1 | 97485 | g1749 | i0 | 73.6 | 1.94488188976378 | 125 | 33 | 98.4 | 0 | 1 | 375 | 260 | 384 | KAL1521514.1 hypothetical protein AB1Y20_021174 [Prymnesium parvum] | diamond | 741 | 189 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 9333430 | 9333430 | PRJNA384462_S_NODE_928_length_532_cov_2.689441_g814_i0 | PRJNA384462 | 928 | 532 | 2.689441 | 14.30782612 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 221 | 7.389999999999999e-66 | NR | KAL1525905.1 | 97485 | g814 | i0 | 65.5 | 5.00751879699248 | 177 | 60 | 99.2 | 1 | 531 | 4 | 345 | 521 | KAL1525905.1 hypothetical protein AB1Y20_020733 [Prymnesium parvum] | diamond | 2664 | 222 | 0.995495495495496 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 10609120 | 10609120 | PRJNA384462_S_NODE_289_length_836_cov_6.255400_g225_i0 | PRJNA384462 | 289 | 836 | 6.2554 | 52.295144 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 342 | 1.14e-113 | NR | KAL1521514.1 | 97485 | g225 | i0 | 65.3 | 3.58492822966507 | 251 | 87 | 90.1 | 0 | 826 | 74 | 139 | 389 | KAL1521514.1 hypothetical protein AB1Y20_021174 [Prymnesium parvum] | diamond | 2997 | 342 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 26758548 | 26758548 | PRJNA384462_S_NODE_15081_length_162_cov_0.893805_g14965_i0 | PRJNA384462 | 15081 | 162 | 0.893805 | 1.4479641 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 41.6 | 0.0295 | NR | XP_005772296.1 | 280463 | g14965 | i0 | 38 | 0.925925925925926 | 50 | 30 | 92.6 | 1 | 11 | 160 | 19 | 67 | XP_005772296.1 hypothetical protein EMIHUDRAFT_444799 [Emiliania huxleyi CCMP1516] | diamond | 150 | 41.6 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26870915 | 26870915 | PRJNA384462_S_NODE_2381_length_337_cov_1.381944_g2265_i0 | PRJNA384462 | 2381 | 337 | 1.381944 | 4.65715128 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 97.4 | 5.8700000000000006e-21 | NR | KOO27741.1 | 1460289 | g2265 | i0 | 78 | 1.70029673590504 | 59 | 13 | 52.5 | 0 | 336 | 160 | 408 | 466 | KOO27741.1 chorismate synthase [Chrysochromulina tobinii] | diamond | 573 | 97.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 27028816 | 27028816 | PRJNA384462_S_NODE_11602_length_174_cov_1.168000_g11486_i0 | PRJNA384462 | 11602 | 174 | 1.168 | 2.03232 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57 | 1.29e-7 | NR | XP_005788998.1 | 280463 | g11486 | i0 | 61 | 2.05172413793103 | 41 | 16 | 70.7 | 0 | 2 | 124 | 257 | 297 | XP_005788998.1 hypothetical protein EMIHUDRAFT_460539 [Emiliania huxleyi CCMP1516] | diamond | 357 | 57 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 27201381 | 27201381 | PRJNA384462_S_NODE_102_length_1164_cov_5.164126_g78_i0 | PRJNA384462 | 102 | 1164 | 5.164126 | 60.11042664 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 94.4 | 9.8e-17 | NR | KAL1518426.1 | 97485 | g78 | i0 | 24.5 | 1.01030927835052 | 392 | 249 | 99 | 12 | 1154 | 3 | 556 | 908 | KAL1518426.1 hypothetical protein AB1Y20_002718 [Prymnesium parvum] | diamond | 1176 | 94.4 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27707417 | 27707417 | PRJNA384462_S_NODE_2484_length_330_cov_3.049822_g2368_i0 | PRJNA384462 | 2484 | 330 | 3.049822 | 10.0644126 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 46.2 | 0.00502 | NR | XP_005773499.1 | 280463 | g2368 | i0 | 32.8 | 2.21818181818182 | 122 | 64 | 98.2 | 5 | 328 | 5 | 133 | 250 | XP_005773499.1 hypothetical protein EMIHUDRAFT_208210 [Emiliania huxleyi CCMP1516] | diamond | 732 | 46.2 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 27850009 | 27850009 | PRJNA384462_S_NODE_8744_length_193_cov_1.409722_g8628_i0 | PRJNA384462 | 8744 | 193 | 1.409722 | 2.72076346 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 2.2e-6 | NR | XP_005763651.1 | 280463 | g8628 | i0 | 56.1 | 2.98445595854922 | 41 | 18 | 63.7 | 0 | 4 | 126 | 555 | 595 | XP_005763651.1 hypothetical protein EMIHUDRAFT_446127 [Emiliania huxleyi CCMP1516] | diamond | 576 | 53.9 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 28008217 | 28008217 | PRJNA384462_S_NODE_14765_length_162_cov_1.743363_g14649_i0 | PRJNA384462 | 14765 | 162 | 1.743363 | 2.82424806 | Pavlovophyceae | 3435358 | Haptophyta | other_Eukaryota | 45.1 | 7.86e-4 | NR | KAL1495125.1 | 97485 | g14649 | i0 | 66.7 | 2.44444444444444 | 33 | 11 | 61.1 | 0 | 3 | 101 | 107 | 139 | KAL1495125.1 hypothetical protein AB1Y20_016992 [Prymnesium parvum] | diamond | 396 | 45.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28117314 | 28117314 | PRJNA384462_S_NODE_13365_length_166_cov_0.871795_g13249_i0 | PRJNA384462 | 13365 | 166 | 0.871795 | 1.4471797 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 41.6 | 0.0347 | NR | XP_005773035.1 | 280463 | g13249 | i0 | 47.6 | 0.759036144578313 | 42 | 22 | 75.9 | 0 | 130 | 5 | 192 | 233 | XP_005773035.1 hypothetical protein EMIHUDRAFT_208560 [Emiliania huxleyi CCMP1516] | diamond | 126 | 41.6 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 29285550 | 29285550 | PRJNA384462_S_NODE_2489_length_330_cov_1.761566_g2373_i0 | PRJNA384462 | 2489 | 330 | 1.761566 | 5.8131678 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 48.9 | 5.67e-4 | NR | KAJ1633443.1 | 483367 | g2373 | i0 | 35 | 0.936363636363636 | 103 | 60 | 87.3 | 2 | 12 | 299 | 137 | 239 | KAJ1633443.1 hypothetical protein T492DRAFT_981117 [Pavlovales sp. CCMP2436] | diamond | 309 | 48.9 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 30282040 | 30282040 | PRJNA384462_S_NODE_7312_length_207_cov_0.968354_g7196_i0 | PRJNA384462 | 7312 | 207 | 0.968354 | 2.00449278 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 3.87e-4 | NR | XP_005780591.1 | 280463 | g7196 | i0 | 58.8 | 3.2463768115942 | 34 | 14 | 49.3 | 0 | 207 | 106 | 238 | 271 | XP_005780591.1 hypothetical protein EMIHUDRAFT_366332 [Emiliania huxleyi CCMP1516] | diamond | 672 | 47.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 30360010 | 30360010 | PRJNA384462_S_NODE_4452_length_252_cov_1.507389_g4336_i0 | PRJNA384462 | 4452 | 252 | 1.507389 | 3.79862028 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 66.2 | 4.84e-11 | NR | KAJ1631509.1 | 483367 | g4336 | i0 | 68 | 2.97619047619048 | 50 | 16 | 59.5 | 0 | 250 | 101 | 148 | 197 | KAJ1631509.1 NAC domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 750 | 66.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 31244181 | 31244181 | PRJNA384462_S_NODE_14635_length_163_cov_0.894737_g14519_i0 | PRJNA384462 | 14635 | 163 | 0.894737 | 1.45842131 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 45.1 | 0.00187 | NR | XP_005787575.1 | 280463 | g14519 | i0 | 45.5 | 0.809815950920245 | 44 | 24 | 81 | 0 | 143 | 12 | 511 | 554 | XP_005787575.1 hypothetical protein EMIHUDRAFT_227656 [Emiliania huxleyi CCMP1516] | diamond | 132 | 45.1 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 32066588 | 32066588 | PRJNA384462_S_NODE_4058_length_262_cov_8.981221_g3942_i0 | PRJNA384462 | 4058 | 262 | 8.981221 | 23.53079902 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 44.3 | 0.00352 | NR | KOO29468.1 | 1460289 | g3942 | i0 | 70.3 | 0.423664122137405 | 37 | 10 | 42.4 | 1 | 236 | 126 | 78 | 113 | KOO29468.1 ubiquitin [Chrysochromulina tobinii] | diamond | 111 | 44.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32115364 | 32115364 | PRJNA384462_S_NODE_1898_length_378_cov_1.759878_g1782_i0 | PRJNA384462 | 1898 | 378 | 1.759878 | 6.65233884 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 6.35e-9 | NR | XP_005768393.1 | 280463 | g1782 | i0 | 34.6 | 2.84126984126984 | 107 | 63 | 81.7 | 3 | 46 | 354 | 339 | 442 | XP_005768393.1 hypothetical protein EMIHUDRAFT_451583 [Emiliania huxleyi CCMP1516] | diamond | 1074 | 64.3 | 0.993779160186625 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 32161806 | 32161806 | PRJNA384462_S_NODE_7178_length_208_cov_1.905660_g7062_i0 | PRJNA384462 | 7178 | 208 | 1.90566 | 3.9637728 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 96.7 | 7.59e-22 | NR | KAL1526987.1 | 97485 | g7062 | i0 | 64.7 | 0.980769230769231 | 68 | 24 | 98.1 | 0 | 207 | 4 | 160 | 227 | KAL1526987.1 hypothetical protein AB1Y20_015676 [Prymnesium parvum] | diamond | 204 | 96.7 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32256901 | 32256901 | PRJNA384462_S_NODE_6318_length_218_cov_2.562130_g6202_i0 | PRJNA384462 | 6318 | 218 | 2.56213 | 5.5854434 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 71.6 | 1.79e-12 | NR | KAL1495967.1 | 97485 | g6202 | i0 | 56.4 | 1.55504587155963 | 55 | 24 | 75.7 | 0 | 187 | 23 | 1569 | 1623 | KAL1495967.1 hypothetical protein AB1Y20_014608 [Prymnesium parvum] | diamond | 339 | 71.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32351671 | 32351671 | PRJNA384462_S_NODE_5499_length_231_cov_0.906593_g5383_i0 | PRJNA384462 | 5499 | 231 | 0.906593 | 2.09422983 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 88.2 | 1.25e-19 | NR | KOO46011.1 | 1460289 | g5383 | i0 | 68.4 | 1.98701298701299 | 76 | 24 | 98.7 | 0 | 228 | 1 | 1 | 76 | KOO46011.1 hypothetical protein Ctob_010172, partial [Chrysochromulina tobinii] | diamond | 459 | 88.2 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32824842 | 32824842 | PRJNA384462_S_NODE_4240_length_257_cov_5.451923_g4124_i0 | PRJNA384462 | 4240 | 257 | 5.451923 | 14.01144211 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 55.8 | 1.08e-6 | NR | KAL1518426.1 | 97485 | g4124 | i0 | 32.5 | 0.933852140077821 | 80 | 52 | 93.4 | 1 | 256 | 17 | 833 | 910 | KAL1518426.1 hypothetical protein AB1Y20_002718 [Prymnesium parvum] | diamond | 240 | 55.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum |
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);;