RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1214993 · 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
5433469 5433469 PRJNA1214993_P_NODE_17405_length_268_cov_2.235897_g17219_i0 PRJNA1214993 17405 268 2.235897 5.99220396 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g17219 i0 100 0.108208955223881 29 0 11 0 2 30 17840576 17840604 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
5433505 5433505 PRJNA1214993_P_NODE_23245_length_247_cov_0.885057_g23059_i0 PRJNA1214993 23245 247 0.885057 2.18609079 Ailoscolex lacteospumosus 1046305 Annelida Annelida 58.4 4.8e-4   NTclustered gi|2920003563|emb|OZ238869.1| 1046305 g23059 i0 89.583 0.311740890688259 48 2 18 3 71 115 8635696 8635743 Ailoscolex lacteospumosus genome assembly, chromosome: 10 blastn 77 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
20731809 20731809 PRJNA1214993_P_NODE_3957_length_533_cov_4.754348_g3772_i0 PRJNA1214993 3957 533 4.754348 25.34067484 Hirudo verbana 311461 Annelida Annelida 58.4 0.001   NTclustered gi|2918369621|emb|OZ237783.1| 311461 g3772 i0 97.143 0.842401500938086 35 0 7 1 286 320 12290707 12290740 Hirudo verbana genome assembly, chromosome: 5 blastn 449 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22007017 22007017 PRJNA1214993_P_NODE_10818_length_334_cov_1.490421_g10632_i0 PRJNA1214993 10818 334 1.490421 4.97800614 Hirudo verbana 311461 Annelida Annelida 58.4 6.77e-4   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g10632 i0 97.143 0.104790419161677 35 0 10 1 295 329 5221475 5221508 Hirudo verbana genome assembly, chromosome: 1 blastn 35 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22007131 22007131 PRJNA1214993_P_NODE_24218_length_245_cov_0.906977_g24032_i0 PRJNA1214993 24218 245 0.906977 2.22209365 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003508|emb|OZ238866.1| 1046305 g24032 i0 100 0.228571428571429 28 0 11 0 93 120 28942752 28942725 Ailoscolex lacteospumosus genome assembly, chromosome: 7 blastn 56 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);;