RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA849172" and tax_phylum = "Cryptomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cryptomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA849172 · 3 ✖

analysis 1

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
1231919 1231919 PRJNA849172_P_NODE_120001_length_232_cov_2.647799_g119641_i0 PRJNA849172 120001 232 2.647799 6.14289368 Paramicrosporidium saccamoebae 1246581 Fungi Fungi 145 1.4699999999999999e-38   NR PJF19135.1 1246581 g119641 i0 89.6 0.995689655172414 77 8 99.6 0 2 232 198 274 PJF19135.1 Hsp77-like protein [Paramicrosporidium saccamoebae] diamond 231 145 1 Eukaryota Opisthokonta Fungi Cryptomycota       Paramicrosporidium Paramicrosporidium saccamoebae
4663513 4663513 PRJNA849172_P_NODE_13564_length_571_cov_23.676707_g13206_i0 PRJNA849172 13564 571 23.676707 135.19399697 Rozella allomycis CSF55 988480 Fungi Fungi 263 8.2e-86   NR EPZ33659.1 988480 g13206 i0 79.8 1.68651488616462 163 33 85.6 0 3 491 93 255 EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] diamond 963 263 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
26833382 26833382 PRJNA849172_P_NODE_137301_length_211_cov_4.434783_g136941_i0 PRJNA849172 137301 211 4.434783 9.35739213 Paramicrosporidium saccamoebae 1246581 Fungi Fungi 103 5.24e-25   NR PJF17617.1 1246581 g136941 i0 73.2 1.00947867298578 71 17 98.1 1 208 2 145 215 PJF17617.1 Solute carrier family 25 member 38 [Paramicrosporidium saccamoebae] diamond 213 103 1 Eukaryota Opisthokonta Fungi Cryptomycota       Paramicrosporidium Paramicrosporidium saccamoebae

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