RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA229468 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
2917900 2917900 PRJNA229468_S_NODE_163_length_378_cov_1.683891_g150_i0 PRJNA229468 163 378 1.683891 6.36510798 Lottia gigantea 225164 Mollusca Mollusca 226 1.9999999999999998e-54   NTclustered gi|676456588|ref|XM_009056125.1| 225164 g150 i0 83.065 7.94708994708995 248 42 66 0 25 272 386 139 Lottia gigantea hypothetical protein mRNA blastn 3004 226 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
6744941 6744941 PRJNA229468_S_NODE_426_length_240_cov_1.198953_g413_i0 PRJNA229468 426 240 1.198953 2.8774872 Physella acuta 109671 Mollusca Mollusca 154 5.75e-33   NTclustered gi|2572306679|ref|XM_059294357.1| 109671 g413 i0 82.065 28.5208333333333 184 30 76 3 1 183 305 486 PREDICTED: Physella acuta large ribosomal subunit protein uL14 (LOC131937156), mRNA blastn 6845 154 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
19493241 19493241 PRJNA229468_S_NODE_1156_length_164_cov_0.886957_g1143_i0 PRJNA229468 1156 164 0.886957 1.45460948 Saccostrea cuccullata 36930 Mollusca Mollusca 52.8 0.014   NTclustered gi|2669042795|ref|XM_062758970.1| 36930 g1143 i0 96.774 0.378048780487805 31 1 19 0 99 129 2414 2384 PREDICTED: Saccostrea cucullata MAM and LDL-receptor class A domain-containing protein 2-like (LOC134276709), mRNA blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata

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