RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA689790 · 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
1944761 1944761 PRJNA689790_S_NODE_16302_length_152_cov_1.356522_g16187_i0 PRJNA689790 16302 152 1.356522 2.06191344 Cirriformia luxuriosa 398471 Annelida Annelida 108 2.62e-19   NTclustered gi|112144461|gb|DQ813355.1| 398471 g16187 i0 87.234 18.2697368421053 94 12 62 0 53 146 503 596 Cirriformia luxuriosa elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds blastn 2777 108 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Cirratulidae Cirriformia Cirriformia luxuriosa
12657533 12657533 PRJNA689790_S_NODE_13570_length_163_cov_2.166667_g13455_i0 PRJNA689790 13570 163 2.166667 3.53166721 Opisthokonta 33154 Annelida Annelida 54.7 0.004   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g13455 i0 94.286 2.50306748466258 35 2 21 0 55 89 652232 652266 Hirudo verbana genome assembly, chromosome: 13 blastn 408 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
18520779 18520779 PRJNA689790_S_NODE_14655_length_158_cov_2.256198_g14540_i0 PRJNA689790 14655 158 2.256198 3.56479284 Hirudo verbana 311461 Annelida Annelida 58.4 2.81e-4   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g14540 i0 92.5 0.253164556962025 40 3 25 0 111 150 1492683 1492722 Hirudo verbana genome assembly, chromosome: 10 blastn 40 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24894913 24894913 PRJNA689790_S_NODE_15200_length_156_cov_1.630252_g15085_i0 PRJNA689790 15200 156 1.630252 2.54319312 Helobdella robusta 6412 Annelida Annelida 89.8 9.79e-14   NTclustered gi|675878013|ref|XM_009026319.1| 6412 g15085 i0 81.905 3.98076923076923 105 19 67 0 42 146 288 184 Helobdella robusta hypothetical protein mRNA blastn 621 89.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
24894967 24894967 PRJNA689790_S_NODE_6560_length_233_cov_1.515306_g6445_i0 PRJNA689790 6560 233 1.515306 3.53066298 Hirudo verbana 311461 Annelida Annelida 58.4 4.48e-4   NTclustered gi|2918369643|emb|OZ237784.1| 311461 g6445 i0 97.059 0.145922746781116 34 1 15 0 91 124 9986770 9986737 Hirudo verbana genome assembly, chromosome: 6 blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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