RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA315314 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
26807069 26807069 PRJNA315314_S_NODE_20121_length_184_cov_3.619355_g19800_i0 PRJNA315314 20121 184 3.619355 6.6596132 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 68.9 4.88e-12   NR KAI2491943.1 210448 g19800 i0 72.5 2.59239130434783 40 11 65.2 0 2 121 180 219 KAI2491943.1 Ribosomal protein S3 [Fragilaria crotonensis] diamond 477 69.3 0.994227994227994 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27060252 27060252 PRJNA315314_S_NODE_21542_length_179_cov_1.460000_g21221_i0 PRJNA315314 21542 179 1.46 2.6134 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 54.7 4.94e-8   NR YP_005090352.1 2850 g21221 i0 82.9 2.93296089385475 35 6 58.7 0 55 159 1 35 YP_005090352.1 ATPase subunit 9 [Phaeodactylum tricornutum] diamond 525 55.1 0.992740471869329 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27801029 27801029 PRJNA315314_S_NODE_3644_length_419_cov_3.443590_g3324_i0 PRJNA315314 3644 419 3.44359 14.4286421 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 77.8 7.65e-14   NR VEU33732.1 183589 g3324 i0 60 0.823389021479714 55 22 39.4 0 416 252 274 328 VEU33732.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 345 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28779549 28779549 PRJNA315314_S_NODE_8027_length_285_cov_4.726562_g7706_i0 PRJNA315314 8027 285 4.726562 13.4707017 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 72 3.52e-13   NR KAI2504009.1 210448 g7706 i0 51.7 2.74736842105263 87 28 76.8 2 284 66 98 184 KAI2504009.1 ribosomal eL6-like protein [Fragilaria crotonensis] diamond 783 72 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29428404 29428404 PRJNA315314_S_NODE_21809_length_178_cov_1.503356_g21488_i0 PRJNA315314 21809 178 1.503356 2.67597368 root 1 Root_unresolved Root_unresolved 102 2.07e-23   NR KAL3774488.1 382360 g21488 i0 83.9 14.6292134831461 56 9 94.4 0 2 169 241 296 KAL3774488.1 hypothetical protein ACHAWO_007008 [Cyclotella atomus] diamond 2604 103 0.990291262135922 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29948045 29948045 PRJNA315314_S_NODE_25331_length_166_cov_7.043796_g25010_i0 PRJNA315314 25331 166 7.043796 11.69270136 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 85.5 5.23e-20   NR AID23594.1 2850 g25010 i0 85.2 15.6144578313253 54 8 97.6 0 2 163 7 60 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 2592 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30376624 30376624 PRJNA315314_S_NODE_30552_length_154_cov_1.272000_g30231_i0 PRJNA315314 30552 154 1.272 1.95888 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00319   NR KAL3918850.1 3061772 g30231 i0 38.1 3.75974025974026 42 26 81.8 0 28 153 136 177 KAL3918850.1 MAG: hypothetical protein SGILL_004048 [Bacillariaceae sp.] diamond 579 44.7 0.991051454138702 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30674565 30674565 PRJNA315314_S_NODE_30533_length_154_cov_1.432000_g30212_i0 PRJNA315314 30533 154 1.432 2.20528 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.55e-5   NR GFH45186.1 426638 g30212 i0 51.1 0.876623376623377 45 22 87.7 0 139 5 302 346 GFH45186.1 hypothetical protein CTEN210_01660 [Chaetoceros tenuissimus] diamond 135 50.8 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);;