contig_metadata
10 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1700680 | 1700680 | PRJNA429937_P_NODE_126622_length_232_cov_7.216749_g103995_i0 | PRJNA429937 | 126622 | 232 | 7.216749 | 16.74285768 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.021 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g103995 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 109 | 136 | 12695437 | 12695410 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5531033 | 5531033 | PRJNA429937_P_NODE_74365_length_386_cov_2.492997_g52350_i0 | PRJNA429937 | 74365 | 386 | 2.492997 | 9.62296842 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 128 | 5.95e-25 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g52350 | i0 | 95.062 | 0.209844559585492 | 81 | 4 | 21 | 0 | 1 | 81 | 9797580 | 9797500 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 81 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6803927 | 6803927 | PRJNA429937_P_NODE_19806_length_826_cov_5.165621_g11701_i0 | PRJNA429937 | 19806 | 826 | 5.165621 | 42.66802946 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 4.96e-4 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g11701 | i0 | 94.872 | 0.0907990314769976 | 39 | 1 | 5 | 1 | 321 | 359 | 1095828 | 1095865 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 75 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9355658 | 9355658 | PRJNA429937_P_NODE_83948_length_353_cov_3.327160_g61448_i0 | PRJNA429937 | 83948 | 353 | 3.32716 | 11.7448748 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 7.17e-4 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g61448 | i0 | 100 | 0.424929178470255 | 31 | 0 | 9 | 0 | 290 | 320 | 7167925 | 7167955 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 150 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 11906004 | 11906004 | PRJNA429937_P_NODE_68890_length_407_cov_4.031746_g47531_i0 | PRJNA429937 | 68890 | 407 | 4.031746 | 16.40920622 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 8.4e-4 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g47531 | i0 | 100 | 0.0761670761670762 | 31 | 0 | 8 | 0 | 129 | 159 | 1328324 | 1328294 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14454762 | 14454762 | PRJNA429937_P_NODE_131612_length_221_cov_4.026042_g108985_i0 | PRJNA429937 | 131612 | 221 | 4.026042 | 8.89755282 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g108985 | i0 | 100 | 0.126696832579186 | 28 | 0 | 13 | 0 | 37 | 64 | 14544192 | 14544165 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18277267 | 18277267 | PRJNA429937_P_NODE_110915_length_272_cov_2.259259_g88293_i0 | PRJNA429937 | 110915 | 272 | 2.259259 | 6.14518448 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 224 | 4.9999999999999996e-54 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g88293 | i0 | 83.682 | 146.463235294118 | 239 | 37 | 93 | 2 | 9 | 246 | 9321505 | 9321268 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 39838 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19551659 | 19551659 | PRJNA429937_P_NODE_122896_length_241_cov_2.589623_g100270_i0 | PRJNA429937 | 122896 | 241 | 2.589623 | 6.24099143 | Capitella capitata | 51294 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|67514114|gb|AC158490.2| | 51294 | g100270 | i0 | 100 | 0.120331950207469 | 29 | 0 | 12 | 0 | 126 | 154 | 17603 | 17575 | Capitella capitata clone JGIAUTO-1A3, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella capitata | ||
| 20827960 | 20827960 | PRJNA429937_P_NODE_23417_length_759_cov_5.156164_g13957_i0 | PRJNA429937 | 23417 | 759 | 5.156164 | 39.13528476 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 388 | 5.11e-103 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g13957 | i0 | 95.851 | 14.1198945981555 | 241 | 9 | 41 | 1 | 504 | 743 | 11499145 | 11498905 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 10717 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22102853 | 22102853 | PRJNA429937_P_NODE_23418_length_759_cov_5.082192_g13957_i1 | PRJNA429937 | 23418 | 759 | 5.082192 | 38.57383728 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 388 | 5.11e-103 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g13957 | i1 | 95.851 | 14.1198945981555 | 241 | 9 | 41 | 1 | 17 | 256 | 11498905 | 11499145 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 10717 | 388 | 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);;