RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA438687", tax_clade = "Haptista" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 4 ✖

tax_clade 1

  • Haptista · 4 ✖

bioproject 1

  • PRJNA438687 · 4 ✖

analysis 1

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
5538945 5538945 PRJNA438687_S_NODE_1605_length_328_cov_15.450512_g1515_i0 PRJNA438687 1605 328 15.450512 50.67767936 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 171 8.16e-38   NTclustered gi|194146360|gb|EU616327.1| 171259 g1515 i0 85.455 49.0884146341463 165 23 50 1 1 165 757 594 Uncultured haptophyte clone MV5_19_190 28S ribosomal RNA gene, partial sequence blastn 16101 171 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
10639239 10639239 PRJNA438687_S_NODE_6209_length_176_cov_2.638298_g6119_i0 PRJNA438687 6209 176 2.638298 4.64340448 Phaeocystis antarctica 33657 Haptophyta other_Eukaryota 60.2 8.87e-5   NTclustered gi|9885782|gb|AF289040.1|AF289040 33657 g6119 i0 94.737 0.215909090909091 38 2 22 0 84 121 1493 1530 Phaeocystis antarctica internal transcribed spacer 2, partial sequence; and 28S ribosomal RNA gene, complete sequence blastn 38 60.2 1 Eukaryota Haptista   Haptophyta   Phaeocystales Phaeocystaceae Phaeocystis Phaeocystis antarctica
12569994 12569994 PRJNA438687_S_NODE_2430_length_284_cov_3.244980_g2340_i0 PRJNA438687 2430 284 3.24498 9.2157432 Pavlovaceae 418969 Haptophyta other_Eukaryota 433 8.01e-117   NTclustered gi|330423575|gb|JF714237.1| 1000985 g2340 i0 100 82.4577464788732 234 0 82 0 51 284 748 981 Pavlova sp. AC248 18S ribosomal RNA gene, partial sequence blastn 23418 433 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Pavlova Pavlova sp. EMB-2011
13189063 13189063 PRJNA438687_S_NODE_8031_length_152_cov_1.991453_g7941_i0 PRJNA438687 8031 152 1.991453 3.02700856 Pavlova gyrans 44452 Haptophyta other_Eukaryota 182 1.52e-41   NTclustered gi|238617593|gb|FJ973368.1| 44452 g7941 i0 88.816 78.2631578947368 152 12 98 5 1 149 1697 1846 Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence blastn 11896 182 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Pavlova Pavlova gyrans

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