RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJEB25789 · 3 ✖

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
8950111 8950111 PRJEB25789_S_NODE_13468_length_272_cov_3.095477_g13389_i0 PRJEB25789 13468 272 3.095477 8.41969744 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 99 3.16e-16   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g13389 i0 79.856 0.658088235294118 139 24 63 4 65 201 249 113 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 179 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
22663704 22663704 PRJEB25789_S_NODE_7978_length_332_cov_1.428571_g7899_i0 PRJEB25789 7978 332 1.428571 4.74285572 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 608 1.479999999999999e-169   NTclustered gi|1169296927|gb|KY364697.1| 29204 g7899 i0 99.699 99.8373493975904 332 1 100 0 1 332 627 958 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 33146 614 0.990228013029316 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27823084 27823084 PRJEB25789_S_NODE_20044_length_241_cov_0.916667_g19965_i0 PRJEB25789 20044 241 0.916667 2.20916747 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47.8 6.37e-4   NR CAB9529681.1 568900 g19965 i0 47.9 1.81742738589212 73 36 88.4 1 217 5 337 409 CAB9529681.1 Tylosin resistance ATP-binding protein TlrC [Seminavis robusta] diamond 438 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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