contig_metadata
7 rows where bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3461550 | 3461550 | PRJNA934332_P_NODE_9443_length_246_cov_0.890173_g9356_i0 | PRJNA934332 | 9443 | 246 | 0.890173 | 2.18982558 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.78e-4 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g9356 | i0 | 97.059 | 0.138211382113821 | 34 | 1 | 14 | 0 | 129 | 162 | 5443790 | 5443823 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 11114291 | 11114291 | PRJNA934332_P_NODE_829_length_656_cov_1.303602_g749_i0 | PRJNA934332 | 829 | 656 | 1.303602 | 8.55162912 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.018 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g749 | i0 | 100 | 0.0442073170731707 | 29 | 0 | 4 | 0 | 353 | 381 | 18635826 | 18635798 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20037242 | 20037242 | PRJNA934332_P_NODE_2976_length_367_cov_3.738095_g2889_i0 | PRJNA934332 | 2976 | 367 | 3.738095 | 13.71880865 | Capitella teleta | 283909 | Annelida | Annelida | 139 | 1.66e-39 | NR | ELT92933.1 | 283909 | g2889 | i0 | 65.7 | 5.26430517711172 | 99 | 32 | 80.9 | 1 | 299 | 3 | 2 | 98 | ELT92933.1 hypothetical protein CAPTEDRAFT_183334 [Capitella teleta] | diamond | 1932 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27189907 | 27189907 | PRJNA934332_P_NODE_6962_length_260_cov_1.540107_g6875_i0 | PRJNA934332 | 6962 | 260 | 1.540107 | 4.0042782 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 1.28e-7 | NR | CAH1775583.1 | 6347 | g6875 | i0 | 41.6 | 7.24615384615385 | 77 | 41 | 84.2 | 2 | 21 | 239 | 572 | 648 | CAH1775583.1 unnamed protein product [Owenia fusiformis] | diamond | 1884 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29589531 | 29589531 | PRJNA934332_P_NODE_6050_length_276_cov_1.517241_g5963_i0 | PRJNA934332 | 6050 | 276 | 1.517241 | 4.18758516 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.1 | 6.77e-10 | NR | ELT97855.1 | 283909 | g5963 | i0 | 72.5 | 1.77173913043478 | 40 | 11 | 43.5 | 0 | 2 | 121 | 338 | 377 | ELT97855.1 hypothetical protein CAPTEDRAFT_204377 [Capitella teleta] | diamond | 489 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30783261 | 30783261 | PRJNA934332_P_NODE_11254_length_241_cov_0.916667_g11167_i0 | PRJNA934332 | 11254 | 241 | 0.916667 | 2.20916747 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 58.5 | 9.64e-8 | NR | CAD5118840.1 | 2664684 | g11167 | i0 | 61.5 | 2.850622406639 | 39 | 15 | 48.5 | 0 | 9 | 125 | 190 | 228 | CAD5118840.1 DgyrCDS7518 [Dimorphilus gyrociliatus] | diamond | 687 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 32150103 | 32150103 | PRJNA934332_P_NODE_4258_length_318_cov_2.110204_g4171_i0 | PRJNA934332 | 4258 | 318 | 2.110204 | 6.71044872 | Metazoa | 33208 | Annelida | Annelida | 55.8 | 1.13e-6 | NR | ABW90371.1 | 6446 | g4171 | i0 | 41.7 | 3.38679245283019 | 72 | 39 | 65.1 | 1 | 315 | 109 | 132 | 203 | ABW90371.1 putative ribosomal protein P0, partial [Sipunculus nudus] | diamond | 1077 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus |
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);;