RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB17675" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB17675 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
2571527 2571527 PRJEB17675_P_NODE_19123_length_179_cov_1.437500_g18819_i0 PRJEB17675 19123 179 1.4375 2.573125 Helobdella robusta 6412 Annelida Annelida 119 1.47e-22   NTclustered gi|675867723|ref|XM_009021174.1| 6412 g18819 i0 79.755 2.40223463687151 163 33 91 0 3 165 1299 1461 Helobdella robusta hypothetical protein mRNA blastn 430 119 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
7673916 7673916 PRJEB17675_P_NODE_21787_length_164_cov_2.480620_g21483_i0 PRJEB17675 21787 164 2.48062 4.0682168 Hirudo verbana 311461 Annelida Annelida 62.1 2.27e-5   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g21483 i0 93.182 1.48170731707317 44 0 26 3 35 76 10152254 10152212 Hirudo verbana genome assembly, chromosome: 10 blastn 243 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
10224422 10224422 PRJEB17675_P_NODE_23729_length_156_cov_1.859504_g23425_i0 PRJEB17675 23729 156 1.859504 2.9008262399999998 Hirudo verbana 311461 Annelida Annelida 99 1.63e-16   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g23425 i0 81.25 0.82051282051282 128 18 79 4 3 125 11097531 11097405 Hirudo verbana genome assembly, chromosome: 8 blastn 128 99 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
12775220 12775220 PRJEB17675_P_NODE_16091_length_200_cov_1.933333_g15787_i0 PRJEB17675 16091 200 1.933333 3.866666 Ailoscolex lacteospumosus 1046305 Annelida Annelida 75 3.71e-9   NTclustered gi|2920003508|emb|OZ238866.1| 1046305 g15787 i0 91.228 28.49 57 2 28 3 133 186 11647275 11647331 Ailoscolex lacteospumosus genome assembly, chromosome: 7 blastn 5698 75 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
19147095 19147095 PRJEB17675_P_NODE_11656_length_249_cov_1.121495_g11352_i0 PRJEB17675 11656 249 1.121495 2.79252255 Ailoscolex lacteospumosus 1046305 Annelida Annelida 62.1 3.74e-5   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g11352 i0 93.023 92.8835341365462 43 1 18 2 26 67 31362459 31362500 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 23128 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
19147120 19147120 PRJEB17675_P_NODE_17716_length_188_cov_1.568627_g17412_i0 PRJEB17675 17716 188 1.568627 2.94901876 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.001   NTclustered gi|2920003527|emb|OZ238867.1| 1046305 g17412 i0 92.308 1.36702127659574 39 3 21 0 132 170 19189808 19189770 Ailoscolex lacteospumosus genome assembly, chromosome: 8 blastn 257 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
21698427 21698427 PRJEB17675_P_NODE_7938_length_323_cov_2.340278_g7634_i0 PRJEB17675 7938 323 2.340278 7.55909794 Ophryotrocha mammillata 1697379 Annelida Annelida 235 2.81e-57   NTclustered gi|918026465|gb|KP731526.1| 1697379 g7634 i0 81.72 69.3839009287926 279 51 86 0 1 279 279 1 Ophryotrocha mammillata voucher DBUA0001555.V06 histone H3 (H3) gene, partial cds blastn 22411 235 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Eunicida Dorvilleidae Ophryotrocha Ophryotrocha mammillata
22973612 22973612 PRJEB17675_P_NODE_1299_length_855_cov_2.658537_g1120_i0 PRJEB17675 1299 855 2.658537 22.73049135 Ailoscolex lacteospumosus 1046305 Annelida Annelida 71.3 2.38e-7   NTclustered gi|2920003651|emb|OZ238876.1| 1046305 g1120 i0 97.561 0.140350877192982 41 1 5 0 201 241 13704843 13704883 Ailoscolex lacteospumosus genome assembly, chromosome: 17 blastn 120 71.3 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);;