RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA911178 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
892872 892872 PRJNA911178_P_NODE_296081_length_239_cov_5.783133_g293607_i0 PRJNA911178 296081 239 5.783133 13.82168787 Hirudo verbana 311461 Annelida Annelida 58.4 4.62e-4   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g293607 i0 100 0.246861924686192 31 0 13 0 170 200 1763935 1763905 Hirudo verbana genome assembly, chromosome: 12 blastn 59 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
7270460 7270460 PRJNA911178_P_NODE_222566_length_259_cov_6.397849_g220092_i0 PRJNA911178 222566 259 6.397849 16.57042891 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369720|emb|OZ237792.1| 311461 g220092 i0 92.5 0.154440154440154 40 1 15 2 201 240 3045071 3045108 Hirudo verbana genome assembly, chromosome: 14 blastn 40 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
8544996 8544996 PRJNA911178_P_NODE_198667_length_272_cov_2.246231_g196194_i0 PRJNA911178 198667 272 2.246231 6.10974832 Lumbriculus sp. EZ-2019 2480966 Annelida Annelida 318 2.23e-82   NTclustered gi|1494622620|gb|MK076419.1| 2480966 g196194 i0 89.453 44.9080882352941 256 21 93 4 3 255 3290 3542 Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence blastn 12215 318 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Lumbriculida Lumbriculidae Lumbriculus Lumbriculus sp. EZ-2019
9819879 9819879 PRJNA911178_P_NODE_185528_length_280_cov_1.111111_g183055_i0 PRJNA911178 185528 280 1.111111 3.1111108 Hirudo verbana 311461 Annelida Annelida 62.1 4.29e-5   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g183055 i0 91.111 2.53571428571429 45 4 16 0 82 126 2059804 2059760 Hirudo verbana genome assembly, chromosome: 9 blastn 710 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
11096351 11096351 PRJNA911178_P_NODE_288589_length_242_cov_0.911243_g286115_i0 PRJNA911178 288589 242 0.911243 2.20520806 Stylaria lacustris 41694 Annelida Annelida 69.4 2.16e-7   NTclustered gi|38350388|gb|AY366517.1| 41694 g286115 i0 91.837 9.27272727272727 49 4 20 0 192 240 1717 1765 Stylaria lacustris 28S ribosomal RNA gene, partial sequence blastn 2244 69.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Tubificida Naididae Stylaria Stylaria lacustris
12371690 12371690 PRJNA911178_P_NODE_263290_length_246_cov_12.526012_g260816_i0 PRJNA911178 263290 246 12.526012 30.81398952 Eisenia fetida 6396 Annelida Annelida 416 6.839999999999999e-112   NTclustered gi|11494215|gb|AF212166.1|AF212166 6396 g260816 i0 98.312 130.048780487805 237 4 96 0 9 245 3389 3625 Eisenia fetida 28S ribosomal RNA gene, partial sequence blastn 31992 416 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Eisenia Eisenia fetida
12372623 12372623 PRJNA911178_P_NODE_83110_length_390_cov_4.233438_g80643_i0 PRJNA911178 83110 390 4.233438 16.5104082 Hirudo verbana 311461 Annelida Annelida 60.2 2.23e-4   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g80643 i0 100 2.01538461538462 32 0 9 0 288 319 1760047 1760016 Hirudo verbana genome assembly, chromosome: 11 blastn 786 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
13646656 13646656 PRJNA911178_P_NODE_307311_length_212_cov_10.906475_g304837_i0 PRJNA911178 307311 212 10.906475 23.121727 Hirudo verbana 311461 Annelida Annelida 99 2.36e-16   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g304837 i0 81.25 0.60377358490566 128 18 58 4 40 162 11097531 11097405 Hirudo verbana genome assembly, chromosome: 8 blastn 128 99 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
20018839 20018839 PRJNA911178_P_NODE_217316_length_262_cov_1.931217_g214842_i0 PRJNA911178 217316 262 1.931217 5.05978854 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003593|emb|OZ238871.1| 1046305 g214842 i0 100 0.110687022900763 29 0 11 0 109 137 19537732 19537760 Ailoscolex lacteospumosus genome assembly, chromosome: 12 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
22927162 22927162 PRJNA911178_P_NODE_114378_length_341_cov_3.750000_g111906_i0 PRJNA911178 114378 341 3.75 12.7875 Clitellata 42113 Annelida Annelida 612 1.18e-170   NTclustered gi|145321025|gb|EF534709.1| 6396 g111906 i0 99.408 131.612903225806 338 1 99 1 4 341 40 376 Eisenia fetida 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 44880 617 0.991896272285251 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Eisenia Eisenia fetida
22928092 22928092 PRJNA911178_P_NODE_306918_length_215_cov_9.718310_g304444_i0 PRJNA911178 306918 215 9.71831 20.8943665 Lumbricidae 6392 Annelida Annelida 398 2.1099999999999997e-106   NTclustered gi|383088845|gb|JQ739972.1| 6396 g304444 i0 100 130.967441860465 215 0 100 0 1 215 227 13 Eisenia fetida isolate H32 28S ribosomal RNA gene, partial sequence blastn 28158 398 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Eisenia Eisenia fetida

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