RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 4 ✖

bioproject 1

  • PRJNA600413 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
26668168 26668168 PRJNA600413_P_NODE_81121_length_179_cov_1.553846_g80420_i0 PRJNA600413 81121 179 1.553846 2.78138434 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 73.9 1.07e-14   NR XP_005774683.1 280463 g80420 i0 59.6 0.871508379888268 52 21 87.2 0 2 157 77 128 XP_005774683.1 hypothetical protein EMIHUDRAFT_207436 [Emiliania huxleyi CCMP1516] diamond 156 73.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27142758 27142758 PRJNA600413_P_NODE_148662_length_161_cov_0.910714_g147961_i0 PRJNA600413 148662 161 0.910714 1.46624954 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 45.8 8.64e-4   NR KAL3928932.1 2812485 g147961 i0 48.1 0.968944099378882 52 27 96.9 0 6 161 55 106 KAL3928932.1 MAG: hypothetical protein SGPRY_002181 [Prymnesium sp.] diamond 156 45.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30459488 30459488 PRJNA600413_P_NODE_147633_length_161_cov_0.910714_g146932_i0 PRJNA600413 147633 161 0.910714 1.46624954 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 49.3 5.96e-5   NR KOO26064.1 1460289 g146932 i0 51 0.950310559006211 51 23 93.2 2 158 9 201 250 KOO26064.1 hypothetical protein Ctob_001772 [Chrysochromulina tobinii] diamond 153 49.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32609134 32609134 PRJNA600413_P_NODE_128160_length_164_cov_0.886957_g127459_i0 PRJNA600413 128160 164 0.886957 1.45460948 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 58.9 5.74e-9   NR XP_005774683.1 280463 g127459 i0 53.1 0.896341463414634 49 23 89.6 0 148 2 94 142 XP_005774683.1 hypothetical protein EMIHUDRAFT_207436 [Emiliania huxleyi CCMP1516] diamond 147 58.9 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);;