RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1240804 · 5 ✖

analysis 1

  • diamond · 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
27249699 27249699 PRJNA1240804_P_NODE_41523_length_234_cov_2.248649_g41157_i0 PRJNA1240804 41523 234 2.248649 5.26183866 Opisthokonta 33154 Mollusca Mollusca 65.5 3.23e-10   NR KAK6167008.1 87958 g41157 i0 44.3 4.64102564102564 70 39 89.7 0 9 218 405 474 KAK6167008.1 hypothetical protein SNE40_021121 [Patella caerulea] diamond 1086 65.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella caerulea
28589498 28589498 PRJNA1240804_P_NODE_119347_length_167_cov_0.881356_g118981_i0 PRJNA1240804 119347 167 0.881356 1.47186452 Crassostrea virginica 6565 Mollusca Mollusca 70.5 2.19e-12   NR XP_022315529.1 6565 g118981 i0 90.6 2.29940119760479 32 3 57.5 0 70 165 939 970 XP_022315529.1 DNA-directed RNA polymerase I subunit RPA1-like [Crassostrea virginica] diamond 384 70.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
30768654 30768654 PRJNA1240804_P_NODE_150974_length_162_cov_0.920354_g150608_i0 PRJNA1240804 150974 162 0.920354 1.49097348 Magallana gigas 29159 Mollusca Mollusca 52.4 5.04e-6   NR XP_011416541.3 29159 g150608 i0 52.3 4.05555555555556 44 21 81.5 0 19 150 261 304 XP_011416541.3 diacylglycerol kinase epsilon [Magallana gigas] diamond 657 52.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
32146522 32146522 PRJNA1240804_P_NODE_67338_length_196_cov_1.734694_g66972_i0 PRJNA1240804 67338 196 1.734694 3.40000024 Opisthokonta 33154 Mollusca Mollusca 43.1 0.0147   NR CAG2204468.1 6550 g66972 i0 32.1 1.53061224489796 56 38 85.7 0 172 5 105 160 CAG2204468.1 unnamed protein product [Mytilus edulis] diamond 300 43.5 0.990804597701149 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
32620768 32620768 PRJNA1240804_P_NODE_131020_length_165_cov_0.896552_g130654_i0 PRJNA1240804 131020 165 0.896552 1.4793108 Metazoa 33208 Mollusca Mollusca 59.3 1.81e-8   NR XP_052816977.1 6604 g130654 i0 52 35.4545454545455 50 24 90.9 0 151 2 189 238 XP_052816977.1 H(+)/Cl(-) exchange transporter 7-like [Mya arenaria] diamond 5850 59.3 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria

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