contig_metadata
11 rows where bioproject = "PRJNA797655", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 784190 | 784190 | PRJNA797655_S_NODE_184061_length_186_cov_3.104895_g183456_i0 | PRJNA797655 | 184061 | 186 | 3.104895 | 5.7751047 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g183456 | i0 | 96.97 | 0.17741935483871 | 33 | 0 | 18 | 1 | 140 | 172 | 20690944 | 20690975 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2058322 | 2058322 | PRJNA797655_S_NODE_130202_length_220_cov_1.587571_g129597_i0 | PRJNA797655 | 130202 | 220 | 1.587571 | 3.4926562 | Dasybranchus sp. DH1 | 547546 | Annelida | Annelida | 401 | 1.6799999999999993e-107 | NTclustered | gi|194579818|gb|EU835658.1| | 547546 | g129597 | i0 | 99.545 | 99.4090909090909 | 220 | 1 | 100 | 0 | 1 | 220 | 425 | 206 | Dasybranchus sp. DH1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 21870 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Dasybranchus | Dasybranchus sp. DH1 | ||
| 3334228 | 3334228 | PRJNA797655_S_NODE_151823_length_205_cov_1.481481_g151218_i0 | PRJNA797655 | 151823 | 205 | 1.481481 | 3.03703605 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.018 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g151218 | i0 | 100 | 0.136585365853659 | 28 | 0 | 14 | 0 | 18 | 45 | 12483911 | 12483884 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5885793 | 5885793 | PRJNA797655_S_NODE_121405_length_227_cov_1.353261_g120800_i0 | PRJNA797655 | 121405 | 227 | 1.353261 | 3.07190247 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g120800 | i0 | 100 | 6.09691629955947 | 29 | 0 | 13 | 0 | 10 | 38 | 5289852 | 5289824 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 1384 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8435217 | 8435217 | PRJNA797655_S_NODE_117027_length_230_cov_3.951872_g116422_i0 | PRJNA797655 | 117027 | 230 | 3.951872 | 9.0893056 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 9.49e-6 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g116422 | i0 | 90.196 | 1.45652173913043 | 51 | 2 | 22 | 3 | 85 | 133 | 1008114 | 1008163 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 335 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10992761 | 10992761 | PRJNA797655_S_NODE_77969_length_270_cov_2.960352_g77364_i0 | PRJNA797655 | 77969 | 270 | 2.960352 | 7.9929504 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g77364 | i0 | 100 | 0.103703703703704 | 28 | 0 | 10 | 0 | 95 | 122 | 8294435 | 8294462 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13542809 | 13542809 | PRJNA797655_S_NODE_90511_length_256_cov_1.300469_g89906_i0 | PRJNA797655 | 90511 | 256 | 1.300469 | 3.32920064 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5e-4 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g89906 | i0 | 100 | 0.12109375 | 31 | 0 | 12 | 0 | 70 | 100 | 1492633 | 1492663 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16087928 | 16087928 | PRJNA797655_S_NODE_22233_length_401_cov_2.421788_g21631_i0 | PRJNA797655 | 22233 | 401 | 2.421788 | 9.71136988 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.038 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g21631 | i0 | 100 | 0.0698254364089776 | 28 | 0 | 7 | 0 | 290 | 317 | 31284760 | 31284733 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18638266 | 18638266 | PRJNA797655_S_NODE_269455_length_152_cov_1.321101_g268850_i0 | PRJNA797655 | 269455 | 152 | 1.321101 | 2.00807352 | Hirudo verbana | 311461 | Annelida | Annelida | 67.6 | 4.44e-7 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g268850 | i0 | 91.837 | 0.322368421052632 | 49 | 2 | 32 | 2 | 99 | 146 | 14432357 | 14432404 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 49 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18638566 | 18638566 | PRJNA797655_S_NODE_278655_length_150_cov_1.794393_g278050_i0 | PRJNA797655 | 278655 | 150 | 1.794393 | 2.6915895 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.012 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g278050 | i0 | 100 | 0.186666666666667 | 28 | 0 | 19 | 0 | 72 | 99 | 4506914 | 4506887 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18639988 | 18639988 | PRJNA797655_S_NODE_67655_length_284_cov_3.377593_g67050_i0 | PRJNA797655 | 67655 | 284 | 3.377593 | 9.59236412 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.026 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g67050 | i0 | 100 | 0.0985915492957746 | 28 | 0 | 10 | 0 | 21 | 48 | 18053941 | 18053968 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 28 | 52.8 | 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);;