RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA896758" and tax_phylum = "Cryptomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cryptomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA896758 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
26992238 26992238 PRJNA896758_P_NODE_25962_length_242_cov_0.911243_g25572_i0 PRJNA896758 25962 242 0.911243 2.20520806 Paramicrosporidium saccamoebae 1246581 Fungi Fungi 42.7 0.0322   NR PJF18438.1 1246581 g25572 i0 50 0.471074380165289 38 19 47.1 0 240 127 197 234 PJF18438.1 Carbohydrate esterase family 4 protein [Paramicrosporidium saccamoebae] diamond 114 42.7 1 Eukaryota Opisthokonta Fungi Cryptomycota       Paramicrosporidium Paramicrosporidium saccamoebae
29557944 29557944 PRJNA896758_P_NODE_14770_length_298_cov_1.368889_g14380_i0 PRJNA896758 14770 298 1.368889 4.07928922 Eukaryota 2759 Fungi Fungi 126 5.279999999999999e-32   NR EPZ31343.1 988480 g14380 i0 57.7 6.76510067114094 97 41 97.7 0 297 7 201 297 EPZ31343.1 DUF1900 domain-containing protein [Rozella allomycis CSF55] diamond 2016 126 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
29802913 29802913 PRJNA896758_P_NODE_23351_length_247_cov_0.885057_g22961_i0 PRJNA896758 23351 247 0.885057 2.18609079 Rozella allomycis CSF55 988480 Fungi Fungi 76.3 4.58e-15   NR EPZ31693.1 988480 g22961 i0 48.6 0.898785425101215 74 38 89.9 0 25 246 85 158 EPZ31693.1 hypothetical protein O9G_000172 [Rozella allomycis CSF55] diamond 222 76.3 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
30316674 30316674 PRJNA896758_P_NODE_12272_length_328_cov_1.811765_g11882_i0 PRJNA896758 12272 328 1.811765 5.9425892 root 1 Root_unresolved Root_unresolved 174 1.11e-52   NR EPZ35492.1 988480 g11882 i0 83.5 14.8536585365854 109 17 98.8 1 326 3 3 111 EPZ35492.1 60S ribosomal protein L15 [Rozella allomycis CSF55] diamond 4872 174 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
31825535 31825535 PRJNA896758_P_NODE_11937_length_333_cov_1.184615_g11547_i0 PRJNA896758 11937 333 1.184615 3.94476795 Rozella allomycis CSF55 988480 Fungi Fungi 93.2 1.35e-21   NR RKP16348.1 988480 g11547 i0 50.5 0.837837837837838 93 46 83.8 0 328 50 49 141 RKP16348.1 HSP20-like chaperone [Rozella allomycis CSF55] diamond 279 93.2 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis

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