RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1215813" 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 · 18 ✖

bioproject 1

  • PRJNA1215813 · 18 ✖

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
9259665 9259665 PRJNA1215813_P_NODE_10828_length_248_cov_0.891429_g10748_i0 PRJNA1215813 10828 248 0.891429 2.21074392 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 182 2.74e-41   NTclustered gi|551557925|ref|XM_005765918.1| 280463 g10748 i0 82.547 12.5443548387097 212 31 84 5 38 246 1573 1781 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 3111 182 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
9259765 9259765 PRJNA1215813_P_NODE_6048_length_317_cov_1.278689_g5968_i0 PRJNA1215813 6048 317 1.278689 4.05344413 Prymnesium parvum 97485 Haptophyta other_Eukaryota 148 1.4799999999999996e-43   NR KAL1515397.1 97485 g5968 i0 81.8 1.68454258675079 88 16 83.3 0 264 1 3 90 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 534 148 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11810474 11810474 PRJNA1215813_P_NODE_6270_length_312_cov_1.167364_g6190_i0 PRJNA1215813 6270 312 1.167364 3.64217568 Prymnesium parvum 97485 Haptophyta other_Eukaryota 201 3.9800000000000005e-64   NR KAL1520798.1 97485 g6190 i0 91.3 7 104 9 100 0 1 312 12 115 KAL1520798.1 hypothetical protein AB1Y20_022362 [Prymnesium parvum] diamond 2184 201 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
18897343 18897343 PRJNA1215813_P_NODE_9375_length_253_cov_0.866667_g9295_i0 PRJNA1215813 9375 253 0.866667 2.19266751 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 89.8 1.75e-13   NTclustered gi|551557907|ref|XM_005765909.1| 280463 g9295 i0 81.651 1.98814229249012 109 18 43 2 107 214 600 707 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 503 89.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26819721 26819721 PRJNA1215813_P_NODE_5781_length_323_cov_1.872000_g5701_i0 PRJNA1215813 5781 323 1.872 6.04656 Prymnesium parvum 97485 Haptophyta other_Eukaryota 134 6.55e-34   NR KAL1511880.1 97485 g5701 i0 57.8 0.947368421052632 102 43 94.7 0 2 307 192 293 KAL1511880.1 hypothetical protein AB1Y20_005162 [Prymnesium parvum] diamond 306 134 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26819723 26819723 PRJNA1215813_P_NODE_8501_length_268_cov_1.076923_g8421_i0 PRJNA1215813 8501 268 1.076923 2.88615364 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 120 1.32e-30   NR KOO32302.1 1460289 g8421 i0 65.9 0.985074626865672 88 30 98.5 0 264 1 221 308 KOO32302.1 NAD-dependent epimerase dehydratase [Chrysochromulina tobinii] diamond 264 120 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27167356 27167356 PRJNA1215813_P_NODE_5682_length_326_cov_1.782609_g5602_i0 PRJNA1215813 5682 326 1.782609 5.81130534 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 42.4 0.0252   NR KAG8458938.1 2081491 g5602 i0 41.3 0.423312883435583 46 25 42.3 1 1 138 40 83 KAG8458938.1 hypothetical protein KFE25_004272 [Diacronema lutheri] diamond 138 42.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27281253 27281253 PRJNA1215813_P_NODE_12243_length_243_cov_0.917647_g12163_i0 PRJNA1215813 12243 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 56.2 6.65e-7   NR KOO34341.1 1460289 g12163 i0 40 1.8641975308642 80 43 95.1 2 231 1 123 200 KOO34341.1 histone deacetylase [Chrysochromulina tobinii] diamond 453 56.6 0.992932862190813 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27609867 27609867 PRJNA1215813_P_NODE_3104_length_429_cov_10.786517_g3024_i0 PRJNA1215813 3104 429 10.786517 46.27415793 Prymnesium parvum 97485 Haptophyta other_Eukaryota 107 1.05e-26   NR KAL1515331.1 97485 g3024 i0 44.8 1.86713286713287 134 59 86.7 2 10 381 4 132 KAL1515331.1 hypothetical protein AB1Y20_001962 [Prymnesium parvum] diamond 801 107 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28209511 28209511 PRJNA1215813_P_NODE_11606_length_245_cov_0.906977_g11526_i0 PRJNA1215813 11606 245 0.906977 2.22209365 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 98.2 4.63e-23   NR KAL3893671.1 2812485 g11526 i0 60 0.918367346938776 75 30 91.8 0 16 240 42 116 KAL3893671.1 MAG: hypothetical protein SGPRY_014071 [Prymnesium sp.] diamond 225 98.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
29144442 29144442 PRJNA1215813_P_NODE_8789_length_262_cov_1.650794_g8709_i0 PRJNA1215813 8789 262 1.650794 4.32508028 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 67.4 2.92e-12   NR XP_005767460.1 280463 g8709 i0 69.8 1.03053435114504 43 13 49.2 0 129 1 2 44 XP_005767460.1 RAN, ras superfamily GTPase, partial [Emiliania huxleyi CCMP1516] diamond 270 67.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30009666 30009666 PRJNA1215813_P_NODE_2951_length_440_cov_2.125341_g2871_i0 PRJNA1215813 2951 440 2.125341 9.3515004 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 48.5 7.51e-4   NR XP_005767793.1 280463 g2871 i0 45 1.81363636363636 60 33 40.9 0 186 7 83 142 XP_005767793.1 hypothetical protein EMIHUDRAFT_356471, partial [Emiliania huxleyi CCMP1516] diamond 798 48.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30389067 30389067 PRJNA1215813_P_NODE_4833_length_349_cov_1.731884_g4753_i0 PRJNA1215813 4833 349 1.731884 6.04427516 Prymnesium parvum 97485 Haptophyta other_Eukaryota 61.6 6.88e-9   NR KAL1524604.1 97485 g4753 i0 48.3 1.02292263610315 58 28 49.9 1 347 174 112 167 KAL1524604.1 hypothetical protein AB1Y20_019493 [Prymnesium parvum] diamond 357 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30736130 30736130 PRJNA1215813_P_NODE_1594_length_588_cov_1.846602_g1517_i0 PRJNA1215813 1594 588 1.846602 10.85801976 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 168 3.939999999999999e-48   NR KOO25738.1 1460289 g1517 i0 45.5 0.954081632653061 187 97 93.4 3 1 549 92 277 KOO25738.1 lipase family protein [Chrysochromulina tobinii] diamond 561 168 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31071083 31071083 PRJNA1215813_P_NODE_2075_length_515_cov_2.402715_g1995_i0 PRJNA1215813 2075 515 2.402715 12.37398225 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 279 4.92e-91   NR KAL1523363.1 97485 g1995 i0 76 2.98834951456311 171 41 99.6 0 2 514 189 359 KAL1523363.1 hypothetical protein AB1Y20_018307 [Prymnesium parvum] diamond 1539 279 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31450464 31450464 PRJNA1215813_P_NODE_7616_length_285_cov_1.103774_g7536_i0 PRJNA1215813 7616 285 1.103774 3.1457559 Diacronema 70451 Haptophyta other_Eukaryota 76.3 9.98e-14   NR KAJ1633252.1 483367 g7536 i0 47.4 2.02105263157895 97 45 100 2 1 285 271 363 KAJ1633252.1 lung seven transmembrane receptor-domain-containing protein [Pavlovales sp. CCMP2436] diamond 576 76.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32254383 32254383 PRJNA1215813_P_NODE_10218_length_250_cov_0.881356_g10138_i0 PRJNA1215813 10218 250 0.881356 2.20339 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 109 6.76e-26   NR KAG8457502.1 2081491 g10138 i0 67.5 1.92 80 18 96 1 250 11 428 499 KAG8457502.1 hypothetical protein KFE25_004138 [Diacronema lutheri] diamond 480 109 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32349223 32349223 PRJNA1215813_P_NODE_879_length_755_cov_1.343109_g810_i0 PRJNA1215813 879 755 1.343109 10.14047295 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 110 5.63e-25   NR KAG8458861.1 2081491 g810 i0 36.1 0.826490066225166 208 122 81.5 5 647 33 24 223 KAG8458861.1 hypothetical protein KFE25_004195 [Diacronema lutheri] diamond 624 110 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri

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