RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA700095" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 30 ✖

bioproject 1

  • PRJNA700095 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
683126 683126 PRJNA700095_P_NODE_11361_length_571_cov_1.156627_g10119_i0 PRJNA700095 11361 571 1.156627 6.60434017 Prymnesium parvum 97485 Haptophyta other_Eukaryota 103 1.5100000000000001e-22   NR KAL1508619.1 97485 g10119 i0 41.6 0.656742556917688 125 70 64.6 3 391 23 1 124 KAL1508619.1 hypothetical protein AB1Y20_004716 [Prymnesium parvum] diamond 375 103 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
683202 683202 PRJNA700095_P_NODE_33861_length_293_cov_2.186364_g32597_i0 PRJNA700095 33861 293 2.186364 6.40604652 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 106 3.1899999999999998e-24   NR XP_005774035.1 280463 g32597 i0 62.8 0.880546075085324 86 32 88.1 0 287 30 603 688 XP_005774035.1 threonine-tRNA ligase, partial [Emiliania huxleyi CCMP1516] diamond 258 106 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23636060 23636060 PRJNA700095_P_NODE_28479_length_319_cov_1.548780_g27215_i0 PRJNA700095 28479 319 1.54878 4.9406082 Prymnesium parvum 97485 Haptophyta other_Eukaryota 134 4.9e-37   NR KAL1523812.1 97485 g27215 i0 76.1 2.62382445141066 71 17 66.8 0 2 214 109 179 KAL1523812.1 hypothetical protein AB1Y20_018734 [Prymnesium parvum] diamond 837 134 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26766265 26766265 PRJNA700095_P_NODE_27241_length_327_cov_1.988189_g25977_i0 PRJNA700095 27241 327 1.988189 6.50137803 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 77.8 1.56e-14   NR XP_005772138.1 280463 g25977 i0 40.8 0.89908256880733906 98 45 82.6 3 325 56 114 206 XP_005772138.1 hypothetical protein EMIHUDRAFT_242685 [Emiliania huxleyi CCMP1516] diamond 294 77.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26809224 26809224 PRJNA700095_P_NODE_29321_length_314_cov_1.294606_g28057_i0 PRJNA700095 29321 314 1.294606 4.06506284 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 54.7 4.97e-6   NR KAJ1618402.1 483367 g28057 i0 68.3 1.28980891719745 41 13 39.2 0 190 312 31 71 KAJ1618402.1 ornithine cyclodeaminase [Pavlovales sp. CCMP2436] diamond 405 54.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
26998883 26998883 PRJNA700095_P_NODE_16882_length_441_cov_1.847826_g15619_i0 PRJNA700095 16882 441 1.847826 8.14891266 root 1 Root_unresolved Root_unresolved 95.5 3.6e-21   NR XP_005772072.1 280463 g15619 i0 36.6 3.89795918367347 142 85 93.2 1 438 28 69 210 XP_005772072.1 hypothetical protein EMIHUDRAFT_458706 [Emiliania huxleyi CCMP1516] diamond 1719 95.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27304116 27304116 PRJNA700095_P_NODE_21663_length_376_cov_1.597360_g20399_i0 PRJNA700095 21663 376 1.59736 6.0060736 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 58.2 6.07e-7   NR XP_005768030.1 280463 g20399 i0 34.1 0.981382978723404 123 56 97.3 5 366 1 25 123 XP_005768030.1 hypothetical protein EMIHUDRAFT_414255 [Emiliania huxleyi CCMP1516] diamond 369 58.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27430646 27430646 PRJNA700095_P_NODE_59223_length_245_cov_0.895349_g57959_i0 PRJNA700095 59223 245 0.895349 2.19360505 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 46.2 0.00227   NR XP_005792637.1 280463 g57959 i0 37.5 0.979591836734694 80 35 79.6 3 29 223 399 478 XP_005792637.1 hypothetical protein EMIHUDRAFT_466594 [Emiliania huxleyi CCMP1516] diamond 240 46.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27473164 27473164 PRJNA700095_P_NODE_40643_length_274_cov_1.532338_g39379_i0 PRJNA700095 40643 274 1.532338 4.19860612 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 117 4.12e-28   NR KOO29726.1 1460289 g39379 i0 62.9 1.95985401459854 89 33 97.4 0 272 6 344 432 KOO29726.1 nfx1-type zinc finger-containing protein 1 [Chrysochromulina tobinii] diamond 537 118 0.991525423728814 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27714976 27714976 PRJNA700095_P_NODE_26604_length_332_cov_1.042471_g25340_i0 PRJNA700095 26604 332 1.042471 3.46100372 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 66.2 6.15e-10   NR KAG8461087.1 2081491 g25340 i0 45.6 1.20180722891566 68 35 59.6 1 134 331 16 83 KAG8461087.1 hypothetical protein KFE25_003656 [Diacronema lutheri] diamond 399 66.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28072963 28072963 PRJNA700095_P_NODE_16045_length_457_cov_2.158854_g14782_i0 PRJNA700095 16045 457 2.158854 9.86596278 root 1 Root_unresolved Root_unresolved 192 1.2699999999999995e-55   NR KAL1507780.1 97485 g14782 i0 57.7 7.0109409190372 156 61 99.8 2 1 456 203 357 KAL1507780.1 hypothetical protein AB1Y20_007390 [Prymnesium parvum] diamond 3204 192 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28472467 28472467 PRJNA700095_P_NODE_34566_length_290_cov_3.105991_g33302_i0 PRJNA700095 34566 290 3.105991 9.0073739 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 48.5 2.23e-4   NR XP_005793372.1 280463 g33302 i0 57.4 1.26206896551724 61 24 63.1 1 241 59 1 59 XP_005793372.1 hypothetical protein EMIHUDRAFT_125495, partial [Emiliania huxleyi CCMP1516] diamond 366 48.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28503894 28503894 PRJNA700095_P_NODE_17947_length_424_cov_1.490028_g16684_i0 PRJNA700095 17947 424 1.490028 6.31771872 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 135 3.23e-34   NR KOO23927.1 1460289 g16684 i0 50.7 2.06603773584906 146 55 99.8 4 1 423 288 421 KOO23927.1 aspartyl aminopeptidase [Chrysochromulina tobinii] diamond 876 135 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29356498 29356498 PRJNA700095_P_NODE_68629_length_229_cov_2.839744_g67364_i0 PRJNA700095 68629 229 2.839744 6.50301376 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 68.2 3.14e-11   NR XP_005793475.1 280463 g67364 i0 44.1 2.47598253275109 68 38 89.1 0 16 219 209 276 XP_005793475.1 hypothetical protein EMIHUDRAFT_222110 [Emiliania huxleyi CCMP1516] diamond 567 68.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29545721 29545721 PRJNA700095_P_NODE_9050_length_653_cov_2.522414_g7846_i0 PRJNA700095 9050 653 2.522414 16.47136342 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 183 2.23e-51   NR XP_005762649.1 280463 g7846 i0 51.6 0.845329249617152 184 84 82.2 3 539 3 33 216 XP_005762649.1 hypothetical protein EMIHUDRAFT_215890 [Emiliania huxleyi CCMP1516] diamond 552 183 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29577179 29577179 PRJNA700095_P_NODE_46670_length_260_cov_1.636364_g45406_i0 PRJNA700095 46670 260 1.636364 4.2545464 Prymnesium parvum 97485 Haptophyta other_Eukaryota 58.9 8.36e-8   NR KAL1503914.1 97485 g45406 i0 43.9 1.41923076923077 66 37 76.2 0 200 3 21 86 KAL1503914.1 hypothetical protein AB1Y20_012375 [Prymnesium parvum] diamond 369 58.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29608622 29608622 PRJNA700095_P_NODE_29610_length_312_cov_1.882845_g28346_i0 PRJNA700095 29610 312 1.882845 5.8744764 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 48.1 0.00104   NR XP_005780827.1 280463 g28346 i0 31.7 1.88461538461538 101 59 94.2 4 301 8 104 197 XP_005780827.1 hypothetical protein EMIHUDRAFT_449972 [Emiliania huxleyi CCMP1516] diamond 588 48.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30093727 30093727 PRJNA700095_P_NODE_11692_length_561_cov_4.088115_g10447_i0 PRJNA700095 11692 561 4.088115 22.93432515 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 180 5.350000000000001e-50   NR KOO24782.1 1460289 g10447 i0 57.1 1.66310160427807 156 63 83.4 2 1 468 443 594 KOO24782.1 tripeptidyl peptidase i [Chrysochromulina tobinii] diamond 933 181 0.994475138121547 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30399203 30399203 PRJNA700095_P_NODE_4633_length_917_cov_2.627962_g3689_i0 PRJNA700095 4633 917 2.627962 24.09841154 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 308 4.569999999999999e-101   NR KOO33292.1 1460289 g3689 i0 47.3 0.974918211559433 298 154 96.5 2 23 907 10 307 KOO33292.1 hypothetical protein Ctob_007771 [Chrysochromulina tobinii] diamond 894 308 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30399207 30399207 PRJNA700095_P_NODE_55693_length_247_cov_3.988506_g54429_i0 PRJNA700095 55693 247 3.988506 9.85160982 Prymnesium parvum 97485 Haptophyta other_Eukaryota 44.7 0.00831   NR KAL1498707.1 97485 g54429 i0 67.7 0.376518218623482 31 10 37.7 0 155 247 25 55 KAL1498707.1 hypothetical protein AB1Y20_014018 [Prymnesium parvum] diamond 93 44.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31104846 31104846 PRJNA700095_P_NODE_11075_length_580_cov_1.662722_g9834_i0 PRJNA700095 11075 580 1.662722 9.6437876 root 1 Root_unresolved Root_unresolved 175 1.38e-50   NR KAL1500405.1 97485 g9834 i0 53.4 1.74827586206897 176 76 91 3 528 1 34 203 KAL1500405.1 hypothetical protein AB1Y20_013062 [Prymnesium parvum] diamond 1014 176 0.994318181818182 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31156634 31156634 PRJNA700095_P_NODE_11175_length_577_cov_2.176587_g9933_i0 PRJNA700095 11175 577 2.176587 12.55890699 Prymnesium parvum 97485 Haptophyta other_Eukaryota 69.3 4.37e-11   NR KAL1524702.1 97485 g9933 i0 34.1 2.07972270363951 126 74 63.4 4 201 566 27 147 KAL1524702.1 hypothetical protein AB1Y20_019587 [Prymnesium parvum] diamond 1200 69.7 0.994261119081779 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31505024 31505024 PRJNA700095_P_NODE_20616_length_388_cov_1.431746_g19353_i0 PRJNA700095 20616 388 1.431746 5.55517448 Prymnesium parvum 97485 Haptophyta other_Eukaryota 63.2 1.23e-8   NR KAL1515046.1 97485 g19353 i0 39.5 1.26030927835052 86 41 63.4 3 279 34 35 113 KAL1515046.1 hypothetical protein AB1Y20_004111 [Prymnesium parvum] diamond 489 63.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31863812 31863812 PRJNA700095_P_NODE_22297_length_369_cov_1.692568_g21033_i0 PRJNA700095 22297 369 1.692568 6.24557592 root 1 Root_unresolved Root_unresolved 55.8 4.03e-6   NR XP_005756303.1 280463 g21033 i0 41.4 2.56910569105691 70 39 56.9 1 26 235 877 944 XP_005756303.1 hypothetical protein EMIHUDRAFT_439327 [Emiliania huxleyi CCMP1516] diamond 948 55.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31916047 31916047 PRJNA700095_P_NODE_54337_length_248_cov_3.268571_g53073_i0 PRJNA700095 54337 248 3.268571 8.10605608 Prymnesium parvum 97485 Haptophyta other_Eukaryota 100 2.58e-23   NR KAL1515278.1 97485 g53073 i0 62.2 3.94354838709677 82 31 99.2 0 246 1 135 216 KAL1515278.1 hypothetical protein AB1Y20_001910 [Prymnesium parvum] diamond 978 100 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32148825 32148825 PRJNA700095_P_NODE_18898_length_410_cov_0.839763_g17635_i0 PRJNA700095 18898 410 0.839763 3.4430283 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 91.7 7.76e-19   NR AAW79315.1 37099 g17635 i0 72.5 4.10487804878049 51 14 37.3 0 3 155 317 367 AAW79315.1 chloroplast ferredoxin NADP(+) reductase, partial [Isochrysis galbana] diamond 1683 92 0.996739130434783 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana
32296137 32296137 PRJNA700095_P_NODE_4099_length_974_cov_2.203108_g3208_i0 PRJNA700095 4099 974 2.203108 21.45827192 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 107 9.88e-22   NR XP_005765871.1 280463 g3208 i0 29.5 0.865503080082136 281 171 80.4 10 939 157 547 820 XP_005765871.1 hypothetical protein EMIHUDRAFT_212500 [Emiliania huxleyi CCMP1516] diamond 843 107 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32549103 32549103 PRJNA700095_P_NODE_13879_length_503_cov_1.818605_g12620_i0 PRJNA700095 13879 503 1.818605 9.1475831500000009 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 118 1.7000000000000002e-27   NR KAL3921422.1 2812485 g12620 i0 43.6 0.930417495029821 156 84 90.7 4 501 46 166 321 KAL3921422.1 MAG: hypothetical protein SGPRY_004910, partial [Prymnesium sp.] diamond 468 118 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32800703 32800703 PRJNA700095_P_NODE_26840_length_330_cov_1.599222_g25576_i0 PRJNA700095 26840 330 1.599222 5.2774326 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 102 9.97e-24   NR XP_005772138.1 280463 g25576 i0 47.9 1.7 94 46 85.5 1 328 47 80 170 XP_005772138.1 hypothetical protein EMIHUDRAFT_242685 [Emiliania huxleyi CCMP1516] diamond 561 102 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32895180 32895180 PRJNA700095_P_NODE_35920_length_286_cov_3.248826_g34656_i0 PRJNA700095 35920 286 3.248826 9.29164236 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 78.6 6.97e-15   NR KOO22165.1 1460289 g34656 i0 57.5 1.6048951048951 73 29 76.6 1 221 3 14 84 KOO22165.1 mitochondrial 2-oxoglutarate malate carrier [Chrysochromulina tobinii] diamond 459 78.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii

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