RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA438111 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
10638052 10638052 PRJNA438111_P_NODE_40069_length_194_cov_3.066667_g39444_i0 PRJNA438111 40069 194 3.066667 5.94933398 Pomacea canaliculata 400727 Mollusca Mollusca 143 9.66e-30   NTclustered gi|1397694303|ref|XM_025240758.1| 400727 g39444 i0 83.333 17.7525773195876 162 19 80 8 28 183 132 291 PREDICTED: Pomacea canaliculata ADP-ribosylation factor 2 (LOC112565351), transcript variant X1, mRNA blastn 3444 143 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
12569486 12569486 PRJNA438111_P_NODE_50770_length_181_cov_1.684211_g50145_i0 PRJNA438111 50770 181 1.684211 3.04842191 Mytilus 6548 Mollusca Mollusca 65.8 1.97e-6   NTclustered gi|2334712348|ref|XM_052245476.1| 6549 g50145 i0 91.489 0.779005524861878 47 4 26 0 46 92 1296 1250 PREDICTED: Mytilus californianus chitinase domain-containing protein 1-like (LOC127735323), mRNA blastn 141 65.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
23386108 23386108 PRJNA438111_P_NODE_25999_length_214_cov_3.675676_g25374_i0 PRJNA438111 25999 214 3.675676 7.86594664 Biomphalaria glabrata 6526 Mollusca Mollusca 60.2 1.13e-4   NTclustered gi|2502134919|ref|XM_056013775.1| 6526 g25374 i0 100 1.2803738317757 32 0 15 0 108 139 233 264 PREDICTED: Biomphalaria glabrata guanine nucleotide-binding protein-like 3 homolog (LOC106077405), transcript variant X5, mRNA blastn 274 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
24660772 24660772 PRJNA438111_P_NODE_65780_length_167_cov_3.231884_g65155_i0 PRJNA438111 65780 167 3.231884 5.39724628 Bradybaena similaris 145626 Mollusca Mollusca 60.2 8.37e-5   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g65155 i0 94.737 22.6287425149701 38 2 23 0 85 122 37730824 37730787 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 3779 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24661059 24661059 PRJNA438111_P_NODE_88180_length_152_cov_2.105691_g87555_i0 PRJNA438111 88180 152 2.105691 3.20065032 Octopus bimaculoides 37653 Mollusca Mollusca 115 1.5600000000000002e-21   NTclustered gi|2427259007|ref|XM_052971768.1| 37653 g87555 i0 84.034 3.98684210526316 119 19 78 0 30 148 586 704 PREDICTED: Octopus bimaculoides 2-oxoisovalerate dehydrogenase subunit alpha, mitochondrial (LOC106879837), transcript variant X2, mRNA blastn 606 115 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides

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