RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB39643", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 20 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 20 ✖

bioproject 1

  • PRJEB39643 · 20 ✖

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
57562 57562 PRJEB39643_P_NODE_142221_length_244_cov_1.730994_g142028_i0 PRJEB39643 142221 244 1.730994 4.22362536 Prymnesiales 73028 Haptophyta other_Eukaryota 98.2 5.46e-23   NR KAL1530296.1 97485 g142028 i0 74.1 1.42622950819672 58 14 70.1 1 206 36 54 111 KAL1530296.1 hypothetical protein AB1Y20_001207 [Prymnesium parvum] diamond 348 98.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
6436084 6436084 PRJEB39643_P_NODE_27006_length_352_cov_19.272401_g26813_i0 PRJEB39643 27006 352 19.272401 67.83885152 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 117 1.29e-31   NR KAG8469654.1 2081491 g26813 i0 65.3 1.6875 98 34 83.5 0 345 52 8 105 KAG8469654.1 hypothetical protein KFE25_006109 [Diacronema lutheri] diamond 594 117 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
11536734 11536734 PRJEB39643_P_NODE_94070_length_264_cov_1.612565_g93877_i0 PRJEB39643 94070 264 1.612565 4.2571716 Prymnesium 35143 Haptophyta other_Eukaryota 137 4.55e-36   NR KAL1496000.1 97485 g93877 i0 77 1.97727272727273 87 20 98.9 0 263 3 176 262 KAL1496000.1 hypothetical protein AB1Y20_014636 [Prymnesium parvum] diamond 522 137 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
20459434 20459434 PRJEB39643_P_NODE_99357_length_261_cov_2.308511_g99164_i0 PRJEB39643 99357 261 2.308511 6.02521371 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 82.4 3.04e-11   NTclustered gi|551616279|ref|XM_005788931.1| 280463 g99164 i0 82.653 3.15708812260536 98 12 36 4 53 146 150 54 Emiliania huxleyi CCMP1516 putative mago nashi (MGO), mRNA blastn 824 82.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
21734582 21734582 PRJEB39643_P_NODE_27658_length_349_cov_1.775362_g27465_i0 PRJEB39643 27658 349 1.775362 6.19601338 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 67 2.6e-10   NR KAJ1625011.1 483367 g27465 i0 61.1 0.464183381088825 54 21 46.4 0 166 5 70 123 KAJ1625011.1 hypothetical protein T492DRAFT_1042819 [Pavlovales sp. CCMP2436] diamond 162 67 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
21734766 21734766 PRJEB39643_P_NODE_42298_length_290_cov_1.419355_g42105_i0 PRJEB39643 42298 290 1.419355 4.1161295 Diacronema 70451 Haptophyta other_Eukaryota 132 4.2e-37   NR KAJ1617403.1 483367 g42105 i0 68.1 1.9448275862069 94 30 97.2 0 290 9 16 109 KAJ1617403.1 Tim17/Tim22/Tim23/Pmp24 family-domain-containing protein [Pavlovales sp. CCMP2436] diamond 564 132 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
26621807 26621807 PRJEB39643_P_NODE_30461_length_334_cov_2.360153_g30268_i0 PRJEB39643 30461 334 2.360153 7.88291102 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 115 1.64e-29   NR KAG8470665.1 2081491 g30268 i0 54.6 0.970059880239521 108 49 97 0 332 9 23 130 KAG8470665.1 hypothetical protein KFE25_009086 [Diacronema lutheri] diamond 324 115 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26716497 26716497 PRJEB39643_P_NODE_91281_length_265_cov_1.604167_g91088_i0 PRJEB39643 91281 265 1.604167 4.25104255 Prymnesium parvum 97485 Haptophyta other_Eukaryota 109 9.79e-26   NR KAL1499435.1 97485 g91088 i0 58.6 1.96981132075472 87 35 98.5 1 3 263 358 443 KAL1499435.1 hypothetical protein AB1Y20_011640 [Prymnesium parvum] diamond 522 109 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27286260 27286260 PRJEB39643_P_NODE_33143_length_322_cov_2.971888_g32950_i0 PRJEB39643 33143 322 2.971888 9.56947936 Prymnesium parvum 97485 Haptophyta other_Eukaryota 107 2.61e-24   NR KAL1510627.1 97485 g32950 i0 50.5 4.95652173913043 107 51 97.8 2 2 316 121 227 KAL1510627.1 hypothetical protein AB1Y20_006928 [Prymnesium parvum] diamond 1596 107 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27311481 27311481 PRJEB39643_P_NODE_14263_length_495_cov_9.189573_g14072_i0 PRJEB39643 14263 495 9.189573 45.48838635 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 149 1.07e-42   NR KAL1514807.1 97485 g14072 i0 58.3 17.0060606060606 139 55 83.6 2 45 458 4 140 KAL1514807.1 hypothetical protein AB1Y20_003893 [Prymnesium parvum] diamond 8418 150 0.993333333333333 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27563650 27563650 PRJEB39643_P_NODE_32144_length_327_cov_1.669291_g31951_i0 PRJEB39643 32144 327 1.669291 5.45858157 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 87.4 2.11e-17   NR KAL1529061.1 97485 g31951 i0 56.1 5.22935779816514 66 29 60.6 0 209 12 85 150 KAL1529061.1 hypothetical protein AB1Y20_000024 [Prymnesium parvum] diamond 1710 87.8 0.995444191343964 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27728771 27728771 PRJEB39643_P_NODE_158764_length_213_cov_4.400000_g158570_i0 PRJEB39643 158764 213 4.4 9.372 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 54.7 1.18e-7   NR KAL3917127.1 2812485 g158570 i0 40 5.88732394366197 70 41 98.6 1 210 1 11 79 KAL3917127.1 MAG: hypothetical protein SGPRY_006528 [Prymnesium sp.] diamond 1254 54.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
28896541 28896541 PRJEB39643_P_NODE_60148_length_281_cov_1.480769_g59955_i0 PRJEB39643 60148 281 1.480769 4.16096089 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 53.9 6.94e-6   NR KAL3931536.1 2812485 g59955 i0 43.7 1.74021352313167 71 31 75.8 2 257 45 539 600 KAL3931536.1 MAG: hypothetical protein SGPRY_001085, partial [Prymnesium sp.] diamond 489 53.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
29433049 29433049 PRJEB39643_P_NODE_105710_length_258_cov_2.962162_g105517_i0 PRJEB39643 105710 258 2.962162 7.64237796 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 72 2.21e-12   NR XP_005786399.1 280463 g105517 i0 46.3 0.953488372093023 82 42 95.3 1 256 11 858 937 XP_005786399.1 hypothetical protein EMIHUDRAFT_441425 [Emiliania huxleyi CCMP1516] diamond 246 72 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30159522 30159522 PRJEB39643_P_NODE_158332_length_218_cov_5.586207_g158138_i0 PRJEB39643 158332 218 5.586207 12.17793126 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 72 1.18e-12   NR KOO28186.1 1460289 g158138 i0 81.6 3.27522935779817 38 7 52.3 0 18 131 3 40 KOO28186.1 actin-like protein [Chrysochromulina tobinii] diamond 714 72 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30318348 30318348 PRJEB39643_P_NODE_7372_length_754_cov_10.490455_g7208_i0 PRJEB39643 7372 754 10.490455 79.0980307 Prymnesium parvum 97485 Haptophyta other_Eukaryota 283 2.36e-92   NR KAL1498655.1 97485 g7208 i0 65.7 3.40185676392573 207 71 82.4 0 68 688 15 221 KAL1498655.1 hypothetical protein AB1Y20_013968 [Prymnesium parvum] diamond 2565 283 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30412839 30412839 PRJEB39643_P_NODE_154733_length_229_cov_2.935897_g154540_i0 PRJEB39643 154733 229 2.935897 6.72320413 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 96.3 4.540000000000001e-21   NR KOO20997.1 1460289 g154540 i0 57.9 1.99126637554585 76 32 99.6 0 229 2 227 302 KOO20997.1 tubulin polyglutamylase ttll5 [Chrysochromulina tobinii] diamond 456 96.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30601977 30601977 PRJEB39643_P_NODE_137293_length_245_cov_3.337209_g137100_i0 PRJEB39643 137293 245 3.337209 8.17616205 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 118 1.4599999999999998e-32   NR XP_005767144.1 280463 g137100 i0 70.7 3.01224489795918 82 23 99.2 1 1 243 9 90 XP_005767144.1 hypothetical protein EMIHUDRAFT_432584 [Emiliania huxleyi CCMP1516] diamond 738 118 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32309977 32309977 PRJEB39643_P_NODE_67899_length_277_cov_1.509804_g67706_i0 PRJEB39643 67899 277 1.509804 4.18215708 Prymnesium parvum 97485 Haptophyta other_Eukaryota 62.4 3.34e-9   NR KAL1508608.1 97485 g67706 i0 43.5 0.671480144404332 62 34 66.1 1 275 93 23 84 KAL1508608.1 hypothetical protein AB1Y20_004705 [Prymnesium parvum] diamond 186 62.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32846081 32846081 PRJEB39643_P_NODE_146200_length_242_cov_1.822485_g146007_i0 PRJEB39643 146200 242 1.822485 4.4104137 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 98.2 1.13e-21   NR KAG8465477.1 2081491 g146007 i0 51.3 0.991735537190083 80 39 99.2 0 2 241 613 692 KAG8465477.1 hypothetical protein KFE25_002784 [Diacronema lutheri] diamond 240 98.2 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);;