contig_metadata
28 rows where bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5257803 | 5257803 | PRJNA1010662_P_NODE_2065_length_354_cov_1.350820_g2006_i0 | PRJNA1010662 | 2065 | 354 | 1.35082 | 4.7819028 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 1.02e-65 | NR | KAJ1616909.1 | 483367 | g2006 | i0 | 88 | 17.8474576271186 | 117 | 14 | 99.2 | 0 | 2 | 352 | 173 | 289 | KAJ1616909.1 26S proteasome AAA-ATPase subunit RPT6a [Pavlovales sp. CCMP2436] | diamond | 6318 | 211 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 9082326 | 9082326 | PRJNA1010662_P_NODE_11188_length_176_cov_1.905512_g11129_i0 | PRJNA1010662 | 11188 | 176 | 1.905512 | 3.35370112 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 202 | 1.39e-47 | NTclustered | gi|551620797|ref|XM_005790858.1| | 280463 | g11129 | i0 | 88.957 | 83.4204545454545 | 163 | 18 | 93 | 0 | 1 | 163 | 843 | 681 | Emiliania huxleyi CCMP1516 S-adenosyl-L-homocysteine hydrolase mRNA | blastn | 14682 | 202 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 11633565 | 11633565 | PRJNA1010662_P_NODE_9510_length_188_cov_1.388489_g9451_i0 | PRJNA1010662 | 9510 | 188 | 1.388489 | 2.61035932 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 8.42e-26 | NR | XP_005773968.1 | 280463 | g9451 | i0 | 85.7 | 13.6436170212766 | 56 | 8 | 89.4 | 0 | 169 | 2 | 2 | 57 | XP_005773968.1 hypothetical protein EMIHUDRAFT_74860 [Emiliania huxleyi CCMP1516] | diamond | 2565 | 100 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 19280420 | 19280420 | PRJNA1010662_P_NODE_1996_length_359_cov_1.519355_g1937_i0 | PRJNA1010662 | 1996 | 359 | 1.519355 | 5.45448445 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 263 | 1.44e-65 | NTclustered | gi|551548842|ref|XM_005762007.1| | 280463 | g1937 | i0 | 85.214 | 5.46518105849582 | 257 | 36 | 71 | 2 | 103 | 358 | 402 | 147 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 1962 | 263 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26837294 | 26837294 | PRJNA1010662_P_NODE_8381_length_197_cov_1.405405_g8322_i0 | PRJNA1010662 | 8381 | 197 | 1.405405 | 2.76864785 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 5.24e-8 | NR | KAL1503075.1 | 97485 | g8322 | i0 | 58.2 | 2.49746192893401 | 55 | 21 | 80.7 | 2 | 196 | 38 | 96 | 150 | KAL1503075.1 hypothetical protein AB1Y20_011140 [Prymnesium parvum] | diamond | 492 | 58.9 | 0.99320882852292 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27002681 | 27002681 | PRJNA1010662_P_NODE_9122_length_191_cov_1.070423_g9063_i0 | PRJNA1010662 | 9122 | 191 | 1.070423 | 2.04450793 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 77 | 1.52e-14 | NR | XP_005756827.1 | 280463 | g9063 | i0 | 60.4 | 1.66492146596859 | 53 | 21 | 83.2 | 0 | 191 | 33 | 172 | 224 | XP_005756827.1 acetolactate synthase catalytic subunit [Emiliania huxleyi CCMP1516] | diamond | 318 | 77 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 27223987 | 27223987 | PRJNA1010662_P_NODE_10083_length_184_cov_1.155556_g10024_i0 | PRJNA1010662 | 10083 | 184 | 1.155556 | 2.12622304 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 48.1 | 2.16e-4 | NR | KAL1519819.1 | 97485 | g10024 | i0 | 49.1 | 1.80978260869565 | 53 | 26 | 86.4 | 1 | 2 | 160 | 394 | 445 | KAL1519819.1 hypothetical protein AB1Y20_023325 [Prymnesium parvum] | diamond | 333 | 48.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 27532576 | 27532576 | PRJNA1010662_P_NODE_10263_length_182_cov_2.751880_g10204_i0 | PRJNA1010662 | 10263 | 182 | 2.75188 | 5.0084216 | Cryptophyceae | 3027 | Haptophyta | other_Eukaryota | 73.2 | 2.23e-14 | NR | Q43362.1 | 13221 | g10204 | i0 | 65 | 3.01648351648352 | 60 | 20 | 98.9 | 1 | 1 | 180 | 48 | 106 | Q43362.1 RecName: Full=V-type proton ATPase 16 kDa proteolipid subunit; Short=V-ATPase 16 kDa proteolipid subunit; AltName: Full=Vacuolar proton pump 16 kDa proteolipid subunit [Chrysotila carterae] | diamond | 549 | 73.9 | 0.990527740189445 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Isochrysidaceae | Chrysotila | Chrysotila carterae | |||
| 27761403 | 27761403 | PRJNA1010662_P_NODE_16204_length_163_cov_0.903509_g16145_i0 | PRJNA1010662 | 16204 | 163 | 0.903509 | 1.47271967 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 68.2 | 2.59e-12 | NR | KAG8456888.1 | 2081491 | g16145 | i0 | 63 | 2.59509202453988 | 46 | 17 | 84.7 | 0 | 140 | 3 | 5 | 50 | KAG8456888.1 hypothetical protein KFE25_005038 [Diacronema lutheri] | diamond | 423 | 68.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 27792804 | 27792804 | PRJNA1010662_P_NODE_1044_length_495_cov_2.432735_g985_i0 | PRJNA1010662 | 1044 | 495 | 2.432735 | 12.04203825 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 104 | 6.949999999999999e-23 | NR | XP_005759595.1 | 280463 | g985 | i0 | 38.2 | 0.921212121212121 | 152 | 87 | 89.7 | 3 | 3 | 446 | 161 | 309 | XP_005759595.1 von Willebrand factor type A domain-containing protein [Emiliania huxleyi CCMP1516] | diamond | 456 | 104 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 27879908 | 27879908 | PRJNA1010662_P_NODE_5_length_2626_cov_3.078774_g2_i0 | PRJNA1010662 | 5 | 2626 | 3.078774 | 80.84860524 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 1.95e-26 | NR | KAL1508137.1 | 97485 | g2 | i0 | 26.6 | 1.27151561309977 | 542 | 320 | 55.6 | 20 | 153 | 1613 | 1537 | 2055 | KAL1508137.1 hypothetical protein AB1Y20_007724 [Prymnesium parvum] | diamond | 3339 | 130 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28076735 | 28076735 | PRJNA1010662_P_NODE_12545_length_169_cov_0.866667_g12486_i0 | PRJNA1010662 | 12545 | 169 | 0.866667 | 1.46466723 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 63.2 | 8.66e-10 | NR | KAJ1640261.1 | 483367 | g12486 | i0 | 48.2 | 0.994082840236686 | 56 | 29 | 99.4 | 0 | 168 | 1 | 698 | 753 | KAJ1640261.1 RNA polymerase II core subunit [Pavlovales sp. CCMP2436] | diamond | 168 | 63.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 28613600 | 28613600 | PRJNA1010662_P_NODE_16087_length_163_cov_0.912281_g16028_i0 | PRJNA1010662 | 16087 | 163 | 0.912281 | 1.48701803 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 62 | 1.08e-9 | NR | KAL1514503.1 | 97485 | g16028 | i0 | 67.3 | 1.93251533742331 | 52 | 16 | 95.7 | 1 | 161 | 6 | 66 | 116 | KAL1514503.1 hypothetical protein AB1Y20_003602 [Prymnesium parvum] | diamond | 315 | 62 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28866149 | 28866149 | PRJNA1010662_P_NODE_10488_length_181_cov_1.386364_g10429_i0 | PRJNA1010662 | 10488 | 181 | 1.386364 | 2.50931884 | Prymnesium sp. | 2812485 | Haptophyta | other_Eukaryota | 58.9 | 3.03e-8 | NR | KAL3919638.1 | 2812485 | g10429 | i0 | 48.3 | 0.961325966850829 | 58 | 30 | 96.1 | 0 | 180 | 7 | 99 | 156 | KAL3919638.1 MAG: hypothetical protein SGPRY_005560 [Prymnesium sp.] | diamond | 174 | 58.9 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium sp. | |||
| 28985290 | 28985290 | PRJNA1010662_P_NODE_13788_length_167_cov_0.864407_g13729_i0 | PRJNA1010662 | 13788 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.6 | 1.68e-7 | NR | KAG8461092.1 | 2081491 | g13729 | i0 | 85.7 | 1.77844311377246 | 28 | 4 | 50.3 | 0 | 79 | 162 | 19 | 46 | KAG8461092.1 hypothetical protein KFE25_003661 [Diacronema lutheri] | diamond | 297 | 56.6 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 29182128 | 29182128 | PRJNA1010662_P_NODE_7289_length_208_cov_1.289308_g7230_i0 | PRJNA1010662 | 7289 | 208 | 1.289308 | 2.68176064 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 106 | 8.860000000000001e-27 | NR | KOO26602.1 | 1460289 | g7230 | i0 | 80.3 | 4.26923076923077 | 61 | 12 | 88 | 0 | 206 | 24 | 153 | 213 | KOO26602.1 60s ribosomal protein [Chrysochromulina tobinii] | diamond | 888 | 106 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29213759 | 29213759 | PRJNA1010662_P_NODE_5509_length_231_cov_1.137363_g5450_i0 | PRJNA1010662 | 5509 | 231 | 1.137363 | 2.62730853 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 45.1 | 0.00304 | NR | KAL1530625.1 | 97485 | g5450 | i0 | 39.7 | 0.753246753246753 | 58 | 27 | 75.3 | 2 | 32 | 205 | 12 | 61 | KAL1530625.1 hypothetical protein AB1Y20_001525 [Prymnesium parvum] | diamond | 174 | 45.1 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29591999 | 29591999 | PRJNA1010662_P_NODE_16230_length_163_cov_0.894737_g16171_i0 | PRJNA1010662 | 16230 | 163 | 0.894737 | 1.45842131 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 47 | 4.05e-4 | NR | KAL1507051.1 | 97485 | g16171 | i0 | 40.7 | 0.993865030674847 | 54 | 32 | 99.4 | 0 | 2 | 163 | 315 | 368 | KAL1507051.1 hypothetical protein AB1Y20_007913 [Prymnesium parvum] | diamond | 162 | 47 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 29939950 | 29939950 | PRJNA1010662_P_NODE_8311_length_198_cov_1.322148_g8252_i0 | PRJNA1010662 | 8311 | 198 | 1.322148 | 2.61785304 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 56.6 | 2.47e-7 | NR | XP_005794596.1 | 280463 | g8252 | i0 | 49.2 | 0.954545454545455 | 63 | 31 | 93.9 | 1 | 187 | 2 | 134 | 196 | XP_005794596.1 hypothetical protein EMIHUDRAFT_431974 [Emiliania huxleyi CCMP1516] | diamond | 189 | 56.6 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 30097618 | 30097618 | PRJNA1010662_P_NODE_6492_length_217_cov_1.178571_g6433_i0 | PRJNA1010662 | 6492 | 217 | 1.178571 | 2.55749907 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 51.2 | 2.79e-5 | NR | KAG8460151.1 | 2081491 | g6433 | i0 | 37.7 | 0.953917050691244 | 69 | 42 | 95.4 | 1 | 4 | 210 | 63 | 130 | KAG8460151.1 hypothetical protein KFE25_014296 [Diacronema lutheri] | diamond | 207 | 51.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri | ||
| 30216488 | 30216488 | PRJNA1010662_P_NODE_7652_length_204_cov_1.329032_g7593_i0 | PRJNA1010662 | 7652 | 204 | 1.329032 | 2.71122528 | root | 1 | Root_unresolved | Root_unresolved | 110 | 2.2e-26 | NR | XP_005779799.1 | 280463 | g7593 | i0 | 72.9 | 4.10294117647059 | 70 | 17 | 100 | 2 | 1 | 204 | 146 | 215 | XP_005779799.1 Adenylosuccinate synthase [Emiliania huxleyi CCMP1516] | diamond | 837 | 111 | 0.990990990990991 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 30697930 | 30697930 | PRJNA1010662_P_NODE_14314_length_166_cov_0.880342_g14255_i0 | PRJNA1010662 | 14314 | 166 | 0.880342 | 1.46136772 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 58.2 | 4.79e-8 | NR | XP_005762031.1 | 280463 | g14255 | i0 | 49 | 0.921686746987952 | 51 | 26 | 92.2 | 0 | 165 | 13 | 371 | 421 | XP_005762031.1 hypothetical protein EMIHUDRAFT_198139 [Emiliania huxleyi CCMP1516] | diamond | 153 | 58.2 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 31520032 | 31520032 | PRJNA1010662_P_NODE_9856_length_185_cov_2.213235_g9797_i0 | PRJNA1010662 | 9856 | 185 | 2.213235 | 4.09448475 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 76.3 | 2.63e-14 | NR | KAJ1626510.1 | 483367 | g9797 | i0 | 59 | 0.989189189189189 | 61 | 25 | 98.9 | 0 | 2 | 184 | 807 | 867 | KAJ1626510.1 hypothetical protein T492DRAFT_910036 [Pavlovales sp. CCMP2436] | diamond | 183 | 76.3 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 31702121 | 31702121 | PRJNA1010662_P_NODE_7197_length_209_cov_1.287500_g7138_i0 | PRJNA1010662 | 7197 | 209 | 1.2875 | 2.690875 | root | 1 | Root_unresolved | Root_unresolved | 96.3 | 9.45e-23 | NR | KAJ1633725.1 | 483367 | g7138 | i0 | 65.2 | 9.63157894736842 | 66 | 23 | 94.7 | 0 | 2 | 199 | 33 | 98 | KAJ1633725.1 adenylate kinase-domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 2013 | 96.7 | 0.995863495346432 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 31702123 | 31702123 | PRJNA1010662_P_NODE_9237_length_190_cov_1.255319_g9178_i0 | PRJNA1010662 | 9237 | 190 | 1.255319 | 2.3851061 | Prymnesiales | 73028 | Haptophyta | other_Eukaryota | 93.2 | 3.12e-20 | NR | KAL1511790.1 | 97485 | g9178 | i0 | 66.7 | 2.98421052631579 | 63 | 21 | 99.5 | 0 | 189 | 1 | 301 | 363 | KAL1511790.1 hypothetical protein AB1Y20_005076 [Prymnesium parvum] | diamond | 567 | 93.2 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 32089261 | 32089261 | PRJNA1010662_P_NODE_2298_length_336_cov_1.212544_g2239_i0 | PRJNA1010662 | 2298 | 336 | 1.212544 | 4.07414784 | Pavlovales sp. CCMP2436 | 483367 | Haptophyta | other_Eukaryota | 110 | 2.72e-28 | NR | KAJ1616433.1 | 483367 | g2239 | i0 | 53.2 | 1.95535714285714 | 109 | 50 | 97.3 | 1 | 327 | 1 | 1 | 108 | KAJ1616433.1 ribosomal protein L24e-domain-containing protein [Pavlovales sp. CCMP2436] | diamond | 657 | 110 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 32184299 | 32184299 | PRJNA1010662_P_NODE_6198_length_220_cov_2.877193_g6139_i0 | PRJNA1010662 | 6198 | 220 | 2.877193 | 6.3298246 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 88.6 | 2.06e-18 | NR | KOO22631.1 | 1460289 | g6139 | i0 | 60.3 | 2.98636363636364 | 73 | 29 | 99.5 | 0 | 2 | 220 | 2373 | 2445 | KOO22631.1 heat shock cognate 70 kda [Chrysochromulina tobinii] | diamond | 657 | 88.6 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 32311078 | 32311078 | PRJNA1010662_P_NODE_4399_length_253_cov_0.990196_g4340_i0 | PRJNA1010662 | 4399 | 253 | 0.990196 | 2.50519588 | Diacronema lutheri | 2081491 | Haptophyta | other_Eukaryota | 58.2 | 1.61e-7 | NR | KAG8457059.1 | 2081491 | g4340 | i0 | 50.8 | 0.74703557312253 | 63 | 30 | 73.5 | 1 | 7 | 192 | 1058 | 1120 | KAG8457059.1 hypothetical protein KFE25_004370 [Diacronema lutheri] | diamond | 189 | 58.2 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovaceae | Diacronema | Diacronema lutheri |
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);;