RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA438111", tax_clade = "Haptista" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 23 ✖

tax_clade 1

  • Haptista · 23 ✖

bioproject 1

  • PRJNA438111 · 23 ✖

analysis 1

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
433881 433881 PRJNA438111_P_NODE_221_length_1654_cov_100.647385_g138_i0 PRJNA438111 221 1654 100.647385 1664.7077479 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 696 3.64e-246   NR KAL1520265.1 97485 g138 i0 67.3 19.3403869407497 511 165 92.3 2 1605 79 4 514 KAL1520265.1 hypothetical protein AB1Y20_023734 [Prymnesium parvum] diamond 31989 696 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
5537809 5537809 PRJNA438111_P_NODE_365_length_1420_cov_28.810927_g238_i0 PRJNA438111 365 1420 28.810927 409.1151634 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 223 1.38e-62   NR KAL1508037.1 97485 g238 i0 44.5 7.79577464788732 447 190 83.9 11 1397 207 36 474 KAL1508037.1 hypothetical protein AB1Y20_007633 [Prymnesium parvum] diamond 11070 224 0.995535714285714 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
9361813 9361813 PRJNA438111_P_NODE_11428_length_304_cov_5.072727_g10803_i0 PRJNA438111 11428 304 5.072727 15.42109008 Prymnesium parvum 97485 Haptophyta other_Eukaryota 132 1.59e-33   NR KAL1511966.1 97485 g10803 i0 67.3 1.94407894736842 98 30 94.7 1 5 292 216 313 KAL1511966.1 hypothetical protein AB1Y20_005246 [Prymnesium parvum] diamond 591 132 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11912679 11912679 PRJNA438111_P_NODE_23550_length_223_cov_2.824742_g22925_i0 PRJNA438111 23550 223 2.824742 6.29917466 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 121 9.06e-31   NR KAL1496020.1 97485 g22925 i0 67.6 2.98654708520179 74 24 99.6 0 2 223 181 254 KAL1496020.1 hypothetical protein AB1Y20_014653 [Prymnesium parvum] diamond 666 121 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
15736500 15736500 PRJNA438111_P_NODE_17393_length_254_cov_4.573333_g16768_i0 PRJNA438111 17393 254 4.573333 11.61626582 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 110 7.82e-27   NR ALD47920.1 2903 g16768 i0 60.2 71.9527559055118 83 33 98 0 254 6 26 108 ALD47920.1 adaptor protein complex 1 subunit mu [Emiliania huxleyi] diamond 18276 110 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20835478 20835478 PRJNA438111_P_NODE_13537_length_283_cov_3.704724_g12912_i0 PRJNA438111 13537 283 3.704724 10.48436892 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 146 1.41e-38   NR KAL1523361.1 97485 g12912 i0 75.3 58.2614840989399 93 23 98.6 0 280 2 220 312 KAL1523361.1 hypothetical protein AB1Y20_018305 [Prymnesium parvum] diamond 16488 147 0.993197278911565 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27170568 27170568 PRJNA438111_P_NODE_7182_length_373_cov_4.311047_g6570_i0 PRJNA438111 7182 373 4.311047 16.08020531 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 114 7.839999999999999e-30   NR KOO32083.1 1460289 g6570 i0 66.7 1.96246648793566 81 27 65.1 0 126 368 46 126 KOO32083.1 60s ribosomal protein l22 [Chrysochromulina tobinii] diamond 732 114 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27202180 27202180 PRJNA438111_P_NODE_36622_length_200_cov_4.818713_g35997_i0 PRJNA438111 36622 200 4.818713 9.637426 Prymnesium parvum 97485 Haptophyta other_Eukaryota 68.2 2.24e-11   NR KAL1522280.1 97485 g35997 i0 47.7 0.975 65 34 97.5 0 195 1 271 335 KAL1522280.1 hypothetical protein AB1Y20_017274 [Prymnesium parvum] diamond 195 68.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27377053 27377053 PRJNA438111_P_NODE_25423_length_216_cov_3.786096_g24798_i0 PRJNA438111 25423 216 3.786096 8.17796736 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 75.1 1.03e-13   NR KOO22886.1 1460289 g24798 i0 52.1 4.81944444444444 71 31 98.6 1 3 215 642 709 KOO22886.1 eukaryotic translation initiation factor 5b [Chrysochromulina tobinii] diamond 1041 75.5 0.994701986754967 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27581368 27581368 PRJNA438111_P_NODE_22244_length_229_cov_2.125000_g21619_i0 PRJNA438111 22244 229 2.125 4.86625 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 67.4 2.06e-11   NR XP_005768097.1 280463 g21619 i0 59.6 1.23144104803493 47 19 61.6 0 225 85 111 157 XP_005768097.1 hypothetical protein EMIHUDRAFT_103182 [Emiliania huxleyi CCMP1516] diamond 282 67.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27960331 27960331 PRJNA438111_P_NODE_59845_length_171_cov_4.866197_g59220_i0 PRJNA438111 59845 171 4.866197 8.32119687 Prymnesium parvum 97485 Haptophyta other_Eukaryota 46.2 8.38e-4   NR KAL1523477.1 97485 g59220 i0 35.7 0.982456140350877 56 34 98.2 1 170 3 820 873 KAL1523477.1 hypothetical protein AB1Y20_018415 [Prymnesium parvum] diamond 168 46.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28339243 28339243 PRJNA438111_P_NODE_18106_length_250_cov_3.321267_g17481_i0 PRJNA438111 18106 250 3.321267 8.3031675 Prymnesium parvum 97485 Haptophyta other_Eukaryota 46.6 0.00182   NR KAL1529927.1 97485 g17481 i0 44.2 0.624 52 22 54 2 247 113 718 769 KAL1529927.1 hypothetical protein AB1Y20_000855 [Prymnesium parvum] diamond 156 46.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28450491 28450491 PRJNA438111_P_NODE_2906_length_570_cov_18.977819_g2432_i0 PRJNA438111 2906 570 18.977819 108.1735683 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 164 2.12e-45   NR XP_005767490.1 280463 g2432 i0 47 4.8 183 96 96.3 1 1 549 35 216 XP_005767490.1 hypothetical protein EMIHUDRAFT_445681 [Emiliania huxleyi CCMP1516] diamond 2736 164 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28450494 28450494 PRJNA438111_P_NODE_4046_length_490_cov_5.177874_g3518_i0 PRJNA438111 4046 490 5.177874 25.3715826 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 231 8.19e-72   NR XP_005788789.1 280463 g3518 i0 68.5 9.02448979591837 162 51 99.2 0 4 489 139 300 XP_005788789.1 hypothetical protein EMIHUDRAFT_455075 [Emiliania huxleyi CCMP1516] diamond 4422 232 0.995689655172414 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29239710 29239710 PRJNA438111_P_NODE_9149_length_335_cov_11.000000_g8529_i0 PRJNA438111 9149 335 11 36.85 Diacronema 70451 Haptophyta other_Eukaryota 106 3.62e-27   NR KAJ1636234.1 483367 g8529 i0 55.2 1.55820895522388 96 40 86 1 13 300 26 118 KAJ1636234.1 mitochondrial acyl carrier protein [Pavlovales sp. CCMP2436] diamond 522 106 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30329257 30329257 PRJNA438111_P_NODE_66392_length_167_cov_1.543478_g65767_i0 PRJNA438111 66392 167 1.543478 2.57760826 Prymnesium parvum 97485 Haptophyta other_Eukaryota 48.5 1.22e-4   NR KAL1518896.1 97485 g65767 i0 46.3 1.86826347305389 54 26 95.2 2 166 8 1363 1414 KAL1518896.1 hypothetical protein AB1Y20_003170 [Prymnesium parvum] diamond 312 48.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30897620 30897620 PRJNA438111_P_NODE_79034_length_158_cov_5.209302_g78409_i0 PRJNA438111 79034 158 5.209302 8.23069716 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 78.6 2.73e-15   NR KAG8467190.1 2081491 g78409 i0 69.4 1.84177215189873 49 15 93 0 10 156 634 682 KAG8467190.1 hypothetical protein KFE25_000506 [Diacronema lutheri] diamond 291 78.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31687738 31687738 PRJNA438111_P_NODE_24377_length_220_cov_2.712042_g23752_i0 PRJNA438111 24377 220 2.712042 5.9664924 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 45.8 0.00229   NR KAG8463183.1 2081491 g23752 i0 46.9 0.668181818181818 49 26 66.8 0 68 214 118 166 KAG8463183.1 hypothetical protein KFE25_011180 [Diacronema lutheri] diamond 147 45.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31719485 31719485 PRJNA438111_P_NODE_60257_length_171_cov_2.880282_g59632_i0 PRJNA438111 60257 171 2.880282 4.92528222 Prymnesium parvum 97485 Haptophyta other_Eukaryota 65.1 5.11e-11   NR KAL1498506.1 97485 g59632 i0 57.4 3.35087719298246 47 20 82.5 0 166 26 152 198 KAL1498506.1 hypothetical protein AB1Y20_013829 [Prymnesium parvum] diamond 573 65.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32083777 32083777 PRJNA438111_P_NODE_51618_length_180_cov_1.801325_g50993_i0 PRJNA438111 51618 180 1.801325 3.242385 root 1 Root_unresolved Root_unresolved 79.7 1.45e-15   NR KAL1523795.1 97485 g50993 i0 69.5 2.95 59 16 98.3 1 3 179 237 293 KAL1523795.1 hypothetical protein AB1Y20_018718 [Prymnesium parvum] diamond 531 79.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32368815 32368815 PRJNA438111_P_NODE_19259_length_243_cov_11.780374_g18634_i0 PRJNA438111 19259 243 11.780374 28.62630882 root 1 Root_unresolved Root_unresolved 110 4.62e-28   NR KAL1529854.1 97485 g18634 i0 80 4.11111111111111 55 11 67.9 0 242 78 177 231 KAL1529854.1 hypothetical protein AB1Y20_000785 [Prymnesium parvum] diamond 999 110 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32825567 32825567 PRJNA438111_P_NODE_12120_length_297_cov_2.996269_g11495_i0 PRJNA438111 12120 297 2.996269 8.89891893 Prymnesium parvum 97485 Haptophyta other_Eukaryota 89.4 2.49e-20   NR KAL1515842.1 97485 g11495 i0 48.7 0.787878787878788 78 40 78.8 0 276 43 59 136 KAL1515842.1 hypothetical protein AB1Y20_002457 [Prymnesium parvum] diamond 234 89.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32904751 32904751 PRJNA438111_P_NODE_64680_length_168_cov_2.028777_g64055_i0 PRJNA438111 64680 168 2.028777 3.40834536 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 48.1 1.63e-4   NR KAL1507412.1 97485 g64055 i0 47.1 1.39285714285714 51 25 87.5 1 21 167 262 312 KAL1507412.1 hypothetical protein AB1Y20_008253 [Prymnesium parvum] diamond 234 48.5 0.991752577319588 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);;