RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA558770", tax_kingdom = "Metazoa" 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

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA558770 · 6 ✖

analysis 1

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
4365952 4365952 PRJNA558770_P_NODE_171044_length_234_cov_5.110553_g169039_i0 PRJNA558770 171044 234 5.110553 11.95869402 Hirudo verbana 311461 Annelida Annelida 52.8 0.021   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g169039 i0 100 0.11965811965812 28 0 12 0 13 40 316081 316054 Hirudo verbana genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
6233800 6233800 PRJNA558770_P_NODE_72505_length_244_cov_2.119617_g70500_i0 PRJNA558770 72505 244 2.119617 5.17186548 Metazoa 33208 Annelida Annelida 54.7 0.006   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g70500 i0 100 0.237704918032787 29 0 12 0 24 52 416234 416262 Hirudo verbana genome assembly, chromosome: 11 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
14567714 14567714 PRJNA558770_P_NODE_176312_length_234_cov_4.824121_g174307_i0 PRJNA558770 176312 234 4.824121 11.28844314 Hirudo verbana 311461 Annelida Annelida 67.6 7.48e-7   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g174307 i0 95.238 10.9017094017094 42 2 18 0 179 220 3751204 3751245 Hirudo verbana genome assembly, chromosome: 9 blastn 2551 67.6 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
19664775 19664775 PRJNA558770_P_NODE_163176_length_234_cov_5.562814_g161171_i0 PRJNA558770 163176 234 5.562814 13.01698476 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.021   NTclustered gi|2920003418|emb|OZ238863.1| 1046305 g161171 i0 100 0.11965811965812 28 0 12 0 23 50 23400641 23400614 Ailoscolex lacteospumosus genome assembly, chromosome: 4 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
19669298 19669298 PRJNA558770_P_NODE_77596_length_236_cov_9.084577_g75591_i0 PRJNA558770 77596 236 9.084577 21.43960172 Hirudo verbana 311461 Annelida Annelida 54.7 0.006   NTclustered gi|2918369621|emb|OZ237783.1| 311461 g75591 i0 100 0.122881355932203 29 0 12 0 43 71 12399967 12399939 Hirudo verbana genome assembly, chromosome: 5 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22216425 22216425 PRJNA558770_P_NODE_205958_length_234_cov_3.557789_g203953_i0 PRJNA558770 205958 234 3.557789 8.32522626 Hirudo verbana 311461 Annelida Annelida 58.4 4.5e-4   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g203953 i0 100 0.388888888888889 31 0 13 0 6 36 5348470 5348500 Hirudo verbana genome assembly, chromosome: 13 blastn 91 58.4 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);;