RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA348537", tax_kingdom = "Metazoa" 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

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA348537 · 6 ✖

analysis 1

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
393548 393548 PRJNA348537_S_NODE_521_length_379_cov_8.287791_g475_i0 PRJNA348537 521 379 8.287791 31.41072789 Magallana angulata 2784310 Mollusca Mollusca 579 1.3399999999999999e-160   NTclustered gi|2416874841|ref|XR_008241671.1| 2784310 g475 i0 99.068 84.8390501319261 322 3 85 0 1 322 3461 3782 PREDICTED: Crassostrea angulata large subunit ribosomal RNA (LOC128170120), rRNA blastn 32154 579 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
1070413 1070413 PRJNA348537_S_NODE_1301_length_254_cov_7.826484_g1255_i0 PRJNA348537 1301 254 7.826484 19.87926936 Ostreidae 6563 Mollusca Mollusca 464 2.4999999999999994e-126   NTclustered gi|1832334954|gb|MT353676.1| 29159 g1255 i0 100 94.0511811023622 251 0 99 0 3 253 656 906 Crassostrea gigas isolate 3155 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 23889 464 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
7448299 7448299 PRJNA348537_S_NODE_2066_length_207_cov_9.162791_g2020_i0 PRJNA348537 2066 207 9.162791 18.96697737 Ostreidae 6563 Mollusca Mollusca 377 2.63e-100   NTclustered gi|1843197836|ref|XR_004597991.1| 29159 g2020 i0 99.517 100.009661835749 207 1 100 0 1 207 139 345 PREDICTED: Magallana gigas small subunit ribosomal RNA (LOC117684133), rRNA blastn 20702 377 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
11273636 11273636 PRJNA348537_S_NODE_4509_length_152_cov_4.666667_g4463_i0 PRJNA348537 4509 152 4.666667 7.09333384 Magallana 147004 Mollusca Mollusca 276 6.770000000000001e-70   NTclustered gi|28375710|dbj|AB102757.1| 29159 g4463 i0 99.342 99 152 1 100 0 1 152 2222 2071 Crassostrea gigas genes for ITS2, 28S rRNA, partial sequence, country: Japan: Okinawa (Haneji inland sea) blastn 15048 276 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
11273637 11273637 PRJNA348537_S_NODE_509_length_382_cov_175.210375_g463_i0 PRJNA348537 509 382 175.210375 669.3036325 Magallana 147004 Mollusca Mollusca 638 2.2e-178   NTclustered gi|2087356261|dbj|LC648604.1| 29159 g463 i0 100 90.3403141361257 345 0 90 0 34 378 205 549 Crassostrea gigas IDEA_Shell201 gene for 28S rRNA, partial sequence blastn 34510 638 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
11872106 11872106 PRJNA348537_S_NODE_3770_length_163_cov_1.414062_g3724_i0 PRJNA348537 3770 163 1.414062 2.30492106 Magallana gigas 29159 Mollusca Mollusca 243 7.51e-60   NTclustered gi|2751280140|ref|XR_010714402.1| 29159 g3724 i0 94.839 161.815950920245 155 8 95 0 1 155 1879 2033 PREDICTED: Magallana gigas uncharacterized lncRNA (LOC117685150), ncRNA blastn 26376 243 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas

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