RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA376117" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 17 ✖

bioproject 1

  • PRJNA376117 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
17651283 17651283 PRJNA376117_P_NODE_24734_length_283_cov_2.061905_g24432_i0 PRJNA376117 24734 283 2.061905 5.83519115 Prymnesium parvum 97485 Haptophyta other_Eukaryota 89 3.49e-18   NR KAL1515312.1 97485 g24432 i0 53.2 2.46996466431095 79 37 83.7 0 244 8 744 822 KAL1515312.1 hypothetical protein AB1Y20_001944 [Prymnesium parvum] diamond 699 89 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
18251700 18251700 PRJNA376117_P_NODE_40515_length_245_cov_0.895349_g40213_i0 PRJNA376117 40515 245 0.895349 2.19360505 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 110 1.37e-29   NR KAG8461069.1 2081491 g40213 i0 74.3 6.53877551020408 74 19 90.6 0 222 1 3 76 KAG8461069.1 hypothetical protein KFE25_003638 [Diacronema lutheri] diamond 1602 110 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
20801207 20801207 PRJNA376117_P_NODE_19257_length_315_cov_1.272727_g18955_i0 PRJNA376117 19257 315 1.272727 4.00909005 Prymnesium parvum 97485 Haptophyta other_Eukaryota 169 1.22e-51   NR KAL1515397.1 97485 g18955 i0 80.4 16.0857142857143 97 19 92.4 0 295 5 3 99 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 5067 169 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27612085 27612085 PRJNA376117_P_NODE_26444_length_278_cov_1.141463_g26142_i0 PRJNA376117 26444 278 1.141463 3.17326714 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 85.5 3.57e-17   NR XP_005758663.1 280463 g26142 i0 48.4 1.02517985611511 95 45 99.3 3 277 2 250 343 XP_005758663.1 hypothetical protein EMIHUDRAFT_77352 [Emiliania huxleyi CCMP1516] diamond 285 85.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28071075 28071075 PRJNA376117_P_NODE_30345_length_263_cov_3.215789_g30043_i0 PRJNA376117 30345 263 3.215789 8.45752507 Prymnesium 35143 Haptophyta other_Eukaryota 152 9e-42   NR KAL1516059.1 97485 g30043 i0 81 1.93916349809886 84 16 95.8 0 2 253 72 155 KAL1516059.1 hypothetical protein AB1Y20_002671 [Prymnesium parvum] diamond 510 153 0.993464052287582 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28607865 28607865 PRJNA376117_P_NODE_14467_length_360_cov_1.602787_g14165_i0 PRJNA376117 14467 360 1.602787 5.7700332 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 105 9.49e-24   NR KAL1504882.1 97485 g14165 i0 69.7 2.25833333333333 66 20 55 0 356 159 309 374 KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum] diamond 813 105 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28748621 28748621 PRJNA376117_P_NODE_28967_length_269_cov_1.051020_g28665_i0 PRJNA376117 28967 269 1.05102 2.8272438 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 80.5 1.55e-15   NR KOO36135.1 1460289 g28665 i0 45.3 1.88475836431227 86 47 95.9 0 7 264 32 117 KOO36135.1 hsp20-like chaperone domain-containing protein [Chrysochromulina tobinii] diamond 507 80.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29460060 29460060 PRJNA376117_P_NODE_37670_length_247_cov_3.022989_g37368_i0 PRJNA376117 37670 247 3.022989 7.46678283 root 1 Root_unresolved Root_unresolved 49.3 1.86e-4   NR KAL1515656.1 97485 g37368 i0 45 1.79757085020243 60 33 72.9 0 182 3 42 101 KAL1515656.1 hypothetical protein AB1Y20_002274 [Prymnesium parvum] diamond 444 49.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29632355 29632355 PRJNA376117_P_NODE_31010_length_261_cov_1.632979_g30708_i0 PRJNA376117 31010 261 1.632979 4.26207519 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 101 8.359999999999999e-23   NR KOO24037.1 1460289 g30708 i0 47.3 1.06896551724138 93 43 100 1 261 1 65 157 KOO24037.1 eukaryotic translation initiation factor 3 subunit b-like protein [Chrysochromulina tobinii] diamond 279 101 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29917104 29917104 PRJNA376117_P_NODE_40271_length_245_cov_0.895349_g39969_i0 PRJNA376117 40271 245 0.895349 2.19360505 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 55.1 1.68e-6   NR KAJ1626367.1 483367 g39969 i0 41.1 0.893877551020408 73 35 79.6 1 245 51 406 478 KAJ1626367.1 acyl-CoA dehydrogenase/oxidase [Pavlovales sp. CCMP2436] diamond 219 55.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30833151 30833151 PRJNA376117_P_NODE_14754_length_357_cov_1.084507_g14452_i0 PRJNA376117 14754 357 1.084507 3.87168999 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 86.7 5.45e-17   NR XP_005763545.1 280463 g14452 i0 57.5 1.46218487394958 87 30 68.1 3 2 244 271 356 XP_005763545.1 hypothetical protein EMIHUDRAFT_437682 [Emiliania huxleyi CCMP1516] diamond 522 86.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31528735 31528735 PRJNA376117_P_NODE_34216_length_251_cov_0.865169_g33914_i0 PRJNA376117 34216 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 62.4 3.62e-9   NR KAL1528863.1 97485 g33914 i0 41.6 0.920318725099602 77 44 92 1 5 235 26 101 KAL1528863.1 hypothetical protein AB1Y20_010186 [Prymnesium parvum] diamond 231 62.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31749861 31749861 PRJNA376117_P_NODE_15877_length_345_cov_1.227941_g15575_i0 PRJNA376117 15877 345 1.227941 4.23639645 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 132 7.67e-37   NR KAJ1638552.1 483367 g15575 i0 66 2.77391304347826 106 35 92.2 1 28 345 4 108 KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436] diamond 957 132 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32178632 32178632 PRJNA376117_P_NODE_17598_length_329_cov_1.203125_g17296_i0 PRJNA376117 17598 329 1.203125 3.95828125 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 145 4.08e-42   NR KAL1515397.1 97485 g17296 i0 64 20.6261398176292 100 36 91.2 0 29 328 4 103 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 6786 146 0.993150684931507 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32288226 32288226 PRJNA376117_P_NODE_45159_length_230_cov_2.719745_g44857_i0 PRJNA376117 45159 230 2.719745 6.2554135 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 61.6 6.9e-9   NR KAG8461329.1 2081491 g44857 i0 38.7 2.03478260869565 75 46 97.8 0 227 3 270 344 KAG8461329.1 hypothetical protein KFE25_010516 [Diacronema lutheri] diamond 468 61.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32351352 32351352 PRJNA376117_P_NODE_13859_length_367_cov_1.670068_g13557_i0 PRJNA376117 13859 367 1.670068 6.12914956 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 55.1 2.7e-6   NR KAL3904080.1 2812485 g13557 i0 52.8 1.77384196185286 53 24 43.3 1 367 209 30 81 KAL3904080.1 MAG: hypothetical protein SGPRY_011420 [Prymnesium sp.] diamond 651 55.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32572872 32572872 PRJNA376117_P_NODE_18359_length_322_cov_2.028112_g18057_i0 PRJNA376117 18359 322 2.028112 6.53052064 Prymnesium parvum 97485 Haptophyta other_Eukaryota 135 2.7399999999999997e-37   NR KAL1525414.1 97485 g18057 i0 59 4.87267080745342 105 43 97.8 0 1 315 43 147 KAL1525414.1 hypothetical protein AB1Y20_020273 [Prymnesium parvum] diamond 1569 135 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);;