RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB3181 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1330304 1330304 PRJEB3181_P_NODE_762_length_646_cov_33.221138_g18_i4 PRJEB3181 762 646 33.221138 214.60855148 Soleneiscus stolonifer 365352 Porifera other_Eukaryota 333 2.0500000000000006e-86   NTclustered gi|111606966|emb|AM180983.1| 365352 g18 i4 78.625 76.2569659442725 538 89 82 22 18 548 585 1103 Soleneiscus stolonifer partial 28S rRNA gene, specimen voucher G313668 (Queensland Museum) blastn 49262 333 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Clathrinida Dendyidae Soleneiscus Soleneiscus stolonifer
7366404 7366404 PRJEB3181_P_NODE_19326_length_187_cov_7.762821_g19062_i0 PRJEB3181 19326 187 7.762821 14.51647527 Metazoa 33208 Porifera other_Eukaryota 99 2.03e-16   NTclustered gi|1284883228|gb|KY825184.1| 178514 g19062 i0 79.452 12.9197860962567 146 24 77 4 42 185 3474 3333 Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 2416 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon compressa
14084346 14084346 PRJEB3181_S_NODE_1392_length_417_cov_8.437173_g1106_i0 PRJEB3181 1392 417 8.437173 35.18301141 Mycale sp. GLH-2013 1325611 Porifera other_Eukaryota 191 8.15e-44   NTclustered gi|514227079|gb|KC961659.1| 1325611 g1106 i0 89.474 19.0599520383693 152 14 36 2 8 158 97 247 Mycale sp. GLH-2013 voucher MNRJ15636 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 7948 191 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Poecilosclerida Mycalidae Mycale Mycale sp. GLH-2013
18840559 18840559 PRJEB3181_S_NODE_4055_length_292_cov_18.704280_g3762_i0 PRJEB3181 4055 292 18.70428 54.6164976 Metazoa 33208 Porifera other_Eukaryota 99 3.43e-16   NTclustered gi|1284883228|gb|KY825184.1| 178514 g3762 i0 79.452 10.2123287671233 146 24 49 4 131 274 3474 3333 Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 2982 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon compressa

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