RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA688931", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 27 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 27 ✖

bioproject 1

  • PRJNA688931 · 27 ✖

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
668477 668477 PRJNA688931_P_NODE_24661_length_206_cov_1.254777_g24448_i0 PRJNA688931 24661 206 1.254777 2.58484062 Meringosphaera mediterranea 2837474 Root_unresolved Root_unresolved 128 2.91e-25   NTclustered gi|2526806211|gb|OR195157.1| 2837474 g24448 i0 85.156 44.6067961165049 128 16 62 3 6 132 2814 2939 Meringosphaera mediterranea isolate S7 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 9189 128 1 Eukaryota Haptista     Centroplasthelida     Meringosphaera Meringosphaera mediterranea
9596997 9596997 PRJNA688931_P_NODE_22028_length_218_cov_1.230769_g21815_i0 PRJNA688931 22028 218 1.230769 2.68307642 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 2.25e-29   NR KAJ1628737.1 483367 g21815 i0 70.8 18.8256880733945 72 21 99.1 0 1 216 72 143 KAJ1628737.1 ribosomal protein S2, flavodoxin-like domain-containing protein [Pavlovales sp. CCMP2436] diamond 4104 114 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
17755912 17755912 PRJNA688931_P_NODE_15994_length_257_cov_1.899038_g15781_i0 PRJNA688931 15994 257 1.899038 4.88052766 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 62.1 3.88e-5   NTclustered gi|551611011|ref|XM_005786544.1| 280463 g15781 i0 92.857 1.91439688715953 42 3 16 0 36 77 772 813 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 492 62.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
21580279 21580279 PRJNA688931_P_NODE_35797_length_168_cov_1.294118_g35584_i0 PRJNA688931 35797 168 1.294118 2.17411824 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.5 4.48e-7   NR KAL1521362.1 97485 g35584 i0 48.1 4.98214285714286 54 28 96.4 0 168 7 466 519 KAL1521362.1 hypothetical protein AB1Y20_021029 [Prymnesium parvum] diamond 837 55.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
22345779 22345779 PRJNA688931_P_NODE_17658_length_244_cov_1.682051_g17445_i0 PRJNA688931 17658 244 1.682051 4.10420444 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 121 2.6699999999999997e-30   NR KAL1504882.1 97485 g17445 i0 67.9 1.95491803278689 78 25 95.9 0 11 244 291 368 KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum] diamond 477 121 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
24894604 24894604 PRJNA688931_P_NODE_17760_length_243_cov_3.190722_g17547_i0 PRJNA688931 17760 243 3.190722 7.75345446 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 132 2.7300000000000003e-26   NTclustered gi|194146310|gb|EU616277.1| 171259 g17547 i0 86.066 62.59670781893 122 17 50 0 1 122 712 591 Uncultured haptophyte clone M18_59_165 28S ribosomal RNA gene, partial sequence blastn 15211 132 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
24894662 24894662 PRJNA688931_P_NODE_2480_length_725_cov_1.877219_g2309_i0 PRJNA688931 2480 725 1.877219 13.60983775 Haptophyta 2830 Haptophyta other_Eukaryota 208 2.14e-61   NR KAJ1630788.1 483367 g2309 i0 45.6 5.87586206896552 237 129 98.1 0 8 718 31 267 KAJ1630788.1 hypothetical protein T492DRAFT_1000960 [Pavlovales sp. CCMP2436] diamond 4260 209 0.995215311004785 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
26765814 26765814 PRJNA688931_P_NODE_20801_length_224_cov_1.880000_g20588_i0 PRJNA688931 20801 224 1.88 4.2112 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 66.2 1.02e-10   NR KOO23382.1 1460289 g20588 i0 50 0.696428571428571 52 26 69.6 0 64 219 113 164 KOO23382.1 dhhc zinc finger domain-containing protein [Chrysochromulina tobinii] diamond 156 66.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27050741 27050741 PRJNA688931_P_NODE_14762_length_269_cov_1.409091_g14549_i0 PRJNA688931 14762 269 1.409091 3.79045479 Prymnesium parvum 97485 Haptophyta other_Eukaryota 52 2.75e-5   NR KAL1525251.1 97485 g14549 i0 39.4 1.47211895910781 66 38 73.6 1 265 68 402 465 KAL1525251.1 hypothetical protein AB1Y20_020116 [Prymnesium parvum] diamond 396 52 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27176914 27176914 PRJNA688931_P_NODE_17102_length_248_cov_1.728643_g16889_i0 PRJNA688931 17102 248 1.728643 4.28703464 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 82.8 3.16e-16   NR KOO23673.1 1460289 g16889 i0 54.5 0.931451612903226 77 33 93.1 1 16 246 191 265 KOO23673.1 calcium-transporting ATPase endoplasmic reticulum-type-like protein [Chrysochromulina tobinii] diamond 231 82.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27378546 27378546 PRJNA688931_P_NODE_24583_length_206_cov_1.484076_g24370_i0 PRJNA688931 24583 206 1.484076 3.05719656 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 84 1.06e-17   NR KAG8461664.1 2081491 g24370 i0 58.5 2.83980582524272 65 27 94.7 0 11 205 62 126 KAG8461664.1 hypothetical protein KFE25_001282 [Diacronema lutheri] diamond 585 84 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28282199 28282199 PRJNA688931_P_NODE_17706_length_244_cov_1.071795_g17493_i0 PRJNA688931 17706 244 1.071795 2.6151798 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 53.1 8.22e-6   NR XP_005792585.1 280463 g17493 i0 38 2.45901639344262 71 44 87.3 0 13 225 513 583 XP_005792585.1 hypothetical protein EMIHUDRAFT_223025 [Emiliania huxleyi CCMP1516] diamond 600 53.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28535239 28535239 PRJNA688931_P_NODE_34747_length_170_cov_1.280992_g34534_i0 PRJNA688931 34747 170 1.280992 2.1776864 Prymnesium parvum 97485 Haptophyta other_Eukaryota 102 6.71e-27   NR KAL1518757.1 97485 g34534 i0 78.6 1.97647058823529 56 12 98.8 0 3 170 25 80 KAL1518757.1 hypothetical protein AB1Y20_003041 [Prymnesium parvum] diamond 336 102 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29071934 29071934 PRJNA688931_P_NODE_10068_length_333_cov_2.165493_g9855_i0 PRJNA688931 10068 333 2.165493 7.21109169 Prymnesium parvum 97485 Haptophyta other_Eukaryota 117 7.25e-31   NR KAL1522537.1 97485 g9855 i0 55.1 1.92792792792793 107 48 96.4 0 321 1 7 113 KAL1522537.1 hypothetical protein AB1Y20_017524 [Prymnesium parvum] diamond 642 117 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29135204 29135204 PRJNA688931_P_NODE_33629_length_173_cov_1.911290_g33416_i0 PRJNA688931 33629 173 1.91129 3.3065317 Prymnesium parvum 97485 Haptophyta other_Eukaryota 71.2 1.8e-13   NR KAL1526551.1 97485 g33416 i0 66.1 0.971098265895954 56 18 97.1 1 2 169 71 125 KAL1526551.1 hypothetical protein AB1Y20_015259 [Prymnesium parvum] diamond 168 71.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29987554 29987554 PRJNA688931_P_NODE_26451_length_198_cov_1.838926_g26238_i0 PRJNA688931 26451 198 1.838926 3.64107348 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 48.1 2.44e-4   NR XP_005784182.1 280463 g26238 i0 40 0.757575757575758 50 29 74.2 1 50 196 92 141 XP_005784182.1 hypothetical protein EMIHUDRAFT_112576 [Emiliania huxleyi CCMP1516] diamond 150 48.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30240292 30240292 PRJNA688931_P_NODE_11592_length_308_cov_1.517375_g11379_i0 PRJNA688931 11592 308 1.517375 4.673515 Prymnesium parvum 97485 Haptophyta other_Eukaryota 114 3.28e-27   NR KAL1504395.1 97485 g11379 i0 58.9 2.81493506493507 90 37 87.7 0 2 271 29 118 KAL1504395.1 hypothetical protein AB1Y20_010801 [Prymnesium parvum] diamond 867 114 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30840637 30840637 PRJNA688931_P_NODE_28034_length_192_cov_1.454545_g27821_i0 PRJNA688931 28034 192 1.454545 2.7927264 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 53.5 3.01e-6   NR KAL3926675.1 2812485 g27821 i0 48.2 4.3125 56 26 87.5 2 1 168 156 208 KAL3926675.1 MAG: hypothetical protein SGPRY_003192 [Prymnesium sp.] diamond 828 53.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30903850 30903850 PRJNA688931_P_NODE_14614_length_270_cov_1.837104_g14401_i0 PRJNA688931 14614 270 1.837104 4.9601808 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 47 0.00172   NR KAL3921810.1 2812485 g14401 i0 35.6 0.811111111111111 73 45 80 2 240 25 50 121 KAL3921810.1 MAG: hypothetical protein SGPRY_004774 [Prymnesium sp.] diamond 219 47 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30998655 30998655 PRJNA688931_P_NODE_44314_length_158_cov_2.669725_g44101_i0 PRJNA688931 44314 158 2.669725 4.2181655 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87.8 2.06e-20   NR XP_005788988.1 280463 g44101 i0 76 6.64556962025316 50 12 94.9 0 5 154 99 148 XP_005788988.1 putative mago nashi [Emiliania huxleyi CCMP1516] diamond 1050 87.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31124563 31124563 PRJNA688931_P_NODE_26055_length_200_cov_1.350993_g25842_i0 PRJNA688931 26055 200 1.350993 2.701986 Prymnesium parvum 97485 Haptophyta other_Eukaryota 68.9 9.89e-12   NR KAL1495320.1 97485 g25842 i0 61.5 1.59 52 20 78 0 2 157 224 275 KAL1495320.1 hypothetical protein AB1Y20_017177 [Prymnesium parvum] diamond 318 68.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31389573 31389573 PRJNA688931_P_NODE_11896_length_303_cov_1.614173_g11683_i0 PRJNA688931 11896 303 1.614173 4.89094419 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 92.4 4.94e-20   NR KOO24708.1 1460289 g11683 i0 57.7 7.23762376237624 71 30 70.3 0 15 227 230 300 KOO24708.1 vacuolar protein sorting-associated protein 26 [Chrysochromulina tobinii] diamond 2193 92.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31673969 31673969 PRJNA688931_P_NODE_7297_length_402_cov_5.994334_g7084_i0 PRJNA688931 7297 402 5.994334 24.09722268 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 80.5 2.49e-16   NR KAL1510948.1 97485 g7084 i0 45.1 3.02985074626866 102 44 74.6 2 73 372 45 136 KAL1510948.1 hypothetical protein AB1Y20_005775 [Prymnesium parvum] diamond 1218 80.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32168966 32168966 PRJNA688931_P_NODE_22438_length_216_cov_1.359281_g22225_i0 PRJNA688931 22438 216 1.359281 2.93604696 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 110 2.1600000000000003e-27   NR KOO20888.1 1460289 g22225 i0 70 1.94444444444444 70 21 97.2 0 3 212 139 208 KOO20888.1 60s ribosomal protein l5-a [Chrysochromulina tobinii] diamond 420 110 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32358908 32358908 PRJNA688931_P_NODE_8459_length_369_cov_1.396875_g8246_i0 PRJNA688931 8459 369 1.396875 5.15446875 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 123 9.889999999999999e-30   NR KOO24983.1 1460289 g8246 i0 54.9 2.07317073170732 122 52 96.7 2 358 2 97 218 KOO24983.1 threonyl-tRNA synthetase [Chrysochromulina tobinii] diamond 765 123 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32611520 32611520 PRJNA688931_P_NODE_33100_length_175_cov_1.357143_g32887_i0 PRJNA688931 33100 175 1.357143 2.37500025 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 86.3 6.95e-18   NR KAG8457743.1 2081491 g32887 i0 78 1.01142857142857 59 12 99.4 1 1 174 180 238 KAG8457743.1 hypothetical protein KFE25_005756, partial [Diacronema lutheri] diamond 177 86.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32906252 32906252 PRJNA688931_P_NODE_13520_length_282_cov_1.772532_g13307_i0 PRJNA688931 13520 282 1.772532 4.99854024 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 45.1 0.0091   NR KAL1496106.1 97485 g13307 i0 33.3 1.75531914893617 75 47 77.7 2 267 49 224 297 KAL1496106.1 hypothetical protein AB1Y20_014731 [Prymnesium parvum] diamond 495 45.4 0.993392070484582 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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