contig_metadata
7 rows where bioproject = "PRJNA635397", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5709587 | 5709587 | PRJNA635397_P_NODE_39865_length_251_cov_1.606742_g39411_i0 | PRJNA635397 | 39865 | 251 | 1.606742 | 4.03292242 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g39411 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 202 | 229 | 10126780 | 10126807 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6983907 | 6983907 | PRJNA635397_P_NODE_13266_length_463_cov_1.794872_g12812_i0 | PRJNA635397 | 13266 | 463 | 1.794872 | 8.31025736 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.045 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g12812 | i0 | 100 | 0.060475161987041 | 28 | 0 | 6 | 0 | 408 | 435 | 18883540 | 18883567 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6984107 | 6984107 | PRJNA635397_P_NODE_23486_length_330_cov_2.303502_g23032_i0 | PRJNA635397 | 23486 | 330 | 2.303502 | 7.6015566 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g23032 | i0 | 96.875 | 0.096969696969697 | 32 | 1 | 10 | 0 | 212 | 243 | 11002249 | 11002218 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9534313 | 9534313 | PRJNA635397_P_NODE_34928_length_268_cov_1.297436_g34474_i0 | PRJNA635397 | 34928 | 268 | 1.297436 | 3.47712848 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.13e-5 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g34474 | i0 | 95.122 | 1.24253731343284 | 41 | 1 | 15 | 1 | 93 | 132 | 11093278 | 11093318 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 333 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10810000 | 10810000 | PRJNA635397_P_NODE_31549_length_283_cov_0.980952_g31095_i0 | PRJNA635397 | 31549 | 283 | 0.980952 | 2.77609416 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g31095 | i0 | 96.875 | 0.113074204946996 | 32 | 1 | 11 | 0 | 236 | 267 | 2847835 | 2847804 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14634524 | 14634524 | PRJNA635397_P_NODE_22452_length_339_cov_0.928571_g21998_i0 | PRJNA635397 | 22452 | 339 | 0.928571 | 3.14785569 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.032 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g21998 | i0 | 100 | 0.0825958702064897 | 28 | 0 | 8 | 0 | 251 | 278 | 38234152 | 38234125 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27838877 | 27838877 | PRJNA635397_P_NODE_30164_length_289_cov_1.972222_g29710_i0 | PRJNA635397 | 30164 | 289 | 1.972222 | 5.69972158 | Helobdella robusta | 6412 | Annelida | Annelida | 49.7 | 4.9e-5 | NR | XP_009023829.1 | 6412 | g29710 | i0 | 83.3 | 0.249134948096886 | 24 | 4 | 24.9 | 0 | 84 | 13 | 90 | 113 | XP_009023829.1 hypothetical protein HELRODRAFT_177382 [Helobdella robusta] | diamond | 72 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;