RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA980585" 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

  • PRJNA980585 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2230272 2230272 PRJNA980585_P_NODE_40862_length_251_cov_0.865169_g40608_i0 PRJNA980585 40862 251 0.865169 2.17157419 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 187 5.98e-43   NTclustered gi|2156401020|dbj|LC537470.1| 426638 g40608 i0 80.738 48.3745019920319 244 43 96 4 3 243 34060 34302 Chaetoceros tenuissimus NIES-3715 mitochondrial DNA, complete genome blastn 12142 187 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
3505160 3505160 PRJNA980585_P_NODE_23943_length_301_cov_1.614035_g23689_i0 PRJNA980585 23943 301 1.614035 4.85824535 Guinardia striata 1514137 SAR_Eukaryotes SAR_Eukaryotes 110 1.64e-19   NTclustered gi|2074156236|gb|MW413904.1| 1514137 g23689 i0 80.822 12.2126245847176 146 22 47 4 153 294 32292 32149 Guinardia striata mitochondrion, complete genome blastn 3676 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia striata
11158439 11158439 PRJNA980585_P_NODE_48549_length_247_cov_0.885057_g48295_i0 PRJNA980585 48549 247 0.885057 2.18609079 Ditylum brightwellii 49249 SAR_Eukaryotes SAR_Eukaryotes 148 2.77e-31   NTclustered gi|398372885|gb|JX305463.1| 49249 g48295 i0 79.71 55.2348178137652 207 41 83 1 1 206 1476 1682 Ditylum brightwellii strain B-326 heat shock protein 70 (Hsp70) mRNA, complete cds blastn 13643 148 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Ditylum Ditylum brightwellii
14982249 14982249 PRJNA980585_P_NODE_11332_length_401_cov_3.103659_g11078_i0 PRJNA980585 11332 401 3.103659 12.44567259 Ralfsiella minima 1334967 SAR_Eukaryotes SAR_Eukaryotes 209 2.16e-49   NTclustered gi|2202538981|gb|OM891887.1| 1334967 g11078 i0 85.167 49.7007481296758 209 25 52 5 1 207 4919 4715 Odontella aurita var. minima small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 19930 209 1 Eukaryota Sar   Bacillariophyta       Ralfsiella Ralfsiella minima
14983042 14983042 PRJNA980585_P_NODE_58092_length_242_cov_0.911243_g57838_i0 PRJNA980585 58092 242 0.911243 2.20520806 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 278 3.3e-70   NTclustered gi|657012367|gb|KF302531.1| 2850 g57838 i0 88.362 78.0578512396694 232 25 95 2 4 234 240 10 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 18890 278 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16257965 16257965 PRJNA980585_P_NODE_54013_length_244_cov_1.350877_g53759_i0 PRJNA980585 54013 244 1.350877 3.29613988 Melosira undulata 2133757 SAR_Eukaryotes SAR_Eukaryotes 161 3.5e-35   NTclustered gi|1418576929|ref|NC_037728.1| 2133757 g53759 i0 85 20.8647540983607 160 22 65 2 8 166 13047 12889 Melosira undulata mitochondrion, complete genome blastn 5091 161 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Melosiraceae Melosira Melosira undulata
25181308 25181308 PRJNA980585_P_NODE_5920_length_525_cov_1.703540_g5666_i0 PRJNA980585 5920 525 1.70354 8.943585 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 246 2.2e-60   NTclustered gi|657012367|gb|KF302531.1| 2850 g5666 i0 84.17 21.7066666666667 259 36 49 5 4 259 272 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 11396 246 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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