RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJEB2925 · 4 ✖

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
6091177 6091177 PRJEB2925_P_NODE_12345_length_305_cov_3.118519_g11069_i0 PRJEB2925 12345 305 3.118519 9.51148295 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.7e-4   NTclustered gi|1169296927|gb|KY364697.1| 29204 g11069 i0 97.143 0.334426229508197 35 1 11 0 257 291 4127 4093 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 102 60.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
21702810 21702810 PRJEB2925_P_NODE_13478_length_284_cov_1.437751_g12201_i0 PRJEB2925 13478 284 1.437751 4.08321284 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 127 2.31e-34   NR CAB9499166.1 568900 g12201 i0 67 3.90845070422535 91 28 96.1 1 2 274 90 178 CAB9499166.1 FKBP-type 22 kDa peptidyl-prolyl cis-trans isomerase [Seminavis robusta] diamond 1110 127 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
22978121 22978121 PRJEB2925_P_NODE_4279_length_670_cov_2.088189_g3354_i0 PRJEB2925 4279 670 2.088189 13.9908663 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 142 2.1099999999999998e-38   NR EJK54772.1 159749 g3354 i0 57.9 155.261194029851 140 44 62.7 3 662 243 73 197 EJK54772.1 hypothetical protein THAOC_25571 [Thalassiosira oceanica] diamond 104025 143 0.993006993006993 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27847897 27847897 PRJEB2925_P_NODE_6624_length_503_cov_4.136752_g5484_i0 PRJEB2925 6624 503 4.136752 20.80786256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 221 2.05e-70   NR CAJ1966769.1 2856 g5484 i0 68.2 37.1451292246521 151 48 90.1 0 16 468 60 210 CAJ1966769.1 unnamed protein product [Cylindrotheca closterium] diamond 18684 221 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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