RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1118794 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
231013 231013 PRJNA1118794_P_NODE_67161_length_243_cov_1.658824_g66411_i0 PRJNA1118794 67161 243 1.658824 4.03094232 Hirudo verbana 311461 Annelida Annelida 54.7 0.006   NTclustered gi|2918369720|emb|OZ237792.1| 311461 g66411 i0 94.286 0.1440329218107 35 2 14 0 99 133 7372766 7372732 Hirudo verbana genome assembly, chromosome: 14 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
4057488 4057488 PRJNA1118794_P_NODE_36624_length_276_cov_1.344828_g35874_i0 PRJNA1118794 36624 276 1.344828 3.71172528 Helobdella robusta 6412 Annelida Annelida 54.7 0.007   NTclustered gi|675848169|ref|XM_009011397.1| 6412 g35874 i0 96.875 0.278985507246377 32 1 12 0 175 206 1515 1546 Helobdella robusta hypothetical protein partial mRNA blastn 77 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
6609099 6609099 PRJNA1118794_P_NODE_70486_length_242_cov_0.911243_g69736_i0 PRJNA1118794 70486 242 0.911243 2.20520806 Helobdella robusta 6412 Annelida Annelida 54.7 0.006   NTclustered gi|675891101|ref|XM_009032805.1| 6412 g69736 i0 100 4.57851239669422 29 0 12 0 143 171 178 150 Helobdella robusta hypothetical protein partial mRNA blastn 1108 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
7883919 7883919 PRJNA1118794_P_NODE_62427_length_245_cov_1.436047_g61677_i0 PRJNA1118794 62427 245 1.436047 3.51831515 Hirudo verbana 311461 Annelida Annelida 52.8 0.022   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g61677 i0 100 0.114285714285714 28 0 11 0 137 164 13497012 13497039 Hirudo verbana genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
9158294 9158294 PRJNA1118794_P_NODE_25428_length_311_cov_1.647059_g24678_i0 PRJNA1118794 25428 311 1.647059 5.12235349 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.008   NTclustered gi|2920003636|emb|OZ238874.1| 1046305 g24678 i0 94.444 0.115755627009646 36 1 12 1 36 71 6310121 6310087 Ailoscolex lacteospumosus genome assembly, chromosome: 15 blastn 36 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
10434096 10434096 PRJNA1118794_P_NODE_33309_length_284_cov_1.194313_g32559_i0 PRJNA1118794 33309 284 1.194313 3.39184892 Ailoscolex lacteospumosus 1046305 Annelida Annelida 62.1 4.36e-5   NTclustered gi|2920003527|emb|OZ238867.1| 1046305 g32559 i0 86.207 0.742957746478873 58 6 20 2 173 229 27179493 27179437 Ailoscolex lacteospumosus genome assembly, chromosome: 8 blastn 211 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
11709326 11709326 PRJNA1118794_P_NODE_31270_length_289_cov_1.166667_g30520_i0 PRJNA1118794 31270 289 1.166667 3.37166763 Hirudo verbana 311461 Annelida Annelida 52.8 0.027   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g30520 i0 88.636 0.152249134948097 44 3 15 2 68 110 2139552 2139510 Hirudo verbana genome assembly, chromosome: 12 blastn 44 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
15533668 15533668 PRJNA1118794_P_NODE_68113_length_243_cov_0.905882_g67363_i0 PRJNA1118794 68113 243 0.905882 2.20129326 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.002   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g67363 i0 96.97 0.135802469135802 33 1 14 0 146 178 1638127 1638095 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
19357061 19357061 PRJNA1118794_P_NODE_9916_length_449_cov_0.752660_g9168_i0 PRJNA1118794 9916 449 0.75266 3.3794434 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.012   NTclustered gi|2920003651|emb|OZ238876.1| 1046305 g9168 i0 100 0.0645879732739421 29 0 6 0 313 341 14326604 14326632 Ailoscolex lacteospumosus genome assembly, chromosome: 17 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
21907799 21907799 PRJNA1118794_P_NODE_52498_length_250_cov_0.870056_g51748_i0 PRJNA1118794 52498 250 0.870056 2.17514 Hirudo verbana 311461 Annelida Annelida 58.4 4.87e-4   NTclustered gi|2918369614|emb|OZ237780.1| 311461 g51748 i0 81.333 0.984 75 10 29 4 168 240 11260806 11260878 Hirudo verbana genome assembly, chromosome: 2 blastn 246 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
23183122 23183122 PRJNA1118794_P_NODE_56059_length_248_cov_0.880000_g55309_i0 PRJNA1118794 56059 248 0.88 2.1824 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g55309 i0 100 0.112903225806452 28 0 11 0 4 31 21952999 21953026 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 28 52.8 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);;