RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where bioproject = "PRJNA1108487" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 33 ✖

bioproject 1

  • PRJNA1108487 · 33 ✖

tax_kingdom 0

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
213430 213430 PRJNA1108487_P_NODE_6981_length_273_cov_1.560000_g6915_i0 PRJNA1108487 6981 273 1.56 4.2588 Prymnesium parvum 97485 Haptophyta other_Eukaryota 114 3.15e-29   NR KAL1515789.1 97485 g6915 i0 61.4 3.71428571428571 83 32 91.2 0 22 270 1 83 KAL1515789.1 hypothetical protein AB1Y20_002405 [Prymnesium parvum] diamond 1014 114 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
2764124 2764124 PRJNA1108487_P_NODE_11043_length_243_cov_0.917647_g10977_i0 PRJNA1108487 11043 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 118 3.78e-30   NR XP_005784162.1 280463 g10977 i0 74.4 3.87654320987654 78 20 96.3 0 8 241 143 220 XP_005784162.1 cysteine synthase [Emiliania huxleyi CCMP1516] diamond 942 118 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4848620 4848620 PRJNA1108487_P_NODE_4864_length_318_cov_5.444898_g4798_i0 PRJNA1108487 4864 318 5.444898 17.31477564 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 228 4.609999999999999e-55   NTclustered gi|551555569|ref|XM_005764902.1| 280463 g4798 i0 91.071 97.9528301886792 168 15 53 0 4 171 633 466 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 31149 228 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11223979 11223979 PRJNA1108487_P_NODE_1229_length_598_cov_2.883810_g1164_i0 PRJNA1108487 1229 598 2.88381 17.2451838 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 103 5.8e-22   NR KAL3925578.1 2812485 g1164 i0 56.4 1.39966555183946 94 41 47.2 0 596 315 381 474 KAL3925578.1 MAG: hypothetical protein SGPRY_003612 [Prymnesium sp.] diamond 837 103 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
21890279 21890279 PRJNA1108487_P_NODE_9598_length_248_cov_0.891429_g9532_i0 PRJNA1108487 9598 248 0.891429 2.21074392 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 81.3 1.12e-15   NR KAG8470448.1 2081491 g9532 i0 51.4 2.80645161290323 74 36 89.5 0 224 3 1660 1733 KAG8470448.1 hypothetical protein KFE25_008869 [Diacronema lutheri] diamond 696 81.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
23165778 23165778 PRJNA1108487_P_NODE_8019_length_257_cov_1.695652_g7953_i0 PRJNA1108487 8019 257 1.695652 4.35782564 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 154 6.23e-33   NTclustered gi|551561030|ref|XM_005767357.1| 280463 g7953 i0 81.152 1.94163424124514 191 36 74 0 20 210 1822 1632 Emiliania huxleyi CCMP1516 Adaptor protein 2 beta subunit 1 (AP2B1), partial mRNA blastn 499 154 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24439320 24439320 PRJNA1108487_P_NODE_2060_length_473_cov_20.102500_g1994_i0 PRJNA1108487 2060 473 20.1025 95.084825 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 150 4.74e-44   NR XP_005758635.1 280463 g1994 i0 86.4 0.513742071881607 81 11 51.4 0 426 184 3 83 XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516] diamond 243 150 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26655979 26655979 PRJNA1108487_P_NODE_8761_length_251_cov_2.629213_g8695_i0 PRJNA1108487 8761 251 2.629213 6.59932463 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 77.8 7.79e-15   NR XP_005761234.1 280463 g8695 i0 42.4 1.0996015936255 92 42 96.8 2 249 7 90 181 XP_005761234.1 hypothetical protein EMIHUDRAFT_217060 [Emiliania huxleyi CCMP1516] diamond 276 77.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26719164 26719164 PRJNA1108487_P_NODE_10801_length_244_cov_0.912281_g10735_i0 PRJNA1108487 10801 244 0.912281 2.22596564 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 45.1 0.00583   NR KAG8461088.1 2081491 g10735 i0 40 0.799180327868853 65 39 79.9 0 6 200 1789 1853 KAG8461088.1 hypothetical protein KFE25_003657 [Diacronema lutheri] diamond 195 45.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26719175 26719175 PRJNA1108487_P_NODE_9901_length_247_cov_0.896552_g9835_i0 PRJNA1108487 9901 247 0.896552 2.21448344 Prymnesium parvum 97485 Haptophyta other_Eukaryota 77.4 2.19e-16   NR KAL1510806.1 97485 g9835 i0 83.3 0.582995951417004 48 8 58.3 0 2 145 32 79 KAL1510806.1 hypothetical protein AB1Y20_007090 [Prymnesium parvum] diamond 144 77.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27004343 27004343 PRJNA1108487_P_NODE_11202_length_242_cov_0.923077_g11136_i0 PRJNA1108487 11202 242 0.923077 2.23384634 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 45.8 0.00137   NR XP_005793372.1 280463 g11136 i0 57.4 1.51239669421488 61 24 75.6 1 236 54 1 59 XP_005793372.1 hypothetical protein EMIHUDRAFT_125495, partial [Emiliania huxleyi CCMP1516] diamond 366 45.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27288972 27288972 PRJNA1108487_P_NODE_6003_length_291_cov_3.440367_g5937_i0 PRJNA1108487 6003 291 3.440367 10.01146797 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 50.8 1.11e-5   NR KAG8469222.1 2081491 g5937 i0 35.6 0.896907216494845 87 51 86.6 3 39 290 1 85 KAG8469222.1 hypothetical protein KFE25_007740 [Diacronema lutheri] diamond 261 50.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27352447 27352447 PRJNA1108487_P_NODE_3403_length_370_cov_3.400673_g3337_i0 PRJNA1108487 3403 370 3.400673 12.5824901 Prymnesium parvum 97485 Haptophyta other_Eukaryota 92.4 4.86e-19   NR KAL1521780.1 97485 g3337 i0 58.6 0.567567567567568 70 29 56.8 0 359 150 41 110 KAL1521780.1 hypothetical protein AB1Y20_021433 [Prymnesium parvum] diamond 210 92.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27352451 27352451 PRJNA1108487_P_NODE_8263_length_253_cov_1.733333_g8197_i0 PRJNA1108487 8263 253 1.733333 4.38533249 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 45.4 0.00438   NR XP_005788165.1 280463 g8197 i0 58.7 1.41106719367589 46 17 52.2 1 251 120 250 295 XP_005788165.1 hypothetical protein EMIHUDRAFT_227253 [Emiliania huxleyi CCMP1516] diamond 357 45.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27659460 27659460 PRJNA1108487_P_NODE_8284_length_253_cov_1.300000_g8218_i0 PRJNA1108487 8284 253 1.3 3.289 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 119 8.95e-30   NR ALD47974.1 2903 g8218 i0 65.8 8.11067193675889 76 26 90.1 0 253 26 369 444 ALD47974.1 adaptor protein complex 2 subunit mu [Emiliania huxleyi] diamond 2052 120 0.991666666666667 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27952176 27952176 PRJNA1108487_P_NODE_2105_length_468_cov_0.987342_g2039_i0 PRJNA1108487 2105 468 0.987342 4.62076056 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 62.4 6.26e-8   NR KOO31097.1 1460289 g2039 i0 26.9 1.68589743589744 119 84 76.3 2 375 19 1734 1849 KOO31097.1 hypothetical protein Ctob_013263 [Chrysochromulina tobinii] diamond 789 62.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28552191 28552191 PRJNA1108487_P_NODE_10487_length_245_cov_0.906977_g10421_i0 PRJNA1108487 10487 245 0.906977 2.22209365 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 73.2 7.22e-13   NR KOO34508.1 1460289 g10421 i0 47.9 1.7265306122449 71 37 86.9 0 244 32 129 199 KOO34508.1 formin-like protein 20-like protein, partial [Chrysochromulina tobinii] diamond 423 73.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28638233 28638233 PRJNA1108487_P_NODE_2927_length_396_cov_1.687307_g2861_i0 PRJNA1108487 2927 396 1.687307 6.68173572 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 224 4.18e-70   NR KAL1523363.1 97485 g2861 i0 77.1 5.84848484848485 131 30 99.2 0 395 3 65 195 KAL1523363.1 hypothetical protein AB1Y20_018307 [Prymnesium parvum] diamond 2316 226 0.991150442477876 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29278085 29278085 PRJNA1108487_P_NODE_8909_length_251_cov_0.876404_g8843_i0 PRJNA1108487 8909 251 0.876404 2.19977404 Prymnesium parvum 97485 Haptophyta other_Eukaryota 115 4.8e-28   NR KAL1527885.1 97485 g8843 i0 61.7 3.800796812749 81 31 96.8 0 248 6 163 243 KAL1527885.1 hypothetical protein AB1Y20_009261 [Prymnesium parvum] diamond 954 115 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29427153 29427153 PRJNA1108487_P_NODE_1389_length_567_cov_0.937247_g1324_i0 PRJNA1108487 1389 567 0.937247 5.31419049 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 62 1.76e-7   NR KAG8466299.1 2081491 g1324 i0 35.9 1.45502645502646 103 62 52.4 3 566 270 25 127 KAG8466299.1 hypothetical protein KFE25_002055 [Diacronema lutheri] diamond 825 62.4 0.993589743589744 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30004644 30004644 PRJNA1108487_P_NODE_9831_length_247_cov_0.896552_g9765_i0 PRJNA1108487 9831 247 0.896552 2.21448344 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 97.8 1.6400000000000002e-21   NR XP_005782225.1 280463 g9765 i0 60.5 1.96761133603239 81 31 98.4 1 4 246 556 635 XP_005782225.1 hypothetical protein EMIHUDRAFT_468499 [Emiliania huxleyi CCMP1516] diamond 486 97.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30122044 30122044 PRJNA1108487_P_NODE_6992_length_273_cov_1.335000_g6926_i0 PRJNA1108487 6992 273 1.335 3.64455 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 92.4 1.79e-19   NR KAL1495274.1 97485 g6926 i0 56.2 25.5494505494506 89 37 97.8 1 268 2 368 454 KAL1495274.1 hypothetical protein AB1Y20_017134 [Prymnesium parvum] diamond 6975 92.8 0.995689655172414 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30280598 30280598 PRJNA1108487_P_NODE_8652_length_252_cov_0.871508_g8586_i0 PRJNA1108487 8652 252 0.871508 2.19620016 root 1 Root_unresolved Root_unresolved 51.6 3.2e-5   NR KAL1523487.1 97485 g8586 i0 37.6 4.16666666666667 93 46 98.8 2 2 250 144 234 KAL1523487.1 hypothetical protein AB1Y20_018425 [Prymnesium parvum] diamond 1050 52 0.992307692307692 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30469951 30469951 PRJNA1108487_P_NODE_10453_length_245_cov_0.906977_g10387_i0 PRJNA1108487 10453 245 0.906977 2.22209365 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.5 3.48e-17   NR KAL1499735.1 97485 g10387 i0 50 1.92244897959184 76 38 93.1 0 241 14 1050 1125 KAL1499735.1 hypothetical protein AB1Y20_012422 [Prymnesium parvum] diamond 471 86.3 0.990730011587486 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30478574 30478574 PRJNA1108487_P_NODE_9473_length_249_cov_0.886364_g9407_i0 PRJNA1108487 9473 249 0.886364 2.20704636 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 46.6 0.00173   NR KAG8465884.1 2081491 g9407 i0 45 0.963855421686747 80 27 81.9 5 40 243 52 126 KAG8465884.1 hypothetical protein KFE25_005454 [Diacronema lutheri] diamond 240 46.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30912261 30912261 PRJNA1108487_P_NODE_5934_length_293_cov_1.418182_g5868_i0 PRJNA1108487 5934 293 1.418182 4.15527326 Diacronema 70451 Haptophyta other_Eukaryota 111 2.03e-28   NR KAJ1629879.1 483367 g5868 i0 62.9 1.98634812286689 97 35 98.3 1 289 2 81 177 KAJ1629879.1 hypothetical protein T492DRAFT_629254 [Pavlovales sp. CCMP2436] diamond 582 111 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31078927 31078927 PRJNA1108487_P_NODE_5515_length_303_cov_1.139130_g5449_i0 PRJNA1108487 5515 303 1.13913 3.4515639 Prymnesium parvum 97485 Haptophyta other_Eukaryota 52.8 2.38e-5   NR KAL1500592.1 97485 g5449 i0 31.2 0.920792079207921 93 58 91.1 2 26 301 1310 1397 KAL1500592.1 hypothetical protein AB1Y20_013245 [Prymnesium parvum] diamond 279 52.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31331607 31331607 PRJNA1108487_P_NODE_4576_length_326_cov_3.375494_g4510_i0 PRJNA1108487 4576 326 3.375494 11.00411044 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87 1.56e-19   NR XP_005782836.1 280463 g4510 i0 51 0.901840490797546 98 44 89.3 2 29 319 20 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 294 87 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31521596 31521596 PRJNA1108487_P_NODE_2336_length_444_cov_1.261456_g2270_i0 PRJNA1108487 2336 444 1.261456 5.60086464 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 62 6.07e-8   NR XP_005780827.1 280463 g2270 i0 34 0.952702702702703 141 79 89.2 5 49 444 31 166 XP_005780827.1 hypothetical protein EMIHUDRAFT_449972 [Emiliania huxleyi CCMP1516] diamond 423 62 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31553338 31553338 PRJNA1108487_P_NODE_4736_length_322_cov_1.546185_g4670_i0 PRJNA1108487 4736 322 1.546185 4.9787157 Prymnesium parvum 97485 Haptophyta other_Eukaryota 129 2.4199999999999998e-32   NR KAL1504879.1 97485 g4670 i0 69.4 2.01242236024845 108 30 98.8 2 320 3 203 309 KAL1504879.1 hypothetical protein AB1Y20_008649 [Prymnesium parvum] diamond 648 129 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31806131 31806131 PRJNA1108487_P_NODE_9937_length_247_cov_0.896552_g9871_i0 PRJNA1108487 9937 247 0.896552 2.21448344 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 90.9 4.58e-19   NR KOO26561.1 1460289 g9871 i0 56.8 0.898785425101215 74 32 89.9 0 247 26 921 994 KOO26561.1 serine threonine protein kinase [Chrysochromulina tobinii] diamond 222 90.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31837577 31837577 PRJNA1108487_P_NODE_1977_length_483_cov_2.470732_g1911_i0 PRJNA1108487 1977 483 2.470732 11.93363556 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 95.9 9.84e-20   NR KAJ1626398.1 483367 g1911 i0 42.1 1.19254658385093 107 55 62.7 2 7 309 277 382 KAJ1626398.1 hypothetical protein T492DRAFT_1032671 [Pavlovales sp. CCMP2436] diamond 576 95.9 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32217502 32217502 PRJNA1108487_P_NODE_8358_length_253_cov_0.866667_g8292_i0 PRJNA1108487 8358 253 0.866667 2.19266751 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 133 2.3e-36   NR KAJ1628597.1 483367 g8292 i0 77.4 12.9486166007905 84 19 99.6 0 1 252 48 131 KAJ1628597.1 cyclin-like protein [Pavlovales sp. CCMP2436] diamond 3276 133 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;