RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1092581 · 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
4022697 4022697 PRJNA1092581_P_NODE_125924_length_204_cov_4.664122_g125391_i0 PRJNA1092581 125924 204 4.664122 9.51480888 Platynereis dumerilii 6359 Annelida Annelida 82.4 2.27e-11   NTclustered gi|146189520|emb|AM697674.1| 6359 g125391 i0 93.103 5.63235294117647 58 1 27 2 149 204 209 153 Platynereis dumerilii mRNA for hypothetical protein (ORF1), isolate 2 blastn 1149 82.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Phyllodocida Nereididae Platynereis Platynereis dumerilii
4024891 4024891 PRJNA1092581_P_NODE_94984_length_261_cov_1.648936_g94451_i0 PRJNA1092581 94984 261 1.648936 4.30372296 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003593|emb|OZ238871.1| 1046305 g94451 i0 100 0.111111111111111 29 0 11 0 136 164 20733402 20733430 Ailoscolex lacteospumosus genome assembly, chromosome: 12 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
5298828 5298828 PRJNA1092581_P_NODE_121125_length_218_cov_9.524138_g120592_i0 PRJNA1092581 121125 218 9.524138 20.76262084 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.019   NTclustered gi|2920003608|emb|OZ238872.1| 1046305 g120592 i0 96.774 0.142201834862385 31 1 14 0 163 193 4071752 4071782 Ailoscolex lacteospumosus genome assembly, chromosome: 13 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
5298998 5298998 PRJNA1092581_P_NODE_14545_length_723_cov_4.983077_g14053_i0 PRJNA1092581 14545 723 4.983077 36.02764671 Ailoscolex lacteospumosus 1046305 Annelida Annelida 60.2 4.32e-4   NTclustered gi|2920003578|emb|OZ238870.1| 1046305 g14053 i0 100 0.558782849239281 32 0 4 0 559 590 20749211 20749180 Ailoscolex lacteospumosus genome assembly, chromosome: 11 blastn 404 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
7849986 7849986 PRJNA1092581_P_NODE_57727_length_350_cov_2.498195_g57194_i0 PRJNA1092581 57727 350 2.498195 8.7436825 Ailoscolex lacteospumosus 1046305 Annelida Annelida 58.4 7.11e-4   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g57194 i0 100 0.297142857142857 31 0 9 0 271 301 18983373 18983343 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 104 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
9125475 9125475 PRJNA1092581_P_NODE_77708_length_294_cov_3.357466_g77175_i0 PRJNA1092581 77708 294 3.357466 9.87095004 Hirudo verbana 311461 Annelida Annelida 60.2 1.63e-4   NTclustered gi|2918369720|emb|OZ237792.1| 311461 g77175 i0 92.857 0.829931972789116 42 2 14 1 238 279 5905111 5905071 Hirudo verbana genome assembly, chromosome: 14 blastn 244 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
12952053 12952053 PRJNA1092581_P_NODE_97571_length_256_cov_10.038251_g97038_i0 PRJNA1092581 97571 256 10.038251 25.69792256 Amynthas corticis 351238 Annelida Annelida 436 5.5e-118   NTclustered gi|927371976|ref|NC_027832.1| 351238 g97038 i0 100 85.59765625 236 0 92 0 21 256 10371 10606 Amynthas corticis mitochondrion, complete genome blastn 21913 436 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Amynthas Amynthas corticis

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