RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJEB10140", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 19 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 19 ✖

bioproject 1

  • PRJEB10140 · 19 ✖

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
5114230 5114230 PRJEB10140_P_NODE_17905_length_1621_cov_29.660941_g10268_i0 PRJEB10140 17905 1621 29.660941 480.80385361 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 696 2.4000000000000003e-246   NR KAL1520265.1 97485 g10268 i0 67.3 19.7341147439852 511 165 94.2 2 1588 62 4 514 KAL1520265.1 hypothetical protein AB1Y20_023734 [Prymnesium parvum] diamond 31989 696 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26874645 26874645 PRJEB10140_P_NODE_126001_length_291_cov_1.214876_g108694_i0 PRJEB10140 126001 291 1.214876 3.53528916 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 52 3.72e-5   NR KAL3926891.1 2812485 g108694 i0 51.3 1.83505154639175 39 19 40.2 0 174 290 972 1010 KAL3926891.1 MAG: hypothetical protein SGPRY_003087 [Prymnesium sp.] diamond 534 52 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
27563431 27563431 PRJEB10140_P_NODE_153264_length_243_cov_1.041237_g135956_i0 PRJEB10140 153264 243 1.041237 2.53020591 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 46.2 0.00215   NR KAL1498779.1 97485 g135956 i0 44.6 1.62962962962963 65 34 80.2 1 40 234 155 217 KAL1498779.1 hypothetical protein AB1Y20_014086 [Prymnesium parvum] diamond 396 46.6 0.991416309012876 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27847750 27847750 PRJEB10140_P_NODE_139684_length_264_cov_0.930233_g122377_i0 PRJEB10140 139684 264 0.930233 2.45581512 Prymnesium 35143 Haptophyta other_Eukaryota 88.2 2.26e-19   NR KAL1498506.1 97485 g122377 i0 52.3 5.875 86 41 97.7 0 6 263 78 163 KAL1498506.1 hypothetical protein AB1Y20_013829 [Prymnesium parvum] diamond 1551 88.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27948760 27948760 PRJEB10140_P_NODE_90625_length_404_cov_1.453521_g73336_i0 PRJEB10140 90625 404 1.453521 5.87222484 Prymnesium parvum 97485 Haptophyta other_Eukaryota 125 2.45e-32   NR KAL1528863.1 97485 g73336 i0 46.3 1.00990099009901 136 65 95 2 385 2 113 248 KAL1528863.1 hypothetical protein AB1Y20_010186 [Prymnesium parvum] diamond 408 125 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28358947 28358947 PRJEB10140_P_NODE_220006_length_183_cov_0.865672_g202697_i0 PRJEB10140 220006 183 0.865672 1.58417976 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 86.7 6.05e-19   NR XP_005773442.1 280463 g202697 i0 67.8 1.95081967213115 59 19 96.7 0 178 2 10 68 XP_005773442.1 D-lactate dehydrogenase, partial [Emiliania huxleyi CCMP1516] diamond 357 86.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28738012 28738012 PRJEB10140_P_NODE_218727_length_183_cov_1.917910_g201418_i0 PRJEB10140 218727 183 1.91791 3.5097753 Prymnesium parvum 97485 Haptophyta other_Eukaryota 55.5 5.59e-7   NR KAL1503391.1 97485 g201418 i0 46.3 1.59016393442623 54 29 88.5 0 22 183 264 317 KAL1503391.1 hypothetical protein AB1Y20_011442 [Prymnesium parvum] diamond 291 55.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28800994 28800994 PRJEB10140_P_NODE_293148_length_162_cov_0.867257_g275839_i0 PRJEB10140 293148 162 0.867257 1.40495634 Prymnesium parvum 97485 Haptophyta other_Eukaryota 85.5 5.9e-18   NR KAL1523363.1 97485 g275839 i0 74.5 0.944444444444444 51 13 94.4 0 10 162 100 150 KAL1523363.1 hypothetical protein AB1Y20_018307 [Prymnesium parvum] diamond 153 85.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28832592 28832592 PRJEB10140_P_NODE_160488_length_233_cov_2.228261_g143180_i0 PRJEB10140 160488 233 2.228261 5.19184813 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 49.3 1.61e-4   NR KAG8458565.1 2081491 g143180 i0 42.3 0.914163090128755 71 41 91.4 0 18 230 302 372 KAG8458565.1 hypothetical protein KFE25_003100 [Diacronema lutheri] diamond 213 49.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28832640 28832640 PRJEB10140_P_NODE_232448_length_175_cov_2.412698_g215139_i0 PRJEB10140 232448 175 2.412698 4.2222215 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 59.7 9.17e-9   NR XP_005783677.1 280463 g215139 i0 65.7 0.6 35 12 60 0 154 50 25 59 XP_005783677.1 hypothetical protein EMIHUDRAFT_468249 [Emiliania huxleyi CCMP1516] diamond 105 59.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29463749 29463749 PRJEB10140_P_NODE_191490_length_202_cov_1.359477_g174181_i0 PRJEB10140 191490 202 1.359477 2.74614354 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 53.1 4.47e-6   NR KAG8465708.1 2081491 g174181 i0 41.7 2.67326732673267 60 35 89.1 0 3 182 149 208 KAG8465708.1 hypothetical protein KFE25_003015 [Diacronema lutheri] diamond 540 53.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
29748132 29748132 PRJEB10140_P_NODE_45971_length_787_cov_608.884824_g10761_i2 PRJEB10140 45971 787 608.884824 4791.92356488 Prymnesium parvum 97485 Haptophyta other_Eukaryota 50.4 0.00546   NR KAL1523158.1 97485 g10761 i2 42.1 0.979669631512071 57 33 21.7 0 275 445 638 694 KAL1523158.1 hypothetical protein AB1Y20_018113 [Prymnesium parvum] diamond 771 50.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30380584 30380584 PRJEB10140_P_NODE_23193_length_1368_cov_1171.909780_g10761_i1 PRJEB10140 23193 1368 1171.90978 16031.7257904 Prymnesium parvum 97485 Haptophyta other_Eukaryota 50.1 0.0261   NR KAL1523158.1 97485 g10761 i1 42.1 0.416666666666667 57 33 12.5 0 275 445 638 694 KAL1523158.1 hypothetical protein AB1Y20_018113 [Prymnesium parvum] diamond 570 50.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31264913 31264913 PRJEB10140_P_NODE_221315_length_182_cov_1.172932_g204006_i0 PRJEB10140 221315 182 1.172932 2.13473624 Prymnesium parvum 97485 Haptophyta other_Eukaryota 56.2 2.79e-7   NR KAL1529376.1 97485 g204006 i0 51.1 3.62637362637363 47 23 77.5 0 4 144 201 247 KAL1529376.1 hypothetical protein AB1Y20_000328 [Prymnesium parvum] diamond 660 56.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31448721 31448721 PRJEB10140_P_NODE_141856_length_260_cov_1.450237_g124548_i0 PRJEB10140 141856 260 1.450237 3.7706162 root 1 Root_unresolved Root_unresolved 49.3 1.79e-4   NR KOO33958.1 1460289 g124548 i0 55 1.32692307692308 40 18 46.2 0 258 139 78 117 KOO33958.1 ankyrin repeat-containing protein, partial [Chrysochromulina tobinii] diamond 345 49.7 0.991951710261569 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31517992 31517992 PRJEB10140_P_NODE_121836_length_300_cov_2.713147_g104529_i0 PRJEB10140 121836 300 2.713147 8.139441 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 47 0.00227   NR XP_005770230.1 280463 g104529 i0 36.1 0.72 72 45 72 1 34 249 4 74 XP_005770230.1 hypothetical protein EMIHUDRAFT_209780 [Emiliania huxleyi CCMP1516] diamond 216 47 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31701719 31701719 PRJEB10140_P_NODE_257437_length_167_cov_0.881356_g240128_i0 PRJEB10140 257437 167 0.881356 1.47186452 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.8 1.85e-5   NR KOO22352.1 1460289 g240128 i0 38.8 1.83233532934132 49 30 88 0 1 147 507 555 KOO22352.1 protein phosphatase [Chrysochromulina tobinii] diamond 306 50.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32277356 32277356 PRJEB10140_P_NODE_125539_length_292_cov_1.308642_g108232_i0 PRJEB10140 125539 292 1.308642 3.82123464 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 53.9 7.82e-6   NR KAJ1617474.1 483367 g108232 i0 37.5 0.73972602739726 72 44 74 1 277 62 466 536 KAJ1617474.1 hypothetical protein T492DRAFT_893637 [Pavlovales sp. CCMP2436] diamond 216 53.9 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32309122 32309122 PRJEB10140_P_NODE_138119_length_266_cov_2.847926_g120812_i0 PRJEB10140 138119 266 2.847926 7.57548316 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 150 9.37e-44   NR KOO35252.1 1460289 g120812 i0 83 2.97744360902256 88 15 99.2 0 1 264 61 148 KOO35252.1 40s ribosomal protein s9 [Chrysochromulina tobinii] diamond 792 150 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);;