contig_metadata
14 rows where bioproject = "PRJNA534016", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1782934 | 1782934 | PRJNA534016_P_NODE_3942_length_414_cov_1.677419_g3852_i0 | PRJNA534016 | 3942 | 414 | 1.677419 | 6.94451466 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.04 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g3852 | i0 | 100 | 0.0676328502415459 | 28 | 0 | 7 | 0 | 100 | 127 | 14231448 | 14231475 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4334346 | 4334346 | PRJNA534016_P_NODE_1044_length_807_cov_2.852861_g967_i0 | PRJNA534016 | 1044 | 807 | 2.852861 | 23.02258827 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.006 | NTclustered | gi|675890235|ref|XM_009032372.1| | 6412 | g967 | i0 | 96.97 | 0.332094175960347 | 33 | 1 | 4 | 0 | 251 | 283 | 472 | 504 | Helobdella robusta hypothetical protein partial mRNA | blastn | 268 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 8160392 | 8160392 | PRJNA534016_P_NODE_8547_length_291_cov_1.261468_g8457_i0 | PRJNA534016 | 8547 | 291 | 1.261468 | 3.67087188 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.027 | NTclustered | gi|675890753|ref|XM_009032631.1| | 6412 | g8457 | i0 | 100 | 0.0962199312714777 | 28 | 0 | 10 | 0 | 228 | 255 | 601 | 574 | Helobdella robusta hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 13261421 | 13261421 | PRJNA534016_P_NODE_6491_length_330_cov_1.494163_g6401_i0 | PRJNA534016 | 6491 | 330 | 1.494163 | 4.9307379 | Capitella teleta | 283909 | Annelida | Annelida | 194 | 6.549999999999999e-57 | NR | ELT90819.1 | 283909 | g6401 | i0 | 84.4 | 31.7090909090909 | 109 | 17 | 99.1 | 0 | 2 | 328 | 214 | 322 | ELT90819.1 hypothetical protein CAPTEDRAFT_148058 [Capitella teleta] | diamond | 10464 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 14536394 | 14536394 | PRJNA534016_P_NODE_5512_length_355_cov_1.092199_g5422_i0 | PRJNA534016 | 5512 | 355 | 1.092199 | 3.87730645 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 4.31e-6 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g5422 | i0 | 80.435 | 8.76338028169014 | 92 | 12 | 26 | 3 | 165 | 256 | 13007069 | 13006984 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 3111 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23459730 | 23459730 | PRJNA534016_P_NODE_17379_length_243_cov_0.905882_g17289_i0 | PRJNA534016 | 17379 | 243 | 0.905882 | 2.20129326 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.71e-4 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g17289 | i0 | 97.143 | 2.07818930041152 | 35 | 0 | 14 | 1 | 1 | 34 | 13569384 | 13569350 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 505 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24733369 | 24733369 | PRJNA534016_P_NODE_13000_length_255_cov_2.247253_g12910_i0 | PRJNA534016 | 13000 | 255 | 2.247253 | 5.73049515 | Hirudo verbana | 311461 | Annelida | Annelida | 185 | 2.19e-42 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g12910 | i0 | 92.913 | 1.01176470588235 | 127 | 9 | 100 | 0 | 129 | 255 | 3830460 | 3830334 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 258 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24733462 | 24733462 | PRJNA534016_P_NODE_18940_length_231_cov_2.607595_g18850_i0 | PRJNA534016 | 18940 | 231 | 2.607595 | 6.02354445 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.44e-4 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g18850 | i0 | 92.5 | 2.35064935064935 | 40 | 3 | 17 | 0 | 36 | 75 | 14222459 | 14222420 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 543 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27394038 | 27394038 | PRJNA534016_P_NODE_18903_length_232_cov_2.421384_g18813_i0 | PRJNA534016 | 18903 | 232 | 2.421384 | 5.61761088 | Phragmatopoma lapidosa | 341668 | Annelida | Annelida | 69.7 | 5.62e-13 | NR | AIU94817.1 | 341668 | g18813 | i0 | 51.4 | 7.33189655172414 | 70 | 34 | 90.5 | 0 | 3 | 212 | 26 | 95 | AIU94817.1 60S ribosomal protein [Phragmatopoma lapidosa] | diamond | 1701 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellariidae | Phragmatopoma | Phragmatopoma lapidosa | |
| 27661541 | 27661541 | PRJNA534016_P_NODE_8784_length_289_cov_1.101852_g8694_i0 | PRJNA534016 | 8784 | 289 | 1.101852 | 3.18435228 | Metazoa | 33208 | Annelida | Annelida | 94.4 | 2.3700000000000003e-21 | NR | XP_009029297.1 | 6412 | g8694 | i0 | 55.1 | 10.961937716263 | 89 | 40 | 92.4 | 0 | 14 | 280 | 139 | 227 | XP_009029297.1 hypothetical protein HELRODRAFT_108236 [Helobdella robusta] | diamond | 3168 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28103261 | 28103261 | PRJNA534016_P_NODE_7505_length_309_cov_2.588983_g7415_i0 | PRJNA534016 | 7505 | 309 | 2.588983 | 7.99995747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.9 | 8.15e-11 | NR | ABW90355.1 | 6446 | g7415 | i0 | 35.7 | 4.64077669902913 | 98 | 63 | 95.1 | 0 | 15 | 308 | 40 | 137 | ABW90355.1 putative ribosomal protein L23a [Sipunculus nudus] | diamond | 1434 | 66.2 | 0.995468277945619 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 29240126 | 29240126 | PRJNA534016_P_NODE_6809_length_323_cov_1.780000_g6719_i0 | PRJNA534016 | 6809 | 323 | 1.78 | 5.7494 | Metazoa | 33208 | Annelida | Annelida | 129 | 2.52e-33 | NR | XP_009012828.1 | 6412 | g6719 | i0 | 58.3 | 2.89783281733746 | 108 | 43 | 98.5 | 1 | 321 | 4 | 61 | 168 | XP_009012828.1 hypothetical protein HELRODRAFT_74431, partial [Helobdella robusta] | diamond | 936 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29761788 | 29761788 | PRJNA534016_P_NODE_11931_length_264_cov_1.392670_g11841_i0 | PRJNA534016 | 11931 | 264 | 1.39267 | 3.6766488 | Capitella teleta | 283909 | Annelida | Annelida | 45.1 | 0.0052 | NR | ELU13009.1 | 283909 | g11841 | i0 | 65.5 | 2.11363636363636 | 29 | 10 | 33 | 0 | 262 | 176 | 124 | 152 | ELU13009.1 hypothetical protein CAPTEDRAFT_155905 [Capitella teleta] | diamond | 558 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31974369 | 31974369 | PRJNA534016_P_NODE_13018_length_255_cov_1.736264_g12928_i0 | PRJNA534016 | 13018 | 255 | 1.736264 | 4.4274732 | Owenia fusiformis | 6347 | Annelida | Annelida | 44.7 | 0.00827 | NR | CAH1786246.1 | 6347 | g12928 | i0 | 31.1 | 1.65882352941176 | 74 | 46 | 81.2 | 1 | 238 | 32 | 88 | 161 | CAH1786246.1 unnamed protein product [Owenia fusiformis] | diamond | 423 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;