contig_metadata
24 rows where bioproject = "PRJNA1068513" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6559726 | 6559726 | PRJNA1068513_S_NODE_1326_length_639_cov_4.340989_g1286_i0 | PRJNA1068513 | 1326 | 639 | 4.340989 | 27.73891971 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 197 | 4.12e-61 | NR | XP_067936191.1 | 2589382 | g1286 | i0 | 69.1 | 0.652582159624413 | 139 | 43 | 65.3 | 0 | 126 | 542 | 1 | 139 | XP_067936191.1 vesicle transport protein GOT1B-like [Watersipora subatra] | diamond | 417 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 11660483 | 11660483 | PRJNA1068513_S_NODE_2190_length_554_cov_1.831601_g2148_i0 | PRJNA1068513 | 2190 | 554 | 1.831601 | 10.14706954 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 192 | 3.1899999999999996e-54 | NR | KAF6025465.1 | 10212 | g2148 | i0 | 72.3 | 24.3953068592058 | 119 | 33 | 64.4 | 0 | 1 | 357 | 549 | 667 | KAF6025465.1 ABCD3 [Bugula neritina] | diamond | 13515 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 23134244 | 23134244 | PRJNA1068513_S_NODE_7879_length_323_cov_4.480000_g7833_i0 | PRJNA1068513 | 7879 | 323 | 4.48 | 14.4704 | Bryozoa | 10205 | Bryozoa | other_Eukaryota | 110 | 6.73e-28 | NR | KAF6024437.1 | 10212 | g7833 | i0 | 51.1 | 1.72755417956656 | 90 | 44 | 83.6 | 0 | 321 | 52 | 69 | 158 | KAF6024437.1 P4HB [Bugula neritina] | diamond | 558 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 24407778 | 24407778 | PRJNA1068513_S_NODE_5460_length_389_cov_2.025316_g5414_i0 | PRJNA1068513 | 5460 | 389 | 2.025316 | 7.87847924 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 91.7 | 1.44e-18 | NR | KAF6032603.1 | 10212 | g5414 | i0 | 46.2 | 4.18766066838046 | 91 | 48 | 70.2 | 1 | 389 | 117 | 581 | 670 | KAF6032603.1 C10orf76 [Bugula neritina] | diamond | 1629 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 26814235 | 26814235 | PRJNA1068513_S_NODE_701_length_757_cov_4.654971_g665_i0 | PRJNA1068513 | 701 | 757 | 4.654971 | 35.23813047 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 201 | 1.8599999999999997e-56 | NR | XP_067938086.1 | 2589382 | g665 | i0 | 59.3 | 2.10435931307794 | 177 | 72 | 70.1 | 0 | 2 | 532 | 468 | 644 | XP_067938086.1 annexin A7-like [Watersipora subatra] | diamond | 1593 | 201 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27090567 | 27090567 | PRJNA1068513_S_NODE_11962_length_253_cov_2.744444_g11916_i0 | PRJNA1068513 | 11962 | 253 | 2.744444 | 6.94344332 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 63.5 | 1.95e-9 | NR | KAF6031780.1 | 10212 | g11916 | i0 | 60 | 1.18577075098814 | 50 | 20 | 59.3 | 0 | 252 | 103 | 450 | 499 | KAF6031780.1 IK [Bugula neritina] | diamond | 300 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27288524 | 27288524 | PRJNA1068513_S_NODE_5403_length_391_cov_3.147799_g5357_i0 | PRJNA1068513 | 5403 | 391 | 3.147799 | 12.30789409 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 160 | 1.9e-44 | NR | XP_067945793.1 | 2589382 | g5357 | i0 | 79.8 | 2.27877237851662 | 99 | 20 | 76 | 0 | 389 | 93 | 363 | 461 | XP_067945793.1 eukaryotic translation initiation factor 2 subunit 3-like [Watersipora subatra] | diamond | 891 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27541340 | 27541340 | PRJNA1068513_S_NODE_11444_length_261_cov_1.255319_g11398_i0 | PRJNA1068513 | 11444 | 261 | 1.255319 | 3.27638259 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 43.5 | 0.0239 | NR | KAF6027109.1 | 10212 | g11398 | i0 | 42.5 | 0.919540229885057 | 40 | 23 | 46 | 0 | 220 | 101 | 417 | 456 | KAF6027109.1 TMEM237 [Bugula neritina] | diamond | 240 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28195748 | 28195748 | PRJNA1068513_S_NODE_5226_length_397_cov_3.475309_g5181_i0 | PRJNA1068513 | 5226 | 397 | 3.475309 | 13.79697673 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 81.3 | 1.52e-15 | NR | KAF6031997.1 | 10212 | g5181 | i0 | 56.3 | 6.92947103274559 | 64 | 28 | 48.4 | 0 | 3 | 194 | 170 | 233 | KAF6031997.1 PIGK [Bugula neritina] | diamond | 2751 | 81.6 | 0.996323529411765 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28298958 | 28298958 | PRJNA1068513_S_NODE_5986_length_372_cov_4.678930_g5940_i0 | PRJNA1068513 | 5986 | 372 | 4.67893 | 17.4056196 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 45.1 | 0.0244 | NR | XP_067932832.1 | 2589382 | g5940 | i0 | 34 | 0.782258064516129 | 97 | 57 | 74.2 | 2 | 19 | 294 | 461 | 555 | XP_067932832.1 double-stranded RNA-binding protein Staufen homolog 2-like isoform X2 [Watersipora subatra] | diamond | 291 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29111678 | 29111678 | PRJNA1068513_S_NODE_4268_length_435_cov_5.011050_g4223_i0 | PRJNA1068513 | 4268 | 435 | 5.01105 | 21.7980675 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 144 | 1.11e-36 | NR | KAF6025518.1 | 10212 | g4223 | i0 | 68.5 | 5.13793103448276 | 108 | 34 | 74.5 | 0 | 3 | 326 | 676 | 783 | KAF6025518.1 AFG3L2 [Bugula neritina] | diamond | 2235 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29647919 | 29647919 | PRJNA1068513_S_NODE_7510_length_332_cov_2.181467_g7464_i0 | PRJNA1068513 | 7510 | 332 | 2.181467 | 7.24247044 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 89.7 | 8.12e-20 | NR | KAF6023173.1 | 10212 | g7464 | i0 | 40 | 1.67168674698795 | 90 | 53 | 81.3 | 1 | 321 | 52 | 89 | 177 | KAF6023173.1 Rap2l [Bugula neritina] | diamond | 555 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30035779 | 30035779 | PRJNA1068513_S_NODE_3531_length_470_cov_1.551637_g3486_i0 | PRJNA1068513 | 3531 | 470 | 1.551637 | 7.2926939 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 124 | 6.7099999999999986e-31 | NR | KAF6027374.1 | 10212 | g3486 | i0 | 40.7 | 3.80425531914894 | 150 | 87 | 95.1 | 2 | 2 | 448 | 206 | 354 | KAF6027374.1 DYNC2LI1 [Bugula neritina] | diamond | 1788 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30193581 | 30193581 | PRJNA1068513_S_NODE_9612_length_290_cov_1.041475_g9566_i0 | PRJNA1068513 | 9612 | 290 | 1.041475 | 3.0202775 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 41.2 | 0.0342 | NR | KAF6022237.1 | 10212 | g9566 | i0 | 60 | 0.310344827586207 | 30 | 11 | 31 | 1 | 4 | 93 | 46 | 74 | KAF6022237.1 FAM188A [Bugula neritina] | diamond | 90 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30722267 | 30722267 | PRJNA1068513_S_NODE_10034_length_282_cov_1.736842_g9988_i0 | PRJNA1068513 | 10034 | 282 | 1.736842 | 4.89789444 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 156 | 2.69e-46 | NR | KAF6021917.1 | 10212 | g9988 | i0 | 84.8 | 6.69148936170213 | 79 | 12 | 84 | 0 | 244 | 8 | 78 | 156 | KAF6021917.1 MORN5 [Bugula neritina] | diamond | 1887 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30952140 | 30952140 | PRJNA1068513_S_NODE_10834_length_270_cov_2.791878_g10788_i0 | PRJNA1068513 | 10834 | 270 | 2.791878 | 7.5380706 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 55.8 | 1.14e-6 | NR | XP_067950158.1 | 2589382 | g10788 | i0 | 46.4 | 1.08888888888889 | 56 | 30 | 62.2 | 0 | 1 | 168 | 247 | 302 | XP_067950158.1 palmitoyltransferase ZDHHC2-like [Watersipora subatra] | diamond | 294 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 30983740 | 30983740 | PRJNA1068513_S_NODE_2934_length_502_cov_3.177156_g2889_i0 | PRJNA1068513 | 2934 | 502 | 3.177156 | 15.94932312 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 105 | 1.04e-25 | NR | KAF6020687.1 | 10212 | g2889 | i0 | 51.8 | 0.681274900398406 | 114 | 53 | 67.5 | 2 | 118 | 456 | 7 | 119 | KAF6020687.1 LYRM1 [Bugula neritina] | diamond | 342 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31038656 | 31038656 | PRJNA1068513_S_NODE_7175_length_340_cov_2.153558_g7129_i0 | PRJNA1068513 | 7175 | 340 | 2.153558 | 7.3220972 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 153 | 3.639999999999999e-43 | NR | KAF6030072.1 | 10212 | g7129 | i0 | 75.8 | 2.46176470588235 | 91 | 22 | 80.3 | 0 | 336 | 64 | 217 | 307 | KAF6030072.1 WDR92 [Bugula neritina] | diamond | 837 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31047068 | 31047068 | PRJNA1068513_S_NODE_8235_length_316_cov_1.119342_g8189_i0 | PRJNA1068513 | 8235 | 316 | 1.119342 | 3.53712072 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 105 | 6.289999999999999e-24 | NR | KAF6021019.1 | 10212 | g8189 | i0 | 45.7 | 4.94620253164557 | 105 | 57 | 99.7 | 0 | 2 | 316 | 1365 | 1469 | KAF6021019.1 MROH1 [Bugula neritina] | diamond | 1563 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31141162 | 31141162 | PRJNA1068513_S_NODE_8915_length_303_cov_1.643478_g8869_i0 | PRJNA1068513 | 8915 | 303 | 1.643478 | 4.97973834 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 74.7 | 4.48e-13 | NR | XP_067936762.1 | 2589382 | g8869 | i0 | 50.7 | 3.25742574257426 | 71 | 28 | 70.3 | 1 | 9 | 221 | 1100 | 1163 | XP_067936762.1 cytospin-A-like [Watersipora subatra] | diamond | 987 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 31607517 | 31607517 | PRJNA1068513_S_NODE_1476_length_620_cov_2.663620_g1435_i0 | PRJNA1068513 | 1476 | 620 | 2.66362 | 16.514444 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 127 | 5.4399999999999995e-30 | NR | KAF6024951.1 | 10212 | g1435 | i0 | 43.7 | 3.9 | 135 | 76 | 65.3 | 0 | 618 | 214 | 461 | 595 | KAF6024951.1 PPP2R1B [Bugula neritina] | diamond | 2418 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31805641 | 31805641 | PRJNA1068513_S_NODE_12077_length_252_cov_3.944134_g12031_i0 | PRJNA1068513 | 12077 | 252 | 3.944134 | 9.93921768 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 64.3 | 1.05e-9 | NR | KAF6032876.1 | 10212 | g12031 | i0 | 82.9 | 1.66666666666667 | 35 | 6 | 41.7 | 0 | 252 | 148 | 472 | 506 | KAF6032876.1 TEKT3 [Bugula neritina] | diamond | 420 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32090445 | 32090445 | PRJNA1068513_S_NODE_12878_length_246_cov_1.265896_g12832_i0 | PRJNA1068513 | 12878 | 246 | 1.265896 | 3.11410416 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 50.4 | 6.84e-5 | NR | XP_067939226.1 | 2589382 | g12832 | i0 | 43.6 | 0.670731707317073 | 55 | 27 | 67.1 | 1 | 228 | 64 | 230 | 280 | XP_067939226.1 golgin subfamily A member 6-like protein 4 [Watersipora subatra] | diamond | 165 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 32627874 | 32627874 | PRJNA1068513_S_NODE_1980_length_569_cov_12.467742_g1938_i0 | PRJNA1068513 | 1980 | 569 | 12.467742 | 70.94145198 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 175 | 1.21e-47 | NR | XP_067938086.1 | 2589382 | g1938 | i0 | 59.3 | 5.36203866432337 | 145 | 59 | 76.4 | 0 | 563 | 129 | 500 | 644 | XP_067938086.1 annexin A7-like [Watersipora subatra] | diamond | 3051 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra |
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);;