RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA613025 · 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
2423990 2423990 PRJNA613025_S_NODE_18922_length_230_cov_0.845304_g18768_i0 PRJNA613025 18922 230 0.84530400000000006 1.9441992 Euprymna 6612 Mollusca Mollusca 418 1.7599999999999996e-112   NTclustered gi|2022611894|dbj|LC597610.1| 6613 g18768 i0 99.13 86.3478260869565 230 2 100 0 1 230 719 948 Euprymna scolopes 2020GS-euscolo gene for 18S rRNA, partial sequence blastn 19860 420 0.995238095238095 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiolidae Euprymna Euprymna scolopes
9520119 9520119 PRJNA613025_S_NODE_23368_length_197_cov_1.722973_g23214_i0 PRJNA613025 23368 197 1.722973 3.39425681 Patella vulgata 6465 Mollusca Mollusca 161 2.7199999999999997e-35   NTclustered gi|2506340964|ref|XM_056102908.1| 6465 g23214 i0 90.833 18.8426395939086 120 11 61 0 76 195 477 358 PREDICTED: Patella vulgata tubulin beta chain-like (LOC126831076), mRNA blastn 3712 161 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
13346001 13346001 PRJNA613025_S_NODE_27891_length_175_cov_1.619048_g27737_i0 PRJNA613025 27891 175 1.619048 2.833334 Falcidens sp. C NTM-2018 2136829 Mollusca Mollusca 73.1 1.13e-8   NTclustered gi|1370811541|gb|MG855782.1| 2136829 g27737 i0 93.75 26.4628571428571 48 3 27 0 36 83 458 411 Falcidens sp. C NTM-2018 voucher ZMBN 123752 28S ribosomal RNA gene, partial sequence blastn 4631 73.1 1 Eukaryota Opisthokonta Metazoa Mollusca Caudofoveata Chaetodermatida Chaetodermatidae Falcidens Falcidens sp. C NTM-2018
14620754 14620754 PRJNA613025_S_NODE_23352_length_197_cov_2.040541_g23198_i0 PRJNA613025 23352 197 2.040541 4.01986577 Donax cuneatus 120567 Mollusca Mollusca 63.9 7.88e-6   NTclustered gi|47496707|dbj|AB126328.1| 120567 g23198 i0 95 0.203045685279188 40 2 20 0 34 73 2859 2898 Donax cuneatus gene for ITS2, 28S rRNA, partial sequence, country:Japan:Okinawa, Nago blastn 40 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Cardiida Donacidae Donax Donax cuneatus
16451566 16451566 PRJNA613025_S_NODE_20813_length_213_cov_2.957317_g20659_i0 PRJNA613025 20813 213 2.957317 6.29908521 Metazoa 33208 Mollusca Mollusca 52.8 0.019   NTclustered gi|2427390617|ref|XM_052917999.1| 6604 g20659 i0 100 2.06572769953052 28 0 13 0 135 162 5153 5126 PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA blastn 440 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
23544460 23544460 PRJNA613025_S_NODE_33399_length_162_cov_0.884956_g33245_i0 PRJNA613025 33399 162 0.884956 1.43362872 Lottia gigantea 225164 Mollusca Mollusca 165 1.66e-36   NTclustered gi|676472385|ref|XM_009061227.1| 225164 g33245 i0 85.443 37.3456790123457 158 23 98 0 1 158 144 301 Lottia gigantea hypothetical protein mRNA blastn 6050 165 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
25375139 25375139 PRJNA613025_S_NODE_25440_length_186_cov_1.489051_g25286_i0 PRJNA613025 25440 186 1.489051 2.76963486 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.5 0.001   NTclustered gi|594617949|gb|KJ366217.1| 926819 g25286 i0 100 1.32795698924731 30 0 16 0 33 62 744 715 Pinna carnea voucher MNHN_IM-2013-7093 28S ribosomal RNA gene, partial sequence blastn 247 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pinnidae Pinna Pinna carnea

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