contig_metadata
26 rows where bioproject = "PRJNA533623", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1781610 | 1781610 | PRJNA533623_P_NODE_30262_length_412_cov_3.470085_g28492_i0 | PRJNA533623 | 30262 | 412 | 3.470085 | 14.2967502 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 148 | 4.91e-31 | NTclustered | gi|551626087|ref|XM_005793063.1| | 280463 | g28492 | i0 | 77.007 | 1.06067961165049 | 274 | 54 | 65 | 7 | 9 | 277 | 1399 | 1668 | Emiliania huxleyi CCMP1516 chaperonin complex component, TCP-1 eta subunit partial mRNA | blastn | 437 | 148 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 6884641 | 6884641 | PRJNA533623_P_NODE_6306_length_917_cov_15.045561_g4991_i0 | PRJNA533623 | 6306 | 917 | 15.045561 | 137.96779437 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 292 | 2.29e-94 | NR | KAG8459849.1 | 2081491 | g4991 | i0 | 52.8 | 2.61395856052345 | 265 | 103 | 79.5 | 1 | 863 | 135 | 11 | 275 | KAG8459849.1 hypothetical protein KFE25_014412 [Diacronema lutheri] | diamond | 2397 | 293 | 0.996587030716723 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 6884655 | 6884655 | PRJNA533623_P_NODE_6366_length_913_cov_149.667840_g5047_i0 | PRJNA533623 | 6366 | 913 | 149.66784 | 1366.4673792 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 920 | 0 | NTclustered | gi|551583414|ref|XM_005777087.1| | 280463 | g5047 | i0 | 87.929 | 85.4107338444688 | 787 | 88 | 86 | 7 | 1 | 782 | 4794 | 4010 | Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA | blastn | 77980 | 920 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 9434766 | 9434766 | PRJNA533623_P_NODE_37628_length_359_cov_8.607383_g35856_i0 | PRJNA533623 | 37628 | 359 | 8.607383 | 30.90050497 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 145 | 1.97e-41 | NR | KAG8468424.1 | 2081491 | g35856 | i0 | 82.6 | 1.45403899721448 | 86 | 14 | 71 | 1 | 26 | 280 | 105 | 190 | KAG8468424.1 hypothetical protein KFE25_013507 [Diacronema lutheri] | diamond | 522 | 145 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 14535186 | 14535186 | PRJNA533623_P_NODE_35012_length_375_cov_18.624204_g33240_i0 | PRJNA533623 | 35012 | 375 | 18.624204 | 69.840765 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 215 | 4.3e-51 | NTclustered | gi|551551396|ref|XM_005763098.1| | 280463 | g33240 | i0 | 79.538 | 2.4 | 303 | 60 | 81 | 2 | 27 | 328 | 2653 | 2954 | Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA | blastn | 900 | 215 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 15810126 | 15810126 | PRJNA533623_P_NODE_8893_length_784_cov_34.250346_g7395_i0 | PRJNA533623 | 8893 | 784 | 34.250346 | 268.52271264 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 60.2 | 4.7e-4 | NTclustered | gi|551572362|ref|XM_005771971.1| | 280463 | g7395 | i0 | 97.143 | 0.247448979591837 | 35 | 1 | 4 | 0 | 483 | 517 | 371 | 405 | Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA | blastn | 194 | 60.2 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 19633326 | 19633326 | PRJNA533623_P_NODE_7416_length_851_cov_36.350633_g6011_i0 | PRJNA533623 | 7416 | 851 | 36.350633 | 309.34388683 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 171 | 6.21e-49 | NR | KAL1521348.1 | 97485 | g6011 | i0 | 89.8 | 11.4077555816686 | 88 | 9 | 31 | 0 | 467 | 204 | 107 | 194 | KAL1521348.1 hypothetical protein AB1Y20_021015 [Prymnesium parvum] | diamond | 9708 | 171 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 26856503 | 26856503 | PRJNA533623_P_NODE_10841_length_713_cov_9.625767_g9257_i0 | PRJNA533623 | 10841 | 713 | 9.625767 | 68.63171871 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 170 | 4.71e-49 | NR | KAL1515425.1 | 97485 | g9257 | i0 | 42.8 | 0.904628330995792 | 215 | 120 | 89.6 | 2 | 47 | 685 | 4 | 217 | KAL1515425.1 hypothetical protein AB1Y20_002051 [Prymnesium parvum] | diamond | 645 | 170 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27724902 | 27724902 | PRJNA533623_P_NODE_19784_length_526_cov_2.378495_g18040_i0 | PRJNA533623 | 19784 | 526 | 2.378495 | 12.5108837 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 140 | 1.7599999999999998e-37 | NR | KAJ1635204.1 | 483367 | g18040 | i0 | 64 | 1.95627376425856 | 114 | 40 | 65 | 1 | 510 | 169 | 35 | 147 | KAJ1635204.1 cyclin-like protein, partial [Pavlovales sp. CCMP2436] | diamond | 1029 | 140 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 28782910 | 28782910 | PRJNA533623_P_NODE_17507_length_561_cov_17.448000_g15776_i0 | PRJNA533623 | 17507 | 561 | 17.448 | 97.88328 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 140 | 3.76e-36 | NR | KAG8457748.1 | 2081491 | g15776 | i0 | 68.4 | 2.62032085561497 | 98 | 31 | 52.4 | 0 | 543 | 250 | 293 | 390 | KAG8457748.1 hypothetical protein KFE25_005761 [Diacronema lutheri] | diamond | 1470 | 140 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 28814375 | 28814375 | PRJNA533623_P_NODE_20448_length_516_cov_7.248352_g18701_i0 | PRJNA533623 | 20448 | 516 | 7.248352 | 37.40149632 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 125 | 5.8899999999999995e-30 | NR | XP_005778384.1 | 280463 | g18701 | i0 | 40.7 | 0.970930232558139 | 167 | 91 | 95.9 | 3 | 10 | 504 | 147 | 307 | XP_005778384.1 hypothetical protein EMIHUDRAFT_237375 [Emiliania huxleyi CCMP1516] | diamond | 501 | 125 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 29035918 | 29035918 | PRJNA533623_P_NODE_8348_length_807_cov_13.522788_g6887_i0 | PRJNA533623 | 8348 | 807 | 13.522788 | 109.12889916 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 58.2 | 1.81e-5 | NR | KAG8470538.1 | 2081491 | g6887 | i0 | 37.6 | 0.315985130111524 | 85 | 49 | 31.6 | 2 | 517 | 771 | 1062 | 1142 | KAG8470538.1 hypothetical protein KFE25_008959 [Diacronema lutheri] | diamond | 255 | 58.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29445962 | 29445962 | PRJNA533623_P_NODE_38490_length_354_cov_2.563140_g36717_i0 | PRJNA533623 | 38490 | 354 | 2.56314 | 9.0735156 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 44.7 | 0.0251 | NR | KAL1529939.1 | 97485 | g36717 | i0 | 51.2 | 0.347457627118644 | 41 | 18 | 33.1 | 1 | 14 | 130 | 314 | 354 | KAL1529939.1 hypothetical protein AB1Y20_000867 [Prymnesium parvum] | diamond | 123 | 44.7 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29793307 | 29793307 | PRJNA533623_P_NODE_3691_length_1148_cov_24.163753_g2656_i0 | PRJNA533623 | 3691 | 1148 | 24.163753 | 277.39988444 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 303 | 8.999999999999997e-94 | NR | KAJ1639173.1 | 483367 | g2656 | i0 | 50.3 | 0.804878048780488 | 308 | 151 | 80 | 1 | 930 | 13 | 59 | 366 | KAJ1639173.1 armadillo-type protein [Pavlovales sp. CCMP2436] | diamond | 924 | 303 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 30014646 | 30014646 | PRJNA533623_P_NODE_12691_length_661_cov_10.076667_g11035_i0 | PRJNA533623 | 12691 | 661 | 10.076667 | 66.60676887 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 79.7 | 1.15e-14 | NR | KAJ1629848.1 | 483367 | g11035 | i0 | 44.2 | 0.390317700453858 | 86 | 44 | 37.2 | 1 | 575 | 330 | 12 | 97 | KAJ1629848.1 hypothetical protein T492DRAFT_840473 [Pavlovales sp. CCMP2436] | diamond | 258 | 79.7 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 30172459 | 30172459 | PRJNA533623_P_NODE_11552_length_692_cov_31.689382_g9939_i0 | PRJNA533623 | 11552 | 692 | 31.689382 | 219.29052344 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 115 | 6.11e-27 | NR | XP_005774162.1 | 280463 | g9939 | i0 | 33 | 0.919075144508671 | 212 | 126 | 85.8 | 3 | 686 | 93 | 71 | 280 | XP_005774162.1 hypothetical protein EMIHUDRAFT_421557 [Emiliania huxleyi CCMP1516] | diamond | 636 | 115 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 30250959 | 30250959 | PRJNA533623_P_NODE_41112_length_338_cov_6.079422_g39338_i0 | PRJNA533623 | 41112 | 338 | 6.079422 | 20.54844636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.1 | 1.63e-9 | NR | KAL1528872.1 | 97485 | g39338 | i0 | 44.4 | 2.32544378698225 | 72 | 38 | 63 | 2 | 319 | 107 | 727 | 797 | KAL1528872.1 hypothetical protein AB1Y20_010195 [Prymnesium parvum] | diamond | 786 | 65.5 | 0.993893129770992 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31057566 | 31057566 | PRJNA533623_P_NODE_17975_length_553_cov_8.851626_g16241_i0 | PRJNA533623 | 17975 | 553 | 8.851626 | 48.94949178 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 55.1 | 2.71e-5 | NR | KOO26345.1 | 1460289 | g16241 | i0 | 47.3 | 0.298372513562387 | 55 | 29 | 29.8 | 0 | 188 | 24 | 82 | 136 | KOO26345.1 hypothetical protein Ctob_002239 [Chrysochromulina tobinii] | diamond | 165 | 55.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 31057592 | 31057592 | PRJNA533623_P_NODE_65275_length_235_cov_3.706897_g63494_i0 | PRJNA533623 | 65275 | 235 | 3.706897 | 8.71120795 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 57.8 | 1.6e-7 | NR | XP_005786803.1 | 280463 | g63494 | i0 | 75.7 | 0.94468085106383 | 37 | 9 | 47.2 | 0 | 212 | 102 | 376 | 412 | XP_005786803.1 hypothetical protein EMIHUDRAFT_426559 [Emiliania huxleyi CCMP1516] | diamond | 222 | 57.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 31120096 | 31120096 | PRJNA533623_P_NODE_51595_length_287_cov_3.464602_g49816_i0 | PRJNA533623 | 51595 | 287 | 3.464602 | 9.94340774 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 56.6 | 6.03e-7 | NR | KAL1522543.1 | 97485 | g49816 | i0 | 50 | 1.28571428571429 | 60 | 28 | 62.7 | 1 | 70 | 249 | 210 | 267 | KAL1522543.1 hypothetical protein AB1Y20_017529 [Prymnesium parvum] | diamond | 369 | 56.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31309991 | 31309991 | PRJNA533623_P_NODE_11635_length_690_cov_5.790143_g10020_i0 | PRJNA533623 | 11635 | 690 | 5.790143 | 39.9519867 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 79 | 2.3e-13 | NR | KAJ1636276.1 | 483367 | g10020 | i0 | 30.3 | 0.817391304347826 | 188 | 112 | 74.3 | 3 | 517 | 5 | 23 | 208 | KAJ1636276.1 hypothetical protein T492DRAFT_1141257 [Pavlovales sp. CCMP2436] | diamond | 564 | 79 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 31721273 | 31721273 | PRJNA533623_P_NODE_38797_length_352_cov_4.006873_g37023_i0 | PRJNA533623 | 38797 | 352 | 4.006873 | 14.10419296 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 70.9 | 1.76e-11 | NR | KAL1503913.1 | 97485 | g37023 | i0 | 34.9 | 0.928977272727273 | 109 | 43 | 92.9 | 1 | 4 | 330 | 434 | 514 | KAL1503913.1 hypothetical protein AB1Y20_012374 [Prymnesium parvum] | diamond | 327 | 70.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31862563 | 31862563 | PRJNA533623_P_NODE_19417_length_531_cov_12.304255_g17676_i0 | PRJNA533623 | 19417 | 531 | 12.304255 | 65.33559405 | Prymnesium | 35143 | Haptophyta | other_Eukaryota | 161 | 3.83e-46 | NR | KAL1504444.1 | 97485 | g17676 | i0 | 59 | 1.90395480225989 | 166 | 58 | 88.1 | 3 | 509 | 42 | 70 | 235 | KAL1504444.1 hypothetical protein AB1Y20_010850 [Prymnesium parvum] | diamond | 1011 | 162 | 0.993827160493827 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32069227 | 32069227 | PRJNA533623_P_NODE_7178_length_863_cov_23.188279_g5791_i0 | PRJNA533623 | 7178 | 863 | 23.188279 | 200.11484777 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 143 | 1.7099999999999996e-34 | NR | KAL1525927.1 | 97485 | g5791 | i0 | 47 | 0.570104287369641 | 164 | 84 | 56.7 | 2 | 130 | 618 | 4 | 165 | KAL1525927.1 hypothetical protein AB1Y20_020753 [Prymnesium parvum] | diamond | 492 | 143 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32291185 | 32291185 | PRJNA533623_P_NODE_33379_length_387_cov_6.457055_g31608_i0 | PRJNA533623 | 33379 | 387 | 6.457055 | 24.98880285 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 150 | 2.2799999999999998e-40 | NR | KAL1528340.1 | 97485 | g31608 | i0 | 62.5 | 0.868217054263566 | 112 | 42 | 86.8 | 0 | 365 | 30 | 392 | 503 | KAL1528340.1 hypothetical protein AB1Y20_009694 [Prymnesium parvum] | diamond | 336 | 150 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32354358 | 32354358 | PRJNA533623_P_NODE_67499_length_228_cov_1.556886_g65718_i0 | PRJNA533623 | 67499 | 228 | 1.556886 | 3.54970008 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 85.9 | 1.84e-17 | NR | KOO33925.1 | 1460289 | g65718 | i0 | 73.8 | 0.552631578947368 | 42 | 11 | 55.3 | 0 | 127 | 2 | 467 | 508 | KOO33925.1 papain family cysteine protease containing protein [Chrysochromulina tobinii] | diamond | 126 | 85.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii |
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);;