contig_metadata
17 rows where bioproject = "PRJDB12578" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3888 | 3888 | PRJDB12578_S_NODE_195301_length_168_cov_1.310924_g172243_i0 | PRJDB12578 | 195301 | 168 | 1.310924 | 2.20235232 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 3.03e-4 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g172243 | i0 | 100 | 0.56547619047619 | 31 | 0 | 18 | 0 | 92 | 122 | 21087202 | 21087172 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 95 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 1275840 | 1275840 | PRJDB12578_S_NODE_133362_length_222_cov_1.312139_g110304_i0 | PRJDB12578 | 133362 | 222 | 1.312139 | 2.91294858 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g110304 | i0 | 100 | 0.126126126126126 | 28 | 0 | 13 | 0 | 61 | 88 | 1199214 | 1199187 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2256149 | 2256149 | PRJDB12578_S_NODE_57402_length_720_cov_3.663189_g35448_i0 | PRJDB12578 | 57402 | 720 | 3.663189 | 26.3749608 | Metazoa | 33208 | Annelida | Annelida | 158 | 1.48e-33 | NTclustered | gi|11494214|gb|AF212165.1|AF212165 | 122240 | g35448 | i0 | 91.304 | 17.1638888888889 | 115 | 10 | 16 | 0 | 406 | 520 | 3449 | 3563 | Proceraea cornuta internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 12358 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Syllidae | Proceraea | Proceraea cornuta | |
| 2556226 | 2556226 | PRJDB12578_S_NODE_53183_length_819_cov_2.445455_g31971_i0 | PRJDB12578 | 53183 | 819 | 2.445455 | 20.02827645 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.006 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g31971 | i0 | 89.583 | 0.407814407814408 | 48 | 0 | 6 | 5 | 488 | 535 | 7788601 | 7788559 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 334 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3832668 | 3832668 | PRJDB12578_S_NODE_55724_length_758_cov_2.796897_g34030_i0 | PRJDB12578 | 55724 | 758 | 2.796897 | 21.20047926 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.021 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g34030 | i0 | 100 | 0.0382585751978892 | 29 | 0 | 4 | 0 | 120 | 148 | 8481444 | 8481416 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5104435 | 5104435 | PRJDB12578_S_NODE_144385_length_209_cov_1.243750_g121327_i0 | PRJDB12578 | 144385 | 209 | 1.24375 | 2.5994375 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g121327 | i0 | 100 | 0.143540669856459 | 30 | 0 | 14 | 0 | 132 | 161 | 8167810 | 8167839 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5109420 | 5109420 | PRJDB12578_S_NODE_65565_length_565_cov_4.034884_g42763_i0 | PRJDB12578 | 65565 | 565 | 4.034884 | 22.7970946 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.015 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g42763 | i0 | 100 | 0.0513274336283186 | 29 | 0 | 5 | 0 | 537 | 565 | 58515 | 58487 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6084120 | 6084120 | PRJDB12578_S_NODE_84165_length_364_cov_1.958730_g61107_i0 | PRJDB12578 | 84165 | 364 | 1.95873 | 7.1297772 | Opisthokonta | 33154 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g61107 | i0 | 94.444 | 2.10714285714286 | 36 | 1 | 10 | 1 | 330 | 364 | 1791826 | 1791791 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 767 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6381992 | 6381992 | PRJDB12578_S_NODE_189166_length_171_cov_2.557377_g166108_i0 | PRJDB12578 | 189166 | 171 | 2.557377 | 4.37311467 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g166108 | i0 | 96.875 | 0.187134502923977 | 32 | 0 | 18 | 1 | 72 | 102 | 5720403 | 5720372 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8931303 | 8931303 | PRJDB12578_S_NODE_207408_length_164_cov_1.295652_g184350_i0 | PRJDB12578 | 207408 | 164 | 1.295652 | 2.12486928 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 2.27e-5 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g184350 | i0 | 97.222 | 4.84146341463415 | 36 | 1 | 22 | 0 | 129 | 164 | 22586104 | 22586069 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 794 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12755590 | 12755590 | PRJDB12578_S_NODE_144271_length_209_cov_1.287500_g121213_i0 | PRJDB12578 | 144271 | 209 | 1.2875 | 2.690875 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g121213 | i0 | 100 | 0.138755980861244 | 29 | 0 | 14 | 0 | 1 | 29 | 1953705 | 1953677 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14028447 | 14028447 | PRJDB12578_S_NODE_103312_length_281_cov_1.935345_g80254_i0 | PRJDB12578 | 103312 | 281 | 1.935345 | 5.43831945 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.026 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g80254 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 150 | 177 | 11364366 | 11364393 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15303101 | 15303101 | PRJDB12578_S_NODE_117693_length_247_cov_5.136364_g94635_i0 | PRJDB12578 | 117693 | 247 | 5.136364 | 12.68681908 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.8e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g94635 | i0 | 94.595 | 0.676113360323887 | 37 | 2 | 15 | 0 | 210 | 246 | 1000818 | 1000854 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 167 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15303591 | 15303591 | PRJDB12578_S_NODE_130053_length_226_cov_3.203390_g106995_i0 | PRJDB12578 | 130053 | 226 | 3.20339 | 7.2396614 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g106995 | i0 | 96.774 | 0.13716814159292 | 31 | 1 | 14 | 0 | 25 | 55 | 19373716 | 19373746 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19129616 | 19129616 | PRJDB12578_S_NODE_199296_length_167_cov_0.872881_g176238_i0 | PRJDB12578 | 199296 | 167 | 0.872881 | 1.45771127 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g176238 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 97 | 124 | 39651979 | 39651952 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21684625 | 21684625 | PRJDB12578_S_NODE_88418_length_340_cov_1.058419_g65360_i0 | PRJDB12578 | 88418 | 340 | 1.058419 | 3.5986246 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g65360 | i0 | 94.444 | 0.352941176470588 | 36 | 0 | 10 | 2 | 108 | 141 | 37465185 | 37465150 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 120 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22952511 | 22952511 | PRJDB12578_S_NODE_107619_length_269_cov_2.336364_g84561_i0 | PRJDB12578 | 107619 | 269 | 2.336364 | 6.28481916 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g84561 | i0 | 100 | 0.427509293680297 | 30 | 0 | 11 | 0 | 1 | 30 | 14376694 | 14376723 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 115 | 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);;