RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA662254 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
10832368 10832368 PRJNA662254_P_NODE_22289_length_348_cov_1.672727_g21638_i0 PRJNA662254 22289 348 1.672727 5.82108996 Hirudo verbana 311461 Annelida Annelida 54.7 0.009   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g21638 i0 92.105 1.2183908045977 38 3 11 0 303 340 956879 956916 Hirudo verbana genome assembly, chromosome: 13 blastn 424 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
23580919 23580919 PRJNA662254_P_NODE_32859_length_290_cov_1.336406_g32208_i0 PRJNA662254 32859 290 1.336406 3.8755774 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g32208 i0 100 0.1 29 0 10 0 153 181 17840576 17840604 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
23580931 23580931 PRJNA662254_P_NODE_35819_length_280_cov_0.772947_g35168_i0 PRJNA662254 35819 280 0.772947 2.1642516 Ailoscolex lacteospumosus 1046305 Annelida Annelida 60.2 1.54e-4   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g35168 i0 97.143 0.889285714285714 35 1 13 0 62 96 31382065 31382099 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 249 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
24854604 24854604 PRJNA662254_P_NODE_49220_length_249_cov_0.875000_g48569_i0 PRJNA662254 49220 249 0.875 2.17875 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.002   NTclustered gi|2920003593|emb|OZ238871.1| 1046305 g48569 i0 100 0.232931726907631 30 0 12 0 211 240 22622290 22622261 Ailoscolex lacteospumosus genome assembly, chromosome: 12 blastn 58 56.5 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);;