RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 16 ✖

bioproject 1

  • PRJNA565584 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
5660844 5660844 PRJNA565584_P_NODE_48325_length_429_cov_0.755618_g47174_i0 PRJNA565584 48325 429 0.755618 3.24160122 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 754 0   NTclustered gi|259475579|emb|FN392387.1| 2792838 g47174 i0 98.368 1 429 7 100 0 1 429 432 4 Raphidiophrys contractilis partial mRNA for 60S ribosomal protein L8, contig 29379 blastn 429 754 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
5661512 5661512 PRJNA565584_P_NODE_84225_length_324_cov_1.227092_g83073_i0 PRJNA565584 84225 324 1.227092 3.97577808 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 198 3.69e-46   NTclustered gi|259475597|emb|FN392405.1| 2792838 g83073 i0 86.932 52.7469135802469 176 23 54 0 146 321 206 31 Raphidiophrys contractilis partial mRNA for 60S ribosomal protein L27a, contig plate1-E4 blastn 17090 198 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
6935760 6935760 PRJNA565584_P_NODE_80126_length_332_cov_1.509653_g78975_i0 PRJNA565584 80126 332 1.509653 5.01204796 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 350 9.9e-92   NTclustered gi|551605616|ref|XM_005784143.1| 280463 g78975 i0 85.933 97.8373493975904 327 46 98 0 6 332 1074 1400 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 32482 350 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
9485807 9485807 PRJNA565584_P_NODE_68548_length_359_cov_1.076923_g67397_i0 PRJNA565584 68548 359 1.076923 3.86615357 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 315 3.9299999999999997e-81   NTclustered gi|81230321|dbj|AB196985.1| 2792838 g67397 i0 82.5 78.983286908078 360 61 100 2 1 359 473 831 Raphidocystis contractilis gene for alpha-tubulin, partial cds blastn 28355 315 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
9486030 9486030 PRJNA565584_P_NODE_80148_length_332_cov_1.486486_g78997_i0 PRJNA565584 80148 332 1.486486 4.93513352 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 189 2.2799999999999993e-43   NTclustered gi|193811885|dbj|AB332032.1| 2792838 g78997 i0 86.55 0.515060240963855 171 23 52 0 162 332 1302 1132 Raphidocystis contractilis EFL mRNA for translation elongation factor-like protein, partial cds blastn 171 189 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
10759166 10759166 PRJNA565584_P_NODE_128169_length_276_cov_2.709360_g127017_i0 PRJNA565584 128169 276 2.70936 7.4778336 Isochrysis galbana 37099 Haptophyta other_Eukaryota 213 1.1e-50   NTclustered gi|54399511|gb|AY729486.1| 37099 g127017 i0 84.332 25.3514492753623 217 34 79 0 42 258 58 274 Isochrysis galbana EF-1 alpha-like protein (efl) mRNA, complete cds blastn 6997 213 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana
10761997 10761997 PRJNA565584_P_NODE_81129_length_330_cov_1.533074_g79977_i0 PRJNA565584 81129 330 1.533074 5.0591442 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 281 3.6400000000000004e-71   NTclustered gi|259475594|emb|FN392402.1| 2792838 g79977 i0 82.965 28.2363636363636 317 48 95 5 6 319 22 335 Raphidiophrys contractilis partial mRNA for 60S ribosomal protein L18a, contig 29317 blastn 9318 281 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
12033891 12033891 PRJNA565584_P_NODE_12670_length_930_cov_14.469078_g11680_i0 PRJNA565584 12670 930 14.469078 134.5624254 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 422 6.22e-113   NTclustered gi|551573512|ref|XM_005772503.1| 280463 g11680 i0 82.773 36.7827956989247 476 78 51 4 396 869 497 24 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 34208 422 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
12036731 12036731 PRJNA565584_P_NODE_79430_length_333_cov_2.284615_g78279_i0 PRJNA565584 79430 333 2.284615 7.60776795 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 342 1.66e-89   NTclustered gi|193811885|dbj|AB332032.1| 2792838 g78279 i0 85.802 46.3843843843844 324 44 97 2 4 326 653 975 Raphidocystis contractilis EFL mRNA for translation elongation factor-like protein, partial cds blastn 15446 342 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
14583126 14583126 PRJNA565584_P_NODE_101992_length_296_cov_1.031390_g100840_i0 PRJNA565584 101992 296 1.03139 3.0529144 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 446 1.0799999999999999e-120   NTclustered gi|193811885|dbj|AB332032.1| 2792838 g100840 i0 93.898 26.7533783783784 295 18 99 0 1 295 855 561 Raphidocystis contractilis EFL mRNA for translation elongation factor-like protein, partial cds blastn 7919 446 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
14584925 14584925 PRJNA565584_P_NODE_201732_length_244_cov_0.900585_g200580_i0 PRJNA565584 201732 244 0.900585 2.1974274 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 187 5.7799999999999984e-43   NTclustered gi|551624794|ref|XM_005792543.1| 280463 g200580 i0 88.462 22.405737704918 156 16 64 2 13 168 239 86 Emiliania huxleyi CCMP1516 40S ribosomal protein S14 partial mRNA blastn 5467 187 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14586062 14586062 PRJNA565584_P_NODE_57812_length_391_cov_1.122642_g56661_i0 PRJNA565584 57812 391 1.122642 4.38953022 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 222 2.69e-53   NTclustered gi|551613833|ref|XM_005787831.1| 280463 g56661 i0 79.257 0.826086956521739 323 63 82 4 71 391 1438 1118 Emiliania huxleyi CCMP1516 putative EF-1 alpha/Tu like protein (EFG1), mRNA blastn 323 222 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17134173 17134173 PRJNA565584_P_NODE_23834_length_640_cov_1.350970_g22702_i0 PRJNA565584 23834 640 1.35097 8.646208 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 357 1.2e-93   NTclustered gi|259475605|emb|FN392413.1| 2792838 g22702 i0 77.512 4.4171875 627 119 96 15 7 619 635 17 Raphidiophrys contractilis partial mRNA for 40S ribosomal protein S8, contig 27856 blastn 2827 357 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
17134515 17134515 PRJNA565584_P_NODE_39754_length_476_cov_1.397022_g38603_i0 PRJNA565584 39754 476 1.397022 6.64982472 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 279 1.95e-70   NTclustered gi|551584285|ref|XM_005777484.1| 280463 g38603 i0 84.429 24.5840336134454 289 39 60 5 1 286 668 953 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 11702 279 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20261044 20261044 PRJNA565584_P_NODE_206256_length_243_cov_0.905882_g205104_i0 PRJNA565584 206256 243 0.905882 2.20129326 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 71.3 6.05e-8   NTclustered gi|551555392|ref|XM_005764836.1| 280463 g205104 i0 97.561 0.703703703703704 41 1 17 0 144 184 5477 5437 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 171 71.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24783514 24783514 PRJNA565584_P_NODE_62140_length_377_cov_1.013158_g60989_i0 PRJNA565584 62140 377 1.013158 3.81960566 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 695 0   NTclustered gi|259475594|emb|FN392402.1| 2792838 g60989 i0 100 22.763925729443 376 0 99 0 1 376 191 566 Raphidiophrys contractilis partial mRNA for 60S ribosomal protein L18a, contig 29317 blastn 8582 695 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis

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