RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB8827", 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 · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJEB8827 · 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
25801609 25801609 PRJEB8827c_S_NODE_2963_length_153_cov_1.559322_g2950_i0 PRJEB8827 2963 153 1.559322 2.38576266 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.6e-11   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g2950 i0 94.34 5.13725490196078 53 3 35 0 99 151 5273 5325 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 786 82.4 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
26073823 26073823 PRJEB8827c_S_NODE_3341_length_150_cov_3.060870_g3328_i0 PRJEB8827 3341 150 3.06087 4.591305 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 1.99e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g3328 i0 85.714 1.4 105 15 70 0 37 141 321 425 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26074509 26074509 PRJEB8827f_S_NODE_901_length_377_cov_4.225146_g881_i0 PRJEB8827 901 377 4.225146 15.92880042 Nitzschia sp. IriIs 1884248 SAR_Eukaryotes SAR_Eukaryotes 143 2.07e-29   NTclustered gi|944186150|dbj|LC052662.1| 1444690 g881 i0 86.26 1.78249336870027 131 18 35 0 7 137 1231 1361 Nitzschia sp. IriIs04 sec61alpha mRNA for Sec61alpha, complete cds blastn 672 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. IriIs04
26074607 26074607 PRJEB8827g_S_NODE_621_length_344_cov_97302.326861_g600_i0 PRJEB8827 621 344 97302.326861 334720.00440184 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 87.9 8.92e-13   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g600 i0 84.615 12.3720930232558 91 10 26 4 125 214 5360 5273 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 4256 87.9 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
26210101 26210101 PRJEB8827d_S_NODE_26222_length_159_cov_3.693548_g26218_i0 PRJEB8827 26222 159 3.693548 5.87274132 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 2.14e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g26218 i0 85.714 1.32075471698113 105 15 66 0 34 138 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26210868 26210868 PRJEB8827h_S_NODE_1486_length_256_cov_5.497738_g1467_i0 PRJEB8827 1486 256 5.497738 14.07420928 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.06e-15   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g1467 i0 75.194 6.26171875 258 36 96 23 11 255 25464 25222 Coscinodiscus granii mitochondrion, complete sequence blastn 1603 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
26482831 26482831 PRJEB8827g_S_NODE_1032_length_289_cov_2407.248031_g1011_i0 PRJEB8827 1032 289 2407.248031 6956.94680959 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 4.35e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g1011 i0 85.714 14.7958477508651 105 15 36 0 145 249 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 4276 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32914160 32914160 PRJEB8827h_S_NODE_27825_length_177_cov_5.633803_g27806_i0 PRJEB8827 27825 177 5.633803 9.97183131 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 79 1.15e-16   NR KAL3928702.1 3061772 g27806 i0 72.9 3.23728813559322 48 13 81.4 0 175 32 117 164 KAL3928702.1 MAG: hypothetical protein SGBAC_012534 [Bacillariaceae sp.] diamond 573 79 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32931115 32931115 PRJEB8827e_S_NODE_39857_length_157_cov_3.114754_g39829_i0 PRJEB8827 39857 157 3.114754 4.89016378 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.00286   NR EJK58442.1 159749 g39829 i0 87 0.439490445859873 23 3 43.9 0 127 59 24 46 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 69 42.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32940501 32940501 PRJEB8827c_S_NODE_577_length_201_cov_1.204819_g564_i0 PRJEB8827 577 201 1.204819 2.42168619 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 79.3 3.25e-17   NR AID23573.1 2850 g564 i0 85 1.7910447761194 40 6 59.7 0 200 81 72 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 360 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
33026000 33026000 PRJEB8827g_S_NODE_2588_length_206_cov_2.052632_g2567_i0 PRJEB8827 2588 206 2.052632 4.22842192 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0164   NR KAI2505912.1 210448 g2567 i0 90.5 1.5 21 2 30.6 0 206 144 318 338 KAI2505912.1 ribosomal uL3-like protein [Fragilaria crotonensis] diamond 309 43.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
33050520 33050520 PRJEB8827d_S_NODE_8077_length_174_cov_2.812950_g8073_i0 PRJEB8827 8077 174 2.81295 4.894533 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.5 9.15e-6   NR KAI2504781.1 210448 g8073 i0 56.4 1.3448275862069 39 17 67.2 0 119 3 8 46 KAI2504781.1 small subunit ribosomal protein S12 [Fragilaria crotonensis] diamond 234 48.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
33118733 33118733 PRJEB8827c_S_NODE_359_length_223_cov_1.292553_g346_i0 PRJEB8827 359 223 1.292553 2.88239319 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 48.9 8.44e-5   NR KAL3928702.1 3061772 g346 i0 76.9 0.349775784753363 26 6 35 0 223 146 139 164 KAL3928702.1 MAG: hypothetical protein SGBAC_012534 [Bacillariaceae sp.] diamond 78 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
33128238 33128238 PRJEB8827g_S_NODE_1359_length_263_cov_3.241228_g1338_i0 PRJEB8827 1359 263 3.241228 8.52442964 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 82.8 5.56e-18   NR KAL3762786.1 2934178 g1338 i0 58.5 2.3041825095057 65 27 74.1 0 236 42 66 130 KAL3762786.1 hypothetical protein ACHAW5_001314 [Stephanodiscus triporus] diamond 606 82.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
33136195 33136195 PRJEB8827h_S_NODE_40839_length_164_cov_2.364341_g40820_i0 PRJEB8827 40839 164 2.364341 3.87751924 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 85.9 5.16e-20   NR AID23573.1 2850 g40820 i0 80.4 1.68292682926829 46 9 84.1 0 3 140 66 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 276 85.9 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);;