RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA345071", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA345071 · 7 ✖

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
15695951 15695951 PRJNA345071_P_NODE_2913_length_348_cov_1.847273_g2873_i0 PRJNA345071 2913 348 1.847273 6.42851004 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 174 2.84e-51   NR XP_002181794.1 556484 g2873 i0 69.6 4.83620689655172 112 34 96.6 0 337 2 46 157 XP_002181794.1 desaturase delta 9 desaturase [Phaeodactylum tricornutum CCAP 1055/1] diamond 1683 174 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27818689 27818689 PRJNA345071_P_NODE_8624_length_249_cov_1.357955_g8584_i0 PRJNA345071 8624 249 1.357955 3.38130795 root 1 Root_unresolved Root_unresolved 74.7 2.16e-13   NR KAL3803927.1 382360 g8584 i0 43.2 1.93975903614458 81 46 97.6 0 244 2 372 452 KAL3803927.1 hypothetical protein ACHAWO_013730 [Cyclotella atomus] diamond 483 74.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29775939 29775939 PRJNA345071_P_NODE_7471_length_254_cov_1.558011_g7431_i0 PRJNA345071 7471 254 1.558011 3.95734794 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 61.2 3.13e-9   NR VEU33373.1 183589 g7431 i0 45.9 1.62992125984252 74 39 87.4 1 31 252 37 109 VEU33373.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 414 61.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30660669 30660669 PRJNA345071_P_NODE_8193_length_251_cov_0.876404_g8153_i0 PRJNA345071 8193 251 0.876404 2.19977404 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 126 1.2e-31   NR CAJ1963703.1 2856 g8153 i0 69.9 5.95219123505976 83 25 99.2 0 250 2 415 497 CAJ1963703.1 unnamed protein product [Cylindrotheca closterium] diamond 1494 127 0.992125984251969 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31514342 31514342 PRJNA345071_P_NODE_9016_length_248_cov_0.891429_g8976_i0 PRJNA345071 9016 248 0.891429 2.21074392 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 51.2 4e-5   NR KAL3773516.1 382360 g8976 i0 41.5 3.55645161290323 53 29 61.7 1 155 3 29 81 KAL3773516.1 hypothetical protein ACHAWO_000512 [Cyclotella atomus] diamond 882 51.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31560328 31560328 PRJNA345071_P_NODE_2676_length_359_cov_1.636364_g2636_i0 PRJNA345071 2676 359 1.636364 5.87454676 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 47 0.00432   NR CAJ1946111.1 2856 g2636 i0 33.7 0.693593314763231 83 52 66.9 2 312 73 3 85 CAJ1946111.1 unnamed protein product [Cylindrotheca closterium] diamond 249 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32730002 32730002 PRJNA345071_P_NODE_9440_length_246_cov_1.803468_g9400_i0 PRJNA345071 9440 246 1.803468 4.43653128 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.65e-9   NR CAB9504775.1 568900 g9400 i0 50 0.634146341463415 52 26 63.4 0 2 157 1439 1490 CAB9504775.1 Nitric oxide synthase [Seminavis robusta] diamond 156 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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