RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1120771", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 3 ✖

tax_clade 1

  • Apusozoa · 3 ✖

bioproject 1

  • PRJNA1120771 · 3 ✖

analysis 1

tax_phylum 0

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
7929599 7929599 PRJNA1120771_S_NODE_3727_length_480_cov_38.427918_g3335_i0 PRJNA1120771 3727 480 38.427918 184.4540064 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 213 6.439999999999999e-67   NR XP_013754328.1 461836 g3335 i0 70.2 3.50625 141 41 87.5 1 475 56 102 242 XP_013754328.1 60S ribosomal protein L7 [Thecamonas trahens ATCC 50062] diamond 1683 213 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
30038512 30038512 PRJNA1120771_S_NODE_11351_length_321_cov_5.985612_g10951_i0 PRJNA1120771 11351 321 5.985612 19.21381452 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 105 1.5999999999999998e-25   NR XP_013759670.1 461836 g10951 i0 53.8 0.850467289719626 91 41 85 1 312 40 139 228 XP_013759670.1 countin-2 [Thecamonas trahens ATCC 50062] diamond 273 105 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens
32473143 32473143 PRJNA1120771_S_NODE_8139_length_361_cov_6.383648_g7739_i0 PRJNA1120771 8139 361 6.383648 23.04496928 Thecamonas trahens ATCC 5 529818 Root_unresolved Root_unresolved 85.9 5.21e-19   NR XP_013760378.1 461836 g7739 i0 47.7 0.714681440443213 86 41 71.5 2 2 259 9 90 XP_013760378.1 uncharacterized protein AMSG_03040 [Thecamonas trahens ATCC 50062] diamond 258 85.9 1 Eukaryota Apusozoa       Apusomonadida Apusomonadidae Thecamonas Thecamonas trahens

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