RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1192965", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA1192965 · 12 ✖

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
2871291 2871291 PRJNA1192965_P_NODE_4203_length_246_cov_0.890173_g4184_i0 PRJNA1192965 4203 246 0.890173 2.18982558 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 85.9 2.56e-17   NR XP_002287436.1 296543 g4184 i0 45 0.975609756097561 80 44 97.6 0 246 7 133 212 XP_002287436.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 240 85.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
4147421 4147421 PRJNA1192965_P_NODE_3264_length_251_cov_1.297753_g3245_i0 PRJNA1192965 3264 251 1.297753 3.25736003 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 129 4.96e-36   NR KAG7346278.1 303405 g3245 i0 80.5 2.91633466135458 82 16 98 0 250 5 33 114 KAG7346278.1 ribosomal protein L6e [Nitzschia inconspicua] diamond 732 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
7973782 7973782 PRJNA1192965_P_NODE_3667_length_249_cov_0.875000_g3648_i0 PRJNA1192965 3667 249 0.875 2.17875 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 195 3.5399999999999996e-45   NTclustered gi|657012367|gb|KF302531.1| 2850 g3648 i0 80.876 2.5863453815261 251 44 100 4 1 249 116 364 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 644 195 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16897617 16897617 PRJNA1192965_P_NODE_1194_length_366_cov_1.525597_g1175_i0 PRJNA1192965 1194 366 1.525597 5.58368502 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 281 4.07e-71   NTclustered gi|657012367|gb|KF302531.1| 2850 g1175 i0 92.386 82.9344262295082 197 15 54 0 10 206 219 23 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 30354 281 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26723717 26723717 PRJNA1192965_P_NODE_4701_length_243_cov_1.382353_g4682_i0 PRJNA1192965 4701 243 1.382353 3.35911779 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 119 9.44e-31   NR KAL3903606.1 3061772 g4682 i0 75.7 1.72839506172839 70 17 86.4 0 33 242 6 75 KAL3903606.1 MAG: hypothetical protein SGARI_005299, partial [Bacillariaceae sp.] diamond 420 119 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27704539 27704539 PRJNA1192965_P_NODE_5244_length_238_cov_2.351515_g5225_i0 PRJNA1192965 5244 238 2.351515 5.5966057 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 68.6 2.51e-11   NR KAL3913026.1 3061772 g5225 i0 47.4 0.957983193277311 76 34 95.8 3 230 3 256 325 KAL3913026.1 MAG: hypothetical protein SGILL_006654 [Bacillariaceae sp.] diamond 228 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28386230 28386230 PRJNA1192965_P_NODE_1266_length_357_cov_1.084507_g1247_i0 PRJNA1192965 1266 357 1.084507 3.87168999 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.01e-6   NR CAJ1951312.1 2856 g1247 i0 42.5 1.15966386554622 73 37 57.1 1 223 20 414 486 CAJ1951312.1 unnamed protein product [Cylindrotheca closterium] diamond 414 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28777580 28777580 PRJNA1192965_P_NODE_4187_length_246_cov_0.890173_g4168_i0 PRJNA1192965 4187 246 0.890173 2.18982558 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 62 6.32e-9   NR KAL3771683.1 2934178 g4168 i0 52.7 0.902439024390244 74 27 90.2 1 245 24 684 749 KAL3771683.1 hypothetical protein ACHAW5_005935 [Stephanodiscus triporus] diamond 222 62 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
30786492 30786492 PRJNA1192965_P_NODE_1654_length_321_cov_1.862903_g1635_i0 PRJNA1192965 1654 321 1.862903 5.97991863 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.82e-5   NR XP_002286743.1 296543 g1635 i0 39.7 3.05607476635514 63 38 58.9 0 194 6 565 627 XP_002286743.1 heat shock protein belonging to the HSP70 family [Thalassiosira pseudonana CCMP1335] diamond 981 52.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31779033 31779033 PRJNA1192965_P_NODE_4157_length_246_cov_0.890173_g4138_i0 PRJNA1192965 4157 246 0.890173 2.18982558 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 75.9 6.82e-14   NR KAL3939698.1 3061772 g4138 i0 55.4 1.52439024390244 65 24 79.3 1 1 195 321 380 KAL3939698.1 MAG: hypothetical protein SGBAC_005619 [Bacillariaceae sp.] diamond 375 75.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32840830 32840830 PRJNA1192965_P_NODE_2340_length_284_cov_2.620853_g2321_i0 PRJNA1192965 2340 284 2.620853 7.44322252 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 94 3.69e-22   NR EJK74848.1 159749 g2321 i0 64.9 2.18661971830986 74 25 77.1 1 65 283 1 74 EJK74848.1 hypothetical protein THAOC_03450 [Thalassiosira oceanica] diamond 621 94 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32884863 32884863 PRJNA1192965_P_NODE_4660_length_244_cov_0.900585_g4641_i0 PRJNA1192965 4660 244 0.900585 2.1974274 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00803   NR VEU36261.1 183589 g4641 i0 53.2 0.577868852459016 47 19 57.8 1 235 95 727 770 VEU36261.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 141 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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