contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 277762 | 277762 | PRJNA1122875_P_NODE_38961_length_266_cov_1.259067_g38737_i0 | PRJNA1122875 | 38961 | 266 | 1.259067 | 3.34911822 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g38737 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 15 | 42 | 188246 | 188219 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1552428 | 1552428 | PRJNA1122875_P_NODE_48862_length_246_cov_0.890173_g48638_i0 | PRJNA1122875 | 48862 | 246 | 0.890173 | 2.18982558 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g48638 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 165 | 192 | 702112 | 702139 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2828501 | 2828501 | PRJNA1122875_P_NODE_46283_length_248_cov_0.880000_g46059_i0 | PRJNA1122875 | 46283 | 248 | 0.88 | 2.1824 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g46059 | i0 | 94.444 | 0.387096774193548 | 36 | 0 | 14 | 1 | 74 | 107 | 862310 | 862275 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4104709 | 4104709 | PRJNA1122875_P_NODE_31684_length_290_cov_1.419355_g31460_i0 | PRJNA1122875 | 31684 | 290 | 1.419355 | 4.1161295 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 4.46e-5 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g31460 | i0 | 93.023 | 0.148275862068966 | 43 | 2 | 15 | 1 | 33 | 75 | 8006241 | 8006282 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 43 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6655409 | 6655409 | PRJNA1122875_P_NODE_25406_length_329_cov_1.203125_g25182_i0 | PRJNA1122875 | 25406 | 329 | 1.203125 | 3.95828125 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 78.7 | 5.11e-10 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g25182 | i0 | 92.593 | 8.16717325227964 | 54 | 4 | 16 | 0 | 120 | 173 | 21103033 | 21103086 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 2687 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9205919 | 9205919 | PRJNA1122875_P_NODE_628_length_1372_cov_4.481139_g556_i0 | PRJNA1122875 | 628 | 1372 | 4.481139 | 61.48122708 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 2.34e-4 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g556 | i0 | 100 | 0.432215743440233 | 33 | 0 | 2 | 0 | 590 | 622 | 9176841 | 9176809 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 593 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16855032 | 16855032 | PRJNA1122875_P_NODE_44334_length_250_cov_0.870056_g44110_i0 | PRJNA1122875 | 44334 | 250 | 0.870056 | 2.17514 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g44110 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 168 | 195 | 41343895 | 41343868 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20679041 | 20679041 | PRJNA1122875_P_NODE_28117_length_310_cov_1.518987_g27893_i0 | PRJNA1122875 | 28117 | 310 | 1.518987 | 4.7088597 | Hirudo verbana | 311461 | Annelida | Annelida | 71.3 | 7.99e-8 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g27893 | i0 | 95.455 | 2.3 | 44 | 2 | 14 | 0 | 22 | 65 | 891544 | 891587 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 713 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
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);;