RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 22 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 22 ✖

analysis 1

  • blastn · 22 ✖

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
1401718 1401718 PRJEB64798_P_NODE_157162_length_185_cov_1.419118_g155396_i0 PRJEB64798 157162 185 1.419118 2.6253683 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 117 5.5200000000000005e-22   NTclustered gi|551606591|ref|XM_005784584.1| 280463 g155396 i0 79.885 64.1351351351351 174 23 92 9 6 176 419 255 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 11865 117 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
2679216 2679216 PRJEB64798_P_NODE_49543_length_278_cov_33.908297_g47778_i0 PRJEB64798 49543 278 33.908297 94.26506566 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 100 9.01e-17   NTclustered gi|1771196870|dbj|LC507231.1| 171259 g47778 i0 96.667 21.1618705035971 60 2 22 0 200 259 186 127 Haptophyta environmental samples OTU035_Lake Takahoko gene for 18S ribosomal RNA, partial sequence blastn 5883 100 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
3543548 3543548 PRJEB64798_P_NODE_172463_length_177_cov_17.273438_g170697_i0 PRJEB64798 172463 177 17.273438 30.57398526 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 124 3.12e-24   NTclustered gi|551571117|ref|XM_005771409.1| 280463 g170697 i0 80.357 4.38418079096045 168 30 94 3 10 175 336 170 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 776 124 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4820642 4820642 PRJEB64798_P_NODE_110044_length_210_cov_5.944099_g108278_i0 PRJEB64798 110044 210 5.944099 12.4826079 Pavlovaceae 418969 Haptophyta other_Eukaryota 91.6 3.91e-14   NTclustered gi|321401323|gb|HQ908424.1| 2081491 g108278 i0 90 1.51428571428571 70 7 33 0 8 77 1946 1877 Pavlova lutheri strain CCMP 1325 mitochondrion, partial genome blastn 318 91.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
6096165 6096165 PRJEB64798_P_NODE_171805_length_178_cov_2.232558_g170039_i0 PRJEB64798 171805 178 2.232558 3.97395324 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 100 5.3e-17   NTclustered gi|9885780|gb|AF289038.1|AF289038 35144 g170039 i0 78.912 6.01685393258427 147 31 83 0 1 147 2611 2465 Prymnesium patelliferum internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 1071 100 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
6506042 6506042 PRJEB64798_P_NODE_196446_length_168_cov_4.722689_g194680_i0 PRJEB64798 196446 168 4.722689 7.93411752 Diacronema sp. 2812047 Haptophyta other_Eukaryota 270 3.5799999999999998e-68   NTclustered gi|2250364170|gb|ON714941.1| 2812047 g194680 i0 96.341 87.8928571428571 164 6 98 0 2 165 173 10 Diacronema sp. isolate OTU_266 small subunit ribosomal RNA gene, partial sequence blastn 14766 270 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema sp.
6506655 6506655 PRJEB64798_P_NODE_239926_length_155_cov_4.000000_g238160_i0 PRJEB64798 239926 155 4 6.2 Isochrysis galbana 37099 Haptophyta other_Eukaryota 209 7.15e-50   NTclustered gi|638920537|gb|KF953490.1| 37099 g238160 i0 91.946 94.2387096774194 149 12 96 0 1 149 332 184 Isochrysis galbana alpha-tubulin mRNA, partial cds blastn 14607 209 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana
7780030 7780030 PRJEB64798_P_NODE_182507_length_173_cov_4.758065_g180741_i0 PRJEB64798 182507 173 4.758065 8.23145245 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 195 2.28e-45   NTclustered gi|551544771|ref|XM_005760371.1| 280463 g180741 i0 88.415 49.3179190751445 164 15 94 4 6 167 85 246 Emiliania huxleyi CCMP1516 ADP-ribosylation factor (Arf1), partial mRNA blastn 8532 195 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
7781193 7781193 PRJEB64798_P_NODE_35627_length_330_cov_83.569395_g33869_i0 PRJEB64798 35627 330 83.569395 275.7790035 Pavlova gyrans 44452 Haptophyta other_Eukaryota 274 6.09e-69   NTclustered gi|238617593|gb|FJ973368.1| 44452 g33869 i0 82.544 101.163636363636 338 34 99 18 1 328 1228 906 Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence blastn 33384 274 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Pavlova Pavlova gyrans
10330532 10330532 PRJEB64798_P_NODE_172489_length_177_cov_15.695312_g170723_i0 PRJEB64798 172489 177 15.695312 27.78070224 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 211 2.33e-50   NTclustered gi|551564199|ref|XM_005768624.1| 280463 g170723 i0 93.617 73.8757062146893 141 9 80 0 1 141 210 350 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 13076 211 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
10331311 10331311 PRJEB64798_P_NODE_226589_length_160_cov_3.225225_g224823_i0 PRJEB64798 226589 160 3.225225 5.16036 Haptophyceae sp. NIES-3900 2748608 Haptophyta other_Eukaryota 84.2 4.71e-12   NTclustered gi|1941608488|dbj|LC564893.1| 2748608 g224823 i0 84.706 1.575 85 11 53 2 27 110 98434 98351 Haptophyceae sp. NIES-3900 chloroplast DNA, complete genome blastn 252 84.2 1 Eukaryota Haptista   Haptophyta         Haptophyceae sp. NIES-3900
10332523 10332523 PRJEB64798_P_NODE_72169_length_227_cov_7.657303_g70404_i0 PRJEB64798 72169 227 7.657303 17.38207781 Haptolina brevifila 156173 Haptophyta other_Eukaryota 89.8 1.54e-13   NTclustered gi|303431894|emb|AM490995.2| 156173 g70404 i0 80.342 22.1057268722467 117 19 51 4 110 224 133 19 Haptolina brevifilum partial 18S rRNA gene, strain Kawachi, Japan blastn 5018 89.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Haptolina Haptolina brevifila
11197008 11197008 PRJEB64798_P_NODE_66669_length_237_cov_14.191489_g64904_i0 PRJEB64798 66669 237 14.191489 33.63382893 Phaeocystis 33656 Haptophyta other_Eukaryota 86.1 2.1e-12   NTclustered gi|9885782|gb|AF289040.1|AF289040 33657 g64904 i0 94.545 4.11814345991561 55 3 23 0 176 230 199 145 Phaeocystis antarctica internal transcribed spacer 2, partial sequence; and 28S ribosomal RNA gene, complete sequence blastn 976 86.1 1 Eukaryota Haptista   Haptophyta   Phaeocystales Phaeocystaceae Phaeocystis Phaeocystis antarctica
11605867 11605867 PRJEB64798_P_NODE_167750_length_180_cov_1.190840_g165984_i0 PRJEB64798 167750 180 1.19084 2.143512 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 161 2.43e-35   NTclustered gi|551576855|ref|XM_005774014.1| 280463 g165984 i0 84 0.972222222222222 175 20 95 6 8 178 934 1104 Emiliania huxleyi CCMP1516 L-Rhamnonate dehydratase mRNA blastn 175 161 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
12881253 12881253 PRJEB64798_P_NODE_182911_length_173_cov_3.330645_g181145_i0 PRJEB64798 182911 173 3.330645 5.76201585 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 69.4 1.44e-7   NTclustered gi|551614683|ref|XM_005788194.1| 280463 g181145 i0 80.22 1.57803468208092 91 18 53 0 79 169 808 898 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 273 69.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13747123 13747123 PRJEB64798_P_NODE_72931_length_226_cov_3.666667_g71166_i0 PRJEB64798 72931 226 3.666667 8.28666742 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 60.2 1.2e-4   NTclustered gi|9885782|gb|AF289040.1|AF289040 33657 g71166 i0 97.143 7.85398230088496 35 1 15 0 1 35 165 199 Phaeocystis antarctica internal transcribed spacer 2, partial sequence; and 28S ribosomal RNA gene, complete sequence blastn 1775 60.2 1 Eukaryota Haptista   Haptophyta   Phaeocystales Phaeocystaceae Phaeocystis Phaeocystis antarctica
14155278 14155278 PRJEB64798_P_NODE_13492_length_543_cov_47.785425_g11845_i0 PRJEB64798 13492 543 47.785425 259.47485775 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 121 1.44e-22   NTclustered gi|822590914|gb|KR338468.1| 171259 g11845 i0 76.327 25.7053406998158 245 46 44 11 305 543 464 702 Uncultured haptophyte clone 7BDCM04 18S ribosomal RNA gene, partial sequence blastn 13958 121 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
15430850 15430850 PRJEB64798_P_NODE_240973_length_155_cov_2.283019_g239207_i0 PRJEB64798 240973 155 2.283019 3.53867945 Diacronema viridis 2793420 Haptophyta other_Eukaryota 100 4.49e-17   NTclustered gi|1941799838|gb|MW044630.1| 2793420 g239207 i0 81.301 1.58709677419355 123 23 79 0 25 147 28016 27894 Diacronema viridis mitochondrion, complete genome blastn 246 100 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema viridis
16295656 16295656 PRJEB64798_P_NODE_16853_length_485_cov_20.694954_g15150_i0 PRJEB64798 16853 485 20.694954 100.3705269 Phaeocystis 33656 Haptophyta other_Eukaryota 167 1.6200000000000002e-36   NTclustered gi|1074200956|dbj|LC189148.1| 118080 g15150 i0 91.803 39.379381443299 122 6 40 4 263 383 1330 1448 Phaeocystis jahnii gene for 18S ribosomal RNA, partial sequence, strain: NIES-3884 blastn 19099 167 1 Eukaryota Haptista   Haptophyta   Phaeocystales Phaeocystaceae Phaeocystis Phaeocystis jahnii
17979882 17979882 PRJEB64798_P_NODE_233855_length_157_cov_5.083333_g232089_i0 PRJEB64798 233855 157 5.083333 7.98083281 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 172 9.53e-39   NTclustered gi|551539306|ref|XM_005758086.1| 280463 g232089 i0 87.013 91.6242038216561 154 18 97 2 4 156 322 474 Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA blastn 14385 172 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
19252755 19252755 PRJEB64798_P_NODE_156096_length_185_cov_5.125000_g154330_i0 PRJEB64798 156096 185 5.125 9.48125 Chrysochromulina sp. 2200936 Haptophyta other_Eukaryota 267 5.18e-67   NTclustered gi|2059554223|gb|MZ469764.1| 2200936 g154330 i0 93.37 102.048648648649 181 11 97 1 1 180 393 213 Chrysochromulina sp. strain DAD-ALGEUK-36 large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 18879 267 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina sp.
25218854 25218854 PRJEB64798_P_NODE_123000_length_204_cov_4.193548_g121234_i0 PRJEB64798 123000 204 4.193548 8.55483792 Pavlovaceae 418969 Haptophyta other_Eukaryota 63.9 8.22e-6   NTclustered gi|321401323|gb|HQ908424.1| 2081491 g121234 i0 83.824 1.36274509803922 68 9 32 2 110 175 1423 1356 Pavlova lutheri strain CCMP 1325 mitochondrion, partial genome blastn 278 63.9 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);;