contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2731487 | 2731487 | PRJNA1067370_P_NODE_60163_length_279_cov_2.601942_g59614_i0 | PRJNA1067370 | 60163 | 279 | 2.601942 | 7.25941818 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g59614 | i0 | 94.595 | 0.132616487455197 | 37 | 1 | 13 | 1 | 137 | 172 | 643883 | 643847 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4006977 | 4006977 | PRJNA1067370_P_NODE_105624_length_243_cov_2.017647_g105075_i0 | PRJNA1067370 | 105624 | 243 | 2.017647 | 4.90288221 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.31e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g105075 | i0 | 94.737 | 0.308641975308642 | 38 | 2 | 16 | 0 | 59 | 96 | 42186152 | 42186115 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 75 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5283818 | 5283818 | PRJNA1067370_P_NODE_66005_length_271_cov_0.919192_g65456_i0 | PRJNA1067370 | 66005 | 271 | 0.919192 | 2.49101032 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g65456 | i0 | 100 | 0.210332103321033 | 29 | 0 | 11 | 0 | 235 | 263 | 5352876 | 5352904 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7833638 | 7833638 | PRJNA1067370_P_NODE_80447_length_251_cov_0.865169_g79898_i0 | PRJNA1067370 | 80447 | 251 | 0.865169 | 2.17157419 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g79898 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 174 | 202 | 31772028 | 31772056 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9108169 | 9108169 | PRJNA1067370_P_NODE_109148_length_242_cov_1.822485_g108599_i0 | PRJNA1067370 | 109148 | 242 | 1.822485 | 4.4104137 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g108599 | i0 | 96.774 | 5.4504132231405 | 31 | 1 | 13 | 0 | 71 | 101 | 38371142 | 38371172 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 1319 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10384228 | 10384228 | PRJNA1067370_P_NODE_54589_length_288_cov_1.320930_g54040_i0 | PRJNA1067370 | 54589 | 288 | 1.32093 | 3.8042784 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.027 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g54040 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 151 | 178 | 4263765 | 4263792 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12934658 | 12934658 | PRJNA1067370_P_NODE_51331_length_293_cov_4.600000_g50782_i0 | PRJNA1067370 | 51331 | 293 | 4.6 | 13.478 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g50782 | i0 | 100 | 0.0989761092150171 | 29 | 0 | 10 | 0 | 227 | 255 | 21772657 | 21772629 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15040844 | 15040844 | PRJNA1067370_P_NODE_108632_length_243_cov_0.905882_g108083_i0 | PRJNA1067370 | 108632 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g108083 | i0 | 100 | 0.345679012345679 | 28 | 0 | 12 | 0 | 113 | 140 | 12506948 | 12506975 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15483440 | 15483440 | PRJNA1067370_P_NODE_17753_length_442_cov_3.406504_g17205_i0 | PRJNA1067370 | 17753 | 442 | 3.406504 | 15.05674768 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.043 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g17205 | i0 | 100 | 0.570135746606335 | 28 | 0 | 6 | 0 | 247 | 274 | 28956758 | 28956785 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 252 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18864756 | 18864756 | PRJNA1067370_P_NODE_195_length_2706_cov_3.641094_g127_i0 | PRJNA1067370 | 195 | 2706 | 3.641094 | 98.52800364 | root | 1 | Root_unresolved | Root_unresolved | 62.1 | 4.67e-4 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g127 | i0 | 92.857 | 0.124907612712491 | 42 | 3 | 3 | 0 | 2645 | 2686 | 5279770 | 5279729 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 338 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19306203 | 19306203 | PRJNA1067370_P_NODE_109456_length_242_cov_1.366864_g108907_i0 | PRJNA1067370 | 109456 | 242 | 1.366864 | 3.30781088 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g108907 | i0 | 94.286 | 0.37603305785124 | 35 | 2 | 14 | 0 | 89 | 123 | 12564379 | 12564345 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 91 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19306512 | 19306512 | PRJNA1067370_P_NODE_4616_length_816_cov_30.353970_g4133_i0 | PRJNA1067370 | 4616 | 816 | 30.35397 | 247.6883952 | Parachilota sp. FB-2019 | 2507458 | Annelida | Annelida | 67.6 | 2.93e-6 | NTclustered | gi|1561760995|gb|MH995747.1| | 2507458 | g4133 | i0 | 97.436 | 0.48406862745098 | 39 | 1 | 5 | 0 | 624 | 662 | 796 | 834 | Parachilota sp. FB-2019 hemoglobin linker chain mRNA, partial cds | blastn | 395 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Acanthodrilidae | Parachilota | Parachilota sp. FB-2019 | |
| 21857673 | 21857673 | PRJNA1067370_P_NODE_37838_length_326_cov_1.146245_g37290_i0 | PRJNA1067370 | 37838 | 326 | 1.146245 | 3.7367587 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.031 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g37290 | i0 | 100 | 0.257668711656442 | 28 | 0 | 9 | 0 | 81 | 108 | 8919156 | 8919129 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23132969 | 23132969 | PRJNA1067370_P_NODE_15979_length_464_cov_1.181586_g15431_i0 | PRJNA1067370 | 15979 | 464 | 1.181586 | 5.48255904 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 93.5 | 2.66e-14 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g15431 | i0 | 83.168 | 3.92025862068966 | 101 | 17 | 25 | 0 | 114 | 214 | 4362189 | 4362289 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 1819 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24406892 | 24406892 | PRJNA1067370_P_NODE_6060_length_719_cov_1.693498_g5556_i0 | PRJNA1067370 | 6060 | 719 | 1.693498 | 12.17625062 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.006 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g5556 | i0 | 100 | 0.0417246175243394 | 30 | 0 | 4 | 0 | 181 | 210 | 21498471 | 21498500 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 30 | 56.5 | 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);;