RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA804229" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA804229 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
801675 801675 PRJNA804229_S_NODE_114781_length_190_cov_2.115646_g113823_i0 PRJNA804229 114781 190 2.115646 4.0197274 Anadara broughtonii 148819 Mollusca Mollusca 58.4 3.51e-4   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g113823 i0 100 0.784210526315789 31 0 16 0 1 31 29 59 Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds blastn 149 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Arcoida Arcidae Anadara Anadara broughtonii
8455419 8455419 PRJNA804229_S_NODE_141167_length_172_cov_1.116279_g140209_i0 PRJNA804229 141167 172 1.116279 1.91999988 Physella acuta 109671 Mollusca Mollusca 52.8 0.014   NTclustered gi|2572326155|ref|XM_059298723.1| 109671 g140209 i0 96.774 0.540697674418605 31 1 18 0 141 171 725 755 PREDICTED: Physella acuta microtubule-associated protein futsch-like (LOC131940138), transcript variant X3, mRNA blastn 93 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
8457359 8457359 PRJNA804229_S_NODE_51727_length_278_cov_2.451064_g50769_i0 PRJNA804229 51727 278 2.451064 6.81395792 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912990805|dbj|AP039595.1| 145626 g50769 i0 97.059 0.122302158273381 34 0 12 1 48 80 10011075 10011042 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10150502 10150502 PRJNA804229_S_NODE_131948_length_178_cov_1.059259_g130990_i0 PRJNA804229 131948 178 1.059259 1.88548102 Metazoa 33208 Mollusca Mollusca 329 6.21e-86   NTclustered gi|1928112764|gb|MT947788.1| 6523 g130990 i0 100 99.7191011235955 178 0 100 0 1 178 591 768 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 17750 329 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
11425763 11425763 PRJNA804229_S_NODE_10149_length_494_cov_3.576497_g9226_i0 PRJNA804229 10149 494 3.576497 17.66789518 Metazoa 33208 Mollusca Mollusca 913 0   NTclustered gi|1928112764|gb|MT947788.1| 6523 g9226 i0 100 100.390688259109 494 0 100 0 1 494 21 514 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 49593 913 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
13975956 13975956 PRJNA804229_S_NODE_39311_length_312_cov_2.431227_g38353_i0 PRJNA804229 39311 312 2.431227 7.58542824 Metazoa 33208 Mollusca Mollusca 577 3.89e-160   NTclustered gi|1928112764|gb|MT947788.1| 6523 g38353 i0 100 99.9935897435897 312 0 100 0 1 312 900 1211 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 31198 577 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis

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