contig_metadata
21 rows where bioproject = "PRJNA914897", tax_phylum = "Haptophyta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22571915 | 22571915 | PRJNA914897_P_NODE_21618_length_360_cov_1.195122_g21194_i0 | PRJNA914897 | 21618 | 360 | 1.195122 | 4.3024392 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 91.7 | 4.35e-19 | NR | KAL3909975.1 | 2812485 | g21194 | i0 | 49.4 | 1.35 | 85 | 43 | 70.8 | 0 | 261 | 7 | 186 | 270 | KAL3909975.1 MAG: hypothetical protein SGPRY_009228 [Prymnesium sp.] | diamond | 486 | 91.7 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 26612821 | 26612821 | PRJNA914897_P_NODE_21021_length_366_cov_145.290102_g20598_i0 | PRJNA914897 | 21021 | 366 | 145.290102 | 531.76177332 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 87.4 | 1.76e-19 | NR | XP_005782836.1 | 280463 | g20598 | i0 | 50 | 1.70491803278689 | 102 | 47 | 82.8 | 2 | 26 | 328 | 16 | 114 | XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] | diamond | 624 | 87.4 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26707679 | 26707679 | PRJNA914897_P_NODE_28321_length_300_cov_1.044053_g27897_i0 | PRJNA914897 | 28321 | 300 | 1.044053 | 3.132159 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 94 | 1.17e-21 | NR | KOO22814.1 | 1460289 | g27897 | i0 | 45.5 | 2.91 | 99 | 54 | 99 | 0 | 298 | 2 | 24 | 122 | KOO22814.1 hypothetical protein Ctob_009224 [Chrysochromulina tobinii] | diamond | 873 | 94 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 27087863 | 27087863 | PRJNA914897_P_NODE_40862_length_244_cov_0.900585_g40438_i0 | PRJNA914897 | 40862 | 244 | 0.900585 | 2.1974274 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 80.5 | 2e-15 | NR | KAG8469335.1 | 2081491 | g40438 | i0 | 48.7 | 2.8155737704918 | 78 | 39 | 94.7 | 1 | 244 | 14 | 2052 | 2129 | KAG8469335.1 hypothetical protein KFE25_007853 [Diacronema lutheri] | diamond | 687 | 80.5 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 28161764 | 28161764 | PRJNA914897_P_NODE_4265_length_971_cov_6.582405_g3961_i0 | PRJNA914897 | 4265 | 971 | 6.582405 | 63.91515255 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 131 | 3.85e-30 | NR | KAG8463072.1 | 2081491 | g3961 | i0 | 34 | 2.51493305870237 | 306 | 181 | 90.5 | 8 | 963 | 85 | 317 | 614 | KAG8463072.1 hypothetical protein KFE25_001845 [Diacronema lutheri] | diamond | 2442 | 131 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29045774 | 29045774 | PRJNA914897_P_NODE_29968_length_288_cov_1.716279_g29544_i0 | PRJNA914897 | 29968 | 288 | 1.716279 | 4.94288352 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 75.5 | 1.96e-13 | NR | KAL1526066.1 | 97485 | g29544 | i0 | 46.1 | 2.25 | 76 | 41 | 79.2 | 0 | 233 | 6 | 26 | 101 | KAL1526066.1 hypothetical protein AB1Y20_020887 [Prymnesium parvum] | diamond | 648 | 75.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29361442 | 29361442 | PRJNA914897_P_NODE_27929_length_303_cov_1.339130_g27505_i0 | PRJNA914897 | 27929 | 303 | 1.33913 | 4.0575639 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 141 | 7.399999999999998e-41 | NR | KOO32083.1 | 1460289 | g27505 | i0 | 73.5 | 1.93069306930693 | 98 | 25 | 97 | 1 | 298 | 5 | 24 | 120 | KOO32083.1 60s ribosomal protein l22 [Chrysochromulina tobinii] | diamond | 585 | 141 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29519246 | 29519246 | PRJNA914897_P_NODE_42310_length_241_cov_1.922619_g41886_i0 | PRJNA914897 | 42310 | 241 | 1.922619 | 4.63351179 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 52.8 | 1.07e-5 | NR | KAL3932640.1 | 2812485 | g41886 | i0 | 39.2 | 0.983402489626556 | 79 | 48 | 98.3 | 0 | 4 | 240 | 510 | 588 | KAL3932640.1 MAG: hypothetical protein SGPRY_000622 [Prymnesium sp.] | diamond | 237 | 52.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 29582073 | 29582073 | PRJNA914897_P_NODE_26110_length_317_cov_2.536885_g25686_i0 | PRJNA914897 | 26110 | 317 | 2.536885 | 8.04192545 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 63.5 | 4.62e-9 | NR | KAL1514775.1 | 97485 | g25686 | i0 | 36.1 | 3.06624605678233 | 108 | 60 | 99.4 | 3 | 316 | 2 | 2125 | 2226 | KAL1514775.1 hypothetical protein AB1Y20_003861 [Prymnesium parvum] | diamond | 972 | 63.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30561405 | 30561405 | PRJNA914897_P_NODE_12653_length_513_cov_4.470455_g12233_i0 | PRJNA914897 | 12653 | 513 | 4.470455 | 22.93343415 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 50.1 | 4.7e-4 | NR | KAG8469453.1 | 2081491 | g12233 | i0 | 27.8 | 1.10526315789474 | 97 | 69 | 56.7 | 1 | 291 | 1 | 63 | 158 | KAG8469453.1 hypothetical protein KFE25_005908 [Diacronema lutheri] | diamond | 567 | 50.1 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30972559 | 30972559 | PRJNA914897_P_NODE_9854_length_603_cov_1.467925_g9439_i0 | PRJNA914897 | 9854 | 603 | 1.467925 | 8.85158775 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 68.9 | 9.73e-10 | NR | KAJ1638830.1 | 483367 | g9439 | i0 | 38.3 | 2.06965174129353 | 120 | 68 | 59.2 | 2 | 382 | 26 | 300 | 414 | KAJ1638830.1 hypothetical protein T492DRAFT_857737 [Pavlovales sp. CCMP2436] | diamond | 1248 | 68.9 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 31011318 | 31011318 | PRJNA914897_P_NODE_16714_length_427_cov_0.807910_g16292_i0 | PRJNA914897 | 16714 | 427 | 0.80791 | 3.4497757 | Diacronema | 70451 | Haptophyta | other_Eukaryota | 86.3 | 1.67e-16 | NR | KAJ1633108.1 | 483367 | g16292 | i0 | 34.1 | 1.76346604215457 | 126 | 83 | 88.5 | 0 | 48 | 425 | 394 | 519 | KAJ1633108.1 PTHB1 N-terminus-domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 753 | 86.3 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 31731157 | 31731157 | PRJNA914897_P_NODE_42317_length_241_cov_1.833333_g41893_i0 | PRJNA914897 | 42317 | 241 | 1.833333 | 4.41833253 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 63.9 | 1.25e-9 | NR | KAL1503852.1 | 97485 | g41893 | i0 | 45.6 | 0.983402489626556 | 79 | 43 | 98.3 | 0 | 4 | 240 | 133 | 211 | KAL1503852.1 hypothetical protein AB1Y20_012316 [Prymnesium parvum] | diamond | 237 | 63.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31762843 | 31762843 | PRJNA914897_P_NODE_18457_length_400_cov_2.128440_g18035_i0 | PRJNA914897 | 18457 | 400 | 2.12844 | 8.51376 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 65.9 | 6.26e-10 | NR | KAL1502981.1 | 97485 | g18035 | i0 | 33.8 | 0.975 | 130 | 70 | 93.8 | 6 | 18 | 392 | 18 | 136 | KAL1502981.1 hypothetical protein AB1Y20_011051 [Prymnesium parvum] | diamond | 390 | 65.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32079216 | 32079216 | PRJNA914897_P_NODE_13758_length_487_cov_1.301932_g13336_i0 | PRJNA914897 | 13758 | 487 | 1.301932 | 6.34040884 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 81.3 | 1.21e-14 | NR | KAL1528937.1 | 97485 | g13336 | i0 | 55.9 | 0.363449691991786 | 59 | 26 | 36.3 | 0 | 179 | 3 | 36 | 94 | KAL1528937.1 hypothetical protein AB1Y20_010259 [Prymnesium parvum] | diamond | 177 | 81.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32079231 | 32079231 | PRJNA914897_P_NODE_28918_length_295_cov_1.860360_g28494_i0 | PRJNA914897 | 28918 | 295 | 1.86036 | 5.488062 | Isochrysis galbana | 37099 | Haptophyta | other_Eukaryota | 55.5 | 2.69e-7 | NR | ALD47958.1 | 37099 | g28494 | i0 | 34.8 | 0.905084745762712 | 89 | 57 | 90.5 | 1 | 3 | 269 | 18 | 105 | ALD47958.1 adaptor protein complex 1 subunit gamma, partial [Isochrysis galbana] | diamond | 267 | 55.5 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Isochrysis | Isochrysis galbana | |||
| 32110976 | 32110976 | PRJNA914897_P_NODE_24998_length_327_cov_1.212598_g24574_i0 | PRJNA914897 | 24998 | 327 | 1.212598 | 3.96519546 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 52 | 5.43e-5 | NR | KOO34375.1 | 1460289 | g24574 | i0 | 38.7 | 0.688073394495413 | 75 | 44 | 68.8 | 1 | 24 | 248 | 379 | 451 | KOO34375.1 70 kda peptidylprolyl isomerase, partial [Chrysochromulina tobinii] | diamond | 225 | 52 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32142636 | 32142636 | PRJNA914897_P_NODE_26018_length_318_cov_1.559184_g25594_i0 | PRJNA914897 | 26018 | 318 | 1.559184 | 4.95820512 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 77.8 | 4.49e-14 | NR | KAL1499456.1 | 97485 | g25594 | i0 | 46.4 | 4.77358490566038 | 69 | 37 | 65.1 | 0 | 316 | 110 | 105 | 173 | KAL1499456.1 hypothetical protein AB1Y20_011660 [Prymnesium parvum] | diamond | 1518 | 77.8 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32237816 | 32237816 | PRJNA914897_P_NODE_29838_length_289_cov_1.370370_g29414_i0 | PRJNA914897 | 29838 | 289 | 1.37037 | 3.9603693 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 80.9 | 2.66e-15 | NR | KOO21816.1 | 1460289 | g29414 | i0 | 41.8 | 6.12456747404844 | 98 | 55 | 99.7 | 2 | 1 | 288 | 513 | 610 | KOO21816.1 pre-mRNA-splicing factor rse1 [Chrysochromulina tobinii] | diamond | 1770 | 80.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32718753 | 32718753 | PRJNA914897_P_NODE_15680_length_445_cov_20.233871_g15258_i0 | PRJNA914897 | 15680 | 445 | 20.233871 | 90.04072595 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.2 | 3.07e-15 | NR | KAL1510948.1 | 97485 | g15258 | i0 | 36.4 | 2.02247191011236 | 129 | 68 | 78.9 | 3 | 423 | 73 | 10 | 136 | KAL1510948.1 hypothetical protein AB1Y20_005775 [Prymnesium parvum] | diamond | 900 | 78.6 | 0.994910941475827 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32718758 | 32718758 | PRJNA914897_P_NODE_39920_length_245_cov_1.720930_g39496_i0 | PRJNA914897 | 39920 | 245 | 1.72093 | 4.2162785 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 6.63e-4 | NR | KAL1519099.1 | 97485 | g39496 | i0 | 58.8 | 1.78775510204082 | 34 | 14 | 41.6 | 0 | 62 | 163 | 110 | 143 | KAL1519099.1 hypothetical protein AB1Y20_003365 [Prymnesium parvum] | diamond | 438 | 47.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);;