RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1022139 · 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
3988325 3988325 PRJNA1022139_P_NODE_38564_length_246_cov_0.890173_g38459_i0 PRJNA1022139 38564 246 0.890173 2.18982558 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.006   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g38459 i0 100 0.345528455284553 29 0 12 0 79 107 40433037 40433065 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
14190323 14190323 PRJNA1022139_P_NODE_32852_length_256_cov_1.316940_g32747_i0 PRJNA1022139 32852 256 1.31694 3.3713664 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369621|emb|OZ237783.1| 311461 g32747 i0 97.059 2.05078125 34 0 13 1 116 148 12647384 12647351 Hirudo verbana genome assembly, chromosome: 5 blastn 525 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
15464314 15464314 PRJNA1022139_P_NODE_2033_length_859_cov_2.473282_g1952_i0 PRJNA1022139 2033 859 2.473282 21.24549238 Hirudo verbana 311461 Annelida Annelida 58.4 0.002   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g1952 i0 100 0.947613504074505 31 0 4 0 253 283 1882535 1882565 Hirudo verbana genome assembly, chromosome: 3 blastn 814 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
18013473 18013473 PRJNA1022139_P_NODE_26855_length_278_cov_1.502439_g26750_i0 PRJNA1022139 26855 278 1.502439 4.17678042 Hirudo verbana 311461 Annelida Annelida 52.8 0.026   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g26750 i0 100 0.100719424460432 28 0 10 0 118 145 8684153 8684126 Hirudo verbana genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
21838402 21838402 PRJNA1022139_P_NODE_17378_length_332_cov_1.386100_g17273_i0 PRJNA1022139 17378 332 1.3861 4.601852 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.031   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g17273 i0 100 0.0843373493975904 28 0 8 0 26 53 20235459 20235486 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
24387772 24387772 PRJNA1022139_P_NODE_31080_length_263_cov_1.210526_g30975_i0 PRJNA1022139 31080 263 1.210526 3.18368338 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.024   NTclustered gi|2920003508|emb|OZ238866.1| 1046305 g30975 i0 100 0.106463878326996 28 0 11 0 49 76 20203018 20203045 Ailoscolex lacteospumosus genome assembly, chromosome: 7 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus

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