RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA615175" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA615175 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
4978013 4978013 PRJNA615175_P_NODE_7844_length_536_cov_79.332613_g7678_i0 PRJNA615175 7844 536 79.332613 425.22280568 Bivalvia 6544 Mollusca Mollusca 161 8.379999999999998e-35   NTclustered gi|2334761650|ref|XM_052209352.1| 6549 g7678 i0 83.24 16.8246268656716 179 26 33 3 304 480 204 28 PREDICTED: Mytilus californianus 60S ribosomal protein L27a-like (LOC127705074), mRNA blastn 9018 161 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
4978014 4978014 PRJNA615175_P_NODE_8124_length_526_cov_1.123620_g7957_i0 PRJNA615175 8124 526 1.12362 5.9102412 Metazoa 33208 Mollusca Mollusca 961 0   NTclustered gi|1928112764|gb|MT947788.1| 6523 g7957 i0 99.62 100 526 2 100 0 1 526 1577 1052 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 52600 961 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
8248389 8248389 PRJNA615175_P_NODE_8127_length_525_cov_9.893805_g7960_i0 PRJNA615175 8127 525 9.893805 51.94247625 Idiosepius paradoxus 294707 Mollusca Mollusca 54.7 0.014   NTclustered gi|325504932|dbj|AB586703.1| 294707 g7960 i0 96.875 0.060952380952381 32 1 6 0 1 32 8 39 Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda   Idiosepiidae Idiosepius Idiosepius paradoxus
17173098 17173098 PRJNA615175_P_NODE_9194_length_489_cov_1.480769_g9026_i0 PRJNA615175 9194 489 1.480769 7.24096041 Mercenaria mercenaria 6596 Mollusca Mollusca 52.8 0.048   NTclustered gi|2441971836|ref|XM_045309525.2| 6596 g9026 i0 100 0.0572597137014315 28 0 6 0 366 393 437 410 PREDICTED: Mercenaria mercenaria calcineurin subunit B type 1 (LOC123529266), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria

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