contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3283310 | 3283310 | PRJNA756891_P_NODE_12603_length_250_cov_0.870056_g12534_i0 | PRJNA756891 | 12603 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g12534 | i0 | 100 | 0.924 | 30 | 0 | 12 | 0 | 35 | 64 | 718806 | 718777 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 231 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3283355 | 3283355 | PRJNA756891_P_NODE_4343_length_404_cov_0.930514_g4274_i0 | PRJNA756891 | 4343 | 404 | 0.930514 | 3.75927656 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.79e-5 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g4274 | i0 | 97.297 | 0.49009900990099 | 37 | 1 | 9 | 0 | 132 | 168 | 4274093 | 4274129 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 198 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5835524 | 5835524 | PRJNA756891_P_NODE_12045_length_251_cov_1.252809_g11976_i0 | PRJNA756891 | 12045 | 251 | 1.252809 | 3.14455059 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g11976 | i0 | 100 | 0.685258964143426 | 30 | 0 | 12 | 0 | 36 | 65 | 7982649 | 7982620 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 172 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7110691 | 7110691 | PRJNA756891_P_NODE_14686_length_245_cov_0.895349_g14617_i0 | PRJNA756891 | 14686 | 245 | 0.895349 | 2.19360505 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.67e-5 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g14617 | i0 | 83.824 | 22.934693877551 | 68 | 8 | 27 | 3 | 96 | 160 | 1109561 | 1109628 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 5619 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8385263 | 8385263 | PRJNA756891_P_NODE_11387_length_259_cov_1.607527_g11318_i0 | PRJNA756891 | 11387 | 259 | 1.607527 | 4.16349493 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 3.03e-6 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g11318 | i0 | 97.368 | 1.81853281853282 | 38 | 1 | 15 | 0 | 73 | 110 | 10928883 | 10928920 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 471 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14760971 | 14760971 | PRJNA756891_P_NODE_5892_length_351_cov_1.107914_g5823_i0 | PRJNA756891 | 5892 | 351 | 1.107914 | 3.88877814 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g5823 | i0 | 100 | 0.0826210826210826 | 29 | 0 | 8 | 0 | 166 | 194 | 25181726 | 25181754 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16034658 | 16034658 | PRJNA756891_P_NODE_3193_length_467_cov_1.659898_g3125_i0 | PRJNA756891 | 3193 | 467 | 1.659898 | 7.75172366 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 7.54e-5 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g3125 | i0 | 94.872 | 9.73447537473233 | 39 | 2 | 10 | 0 | 359 | 397 | 16472511 | 16472549 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 4546 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16034683 | 16034683 | PRJNA756891_P_NODE_7453_length_317_cov_0.926230_g7384_i0 | PRJNA756891 | 7453 | 317 | 0.92623 | 2.9361491 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 6.38e-4 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g7384 | i0 | 100 | 0.0977917981072555 | 31 | 0 | 10 | 0 | 204 | 234 | 1197116 | 1197086 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17310089 | 17310089 | PRJNA756891_P_NODE_11714_length_255_cov_1.510989_g11645_i0 | PRJNA756891 | 11714 | 255 | 1.510989 | 3.85302195 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.38e-4 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g11645 | i0 | 100 | 2.32941176470588 | 32 | 0 | 13 | 0 | 110 | 141 | 1686836 | 1686867 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 594 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17310090 | 17310090 | PRJNA756891_P_NODE_11754_length_254_cov_4.254144_g11685_i0 | PRJNA756891 | 11754 | 254 | 4.254144 | 10.80552576 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g11685 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 220 | 247 | 4151448 | 4151421 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22409409 | 22409409 | PRJNA756891_P_NODE_3818_length_429_cov_1.297753_g3749_i0 | PRJNA756891 | 3818 | 429 | 1.297753 | 5.56736037 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.041 | NTclustered | gi|675862483|ref|XM_009018554.1| | 6412 | g3749 | i0 | 100 | 0.0652680652680653 | 28 | 0 | 7 | 0 | 16 | 43 | 515 | 542 | Helobdella robusta hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22409419 | 22409419 | PRJNA756891_P_NODE_618_length_989_cov_11.560044_g573_i0 | PRJNA756891 | 618 | 989 | 11.560044 | 114.32883516 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.002 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g573 | i0 | 100 | 0.0313447927199191 | 31 | 0 | 3 | 0 | 284 | 314 | 15323560 | 15323530 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22409427 | 22409427 | PRJNA756891_P_NODE_7598_length_314_cov_0.958506_g7529_i0 | PRJNA756891 | 7598 | 314 | 0.958506 | 3.00970884 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.36e-5 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g7529 | i0 | 97.297 | 11.1050955414013 | 37 | 1 | 12 | 0 | 270 | 306 | 255894 | 255858 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 3487 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23685015 | 23685015 | PRJNA756891_P_NODE_16619_length_241_cov_0.916667_g16550_i0 | PRJNA756891 | 16619 | 241 | 0.916667 | 2.20916747 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g16550 | i0 | 100 | 0.120331950207469 | 29 | 0 | 12 | 0 | 174 | 202 | 4244429 | 4244401 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23685046 | 23685046 | PRJNA756891_P_NODE_6079_length_346_cov_1.186813_g6010_i0 | PRJNA756891 | 6079 | 346 | 1.186813 | 4.10637298 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.033 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g6010 | i0 | 100 | 0.0809248554913295 | 28 | 0 | 8 | 0 | 314 | 341 | 5420421 | 5420448 | Hirudo verbana genome assembly, chromosome: 3 | 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);;