RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA715462" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA715462 · 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
3257299 3257299 PRJNA715462_P_NODE_40443_length_280_cov_0.961353_g39647_i0 PRJNA715462 40443 280 0.961353 2.6917884 Hirudo verbana 311461 Annelida Annelida 54.7 0.007   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g39647 i0 100 0.535714285714286 29 0 10 0 203 231 10156416 10156388 Hirudo verbana genome assembly, chromosome: 8 blastn 150 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
5808967 5808967 PRJNA715462_P_NODE_15145_length_500_cov_1.814988_g14350_i0 PRJNA715462 15145 500 1.814988 9.07494 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.049   NTclustered gi|2920003593|emb|OZ238871.1| 1046305 g14350 i0 100 0.056 28 0 6 0 43 70 16589265 16589292 Ailoscolex lacteospumosus genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
14735059 14735059 PRJNA715462_P_NODE_46972_length_260_cov_1.647059_g46176_i0 PRJNA715462 46972 260 1.647059 4.2823534 Ailoscolex lacteospumosus 1046305 Annelida Annelida 63.9 1.09e-5   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g46176 i0 88.462 5.06923076923077 52 6 20 0 165 216 26921127 26921076 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 1318 63.9 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
16008341 16008341 PRJNA715462_P_NODE_32053_length_314_cov_1.261411_g31257_i0 PRJNA715462 32053 314 1.261411 3.96083054 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.002   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g31257 i0 97.059 0.10828025477707 34 0 11 1 223 255 374436 374469 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
17284089 17284089 PRJNA715462_P_NODE_44714_length_267_cov_1.195876_g43918_i0 PRJNA715462 44714 267 1.195876 3.19298892 Ailoscolex lacteospumosus 1046305 Annelida Annelida 65.8 3.14e-6   NTclustered gi|2920003563|emb|OZ238869.1| 1046305 g43918 i0 93.333 1.68164794007491 45 1 16 2 68 111 24058212 24058169 Ailoscolex lacteospumosus genome assembly, chromosome: 10 blastn 449 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
18557888 18557888 PRJNA715462_P_NODE_45695_length_264_cov_1.371728_g44899_i0 PRJNA715462 45695 264 1.371728 3.62136192 Hirudo verbana 311461 Annelida Annelida 52.8 0.024   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g44899 i0 100 0.106060606060606 28 0 11 0 92 119 15683759 15683786 Hirudo verbana genome assembly, chromosome: 1 blastn 28 52.8 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);;