RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA816047", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA816047 · 3 ✖

analysis 1

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
25633509 25633509 PRJNA816047a_S_NODE_87561_length_213_cov_9.928571_g84901_i0 PRJNA816047 87561 213 9.928571 21.14785623 Gymnochlora 67808 SAR_Eukaryotes SAR_Eukaryotes 152 1.8e-32   NTclustered gi|220983370|dbj|AB453006.1| 67809 g84901 i0 82.222 83.3896713615024 180 29 83 3 37 213 3060 2881 Gymnochlora stellata gene for nuclear large subunit ribosomal RNA, partial sequence blastn 17762 152 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
25908197 25908197 PRJNA816047d_S_NODE_50747_length_310_cov_8472.404669_g48912_i0 PRJNA816047 50747 310 8472.404669 26264.4544739 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.1 2.22e-8   NTclustered gi|1915673679|emb|LR867298.1| 175275 g48912 i0 95.652 128.487096774194 46 1 15 1 22 66 255 210 uncultured Cercozoa partial 18S rRNA gene blastn 39831 73.1 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
26315646 26315646 PRJNA816047d_S_NODE_187534_length_202_cov_12082.510067_g185699_i0 PRJNA816047 187534 202 12082.510067 24406.67033534 Thecofilosea 1004930 SAR_Eukaryotes SAR_Eukaryotes 78.7 2.9e-10   NTclustered gi|1915674082|emb|LR867701.1| 1595894 g185699 i0 97.778 218.747524752475 45 1 22 0 20 64 256 212 uncultured Rhogostoma partial 18S rRNA gene blastn 44187 78.7 1 Eukaryota Sar   Cercozoa Thecofilosea Cryomonadida     uncultured Rhogostoma

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