contig_metadata
20 rows where bioproject = "PRJNA615351" and tax_phylum = "Bryozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1871993 | 1871993 | PRJNA615351_P_NODE_88342_length_374_cov_2.905605_g74265_i0 | PRJNA615351 | 88342 | 374 | 2.905605 | 10.8669627 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 65.8 | 4.57e-6 | NTclustered | gi|2795726385|ref|XM_068086924.1| | 2589382 | g74265 | i0 | 85.714 | 0.818181818181818 | 63 | 8 | 17 | 1 | 312 | 374 | 183 | 244 | PREDICTED: Watersipora subatra uncharacterized protein (LOC137400593), mRNA | blastn | 306 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 4423346 | 4423346 | PRJNA615351_P_NODE_40404_length_892_cov_7.841307_g30009_i0 | PRJNA615351 | 40404 | 892 | 7.841307 | 69.94445844 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 170 | 4.86e-49 | NR | ABX44826.1 | 478208 | g30009 | i0 | 65.5 | 3.36659192825112 | 148 | 45 | 49.8 | 2 | 708 | 265 | 16 | 157 | ABX44826.1 putative 60S ribosomal protein RPL23A [Flustra foliacea] | diamond | 3003 | 171 | 0.994152046783626 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Flustridae | Flustra | Flustra foliacea | |
| 18447591 | 18447591 | PRJNA615351_P_NODE_138375_length_209_cov_1.839080_g124275_i0 | PRJNA615351 | 138375 | 209 | 1.83908 | 3.8436772 | Flustra foliacea | 478208 | Bryozoa | other_Eukaryota | 82.8 | 3.1e-19 | NR | ABX44844.1 | 478208 | g124275 | i0 | 80 | 1.53588516746411 | 50 | 10 | 71.8 | 0 | 187 | 38 | 1 | 50 | ABX44844.1 putative 60S ribosomal protein RPL39 [Flustra foliacea] | diamond | 321 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Flustridae | Flustra | Flustra foliacea | |
| 20998185 | 20998185 | PRJNA615351_P_NODE_72637_length_479_cov_13.279279_g58692_i0 | PRJNA615351 | 72637 | 479 | 13.279279 | 63.60774641 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 76.8 | 2.77e-9 | NTclustered | gi|2795667731|ref|XM_068083011.1| | 2589382 | g58692 | i0 | 100 | 10.9060542797495 | 41 | 0 | 9 | 0 | 439 | 479 | 55 | 15 | PREDICTED: Watersipora subatra protein hunchback-like (LOC137396666), mRNA | blastn | 5224 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 26903626 | 26903626 | PRJNA615351_P_NODE_105381_length_296_cov_3.229885_g91282_i0 | PRJNA615351 | 105381 | 296 | 3.229885 | 9.5604596 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 124 | 2.58e-34 | NR | XP_067940690.1 | 2589382 | g91282 | i0 | 56.1 | 2.97972972972973 | 98 | 43 | 99.3 | 0 | 2 | 295 | 5 | 102 | XP_067940690.1 small ribosomal subunit protein uS13 isoform X3 [Watersipora subatra] | diamond | 882 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 26998277 | 26998277 | PRJNA615351_P_NODE_43722_length_831_cov_2.655779_g32688_i0 | PRJNA615351 | 43722 | 831 | 2.655779 | 22.06952349 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 1.08e-26 | NR | KAF6031922.1 | 10212 | g32688 | i0 | 40.5 | 16.0505415162455 | 200 | 87 | 68.2 | 5 | 814 | 248 | 107 | 285 | KAF6031922.1 KIF27 [Bugula neritina] | diamond | 13338 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27111960 | 27111960 | PRJNA615351_P_NODE_44702_length_814_cov_2.889602_g33495_i0 | PRJNA615351 | 44702 | 814 | 2.889602 | 23.52136028 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 102 | 7.77e-22 | NR | XP_067934134.1 | 2589382 | g33495 | i0 | 30.7 | 0.733415233415233 | 199 | 116 | 73.3 | 6 | 43 | 639 | 22 | 198 | XP_067934134.1 uncharacterized protein [Watersipora subatra] | diamond | 597 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27270090 | 27270090 | PRJNA615351_P_NODE_62823_length_567_cov_39.795113_g49365_i0 | PRJNA615351 | 62823 | 567 | 39.795113 | 225.63829071 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 81.6 | 4.1e-15 | NR | KAF6038236.1 | 10212 | g49365 | i0 | 41.4 | 1.17460317460317 | 111 | 65 | 58.7 | 0 | 511 | 179 | 122 | 232 | KAF6038236.1 RPL28 [Bugula neritina] | diamond | 666 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27301732 | 27301732 | PRJNA615351_P_NODE_171123_length_164_cov_1.720930_g157023_i0 | PRJNA615351 | 171123 | 164 | 1.72093 | 2.8223252 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 42.4 | 0.0176 | NR | XP_067927910.1 | 2589382 | g157023 | i0 | 41.5 | 0.969512195121951 | 53 | 31 | 97 | 0 | 162 | 4 | 376 | 428 | XP_067927910.1 F-box/LRR-repeat protein 20-like [Watersipora subatra] | diamond | 159 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27681087 | 27681087 | PRJNA615351_P_NODE_81944_length_413_cov_1.756614_g67895_i0 | PRJNA615351 | 81944 | 413 | 1.756614 | 7.25481582 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 64.3 | 7.34e-9 | NR | XP_067948316.1 | 2589382 | g67895 | i0 | 76.9 | 1.41646489104116 | 39 | 9 | 28.3 | 0 | 3 | 119 | 1518 | 1556 | XP_067948316.1 multidrug resistance-associated protein 1-like [Watersipora subatra] | diamond | 585 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27933302 | 27933302 | PRJNA615351_P_NODE_47205_length_770_cov_2.789116_g33495_i1 | PRJNA615351 | 47205 | 770 | 2.789116 | 21.4761932 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 102 | 3.91e-22 | NR | XP_067934134.1 | 2589382 | g33495 | i1 | 31.2 | 0.775324675324675 | 199 | 115 | 77.5 | 6 | 43 | 639 | 22 | 198 | XP_067934134.1 uncharacterized protein [Watersipora subatra] | diamond | 597 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28312179 | 28312179 | PRJNA615351_P_NODE_171786_length_163_cov_3.296875_g157686_i0 | PRJNA615351 | 171786 | 163 | 3.296875 | 5.37390625 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 41.6 | 0.0328 | NR | KAF6020496.1 | 10212 | g157686 | i0 | 41.3 | 0.846625766871166 | 46 | 27 | 84.7 | 0 | 162 | 25 | 163 | 208 | KAF6020496.1 RfC38 [Bugula neritina] | diamond | 138 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29070041 | 29070041 | PRJNA615351_P_NODE_14668_length_1717_cov_4.991082_g10575_i0 | PRJNA615351 | 14668 | 1717 | 4.991082 | 85.69687794 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 80.5 | 2.76e-12 | NR | XP_067936287.1 | 2589382 | g10575 | i0 | 29.4 | 0.344205008736168 | 197 | 83 | 34.4 | 6 | 1606 | 1016 | 44 | 184 | XP_067936287.1 PI-PLC X domain-containing protein 3-like [Watersipora subatra] | diamond | 591 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29891097 | 29891097 | PRJNA615351_P_NODE_45051_length_808_cov_2.952135_g33776_i0 | PRJNA615351 | 45051 | 808 | 2.952135 | 23.8532508 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 53.9 | 3.3e-4 | NR | KAF6031115.1 | 10212 | g33776 | i0 | 42.9 | 0.738861386138614 | 56 | 28 | 20.8 | 1 | 565 | 732 | 172 | 223 | KAF6031115.1 hypothetical protein EB796_010591 [Bugula neritina] | diamond | 597 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30143320 | 30143320 | PRJNA615351_P_NODE_66432_length_533_cov_2.257028_g52724_i0 | PRJNA615351 | 66432 | 533 | 2.257028 | 12.02995924 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 106 | 6.169999999999999e-23 | NR | XP_067931787.1 | 2589382 | g52724 | i0 | 37.3 | 0.99624765478424 | 177 | 75 | 99.6 | 3 | 533 | 3 | 364 | 504 | XP_067931787.1 membrane-bound transcription factor site-1 protease-like [Watersipora subatra] | diamond | 531 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 31154342 | 31154342 | PRJNA615351_P_NODE_30755_length_1111_cov_8.612454_g22489_i0 | PRJNA615351 | 30755 | 1111 | 8.612454 | 95.68436394 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 85.5 | 1.68e-14 | NR | KAF6032042.1 | 10212 | g22489 | i0 | 27.3 | 0.831683168316832 | 308 | 177 | 76.1 | 10 | 99 | 944 | 3 | 289 | KAF6032042.1 PAQR5 [Bugula neritina] | diamond | 924 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31312628 | 31312628 | PRJNA615351_P_NODE_106755_length_291_cov_2.035156_g92656_i0 | PRJNA615351 | 106755 | 291 | 2.035156 | 5.92230396 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 128 | 4.63e-33 | NR | XP_067940045.1 | 2589382 | g92656 | i0 | 63.8 | 1.92783505154639 | 94 | 31 | 96.9 | 1 | 291 | 10 | 322 | 412 | XP_067940045.1 dipeptidyl peptidase 1-like [Watersipora subatra] | diamond | 561 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 31376047 | 31376047 | PRJNA615351_P_NODE_122896_length_243_cov_1.153846_g108796_i0 | PRJNA615351 | 122896 | 243 | 1.153846 | 2.80384578 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 68.6 | 6.75e-12 | NR | XP_067934564.1 | 2589382 | g108796 | i0 | 48.4 | 3.11111111111111 | 64 | 33 | 79 | 0 | 51 | 242 | 15 | 78 | XP_067934564.1 transmembrane emp24 domain-containing protein 2-like [Watersipora subatra] | diamond | 756 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 32008739 | 32008739 | PRJNA615351_P_NODE_48278_length_752_cov_3.624826_g36448_i0 | PRJNA615351 | 48278 | 752 | 3.624826 | 27.25869152 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 92 | 4e-17 | NR | XP_067936857.1 | 2589382 | g36448 | i0 | 30.4 | 0.997340425531915 | 250 | 147 | 96.5 | 12 | 735 | 10 | 176 | 406 | XP_067936857.1 latent-transforming growth factor beta-binding protein 2-like [Watersipora subatra] | diamond | 750 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 32798280 | 32798280 | PRJNA615351_P_NODE_155420_length_182_cov_2.585034_g141320_i0 | PRJNA615351 | 155420 | 182 | 2.585034 | 4.70476188 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 42.4 | 0.015 | NR | KAF6035235.1 | 10212 | g141320 | i0 | 35.2 | 0.89010989010989 | 54 | 27 | 75.8 | 1 | 41 | 178 | 33 | 86 | KAF6035235.1 hypothetical protein EB796_006439 [Bugula neritina] | diamond | 162 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina |
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);;