RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA193544", tax_kingdom = "Metazoa" 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

  • Metazoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA193544 · 4 ✖

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
365887 365887 PRJNA193544_S_NODE_2641_length_170_cov_5.921986_g2626_i0 PRJNA193544 2641 170 5.921986 10.0673762 Haplosclerida sp. A KZ-2019 2593691 Porifera other_Eukaryota 95.3 2.33e-15   NTclustered gi|1699953832|gb|MN153806.1| 2593691 g2626 i0 87.654 0.476470588235294 81 10 48 0 85 165 2786 2706 Haplosclerida sp. A KZ-2019 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 81 95.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida     Haplosclerida sp. A KZ-2019
13119639 13119639 PRJNA193544_S_NODE_1091_length_243_cov_511.822430_g1076_i0 PRJNA193544 1091 243 511.82243 1243.7285049 Clathrinidae sp. 5 JV-2020 2772896 Porifera other_Eukaryota 115 2.7500000000000003e-21   NTclustered gi|1905444957|gb|MW016097.1| 2772896 g1076 i0 77.273 69.2181069958848 220 34 88 12 29 243 210 2 Clathrinidae sp. 5 JV-2020 voucher KBOA02131730 large subunit ribosomal RNA gene, partial sequence blastn 16820 115 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Clathrinida Clathrinidae   Clathrinidae sp. 5 JV-2020
16357671 16357671 PRJNA193544_S_NODE_333_length_351_cov_10969.819876_g318_i0 PRJNA193544 333 351 10969.819876 38504.06776476 Dictyoceratida 119428 Porifera other_Eukaryota 124 6.93e-24   NTclustered gi|2749500559|ref|XR_010696300.1| 196820 g318 i0 93.023 26.2079772079772 86 5 24 1 58 142 3610 3525 PREDICTED: Dysidea avara large subunit ribosomal RNA (LOC136246210), rRNA blastn 9199 124 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
18906710 18906710 PRJNA193544_S_NODE_955_length_255_cov_15499.407080_g940_i0 PRJNA193544 955 255 15499.40708 39523.488054 Opisthokonta 33154 Porifera other_Eukaryota 80.5 1.06e-10   NTclustered gi|7630145|emb|AJ277422.1| 111878 g940 i0 94.231 13.9333333333333 52 3 20 0 204 255 103 52 Oopsacas minuta partial 28S rRNA gene blastn 3553 80.5 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta

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