contig_metadata
21 rows where bioproject = "PRJNA721440" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19837115 | 19837115 | PRJNA721440_S_NODE_6296_length_243_cov_1.072165_g6170_i0 | PRJNA721440 | 6296 | 243 | 1.072165 | 2.60536095 | root | 1 | Root_unresolved | Root_unresolved | 153 | 2.689999999999999e-41 | NR | KAL1495696.1 | 97485 | g6170 | i0 | 91.3 | 6.91358024691358 | 80 | 7 | 98.8 | 0 | 242 | 3 | 415 | 494 | KAL1495696.1 hypothetical protein AB1Y20_016559 [Prymnesium parvum] | diamond | 1680 | 154 | 0.993506493506494 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 22387596 | 22387596 | PRJNA721440_S_NODE_6358_length_242_cov_1.538860_g6232_i0 | PRJNA721440 | 6358 | 242 | 1.53886 | 3.7240412 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 69.3 | 1.57e-11 | NR | KAL1520290.1 | 97485 | g6232 | i0 | 44.6 | 3.07438016528926 | 83 | 36 | 99.2 | 3 | 2 | 241 | 227 | 302 | KAL1520290.1 hypothetical protein AB1Y20_021882 [Prymnesium parvum] | diamond | 744 | 69.3 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 26830637 | 26830637 | PRJNA721440_S_NODE_19441_length_163_cov_0.982456_g19315_i0 | PRJNA721440 | 19441 | 163 | 0.982456 | 1.60140328 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 44.7 | 0.00262 | NR | XP_005767666.1 | 280463 | g19315 | i0 | 38.8 | 2.77914110429448 | 49 | 30 | 90.2 | 0 | 156 | 10 | 94 | 142 | XP_005767666.1 hypothetical protein EMIHUDRAFT_43544, partial [Emiliania huxleyi CCMP1516] | diamond | 453 | 44.7 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 27030855 | 27030855 | PRJNA721440_S_NODE_10042_length_204_cov_6.303226_g9916_i0 | PRJNA721440 | 10042 | 204 | 6.303226 | 12.85858104 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 109 | 7.7199999999999995e-28 | NR | KAJ1640026.1 | 483367 | g9916 | i0 | 81 | 3.75 | 63 | 12 | 92.6 | 0 | 196 | 8 | 102 | 164 | KAJ1640026.1 glutamine synthetase type III N terminal-domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 765 | 109 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 28410161 | 28410161 | PRJNA721440_S_NODE_17926_length_166_cov_5.000000_g17800_i0 | PRJNA721440 | 17926 | 166 | 5 | 8.3 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 96.7 | 7.46e-23 | NR | KAJ1640223.1 | 483367 | g17800 | i0 | 72.7 | 1.98795180722892 | 55 | 15 | 99.4 | 0 | 2 | 166 | 147 | 201 | KAJ1640223.1 hypothetical protein T492DRAFT_534096 [Pavlovales sp. CCMP2436] | diamond | 330 | 96.7 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 28694489 | 28694489 | PRJNA721440_S_NODE_17567_length_167_cov_3.084746_g17441_i0 | PRJNA721440 | 17567 | 167 | 3.084746 | 5.15152582 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 50.1 | 3.49e-5 | NR | KAG8466611.1 | 2081491 | g17441 | i0 | 46.3 | 0.736526946107784 | 41 | 22 | 73.7 | 0 | 1 | 123 | 176 | 216 | KAG8466611.1 hypothetical protein KFE25_007990 [Diacronema lutheri] | diamond | 123 | 50.1 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29104890 | 29104890 | PRJNA721440_S_NODE_9048_length_212_cov_1.754601_g8922_i0 | PRJNA721440 | 9048 | 212 | 1.754601 | 3.71975412 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 68.6 | 9.13e-12 | NR | KOO24620.1 | 1460289 | g8922 | i0 | 50 | 0.990566037735849 | 70 | 29 | 99.1 | 1 | 211 | 2 | 97 | 160 | KOO24620.1 protein notum-like protein [Chrysochromulina tobinii] | diamond | 210 | 68.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29389036 | 29389036 | PRJNA721440_S_NODE_18169_length_166_cov_0.888889_g18043_i0 | PRJNA721440 | 18169 | 166 | 0.888889 | 1.47555574 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 67 | 1.43e-11 | NR | KOO31350.1 | 1460289 | g18043 | i0 | 54.5 | 0.993975903614458 | 55 | 25 | 99.4 | 0 | 166 | 2 | 158 | 212 | KOO31350.1 proteasome endopeptidase complex beta subunit [Chrysochromulina tobinii] | diamond | 165 | 67 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29609556 | 29609556 | PRJNA721440_S_NODE_11290_length_196_cov_1.768707_g11164_i0 | PRJNA721440 | 11290 | 196 | 1.768707 | 3.46666572 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 70.5 | 2.9e-12 | NR | XP_005793475.1 | 280463 | g11164 | i0 | 58.8 | 2.18877551020408 | 51 | 21 | 78.1 | 0 | 173 | 21 | 214 | 264 | XP_005793475.1 hypothetical protein EMIHUDRAFT_222110 [Emiliania huxleyi CCMP1516] | diamond | 429 | 70.5 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 29641137 | 29641137 | PRJNA721440_S_NODE_7510_length_227_cov_9.421348_g7384_i0 | PRJNA721440 | 7510 | 227 | 9.421348 | 21.38645996 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 42.7 | 0.0178 | NR | KAL1524702.1 | 97485 | g7384 | i0 | 34.2 | 0.964757709251101 | 73 | 40 | 92.5 | 3 | 210 | 1 | 61 | 128 | KAL1524702.1 hypothetical protein AB1Y20_019587 [Prymnesium parvum] | diamond | 219 | 42.7 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29735950 | 29735950 | PRJNA721440_S_NODE_17390_length_168_cov_0.873950_g17264_i0 | PRJNA721440 | 17390 | 168 | 0.87395 | 1.468236 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 66.2 | 3.42e-11 | NR | KAL1515805.1 | 97485 | g17264 | i0 | 63 | 2.32142857142857 | 46 | 15 | 82.1 | 1 | 166 | 29 | 165 | 208 | KAL1515805.1 hypothetical protein AB1Y20_002421 [Prymnesium parvum] | diamond | 390 | 66.2 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30178356 | 30178356 | PRJNA721440_S_NODE_5432_length_257_cov_6.990385_g5306_i0 | PRJNA721440 | 5432 | 257 | 6.990385 | 17.96528945 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 114 | 2.63e-27 | NR | KAL1500319.1 | 97485 | g5306 | i0 | 65.1 | 2.96498054474708 | 83 | 29 | 96.9 | 0 | 250 | 2 | 391 | 473 | KAL1500319.1 hypothetical protein AB1Y20_012985 [Prymnesium parvum] | diamond | 762 | 114 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 30525939 | 30525939 | PRJNA721440_S_NODE_8713_length_215_cov_1.566265_g8587_i0 | PRJNA721440 | 8713 | 215 | 1.566265 | 3.36746975 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 113 | 2.9500000000000003e-27 | NR | XP_005764875.1 | 280463 | g8587 | i0 | 67.6 | 0.990697674418605 | 71 | 23 | 99.1 | 0 | 1 | 213 | 366 | 436 | XP_005764875.1 mitochondrial malic enzyme [Emiliania huxleyi CCMP1516] | diamond | 213 | 113 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 30810348 | 30810348 | PRJNA721440_S_NODE_14374_length_179_cov_1.946154_g14248_i0 | PRJNA721440 | 14374 | 179 | 1.946154 | 3.48361566 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 88.2 | 8.28e-19 | NR | KOO28580.1 | 1460289 | g14248 | i0 | 69 | 3.97206703910615 | 58 | 18 | 97.2 | 0 | 2 | 175 | 287 | 344 | KOO28580.1 DNA-directed RNA polymerases i and iii subunit rpac1 [Chrysochromulina tobinii] | diamond | 711 | 88.2 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 30873546 | 30873546 | PRJNA721440_S_NODE_21114_length_156_cov_2.579439_g20988_i0 | PRJNA721440 | 21114 | 156 | 2.579439 | 4.02392484 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 80.9 | 3.05e-16 | NR | KAL1521850.1 | 97485 | g20988 | i0 | 83.3 | 3.17307692307692 | 42 | 7 | 80.8 | 0 | 3 | 128 | 349 | 390 | KAL1521850.1 hypothetical protein AB1Y20_021501 [Prymnesium parvum] | diamond | 495 | 80.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 31042352 | 31042352 | PRJNA721440_S_NODE_4415_length_280_cov_1.593074_g4289_i0 | PRJNA721440 | 4415 | 280 | 1.593074 | 4.4606072 | root | 1 | Root_unresolved | Root_unresolved | 160 | 1.28e-45 | NR | XP_005790923.1 | 280463 | g4289 | i0 | 80.7 | 9.58928571428571 | 88 | 17 | 94.3 | 0 | 4 | 267 | 168 | 255 | XP_005790923.1 hypothetical protein EMIHUDRAFT_361737 [Emiliania huxleyi CCMP1516] | diamond | 2685 | 161 | 0.993788819875776 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 31094675 | 31094675 | PRJNA721440_S_NODE_3455_length_308_cov_2.208494_g3329_i0 | PRJNA721440 | 3455 | 308 | 2.208494 | 6.80216152 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 58.5 | 2.21e-7 | NR | KAG8469634.1 | 2081491 | g3329 | i0 | 47.4 | 0.555194805194805 | 57 | 30 | 55.5 | 0 | 2 | 172 | 478 | 534 | KAG8469634.1 hypothetical protein KFE25_006089 [Diacronema lutheri] | diamond | 171 | 58.5 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 31600834 | 31600834 | PRJNA721440_S_NODE_13536_length_183_cov_1.746269_g13410_i0 | PRJNA721440 | 13536 | 183 | 1.746269 | 3.19567227 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 70.1 | 3.52e-12 | NR | KAG8468955.1 | 2081491 | g13410 | i0 | 49.1 | 0.934426229508197 | 57 | 29 | 93.4 | 0 | 176 | 6 | 264 | 320 | KAG8468955.1 hypothetical protein KFE25_007473 [Diacronema lutheri] | diamond | 171 | 70.1 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 31642574 | 31642574 | PRJNA721440_S_NODE_12356_length_189_cov_2.650000_g12230_i0 | PRJNA721440 | 12356 | 189 | 2.65 | 5.0085 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 1.52e-29 | NR | KAJ1629966.1 | 483367 | g12230 | i0 | 76.7 | 4.76190476190476 | 60 | 14 | 95.2 | 0 | 184 | 5 | 147 | 206 | KAJ1629966.1 delta-5 desaturase [Pavlovales sp. CCMP2436] | diamond | 900 | 118 | 0.991525423728814 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 32423266 | 32423266 | PRJNA721440_S_NODE_8199_length_220_cov_1.461988_g8073_i0 | PRJNA721440 | 8199 | 220 | 1.461988 | 3.2163736 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 42 | 0.0311 | NR | KAL1524702.1 | 97485 | g8073 | i0 | 39.6 | 0.654545454545455 | 48 | 27 | 62.7 | 1 | 209 | 72 | 54 | 101 | KAL1524702.1 hypothetical protein AB1Y20_019587 [Prymnesium parvum] | diamond | 144 | 42 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32612840 | 32612840 | PRJNA721440_S_NODE_22160_length_151_cov_5.098039_g22034_i0 | PRJNA721440 | 22160 | 151 | 5.098039 | 7.69803889 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 47.8 | 1.74e-4 | NR | XP_005793475.1 | 280463 | g22034 | i0 | 51.4 | 0.735099337748344 | 37 | 18 | 73.5 | 0 | 39 | 149 | 209 | 245 | XP_005793475.1 hypothetical protein EMIHUDRAFT_222110 [Emiliania huxleyi CCMP1516] | diamond | 111 | 47.8 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi |
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);;