contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA414036" and tax_phylum = "Annelida"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1693663 | 1693663 | PRJNA414036_P_NODE_7122_length_477_cov_4.744344_g4333_i1 | PRJNA414036 | 7122 | 477 | 4.744344 | 22.63052088 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.046 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g4333 | i1 | 100 | 0.0587002096436059 | 28 | 0 | 6 | 0 | 80 | 107 | 2435889 | 2435916 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2969503 | 2969503 | PRJNA414036_P_NODE_4803_length_526_cov_17.299389_g3915_i0 | PRJNA414036 | 4803 | 526 | 17.299389 | 90.99478614 | Platynereis dumerilii | 6359 | Annelida | Annelida | 60.2 | 3.08e-4 | NTclustered | gi|83307875|emb|CT032362.1| | 6359 | g3915 | i0 | 88.235 | 0.347908745247148 | 51 | 5 | 10 | 1 | 74 | 124 | 716 | 765 | Platynereis dumerilii EST IB0AAA39CB11FM1 | blastn | 183 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 5522511 | 5522511 | PRJNA414036_P_NODE_36385_length_245_cov_5.266667_g34649_i0 | PRJNA414036 | 36385 | 245 | 5.266667 | 12.90333415 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g34649 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 28 | 56 | 7453128 | 7453100 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6796595 | 6796595 | PRJNA414036_P_NODE_7766_length_467_cov_5.365741_g4333_i2 | PRJNA414036 | 7766 | 467 | 5.365741 | 25.05801047 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.045 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g4333 | i2 | 100 | 0.0599571734475375 | 28 | 0 | 6 | 0 | 361 | 388 | 2435916 | 2435889 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8071977 | 8071977 | PRJNA414036_P_NODE_22307_length_320_cov_1768.940351_g20577_i0 | PRJNA414036 | 22307 | 320 | 1768.940351 | 5660.6091232 | Hesiospina sp. BC-2003 | 251473 | Annelida | Annelida | 147 | 1.34e-30 | NTclustered | gi|37706152|gb|AY340435.1| | 251473 | g20577 | i0 | 77.778 | 27.278125 | 243 | 51 | 76 | 3 | 78 | 320 | 940 | 1179 | Hesiospina sp. BC-2003 18S ribosomal RNA gene, partial sequence | blastn | 8729 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Hesionidae | Hesiospina | Hesiospina sp. BC-2003 | |
| 11897667 | 11897667 | PRJNA414036_P_NODE_68770_length_186_cov_890.423841_g67031_i0 | PRJNA414036 | 68770 | 186 | 890.423841 | 1656.18834426 | Urechis caupo | 6431 | Annelida | Annelida | 244 | 2.44e-60 | NTclustered | gi|340763912|gb|JF509731.1| | 6431 | g67031 | i0 | 90.811 | 98.747311827957 | 185 | 14 | 99 | 3 | 1 | 184 | 2002 | 2184 | Urechis caupo voucher AToL000328 28S ribosomal RNA gene, partial sequence | blastn | 18367 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Xenopneusta | Urechidae | Urechis | Urechis caupo | |
| 13172424 | 13172424 | PRJNA414036_P_NODE_24431_length_306_cov_97.952030_g22699_i0 | PRJNA414036 | 24431 | 306 | 97.95203 | 299.7332118 | Styloscolex baicalensis | 100962 | Annelida | Annelida | 76.8 | 1.69e-9 | NTclustered | gi|83638469|gb|DQ313228.1| | 100962 | g22699 | i0 | 76.19 | 0.480392156862745 | 147 | 34 | 48 | 1 | 19 | 164 | 7 | 153 | Styloscolex baicalensis 18S ribosomal RNA gene, partial sequence | blastn | 147 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Styloscolex | Styloscolex baicalensis | |
| 13172597 | 13172597 | PRJNA414036_P_NODE_88891_length_150_cov_3.886957_g87152_i0 | PRJNA414036 | 88891 | 150 | 3.886957 | 5.8304355 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.012 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g87152 | i0 | 100 | 0.186666666666667 | 28 | 0 | 19 | 0 | 99 | 126 | 13372107 | 13372080 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14447571 | 14447571 | PRJNA414036_P_NODE_23352_length_314_cov_2.200717_g21621_i0 | PRJNA414036 | 23352 | 314 | 2.200717 | 6.91025138 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.029 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g21621 | i0 | 100 | 0.089171974522293 | 28 | 0 | 9 | 0 | 10 | 37 | 1638397 | 1638370 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15721384 | 15721384 | PRJNA414036_P_NODE_31373_length_267_cov_4.340517_g29637_i0 | PRJNA414036 | 31373 | 267 | 4.340517 | 11.58918039 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g29637 | i0 | 100 | 0.108614232209738 | 29 | 0 | 11 | 0 | 28 | 56 | 7453128 | 7453100 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16996165 | 16996165 | PRJNA414036_P_NODE_34154_length_254_cov_6.196347_g32418_i0 | PRJNA414036 | 34154 | 254 | 6.196347 | 15.73872138 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g32418 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 219 | 246 | 18391290 | 18391263 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18270260 | 18270260 | PRJNA414036_P_NODE_13555_length_395_cov_3.361111_g11912_i0 | PRJNA414036 | 13555 | 395 | 3.361111 | 13.27638845 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 6.28e-5 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g11912 | i0 | 92.857 | 0.288607594936709 | 42 | 3 | 11 | 0 | 74 | 115 | 7038429 | 7038470 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 114 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18270394 | 18270394 | PRJNA414036_P_NODE_57315_length_227_cov_2.395833_g55576_i0 | PRJNA414036 | 57315 | 227 | 2.395833 | 5.43854091 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g55576 | i0 | 100 | 0.123348017621145 | 28 | 0 | 12 | 0 | 115 | 142 | 1663677 | 1663704 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19544517 | 19544517 | PRJNA414036_P_NODE_28876_length_280_cov_1.620408_g27141_i0 | PRJNA414036 | 28876 | 280 | 1.620408 | 4.5371424 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5.55e-4 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g27141 | i0 | 100 | 0.221428571428571 | 31 | 0 | 11 | 0 | 74 | 104 | 25119318 | 25119288 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20820360 | 20820360 | PRJNA414036_P_NODE_197_length_1031_cov_2.839357_g173_i0 | PRJNA414036 | 197 | 1031 | 2.839357 | 29.27377067 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 1.74e-4 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g173 | i0 | 100 | 0.0950533462657614 | 33 | 0 | 3 | 0 | 749 | 781 | 1844863 | 1844831 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 98 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22095093 | 22095093 | PRJNA414036_P_NODE_18278_length_351_cov_5.813291_g16561_i0 | PRJNA414036 | 18278 | 351 | 5.813291 | 20.40465141 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 7.13e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g16561 | i0 | 100 | 0.0883190883190883 | 31 | 0 | 9 | 0 | 107 | 137 | 1852858 | 1852888 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22095145 | 22095145 | PRJNA414036_P_NODE_32778_length_260_cov_2202.608889_g31042_i0 | PRJNA414036 | 32778 | 260 | 2202.608889 | 5726.7831114 | Hesiospina sp. BC-2003 | 251473 | Annelida | Annelida | 154 | 6.31e-33 | NTclustered | gi|37706152|gb|AY340435.1| | 251473 | g31042 | i0 | 78 | 33.5615384615385 | 250 | 52 | 96 | 3 | 11 | 260 | 933 | 1179 | Hesiospina sp. BC-2003 18S ribosomal RNA gene, partial sequence | blastn | 8726 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Hesionidae | Hesiospina | Hesiospina sp. BC-2003 | |
| 23370877 | 23370877 | PRJNA414036_P_NODE_56879_length_228_cov_10.243523_g55140_i0 | PRJNA414036 | 56879 | 228 | 10.243523 | 23.35523244 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g55140 | i0 | 100 | 0.12280701754386 | 28 | 0 | 12 | 0 | 186 | 213 | 1132020 | 1131993 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
Advanced export
JSON shape: default, array, newline-delimited
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);;