RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA900028 · 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
4702869 4702869 PRJNA900028_P_NODE_106764_length_172_cov_2.219512_g106015_i0 PRJNA900028 106764 172 2.219512 3.81756064 Bradybaena similaris 145626 Mollusca Mollusca 154 3.84e-33   NTclustered gi|2912989933|dbj|AP039594.1| 145626 g106015 i0 91.15 3.42441860465116 113 10 72 0 39 151 30936814 30936926 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence blastn 589 154 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16547084 16547084 PRJNA900028_P_NODE_106813_length_172_cov_2.073171_g106064_i0 PRJNA900028 106813 172 2.073171 3.56585412 Metazoa 33208 Mollusca Mollusca 58.4 3.1e-4   NTclustered gi|2793349872|ref|XR_010955290.1| 109174 g106064 i0 100 14.156976744186 31 0 18 0 142 172 2386 2416 PREDICTED: Haliotis asinina large subunit ribosomal RNA (LOC137270364), rRNA blastn 2435 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
17822397 17822397 PRJNA900028_P_NODE_16054_length_292_cov_3.106996_g15305_i0 PRJNA900028 16054 292 3.106996 9.07242832 Metazoa 33208 Mollusca Mollusca 60.2 1.62e-4   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g15305 i0 88.235 0.541095890410959 51 5 17 1 1 50 15919840 15919890 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 158 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18726246 18726246 PRJNA900028_P_NODE_155255_length_164_cov_0.886957_g154506_i0 PRJNA900028 155255 164 0.886957 1.45460948 Bradybaena similaris 145626 Mollusca Mollusca 62.1 2.27e-5   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g154506 i0 91.304 1.95731707317073 46 2 28 1 119 164 46230200 46230243 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 321 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
20002268 20002268 PRJNA900028_P_NODE_50356_length_207_cov_1.670886_g49607_i0 PRJNA900028 50356 207 1.670886 3.45873402 Bradybaena similaris 145626 Mollusca Mollusca 93.5 1.07e-14   NTclustered gi|2912986657|dbj|AP039591.1| 145626 g49607 i0 82.569 3.70048309178744 109 15 73 4 48 152 28896024 28895916 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence blastn 766 93.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
25471972 25471972 PRJNA900028_P_NODE_38100_length_224_cov_1.097143_g37351_i0 PRJNA900028 38100 224 1.097143 2.45760032 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 398 2.2199999999999997e-106   NTclustered gi|2076472537|gb|MZ710040.1| 6465 g37351 i0 98.667 57.4464285714286 225 1 99 1 2 224 1219 995 Patella vulgata voucher LKW089 small subunit ribosomal RNA gene, partial sequence blastn 12868 398 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata

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