contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA485080" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 449229 | 449229 | PRJNA485080_P_NODE_29761_length_247_cov_1.327586_g29667_i0 | PRJNA485080 | 29761 | 247 | 1.327586 | 3.27913742 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g29667 | i0 | 96.875 | 0.129554655870445 | 32 | 1 | 13 | 0 | 53 | 84 | 15410668 | 15410699 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2999665 | 2999665 | PRJNA485080_P_NODE_10243_length_333_cov_1.096154_g10149_i0 | PRJNA485080 | 10243 | 333 | 1.096154 | 3.65019282 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.88e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g10149 | i0 | 97.143 | 1.05105105105105 | 35 | 1 | 11 | 0 | 200 | 234 | 4152191 | 4152225 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 350 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10652809 | 10652809 | PRJNA485080_P_NODE_24569_length_250_cov_0.870056_g24475_i0 | PRJNA485080 | 24569 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.35e-4 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g24475 | i0 | 100 | 0.924 | 32 | 0 | 13 | 0 | 43 | 74 | 4628277 | 4628246 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 231 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14477724 | 14477724 | PRJNA485080_P_NODE_27352_length_249_cov_0.875000_g27258_i0 | PRJNA485080 | 27352 | 249 | 0.875 | 2.17875 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g27258 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 119 | 146 | 1024734 | 1024707 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14477813 | 14477813 | PRJNA485080_P_NODE_33272_length_246_cov_0.890173_g33178_i0 | PRJNA485080 | 33272 | 246 | 0.890173 | 2.18982558 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g33178 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 4 | 32 | 1728423 | 1728451 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15751929 | 15751929 | PRJNA485080_P_NODE_35273_length_245_cov_0.895349_g35179_i0 | PRJNA485080 | 35273 | 245 | 0.895349 | 2.19360505 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g35179 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 192 | 220 | 13103942 | 13103914 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15751934 | 15751934 | PRJNA485080_P_NODE_35613_length_245_cov_0.895349_g35519_i0 | PRJNA485080 | 35613 | 245 | 0.895349 | 2.19360505 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 76.8 | 1.31e-9 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g35519 | i0 | 87.692 | 3.13469387755102 | 65 | 8 | 27 | 0 | 123 | 187 | 4020100 | 4020164 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 768 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20851047 | 20851047 | PRJNA485080_P_NODE_7217_length_373_cov_1.026667_g7123_i0 | PRJNA485080 | 7217 | 373 | 1.026667 | 3.82946791 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|675891115|ref|XM_009032812.1| | 6412 | g7123 | i0 | 94.286 | 0.0938337801608579 | 35 | 2 | 9 | 0 | 231 | 265 | 1175 | 1209 | Helobdella robusta hypothetical protein partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22125516 | 22125516 | PRJNA485080_P_NODE_21958_length_251_cov_0.865169_g21864_i0 | PRJNA485080 | 21958 | 251 | 0.865169 | 2.17157419 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 67.6 | 8.12e-7 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g21864 | i0 | 93.333 | 4.11155378486056 | 45 | 3 | 18 | 0 | 181 | 225 | 20229082 | 20229126 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 1032 | 67.6 | 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);;