RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA608660 · 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
3135578 3135578 PRJNA608660_P_NODE_31303_length_228_cov_1.162011_g30947_i0 PRJNA608660 31303 228 1.162011 2.64938508 Crassostrea virginica 6565 Mollusca Mollusca 52.8 0.02   NTclustered gi|1242830407|ref|XM_022440510.1| 6565 g30947 i0 96.774 0.271929824561404 31 1 14 0 93 123 743 713 PREDICTED: Crassostrea virginica U3 small nucleolar RNA-interacting protein 2-like (LOC111106001), transcript variant X2, mRNA blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
6963140 6963140 PRJNA608660_P_NODE_46906_length_167_cov_0.881356_g46549_i0 PRJNA608660 46906 167 0.881356 1.47186452 Bradybaena similaris 145626 Mollusca Mollusca 62.1 2.33e-5   NTclustered gi|2912998575|dbj|AP039604.1| 145626 g46549 i0 84.375 0.754491017964072 64 9 38 1 8 71 31164981 31165043 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence blastn 126 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8237598 8237598 PRJNA608660_P_NODE_11147_length_446_cov_4.793451_g10800_i0 PRJNA608660 11147 446 4.793451 21.37879146 Bradybaena similaris 145626 Mollusca Mollusca 62.1 7.17e-5   NTclustered gi|2912993551|dbj|AP039598.1| 145626 g10800 i0 94.872 28.8340807174888 39 2 10 0 219 257 29114687 29114649 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence blastn 12860 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18436853 18436853 PRJNA608660_P_NODE_44355_length_173_cov_0.879032_g43998_i0 PRJNA608660 44355 173 0.879032 1.52072536 Physella acuta 109671 Mollusca Mollusca 165 1.79e-36   NTclustered gi|2572453128|ref|XR_009385722.1| 109671 g43998 i0 83.908 71.2832369942196 174 27 100 1 1 173 486 659 PREDICTED: Physella acuta small subunit ribosomal RNA (LOC131934416), rRNA blastn 12332 165 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta

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