RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA692200 · 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
1949003 1949003 PRJNA692200_S_NODE_9382_length_230_cov_1.414365_g9325_i0 PRJNA692200 9382 230 1.414365 3.2530395 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g9325 i0 90.476 2.61304347826087 42 4 18 0 96 137 23553379 23553420 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 601 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
4500698 4500698 PRJNA692200_S_NODE_17524_length_175_cov_5.460317_g17467_i0 PRJNA692200 17524 175 5.460317 9.55555475 Pyramidelloides angustus 1502566 Mollusca Mollusca 126 8.56e-25   NTclustered gi|663060754|dbj|AB930414.1| 1502566 g17467 i0 80.117 48.1371428571429 171 32 97 2 4 172 50 220 Pyramidelloides angustus mitochondrial gene for 16S rRNA, partial sequence, isolate: YK1601 blastn 8424 126 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Eulimidae Pyramidelloides Pyramidelloides angustus
13426464 13426464 PRJNA692200_S_NODE_18491_length_171_cov_3.778689_g18434_i0 PRJNA692200 18491 171 3.778689 6.46155819 Mizuhopecten yessoensis 6573 Mollusca Mollusca 84.2 5.08e-12   NTclustered gi|1207980031|ref|XM_021483861.1| 6573 g18434 i0 91.803 2.19298245614035 61 3 35 2 89 148 609 550 PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S5 (LOC110440710), mRNA blastn 375 84.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
21075377 21075377 PRJNA692200_S_NODE_577_length_491_cov_15.540724_g541_i0 PRJNA692200 577 491 15.540724 76.30495484 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.013   NTclustered gi|2913001038|dbj|AP039608.1| 145626 g541 i0 100 0.0590631364562118 29 0 6 0 297 325 9147465 9147493 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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