RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA799842", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 13 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 13 ✖

bioproject 1

  • PRJNA799842 · 13 ✖

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
13549076 13549076 PRJNA799842_P_NODE_69751_length_342_cov_1.717472_g68178_i0 PRJNA799842 69751 342 1.717472 5.87375424 Cryptophyceae 3027 Haptophyta other_Eukaryota 143 1.84e-40   NR KAL1495828.1 97485 g68178 i0 62 4.86842105263158 108 40 94.7 1 2 325 90 196 KAL1495828.1 hypothetical protein AB1Y20_016688 [Prymnesium parvum] diamond 1665 144 0.993055555555556 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
16096516 16096516 PRJNA799842_P_NODE_170093_length_244_cov_1.795322_g168520_i0 PRJNA799842 170093 244 1.795322 4.38058568 Prymnesium parvum 97485 Haptophyta other_Eukaryota 129 2.9699999999999993e-34   NR KAL1524389.1 97485 g168520 i0 75.6 9.50409836065574 78 19 95.9 0 3 236 200 277 KAL1524389.1 hypothetical protein AB1Y20_019284 [Prymnesium parvum] diamond 2319 129 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26769127 26769127 PRJNA799842_P_NODE_120941_length_266_cov_1.450777_g119368_i0 PRJNA799842 120941 266 1.450777 3.85906682 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 93.2 4.76e-21   NR KOO31352.1 1460289 g119368 i0 52.3 0.992481203007519 88 42 99.2 0 264 1 40 127 KOO31352.1 pre-mRNA-splicing factor spf27-like protein [Chrysochromulina tobinii] diamond 264 93.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
26864496 26864496 PRJNA799842_P_NODE_36221_length_477_cov_1.415842_g34651_i0 PRJNA799842 36221 477 1.415842 6.75356634 Prymnesium parvum 97485 Haptophyta other_Eukaryota 145 7.94e-38   NR KAL1526962.1 97485 g34651 i0 50 3.06918238993711 160 74 98.7 4 3 473 297 453 KAL1526962.1 hypothetical protein AB1Y20_015651 [Prymnesium parvum] diamond 1464 145 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26927441 26927441 PRJNA799842_P_NODE_156082_length_247_cov_0.885057_g154509_i0 PRJNA799842 156082 247 0.885057 2.18609079 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 65.5 3.84e-10   NR KAG8462083.1 2081491 g154509 i0 39.5 1.83400809716599 81 48 98.4 1 247 5 365 444 KAG8462083.1 hypothetical protein KFE25_011533 [Diacronema lutheri] diamond 453 65.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27622888 27622888 PRJNA799842_P_NODE_177844_length_243_cov_0.905882_g176271_i0 PRJNA799842 177844 243 0.905882 2.20129326 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 119 8.059999999999999e-31   NR XP_005760450.1 280463 g176271 i0 72.8 1 81 21 100 1 1 243 186 265 XP_005760450.1 light harvesting protein [Emiliania huxleyi CCMP1516] diamond 243 119 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28190830 28190830 PRJNA799842_P_NODE_182706_length_242_cov_0.911243_g181133_i0 PRJNA799842 182706 242 0.911243 2.20520806 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 53.5 5.5e-6   NR XP_005767886.1 280463 g181133 i0 59 1.37603305785124 39 14 45.9 1 217 107 324 362 XP_005767886.1 hypothetical protein EMIHUDRAFT_470551 [Emiliania huxleyi CCMP1516] diamond 333 53.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29241977 29241977 PRJNA799842_P_NODE_100769_length_290_cov_1.064516_g99196_i0 PRJNA799842 100769 290 1.064516 3.0870964 root 1 Root_unresolved Root_unresolved 143 1.92e-37   NR KAJ1630252.1 483367 g99196 i0 72.9 51.951724137931 96 26 99.3 0 2 289 322 417 KAJ1630252.1 heat shock protein 70, mitochondrial precursor [Pavlovales sp. CCMP2436] diamond 15066 143 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
29516981 29516981 PRJNA799842_P_NODE_139670_length_250_cov_1.305085_g138097_i0 PRJNA799842 139670 250 1.305085 3.2627125 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 50.8 5.18e-5   NR KAJ1635262.1 483367 g138097 i0 41.5 1.272 53 31 63.6 0 3 161 263 315 KAJ1635262.1 kinase domain protein [Pavlovales sp. CCMP2436] diamond 318 50.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30062882 30062882 PRJNA799842_P_NODE_102871_length_287_cov_1.439252_g101298_i0 PRJNA799842 102871 287 1.439252 4.13065324 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.4 1.29e-4   NR KAL1507110.1 97485 g101298 i0 48.8 3.55400696864112 41 21 42.9 0 262 140 514 554 KAL1507110.1 hypothetical protein AB1Y20_007966 [Prymnesium parvum] diamond 1020 50.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31381406 31381406 PRJNA799842_P_NODE_27836_length_554_cov_12.746362_g26279_i0 PRJNA799842 27836 554 12.746362 70.61484548 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 109 7.150000000000001e-27   NR XP_005778651.1 280463 g26279 i0 39.9 0.774368231046931 143 74 77.4 2 55 483 2 132 XP_005778651.1 hypothetical protein EMIHUDRAFT_73627, partial [Emiliania huxleyi CCMP1516] diamond 429 109 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31507920 31507920 PRJNA799842_P_NODE_16956_length_745_cov_1.306548_g15514_i0 PRJNA799842 16956 745 1.306548 9.7337826 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 164 2.46e-42   NR XP_005764058.1 280463 g15514 i0 41.8 3.51140939597315 251 115 89.4 9 709 44 360 608 XP_005764058.1 hypothetical protein EMIHUDRAFT_214491 [Emiliania huxleyi CCMP1516] diamond 2616 164 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31792195 31792195 PRJNA799842_P_NODE_161397_length_246_cov_0.890173_g159824_i0 PRJNA799842 161397 246 0.890173 2.18982558 Prymnesium parvum 97485 Haptophyta other_Eukaryota 48.5 2.45e-4   NR KAL1498863.1 97485 g159824 i0 31.2 0.939024390243902 77 53 93.9 0 6 236 136 212 KAL1498863.1 hypothetical protein AB1Y20_013387 [Prymnesium parvum] diamond 231 48.5 1 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);;