RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA658591" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA658591 · 15 ✖

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
4453378 4453378 PRJNA658591_S_NODE_144_length_867_cov_6.605134_g115_i0 PRJNA658591 144 867 6.605134 57.26651178 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 350 3.4099999999999985e-119   NR XP_002181180.1 556484 g115 i0 79.2 6.95155709342561 212 44 73.4 0 24 659 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 6027 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13379571 13379571 PRJNA658591_S_NODE_10051_length_163_cov_1.368421_g9988_i0 PRJNA658591 10051 163 1.368421 2.23052623 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 107 2.91e-25   NR KAI2488626.1 210448 g9988 i0 90.7 3.97546012269939 54 5 99.4 0 1 162 490 543 KAI2488626.1 ATP-dependent RNA helicase DOB1 [Fragilaria crotonensis] diamond 648 107 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
23578135 23578135 PRJNA658591_S_NODE_4639_length_213_cov_7.000000_g4576_i0 PRJNA658591 4639 213 7 14.91 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 176 1.07e-39   NTclustered gi|657012367|gb|KF302531.1| 2850 g4576 i0 85.38 4.42723004694836 171 23 80 2 7 176 333 164 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 943 176 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
24851741 24851741 PRJNA658591_S_NODE_7980_length_175_cov_1.055556_g7917_i0 PRJNA658591 7980 175 1.055556 1.847223 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 105 1.62e-24   NR VEU38097.1 183589 g7917 i0 86.2 9.94285714285714 58 8 99.4 0 175 2 466 523 VEU38097.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1740 106 0.990566037735849 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
26860215 26860215 PRJNA658591_S_NODE_4201_length_221_cov_2.598837_g4138_i0 PRJNA658591 4201 221 2.598837 5.74342977 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0251   NR KAL3918831.1 3061772 g4138 i0 43.4 0.719457013574661 53 26 71.9 1 61 219 6 54 KAL3918831.1 MAG: hypothetical protein SGARI_007355, partial [Bacillariaceae sp.] diamond 159 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27523719 27523719 PRJNA658591_S_NODE_9063_length_168_cov_0.873950_g9000_i0 PRJNA658591 9063 168 0.87395 1.468236 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 116 5.24e-29   NR KAG7363815.1 303405 g9000 i0 85.5 1.96428571428571 55 8 98.2 0 2 166 324 378 KAG7363815.1 hem peroxidase [Nitzschia inconspicua] diamond 330 116 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27713576 27713576 PRJNA658591_S_NODE_10564_length_160_cov_2.738739_g10501_i0 PRJNA658591 10564 160 2.738739 4.3819824 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00111   NR AID23596.1 2850 g10501 i0 60.6 0.61875 33 13 61.9 0 2 100 85 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 99 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27851547 27851547 PRJNA658591_S_NODE_6244_length_191_cov_1.098592_g6181_i0 PRJNA658591 6244 191 1.098592 2.09831072 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 116 2.46e-28   NR KAL3784446.1 29204 g6181 i0 81 20.7329842931937 63 12 99 0 1 189 590 652 KAL3784446.1 hypothetical protein HJC23_002490 [Cyclotella cryptica] diamond 3960 116 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28471091 28471091 PRJNA658591_S_NODE_2466_length_272_cov_8.695067_g2403_i0 PRJNA658591 2466 272 8.695067 23.65058224 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.06e-14   NR XP_002178302.1 556484 g2403 i0 65.3 2.29411764705882 49 17 54 0 125 271 242 290 XP_002178302.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 624 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29714186 29714186 PRJNA658591_S_NODE_4170_length_222_cov_1.248555_g4107_i0 PRJNA658591 4170 222 1.248555 2.7717921 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 96.3 1.32e-23   NR CAJ1953474.1 2856 g4107 i0 86.4 10.1756756756757 44 6 59.5 0 3 134 84 127 CAJ1953474.1 unnamed protein product [Cylindrotheca closterium] diamond 2259 96.7 0.995863495346432 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30018326 30018326 PRJNA658591_S_NODE_10911_length_157_cov_2.101852_g10848_i0 PRJNA658591 10911 157 2.101852 3.29990764 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 54.3 9.7e-7   NR EJK63179.1 159749 g10848 i0 52.1 1.8343949044586 48 23 91.7 0 144 1 527 574 EJK63179.1 hypothetical protein THAOC_16183 [Thalassiosira oceanica] diamond 288 54.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30283571 30283571 PRJNA658591_S_NODE_9152_length_167_cov_2.161017_g9089_i0 PRJNA658591 9152 167 2.161017 3.60889839 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 111 4.3200000000000005e-27   NR CAJ1955121.1 2856 g9089 i0 92.7 13.8323353293413 55 4 98.8 0 166 2 368 422 CAJ1955121.1 unnamed protein product [Cylindrotheca closterium] diamond 2310 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30598965 30598965 PRJNA658591_S_NODE_7833_length_176_cov_2.047244_g7770_i0 PRJNA658591 7833 176 2.047244 3.60314944 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 80.1 1e-15   NR XP_002286935.1 296543 g7770 i0 64.3 3.78409090909091 56 20 95.5 0 171 4 184 239 XP_002286935.1 hypothetical protein THAPSDRAFT_26082 [Thalassiosira pseudonana CCMP1335] diamond 666 80.5 0.995031055900621 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31661455 31661455 PRJNA658591_S_NODE_8797_length_169_cov_1.258333_g8734_i0 PRJNA658591 8797 169 1.258333 2.12658277 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.28e-4   NR KAL3805332.1 29204 g8734 i0 58.1 0.763313609467456 43 18 76.3 0 2 130 80 122 KAL3805332.1 hypothetical protein HJC23_009039 [Cyclotella cryptica] diamond 129 47.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32294752 32294752 PRJNA658591_S_NODE_5099_length_206_cov_1.987261_g5036_i0 PRJNA658591 5099 206 1.987261 4.09375766 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.86e-4   NR KAI2490089.1 210448 g5036 i0 56.8 1.07766990291262 37 16 53.9 0 81 191 185 221 KAI2490089.1 hypothetical protein MHU86_24485 [Fragilaria crotonensis] diamond 222 48.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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