RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 15 ✖

bioproject 1

  • PRJNA980585 · 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
3505504 3505504 PRJNA980585_P_NODE_43923_length_249_cov_2.926136_g43669_i0 PRJNA980585 43923 249 2.926136 7.28607864 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 187 5.919999999999998e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g43669 i0 95 50.6385542168675 120 5 48 1 3 122 1981 2099 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 12609 187 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
4782678 4782678 PRJNA980585_P_NODE_17564_length_339_cov_1.672932_g17310_i0 PRJNA980585 17564 339 1.672932 5.67123948 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 126 1.86e-24   NTclustered gi|551591779|ref|XM_005780021.1| 280463 g17310 i0 88.571 31.5398230088496 105 11 31 1 1 105 650 753 Emiliania huxleyi CCMP1516 14-3-3 protein mRNA blastn 10692 126 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6058230 6058230 PRJNA980585_P_NODE_42725_length_250_cov_0.870056_g42471_i0 PRJNA980585 42725 250 0.870056 2.17514 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 191 4.6e-44   NTclustered gi|551544815|ref|XM_005760393.1| 280463 g42471 i0 80.62 1.688 258 40 100 8 1 250 511 256 Emiliania huxleyi CCMP1516 light harvesting protein (Lhcf24), mRNA blastn 422 191 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
7332584 7332584 PRJNA980585_P_NODE_3506_length_656_cov_2.778731_g3255_i0 PRJNA980585 3506 656 2.778731 18.22847536 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 204 1.6999999999999996e-47   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g3255 i0 79.252 10.7865853658537 294 59 45 2 98 390 112 404 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 7076 204 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
7332603 7332603 PRJNA980585_P_NODE_35906_length_263_cov_1.589474_g35652_i0 PRJNA980585 35906 263 1.589474 4.18031662 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 183 8.16e-42   NTclustered gi|551573510|ref|XM_005772502.1| 280463 g35652 i0 80.469 74.6121673003802 256 37 97 8 10 263 148 392 Emiliania huxleyi CCMP1516 peptidyl-prolyl cis-trans isomerase putative cyclophilin protein partial mRNA blastn 19623 183 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8607801 8607801 PRJNA980585_P_NODE_41487_length_251_cov_0.865169_g41233_i0 PRJNA980585 41487 251 0.865169 2.17157419 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 73.1 1.75e-8   NTclustered gi|551550691|ref|XM_005762783.1| 280463 g41233 i0 100 5.11553784860558 39 0 16 0 211 249 625 587 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1284 73.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11158511 11158511 PRJNA980585_P_NODE_53749_length_244_cov_2.257310_g53495_i0 PRJNA980585 53749 244 2.25731 5.5078364 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 255 1.5600000000000001e-63   NTclustered gi|551613833|ref|XM_005787831.1| 280463 g53495 i0 86.134 56.2540983606557 238 31 97 2 6 242 382 146 Emiliania huxleyi CCMP1516 putative EF-1 alpha/Tu like protein (EFG1), mRNA blastn 13726 255 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11158608 11158608 PRJNA980585_P_NODE_60409_length_241_cov_0.916667_g60155_i0 PRJNA980585 60409 241 0.916667 2.20916747 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 185 2.0499999999999998e-42   NTclustered gi|551537251|ref|XM_005757197.1| 280463 g60155 i0 83.838 3.98755186721992 198 29 82 2 10 207 175 369 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 961 185 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
11158669 11158669 PRJNA980585_P_NODE_7969_length_464_cov_1.276215_g7715_i0 PRJNA980585 7969 464 1.276215 5.9216376 Raphidocystis ambigua 212535 Root_unresolved Root_unresolved 372 3.05e-98   NTclustered gi|29647995|gb|AF534708.1| 212535 g7715 i0 81.743 42.801724137931 482 54 100 28 1 464 1587 2052 Raphidiophrys ambigua 18S ribosomal RNA gene, partial sequence blastn 19860 372 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis ambigua
13708352 13708352 PRJNA980585_P_NODE_31311_length_276_cov_1.443350_g31057_i0 PRJNA980585 31311 276 1.44335 3.983646 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 58.4 5.45e-4   NTclustered gi|551550269|ref|XM_005762608.1| 280463 g31057 i0 83.871 1.03623188405797 62 8 22 2 40 101 2095 2036 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 286 58.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16571817 16571817 PRJNA980585_P_NODE_23113_length_305_cov_2.344828_g22859_i0 PRJNA980585 23113 305 2.344828 7.1517254 Pterocystida 2607628 Root_unresolved Root_unresolved 303 7.11e-78   NTclustered gi|61187375|gb|AY752993.1| 299886 g22859 i0 97.207 64.0983606557377 179 5 59 0 16 194 3380 3202 Pterocystis tropica 28S ribosomal RNA gene, partial sequence blastn 19550 303 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Pterocystis Pterocystis tropica
17532419 17532419 PRJNA980585_P_NODE_15294_length_357_cov_1.725352_g15040_i0 PRJNA980585 15294 357 1.725352 6.15950664 Acanthocystis sp. Oxford8 299876 Root_unresolved Root_unresolved 427 4.81e-115   NTclustered gi|55469153|gb|AY749626.1| 299876 g15040 i0 90.606 44.078431372549 330 19 90 7 25 346 326 1 Acanthocystis sp. Oxford8 18S ribosomal RNA gene, partial sequence blastn 15736 427 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. Oxford8
20081774 20081774 PRJNA980585_P_NODE_6536_length_505_cov_1.212963_g6282_i0 PRJNA980585 6536 505 1.212963 6.12546315 Raphidiophrys sp. Whale Bay 299893 Root_unresolved Root_unresolved 440 9.019999999999997e-119   NTclustered gi|55469146|gb|AY749619.1| 299893 g6282 i0 88.235 55.1623762376238 391 17 73 16 87 456 1225 843 Raphidiophrys sp. Whale Bay 18S ribosomal RNA gene, partial sequence blastn 27857 440 1 Eukaryota Haptista     Centroplasthelida Pterocystida Raphidiophryidae Raphidiophrys Raphidiophrys sp. Whale Bay
21357280 21357280 PRJNA980585_P_NODE_8057_length_461_cov_3.420103_g7803_i0 PRJNA980585 8057 461 3.420103 15.76667483 Dicrateria rotunda 2703868 Haptophyta other_Eukaryota 442 2.2699999999999988e-119   NTclustered gi|259419544|emb|FN392559.1| 2703868 g7803 i0 86.717 90.8329718004338 399 51 86 2 37 434 40 437 Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068 blastn 41874 442 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Dicrateria Dicrateria rotunda
23907537 23907537 PRJNA980585_P_NODE_50499_length_246_cov_0.890173_g50245_i0 PRJNA980585 50499 246 0.890173 2.18982558 Acanthocystis sp. Hinksey Lake 299879 Root_unresolved Root_unresolved 303 5.56e-78   NTclustered gi|55469156|gb|AY749629.1| 299879 g50245 i0 92.925 33.0975609756098 212 10 85 5 39 246 895 1105 Acanthocystis sp. Hinksey Lake 18S ribosomal RNA gene, partial sequence blastn 8142 303 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. Hinksey Lake

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