RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA853194" 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

  • PRJNA853194 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
26706527 26706527 PRJNA853194_S_NODE_10321_length_587_cov_4.429961_g9280_i0 PRJNA853194 10321 587 4.429961 26.00387107 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 74.7 9.81e-12   NR GFH49360.1 426638 g9280 i0 37.5 1.01703577512777 96 60 49.1 0 2 289 13 108 GFH49360.1 hypothetical protein CTEN210_05836 [Chaetoceros tenuissimus] diamond 597 74.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28602575 28602575 PRJNA853194_S_NODE_32647_length_368_cov_5.305085_g31556_i0 PRJNA853194 32647 368 5.305085 19.5227128 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 59.3 2.39e-7   NR CAJ1958892.1 2856 g31556 i0 33 1.56521739130435 97 62 78.3 2 366 79 238 332 CAJ1958892.1 unnamed protein product [Cylindrotheca closterium] diamond 576 59.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32615799 32615799 PRJNA853194_S_NODE_86320_length_237_cov_2.396341_g85229_i0 PRJNA853194 86320 237 2.396341 5.67932817 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 72 1.51e-12   NR CAJ1951130.1 2856 g85229 i0 45.1 2.6962025316455702 71 38 88.6 1 9 218 89 159 CAJ1951130.1 unnamed protein product [Cylindrotheca closterium] diamond 639 72 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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