RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA680334", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA680334 · 4 ✖

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
1925362 1925362 PRJNA680334_S_NODE_1442_length_571_cov_18.189591_g1003_i0 PRJNA680334 1442 571 18.189591 103.86256461 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 749 0   NTclustered gi|238617605|gb|FJ973380.1| 45107 g1003 i0 90.401 102.245183887916 573 50 100 5 1 571 1596 1027 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 58382 749 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
3721005 3721005 PRJNA680334_S_NODE_37163_length_210_cov_5.118644_g36677_i0 PRJNA680334 37163 210 5.118644 10.7491524 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 381 2.069999999999999e-101   NTclustered gi|2493707699|dbj|LC764482.1| 45107 g36677 i0 99.522 99.5238095238095 209 1 99 0 2 210 768 976 Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence blastn 20900 381 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
17228714 17228714 PRJNA680334_S_NODE_96174_length_155_cov_5.639344_g95688_i0 PRJNA680334 96174 155 5.639344 8.7409832 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 159 7.3e-35   NTclustered gi|1402550480|gb|MH488766.1| 2231163 g95688 i0 95.05 12.1870967741935 101 5 65 0 55 155 661 561 Rosculus philanguis isolate HAS small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 1889 159 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
21571396 21571396 PRJNA680334_S_NODE_23317_length_242_cov_22.483254_g22831_i0 PRJNA680334 23317 242 22.483254 54.40947468 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 442 1.1099999999999995e-119   NTclustered gi|2493707699|dbj|LC764482.1| 45107 g22831 i0 100 98.7479338842975 239 0 99 0 4 242 129 367 Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence blastn 23897 442 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa

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