contig_metadata
9 rows where bioproject = "PRJNA835051", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9753610 | 9753610 | PRJNA835051_S_NODE_126788_length_153_cov_0.872727_g126492_i0 | PRJNA835051 | 126788 | 153 | 0.872727 | 1.33527231 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 2.08e-5 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g126492 | i0 | 100 | 0.215686274509804 | 33 | 0 | 22 | 0 | 120 | 152 | 20944703 | 20944735 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12304629 | 12304629 | PRJNA835051_S_NODE_115510_length_159_cov_1.646552_g115214_i0 | PRJNA835051 | 115510 | 159 | 1.646552 | 2.61801768 | Dasybranchus sp. DH1 | 547546 | Annelida | Annelida | 294 | 1.98e-75 | NTclustered | gi|194579818|gb|EU835658.1| | 547546 | g115214 | i0 | 100 | 99.3899371069182 | 159 | 0 | 100 | 0 | 1 | 159 | 197 | 355 | Dasybranchus sp. DH1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 15803 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Dasybranchus | Dasybranchus sp. DH1 | ||
| 16128516 | 16128516 | PRJNA835051_S_NODE_32493_length_245_cov_1.539604_g32197_i0 | PRJNA835051 | 32493 | 245 | 1.539604 | 3.7720298 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g32197 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 21 | 49 | 9540838 | 9540810 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16129401 | 16129401 | PRJNA835051_S_NODE_98753_length_170_cov_1.834646_g98457_i0 | PRJNA835051 | 98753 | 170 | 1.834646 | 3.1188982 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g98457 | i0 | 96.875 | 1.88235294117647 | 32 | 1 | 19 | 0 | 104 | 135 | 4305206 | 4305237 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 320 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20355951 | 20355951 | PRJNA835051_S_NODE_63056_length_201_cov_1.506329_g62760_i0 | PRJNA835051 | 63056 | 201 | 1.506329 | 3.02772129 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g62760 | i0 | 100 | 0.577114427860697 | 29 | 0 | 14 | 0 | 125 | 153 | 3154447 | 3154419 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 116 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22502307 | 22502307 | PRJNA835051_S_NODE_1198_length_634_cov_9.326565_g954_i0 | PRJNA835051 | 1198 | 634 | 9.326565 | 59.1304221 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 3.76e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g954 | i0 | 100 | 1.05362776025237 | 32 | 0 | 5 | 0 | 460 | 491 | 1760047 | 1760016 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 668 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22502416 | 22502416 | PRJNA835051_S_NODE_132318_length_150_cov_2.233645_g132022_i0 | PRJNA835051 | 132318 | 150 | 2.233645 | 3.3504675 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g132022 | i0 | 100 | 1.01333333333333 | 30 | 0 | 20 | 0 | 6 | 35 | 23008332 | 23008361 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 152 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22502487 | 22502487 | PRJNA835051_S_NODE_17098_length_287_cov_2.143443_g16802_i0 | PRJNA835051 | 17098 | 287 | 2.143443 | 6.15168141 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g16802 | i0 | 100 | 0.411149825783972 | 30 | 0 | 10 | 0 | 80 | 109 | 1800134 | 1800163 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 118 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 25051801 | 25051801 | PRJNA835051_S_NODE_125420_length_153_cov_2.400000_g125124_i0 | PRJNA835051 | 125420 | 153 | 2.4 | 3.672 | Dasybranchus sp. DH1 | 547546 | Annelida | Annelida | 283 | 4.0799999999999995e-72 | NTclustered | gi|194579818|gb|EU835658.1| | 547546 | g125124 | i0 | 100 | 98.1830065359477 | 153 | 0 | 100 | 0 | 1 | 153 | 490 | 338 | Dasybranchus sp. DH1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 15022 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Dasybranchus | Dasybranchus sp. DH1 |
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);;