contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2136343 | 2136343 | PRJNA884104_S_NODE_48902_length_299_cov_1.238938_g48159_i0 | PRJNA884104 | 48902 | 299 | 1.238938 | 3.70442462 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.028 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g48159 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 0 | 74 | 101 | 20224388 | 20224415 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3411818 | 3411818 | PRJNA884104_S_NODE_55543_length_281_cov_0.975962_g54800_i0 | PRJNA884104 | 55543 | 281 | 0.975962 | 2.74245322 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g54800 | i0 | 100 | 0.814946619217082 | 29 | 0 | 10 | 0 | 189 | 217 | 1686868 | 1686840 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 229 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8513738 | 8513738 | PRJNA884104_S_NODE_46107_length_307_cov_1.414530_g45364_i0 | PRJNA884104 | 46107 | 307 | 1.41453 | 4.3426071 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 4.76e-5 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g45364 | i0 | 100 | 4.10749185667752 | 33 | 0 | 11 | 0 | 222 | 254 | 13221773 | 13221741 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 1261 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 11063999 | 11063999 | PRJNA884104_S_NODE_25629_length_401_cov_0.935976_g24886_i0 | PRJNA884104 | 25629 | 401 | 0.935976 | 3.75326376 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g24886 | i0 | 100 | 0.0748129675810474 | 30 | 0 | 7 | 0 | 348 | 377 | 11442269 | 11442240 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12339369 | 12339369 | PRJNA884104_S_NODE_17730_length_478_cov_2.281481_g16990_i0 | PRJNA884104 | 17730 | 478 | 2.281481 | 10.90547918 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.047 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g16990 | i0 | 100 | 0.0585774058577406 | 28 | 0 | 6 | 0 | 290 | 317 | 6771104 | 6771077 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12340523 | 12340523 | PRJNA884104_S_NODE_73870_length_248_cov_0.880000_g73127_i0 | PRJNA884104 | 73870 | 248 | 0.88 | 2.1824 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.82e-4 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g73127 | i0 | 94.595 | 14.8508064516129 | 37 | 2 | 19 | 0 | 117 | 153 | 13874814 | 13874778 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 3683 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12340779 | 12340779 | PRJNA884104_S_NODE_86950_length_239_cov_9.000000_g86207_i0 | PRJNA884104 | 86950 | 239 | 9 | 21.51 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.28e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g86207 | i0 | 100 | 3.28870292887029 | 32 | 0 | 14 | 0 | 112 | 143 | 1760016 | 1760047 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 786 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13614232 | 13614232 | PRJNA884104_S_NODE_3531_length_1070_cov_215.496489_g597_i6 | PRJNA884104 | 3531 | 1070 | 215.496489 | 2305.8124323 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.008 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g597 | i6 | 94.595 | 0.0682242990654206 | 37 | 0 | 3 | 2 | 445 | 479 | 13278364 | 13278400 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 73 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14888292 | 14888292 | PRJNA884104_S_NODE_18312_length_471_cov_1.160804_g17571_i0 | PRJNA884104 | 18312 | 471 | 1.160804 | 5.46738684 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.013 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g17571 | i0 | 100 | 0.121019108280255 | 29 | 0 | 6 | 0 | 55 | 83 | 14148472 | 14148444 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14889184 | 14889184 | PRJNA884104_S_NODE_63272_length_262_cov_1.269841_g62529_i0 | PRJNA884104 | 63272 | 262 | 1.269841 | 3.32698342 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g62529 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 163 | 190 | 307624 | 307651 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16163491 | 16163491 | PRJNA884104_S_NODE_4133_length_992_cov_3.162133_g3640_i0 | PRJNA884104 | 4133 | 992 | 3.162133 | 31.36835936 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 6.01e-4 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g3640 | i0 | 94.737 | 2.80947580645161 | 38 | 2 | 4 | 0 | 770 | 807 | 666494 | 666531 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 2787 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17439776 | 17439776 | PRJNA884104_S_NODE_84494_length_242_cov_0.911243_g83751_i0 | PRJNA884104 | 84494 | 242 | 0.911243 | 2.20520806 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 63.9 | 1.01e-5 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g83751 | i0 | 100 | 0.524793388429752 | 34 | 0 | 15 | 0 | 135 | 168 | 19311506 | 19311473 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 127 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18712157 | 18712157 | PRJNA884104_S_NODE_41695_length_321_cov_1.310484_g40952_i0 | PRJNA884104 | 41695 | 321 | 1.310484 | 4.20665364 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.03 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g40952 | i0 | 100 | 0.0872274143302181 | 28 | 0 | 9 | 0 | 215 | 242 | 5534842 | 5534869 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21262347 | 21262347 | PRJNA884104_S_NODE_22977_length_422_cov_1.424069_g22234_i0 | PRJNA884104 | 22977 | 422 | 1.424069 | 6.00957118 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.041 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g22234 | i0 | 100 | 0.0663507109004739 | 28 | 0 | 7 | 0 | 23 | 50 | 9898789 | 9898762 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21263349 | 21263349 | PRJNA884104_S_NODE_72157_length_249_cov_0.875000_g71414_i0 | PRJNA884104 | 72157 | 249 | 0.875 | 2.17875 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g71414 | i0 | 100 | 0.116465863453815 | 29 | 0 | 12 | 0 | 43 | 71 | 22046119 | 22046091 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23812849 | 23812849 | PRJNA884104_S_NODE_32219_length_361_cov_1.031250_g31476_i0 | PRJNA884104 | 32219 | 361 | 1.03125 | 3.7228125 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.034 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g31476 | i0 | 100 | 0.0775623268698061 | 28 | 0 | 8 | 0 | 174 | 201 | 1669292 | 1669265 | Hirudo verbana genome assembly, chromosome: 4 | 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);;