contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322350 | 322350 | PRJNA1195374_P_NODE_79581_length_245_cov_0.895349_g79237_i0 | PRJNA1195374 | 79581 | 245 | 0.895349 | 2.19360505 | Hirudo verbana | 311461 | Annelida | Annelida | 67.6 | 7.9e-7 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g79237 | i0 | 89.091 | 349.54693877551 | 55 | 4 | 22 | 2 | 192 | 245 | 1513574 | 1513521 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 85639 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2871911 | 2871911 | PRJNA1195374_P_NODE_17223_length_545_cov_4.131356_g16881_i0 | PRJNA1195374 | 17223 | 545 | 4.131356 | 22.5158902 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.015 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g16881 | i0 | 94.444 | 0.0660550458715596 | 36 | 1 | 6 | 1 | 31 | 65 | 520190 | 520155 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2872306 | 2872306 | PRJNA1195374_P_NODE_35043_length_380_cov_1.850163_g34699_i0 | PRJNA1195374 | 35043 | 380 | 1.850163 | 7.0306194 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 2.16e-4 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g34699 | i0 | 97.143 | 1.79473684210526 | 35 | 1 | 9 | 0 | 326 | 360 | 8966196 | 8966162 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 682 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4147925 | 4147925 | PRJNA1195374_P_NODE_11924_length_647_cov_2.775261_g11592_i0 | PRJNA1195374 | 11924 | 647 | 2.775261 | 17.95593867 | Theromyzon tessulatum | 13286 | Annelida | Annelida | 313 | 2.67e-80 | NTclustered | gi|23344733|gb|AF542132.1| | 13286 | g11592 | i0 | 97.283 | 0.442040185471406 | 184 | 5 | 28 | 0 | 1 | 184 | 1158 | 975 | Theromyzon tessulatum cathepsin L mRNA, complete cds | blastn | 286 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Theromyzon | Theromyzon tessulatum | |
| 4871020 | 4871020 | PRJNA1195374_P_NODE_7504_length_790_cov_1.887029_g7200_i0 | PRJNA1195374 | 7504 | 790 | 1.887029 | 14.9075291 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.006 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g7200 | i0 | 96.97 | 0.489873417721519 | 33 | 1 | 4 | 0 | 2 | 34 | 31450532 | 31450564 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 387 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15070472 | 15070472 | PRJNA1195374_P_NODE_47372_length_321_cov_0.931452_g47028_i0 | PRJNA1195374 | 47372 | 321 | 0.931452 | 2.98996092 | Opisthokonta | 33154 | Annelida | Annelida | 52.8 | 0.03 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g47028 | i0 | 94.118 | 0.193146417445483 | 34 | 2 | 11 | 0 | 130 | 163 | 1094930 | 1094963 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16898893 | 16898893 | PRJNA1195374_P_NODE_50994_length_307_cov_1.965812_g50650_i0 | PRJNA1195374 | 50994 | 307 | 1.965812 | 6.03504284 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g50650 | i0 | 94.444 | 0.244299674267101 | 36 | 0 | 12 | 2 | 75 | 110 | 2493081 | 2493114 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 75 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20722504 | 20722504 | PRJNA1195374_P_NODE_18897_length_521_cov_2.629464_g18554_i0 | PRJNA1195374 | 18897 | 521 | 2.629464 | 13.69950744 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g18554 | i0 | 96.97 | 0.0633397312859885 | 33 | 1 | 6 | 0 | 333 | 365 | 2109333 | 2109365 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24547183 | 24547183 | PRJNA1195374_P_NODE_17560_length_540_cov_2.426124_g17218_i0 | PRJNA1195374 | 17560 | 540 | 2.426124 | 13.1010696 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g17218 | i0 | 97.059 | 0.062962962962963 | 34 | 1 | 6 | 0 | 318 | 351 | 7326198 | 7326231 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 34 | 58.4 | 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);;