RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1150539 · 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
5403945 5403945 PRJNA1150539_S_NODE_101525_length_242_cov_1.786982_g100929_i0 PRJNA1150539 101525 242 1.786982 4.32449644 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g100929 i0 100 0.115702479338843 28 0 12 0 215 242 17340647 17340620 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
5404786 5404786 PRJNA1150539_S_NODE_82145_length_263_cov_2.057895_g81549_i0 PRJNA1150539 82145 263 2.057895 5.41226385 Ailoscolex lacteospumosus 1046305 Annelida Annelida 65.8 3.08e-6   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g81549 i0 100 5.17110266159696 35 0 14 0 210 244 7707807 7707841 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 1360 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
18152645 18152645 PRJNA1150539_S_NODE_110135_length_223_cov_12.946667_g109539_i0 PRJNA1150539 110135 223 12.946667 28.87106741 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369720|emb|OZ237792.1| 311461 g109539 i0 92.5 0.587443946188341 40 1 18 2 145 184 3045071 3045108 Hirudo verbana genome assembly, chromosome: 14 blastn 131 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
20702452 20702452 PRJNA1150539_S_NODE_20957_length_379_cov_2.107843_g20361_i0 PRJNA1150539 20957 379 2.107843 7.98872497 Ailoscolex lacteospumosus 1046305 Annelida Annelida 67.6 1.29e-6   NTclustered gi|2920003636|emb|OZ238874.1| 1046305 g20361 i0 97.436 0.20844327176781 39 1 10 0 283 321 12637500 12637462 Ailoscolex lacteospumosus genome assembly, chromosome: 15 blastn 79 67.6 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
21977703 21977703 PRJNA1150539_S_NODE_102698_length_241_cov_1.375000_g102102_i0 PRJNA1150539 102698 241 1.375 3.31375 Hirudo verbana 311461 Annelida Annelida 52.8 0.022   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g102102 i0 100 0.116182572614108 28 0 12 0 5 32 14767891 14767864 Hirudo verbana genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24527325 24527325 PRJNA1150539_S_NODE_50640_length_310_cov_1.949367_g50044_i0 PRJNA1150539 50640 310 1.949367 6.0430377 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.029   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g50044 i0 100 0.0903225806451613 28 0 9 0 255 282 10862768 10862741 Ailoscolex lacteospumosus genome assembly, chromosome: 9 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);;