RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA724011 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3261978 3261978 PRJNA724011_P_NODE_50083_length_366_cov_1.576792_g49060_i0 PRJNA724011 50083 366 1.576792 5.77105872 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 279 1.46e-70   NTclustered gi|551556343|ref|XM_005765234.1| 280463 g49060 i0 83.224 2.47267759562842 304 51 83 0 1 304 1799 1496 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 905 279 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4538888 4538888 PRJNA724011_P_NODE_23184_length_596_cov_1.223709_g22169_i0 PRJNA724011 23184 596 1.223709 7.29330564 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 63.9 2.72e-5   NTclustered gi|551584295|ref|XM_005777489.1| 280463 g22169 i0 95 0.268456375838926 40 2 7 0 69 108 1404 1365 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 160 63.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4538970 4538970 PRJNA724011_P_NODE_34264_length_465_cov_2.081633_g33245_i0 PRJNA724011 34264 465 2.081633 9.67959345 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 224 9.05e-54   NTclustered gi|551560604|ref|XM_005767144.1| 280463 g33245 i0 86.124 2.0752688172043 209 27 45 2 22 229 1083 1290 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 965 224 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8364046 8364046 PRJNA724011_P_NODE_60767_length_327_cov_0.811024_g59744_i0 PRJNA724011 60767 327 0.811024 2.65204848 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 56.5 0.002   NTclustered gi|551581802|ref|XM_005776324.1| 280463 g59744 i0 100 0.339449541284404 30 0 9 0 8 37 627 598 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 111 56.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8364071 8364071 PRJNA724011_P_NODE_64787_length_315_cov_1.272727_g63764_i0 PRJNA724011 64787 315 1.272727 4.00909005 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 246 1.26e-60   NTclustered gi|551598387|ref|XM_005781173.1| 280463 g63764 i0 82.639 92.8730158730159 288 41 90 7 29 310 746 1030 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 29255 246 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
19837742 19837742 PRJNA724011_P_NODE_69276_length_302_cov_2.017467_g68253_i0 PRJNA724011 69276 302 2.017467 6.09275034 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 141 5.830000000000001e-29   NTclustered gi|551604089|ref|XM_005783475.1| 280463 g68253 i0 79.703 7.33112582781457 202 35 66 6 11 209 877 679 Emiliania huxleyi CCMP1516 calreticulin (CRT-1), mRNA blastn 2214 141 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);;