RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA263496", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 3 ✖

tax_kingdom 1

  • Metazoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA263496 · 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
8022591 8022591 PRJNA263496_P_NODE_16947_length_189_cov_1.457143_g16694_i0 PRJNA263496 16947 189 1.457143 2.75400027 Porifera 6040 Porifera other_Eukaryota 84 3.96e-17   NR XP_065183973.1 27933 g16694 i0 79.6 34.2222222222222 49 10 77.8 0 148 2 1 49 XP_065183973.1 dnaJ homolog subfamily A member 1-like [Sycon ciliatum] diamond 6468 84.7 0.991735537190083 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27186399 27186399 PRJNA263496_P_NODE_21622_length_166_cov_1.666667_g21369_i0 PRJNA263496 21622 166 1.666667 2.76666722 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.2 7.56e-4   NR XP_003385244.1 400682 g21369 i0 45.5 2.34939759036145 44 24 79.5 0 134 3 260 303 XP_003385244.1 PREDICTED: cathepsin D-like [Amphimedon queenslandica] diamond 390 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
29852963 29852963 PRJNA263496_P_NODE_15791_length_196_cov_2.353741_g15538_i0 PRJNA263496 15791 196 2.353741 4.61333236 Oscarella lobularis 121494 Porifera other_Eukaryota 112 4.99e-28   NR AQM52340.1 121494 g15538 i0 84.7 1.80612244897959 59 9 90.3 0 18 194 111 169 AQM52340.1 glyceraldehyde 3-phosphate dehydrogenase, partial [Oscarella lobularis] diamond 354 112 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);;