contig_metadata
8 rows where bioproject = "PRJNA1255065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2910992 | 2910992 | PRJNA1255065_P_NODE_26963_length_500_cov_2.971175_g24768_i0 | PRJNA1255065 | 26963 | 500 | 2.971175 | 14.855875 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.014 | NTclustered | gi|675892471|ref|XM_009033490.1| | 6412 | g24768 | i0 | 100 | 0.058 | 29 | 0 | 6 | 0 | 36 | 64 | 1959 | 1931 | Helobdella robusta hypothetical protein mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 4187346 | 4187346 | PRJNA1255065_P_NODE_154464_length_159_cov_2.054545_g152236_i0 | PRJNA1255065 | 154464 | 159 | 2.054545 | 3.26672655 | Myxobdella sinanensis | 1917527 | Annelida | Annelida | 134 | 4.5700000000000005e-27 | NTclustered | gi|1143530630|dbj|LC192131.1| | 1917527 | g152236 | i0 | 86.614 | 39.1949685534591 | 127 | 10 | 78 | 7 | 20 | 143 | 2153 | 2275 | Myxobdella sinanensis gene for 28S ribosomal RNA, partial sequence, specimen_voucher: KUZ<JPN>:Z1794 | blastn | 6232 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Myxobdella | Myxobdella sinanensis | |
| 6737551 | 6737551 | PRJNA1255065_P_NODE_110826_length_168_cov_0.873950_g108598_i0 | PRJNA1255065 | 110826 | 168 | 0.87395 | 1.468236 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 82.4 | 1.8e-11 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g108598 | i0 | 82.353 | 184.392857142857 | 102 | 11 | 59 | 6 | 19 | 114 | 46221221 | 46221321 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 30978 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9288064 | 9288064 | PRJNA1255065_P_NODE_115828_length_167_cov_2.203390_g113600_i0 | PRJNA1255065 | 115828 | 167 | 2.20339 | 3.6796613 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g113600 | i0 | 94.286 | 0.209580838323353 | 35 | 2 | 21 | 0 | 15 | 49 | 16399777 | 16399811 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14389753 | 14389753 | PRJNA1255065_P_NODE_79972_length_200_cov_5.701987_g77744_i0 | PRJNA1255065 | 79972 | 200 | 5.701987 | 11.403974 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.04e-4 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g77744 | i0 | 100 | 16.86 | 32 | 0 | 16 | 0 | 136 | 167 | 1674376 | 1674407 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 3372 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15663482 | 15663482 | PRJNA1255065_P_NODE_74873_length_209_cov_3.775000_g72645_i0 | PRJNA1255065 | 74873 | 209 | 3.775 | 7.88975 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 2.35e-6 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g72645 | i0 | 78.846 | 1.91866028708134 | 104 | 16 | 47 | 5 | 111 | 209 | 869057 | 868955 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 401 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18211510 | 18211510 | PRJNA1255065_P_NODE_108595_length_169_cov_0.866667_g106367_i0 | PRJNA1255065 | 108595 | 169 | 0.866667 | 1.46466723 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 8.43e-5 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g106367 | i0 | 97.143 | 2.46745562130178 | 35 | 1 | 21 | 0 | 104 | 138 | 520404 | 520370 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 417 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20761816 | 20761816 | PRJNA1255065_P_NODE_155577_length_153_cov_4.192308_g153349_i0 | PRJNA1255065 | 155577 | 153 | 4.192308 | 6.41423124 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 84.2 | 4.44e-12 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g153349 | i0 | 80 | 14.3464052287582 | 115 | 21 | 74 | 1 | 39 | 151 | 16997629 | 16997743 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 2195 | 84.2 | 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);;