contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 556030 | 556030 | PRJNA565584_P_NODE_199621_length_244_cov_0.900585_g198469_i0 | PRJNA565584 | 199621 | 244 | 0.900585 | 2.1974274 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g198469 | i0 | 100 | 0.467213114754098 | 30 | 0 | 12 | 0 | 136 | 165 | 5333663 | 5333692 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 114 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3105573 | 3105573 | PRJNA565584_P_NODE_123323_length_280_cov_0.908213_g122171_i0 | PRJNA565584 | 123323 | 280 | 0.908213 | 2.5429964 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5.55e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g122171 | i0 | 100 | 0.514285714285714 | 31 | 0 | 11 | 0 | 230 | 260 | 23829174 | 23829144 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 144 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3106941 | 3106941 | PRJNA565584_P_NODE_198463_length_244_cov_1.801170_g197311_i0 | PRJNA565584 | 198463 | 244 | 1.80117 | 4.3948548 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 2.83e-6 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g197311 | i0 | 87.5 | 0.860655737704918 | 56 | 7 | 23 | 0 | 115 | 170 | 31424590 | 31424645 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 210 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4382343 | 4382343 | PRJNA565584_P_NODE_131664_length_274_cov_1.532338_g130512_i0 | PRJNA565584 | 131664 | 274 | 1.532338 | 4.19860612 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g130512 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 28 | 55 | 763873 | 763846 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5660620 | 5660620 | PRJNA565584_P_NODE_38445_length_485_cov_1.817961_g37294_i0 | PRJNA565584 | 38445 | 485 | 1.817961 | 8.81711085 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 7.86e-5 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g37294 | i0 | 97.222 | 2.71546391752577 | 36 | 1 | 7 | 0 | 304 | 339 | 974980 | 975015 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 1317 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5660747 | 5660747 | PRJNA565584_P_NODE_43745_length_452_cov_1.451187_g42594_i0 | PRJNA565584 | 43745 | 452 | 1.451187 | 6.55936524 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g42594 | i0 | 94.595 | 0.274336283185841 | 37 | 2 | 8 | 0 | 414 | 450 | 1527715 | 1527679 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 124 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6932789 | 6932789 | PRJNA565584_P_NODE_125046_length_278_cov_2.990244_g123894_i0 | PRJNA565584 | 125046 | 278 | 2.990244 | 8.31287832 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g123894 | i0 | 100 | 0.205035971223022 | 29 | 0 | 10 | 0 | 138 | 166 | 597807 | 597835 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6935770 | 6935770 | PRJNA565584_P_NODE_80806_length_331_cov_1.046512_g79655_i0 | PRJNA565584 | 80806 | 331 | 1.046512 | 3.46395472 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 152 | 2.9899999999999996e-32 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g79655 | i0 | 90.517 | 0.577039274924471 | 116 | 9 | 35 | 2 | 2 | 116 | 10401163 | 10401277 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 191 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8208938 | 8208938 | PRJNA565584_P_NODE_194067_length_245_cov_1.790698_g192915_i0 | PRJNA565584 | 194067 | 245 | 1.790698 | 4.3872101 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.75e-4 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g192915 | i0 | 92.683 | 0.16734693877551 | 41 | 1 | 16 | 2 | 42 | 80 | 4665494 | 4665534 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 41 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8211053 | 8211053 | PRJNA565584_P_NODE_99387_length_299_cov_3.287611_g98235_i0 | PRJNA565584 | 99387 | 299 | 3.287611 | 9.82995689 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g98235 | i0 | 97.059 | 0.983277591973244 | 34 | 0 | 11 | 1 | 169 | 202 | 2680250 | 2680282 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 294 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9482956 | 9482956 | PRJNA565584_P_NODE_117128_length_283_cov_2.752381_g115976_i0 | PRJNA565584 | 117128 | 283 | 2.752381 | 7.78923823 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.21e-5 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g115976 | i0 | 95 | 30.9222614840989 | 40 | 2 | 16 | 0 | 4 | 43 | 8233573 | 8233534 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 8751 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9483179 | 9483179 | PRJNA565584_P_NODE_128748_length_276_cov_1.517241_g127596_i0 | PRJNA565584 | 128748 | 276 | 1.517241 | 4.18758516 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5.45e-4 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g127596 | i0 | 94.595 | 0.489130434782609 | 37 | 2 | 13 | 0 | 139 | 175 | 21148325 | 21148289 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 135 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9484645 | 9484645 | PRJNA565584_P_NODE_212788_length_241_cov_1.440476_g211636_i0 | PRJNA565584 | 212788 | 241 | 1.440476 | 3.47154716 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.6e-5 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g211636 | i0 | 100 | 0.273858921161826 | 33 | 0 | 14 | 0 | 156 | 188 | 9661694 | 9661662 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 66 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12613251 | 12613251 | PRJNA565584_P_NODE_168450_length_251_cov_0.865169_g167298_i0 | PRJNA565584 | 168450 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Annelida | Annelida | 67.6 | 8.12e-7 | NTclustered | gi|172053649|gb|EU418873.1| | 47111 | g167298 | i0 | 100 | 15.1075697211155 | 36 | 0 | 14 | 0 | 2 | 37 | 2060 | 2025 | Protodrilus ciliatus 28S ribosomal RNA gene, partial sequence | blastn | 3792 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Protodrilidae | Protodrilus | Protodrilus ciliatus | ||
| 14585256 | 14585256 | PRJNA565584_P_NODE_222152_length_226_cov_4.078431_g221000_i0 | PRJNA565584 | 222152 | 226 | 4.078431 | 9.21725406 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.34e-5 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g221000 | i0 | 91.304 | 1.78318584070796 | 46 | 2 | 20 | 2 | 18 | 62 | 10491807 | 10491763 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 403 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18407613 | 18407613 | PRJNA565584_P_NODE_170375_length_251_cov_0.865169_g169223_i0 | PRJNA565584 | 170375 | 251 | 0.865169 | 2.17157419 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.05e-5 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g169223 | i0 | 97.297 | 0.812749003984064 | 37 | 1 | 15 | 0 | 199 | 235 | 6621215 | 6621179 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 204 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19684217 | 19684217 | PRJNA565584_P_NODE_86056_length_320_cov_1.870445_g84904_i0 | PRJNA565584 | 86056 | 320 | 1.870445 | 5.985424 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.03 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g84904 | i0 | 100 | 0.0875 | 28 | 0 | 9 | 0 | 276 | 303 | 6037108 | 6037081 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20956537 | 20956537 | PRJNA565584_P_NODE_109537_length_288_cov_1.934884_g108385_i0 | PRJNA565584 | 109537 | 288 | 1.934884 | 5.57246592 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 5.73e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g108385 | i0 | 100 | 0.107638888888889 | 31 | 0 | 11 | 0 | 142 | 172 | 3272437 | 3272407 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20957033 | 20957033 | PRJNA565584_P_NODE_133817_length_273_cov_1.295000_g132665_i0 | PRJNA565584 | 133817 | 273 | 1.295 | 3.53535 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.5e-4 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g132665 | i0 | 94.872 | 7.58974358974359 | 39 | 1 | 14 | 1 | 95 | 132 | 22729169 | 22729131 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 2072 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20957973 | 20957973 | PRJNA565584_P_NODE_182637_length_248_cov_0.880000_g181485_i0 | PRJNA565584 | 182637 | 248 | 0.88 | 2.1824 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.34e-4 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g181485 | i0 | 92.683 | 2.03629032258065 | 41 | 3 | 17 | 0 | 113 | 153 | 5949229 | 5949189 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 505 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22232934 | 22232934 | PRJNA565584_P_NODE_184878_length_247_cov_1.770115_g183726_i0 | PRJNA565584 | 184878 | 247 | 1.770115 | 4.37218405 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g183726 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 11 | 38 | 3466708 | 3466681 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22234539 | 22234539 | PRJNA565584_P_NODE_69218_length_357_cov_1.619718_g68067_i0 | PRJNA565584 | 69218 | 357 | 1.619718 | 5.78239326 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.034 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g68067 | i0 | 100 | 0.0784313725490196 | 28 | 0 | 8 | 0 | 170 | 197 | 26443662 | 26443635 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23506593 | 23506593 | PRJNA565584_P_NODE_101099_length_297_cov_1.370536_g99947_i0 | PRJNA565584 | 101099 | 297 | 1.370536 | 4.07049192 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g99947 | i0 | 100 | 0.303030303030303 | 29 | 0 | 10 | 0 | 244 | 272 | 9380195 | 9380223 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 90 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24781471 | 24781471 | PRJNA565584_P_NODE_151560_length_261_cov_1.638298_g150408_i0 | PRJNA565584 | 151560 | 261 | 1.638298 | 4.27595778 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g150408 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 175 | 202 | 13730809 | 13730836 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
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);;