contig_metadata
18 rows where bioproject = "PRJNA312899", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 379960 | 379960 | PRJNA312899_P_NODE_64841_length_206_cov_1.299363_g64399_i0 | PRJNA312899 | 64841 | 206 | 1.299363 | 2.67668778 | Hirudo verbana | 311461 | Annelida | Annelida | 130 | 8.09e-26 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g64399 | i0 | 84.615 | 5.39320388349515 | 130 | 20 | 63 | 0 | 42 | 171 | 3079066 | 3079195 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 1111 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1654058 | 1654058 | PRJNA312899_P_NODE_27682_length_353_cov_9.180921_g27240_i0 | PRJNA312899 | 27682 | 353 | 9.180921 | 32.40865113 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g27240 | i0 | 100 | 0.084985835694051 | 30 | 0 | 8 | 0 | 132 | 161 | 6818430 | 6818459 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2929887 | 2929887 | PRJNA312899_P_NODE_24543_length_378_cov_4.942249_g24101_i0 | PRJNA312899 | 24543 | 378 | 4.942249 | 18.68170122 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 4.63e-6 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g24101 | i0 | 91.667 | 3.00529100529101 | 48 | 2 | 12 | 2 | 283 | 329 | 666824 | 666870 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 1136 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4206723 | 4206723 | PRJNA312899_P_NODE_41424_length_276_cov_11.392070_g40982_i0 | PRJNA312899 | 41424 | 276 | 11.39207 | 31.4421132 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g40982 | i0 | 100 | 0.829710144927536 | 29 | 0 | 11 | 0 | 3 | 31 | 696916 | 696888 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 229 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6757148 | 6757148 | PRJNA312899_P_NODE_3786_length_902_cov_66.601407_g3519_i0 | PRJNA312899 | 3786 | 902 | 66.601407 | 600.74469114 | Metazoa | 33208 | Annelida | Annelida | 87 | 4.08e-15 | NR | CAH1776528.1 | 6347 | g3519 | i0 | 72.9 | 1.45011086474501 | 48 | 13 | 16 | 0 | 16 | 159 | 365 | 412 | CAH1776528.1 unnamed protein product [Owenia fusiformis] | diamond | 1308 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 6757704 | 6757704 | PRJNA312899_P_NODE_69546_length_194_cov_12.648276_g69104_i0 | PRJNA312899 | 69546 | 194 | 12.648276 | 24.53765544 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 346 | 6.860000000000001e-91 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g69104 | i0 | 98.964 | 96.159793814433 | 193 | 2 | 99 | 0 | 2 | 194 | 3421 | 3229 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 18655 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 8033136 | 8033136 | PRJNA312899_P_NODE_61107_length_215_cov_2.457831_g60665_i0 | PRJNA312899 | 61107 | 215 | 2.457831 | 5.28433665 | Helmutneris vadum | 2801950 | Annelida | Annelida | 102 | 1.86e-17 | NTclustered | gi|1954991903|gb|MT763202.1| | 2801950 | g60665 | i0 | 79.355 | 34.1395348837209 | 155 | 25 | 70 | 7 | 65 | 215 | 236 | 85 | Helmutneris vadum voucher W44399 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 7340 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Lumbrineridae | Helmutneris | Helmutneris vadum | |
| 11857631 | 11857631 | PRJNA312899_P_NODE_13670_length_510_cov_78.550976_g13239_i0 | PRJNA312899 | 13670 | 510 | 78.550976 | 400.6099776 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.014 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g13239 | i0 | 96.875 | 0.0627450980392157 | 32 | 1 | 6 | 0 | 119 | 150 | 3168846 | 3168815 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 11857658 | 11857658 | PRJNA312899_P_NODE_14830_length_490_cov_27.594104_g14395_i0 | PRJNA312899 | 14830 | 490 | 27.594104 | 135.2111096 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.013 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g14395 | i0 | 100 | 0.0591836734693878 | 29 | 0 | 6 | 0 | 346 | 374 | 9703423 | 9703451 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16366884 | 16366884 | PRJNA312899_P_NODE_23513_length_387_cov_3.908284_g23071_i0 | PRJNA312899 | 23513 | 387 | 3.908284 | 15.12505908 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 98.2 | 5.53e-22 | NR | XP_009020225.1 | 6412 | g23071 | i0 | 35.4 | 12.3565891472868 | 130 | 78 | 96.9 | 2 | 384 | 10 | 26 | 154 | XP_009020225.1 hypothetical protein HELRODRAFT_112561 [Helobdella robusta] | diamond | 4782 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 16956804 | 16956804 | PRJNA312899_P_NODE_34034_length_312_cov_10.726236_g33592_i0 | PRJNA312899 | 34034 | 312 | 10.726236 | 33.46585632 | Hirudo verbana | 311461 | Annelida | Annelida | 76.8 | 1.73e-9 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g33592 | i0 | 87.692 | 43.9839743589744 | 65 | 8 | 21 | 0 | 144 | 208 | 505283 | 505219 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 13723 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19505142 | 19505142 | PRJNA312899_P_NODE_20856_length_411_cov_32.016575_g20415_i0 | PRJNA312899 | 20856 | 411 | 32.016575 | 131.58812325 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g20415 | i0 | 100 | 0.072992700729927 | 30 | 0 | 7 | 0 | 336 | 365 | 21847366 | 21847395 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19505584 | 19505584 | PRJNA312899_P_NODE_43796_length_267_cov_6.711009_g43354_i0 | PRJNA312899 | 43796 | 267 | 6.711009 | 17.91839403 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g43354 | i0 | 100 | 0.104868913857678 | 28 | 0 | 10 | 0 | 165 | 192 | 8279171 | 8279198 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24606329 | 24606329 | PRJNA312899_P_NODE_83540_length_172_cov_1.609756_g83098_i0 | PRJNA312899 | 83540 | 172 | 1.609756 | 2.76878032 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g83098 | i0 | 100 | 0.488372093023256 | 28 | 0 | 16 | 0 | 109 | 136 | 11954806 | 11954779 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26743270 | 26743270 | PRJNA312899_P_NODE_6001_length_755_cov_2.011331_g5666_i0 | PRJNA312899 | 6001 | 755 | 2.011331 | 15.18554905 | Metazoa | 33208 | Annelida | Annelida | 73.9 | 2e-11 | NR | CAH1794214.1 | 6347 | g5666 | i0 | 44.6 | 1.99072847682119 | 83 | 43 | 31.8 | 1 | 752 | 513 | 112 | 194 | CAH1794214.1 unnamed protein product [Owenia fusiformis] | diamond | 1503 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29410996 | 29410996 | PRJNA312899_P_NODE_23349_length_388_cov_12.253687_g22907_i0 | PRJNA312899 | 23349 | 388 | 12.253687 | 47.54430556 | Pectinaria gouldii | 260746 | Annelida | Annelida | 160 | 5.559999999999999e-48 | NR | AKV16230.1 | 260746 | g22907 | i0 | 78.1 | 11.7371134020619 | 96 | 21 | 74.2 | 0 | 293 | 6 | 15 | 110 | AKV16230.1 60S ribosomal protein [Pectinaria gouldii] | diamond | 4554 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Pectinariidae | Pectinaria | Pectinaria gouldii | |
| 29617730 | 29617730 | PRJNA312899_P_NODE_37290_length_295_cov_4.138211_g36848_i0 | PRJNA312899 | 37290 | 295 | 4.138211 | 12.20772245 | Metazoa | 33208 | Annelida | Annelida | 173 | 5.37e-51 | NR | XP_009010914.1 | 6412 | g36848 | i0 | 79.4 | 48.4067796610169 | 97 | 20 | 98.6 | 0 | 292 | 2 | 111 | 207 | XP_009010914.1 hypothetical protein HELRODRAFT_96941 [Helobdella robusta] | diamond | 14280 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31907563 | 31907563 | PRJNA312899_P_NODE_12037_length_545_cov_24.973790_g11610_i0 | PRJNA312899 | 12037 | 545 | 24.97379 | 136.1071555 | Helobdella robusta | 6412 | Annelida | Annelida | 63.5 | 3.79e-8 | NR | XP_009018683.1 | 6412 | g11610 | i0 | 54.2 | 0.64954128440367 | 59 | 27 | 32.5 | 0 | 227 | 51 | 22 | 80 | XP_009018683.1 hypothetical protein HELRODRAFT_173825 [Helobdella robusta] | diamond | 354 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;