RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB43370 · 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
1334533 1334533 PRJEB43370_P_NODE_4302_length_215_cov_1.385542_g4259_i0 PRJEB43370 4302 215 1.385542 2.9789153 Mizuhopecten yessoensis 6573 Mollusca Mollusca 165 2.33e-36   NTclustered gi|1207980043|ref|XM_021483868.1| 6573 g4259 i0 80.861 45.4418604651163 209 40 97 0 4 212 172 380 PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L10-like (LOC110440716), mRNA blastn 9770 165 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
2610164 2610164 PRJEB43370_P_NODE_8103_length_168_cov_0.873950_g8060_i0 PRJEB43370 8103 168 0.87395 1.468236 Pomacea canaliculata 400727 Mollusca Mollusca 62.1 2.34e-5   NTclustered gi|1397664316|ref|XM_025228474.1| 400727 g8060 i0 92.857 0.946428571428571 42 3 25 0 127 168 1540 1499 PREDICTED: Pomacea canaliculata uncharacterized LOC112558184 (LOC112558184), transcript variant X2, mRNA blastn 159 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
3886311 3886311 PRJEB43370_P_NODE_3724_length_228_cov_1.787709_g3681_i0 PRJEB43370 3724 228 1.787709 4.07597652 Mizuhopecten yessoensis 6573 Mollusca Mollusca 156 1.51e-33   NTclustered gi|1207979951|ref|XM_021483817.1| 6573 g3681 i0 83.146 10.0614035087719 178 22 76 8 55 228 257 84 PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S17-B-like (LOC110440653), partial mRNA blastn 2294 156 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
5162536 5162536 PRJEB43370_P_NODE_5645_length_191_cov_2.197183_g5602_i0 PRJEB43370 5645 191 2.197183 4.19661953 Biomphalaria glabrata 6526 Mollusca Mollusca 89.8 1.25e-13   NTclustered gi|2502174295|ref|XM_013225235.2| 6526 g5602 i0 91.045 0.350785340314136 67 4 35 2 20 85 301 236 PREDICTED: Biomphalaria glabrata uncharacterized LOC106066252 (LOC106066252), mRNA blastn 67 89.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
14088553 14088553 PRJEB43370_P_NODE_1752_length_331_cov_1.475177_g1709_i0 PRJEB43370 1752 331 1.475177 4.88283587 Physella acuta 109671 Mollusca Mollusca 54.7 0.009   NTclustered gi|2572426195|ref|XM_059283729.1| 109671 g1709 i0 100 0.172205438066465 29 0 9 0 140 168 381 409 PREDICTED: Physella acuta dehydrogenase/reductase SDR family member 7B-like (LOC131927857), mRNA blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
17911810 17911810 PRJEB43370_P_NODE_9695_length_164_cov_1.356522_g9652_i0 PRJEB43370 9695 164 1.356522 2.22469608 Mizuhopecten yessoensis 6573 Mollusca Mollusca 89.8 1.04e-13   NTclustered gi|1207980000|ref|XM_021483844.1| 6573 g9652 i0 83.871 0.567073170731707 93 15 57 0 11 103 40 132 PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S13-like (LOC110440687), mRNA blastn 93 89.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
21736924 21736924 PRJEB43370_P_NODE_7318_length_169_cov_2.166667_g7275_i0 PRJEB43370 7318 169 2.166667 3.66166723 Saccostrea cuccullata 36930 Mollusca Mollusca 161 2.25e-35   NTclustered gi|2669103391|ref|XM_062730828.1| 36930 g7275 i0 83.929 24.2840236686391 168 27 99 0 2 169 614 781 PREDICTED: Saccostrea cucullata large ribosomal subunit protein uL2-like (LOC134248420), mRNA blastn 4104 161 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata

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