contig_metadata
23 rows where bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6995553 | 6995553 | PRJNA641707_P_NODE_66566_length_258_cov_9.004785_g63903_i0 | PRJNA641707 | 66566 | 258 | 9.004785 | 23.2323453 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 134 | 8.150000000000001e-27 | NTclustered | gi|2795709973|ref|XM_068078427.1| | 2589382 | g63903 | i0 | 84.058 | 1.52713178294574 | 138 | 22 | 53 | 0 | 1 | 138 | 197 | 60 | PREDICTED: Watersipora subatra proteasome subunit alpha type-7-like (LOC137391879), mRNA | blastn | 394 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 17735871 | 17735871 | PRJNA641707_P_NODE_49494_length_307_cov_3.740310_g46837_i0 | PRJNA641707 | 49494 | 307 | 3.74031 | 11.4827517 | Cheilostomatida | 10207 | Bryozoa | other_Eukaryota | 82.4 | 3.65e-11 | NTclustered | gi|2075441990|gb|MZ677540.1| | 2865452 | g46837 | i0 | 88.235 | 23.4104234527687 | 68 | 8 | 22 | 0 | 132 | 199 | 1646 | 1579 | Cellarinella rogickae voucher BLEED1713 large subunit ribosomal RNA gene, partial sequence | blastn | 7187 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Sclerodomidae | Cellarinella | Cellarinella rogickae | |
| 23564395 | 23564395 | PRJNA641707_P_NODE_144479_length_240_cov_7.905759_g141816_i0 | PRJNA641707 | 144479 | 240 | 7.905759 | 18.9738216 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 64.3 | 8.78e-10 | NR | KAF6024692.1 | 10212 | g141816 | i0 | 87.9 | 2.475 | 33 | 4 | 41.3 | 0 | 100 | 2 | 409 | 441 | KAF6024692.1 hypothetical protein EB796_017014 [Bugula neritina] | diamond | 594 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 26859995 | 26859995 | PRJNA641707_P_NODE_26121_length_425_cov_4.773936_g23531_i0 | PRJNA641707 | 26121 | 425 | 4.773936 | 20.289228 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 95.5 | 9.9e-20 | NR | KAF6030425.1 | 10212 | g23531 | i0 | 49.5 | 1.28470588235294 | 97 | 44 | 64.9 | 2 | 422 | 147 | 430 | 526 | KAF6030425.1 hypothetical protein EB796_011266 [Bugula neritina] | diamond | 546 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27143836 | 27143836 | PRJNA641707_P_NODE_117622_length_245_cov_13.341837_g114959_i0 | PRJNA641707 | 117622 | 245 | 13.341837 | 32.68750065 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 51.6 | 2.83e-5 | NR | XP_067937978.1 | 2589382 | g114959 | i0 | 71 | 0.379591836734694 | 31 | 9 | 38 | 0 | 239 | 147 | 469 | 499 | XP_067937978.1 serine/threonine-protein phosphatase 2A 65 kDa regulatory subunit A alpha isoform-like [Watersipora subatra] | diamond | 93 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27207350 | 27207350 | PRJNA641707_P_NODE_288902_length_167_cov_5.686441_g286239_i0 | PRJNA641707 | 288902 | 167 | 5.686441 | 9.49635647 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 65.1 | 3.89e-11 | NR | XP_067938117.1 | 2589382 | g286239 | i0 | 51.9 | 6.73652694610778 | 54 | 26 | 97 | 0 | 163 | 2 | 33 | 86 | XP_067938117.1 ATP synthase subunit d, mitochondrial-like [Watersipora subatra] | diamond | 1125 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27283243 | 27283243 | PRJNA641707_P_NODE_89423_length_246_cov_5.827411_g86760_i0 | PRJNA641707 | 89423 | 246 | 5.827411 | 14.33543106 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 50.8 | 5.77e-5 | NR | KAF6024688.1 | 10212 | g86760 | i0 | 36.7 | 1.92682926829268 | 79 | 48 | 95.1 | 2 | 234 | 1 | 3070 | 3147 | KAF6024688.1 unc-22 [Bugula neritina] | diamond | 474 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27554973 | 27554973 | PRJNA641707_P_NODE_84764_length_246_cov_6.791878_g82101_i0 | PRJNA641707 | 84764 | 246 | 6.791878 | 16.70801988 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 52.4 | 1.58e-5 | NR | XP_067937675.1 | 2589382 | g82101 | i0 | 43.1 | 0.792682926829268 | 65 | 33 | 74.4 | 1 | 48 | 230 | 1649 | 1713 | XP_067937675.1 helicase domino-like [Watersipora subatra] | diamond | 195 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27650029 | 27650029 | PRJNA641707_P_NODE_94144_length_246_cov_5.060914_g91481_i0 | PRJNA641707 | 94144 | 246 | 5.060914 | 12.44984844 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 65.1 | 5.11e-10 | NR | KAF6031347.1 | 10212 | g91481 | i0 | 41.8 | 4.70731707317073 | 79 | 34 | 96.3 | 1 | 239 | 3 | 331 | 397 | KAF6031347.1 HYDIN [Bugula neritina] | diamond | 1158 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28167433 | 28167433 | PRJNA641707_P_NODE_214365_length_194_cov_11.206897_g211702_i0 | PRJNA641707 | 214365 | 194 | 11.206897 | 21.74138018 | Cheilostomatida | 10207 | Bryozoa | other_Eukaryota | 45.1 | 0.00298 | NR | KAF6018826.1 | 10212 | g211702 | i0 | 66.7 | 1.02061855670103 | 33 | 11 | 51 | 0 | 2 | 100 | 414 | 446 | KAF6018826.1 hypothetical protein EB796_022875 [Bugula neritina] | diamond | 198 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28388317 | 28388317 | PRJNA641707_P_NODE_231146_length_189_cov_27.907143_g228483_i0 | PRJNA641707 | 231146 | 189 | 27.907143 | 52.74450027 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 41.6 | 0.0476 | NR | KAF6031597.1 | 10212 | g228483 | i0 | 56.7 | 1.36507936507937 | 30 | 13 | 47.6 | 0 | 187 | 98 | 2859 | 2888 | KAF6031597.1 hypothetical protein EB796_010094 [Bugula neritina] | diamond | 258 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29102357 | 29102357 | PRJNA641707_P_NODE_288468_length_167_cov_7.593220_g285805_i0 | PRJNA641707 | 288468 | 167 | 7.59322 | 12.6806774 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 41.2 | 0.0473 | NR | XP_067931785.1 | 2589382 | g285805 | i0 | 63.3 | 0.538922155688623 | 30 | 11 | 53.9 | 0 | 164 | 75 | 66 | 95 | XP_067931785.1 leucine-rich repeat-containing protein 47-like [Watersipora subatra] | diamond | 90 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29197028 | 29197028 | PRJNA641707_P_NODE_228529_length_190_cov_14.609929_g225866_i0 | PRJNA641707 | 228529 | 190 | 14.609929 | 27.7588651 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 56.2 | 3.09e-7 | NR | KAF6033145.1 | 10212 | g225866 | i0 | 43.8 | 1.01052631578947 | 64 | 29 | 97.9 | 2 | 188 | 3 | 221 | 279 | KAF6033145.1 SK [Bugula neritina] | diamond | 192 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29619356 | 29619356 | PRJNA641707_P_NODE_297990_length_165_cov_1.405172_g295327_i0 | PRJNA641707 | 297990 | 165 | 1.405172 | 2.3185338 | Opisthokonta | 33154 | Bryozoa | other_Eukaryota | 43.9 | 0.00499 | NR | KAF6021080.1 | 10212 | g295327 | i0 | 61.8 | 4.12727272727273 | 34 | 13 | 61.8 | 0 | 110 | 9 | 22 | 55 | KAF6021080.1 NUAK1 [Bugula neritina] | diamond | 681 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29670203 | 29670203 | PRJNA641707_P_NODE_311310_length_161_cov_4.267857_g308647_i0 | PRJNA641707 | 311310 | 161 | 4.267857 | 6.87124977 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 72.4 | 4.22e-13 | NR | KAF6019882.1 | 10212 | g308647 | i0 | 77.4 | 0.987577639751553 | 53 | 12 | 98.8 | 0 | 160 | 2 | 1176 | 1228 | KAF6019882.1 hypothetical protein EB796_021806 [Bugula neritina] | diamond | 159 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29765050 | 29765050 | PRJNA641707_P_NODE_177571_length_200_cov_7.715232_g174908_i0 | PRJNA641707 | 177571 | 200 | 7.715232 | 15.430464 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 53.5 | 3.29e-6 | NR | KAF6017827.1 | 10212 | g174908 | i0 | 49.1 | 3.825 | 57 | 27 | 82.5 | 1 | 169 | 5 | 125 | 181 | KAF6017827.1 hypothetical protein EB796_023871 [Bugula neritina] | diamond | 765 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30207180 | 30207180 | PRJNA641707_P_NODE_160592_length_213_cov_3.987805_g157929_i0 | PRJNA641707 | 160592 | 213 | 3.987805 | 8.49402465 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 60.5 | 1.41e-8 | NR | KAF6036685.1 | 10212 | g157929 | i0 | 70.3 | 1.56338028169014 | 37 | 11 | 52.1 | 0 | 101 | 211 | 997 | 1033 | KAF6036685.1 CHDC2 [Bugula neritina] | diamond | 333 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30207245 | 30207245 | PRJNA641707_P_NODE_26172_length_424_cov_14.661333_g23581_i0 | PRJNA641707 | 26172 | 424 | 14.661333 | 62.16405192 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 102 | 5.32e-22 | NR | XP_067932807.1 | 2589382 | g23581 | i0 | 50 | 1.91745283018868 | 88 | 43 | 62.3 | 1 | 315 | 52 | 748 | 834 | XP_067932807.1 uncharacterized protein [Watersipora subatra] | diamond | 813 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 31471737 | 31471737 | PRJNA641707_P_NODE_178436_length_200_cov_6.662252_g175773_i0 | PRJNA641707 | 178436 | 200 | 6.662252 | 13.324504 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 94 | 4.01e-22 | NR | KAF6040296.1 | 10212 | g175773 | i0 | 63.3 | 0.9 | 60 | 22 | 90 | 0 | 192 | 13 | 128 | 187 | KAF6040296.1 mlc-4 [Bugula neritina] | diamond | 180 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31768619 | 31768619 | PRJNA641707_P_NODE_293277_length_166_cov_3.581197_g290614_i0 | PRJNA641707 | 293277 | 166 | 3.581197 | 5.94478702 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 91.3 | 2.81e-20 | NR | KAF6022759.1 | 10212 | g290614 | i0 | 73.1 | 1.87951807228916 | 52 | 14 | 94 | 0 | 160 | 5 | 159 | 210 | KAF6022759.1 Nhe3 [Bugula neritina] | diamond | 312 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31831697 | 31831697 | PRJNA641707_P_NODE_207957_length_196_cov_4.129252_g205294_i0 | PRJNA641707 | 207957 | 196 | 4.129252 | 8.09333392 | Cheilostomatida | 10207 | Bryozoa | other_Eukaryota | 61.6 | 4.5e-9 | NR | KAF6024561.1 | 10212 | g205294 | i0 | 60.3 | 3.55102040816327 | 58 | 23 | 88.8 | 0 | 7 | 180 | 3131 | 3188 | KAF6024561.1 DYNC1H1 [Bugula neritina] | diamond | 696 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32167828 | 32167828 | PRJNA641707_P_NODE_310658_length_161_cov_5.928571_g307995_i0 | PRJNA641707 | 310658 | 161 | 5.928571 | 9.54499931 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 47 | 3.91e-4 | NR | XP_067945050.1 | 2589382 | g307995 | i0 | 40.4 | 0.875776397515528 | 47 | 28 | 87.6 | 0 | 159 | 19 | 549 | 595 | XP_067945050.1 transient receptor potential cation channel subfamily M member-like 2 [Watersipora subatra] | diamond | 141 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 32704707 | 32704707 | PRJNA641707_P_NODE_320000_length_158_cov_3.000000_g317337_i0 | PRJNA641707 | 320000 | 158 | 3 | 4.74 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 48.5 | 1.07e-4 | NR | XP_067948520.1 | 2589382 | g317337 | i0 | 41.2 | 0.968354430379747 | 51 | 30 | 96.8 | 0 | 6 | 158 | 879 | 929 | XP_067948520.1 dynein axonemal heavy chain 2-like [Watersipora subatra] | diamond | 153 | 48.5 | 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);;