contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA889065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3414220 | 3414220 | PRJNA889065_S_NODE_7223_length_352_cov_8.103560_g6985_i0 | PRJNA889065 | 7223 | 352 | 8.10356 | 28.5245312 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g6985 | i0 | 100 | 0.164772727272727 | 30 | 0 | 9 | 0 | 1 | 30 | 1434624 | 1434653 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 58 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4691765 | 4691765 | PRJNA889065_S_NODE_2564_length_541_cov_8.654618_g2346_i0 | PRJNA889065 | 2564 | 541 | 8.654618 | 46.82148338 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.015 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g2346 | i0 | 96.97 | 0.0609981515711645 | 33 | 0 | 6 | 1 | 1 | 32 | 2555359 | 2555391 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7241457 | 7241457 | PRJNA889065_S_NODE_21406_length_210_cov_3.161677_g21168_i0 | PRJNA889065 | 21406 | 210 | 3.161677 | 6.6395217 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|675884701|ref|XM_009029605.1| | 6412 | g21168 | i0 | 100 | 0.138095238095238 | 29 | 0 | 14 | 0 | 13 | 41 | 293 | 321 | Helobdella robusta hypothetical protein mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 7241521 | 7241521 | PRJNA889065_S_NODE_36646_length_157_cov_2.017544_g36408_i0 | PRJNA889065 | 36646 | 157 | 2.017544 | 3.16754408 | Phascolosoma pacificum | 1634976 | Annelida | Annelida | 58.4 | 2.78e-4 | NTclustered | gi|1079487787|ref|NC_031412.1| | 1634976 | g36408 | i0 | 94.595 | 2.56687898089172 | 37 | 2 | 24 | 0 | 2 | 38 | 2788 | 2824 | Phascolosoma pacificum mitochondrion, complete genome | blastn | 403 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Phascolosomatiformes | Phascolosomatidae | Phascolosoma | Phascolosoma pacificum | |
| 8516287 | 8516287 | PRJNA889065_S_NODE_36067_length_159_cov_1.189655_g35829_i0 | PRJNA889065 | 36067 | 159 | 1.189655 | 1.89155145 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.013 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g35829 | i0 | 100 | 0.176100628930818 | 28 | 0 | 18 | 0 | 40 | 67 | 25943560 | 25943533 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9791326 | 9791326 | PRJNA889065_S_NODE_34088_length_164_cov_1.140496_g33850_i0 | PRJNA889065 | 34088 | 164 | 1.140496 | 1.87041344 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g33850 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 83 | 110 | 40763973 | 40763946 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19990070 | 19990070 | PRJNA889065_S_NODE_8636_length_324_cov_1.494662_g8398_i0 | PRJNA889065 | 8636 | 324 | 1.494662 | 4.84270488 | Hirudo verbana | 311461 | Annelida | Annelida | 435 | 2.59e-117 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g8398 | i0 | 91.022 | 2.7962962962963 | 323 | 28 | 99 | 1 | 1 | 323 | 4592068 | 4591747 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 906 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21265304 | 21265304 | PRJNA889065_S_NODE_19597_length_220_cov_1.519774_g19359_i0 | PRJNA889065 | 19597 | 220 | 1.519774 | 3.3435028 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g19359 | i0 | 92.308 | 0.177272727272727 | 39 | 2 | 18 | 1 | 84 | 122 | 16293131 | 16293168 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 39 | 54.7 | 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);;