RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA312899 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
379960 379960 PRJNA312899_P_NODE_64841_length_206_cov_1.299363_g64399_i0 PRJNA312899 64841 206 1.299363 2.67668778 Hirudo verbana 311461 Annelida Annelida 130 8.09e-26   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g64399 i0 84.615 5.39320388349515 130 20 63 0 42 171 3079066 3079195 Hirudo verbana genome assembly, chromosome: 1 blastn 1111 130 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
1654058 1654058 PRJNA312899_P_NODE_27682_length_353_cov_9.180921_g27240_i0 PRJNA312899 27682 353 9.180921 32.40865113 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.003   NTclustered gi|2920003636|emb|OZ238874.1| 1046305 g27240 i0 100 0.084985835694051 30 0 8 0 132 161 6818430 6818459 Ailoscolex lacteospumosus genome assembly, chromosome: 15 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
2929887 2929887 PRJNA312899_P_NODE_24543_length_378_cov_4.942249_g24101_i0 PRJNA312899 24543 378 4.942249 18.68170122 Hirudo verbana 311461 Annelida Annelida 65.8 4.63e-6   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g24101 i0 91.667 3.00529100529101 48 2 12 2 283 329 666824 666870 Hirudo verbana genome assembly, chromosome: 12 blastn 1136 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
4206723 4206723 PRJNA312899_P_NODE_41424_length_276_cov_11.392070_g40982_i0 PRJNA312899 41424 276 11.39207 31.4421132 Hirudo verbana 311461 Annelida Annelida 54.7 0.007   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g40982 i0 100 0.829710144927536 29 0 11 0 3 31 696916 696888 Hirudo verbana genome assembly, chromosome: 12 blastn 229 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
6757704 6757704 PRJNA312899_P_NODE_69546_length_194_cov_12.648276_g69104_i0 PRJNA312899 69546 194 12.648276 24.53765544 Lumbriculus sp. EZ-2019 2480966 Annelida Annelida 346 6.860000000000001e-91   NTclustered gi|1494622620|gb|MK076419.1| 2480966 g69104 i0 98.964 96.159793814433 193 2 99 0 2 194 3421 3229 Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence blastn 18655 346 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Lumbriculida Lumbriculidae Lumbriculus Lumbriculus sp. EZ-2019
8033136 8033136 PRJNA312899_P_NODE_61107_length_215_cov_2.457831_g60665_i0 PRJNA312899 61107 215 2.457831 5.28433665 Helmutneris vadum 2801950 Annelida Annelida 102 1.86e-17   NTclustered gi|1954991903|gb|MT763202.1| 2801950 g60665 i0 79.355 34.1395348837209 155 25 70 7 65 215 236 85 Helmutneris vadum voucher W44399 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 7340 102 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Eunicida Lumbrineridae Helmutneris Helmutneris vadum
11857631 11857631 PRJNA312899_P_NODE_13670_length_510_cov_78.550976_g13239_i0 PRJNA312899 13670 510 78.550976 400.6099776 Hirudo verbana 311461 Annelida Annelida 54.7 0.014   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g13239 i0 96.875 0.0627450980392157 32 1 6 0 119 150 3168846 3168815 Hirudo verbana genome assembly, chromosome: 13 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
11857658 11857658 PRJNA312899_P_NODE_14830_length_490_cov_27.594104_g14395_i0 PRJNA312899 14830 490 27.594104 135.2111096 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.013   NTclustered gi|2920003608|emb|OZ238872.1| 1046305 g14395 i0 100 0.0591836734693878 29 0 6 0 346 374 9703423 9703451 Ailoscolex lacteospumosus genome assembly, chromosome: 13 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
16956804 16956804 PRJNA312899_P_NODE_34034_length_312_cov_10.726236_g33592_i0 PRJNA312899 34034 312 10.726236 33.46585632 Hirudo verbana 311461 Annelida Annelida 76.8 1.73e-9   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g33592 i0 87.692 43.9839743589744 65 8 21 0 144 208 505283 505219 Hirudo verbana genome assembly, chromosome: 11 blastn 13723 76.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
19505142 19505142 PRJNA312899_P_NODE_20856_length_411_cov_32.016575_g20415_i0 PRJNA312899 20856 411 32.016575 131.58812325 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.003   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g20415 i0 100 0.072992700729927 30 0 7 0 336 365 21847366 21847395 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
19505584 19505584 PRJNA312899_P_NODE_43796_length_267_cov_6.711009_g43354_i0 PRJNA312899 43796 267 6.711009 17.91839403 Hirudo verbana 311461 Annelida Annelida 52.8 0.024   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g43354 i0 100 0.104868913857678 28 0 10 0 165 192 8279171 8279198 Hirudo verbana genome assembly, chromosome: 8 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24606329 24606329 PRJNA312899_P_NODE_83540_length_172_cov_1.609756_g83098_i0 PRJNA312899 83540 172 1.609756 2.76878032 Hirudo verbana 311461 Annelida Annelida 52.8 0.014   NTclustered gi|2918369643|emb|OZ237784.1| 311461 g83098 i0 100 0.488372093023256 28 0 16 0 109 136 11954806 11954779 Hirudo verbana genome assembly, chromosome: 6 blastn 84 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);;