RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA914897" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA914897 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
4723412 4723412 PRJNA914897_P_NODE_27244_length_308_cov_1.727660_g26820_i0 PRJNA914897 27244 308 1.72766 5.3211928 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g26820 i0 100 0.0974025974025974 30 0 10 0 243 272 8208837 8208866 Hirudo verbana genome assembly, chromosome: 12 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
8547766 8547766 PRJNA914897_P_NODE_18927_length_393_cov_1.203125_g18505_i0 PRJNA914897 18927 393 1.203125 4.72828125 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.038   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g18505 i0 100 0.0712468193384224 28 0 7 0 119 146 19930353 19930380 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
9822797 9822797 PRJNA914897_P_NODE_3028_length_1135_cov_15.147834_g2777_i0 PRJNA914897 3028 1135 15.147834 171.9279159 Theromyzon tessulatum 13286 Annelida Annelida 313 4.8000000000000006e-80   NTclustered gi|23344733|gb|AF542132.1| 13286 g2777 i0 96.791 0.586784140969163 187 6 16 0 52 238 1161 975 Theromyzon tessulatum cathepsin L mRNA, complete cds blastn 666 313 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Theromyzon Theromyzon tessulatum
17473218 17473218 PRJNA914897_P_NODE_42474_length_241_cov_0.916667_g42050_i0 PRJNA914897 42474 241 0.916667 2.20916747 Hirudo verbana 311461 Annelida Annelida 58.4 4.66e-4   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g42050 i0 97.059 2.7551867219917 34 1 14 0 200 233 1147419 1147386 Hirudo verbana genome assembly, chromosome: 12 blastn 664 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
23847042 23847042 PRJNA914897_P_NODE_11699_length_540_cov_1.486081_g11279_i0 PRJNA914897 11699 540 1.486081 8.0248374 Hirudo verbana 311461 Annelida Annelida 54.7 0.015   NTclustered gi|2918369620|emb|OZ237782.1| 311461 g11279 i0 96.875 0.0592592592592593 32 1 6 0 50 81 12401612 12401643 Hirudo verbana genome assembly, chromosome: 4 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
23847314 23847314 PRJNA914897_P_NODE_4279_length_969_cov_3.138393_g3972_i0 PRJNA914897 4279 969 3.138393 30.41102817 Hirudo verbana 311461 Annelida Annelida 58.4 0.002   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g3972 i0 94.737 0.302373581011352 38 0 4 2 263 298 13114835 13114798 Hirudo verbana genome assembly, chromosome: 3 blastn 293 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
25120921 25120921 PRJNA914897_P_NODE_21580_length_360_cov_1.620209_g21156_i0 PRJNA914897 21580 360 1.620209 5.8327524 Hirudo verbana 311461 Annelida Annelida 71.3 9.42e-8   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g21156 i0 100 0.977777777777778 38 0 11 0 5 42 1933209 1933172 Hirudo verbana genome assembly, chromosome: 11 blastn 352 71.3 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);;