RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB81327 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
6100155 6100155 PRJEB81327_P_NODE_39465_length_262_cov_1.603175_g38857_i0 PRJEB81327 39465 262 1.603175 4.2003185 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.024   NTclustered gi|1207978941|ref|XM_021483260.1| 6573 g38857 i0 100 2.06870229007634 28 0 11 0 188 215 4365 4392 PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110440287 (LOC110440287), mRNA blastn 542 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
17991140 17991140 PRJEB81327_P_NODE_18335_length_315_cov_3.219008_g17727_i0 PRJEB81327 18335 315 3.219008 10.1398752 Magallana angulata 2784310 Mollusca Mollusca 198 3.58e-46   NTclustered gi|2416916068|ref|XM_052845461.1| 2784310 g17727 i0 78.165 10.8285714285714 316 65 99 3 2 315 438 125 PREDICTED: Crassostrea angulata proteasome subunit alpha type-6-like (LOC128178343), mRNA blastn 3411 198 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
17991540 17991540 PRJEB81327_P_NODE_48375_length_250_cov_0.870056_g47767_i0 PRJEB81327 48375 250 0.870056 2.17514 Aplysia californica 6500 Mollusca Mollusca 318 2.02e-82   NTclustered gi|325297131|ref|NM_001204646.1| 6500 g47767 i0 90 87.064 250 20 100 1 1 250 405 161 Aplysia californica polyubiquitin-C (LOC101860494), mRNA blastn 21766 318 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
17991795 17991795 PRJEB81327_P_NODE_69035_length_216_cov_5.489510_g68427_i0 PRJEB81327 69035 216 5.48951 11.8573416 Ostrea edulis 37623 Mollusca Mollusca 104 5.19e-18   NTclustered gi|2507442068|ref|XM_048889000.2| 37623 g68427 i0 80.42 1.98611111111111 143 23 64 5 1 138 5516 5658 PREDICTED: Ostrea edulis E3 ubiquitin-protein ligase RNF38-like (LOC125657998), transcript variant X6, mRNA blastn 429 104 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
19265057 19265057 PRJEB81327_P_NODE_12216_length_387_cov_2.082803_g11608_i0 PRJEB81327 12216 387 2.082803 8.06044761 Ostrea edulis 37623 Mollusca Mollusca 156 2.74e-33   NTclustered gi|2507440729|ref|XM_056150217.1| 37623 g11608 i0 89.516 30.2041343669251 124 11 32 2 240 362 795 673 PREDICTED: Ostrea edulis 60S ribosomal protein L8-like (LOC130050350), transcript variant X2, mRNA blastn 11689 156 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
19265362 19265362 PRJEB81327_P_NODE_36116_length_268_cov_1.184615_g35508_i0 PRJEB81327 36116 268 1.184615 3.1747682 Physella acuta 109671 Mollusca Mollusca 252 2.25e-62   NTclustered gi|2572439903|ref|XM_059287523.1| 109671 g35508 i0 85.081 85.1492537313433 248 36 93 1 17 264 716 962 PREDICTED: Physella acuta endoplasmic reticulum chaperone BiP (LOC131930863), mRNA blastn 22820 252 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
24365749 24365749 PRJEB81327_P_NODE_4520_length_692_cov_1.794830_g3952_i0 PRJEB81327 4520 692 1.79483 12.4202236 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.019   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g3952 i0 100 0.226878612716763 29 0 4 0 491 519 59809024 59809052 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 157 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);;