RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA692200", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA692200 · 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
672782 672782 PRJNA692200_S_NODE_21101_length_164_cov_1.339130_g21044_i0 PRJNA692200 21101 164 1.33913 2.1961732 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.014   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g21044 i0 96.774 0.189024390243902 31 1 19 0 60 90 36375456 36375486 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
672891 672891 PRJNA692200_S_NODE_3881_length_315_cov_1.492481_g3824_i0 PRJNA692200 3881 315 1.492481 4.70131515 Ailoscolex lacteospumosus 1046305 Annelida Annelida 62.1 4.9e-5   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g3824 i0 97.222 3.88571428571429 36 1 11 0 212 247 14610310 14610275 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 1224 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
12151977 12151977 PRJNA692200_S_NODE_21810_length_162_cov_2.955752_g21753_i0 PRJNA692200 21810 162 2.955752 4.78831824 Oligochaeta environmental sample 333472 Annelida Annelida 257 2.66e-64   NTclustered gi|68271334|gb|DQ086515.1| 333472 g21753 i0 95.625 92.3086419753086 160 7 99 0 1 160 177 18 Uncultured Oligochaeta sp. isolate Oligoc06 large subunit ribosomal RNA gene, partial sequence blastn 14954 257 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata       Oligochaeta environmental sample
14701947 14701947 PRJNA692200_S_NODE_6792_length_259_cov_2419.480952_g6735_i0 PRJNA692200 6792 259 2419.480952 6266.45566568 Slavina appendiculata 188233 Annelida Annelida 283 7.679999999999999e-72   NTclustered gi|2741723584|gb|PP893275.1| 188233 g6735 i0 91.038 65.8918918918919 212 16 81 3 3 213 5693 5902 Slavina appendiculata mitochondrion, partial genome blastn 17066 283 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Tubificida Naididae Slavina Slavina appendiculata
17250772 17250772 PRJNA692200_S_NODE_4414_length_301_cov_12.051587_g4357_i0 PRJNA692200 4414 301 12.051587 36.27527687 Theromyzon tessulatum 13286 Annelida Annelida 105 1.62e-24   NR AAN28680.1 13286 g4357 i0 68.9 0.737541528239203 74 18 68.8 2 7 213 278 351 AAN28680.1 cathepsin L [Theromyzon tessulatum] diamond 222 105 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Theromyzon Theromyzon tessulatum
28946023 28946023 PRJNA692200_S_NODE_9268_length_231_cov_1.379121_g9211_i0 PRJNA692200 9268 231 1.379121 3.18576951 Dimorphilus gyrociliatus 2664684 Annelida Annelida 79.7 3.01e-15   NR CAD5123944.1 2664684 g9211 i0 44.7 2.96103896103896 76 40 98.7 1 2 229 740 813 CAD5123944.1 DgyrCDS12251 [Dimorphilus gyrociliatus] diamond 684 79.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus

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