RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA800090", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA800090 · 6 ✖

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
25024529 25024529 PRJNA800090_P_NODE_172740_length_236_cov_0.874251_g170555_i0 PRJNA800090 172740 236 0.874251 2.06323236 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 128 3e-32   NR KAF4674911.1 330153 g170555 i0 71.8 7.93220338983051 78 22 99.2 0 3 236 589 666 KAF4674911.1 hypothetical protein FOL47_008500 [Perkinsus chesapeaki] diamond 1872 128 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
27125824 27125824 PRJNA800090_P_NODE_118242_length_294_cov_2.524444_g116057_i0 PRJNA800090 118242 294 2.524444 7.42186536 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00483   NR KAF4668825.1 32597 g116057 i0 31.9 2.40816326530612 72 48 72.4 1 215 3 63 134 KAF4668825.1 hypothetical protein FOL46_001788 [Perkinsus olseni] diamond 708 45.8 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
27843638 27843638 PRJNA800090_P_NODE_182024_length_232_cov_0.895706_g179839_i0 PRJNA800090 182024 232 0.895706 2.07803792 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.56e-9   NR KAF4661230.1 330153 g179839 i0 64 0.646551724137931 50 17 64.7 1 162 13 64 112 KAF4661230.1 hypothetical protein FOL47_006777 [Perkinsus chesapeaki] diamond 150 62.4 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
30275525 30275525 PRJNA800090_P_NODE_106172_length_314_cov_2.318367_g103987_i0 PRJNA800090 106172 314 2.318367 7.27967238 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 196 3.79e-57   NR KAF4732490.1 32597 g103987 i0 87.5 5.96178343949045 104 13 99.4 0 3 314 496 599 KAF4732490.1 Thioredoxin domain-containing protein 9 [Perkinsus olseni] diamond 1872 196 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30536962 30536962 PRJNA800090_P_NODE_182113_length_232_cov_0.895706_g179928_i0 PRJNA800090 182113 232 0.895706 2.07803792 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 51.6 4.63e-6   NR KAF4703871.1 32597 g179928 i0 49.1 7.7198275862069 53 27 68.5 0 9 167 72 124 KAF4703871.1 hypothetical protein FOZ62_014870 [Perkinsus olseni] diamond 1791 51.6 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31453638 31453638 PRJNA800090_P_NODE_165416_length_242_cov_1.231214_g163231_i0 PRJNA800090 165416 242 1.231214 2.97953788 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 100 7.39e-23   NR KAF4703196.1 32597 g163231 i0 61.5 5.80165289256198 78 30 96.7 0 2 235 247 324 KAF4703196.1 hypothetical protein FOZ63_028309, partial [Perkinsus olseni] diamond 1404 100 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni

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