contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1764694 | 1764694 | PRJNA520845_P_NODE_185442_length_273_cov_1.800000_g183943_i0 | PRJNA520845 | 185442 | 273 | 1.8 | 4.914 | Henlea glandulifera | 2562768 | Annelida | Annelida | 130 | 1.13e-25 | NTclustered | gi|2750816250|gb|PP944271.1| | 2562768 | g183943 | i0 | 83.333 | 51.7399267399267 | 144 | 20 | 52 | 3 | 17 | 158 | 205 | 64 | Henlea glandulifera isolate CE9452 histone 3 (H3) gene, partial cds | blastn | 14125 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Henlea | Henlea glandulifera | |
| 1765751 | 1765751 | PRJNA520845_P_NODE_226242_length_249_cov_0.875000_g224743_i0 | PRJNA520845 | 226242 | 249 | 0.875 | 2.17875 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g224743 | i0 | 100 | 0.120481927710843 | 30 | 0 | 12 | 0 | 218 | 247 | 12405256 | 12405227 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3040387 | 3040387 | PRJNA520845_P_NODE_182343_length_276_cov_1.137931_g180844_i0 | PRJNA520845 | 182343 | 276 | 1.137931 | 3.14068956 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g180844 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 72 | 99 | 1192199 | 1192226 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3044026 | 3044026 | PRJNA520845_P_NODE_82443_length_409_cov_1.160714_g80944_i0 | PRJNA520845 | 82443 | 409 | 1.160714 | 4.74732026 | Helobdella robusta | 6412 | Annelida | Annelida | 62.1 | 6.53e-5 | NTclustered | gi|675876479|ref|XM_009025552.1| | 6412 | g80944 | i0 | 100 | 0.364303178484108 | 33 | 0 | 8 | 0 | 1 | 33 | 335 | 367 | Helobdella robusta hypothetical protein mRNA | blastn | 149 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 4317336 | 4317336 | PRJNA520845_P_NODE_221424_length_250_cov_0.870056_g219925_i0 | PRJNA520845 | 221424 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 2.91e-6 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g219925 | i0 | 90.385 | 20.284 | 52 | 1 | 21 | 3 | 137 | 187 | 12469245 | 12469293 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 5071 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9419403 | 9419403 | PRJNA520845_P_NODE_249748_length_244_cov_0.900585_g248249_i0 | PRJNA520845 | 249748 | 244 | 0.900585 | 2.1974274 | Platynereis dumerilii | 6359 | Annelida | Annelida | 111 | 3.58e-20 | NTclustered | gi|83307135|emb|CT033109.1| | 6359 | g248249 | i0 | 88.889 | 2.08196721311475 | 90 | 10 | 37 | 0 | 3 | 92 | 639 | 550 | Platynereis dumerilii EST IB0AAA26CC06EM1 | blastn | 508 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 9419676 | 9419676 | PRJNA520845_P_NODE_260108_length_242_cov_0.911243_g258609_i0 | PRJNA520845 | 260108 | 242 | 0.911243 | 2.20520806 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g258609 | i0 | 96.774 | 0.243801652892562 | 31 | 1 | 13 | 0 | 61 | 91 | 9497129 | 9497099 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 59 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12590907 | 12590907 | PRJNA520845_P_NODE_58390_length_488_cov_1.855422_g56895_i0 | PRJNA520845 | 58390 | 488 | 1.855422 | 9.05445936 | Metazoa | 33208 | Annelida | Annelida | 322 | 3.29e-83 | NTclustered | gi|675872871|ref|XM_009023748.1| | 6412 | g56895 | i0 | 80.328 | 36.7909836065574 | 427 | 82 | 87 | 2 | 63 | 488 | 427 | 2 | Helobdella robusta hypothetical protein partial mRNA | blastn | 17954 | 324 | 0.993827160493827 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 15792677 | 15792677 | PRJNA520845_P_NODE_205593_length_257_cov_1.255435_g204094_i0 | PRJNA520845 | 205593 | 257 | 1.255435 | 3.22646795 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 169 | 2.2199999999999996e-37 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g204094 | i0 | 78.968 | 0.980544747081712 | 252 | 49 | 97 | 4 | 6 | 255 | 19234220 | 19233971 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 252 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18341000 | 18341000 | PRJNA520845_P_NODE_180795_length_277_cov_1.333333_g179296_i0 | PRJNA520845 | 180795 | 277 | 1.333333 | 3.69333241 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g179296 | i0 | 100 | 0.101083032490975 | 28 | 0 | 10 | 0 | 76 | 103 | 18334849 | 18334822 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20893580 | 20893580 | PRJNA520845_P_NODE_262557_length_242_cov_0.911243_g261058_i0 | PRJNA520845 | 262557 | 242 | 0.911243 | 2.20520806 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g261058 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 208 | 235 | 26571344 | 26571371 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22165766 | 22165766 | PRJNA520845_P_NODE_167458_length_288_cov_0.995349_g165959_i0 | PRJNA520845 | 167458 | 288 | 0.995349 | 2.86660512 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.027 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g165959 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 190 | 217 | 2479258 | 2479285 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23440365 | 23440365 | PRJNA520845_P_NODE_129999_length_327_cov_2.728346_g128500_i0 | PRJNA520845 | 129999 | 327 | 2.728346 | 8.92169142 | Helobdella robusta | 6412 | Annelida | Annelida | 62.1 | 5.11e-5 | NTclustered | gi|675890727|ref|XM_009032618.1| | 6412 | g128500 | i0 | 97.222 | 5.11009174311927 | 36 | 1 | 11 | 0 | 118 | 153 | 4132 | 4167 | Helobdella robusta hypothetical protein partial mRNA | blastn | 1671 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 23445441 | 23445441 | PRJNA520845_P_NODE_82719_length_408_cov_1.608955_g81220_i0 | PRJNA520845 | 82719 | 408 | 1.608955 | 6.5645364 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 2.34e-4 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g81220 | i0 | 97.143 | 2.2156862745098 | 35 | 1 | 9 | 0 | 83 | 117 | 9479358 | 9479392 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 904 | 60.2 | 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);;