RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493828 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
3657900 3657900 PRJNA493828_P_NODE_5263_length_479_cov_11.125616_g4873_i0 PRJNA493828 5263 479 11.125616 53.29170064 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 54.7 0.013   NTclustered gi|2693871861|ref|XR_010104559.1| 6551 g4873 i0 100 0.609603340292276 29 0 6 0 1 29 3289 3317 PREDICTED: Mytilus trossulus large subunit ribosomal RNA (LOC134702777), rRNA blastn 292 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
8128081 8128081 PRJNA493828_P_NODE_8507_length_386_cov_18.265176_g8092_i0 PRJNA493828 8507 386 18.265176 70.50357936 Physella acuta 109671 Mollusca Mollusca 691 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g8092 i0 99.217 4.21761658031088 383 3 99 0 1 383 3768 3386 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 1628 691 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
10678339 10678339 PRJNA493828_P_NODE_32309_length_251_cov_0.865169_g31890_i0 PRJNA493828 32309 251 0.865169 2.17157419 Haliotis rufescens 6454 Mollusca Mollusca 54.7 0.006   NTclustered gi|2245631347|ref|XM_046496882.2| 6454 g31890 i0 100 0.231075697211155 29 0 12 0 170 198 2728 2700 PREDICTED: Haliotis rufescens uncharacterized LOC124132767 (LOC124132767), transcript variant X1, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
10678436 10678436 PRJNA493828_P_NODE_38769_length_242_cov_0.911243_g38350_i0 PRJNA493828 38769 242 0.911243 2.20520806 Mytilus edulis 6550 Mollusca Mollusca 54.7 0.006   NTclustered gi|2912346022|ref|XM_071286065.1| 6550 g38350 i0 100 0.119834710743802 29 0 12 0 175 203 555 527 PREDICTED: Mytilus edulis putative leucine-rich repeat-containing protein DDB_G0290503 (LOC139497828), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
17052136 17052136 PRJNA493828_P_NODE_35694_length_246_cov_1.236994_g35275_i0 PRJNA493828 35694 246 1.236994 3.04300524 Lottia gigantea 225164 Mollusca Mollusca 154 5.9200000000000005e-33   NTclustered gi|676460691|ref|XM_009057459.1| 225164 g35275 i0 85.616 23.6341463414634 146 21 59 0 70 215 182 37 Lottia gigantea hypothetical protein partial mRNA blastn 5814 154 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
18326400 18326400 PRJNA493828_P_NODE_32255_length_251_cov_0.865169_g31836_i0 PRJNA493828 32255 251 0.865169 2.17157419 Haliotis rufescens 6454 Mollusca Mollusca 58.4 4.89e-4   NTclustered gi|2245725797|ref|XM_046472408.2| 6454 g31836 i0 100 1.50199203187251 31 0 12 0 169 199 3516 3546 PREDICTED: Haliotis rufescens uncharacterized LOC124112341 (LOC124112341), transcript variant X2, mRNA blastn 377 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens

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