RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1108009", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1108009 · 3 ✖

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
7865822 7865822 PRJNA1108009_P_NODE_25227_length_250_cov_1.740113_g24909_i0 PRJNA1108009 25227 250 1.740113 4.3502825 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 167 3.47e-49   NR AAX09600.1 29204 g24909 i0 92.8 2.988 83 6 99.6 0 249 1 238 320 AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica] diamond 747 167 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
10416815 10416815 PRJNA1108009_P_NODE_9609_length_438_cov_1.591781_g9291_i0 PRJNA1108009 9609 438 1.591781 6.97200078 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 7.62e-37   NR EJK75259.1 159749 g9291 i0 63.1 0.705479452054795 103 37 69.9 1 341 36 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28015414 28015414 PRJNA1108009_P_NODE_30965_length_242_cov_0.911243_g30647_i0 PRJNA1108009 30965 242 0.911243 2.20520806 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 98.2 6.38e-22   NR GFH51759.1 426638 g30647 i0 54.2 1.02892561983471 83 35 99.2 1 241 2 40 122 GFH51759.1 hypothetical protein CTEN210_08235 [Chaetoceros tenuissimus] diamond 249 98.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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