RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJEB81327 · 6 ✖

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
5242767 5242767 PRJEB81327_P_NODE_62945_length_242_cov_0.911243_g62337_i0 PRJEB81327 62945 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 129 1.7599999999999998e-32   NR CAJ1958678.1 2856 g62337 i0 77.5 33.5950413223141 80 18 99.2 0 2 241 491 570 CAJ1958678.1 unnamed protein product [Cylindrotheca closterium] diamond 8130 130 0.992307692307692 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
23091777 23091777 PRJEB81327_P_NODE_37799_length_265_cov_1.265625_g37191_i0 PRJEB81327 37799 265 1.265625 3.35390625 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 318 2.16e-82   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g37191 i0 88.846 83.2528301886792 260 28 98 1 1 260 4846 4588 Naviculales sp. strain SZCZO2114 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 22062 318 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
26939163 26939163 PRJEB81327_P_NODE_21662_length_298_cov_2.506667_g21054_i0 PRJEB81327 21662 298 2.506667 7.46986766 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 124 1.48e-33   NR KAL3922769.1 3061772 g21054 i0 71.1 0.976510067114094 97 23 96.6 2 9 296 74 166 KAL3922769.1 MAG: hypothetical protein SGILL_002026 [Bacillariaceae sp.] diamond 291 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27855509 27855509 PRJEB81327_P_NODE_45525_length_252_cov_1.290503_g44917_i0 PRJEB81327 45525 252 1.290503 3.25206756 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 60.5 1.62e-9   NR KAL3928765.1 3061772 g44917 i0 43.5 0.821428571428571 69 35 79.8 3 6 206 47 113 KAL3928765.1 MAG: hypothetical protein SGBAC_012508 [Bacillariaceae sp.] diamond 207 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30034386 30034386 PRJEB81327_P_NODE_39231_length_262_cov_2.216931_g38623_i0 PRJEB81327 39231 262 2.216931 5.80835922 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 56.6 2.47e-8   NR EJK70082.1 159749 g38623 i0 58.1 0.984732824427481 43 18 49.2 0 127 255 12 54 EJK70082.1 hypothetical protein THAOC_08591 [Thalassiosira oceanica] diamond 258 56.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31013695 31013695 PRJEB81327_P_NODE_17135_length_326_cov_1.976285_g16527_i0 PRJEB81327 17135 326 1.976285 6.4426891 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 122 1.97e-32   NR EJK47429.1 159749 g16527 i0 61.6 0.911042944785276 99 38 91.1 0 16 312 12 110 EJK47429.1 hypothetical protein THAOC_33854 [Thalassiosira oceanica] diamond 297 122 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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