RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA278119" 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 · 19 ✖

bioproject 1

  • PRJNA278119 · 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
15673709 15673709 PRJNA278119_P_NODE_11433_length_341_cov_1.561644_g11185_i0 PRJNA278119 11433 341 1.561644 5.32520604 Isochrysis galbana 37099 Haptophyta other_Eukaryota 230 1.3899999999999995e-55   NTclustered gi|926485563|gb|KP892617.1| 37099 g11185 i0 79.811 14.0909090909091 317 62 93 2 26 341 1677 1992 Isochrysis galbana adaptor protein complex 1 or 2 subunit beta (AP12B) gene, partial cds blastn 4805 230 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana
26648416 26648416 PRJNA278119_P_NODE_32241_length_175_cov_0.936508_g31992_i0 PRJNA278119 32241 175 0.936508 1.638889 root 1 Root_unresolved Root_unresolved 71.6 4.93e-13   NR XP_005759087.1 280463 g31992 i0 61.8 1.88571428571429 55 21 94.3 0 2 166 182 236 XP_005759087.1 hypothetical protein EMIHUDRAFT_249770 [Emiliania huxleyi CCMP1516] diamond 330 72 0.994444444444444 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26743225 26743225 PRJNA278119_P_NODE_44821_length_163_cov_1.149123_g44572_i0 PRJNA278119 44821 163 1.149123 1.87307049 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 97.8 1.07e-22   NR KAL1503664.1 97485 g44572 i0 81.1 41.9263803680982 53 10 97.5 0 161 3 7 59 KAL1503664.1 hypothetical protein AB1Y20_012137 [Prymnesium parvum] diamond 6834 98.6 0.991886409736308 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27123078 27123078 PRJNA278119_P_NODE_31182_length_177_cov_2.226562_g30933_i0 PRJNA278119 31182 177 2.226562 3.94101474 root 1 Root_unresolved Root_unresolved 73.6 2.04e-13   NR KAL1527886.1 97485 g30933 i0 67.2 13.7118644067797 58 19 98.3 0 176 3 126 183 KAL1527886.1 hypothetical protein AB1Y20_009262 [Prymnesium parvum] diamond 2427 73.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27453511 27453511 PRJNA278119_P_NODE_37803_length_167_cov_1.322034_g37554_i0 PRJNA278119 37803 167 1.322034 2.20779678 Prymnesium parvum 97485 Haptophyta other_Eukaryota 80.5 1.87e-17   NR KAL1523551.1 97485 g37554 i0 69.1 0.988023952095808 55 17 98.8 0 2 166 64 118 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 165 80.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27471135 27471135 PRJNA278119_P_NODE_45843_length_163_cov_0.912281_g45594_i0 PRJNA278119 45843 163 0.912281 1.48701803 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.2 7.34e-4   NR KAL1522522.1 97485 g45594 i0 48.9 2.68711656441718 47 21 86.5 1 12 152 445 488 KAL1522522.1 hypothetical protein AB1Y20_017509 [Prymnesium parvum] diamond 438 46.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27895203 27895203 PRJNA278119_P_NODE_11545_length_339_cov_1.417241_g11297_i0 PRJNA278119 11545 339 1.417241 4.80444699 Prymnesium parvum 97485 Haptophyta other_Eukaryota 138 1.95e-37   NR KAL1511027.1 97485 g11297 i0 63.1 2.8141592920354 111 41 98.2 0 2 334 46 156 KAL1511027.1 hypothetical protein AB1Y20_005852 [Prymnesium parvum] diamond 954 138 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28260166 28260166 PRJNA278119_P_NODE_31126_length_178_cov_1.116279_g30877_i0 PRJNA278119 31126 178 1.116279 1.98697662 root 1 Root_unresolved Root_unresolved 71.6 4.47e-13   NR KAL1496463.1 97485 g30877 i0 65.4 1.83707865168539 52 18 87.6 0 21 176 11 62 KAL1496463.1 hypothetical protein AB1Y20_016417 [Prymnesium parvum] diamond 327 72 0.994444444444444 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28400538 28400538 PRJNA278119_P_NODE_23186_length_205_cov_1.653846_g22937_i0 PRJNA278119 23186 205 1.653846 3.3903843 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 55.8 5.27e-7   NR KOO28486.1 1460289 g22937 i0 60.8 0.746341463414634 51 20 74.6 0 158 6 210 260 KOO28486.1 mhck ef2 kinase domain family protein [Chrysochromulina tobinii] diamond 153 55.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29758115 29758115 PRJNA278119_P_NODE_9711_length_376_cov_2.039755_g9464_i0 PRJNA278119 9711 376 2.039755 7.6694788 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 52.8 4.65e-5   NR KAG8465884.1 2081491 g9464 i0 45.9 0.486702127659574 61 31 48.7 1 198 16 74 132 KAG8465884.1 hypothetical protein KFE25_005454 [Diacronema lutheri] diamond 183 52.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30136899 30136899 PRJNA278119_P_NODE_36492_length_168_cov_0.873950_g36243_i0 PRJNA278119 36492 168 0.87395 1.468236 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 70.9 1.67e-12   NR KAG8462182.1 2081491 g36243 i0 64.4 0.803571428571429 45 16 80.4 0 1 135 752 796 KAG8462182.1 hypothetical protein KFE25_011632 [Diacronema lutheri] diamond 135 70.9 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30534046 30534046 PRJNA278119_P_NODE_15453_length_274_cov_0.888889_g15204_i0 PRJNA278119 15453 274 0.888889 2.43555586 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 150 2.58e-40   NR KOO25970.1 1460289 g15204 i0 78.9 4.97080291970803 90 19 98.5 0 5 274 80 169 KOO25970.1 intraflagellar transport protein ift88 [Chrysochromulina tobinii] diamond 1362 150 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31116482 31116482 PRJNA278119_P_NODE_22235_length_210_cov_1.267081_g21986_i0 PRJNA278119 22235 210 1.267081 2.6608701 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 44.3 0.00676   NR KAL3905499.1 2812485 g21986 i0 42.6 1.92857142857143 68 38 97.1 1 2 205 263 329 KAL3905499.1 MAG: hypothetical protein SGPRY_010888, partial [Prymnesium sp.] diamond 405 44.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
31875580 31875580 PRJNA278119_P_NODE_16077_length_265_cov_1.157407_g15828_i0 PRJNA278119 16077 265 1.157407 3.06712855 Prymnesium parvum 97485 Haptophyta other_Eukaryota 52.8 1.37e-5   NR KAL1524795.1 97485 g15828 i0 60 0.452830188679245 40 16 45.3 0 2 121 318 357 KAL1524795.1 hypothetical protein AB1Y20_019675 [Prymnesium parvum] diamond 120 52.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31988308 31988308 PRJNA278119_P_NODE_8958_length_394_cov_1.513043_g8711_i0 PRJNA278119 8958 394 1.513043 5.96138942 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 109 1.02e-24   NR KAL1522522.1 97485 g8711 i0 50.5 1.56091370558376 105 52 79.9 0 37 351 859 963 KAL1522522.1 hypothetical protein AB1Y20_017509 [Prymnesium parvum] diamond 615 110 0.990909090909091 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32083233 32083233 PRJNA278119_P_NODE_11958_length_331_cov_2.003546_g11710_i0 PRJNA278119 11958 331 2.003546 6.63173726 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 128 3.2699999999999996e-32   NR KAL1504882.1 97485 g11710 i0 67.9 3.89728096676737 84 27 76.1 0 8 259 291 374 KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum] diamond 1290 128 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32413761 32413761 PRJNA278119_P_NODE_31719_length_176_cov_1.228346_g31470_i0 PRJNA278119 31719 176 1.228346 2.16188896 Prymnesium parvum 97485 Haptophyta other_Eukaryota 75.9 3.15e-14   NR KAL1512381.1 97485 g31470 i0 53.4 0.988636363636364 58 27 98.9 0 174 1 116 173 KAL1512381.1 hypothetical protein AB1Y20_005639 [Prymnesium parvum] diamond 174 75.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32634512 32634512 PRJNA278119_P_NODE_24940_length_198_cov_1.046980_g24691_i0 PRJNA278119 24940 198 1.04698 2.0730204 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 52.8 5.93e-6   NR KAL3930625.1 2812485 g24691 i0 44.8 1.01515151515152 67 32 98.5 2 196 2 111 174 KAL3930625.1 MAG: hypothetical protein SGPRY_001459 [Prymnesium sp.] diamond 201 52.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32886496 32886496 PRJNA278119_P_NODE_31580_length_176_cov_2.007874_g31331_i0 PRJNA278119 31580 176 2.007874 3.53385824 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 106 5.93e-26   NR KOO23867.1 1460289 g31331 i0 87.9 1.97727272727273 58 7 98.9 0 176 3 126 183 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 348 106 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);;