RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA415856 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
2359059 2359059 PRJNA415856_P_NODE_6162_length_381_cov_5.216867_g5901_i0 PRJNA415856 6162 381 5.216867 19.87626327 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 562 1.36e-155   NTclustered gi|2530650642|gb|ON844104.1| 2903 g5901 i0 93.455 188.275590551181 382 19 100 5 1 381 89704 89328 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 71733 562 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
2969863 2969863 PRJNA415856_P_NODE_12283_length_249_cov_1.865000_g12022_i0 PRJNA415856 12283 249 1.865 4.64385 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 451 1.9e-122   NTclustered gi|551614683|ref|XM_005788194.1| 280463 g12022 i0 99.203 32.1686746987952 251 0 100 1 1 249 87 337 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 8010 451 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
3634274 3634274 PRJNA415856_P_NODE_23683_length_186_cov_1.291971_g23422_i0 PRJNA415856 23683 186 1.291971 2.40306606 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 339 1.0899999999999998e-88   NTclustered gi|283483056|emb|FM882214.1| 2903 g23422 i0 99.462 99.8978494623656 186 1 100 0 1 186 70 255 Emiliania huxleyi partial 18S rRNA gene, clone G3-53-4 blastn 18581 339 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6186470 6186470 PRJNA415856_P_NODE_26525_length_180_cov_2.038168_g26264_i0 PRJNA415856 26525 180 2.038168 3.6687024 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 333 4.87e-87   NTclustered gi|2530650642|gb|ON844104.1| 2903 g26264 i0 100 167.566666666667 180 0 100 0 1 180 88082 87903 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 30162 333 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6796933 6796933 PRJNA415856_P_NODE_16046_length_217_cov_1.821429_g15785_i0 PRJNA415856 16046 217 1.821429 3.95250093 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 377 2.78e-100   NTclustered gi|551569863|ref|XM_005770835.1| 280463 g15785 i0 99.519 76.9585253456221 208 0 95 1 11 217 951 744 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 16700 377 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8072523 8072523 PRJNA415856_P_NODE_21207_length_190_cov_2.978723_g20946_i0 PRJNA415856 21207 190 2.978723 5.6595737 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 346 6.690000000000001e-91   NTclustered gi|551564253|ref|XM_005768650.1| 280463 g20946 i0 99.474 65.7789473684211 190 1 100 0 1 190 395 206 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 12498 346 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
10011461 10011461 PRJNA415856_P_NODE_19788_length_196_cov_2.673469_g19527_i0 PRJNA415856 19788 196 2.673469 5.23999924 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 363 6.899999999999998e-96   NTclustered gi|2530650642|gb|ON844104.1| 2903 g19527 i0 100 190 196 0 100 0 1 196 88860 89055 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 37240 363 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
13837066 13837066 PRJNA415856_P_NODE_55431_length_151_cov_2.098039_g55170_i0 PRJNA415856 55431 151 2.098039 3.16803889 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 279 5.19e-71   NTclustered gi|1576971049|gb|MK542696.1| 2903 g55170 i0 100 100 151 0 100 0 1 151 971 821 Emiliania huxleyi strain RCC6071 small subunit ribosomal RNA gene, partial sequence blastn 15100 279 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16385756 16385756 PRJNA415856_P_NODE_14733_length_226_cov_1.983051_g14472_i0 PRJNA415856 14733 226 1.983051 4.48169526 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 418 1.7199999999999998e-112   NTclustered gi|2235060040|gb|OL703593.1| 2903 g14472 i0 100 163.769911504425 226 0 100 0 1 226 3977 3752 Emiliania huxleyi strain AWI1516 plastid, complete genome blastn 37012 418 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16386017 16386017 PRJNA415856_P_NODE_50953_length_161_cov_1.821429_g50692_i0 PRJNA415856 50953 161 1.821429 2.93250069 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 298 1.56e-76   NTclustered gi|2677147785|gb|PP351368.1| 2903 g50692 i0 100 99.4347826086957 161 0 100 0 1 161 316 156 Emiliania huxleyi isolate G5_Ehux_70 large subunit ribosomal RNA gene, partial sequence blastn 16009 298 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16996649 16996649 PRJNA415856_P_NODE_19834_length_196_cov_1.857143_g19573_i0 PRJNA415856 19834 196 1.857143 3.64000028 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 363 6.899999999999998e-96   NTclustered gi|551547100|ref|XM_005761350.1| 280463 g19573 i0 100 100 196 0 100 0 1 196 87 282 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 19600 363 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18934881 18934881 PRJNA415856_P_NODE_24355_length_184_cov_6.311111_g24094_i0 PRJNA415856 24355 184 6.311111 11.61244424 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 340 2.99e-89   NTclustered gi|2530650642|gb|ON844104.1| 2903 g24094 i0 100 155.184782608696 184 0 100 0 1 184 89088 89271 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 28554 340 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20209786 20209786 PRJNA415856_P_NODE_5336_length_416_cov_4.615804_g5075_i0 PRJNA415856 5336 416 4.615804 19.20174464 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 706 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g5075 i0 97.362 158.204326923077 417 8 100 3 1 416 88376 88790 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 65813 706 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24035215 24035215 PRJNA415856_P_NODE_31739_length_171_cov_2.450820_g31478_i0 PRJNA415856 31739 171 2.45082 4.1909022 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 316 4.6e-82   NTclustered gi|2530650642|gb|ON844104.1| 2903 g31478 i0 100 136 171 0 100 0 1 171 90134 90304 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 23256 316 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24035220 24035220 PRJNA415856_P_NODE_32499_length_170_cov_1.685950_g32238_i0 PRJNA415856 32499 170 1.68595 2.866115 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 315 1.64e-81   NTclustered gi|323099916|gb|HQ877901.1| 2903 g32238 i0 100 99.9823529411765 170 0 100 0 1 170 288 119 Emiliania huxleyi strain KMMCC H-18 18S ribosomal RNA gene, partial sequence blastn 16997 315 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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);;