RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB11748" 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

tax_clade 1

bioproject 1

  • PRJEB11748 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
8942478 8942478 PRJEB11748_P_NODE_182248_length_300_cov_1.334728_g180065_i0 PRJEB11748 182248 300 1.334728 4.004184 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 0.028   NTclustered gi|2746777157|ref|XM_065972481.1| 121494 g180065 i0 100 0.0933333333333333 28 0 9 0 73 100 329 302 PREDICTED: Oscarella lobularis E3 ubiquitin-protein ligase TRIM37-like (LOC136185367), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
13736919 13736919 PRJEB11748_P_NODE_201211_length_282_cov_21.316742_g199028_i0 PRJEB11748 201211 282 21.316742 60.11321244 Demospongiae 6042 Porifera other_Eukaryota 237 6.690000000000001e-58   NTclustered gi|1918108416|gb|MW150047.1| 593584 g199028 i0 84.17 91.8404255319149 259 25 89 11 25 274 191 442 Carteriospongia foliascens isolate CSGI08 large subunit ribosomal RNA gene, partial sequence blastn 25899 237 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Thorectidae Phyllospongia Phyllospongia foliascens
14045686 14045686 PRJEB11748_P_NODE_291952_length_223_cov_6.228395_g289769_i0 PRJEB11748 291952 223 6.228395 13.88932085 Hippospongia lachne 479639 Porifera other_Eukaryota 99 2.51e-16   NTclustered gi|387166032|gb|JQ606797.1| 479639 g289769 i0 91.549 2.33183856502242 71 6 32 0 25 95 122 52 Hippospongia lachne ATP synthase beta chain (ATPB) mRNA, partial cds blastn 520 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Spongiidae Hippospongia Hippospongia lachne

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