RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1041773 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
5273864 5273864 PRJNA1041773_P_NODE_93465_length_244_cov_0.900585_g93132_i0 PRJNA1041773 93465 244 0.900585 2.1974274 Prymnesium parvum 97485 Haptophyta other_Eukaryota 139 5.42e-36   NR KAL1526948.1 97485 g93132 i0 77.5 2.97540983606557 80 18 98.4 0 243 4 74 153 KAL1526948.1 hypothetical protein AB1Y20_015638 [Prymnesium parvum] diamond 726 139 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
7823642 7823642 PRJNA1041773_P_NODE_87647_length_247_cov_0.885057_g87314_i0 PRJNA1041773 87647 247 0.885057 2.18609079 Prymnesium 35143 Haptophyta other_Eukaryota 68.2 1.62e-12   NR KAL1519314.1 97485 g87314 i0 80 0.97165991902834 40 8 48.6 0 128 247 26 65 KAL1519314.1 hypothetical protein AB1Y20_022841 [Prymnesium parvum] diamond 240 68.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11649590 11649590 PRJNA1041773_P_NODE_96490_length_243_cov_0.905882_g96157_i0 PRJNA1041773 96490 243 0.905882 2.20129326 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 163 1.1399999999999999e-48   NR KOO28341.1 1460289 g96157 i0 88.9 1 81 9 100 0 243 1 106 186 KOO28341.1 cell division control protein 28 [Chrysochromulina tobinii] diamond 243 163 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
20570978 20570978 PRJNA1041773_P_NODE_101517_length_241_cov_0.916667_g101184_i0 PRJNA1041773 101517 241 0.916667 2.20916747 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 136 4.62e-35   NR KOO21715.1 1460289 g101184 i0 78.5 0.983402489626556 79 17 98.3 0 3 239 679 757 KOO21715.1 fatty acyl- synthetase [Chrysochromulina tobinii] diamond 237 136 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
26971833 26971833 PRJNA1041773_P_NODE_78342_length_251_cov_0.865169_g78009_i0 PRJNA1041773 78342 251 0.865169 2.17157419 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 65.1 5.49e-10   NR KOO28423.1 1460289 g78009 i0 49.2 0.705179282868526 59 29 70.5 1 178 2 20 77 KOO28423.1 ehmt2 [Chrysochromulina tobinii] diamond 177 65.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27319797 27319797 PRJNA1041773_P_NODE_94483_length_244_cov_0.900585_g94150_i0 PRJNA1041773 94483 244 0.900585 2.1974274 Prymnesium parvum 97485 Haptophyta other_Eukaryota 94 1.34e-20   NR KAL1522117.1 97485 g94150 i0 59.3 0.995901639344262 81 32 99.6 1 2 244 181 260 KAL1522117.1 hypothetical protein AB1Y20_021759 [Prymnesium parvum] diamond 243 94 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27564052 27564052 PRJNA1041773_P_NODE_44204_length_320_cov_1.097166_g43871_i0 PRJNA1041773 44204 320 1.097166 3.5109312 Isochrysidales 73020 Haptophyta other_Eukaryota 97.8 4.26e-21   NR NP_957735.1 2903 g43871 i0 66.2 1.340625 71 24 66.6 0 276 64 157 227 NP_957735.1 NADH dehydrogenase subunit 5 [Emiliania huxleyi] diamond 429 97.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27572312 27572312 PRJNA1041773_P_NODE_80524_length_250_cov_0.870056_g80191_i0 PRJNA1041773 80524 250 0.870056 2.17514 Prymnesium parvum 97485 Haptophyta other_Eukaryota 119 4.53e-29   NR KAL1508789.1 97485 g80191 i0 75.6 0.936 78 17 93.6 1 2 235 273 348 KAL1508789.1 hypothetical protein AB1Y20_004884 [Prymnesium parvum] diamond 234 119 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28393260 28393260 PRJNA1041773_P_NODE_84626_length_248_cov_0.880000_g84293_i0 PRJNA1041773 84626 248 0.88 2.1824 Prymnesium parvum 97485 Haptophyta other_Eukaryota 156 1.71e-45   NR KAL1515065.1 97485 g84293 i0 93.8 0.979838709677419 81 5 98 0 5 247 154 234 KAL1515065.1 hypothetical protein AB1Y20_004130 [Prymnesium parvum] diamond 243 156 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29466417 29466417 PRJNA1041773_P_NODE_84570_length_248_cov_0.880000_g84237_i0 PRJNA1041773 84570 248 0.88 2.1824 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 168 7e-49   NR KOO28632.1 1460289 g84237 i0 89 0.991935483870968 82 9 99.2 0 246 1 99 180 KOO28632.1 cobalamin synthase [Chrysochromulina tobinii] diamond 246 168 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29971997 29971997 PRJNA1041773_P_NODE_82031_length_249_cov_0.875000_g81698_i0 PRJNA1041773 82031 249 0.875 2.17875 Prymnesium parvum 97485 Haptophyta other_Eukaryota 58.9 8.42e-8   NR KAL1519083.1 97485 g81698 i0 41.2 1.60240963855422 68 34 74.7 1 189 4 2514 2581 KAL1519083.1 hypothetical protein AB1Y20_003350 [Prymnesium parvum] diamond 399 58.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29971998 29971998 PRJNA1041773_P_NODE_85011_length_248_cov_0.880000_g84678_i0 PRJNA1041773 85011 248 0.88 2.1824 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 133 4.369999999999999e-34   NR KOO48198.1 1460289 g84678 i0 85.4 0.991935483870968 82 12 99.2 0 2 247 294 375 KOO48198.1 phosphatidylinositol 3-kinase [Chrysochromulina tobinii] diamond 246 133 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30003725 30003725 PRJNA1041773_P_NODE_77611_length_251_cov_0.865169_g77278_i0 PRJNA1041773 77611 251 0.865169 2.17157419 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 134 1.23e-34   NR KOO21375.1 1460289 g77278 i0 82.1 1.00398406374502 84 14 99.2 1 2 250 304 387 KOO21375.1 eukaryotic translation initiation factor 3 subunit l-like protein [Chrysochromulina tobinii] diamond 252 134 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30667124 30667124 PRJNA1041773_P_NODE_82153_length_249_cov_0.875000_g81820_i0 PRJNA1041773 82153 249 0.875 2.17875 Prymnesium parvum 97485 Haptophyta other_Eukaryota 120 7.749999999999998e-30   NR KAL1530476.1 97485 g81820 i0 75 0.963855421686747 80 20 96.4 0 242 3 36 115 KAL1530476.1 hypothetical protein AB1Y20_001378 [Prymnesium parvum] diamond 240 120 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30793431 30793431 PRJNA1041773_P_NODE_96554_length_243_cov_0.905882_g96221_i0 PRJNA1041773 96554 243 0.905882 2.20129326 Prymnesium parvum 97485 Haptophyta other_Eukaryota 68.6 2.61e-11   NR KAL1503094.1 97485 g96221 i0 50 0.938271604938272 76 38 93.8 0 2 229 209 284 KAL1503094.1 hypothetical protein AB1Y20_011157 [Prymnesium parvum] diamond 228 68.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30943603 30943603 PRJNA1041773_P_NODE_78014_length_251_cov_0.865169_g77681_i0 PRJNA1041773 78014 251 0.865169 2.17157419 Cryptophyceae 3027 Haptophyta other_Eukaryota 79 7.48e-15   NR KAL1527440.1 97485 g77681 i0 53.1 1.91235059760956 81 28 94.4 2 251 15 634 706 KAL1527440.1 hypothetical protein AB1Y20_016106 [Prymnesium parvum] diamond 480 79.7 0.991217063989962 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31290978 31290978 PRJNA1041773_P_NODE_85475_length_248_cov_0.880000_g85142_i0 PRJNA1041773 85475 248 0.88 2.1824 Prymnesium 35143 Haptophyta other_Eukaryota 117 1.79e-28   NR KAL1529970.1 97485 g85142 i0 73.2 1.98387096774194 82 21 99.2 1 248 3 419 499 KAL1529970.1 hypothetical protein AB1Y20_000897 [Prymnesium parvum] diamond 492 117 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31584013 31584013 PRJNA1041773_P_NODE_96376_length_243_cov_0.905882_g96043_i0 PRJNA1041773 96376 243 0.905882 2.20129326 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87 3.89e-20   NR XP_005770257.1 280463 g96043 i0 97.4 0.481481481481481 39 1 48.1 0 2 118 64 102 XP_005770257.1 hypothetical protein EMIHUDRAFT_59827, partial [Emiliania huxleyi CCMP1516] diamond 117 87 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31615435 31615435 PRJNA1041773_P_NODE_86776_length_247_cov_0.885057_g86443_i0 PRJNA1041773 86776 247 0.885057 2.18609079 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 110 1.12e-27   NR KAL3897729.1 2812485 g86443 i0 68.8 0.97165991902834 80 23 94.7 1 10 243 128 207 KAL3897729.1 MAG: hypothetical protein SGPRY_012990 [Prymnesium sp.] diamond 240 110 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.

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