RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA971593" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA971593 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
944090 944090 PRJNA971593_P_NODE_11221_length_361_cov_0.982639_g11072_i0 PRJNA971593 11221 361 0.982639 3.54732679 Hirudo verbana 311461 Annelida Annelida 62.1 5.69e-5   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g11072 i0 92.857 0.227146814404432 42 3 12 0 195 236 1174997 1174956 Hirudo verbana genome assembly, chromosome: 12 blastn 82 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
2219644 2219644 PRJNA971593_P_NODE_25622_length_246_cov_0.890173_g25473_i0 PRJNA971593 25622 246 0.890173 2.18982558 Hirudo verbana 311461 Annelida Annelida 174 4.55e-39   NTclustered gi|2918369620|emb|OZ237782.1| 311461 g25473 i0 83.422 33.849593495935 187 31 76 0 60 246 15022035 15021849 Hirudo verbana genome assembly, chromosome: 4 blastn 8327 174 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
3494992 3494992 PRJNA971593_P_NODE_26823_length_244_cov_1.304094_g26674_i0 PRJNA971593 26823 244 1.304094 3.18198936 Metaphire californica 298374 Annelida Annelida 451 1.86e-122   NTclustered gi|836614179|ref|NC_027257.1| 298374 g26674 i0 100 18.2909836065574 244 0 100 0 1 244 4338 4095 Metaphire californica mitochondrion, complete genome blastn 4463 451 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Metaphire Metaphire californica
5094525 5094525 PRJNA971593_P_NODE_11404_length_358_cov_1.596491_g11255_i0 PRJNA971593 11404 358 1.596491 5.71543778 Megascolecidae 6400 Annelida Annelida 662 0   NTclustered gi|1497465297|gb|MK102885.1| 298374 g11255 i0 100 99.7122905027933 358 0 100 0 1 358 124 481 Metaphire californica isolate S187c large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 35697 662 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Metaphire Metaphire californica
6047536 6047536 PRJNA971593_P_NODE_28665_length_242_cov_0.911243_g28516_i0 PRJNA971593 28665 242 0.911243 2.20520806 Ailoscolex lacteospumosus 1046305 Annelida Annelida 150 7.509999999999998e-32   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g28516 i0 92.453 0.43801652892562 106 6 44 1 51 156 22620851 22620748 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 106 150 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
7644345 7644345 PRJNA971593_P_NODE_7166_length_454_cov_1.128609_g7017_i0 PRJNA971593 7166 454 1.128609 5.12388486 Metazoa 33208 Annelida Annelida 65.8 5.65e-6   NTclustered gi|675880757|ref|XM_009027633.1| 6412 g7017 i0 95.238 7.86784140969163 42 1 9 1 1 42 694 654 Helobdella robusta hypothetical protein partial mRNA blastn 3572 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
8597066 8597066 PRJNA971593_P_NODE_10127_length_381_cov_1.090909_g9978_i0 PRJNA971593 10127 381 1.090909 4.15636329 Amynthas sp. FB-2019 2507431 Annelida Annelida 556 6.31e-154   NTclustered gi|1561761345|gb|MH995906.1| 2507431 g9978 i0 93.158 0.99737532808399 380 24 99 2 1 379 20 398 Amynthas sp. FB-2019 extracellular globin mRNA, partial cds blastn 380 556 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Amynthas Amynthas sp. FB-2019
9872358 9872358 PRJNA971593_P_NODE_15408_length_305_cov_1.659483_g15259_i0 PRJNA971593 15408 305 1.659483 5.06142315 Hirudo verbana 311461 Annelida Annelida 291 5.5299999999999996e-74   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g15259 i0 84.053 95.5114754098361 301 48 99 0 5 305 5316881 5316581 Hirudo verbana genome assembly, chromosome: 9 blastn 29131 291 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
9872534 9872534 PRJNA971593_P_NODE_27568_length_243_cov_0.905882_g27419_i0 PRJNA971593 27568 243 0.905882 2.20129326 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g27419 i0 100 0.11522633744856 28 0 12 0 121 148 43430689 43430662 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
17522362 17522362 PRJNA971593_P_NODE_25814_length_246_cov_0.890173_g25665_i0 PRJNA971593 25814 246 0.890173 2.18982558 Metaphire californica 298374 Annelida Annelida 455 1.4500000000000002e-123   NTclustered gi|836614179|ref|NC_027257.1| 298374 g25665 i0 100 31.4512195121951 246 0 100 0 1 246 9695 9450 Metaphire californica mitochondrion, complete genome blastn 7737 455 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Metaphire Metaphire californica
18795940 18795940 PRJNA971593_P_NODE_13495_length_328_cov_0.941176_g13346_i0 PRJNA971593 13495 328 0.941176 3.08705728 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.031   NTclustered gi|2920003456|emb|OZ238864.1| 1046305 g13346 i0 100 0.0853658536585366 28 0 9 0 155 182 18756864 18756837 Ailoscolex lacteospumosus genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
18795955 18795955 PRJNA971593_P_NODE_14315_length_318_cov_1.244898_g14166_i0 PRJNA971593 14315 318 1.244898 3.95877564 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.008   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g14166 i0 92.308 0.122641509433962 39 1 12 2 133 169 36268065 36268027 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 39 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
24217877 24217877 PRJNA971593_P_NODE_18679_length_276_cov_1.137931_g18530_i0 PRJNA971593 18679 276 1.137931 3.14068956 Megascolecidae 6400 Annelida Annelida 499 7.54e-137   NTclustered gi|1496877574|gb|MK100051.1| 298374 g18530 i0 99.275 100.63768115942 276 2 100 0 1 276 516 791 Metaphire californica isolate SS187c small subunit ribosomal RNA gene, partial sequence; tRNA-Val gene, complete sequence; and large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 27776 499 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Metaphire Metaphire californica
25170559 25170559 PRJNA971593_P_NODE_6140_length_491_cov_0.772727_g5992_i0 PRJNA971593 6140 491 0.772727 3.79408957 Hirudo verbana 311461 Annelida Annelida 58.4 0.001   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g5992 i0 97.143 0.209775967413442 35 0 7 1 297 331 12693988 12693955 Hirudo verbana genome assembly, chromosome: 3 blastn 103 58.4 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);;