RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA976345 · 18 ✖

analysis 1

  • blastn · 18 ✖
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
947830 947830 PRJNA976345_P_NODE_134281_length_173_cov_2.188406_g132673_i0 PRJNA976345 134281 173 2.188406 3.78594238 Hirudo verbana 311461 Annelida Annelida 52.8 0.015   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g132673 i0 100 0.161849710982659 28 0 16 0 81 108 7938887 7938914 Hirudo verbana genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
2223124 2223124 PRJNA976345_P_NODE_125282_length_178_cov_1.104895_g123674_i0 PRJNA976345 125282 178 1.104895 1.9667131 Helobdella robusta 6412 Annelida Annelida 52.8 0.015   NTclustered gi|675893129|ref|XM_009033819.1| 6412 g123674 i0 100 0.157303370786517 28 0 16 0 7 34 1 28 Helobdella robusta hypothetical protein mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
2224218 2224218 PRJNA976345_P_NODE_82662_length_203_cov_2.428571_g81054_i0 PRJNA976345 82662 203 2.428571 4.92999913 Hirudo verbana 311461 Annelida Annelida 54.7 0.005   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g81054 i0 100 0.142857142857143 29 0 14 0 115 143 7649380 7649408 Hirudo verbana genome assembly, chromosome: 11 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
3499094 3499094 PRJNA976345_P_NODE_40903_length_269_cov_2.410256_g39295_i0 PRJNA976345 40903 269 2.410256 6.48358864 Hirudo verbana 311461 Annelida Annelida 54.7 0.007   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g39295 i0 100 0.33457249070632 29 0 12 0 27 55 8746787 8746759 Hirudo verbana genome assembly, chromosome: 9 blastn 90 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
6051947 6051947 PRJNA976345_P_NODE_60985_length_228_cov_1.865285_g59377_i0 PRJNA976345 60985 228 1.865285 4.2528498 Hirudo verbana 311461 Annelida Annelida 124 4.25e-24   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g59377 i0 95 3.95614035087719 80 2 34 2 147 224 2476368 2476447 Hirudo verbana genome assembly, chromosome: 8 blastn 902 124 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
7325486 7325486 PRJNA976345_P_NODE_101746_length_188_cov_3.993464_g100138_i0 PRJNA976345 101746 188 3.993464 7.50771232 Hirudo verbana 311461 Annelida Annelida 54.7 0.004   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g100138 i0 100 0.308510638297872 29 0 15 0 58 86 4225867 4225895 Hirudo verbana genome assembly, chromosome: 8 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
7325506 7325506 PRJNA976345_P_NODE_10546_length_531_cov_3.778226_g2181_i2 PRJNA976345 10546 531 3.778226 20.06238006 Hirudo verbana 311461 Annelida Annelida 311 7.790000000000001e-80   NTclustered gi|2918369620|emb|OZ237782.1| 311461 g2181 i2 94.581 8.82674199623352 203 8 45 1 156 358 7439096 7439295 Hirudo verbana genome assembly, chromosome: 4 blastn 4687 311 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
10195804 10195804 PRJNA976345_P_NODE_181328_length_155_cov_1.683333_g179720_i0 PRJNA976345 181328 155 1.683333 2.60916615 Metazoa 33208 Annelida Annelida 54.7 0.004   NTclustered gi|675866017|ref|XM_009020321.1| 6412 g179720 i0 100 1.7741935483871 29 0 19 0 109 137 233 261 Helobdella robusta hypothetical protein partial mRNA blastn 275 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
11151742 11151742 PRJNA976345_P_NODE_197129_length_150_cov_2.895652_g195521_i0 PRJNA976345 197129 150 2.895652 4.343478 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.012   NTclustered gi|2920003578|emb|OZ238870.1| 1046305 g195521 i0 100 0.186666666666667 28 0 19 0 46 73 1071418 1071391 Ailoscolex lacteospumosus genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
16250516 16250516 PRJNA976345_P_NODE_109693_length_183_cov_4.175676_g108085_i0 PRJNA976345 109693 183 4.175676 7.64148708 Ailoscolex lacteospumosus 1046305 Annelida Annelida 69.4 1.55e-7   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g108085 i0 97.561 0.224043715846995 41 0 22 1 143 183 18147373 18147412 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 41 69.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
16250954 16250954 PRJNA976345_P_NODE_177353_length_156_cov_2.198347_g175745_i0 PRJNA976345 177353 156 2.198347 3.42942132 Hirudo verbana 311461 Annelida Annelida 137 3.45e-28   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g175745 i0 95.349 13.4102564102564 86 4 100 0 71 156 8566880 8566965 Hirudo verbana genome assembly, chromosome: 3 blastn 2092 137 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
18799897 18799897 PRJNA976345_P_NODE_184075_length_154_cov_2.000000_g182467_i0 PRJNA976345 184075 154 2 3.08 Ailoscolex lacteospumosus 1046305 Annelida Annelida 126 7.34e-25   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g182467 i0 82.877 3.98051948051948 146 19 94 5 1 144 10906848 10906707 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 613 126 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
19118389 19118389 PRJNA976345_P_NODE_130435_length_175_cov_1.957143_g128827_i0 PRJNA976345 130435 175 1.957143 3.42500025 root 1 Root_unresolved Root_unresolved 52.8 0.015   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g128827 i0 100 0.32 28 0 16 0 131 158 13676632 13676659 Hirudo verbana genome assembly, chromosome: 1 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
20074436 20074436 PRJNA976345_P_NODE_137976_length_171_cov_3.875000_g136368_i0 PRJNA976345 137976 171 3.875 6.62625 Hirudo verbana 311461 Annelida Annelida 52.8 0.014   NTclustered gi|2918369614|emb|OZ237780.1| 311461 g136368 i0 100 0.16374269005848 28 0 16 0 118 145 10872831 10872858 Hirudo verbana genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
20074795 20074795 PRJNA976345_P_NODE_198136_length_150_cov_1.947826_g196528_i0 PRJNA976345 198136 150 1.947826 2.921739 Hirudo verbana 311461 Annelida Annelida 52.8 0.012   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g196528 i0 100 0.186666666666667 28 0 19 0 51 78 919043 919016 Hirudo verbana genome assembly, chromosome: 13 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
20075066 20075066 PRJNA976345_P_NODE_38896_length_275_cov_2.354167_g37289_i0 PRJNA976345 38896 275 2.354167 6.47395925 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.025   NTclustered gi|2920003593|emb|OZ238871.1| 1046305 g37289 i0 94.286 0.127272727272727 35 0 12 2 7 39 5384496 5384530 Ailoscolex lacteospumosus genome assembly, chromosome: 12 blastn 35 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
20075229 20075229 PRJNA976345_P_NODE_54216_length_239_cov_2.250000_g52608_i0 PRJNA976345 54216 239 2.25 5.3775 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.006   NTclustered gi|2920003484|emb|OZ238865.1| 1046305 g52608 i0 96.97 0.138075313807531 33 0 13 1 11 42 24842836 24842868 Ailoscolex lacteospumosus genome assembly, chromosome: 6 blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
25174411 25174411 PRJNA976345_P_NODE_30440_length_306_cov_2.660517_g28834_i0 PRJNA976345 30440 306 2.660517 8.14118202 Hirudo verbana 311461 Annelida Annelida 52.8 0.029   NTclustered gi|2918369614|emb|OZ237780.1| 311461 g28834 i0 100 0.0915032679738562 28 0 9 0 22 49 10600162 10600189 Hirudo verbana genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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