RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA855894 · 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
12321503 12321503 PRJNA855894_P_NODE_31790_length_247_cov_0.885057_g31668_i0 PRJNA855894 31790 247 0.885057 2.18609079 Mya arenaria 6604 Mollusca Mollusca 171 5.91e-38   NTclustered gi|2427442033|ref|XM_052906168.1| 6604 g31668 i0 79.339 45.1417004048583 242 50 98 0 4 245 1862 1621 PREDICTED: Mya arenaria polycystin-2-like (LOC128204697), transcript variant X11, mRNA blastn 11150 171 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
14869846 14869846 PRJNA855894_P_NODE_15332_length_393_cov_1.218750_g15210_i0 PRJNA855894 15332 393 1.21875 4.7896875 Ylistrum balloti 509963 Mollusca Mollusca 207 7.58e-49   NTclustered gi|2592067964|ref|XM_060213736.1| 509963 g15210 i0 80.989 14.7251908396947 263 48 67 2 132 393 1335 1074 PREDICTED: Ylistrum balloti spliceosome RNA helicase DDX39B (LOC132549774), mRNA blastn 5787 207 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Ylistrum Ylistrum balloti
21244288 21244288 PRJNA855894_P_NODE_28077_length_262_cov_1.423280_g27955_i0 PRJNA855894 28077 262 1.42328 3.7289936 Ylistrum balloti 509963 Mollusca Mollusca 206 1.7299999999999994e-48   NTclustered gi|2592060635|ref|XM_060209746.1| 509963 g27955 i0 81.707 13.7709923664122 246 45 94 0 17 262 22 267 PREDICTED: Ylistrum balloti small ribosomal subunit protein uS13 (LOC132546049), mRNA blastn 3608 206 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Ylistrum Ylistrum balloti

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