RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB14664 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
2571135 2571135 PRJEB14664_P_NODE_5063_length_377_cov_2.210526_g4933_i0 PRJEB14664 5063 377 2.210526 8.33368302 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.01   NTclustered gi|2912993551|dbj|AP039598.1| 145626 g4933 i0 100 0.236074270557029 29 0 8 0 96 124 8221864 8221836 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence blastn 89 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
5123665 5123665 PRJEB14664_P_NODE_4925_length_385_cov_3.334286_g4795_i0 PRJEB14664 4925 385 3.334286 12.8370011 Physella acuta 109671 Mollusca Mollusca 706 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g4795 i0 99.74 4.91428571428571 385 1 100 0 1 385 3339 3723 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 1892 706 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
8948268 8948268 PRJEB14664_P_NODE_6928_length_309_cov_1.762774_g6798_i0 PRJEB14664 6928 309 1.762774 5.44697166 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.029   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g6798 i0 100 0.0906148867313916 28 0 9 0 242 269 22788486 22788459 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10223933 10223933 PRJEB14664_P_NODE_18029_length_161_cov_1.412698_g17899_i0 PRJEB14664 18029 161 1.412698 2.27444378 Physella acuta 109671 Mollusca Mollusca 93.5 7.88e-15   NTclustered gi|2572437643|ref|XM_059286917.1| 109671 g17899 i0 88.312 4.88198757763975 77 9 48 0 82 158 752 676 PREDICTED: Physella acuta ras-related protein Rab-3 (LOC131930434), transcript variant X6, mRNA blastn 786 93.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
15323359 15323359 PRJEB14664_P_NODE_16073_length_174_cov_2.021583_g15943_i0 PRJEB14664 16073 174 2.021583 3.51755442 Bradybaena similaris 145626 Mollusca Mollusca 62.1 2.43e-5   NTclustered gi|2912983111|dbj|AP039588.1| 145626 g15943 i0 100 23 33 0 19 0 134 166 15040275 15040243 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence blastn 4002 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
17563610 17563610 PRJEB14664_P_NODE_3614_length_468_cov_2.741339_g3489_i0 PRJEB14664 3614 468 2.741339 12.82946652 Opisthokonta 33154 Mollusca Mollusca 189 3.319999999999999e-43   NTclustered gi|1207937899|ref|XM_021502813.1| 6573 g3489 i0 87.805 36.3803418803419 164 16 35 4 95 256 54 215 PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L27a-like (LOC110453724), mRNA blastn 17026 189 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
22973281 22973281 PRJEB14664_P_NODE_8919_length_262_cov_1.585903_g8789_i0 PRJEB14664 8919 262 1.585903 4.15506586 Bradybaena similaris 145626 Mollusca Mollusca 69.4 2.37e-7   NTclustered gi|2913002568|dbj|AP039611.1| 145626 g8789 i0 97.5 15.8358778625954 40 1 24 0 138 177 2690477 2690516 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence blastn 4149 69.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24247069 24247069 PRJEB14664_P_NODE_4340_length_419_cov_1.611979_g4212_i0 PRJEB14664 4340 419 1.611979 6.75419201 Mytilus trossulus 6551 Mollusca Mollusca 357 7.63e-94   NTclustered gi|2694002732|ref|XM_063566204.1| 6551 g4212 i0 83 94.3532219570406 400 62 95 6 13 409 184 580 PREDICTED: Mytilus trossulus tubulin alpha-1A chain (LOC134706872), mRNA blastn 39534 357 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus

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