contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 739990 | 739990 | PRJNA758398_S_NODE_6461_length_375_cov_1.371166_g6320_i0 | PRJNA758398 | 6461 | 375 | 1.371166 | 5.1418725 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g6320 | i0 | 94.444 | 0.170666666666667 | 36 | 1 | 9 | 1 | 50 | 84 | 2523728 | 2523693 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7118583 | 7118583 | PRJNA758398_S_NODE_33086_length_186_cov_1.116788_g32945_i0 | PRJNA758398 | 33086 | 186 | 1.116788 | 2.07722568 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g32945 | i0 | 94.444 | 0.193548387096774 | 36 | 2 | 19 | 0 | 65 | 100 | 19829627 | 19829662 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9668557 | 9668557 | PRJNA758398_S_NODE_8748_length_326_cov_1.472924_g8607_i0 | PRJNA758398 | 8748 | 326 | 1.472924 | 4.80173224 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g8607 | i0 | 100 | 0.0889570552147239 | 29 | 0 | 9 | 0 | 12 | 40 | 12949897 | 12949925 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12219414 | 12219414 | PRJNA758398_S_NODE_31690_length_189_cov_2.185714_g31549_i0 | PRJNA758398 | 31690 | 189 | 2.185714 | 4.13099946 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 9.69e-5 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g31549 | i0 | 100 | 4.15873015873016 | 32 | 0 | 18 | 0 | 79 | 110 | 1760047 | 1760016 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 786 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22417401 | 22417401 | PRJNA758398_S_NODE_9378_length_315_cov_3.334586_g9237_i0 | PRJNA758398 | 9378 | 315 | 3.334586 | 10.5039459 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g9237 | i0 | 100 | 0.0920634920634921 | 29 | 0 | 9 | 0 | 242 | 270 | 15395455 | 15395483 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23692469 | 23692469 | PRJNA758398_S_NODE_14759_length_257_cov_2.865385_g14618_i0 | PRJNA758398 | 14759 | 257 | 2.865385 | 7.36403945 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g14618 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 1 | 28 | 12904171 | 12904198 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 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);;