RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA575566 · 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
9488257 9488257 PRJNA575566_P_NODE_11888_length_304_cov_1.580247_g11691_i0 PRJNA575566 11888 304 1.580247 4.80395088 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g11691 i0 100 0.5 30 0 10 0 169 198 31243483 31243454 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 152 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10764351 10764351 PRJNA575566_P_NODE_24229_length_209_cov_0.864865_g24032_i0 PRJNA575566 24229 209 0.864865 1.80756785 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.018   NTclustered gi|2912985489|dbj|AP039590.1| 145626 g24032 i0 100 0.133971291866029 28 0 13 0 161 188 68813022 68812995 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
12039076 12039076 PRJNA575566_P_NODE_17370_length_253_cov_1.000000_g17173_i0 PRJNA575566 17370 253 1 2.53 Bradybaena similaris 145626 Mollusca Mollusca 73.1 1.76e-8   NTclustered gi|2912996298|dbj|AP039601.1| 145626 g17173 i0 90.741 6.01185770750988 54 5 21 0 1 54 21546789 21546736 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence blastn 1521 73.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
14589007 14589007 PRJNA575566_P_NODE_29272_length_202_cov_0.907801_g29075_i0 PRJNA575566 29272 202 0.907801 1.83375802 Ostrea edulis 37623 Mollusca Mollusca 58.4 3.78e-4   NTclustered gi|2507420029|ref|XM_048885337.2| 37623 g29075 i0 94.595 1.87128712871287 37 2 18 0 160 196 278 242 PREDICTED: Ostrea edulis diencephalon/mesencephalon homeobox protein 1-like (LOC125655165), mRNA blastn 378 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
19686379 19686379 PRJNA575566_P_NODE_10576_length_321_cov_2.192308_g10379_i0 PRJNA575566 10576 321 2.192308 7.03730868 Mytilus californianus 6549 Mollusca Mollusca 56.5 0.002   NTclustered gi|2334761577|ref|XM_052209329.1| 6549 g10379 i0 100 3.65732087227414 30 0 9 0 230 259 980 1009 PREDICTED: Mytilus californianus uncharacterized LOC127705057 (LOC127705057), transcript variant X3, mRNA blastn 1174 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
22236935 22236935 PRJNA575566_P_NODE_11298_length_311_cov_3.084000_g11101_i0 PRJNA575566 11298 311 3.084 9.59124 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.008   NTclustered gi|2912989933|dbj|AP039594.1| 145626 g11101 i0 100 0.0932475884244373 29 0 9 0 118 146 61918646 61918618 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, 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);;