RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA797475 · 5 ✖

analysis 1

  • blastn · 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
12696538 12696538 PRJNA797475_P_NODE_13390_length_293_cov_1.400000_g13291_i0 PRJNA797475 13390 293 1.4 4.102 Metazoa 33208 Mollusca Mollusca 542 1.32e-149   NTclustered gi|1928112764|gb|MT947788.1| 6523 g13291 i0 100 100 293 0 100 0 1 293 211 503 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 29300 542 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
12696609 12696609 PRJNA797475_P_NODE_6710_length_391_cov_1.937107_g6611_i0 PRJNA797475 6710 391 1.937107 7.57408837 Metazoa 33208 Mollusca Mollusca 56.5 0.003   NTclustered gi|2694097628|ref|XM_063586004.1| 6551 g6611 i0 100 0.976982097186701 30 0 8 0 182 211 483 512 PREDICTED: Mytilus trossulus uncharacterized LOC134722385 (LOC134722385), mRNA blastn 382 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
18632806 18632806 PRJNA797475_P_NODE_14335_length_287_cov_1.439252_g14236_i0 PRJNA797475 14335 287 1.439252 4.13065324 Pecten maximus 6579 Mollusca Mollusca 156 1.97e-33   NTclustered gi|1835525678|ref|XM_033895776.1| 6579 g14236 i0 84.713 14 157 22 54 2 99 254 234 79 PREDICTED: Pecten maximus 60S ribosomal protein L27a-like (LOC117335639), mRNA blastn 4018 156 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
19908404 19908404 PRJNA797475_P_NODE_9816_length_334_cov_1.501916_g9717_i0 PRJNA797475 9816 334 1.501916 5.01639944 Saccostrea echinata 191078 Mollusca Mollusca 52.8 0.031   NTclustered gi|2628587666|ref|XM_061307106.1| 191078 g9717 i0 100 0.0838323353293413 28 0 8 0 219 246 5962 5935 PREDICTED: Saccostrea echinata E3 ubiquitin-protein ligase TRIM71-like (LOC133172256), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea echinata
21619077 21619077 PRJNA797475_P_NODE_25797_length_246_cov_0.890173_g25698_i0 PRJNA797475 25797 246 0.890173 2.18982558 Metazoa 33208 Mollusca Mollusca 455 1.4500000000000002e-123   NTclustered gi|1928112764|gb|MT947788.1| 6523 g25698 i0 100 100.012195121951 246 0 100 0 1 246 871 1116 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 24603 455 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis

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