RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA193544 · 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
365860 365860 PRJNA193544_S_NODE_141_length_429_cov_12.480000_g128_i0 PRJNA193544 141 429 12.48 53.5392 Leptochiton asellus 211853 Mollusca Mollusca 147 1.85e-30   NTclustered gi|34369208|gb|AY145414.1| 211853 g128 i0 85.315 3.2027972027972 143 20 33 1 287 429 2701 2560 Leptochiton asellus 28S ribosomal RNA gene, partial sequence blastn 1374 147 1 Eukaryota Opisthokonta Metazoa Mollusca Polyplacophora Lepidopleurida Lepidopleuridae Leptochiton Leptochiton asellus
2330543 2330543 PRJNA193544_S_NODE_922_length_258_cov_34.366812_g907_i0 PRJNA193544 922 258 34.366812 88.66637496 Pinctada 50425 Mollusca Mollusca 80.5 1.08e-10   NTclustered gi|67423693|dbj|AB214466.1| 102329 g907 i0 89.062 0.496124031007752 64 7 25 0 24 87 3649 3586 Pinctada margaritifera gene for 28S rRNA, complete sequence, country:Japan:Okinawa blastn 128 80.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada margaritifera
5469207 5469207 PRJNA193544_S_NODE_1565_length_210_cov_11.325967_g1550_i0 PRJNA193544 1565 210 11.325967 23.7845307 Leptochiton asellus 211853 Mollusca Mollusca 145 2.96e-30   NTclustered gi|34369208|gb|AY145414.1| 211853 g1550 i0 83.333 6.22857142857143 162 21 76 6 51 210 2717 2560 Leptochiton asellus 28S ribosomal RNA gene, partial sequence blastn 1308 145 1 Eukaryota Opisthokonta Metazoa Mollusca Polyplacophora Lepidopleurida Lepidopleuridae Leptochiton Leptochiton asellus
6157973 6157973 PRJNA193544_S_NODE_2925_length_162_cov_4.578947_g2910_i0 PRJNA193544 2925 162 4.578947 7.41789414 Lucinidae 42655 Mollusca Mollusca 152 1.29e-32   NTclustered gi|2127706950|gb|OL339379.1| 244476 g2910 i0 83.851 87.6481481481482 161 24 99 2 1 160 3215 3056 Divaricella irpex voucher UF 432892 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 14199 152 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Lucinida Lucinidae Divaricella Divaricella irpex
9983299 9983299 PRJNA193544_S_NODE_508_length_315_cov_12330.272727_g493_i0 PRJNA193544 508 315 12330.272727 38840.35909005 Ctena 102298 Mollusca Mollusca 148 3.659999999999999e-31   NTclustered gi|2129023951|gb|OL361786.1| 2892552 g493 i0 90.909 7.87936507936508 110 10 35 0 34 143 4159 4050 Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 2482 148 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Lucinida Lucinidae Ctena Ctena cf. galapagana NHMUK 20210086

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