RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA807836" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA807836 · 6 ✖

analysis 1

  • diamond · 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
26896222 26896222 PRJNA807836_S_NODE_20341_length_302_cov_4.668122_g20065_i0 PRJNA807836 20341 302 4.668122 14.09772844 Symbiodinium sp. CCMP2592 631055 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0448   NR CAE7793371.1 631055 g20065 i0 36.1 0.71523178807947 72 46 71.5 0 258 43 19 90 CAE7793371.1 unnamed protein product, partial [Symbiodinium sp. CCMP2592] diamond 216 41.6 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2592
27401999 27401999 PRJNA807836_S_NODE_22143_length_287_cov_1.971963_g21867_i0 PRJNA807836 22143 287 1.971963 5.65953381 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0131   NR CDW73079.1 5949 g21867 i0 36.1 1.49477351916376 61 37 63.8 1 257 75 369 427 CDW73079.1 fha domain containing protein [Stylonychia lemnae] diamond 429 44.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27528120 27528120 PRJNA807836_S_NODE_19003_length_315_cov_1.586777_g18727_i0 PRJNA807836 19003 315 1.586777 4.99834755 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0472   NR CAJ1957214.1 2856 g18727 i0 38.3 1.12380952380952 60 35 57.1 1 89 268 416 473 CAJ1957214.1 unnamed protein product [Cylindrotheca closterium] diamond 354 43.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30220926 30220926 PRJNA807836_S_NODE_30392_length_243_cov_0.905882_g30116_i0 PRJNA807836 30392 243 0.905882 2.20129326 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 119 4.53e-30   NR CAD8180050.1 43137 g30116 i0 71.3 3.95061728395062 80 23 98.8 0 242 3 296 375 CAD8180050.1 unnamed protein product [Paramecium octaurelia] diamond 960 119 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30252809 30252809 PRJNA807836_S_NODE_1852_length_1247_cov_1.586031_g1729_i0 PRJNA807836 1852 1247 1.586031 19.77780657 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 88.6 7.47e-15   NR POM70231.1 4796 g1729 i0 41.3 2.88452285485164 109 56 26.2 2 1100 774 48 148 POM70231.1 Carbon catabolite repressor protein, partial [Phytophthora palmivora] diamond 3597 89.4 0.991051454138702 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
32709355 32709355 PRJNA807836_S_NODE_23720_length_276_cov_0.847291_g23444_i0 PRJNA807836 23720 276 0.847291 2.33852316 Cladocopium goreaui 2562237 SAR_Eukaryotes SAR_Eukaryotes 85.5 5.37e-17   NR CAL1149205.1 2562237 g23444 i0 54.1 0.923913043478261 85 39 92.4 0 258 4 471 555 CAL1149205.1 unnamed protein product [Cladocopium goreaui] diamond 255 85.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Cladocopium Cladocopium goreaui

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