RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA641707", tax_clade = "Haptista" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 19 ✖

tax_clade 1

  • Haptista · 19 ✖

bioproject 1

  • PRJNA641707 · 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
6992342 6992342 PRJNA641707_P_NODE_235026_length_188_cov_6.669065_g232363_i0 PRJNA641707 235026 188 6.669065 12.5378422 Chrysotila carterae 13221 Haptophyta other_Eukaryota 154 4.29e-33   NTclustered gi|238617648|gb|FJ973403.1| 13221 g232363 i0 94.898 52.281914893617 98 5 52 0 2 99 104 7 Pleurochrysis carterae strain CCMP 874 alpha-tubulin (atub) gene, partial cds blastn 9829 154 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Chrysotila Chrysotila carterae
7534993 7534993 PRJNA641707_P_NODE_246306_length_184_cov_1.474074_g243643_i0 PRJNA641707 246306 184 1.474074 2.71229616 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 209 8.8e-50   NTclustered gi|2059554211|gb|MZ469752.1| 1907791 g243643 i0 88.824 1.84782608695652 170 19 92 0 1 170 334 165 Phaeocystis sp. strain DAD-ALGEUK-24 large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 340 209 1 Eukaryota Haptista   Haptophyta   Phaeocystales Phaeocystaceae Phaeocystis Phaeocystis sp.
10086528 10086528 PRJNA641707_P_NODE_52688_length_296_cov_5.611336_g50029_i0 PRJNA641707 52688 296 5.611336 16.60955456 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 71.3 7.59e-8   NTclustered gi|194145918|gb|EU615885.1| 171259 g50029 i0 100 15.0641891891892 38 0 13 0 8 45 740 777 Uncultured haptophyte clone MV5_19_35 28S ribosomal RNA gene, partial sequence blastn 4459 71.3 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
11360638 11360638 PRJNA641707_P_NODE_265769_length_176_cov_2.716535_g263106_i0 PRJNA641707 265769 176 2.716535 4.7811016 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 53.1 4.6e-7   NR KOO29468.1 1460289 g263106 i0 75.7 0.630681818181818 37 9 63.1 0 24 134 78 114 KOO29468.1 ubiquitin [Chrysochromulina tobinii] diamond 111 53.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
15914158 15914158 PRJNA641707_P_NODE_120913_length_245_cov_6.979592_g118250_i0 PRJNA641707 120913 245 6.979592 17.1000004 Diacronema 70451 Haptophyta other_Eukaryota 98.2 1.19e-21   NR KAJ1637937.1 483367 g118250 i0 67.9 2.88979591836735 78 18 95.5 1 242 9 780 850 KAJ1637937.1 hypothetical protein T492DRAFT_1137168 [Pavlovales sp. CCMP2436] diamond 708 99 0.991919191919192 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
22293333 22293333 PRJNA641707_P_NODE_339198_length_150_cov_6.811881_g336535_i0 PRJNA641707 339198 150 6.811881 10.2178215 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 54.7 0.003   NTclustered gi|551583694|ref|XM_005777204.1| 280463 g336535 i0 100 0.773333333333333 29 0 19 0 23 51 707 679 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 116 54.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26764689 26764689 PRJNA641707_P_NODE_80181_length_246_cov_8.263959_g77518_i0 PRJNA641707 80181 246 8.263959 20.32933914 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 62.8 1.07e-10   NR XP_005773968.1 280463 g77518 i0 81.3 1.90243902439024 32 6 39 0 96 1 2 33 XP_005773968.1 hypothetical protein EMIHUDRAFT_74860 [Emiliania huxleyi CCMP1516] diamond 468 62.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27270720 27270720 PRJNA641707_P_NODE_203343_length_197_cov_2.709459_g200680_i0 PRJNA641707 203343 197 2.709459 5.33763423 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 42.7 0.0208   NR XP_005780257.1 280463 g200680 i0 37.1 0.944162436548223 62 35 94.4 1 190 5 812 869 XP_005780257.1 hypothetical protein EMIHUDRAFT_450099 [Emiliania huxleyi CCMP1516] diamond 186 42.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27270744 27270744 PRJNA641707_P_NODE_235283_length_188_cov_5.791367_g232620_i0 PRJNA641707 235283 188 5.791367 10.88776996 Prymnesium parvum 97485 Haptophyta other_Eukaryota 48.9 1.22e-4   NR KAL1521937.1 97485 g232620 i0 40.7 0.861702127659574 54 29 86.2 1 13 174 94 144 KAL1521937.1 hypothetical protein AB1Y20_021585 [Prymnesium parvum] diamond 162 48.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28123462 28123462 PRJNA641707_P_NODE_295805_length_165_cov_6.637931_g293142_i0 PRJNA641707 295805 165 6.637931 10.95258615 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 48.5 1.18e-4   NR KAG8466028.1 2081491 g293142 i0 55.6 0.654545454545455 36 16 65.5 0 2 109 140 175 KAG8466028.1 hypothetical protein KFE25_005598 [Diacronema lutheri] diamond 108 48.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28344371 28344371 PRJNA641707_P_NODE_207306_length_196_cov_5.231293_g204643_i0 PRJNA641707 207306 196 5.231293 10.25333428 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 53.1 2.2e-6   NR KAJ1628850.1 483367 g204643 i0 39.2 1.20918367346939 79 31 94.9 1 7 192 72 150 KAJ1628850.1 tryptophan synthase beta subunit-like PLP-dependent enzyme, partial [Pavlovales sp. CCMP2436] diamond 237 53.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28439258 28439258 PRJNA641707_P_NODE_196446_length_198_cov_4.382550_g193783_i0 PRJNA641707 196446 198 4.38255 8.677449 Prymnesium parvum 97485 Haptophyta other_Eukaryota 47 6.76e-4   NR KAL1503688.1 97485 g193783 i0 38.2 1.63636363636364 55 28 83.3 1 177 13 80 128 KAL1503688.1 hypothetical protein AB1Y20_012161 [Prymnesium parvum] diamond 324 47 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28754926 28754926 PRJNA641707_P_NODE_299187_length_164_cov_8.513043_g296524_i0 PRJNA641707 299187 164 8.513043 13.96139052 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 44.3 0.00112   NR XP_005761064.1 280463 g296524 i0 43.1 2.14024390243902 51 28 93.3 1 153 1 3 52 XP_005761064.1 hypothetical protein EMIHUDRAFT_358841 [Emiliania huxleyi CCMP1516] diamond 351 44.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29619313 29619313 PRJNA641707_P_NODE_123950_length_245_cov_4.586735_g121287_i0 PRJNA641707 123950 245 4.586735 11.23750075 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.1 0.0283   NR XP_005759422.1 280463 g121287 i0 65.5 0.722448979591837 29 10 35.5 0 237 151 719 747 XP_005759422.1 putative ABC transporter [Emiliania huxleyi CCMP1516] diamond 177 43.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29670104 29670104 PRJNA641707_P_NODE_179370_length_200_cov_5.682119_g176707_i0 PRJNA641707 179370 200 5.682119 11.364238 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 55.5 6.53e-7   NR XP_005760681.1 280463 g176707 i0 74.3 0.525 35 9 52.5 0 105 1 13 47 XP_005760681.1 vacuolar H+-ATPase V0 sector, subunit D [Emiliania huxleyi CCMP1516] diamond 105 55.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29967179 29967179 PRJNA641707_P_NODE_200391_length_197_cov_7.628378_g197728_i0 PRJNA641707 200391 197 7.628378 15.02790466 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 59.7 2.15e-8   NR KAL1507020.1 97485 g197728 i0 69.7 6.03045685279188 33 10 50.3 0 116 18 1959 1991 KAL1507020.1 hypothetical protein AB1Y20_007882 [Prymnesium parvum] diamond 1188 59.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32199290 32199290 PRJNA641707_P_NODE_245158_length_184_cov_5.962963_g242495_i0 PRJNA641707 245158 184 5.962963 10.97185192 Prymnesium parvum 97485 Haptophyta other_Eukaryota 57.8 7.98e-8   NR KAL1528040.1 97485 g242495 i0 59.1 4.33695652173913 44 17 71.7 1 180 49 296 338 KAL1528040.1 hypothetical protein AB1Y20_009409 [Prymnesium parvum] diamond 798 57.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32641556 32641556 PRJNA641707_P_NODE_242140_length_185_cov_8.985294_g239477_i0 PRJNA641707 242140 185 8.985294 16.6227939 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 58.5 6.3e-9   NR KAG8467390.1 2081491 g239477 i0 61.4 1.52432432432432 44 17 71.4 0 133 2 5 48 KAG8467390.1 hypothetical protein KFE25_000706 [Diacronema lutheri] diamond 282 58.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32893532 32893532 PRJNA641707_P_NODE_176960_length_200_cov_8.556291_g174297_i0 PRJNA641707 176960 200 8.556291 17.112582 Prymnesium parvum 97485 Haptophyta other_Eukaryota 45.4 0.0024   NR KAL1503316.1 97485 g174297 i0 54.5 0.495 33 15 49.5 0 195 97 811 843 KAL1503316.1 hypothetical protein AB1Y20_011368 [Prymnesium parvum] diamond 99 45.4 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);;