RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where bioproject = "PRJNA924320" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 31 ✖

bioproject 1

  • PRJNA924320 · 31 ✖

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
3449951 3449951 PRJNA924320_S_NODE_2143_length_631_cov_3.702749_g2017_i0 PRJNA924320 2143 631 3.702749 23.36434619 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 95.3 1.03e-14   NTclustered gi|551606591|ref|XM_005784584.1| 280463 g2017 i0 83.838 2.48494453248811 99 16 16 0 1 99 215 313 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1568 95.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
3450267 3450267 PRJNA924320_S_NODE_55583_length_162_cov_0.902655_g55441_i0 PRJNA924320 55583 162 0.902655 1.4623011 Cryptophyceae 3027 Haptophyta other_Eukaryota 90.5 4.6e-20   NR KAL1508007.1 97485 g55441 i0 88.7 4.88888888888889 53 6 98.1 0 2 160 194 246 KAL1508007.1 hypothetical protein AB1Y20_007605 [Prymnesium parvum] diamond 792 91.3 0.991237677984666 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
4727642 4727642 PRJNA924320_S_NODE_26864_length_207_cov_1.911392_g26722_i0 PRJNA924320 26864 207 1.911392 3.95658144 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 65.8 2.33e-6   NTclustered gi|551557123|ref|XM_005765587.1| 280463 g26722 i0 95.122 0.198067632850242 41 2 20 0 146 186 447 407 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 41 65.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13652708 13652708 PRJNA924320_S_NODE_13211_length_274_cov_1.840000_g13069_i0 PRJNA924320 13211 274 1.84 5.0416 Diacronema 70451 Haptophyta other_Eukaryota 114 5.06e-30   NR KAJ1641330.1 483367 g13069 i0 65 4.47810218978102 80 28 87.6 0 246 7 9 88 KAJ1641330.1 40S ribosomal protein S19 like [Pavlovales sp. CCMP2436] diamond 1227 114 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
23851692 23851692 PRJNA924320_S_NODE_679_length_1031_cov_6.775967_g615_i0 PRJNA924320 679 1031 6.775967 69.86021977 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 362 4.75e-120   NR KAL1512169.1 97485 g615 i0 56.2 8.69738118331717 329 142 95.7 2 1 987 91 417 KAL1512169.1 hypothetical protein AB1Y20_005435 [Prymnesium parvum] diamond 8967 363 0.997245179063361 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
25125141 25125141 PRJNA924320_S_NODE_20380_length_230_cov_1.160221_g20238_i0 PRJNA924320 20380 230 1.160221 2.6685083 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 215 2.47e-51   NTclustered gi|551557925|ref|XM_005765918.1| 280463 g20238 i0 85.047 15.304347826087 214 29 92 3 19 230 1573 1785 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 3520 215 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26834931 26834931 PRJNA924320_S_NODE_31961_length_194_cov_1.082759_g31819_i0 PRJNA924320 31961 194 1.082759 2.10055246 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 54.3 1.57e-6   NR KAL3909975.1 2812485 g31819 i0 43.6 0.850515463917526 55 31 85.1 0 29 193 193 247 KAL3909975.1 MAG: hypothetical protein SGPRY_009228 [Prymnesium sp.] diamond 165 54.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
26929842 26929842 PRJNA924320_S_NODE_7982_length_343_cov_1.190476_g7840_i0 PRJNA924320 7982 343 1.190476 4.08333268 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 57.4 3.08e-7   NR KOO25695.1 1460289 g7840 i0 33.6 1.95918367346939 113 75 98.8 0 341 3 49 161 KOO25695.1 hypothetical protein Ctob_012372 [Chrysochromulina tobinii] diamond 672 57.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27088021 27088021 PRJNA924320_S_NODE_37682_length_182_cov_1.082707_g37540_i0 PRJNA924320 37682 182 1.082707 1.97052674 Prymnesium parvum 97485 Haptophyta other_Eukaryota 44.7 0.00343   NR KAL1498555.1 97485 g37540 i0 39.7 0.956043956043956 58 35 95.6 0 177 4 114 171 KAL1498555.1 hypothetical protein AB1Y20_013874 [Prymnesium parvum] diamond 174 44.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27253106 27253106 PRJNA924320_S_NODE_50963_length_164_cov_1.600000_g50821_i0 PRJNA924320 50963 164 1.6 2.624 Prymnesiales 73028 Haptophyta other_Eukaryota 65.9 1.23e-11   NR KAL1522843.1 97485 g50821 i0 57.7 2.85365853658537 52 22 95.1 0 2 157 17 68 KAL1522843.1 hypothetical protein AB1Y20_017811 [Prymnesium parvum] diamond 468 65.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27372684 27372684 PRJNA924320_S_NODE_22883_length_220_cov_1.491228_g22741_i0 PRJNA924320 22883 220 1.491228 3.2807016 Prymnesium parvum 97485 Haptophyta other_Eukaryota 53.5 4.22e-6   NR KAL1495937.1 97485 g22741 i0 33.8 0.968181818181818 71 47 96.8 0 1 213 74 144 KAL1495937.1 hypothetical protein AB1Y20_014579 [Prymnesium parvum] diamond 213 53.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27814661 27814661 PRJNA924320_S_NODE_45644_length_167_cov_1.728814_g45502_i0 PRJNA924320 45644 167 1.728814 2.88711938 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 42.4 0.0181   NR KAJ1617603.1 483367 g45502 i0 56.3 0.574850299401198 32 14 57.5 0 111 16 284 315 KAJ1617603.1 WD40-repeat-containing domain protein [Pavlovales sp. CCMP2436] diamond 96 42.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
27940818 27940818 PRJNA924320_S_NODE_5065_length_420_cov_4.563342_g4923_i0 PRJNA924320 5065 420 4.563342 19.1660364 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 207 1.49e-62   NR KAJ1625763.1 483367 g4923 i0 70.6 2.91428571428571 136 40 97.1 0 12 419 179 314 KAJ1625763.1 pseudouridine synthase [Pavlovales sp. CCMP2436] diamond 1224 207 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28414452 28414452 PRJNA924320_S_NODE_14586_length_263_cov_1.906542_g14444_i0 PRJNA924320 14586 263 1.906542 5.01420546 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 57 4.26e-7   NR KOO53605.1 1460289 g14444 i0 38 2.08745247148289 92 47 98.1 3 262 5 153 240 KOO53605.1 peptidyl-prolyl cis-trans isomerase-like 6-like protein [Chrysochromulina tobinii] diamond 549 57 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28572122 28572122 PRJNA924320_S_NODE_14107_length_267_cov_1.403670_g13965_i0 PRJNA924320 14107 267 1.40367 3.7477989 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 42.7 0.05   NR KOO32777.1 1460289 g13965 i0 31.8 0.955056179775281 85 57 95.5 1 265 11 770 853 KOO32777.1 conserved oligomeric golgi complex subunit 4-like protein [Chrysochromulina tobinii] diamond 255 42.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28730125 28730125 PRJNA924320_S_NODE_53567_length_163_cov_0.894737_g53425_i0 PRJNA924320 53567 163 0.894737 1.45842131 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 42.4 0.017   NR KAL3905726.1 2812485 g53425 i0 32 0.920245398773006 50 34 92 0 7 156 200 249 KAL3905726.1 MAG: hypothetical protein SGPRY_010818, partial [Prymnesium sp.] diamond 150 42.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
28761547 28761547 PRJNA924320_S_NODE_49527_length_165_cov_1.068966_g49385_i0 PRJNA924320 49527 165 1.068966 1.7637939 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 88.6 6.2500000000000006e-21   NR KOO31148.1 1460289 g49385 i0 81.8 9 55 10 100 0 1 165 23 77 KOO31148.1 40s ribosomal protein s20 [Chrysochromulina tobinii] diamond 1485 88.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28824529 28824529 PRJNA924320_S_NODE_37548_length_182_cov_1.150376_g37406_i0 PRJNA924320 37548 182 1.150376 2.09368432 Prymnesium parvum 97485 Haptophyta other_Eukaryota 42.4 0.0229   NR KAL1503852.1 97485 g37406 i0 43.4 0.873626373626374 53 30 87.4 0 164 6 141 193 KAL1503852.1 hypothetical protein AB1Y20_012316 [Prymnesium parvum] diamond 159 42.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29077542 29077542 PRJNA924320_S_NODE_7128_length_359_cov_20.464516_g6986_i0 PRJNA924320 7128 359 20.464516 73.46761244 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87.4 1.64e-19   NR XP_005782836.1 280463 g6986 i0 51 1.70473537604457 98 44 81.1 2 319 29 20 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 612 87.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29715809 29715809 PRJNA924320_S_NODE_19430_length_234_cov_1.924324_g19288_i0 PRJNA924320 19430 234 1.924324 4.50291816 Diacronema 70451 Haptophyta other_Eukaryota 45.8 0.00261   NR KAJ1629966.1 483367 g19288 i0 80 0.666666666666667 25 5 32.1 0 233 159 393 417 KAJ1629966.1 delta-5 desaturase [Pavlovales sp. CCMP2436] diamond 156 45.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
29898430 29898430 PRJNA924320_S_NODE_11411_length_292_cov_2.485597_g11269_i0 PRJNA924320 11411 292 2.485597 7.25794324 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 88.2 1.18e-18   NR KAJ1636976.1 483367 g11269 i0 53.2 2.90753424657534 94 41 95.5 2 287 9 165 256 KAJ1636976.1 E1-E2 ATPase-domain-containing protein, partial [Pavlovales sp. CCMP2436] diamond 849 88.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
29905742 29905742 PRJNA924320_S_NODE_6071_length_386_cov_3.626113_g5929_i0 PRJNA924320 6071 386 3.626113 13.99679618 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 81.3 1.02e-16   NR KAL1510948.1 97485 g5929 i0 38.5 3.34974093264249 130 65 91.7 4 9 362 10 136 KAL1510948.1 hypothetical protein AB1Y20_005775 [Prymnesium parvum] diamond 1293 81.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29961522 29961522 PRJNA924320_S_NODE_56051_length_162_cov_0.902655_g55909_i0 PRJNA924320 56051 162 0.902655 1.4623011 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 43.5 0.00107   NR KAJ1615723.1 483367 g55909 i0 41.2 2.96296296296296 51 28 94.4 1 2 154 18 66 KAJ1615723.1 kinase-like domain-containing protein, partial [Pavlovales sp. CCMP2436] diamond 480 43.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
29993221 29993221 PRJNA924320_S_NODE_57851_length_161_cov_0.910714_g57709_i0 PRJNA924320 57851 161 0.910714 1.46624954 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 50.1 3.2e-5   NR XP_005764893.1 280463 g57709 i0 47.1 0.950310559006211 51 27 95 0 153 1 109 159 XP_005764893.1 hypothetical protein EMIHUDRAFT_422149 [Emiliania huxleyi CCMP1516] diamond 153 50.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31225219 31225219 PRJNA924320_S_NODE_52855_length_163_cov_1.342105_g52713_i0 PRJNA924320 52855 163 1.342105 2.18763115 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 61.6 2.64e-9   NR KAL3931286.1 2812485 g52713 i0 61.2 0.901840490797546 49 19 90.2 0 155 9 30 78 KAL3931286.1 MAG: hypothetical protein SGPRY_001188 [Prymnesium sp.] diamond 147 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
31351930 31351930 PRJNA924320_S_NODE_21296_length_226_cov_1.440678_g21154_i0 PRJNA924320 21296 226 1.440678 3.25593228 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 92 7.5e-20   NR KAG8466613.1 2081491 g21154 i0 52 1.99115044247788 75 31 99.6 2 226 2 300 369 KAG8466613.1 hypothetical protein KFE25_007992 [Diacronema lutheri] diamond 450 92 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31383646 31383646 PRJNA924320_S_NODE_55656_length_162_cov_0.902655_g55514_i0 PRJNA924320 55656 162 0.902655 1.4623011 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 42.7 0.0129   NR KOO28205.1 1460289 g55514 i0 47.7 1.64814814814815 44 23 81.5 0 150 19 601 644 KOO28205.1 hypothetical protein Ctob_000829 [Chrysochromulina tobinii] diamond 267 42.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31699828 31699828 PRJNA924320_S_NODE_19837_length_232_cov_1.950820_g19695_i0 PRJNA924320 19837 232 1.95082 4.5259024 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 69.7 9.49e-12   NR KAJ1617743.1 483367 g19695 i0 44 2.90948275862069 75 42 97 0 230 6 315 389 KAJ1617743.1 Bystin-domain-containing protein [Pavlovales sp. CCMP2436] diamond 675 69.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31984457 31984457 PRJNA924320_S_NODE_55098_length_162_cov_0.902655_g54956_i0 PRJNA924320 55098 162 0.902655 1.4623011 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 70.5 2.09e-12   NR KAL3918846.1 2812485 g54956 i0 56.6 2.94444444444444 53 23 98.1 0 159 1 87 139 KAL3918846.1 MAG: hypothetical protein SGPRY_005850, partial [Prymnesium sp.] diamond 477 70.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32395951 32395951 PRJNA924320_S_NODE_8099_length_340_cov_3.085911_g7957_i0 PRJNA924320 8099 340 3.085911 10.4920974 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 47.4 0.00274   NR KAL3921810.1 2812485 g7957 i0 35.1 1.19117647058824 74 46 64.4 2 100 318 50 122 KAL3921810.1 MAG: hypothetical protein SGPRY_004774 [Prymnesium sp.] diamond 405 47.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32900328 32900328 PRJNA924320_S_NODE_31180_length_196_cov_1.040816_g31038_i0 PRJNA924320 31180 196 1.040816 2.03999936 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 72.8 3.88e-13   NR KAG8464094.1 2081491 g31038 i0 53.8 2.05102040816327 65 30 99.5 0 2 196 30 94 KAG8464094.1 hypothetical protein KFE25_000262 [Diacronema lutheri] diamond 402 72.8 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);;