contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5648357 | 5648357 | PRJNA560932_P_NODE_19825_length_395_cov_3.347826_g19469_i0 | PRJNA560932 | 19825 | 395 | 3.347826 | 13.2239127 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 179 | 3.709999999999999e-55 | NR | KAF6029644.1 | 10212 | g19469 | i0 | 75.2 | 10.3443037974684 | 113 | 28 | 85.8 | 0 | 339 | 1 | 19 | 131 | KAF6029644.1 RpS15Aa [Bugula neritina] | diamond | 4086 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 8197852 | 8197852 | PRJNA560932_P_NODE_9907_length_553_cov_2.258333_g9553_i0 | PRJNA560932 | 9907 | 553 | 2.258333 | 12.48858149 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 310 | 4.729999999999998e-103 | NR | KAF6024418.1 | 10212 | g9553 | i0 | 85.1 | 38.3869801084991 | 181 | 27 | 98.2 | 0 | 3 | 545 | 166 | 346 | KAF6024418.1 PSMC1 [Bugula neritina] | diamond | 21228 | 313 | 0.990415335463259 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 12023913 | 12023913 | PRJNA560932_P_NODE_57230_length_248_cov_0.880000_g56874_i0 | PRJNA560932 | 57230 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 117 | 2.83e-29 | NR | KAF6023690.1 | 10212 | g56874 | i0 | 63.4 | 2.96370967741935 | 82 | 30 | 99.2 | 0 | 247 | 2 | 202 | 283 | KAF6023690.1 hypothetical protein EB796_018006 [Bugula neritina] | diamond | 735 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 20946736 | 20946736 | PRJNA560932_P_NODE_25617_length_352_cov_2.089606_g25261_i0 | PRJNA560932 | 25617 | 352 | 2.089606 | 7.35541312 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 160 | 7.339999999999999e-43 | NR | XP_067937000.1 | 2589382 | g25261 | i0 | 71.6 | 6 | 116 | 30 | 98 | 3 | 348 | 4 | 147 | 260 | XP_067937000.1 uncharacterized protein [Watersipora subatra] | diamond | 2112 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 25356921 | 25356921 | PRJNA560932_P_NODE_8620_length_591_cov_5.893822_g8267_i0 | PRJNA560932 | 8620 | 591 | 5.893822 | 34.83248802 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 209 | 4.51e-66 | NR | KAF6029644.1 | 10212 | g8267 | i0 | 74.8 | 29.9695431472081 | 131 | 33 | 66.5 | 0 | 55 | 447 | 19 | 149 | KAF6029644.1 RpS15Aa [Bugula neritina] | diamond | 17712 | 211 | 0.990521327014218 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 26825997 | 26825997 | PRJNA560932_P_NODE_14381_length_462_cov_1.179949_g14026_i0 | PRJNA560932 | 14381 | 462 | 1.179949 | 5.45136438 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 53.5 | 6.22e-5 | NR | KAF6025425.1 | 10212 | g14026 | i0 | 26.8 | 5.02597402597403 | 123 | 79 | 77.9 | 4 | 3 | 362 | 636 | 750 | KAF6025425.1 ABCG4 [Bugula neritina] | diamond | 2322 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27774174 | 27774174 | PRJNA560932_P_NODE_49704_length_258_cov_0.935135_g49348_i0 | PRJNA560932 | 49704 | 258 | 0.935135 | 2.4126483 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 42.7 | 0.0458 | NR | KAF6034616.1 | 10212 | g49348 | i0 | 44.9 | 0.569767441860465 | 49 | 25 | 55.8 | 2 | 20 | 163 | 664 | 711 | KAF6034616.1 hypothetical protein EB796_007071 [Bugula neritina] | diamond | 147 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28703706 | 28703706 | PRJNA560932_P_NODE_23367_length_367_cov_1.295918_g23011_i0 | PRJNA560932 | 23367 | 367 | 1.295918 | 4.75601906 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 106 | 1.58e-26 | NR | KAF6022347.1 | 10212 | g23011 | i0 | 44.4 | 3.61307901907357 | 108 | 59 | 87.5 | 1 | 321 | 1 | 16 | 123 | KAF6022347.1 hypothetical protein EB796_019335 [Bugula neritina] | diamond | 1326 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28735190 | 28735190 | PRJNA560932_P_NODE_3347_length_921_cov_3.200472_g3074_i0 | PRJNA560932 | 3347 | 921 | 3.200472 | 29.47634712 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 84.7 | 1.4e-15 | NR | KAF6025782.1 | 10212 | g3074 | i0 | 30.8 | 2.20195439739414 | 169 | 108 | 54.1 | 3 | 861 | 364 | 9 | 171 | KAF6025782.1 hypothetical protein EB796_016033 [Bugula neritina] | diamond | 2028 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29271728 | 29271728 | PRJNA560932_P_NODE_7689_length_625_cov_1.682971_g7337_i0 | PRJNA560932 | 7689 | 625 | 1.682971 | 10.51856875 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 0.0105 | NR | KAF6027431.1 | 10212 | g7337 | i0 | 44.2 | 0.6096 | 43 | 24 | 20.6 | 0 | 575 | 447 | 134 | 176 | KAF6027431.1 WDR45B [Bugula neritina] | diamond | 381 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29398220 | 29398220 | PRJNA560932_P_NODE_44309_length_275_cov_0.871287_g43953_i0 | PRJNA560932 | 44309 | 275 | 0.871287 | 2.39603925 | Cheilostomatida | 10207 | Bryozoa | other_Eukaryota | 105 | 6.52e-24 | NR | KAF6035000.1 | 10212 | g43953 | i0 | 62.3 | 4.2 | 77 | 29 | 84 | 0 | 26 | 256 | 380 | 456 | KAF6035000.1 hypothetical protein EB796_006688 [Bugula neritina] | diamond | 1155 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29618850 | 29618850 | PRJNA560932_P_NODE_12570_length_493_cov_0.983333_g12216_i0 | PRJNA560932 | 12570 | 493 | 0.983333 | 4.84783169 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.58e-4 | NR | KAF6018602.1 | 10212 | g12216 | i0 | 52.9 | 0.973630831643002 | 34 | 16 | 20.7 | 0 | 2 | 103 | 249 | 282 | KAF6018602.1 hypothetical protein EB796_023091 [Bugula neritina] | diamond | 480 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 29699633 | 29699633 | PRJNA560932_P_NODE_5970_length_704_cov_1.342314_g5630_i0 | PRJNA560932 | 5970 | 704 | 1.342314 | 9.44989056 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 57.4 | 1.73e-5 | NR | KAF6033080.1 | 10212 | g5630 | i0 | 33 | 1.14630681818182 | 97 | 62 | 41.3 | 1 | 410 | 700 | 76 | 169 | KAF6033080.1 hypothetical protein EB796_008661 [Bugula neritina] | diamond | 807 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30047244 | 30047244 | PRJNA560932_P_NODE_36951_length_299_cov_1.300885_g36595_i0 | PRJNA560932 | 36951 | 299 | 1.300885 | 3.88964615 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 61.2 | 2.34e-8 | NR | KAF6018602.1 | 10212 | g36595 | i0 | 51.1 | 0.903010033444816 | 45 | 22 | 45.2 | 0 | 298 | 164 | 247 | 291 | KAF6018602.1 hypothetical protein EB796_023091 [Bugula neritina] | diamond | 270 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30205086 | 30205086 | PRJNA560932_P_NODE_10912_length_527_cov_1.693833_g10558_i0 | PRJNA560932 | 10912 | 527 | 1.693833 | 8.92649991 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 168 | 5.3000000000000003e-45 | NR | KAF6029261.1 | 10212 | g10558 | i0 | 51.2 | 8.4819734345351 | 166 | 81 | 94.5 | 0 | 499 | 2 | 458 | 623 | KAF6029261.1 hypothetical protein EB796_012444 [Bugula neritina] | diamond | 4470 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30552864 | 30552864 | PRJNA560932_P_NODE_66753_length_241_cov_0.916667_g66397_i0 | PRJNA560932 | 66753 | 241 | 0.916667 | 2.20916747 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 57 | 3.36e-7 | NR | KAF6038161.1 | 10212 | g66397 | i0 | 40.8 | 1.80497925311203 | 71 | 42 | 88.4 | 0 | 231 | 19 | 147 | 217 | KAF6038161.1 hypothetical protein EB796_003536 [Bugula neritina] | diamond | 435 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30868792 | 30868792 | PRJNA560932_P_NODE_18194_length_412_cov_2.389381_g17838_i0 | PRJNA560932 | 18194 | 412 | 2.389381 | 9.84424972 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 62.4 | 1.85e-8 | NR | KAF6024192.1 | 10212 | g17838 | i0 | 41.5 | 1.36893203883495 | 94 | 40 | 63.3 | 3 | 148 | 408 | 37 | 122 | KAF6024192.1 APX2 [Bugula neritina] | diamond | 564 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31262119 | 31262119 | PRJNA560932_P_NODE_46235_length_269_cov_1.107143_g45879_i0 | PRJNA560932 | 46235 | 269 | 1.107143 | 2.97821467 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 46.2 | 0.00291 | NR | KAF6024355.1 | 10212 | g45879 | i0 | 38.4 | 1.94052044609665 | 86 | 40 | 95.9 | 4 | 260 | 3 | 212 | 284 | KAF6024355.1 hypothetical protein EB796_017356 [Bugula neritina] | diamond | 522 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32796903 | 32796903 | PRJNA560932_P_NODE_37580_length_296_cov_3.591928_g37224_i0 | PRJNA560932 | 37580 | 296 | 3.591928 | 10.63210688 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 78.6 | 1.34e-15 | NR | XP_067936593.1 | 2589382 | g37224 | i0 | 35.1 | 9.93243243243243 | 97 | 63 | 98.3 | 0 | 4 | 294 | 69 | 165 | XP_067936593.1 neuronal calcium sensor 2-like [Watersipora subatra] | diamond | 2940 | 78.6 | 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);;