RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA565584 · 7 ✖

analysis 1

  • blastn · 7 ✖

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

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