contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17288555 | 17288555 | PRJNA724011_P_NODE_26154_length_551_cov_1.797071_g25138_i0 | PRJNA724011 | 26154 | 551 | 1.797071 | 9.90186121 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 175 | 1.6399999999999997e-52 | NR | XP_067932482.1 | 2589382 | g25138 | i0 | 68.8 | 4.13248638838475 | 128 | 40 | 69.7 | 0 | 422 | 39 | 30 | 157 | XP_067932482.1 large ribosomal subunit protein uL23-like [Watersipora subatra] | diamond | 2277 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 19837607 | 19837607 | PRJNA724011_P_NODE_48676_length_372_cov_2.648829_g47653_i0 | PRJNA724011 | 48676 | 372 | 2.648829 | 9.85364388 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 84.7 | 3.35e-16 | NR | XP_067931323.1 | 2589382 | g47653 | i0 | 67.2 | 0.467741935483871 | 58 | 19 | 46.8 | 0 | 192 | 19 | 4 | 61 | XP_067931323.1 kinesin-like protein KIF28 [Watersipora subatra] | diamond | 174 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 26640664 | 26640664 | PRJNA724011_P_NODE_88201_length_261_cov_1.271277_g87178_i0 | PRJNA724011 | 88201 | 261 | 1.271277 | 3.31803297 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 45.4 | 0.00491 | NR | KAF6020354.1 | 10212 | g87178 | i0 | 48.6 | 1.06896551724138 | 35 | 18 | 40.2 | 0 | 238 | 134 | 29 | 63 | KAF6020354.1 hypothetical protein EB796_021326 [Bugula neritina] | diamond | 279 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 26735248 | 26735248 | PRJNA724011_P_NODE_94381_length_251_cov_0.865169_g93358_i0 | PRJNA724011 | 94381 | 251 | 0.865169 | 2.17157419 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 46.6 | 0.00185 | NR | KAF6020189.1 | 10212 | g93358 | i0 | 38.2 | 0.812749003984064 | 68 | 38 | 81.3 | 1 | 22 | 225 | 1492 | 1555 | KAF6020189.1 HEATR1 [Bugula neritina] | diamond | 204 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 26777839 | 26777839 | PRJNA724011_P_NODE_29161_length_514_cov_3.102041_g28143_i0 | PRJNA724011 | 29161 | 514 | 3.102041 | 15.94449074 | Opisthokonta | 33154 | Bryozoa | other_Eukaryota | 89.4 | 3.93e-17 | NR | KAF6028921.1 | 10212 | g28143 | i0 | 33.6 | 4.10894941634241 | 143 | 89 | 83.5 | 1 | 513 | 85 | 690 | 826 | KAF6028921.1 hypothetical protein EB796_012775 [Bugula neritina] | diamond | 2112 | 89.7 | 0.996655518394649 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27283824 | 27283824 | PRJNA724011_P_NODE_48523_length_373_cov_1.740000_g47500_i0 | PRJNA724011 | 48523 | 373 | 1.74 | 6.4902 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 4.23e-30 | NR | KAF6040457.1 | 10212 | g47500 | i0 | 60 | 13.2386058981233 | 100 | 39 | 79.6 | 1 | 302 | 6 | 984 | 1083 | KAF6040457.1 ABCC5 [Bugula neritina] | diamond | 4938 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27399926 | 27399926 | PRJNA724011_P_NODE_28563_length_521_cov_2.629464_g27546_i0 | PRJNA724011 | 28563 | 521 | 2.629464 | 13.69950744 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 95.9 | 1.87e-19 | NR | XP_067951620.1 | 2589382 | g27546 | i0 | 33.2 | 1.0595009596929 | 184 | 105 | 98.5 | 5 | 518 | 6 | 172 | 350 | XP_067951620.1 protein F37C4.5-like [Watersipora subatra] | diamond | 552 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27399943 | 27399943 | PRJNA724011_P_NODE_39223_length_427_cov_1.666667_g38200_i0 | PRJNA724011 | 39223 | 427 | 1.666667 | 7.11666809 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 71.6 | 2.31e-11 | NR | XP_067942274.1 | 2589382 | g38200 | i0 | 34.6 | 5.95081967213115 | 130 | 79 | 88.5 | 4 | 378 | 1 | 536 | 663 | XP_067942274.1 serine/threonine-protein kinase D3-like [Watersipora subatra] | diamond | 2541 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27557427 | 27557427 | PRJNA724011_P_NODE_1564_length_2186_cov_2.661145_g1331_i0 | PRJNA724011 | 1564 | 2186 | 2.661145 | 58.1726297 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 66.6 | 5.04e-7 | NR | KAF6038856.1 | 10212 | g1331 | i0 | 29.3 | 0.609332113449222 | 150 | 77 | 19.2 | 7 | 1038 | 1457 | 894 | 1024 | KAF6038856.1 clec-78 [Bugula neritina] | diamond | 1332 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27883773 | 27883773 | PRJNA724011_P_NODE_59685_length_330_cov_1.797665_g58662_i0 | PRJNA724011 | 59685 | 330 | 1.797665 | 5.9322945 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 3.1500000000000004e-27 | NR | KAF6040607.1 | 10212 | g58662 | i0 | 58 | 4.6 | 100 | 41 | 90 | 1 | 1 | 297 | 711 | 810 | KAF6040607.1 RAD54B [Bugula neritina] | diamond | 1518 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28094407 | 28094407 | PRJNA724011_P_NODE_28185_length_525_cov_19.261062_g27168_i0 | PRJNA724011 | 28185 | 525 | 19.261062 | 101.1205755 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 82.8 | 1.05e-15 | NR | KAF6038236.1 | 10212 | g27168 | i0 | 41.4 | 1.26857142857143 | 111 | 65 | 63.4 | 0 | 49 | 381 | 122 | 232 | KAF6038236.1 RPL28 [Bugula neritina] | diamond | 666 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28410230 | 28410230 | PRJNA724011_P_NODE_32906_length_477_cov_1.707921_g31887_i0 | PRJNA724011 | 32906 | 477 | 1.707921 | 8.14678317 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 74.3 | 4.66e-12 | NR | XP_067940319.1 | 2589382 | g31887 | i0 | 34.3 | 0.89937106918239 | 143 | 79 | 83.6 | 5 | 477 | 79 | 470 | 607 | XP_067940319.1 BOS complex subunit NOMO3-like isoform X2 [Watersipora subatra] | diamond | 429 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28504899 | 28504899 | PRJNA724011_P_NODE_67567_length_307_cov_1.316239_g66544_i0 | PRJNA724011 | 67567 | 307 | 1.316239 | 4.04085373 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 48.9 | 5.6e-4 | NR | XP_067940384.1 | 2589382 | g66544 | i0 | 55.6 | 0.439739413680782 | 45 | 17 | 41 | 1 | 305 | 180 | 466 | 510 | XP_067940384.1 LOW QUALITY PROTEIN: uncharacterized protein [Watersipora subatra] | diamond | 135 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28788909 | 28788909 | PRJNA724011_P_NODE_57047_length_339_cov_1.484962_g56024_i0 | PRJNA724011 | 57047 | 339 | 1.484962 | 5.03402118 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 98.6 | 3.82e-22 | NR | XP_067931811.1 | 2589382 | g56024 | i0 | 52.3 | 0.778761061946903 | 88 | 42 | 77.9 | 0 | 70 | 333 | 114 | 201 | XP_067931811.1 ubiquitin thioesterase OTU1-like [Watersipora subatra] | diamond | 264 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28820365 | 28820365 | PRJNA724011_P_NODE_76708_length_284_cov_3.412322_g75685_i0 | PRJNA724011 | 76708 | 284 | 3.412322 | 9.69099448 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 42.7 | 0.0464 | NR | XP_067950887.1 | 2589382 | g75685 | i0 | 39.3 | 0.644366197183099 | 61 | 32 | 64.4 | 2 | 282 | 100 | 154 | 209 | XP_067950887.1 ras-related protein Rab-21-like [Watersipora subatra] | diamond | 183 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29010446 | 29010446 | PRJNA724011_P_NODE_18948_length_679_cov_1.902640_g17943_i0 | PRJNA724011 | 18948 | 679 | 1.90264 | 12.9189256 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 61.2 | 6.26e-7 | NR | XP_067936570.1 | 2589382 | g17943 | i0 | 29.3 | 2.9779086892489 | 174 | 96 | 73.8 | 5 | 166 | 666 | 210 | 363 | XP_067936570.1 CDP-diacylglycerol--glycerol-3-phosphate 3-phosphatidyltransferase, mitochondrial-like [Watersipora subatra] | diamond | 2022 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29619947 | 29619947 | PRJNA724011_P_NODE_22950_length_599_cov_2.562738_g21936_i0 | PRJNA724011 | 22950 | 599 | 2.562738 | 15.35080062 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 3.0799999999999995e-37 | NR | KAF6029688.1 | 10212 | g21936 | i0 | 51.1 | 4.14691151919866 | 141 | 64 | 70.6 | 1 | 425 | 3 | 1 | 136 | KAF6029688.1 KIF3C [Bugula neritina] | diamond | 2484 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29767776 | 29767776 | PRJNA724011_P_NODE_69931_length_301_cov_1.008772_g68908_i0 | PRJNA724011 | 69931 | 301 | 1.008772 | 3.03640372 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 97.1 | 2.16e-22 | NR | XP_067942426.1 | 2589382 | g68908 | i0 | 49.4 | 0.887043189368771 | 89 | 43 | 88.7 | 1 | 35 | 301 | 112 | 198 | XP_067942426.1 N-alpha-acetyltransferase 40-like isoform X2 [Watersipora subatra] | diamond | 267 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29778179 | 29778179 | PRJNA724011_P_NODE_69331_length_302_cov_1.812227_g68308_i0 | PRJNA724011 | 69331 | 302 | 1.812227 | 5.47292554 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 2.73e-4 | NR | KAF6027803.1 | 10212 | g68308 | i0 | 39.1 | 10.1523178807947 | 64 | 39 | 63.6 | 0 | 109 | 300 | 264 | 327 | KAF6027803.1 MYO6 [Bugula neritina] | diamond | 3066 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30936964 | 30936964 | PRJNA724011_P_NODE_35394_length_456_cov_2.086162_g34373_i0 | PRJNA724011 | 35394 | 456 | 2.086162 | 9.51289872 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 47.8 | 0.00555 | NR | XP_067945427.1 | 2589382 | g34373 | i0 | 38 | 0.519736842105263 | 79 | 49 | 52 | 0 | 455 | 219 | 454 | 532 | XP_067945427.1 dynein regulatory complex protein 10-like [Watersipora subatra] | diamond | 237 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 31727187 | 31727187 | PRJNA724011_P_NODE_83817_length_269_cov_2.750000_g82794_i0 | PRJNA724011 | 83817 | 269 | 2.75 | 7.3975 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 50.4 | 1.02e-4 | NR | KAF6032969.1 | 10212 | g82794 | i0 | 53.7 | 0.925650557620818 | 41 | 19 | 45.7 | 0 | 249 | 127 | 1646 | 1686 | KAF6032969.1 ABCA3 [Bugula neritina] | diamond | 249 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32486727 | 32486727 | PRJNA724011_P_NODE_11899_length_901_cov_17.487923_g11020_i0 | PRJNA724011 | 11899 | 901 | 17.487923 | 157.56618623 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 310 | 1.58e-102 | NR | XP_067934528.1 | 2589382 | g11020 | i0 | 60.2 | 3.99889012208657 | 244 | 97 | 81.2 | 0 | 850 | 119 | 5 | 248 | XP_067934528.1 proteasome subunit alpha type-7-like [Watersipora subatra] | diamond | 3603 | 310 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 32486741 | 32486741 | PRJNA724011_P_NODE_20759_length_640_cov_1.904762_g19747_i0 | PRJNA724011 | 20759 | 640 | 1.904762 | 12.1904768 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 69.3 | 1.13e-9 | NR | KAF6020376.1 | 10212 | g19747 | i0 | 34.5 | 0.5578125 | 119 | 61 | 47.8 | 2 | 352 | 47 | 298 | 416 | KAF6020376.1 hypothetical protein EB796_021348 [Bugula neritina] | diamond | 357 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32486786 | 32486786 | PRJNA724011_P_NODE_53719_length_351_cov_1.449640_g52696_i0 | PRJNA724011 | 53719 | 351 | 1.44964 | 5.0882364 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 94.7 | 7.43e-20 | NR | KAF6017968.1 | 10212 | g52696 | i0 | 48.2 | 2.88888888888889 | 112 | 51 | 93.2 | 4 | 24 | 350 | 4 | 111 | KAF6017968.1 METTL13 [Bugula neritina] | diamond | 1014 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32675712 | 32675712 | PRJNA724011_P_NODE_28960_length_517_cov_1.382883_g27943_i0 | PRJNA724011 | 28960 | 517 | 1.382883 | 7.14950511 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 94.7 | 5.2e-19 | NR | XP_067945473.1 | 2589382 | g27943 | i0 | 45.5 | 13.2127659574468 | 121 | 66 | 70.2 | 0 | 487 | 125 | 493 | 613 | XP_067945473.1 sodium/potassium/calcium exchanger 3-like [Watersipora subatra] | diamond | 6831 | 94.7 | 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);;