RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB8827" 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

  • PRJEB8827 · 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
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);;