RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1028258 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
163056 163056 PRJNA1028258_P_NODE_109941_length_252_cov_1.885246_g109378_i0 PRJNA1028258 109941 252 1.885246 4.75081992 Hirudo verbana 311461 Annelida Annelida 60.2 1.37e-4   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g109378 i0 100 3.11904761904762 32 0 13 0 111 142 1760047 1760016 Hirudo verbana genome assembly, chromosome: 11 blastn 786 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
1438708 1438708 PRJNA1028258_P_NODE_162342_length_228_cov_0.893082_g161779_i0 PRJNA1028258 162342 228 0.893082 2.03622696 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.006   NTclustered gi|2920003644|emb|OZ238875.1| 1046305 g161779 i0 100 0.254385964912281 29 0 13 0 175 203 16957547 16957575 Ailoscolex lacteospumosus genome assembly, chromosome: 16 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
2280176 2280176 PRJNA1028258_P_NODE_175162_length_225_cov_0.910256_g174599_i0 PRJNA1028258 175162 225 0.910256 2.048076 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.02   NTclustered gi|2920003484|emb|OZ238865.1| 1046305 g174599 i0 100 0.248888888888889 28 0 12 0 139 166 23517859 23517886 Ailoscolex lacteospumosus genome assembly, chromosome: 6 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
5268419 5268419 PRJNA1028258_P_NODE_81205_length_286_cov_1.359447_g80642_i0 PRJNA1028258 81205 286 1.359447 3.88801842 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g80642 i0 100 0.101398601398601 29 0 10 0 78 106 24960451 24960479 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
9092282 9092282 PRJNA1028258_P_NODE_35948_length_422_cov_2.807365_g35385_i0 PRJNA1028258 35948 422 2.807365 11.8470803 Phragmatopoma lapidosa 341668 Annelida Annelida 243 2.25e-59   NTclustered gi|322367326|gb|HQ121511.1| 341668 g35385 i0 80.308 11.8601895734597 325 60 77 4 2 324 462 140 Phragmatopoma lapidosa 40s ribosomal S14-like protein mRNA, complete cds blastn 5005 243 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Sabellariidae Phragmatopoma Phragmatopoma lapidosa
14193568 14193568 PRJNA1028258_P_NODE_46572_length_371_cov_1.645695_g46009_i0 PRJNA1028258 46572 371 1.645695 6.10552845 Hirudo verbana 311461 Annelida Annelida 54.7 0.01   NTclustered gi|2918369693|emb|OZ237785.1| 311461 g46009 i0 96.875 0.0862533692722372 32 1 9 0 229 260 1941527 1941496 Hirudo verbana genome assembly, chromosome: 7 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
15466967 15466967 PRJNA1028258_P_NODE_175793_length_225_cov_0.910256_g175230_i0 PRJNA1028258 175793 225 0.910256 2.048076 Hirudo verbana 311461 Annelida Annelida 63.9 9.24e-6   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g175230 i0 97.297 3.28888888888889 37 1 16 0 189 225 11190040 11190076 Hirudo verbana genome assembly, chromosome: 8 blastn 740 63.9 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
16740383 16740383 PRJNA1028258_P_NODE_128914_length_237_cov_1.303571_g128351_i0 PRJNA1028258 128914 237 1.303571 3.08946327 Hirudo verbana 311461 Annelida Annelida 58.4 4.57e-4   NTclustered gi|2918369621|emb|OZ237783.1| 311461 g128351 i0 87.037 0.345991561181435 54 4 23 2 169 222 11829057 11829107 Hirudo verbana genome assembly, chromosome: 5 blastn 82 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
19289948 19289948 PRJNA1028258_P_NODE_177836_length_225_cov_0.878205_g177273_i0 PRJNA1028258 177836 225 0.878205 1.97596125 Hirudo verbana 311461 Annelida Annelida 54.7 0.006   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g177273 i0 100 0.128888888888889 29 0 13 0 59 87 152411 152383 Hirudo verbana genome assembly, chromosome: 3 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22681480 22681480 PRJNA1028258_P_NODE_147298_length_232_cov_0.871166_g146735_i0 PRJNA1028258 147298 232 0.871166 2.02110512 Opisthokonta 33154 Annelida Annelida 196 9.06e-46   NTclustered gi|158187745|gb|EU124957.1| 6344 g146735 i0 86.517 45.1551724137931 178 24 77 0 5 182 721 544 Arenicola marina ribosomal protein rpl7 mRNA, complete cds blastn 10476 196 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Arenicolidae Arenicola Arenicola marina

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