RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB7799 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
33050415 33050415 PRJEB7799p_S_NODE_3125_length_275_cov_6.058333_g3102_i0 PRJEB7799 3125 275 6.058333 16.66041575 Oscarella lobularis 121494 Porifera other_Eukaryota 82 1.8e-17   NR XP_065836264.1 121494 g3102 i0 90 6.98181818181818 40 4 43.6 0 275 156 108 147 XP_065836264.1 small ribosomal subunit protein uS19-like [Oscarella lobularis] diamond 1920 82 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
33162224 33162224 PRJEB7799p_S_NODE_15400_length_176_cov_3.042553_g15377_i0 PRJEB7799 15400 176 3.042553 5.35489328 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.9 3.95e-7   NR XP_065844892.1 121494 g15377 i0 66.7 3.39204545454545 39 13 66.5 0 6 122 95 133 XP_065844892.1 large ribosomal subunit protein eL32-like [Oscarella lobularis] diamond 597 53.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis

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