RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1105232", tax_clade = "Sar" 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

  • PRJNA1105232 · 8 ✖

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
8673625 8673625 PRJNA1105232_S_NODE_6667_length_237_cov_1.563830_g6451_i0 PRJNA1105232 6667 237 1.56383 3.7062771 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 83.2 5.86e-17   NR KAL3789155.1 29204 g6451 i0 67.7 4.67088607594937 62 15 73.4 2 235 62 232 292 KAL3789155.1 hypothetical protein HJC23_012244 [Cyclotella cryptica] diamond 1107 83.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
15515237 15515237 PRJNA1105232_S_NODE_7413_length_227_cov_1.668539_g7197_i0 PRJNA1105232 7413 227 1.668539 3.78758353 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 102 2.8000000000000003e-23   NR VEU36583.1 183589 g7197 i0 60.8 5.86784140969163 74 29 97.8 0 6 227 486 559 VEU36583.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1332 103 0.990291262135922 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
20613752 20613752 PRJNA1105232_S_NODE_4697_length_272_cov_1.358744_g4481_i0 PRJNA1105232 4697 272 1.358744 3.69578368 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 76.3 8.42e-14   NR KAG7362897.1 303405 g4481 i0 45.1 0.904411764705882 82 43 90.4 1 267 22 168 247 KAG7362897.1 ankyrin repeat domain protein [Nitzschia inconspicua] diamond 246 76.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27952149 27952149 PRJNA1105232_S_NODE_7565_length_225_cov_1.772727_g7349_i0 PRJNA1105232 7565 225 1.772727 3.98863575 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 107 1.63e-25   NR XP_002289146.1 296543 g7349 i0 65.3 4 75 25 98.7 1 223 2 149 223 XP_002289146.1 hypothetical protein THAPSDRAFT_268598 [Thalassiosira pseudonana CCMP1335] diamond 900 107 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28078325 28078325 PRJNA1105232_S_NODE_7845_length_222_cov_1.202312_g7629_i0 PRJNA1105232 7845 222 1.202312 2.66913264 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 50.4 5.37e-5   NR KAL3921016.1 3061772 g7629 i0 43.7 0.959459459459459 71 38 95.9 1 215 3 379 447 KAL3921016.1 MAG: hypothetical protein SGILL_002973, partial [Bacillariaceae sp.] diamond 213 50.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30438375 30438375 PRJNA1105232_S_NODE_13153_length_180_cov_1.152672_g12937_i0 PRJNA1105232 13153 180 1.152672 2.0748096 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 80.5 3.3e-16   NR KAL3778566.1 29204 g12937 i0 67.2 2.9 58 19 96.7 0 3 176 216 273 KAL3778566.1 hypothetical protein HJC23_011662 [Cyclotella cryptica] diamond 522 80.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31110157 31110157 PRJNA1105232_S_NODE_10495_length_198_cov_1.046980_g10279_i0 PRJNA1105232 10495 198 1.04698 2.0730204 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00588   NR CAJ1942400.1 2856 g10279 i0 57.6 4.18181818181818 33 14 50 0 172 74 840 872 CAJ1942400.1 unnamed protein product [Cylindrotheca closterium] diamond 828 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32714165 32714165 PRJNA1105232_S_NODE_9480_length_206_cov_2.980892_g9264_i0 PRJNA1105232 9480 206 2.980892 6.14063752 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 116 1.6499999999999999e-28   NR KAK1743033.1 267567 g9264 i0 88.2 4.95145631067961 68 8 99 0 1 204 30 97 KAK1743033.1 T-complex protein 1 subunit zeta [Skeletonema marinoi] diamond 1020 117 0.991452991452991 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi

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