contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24353137 | 24353137 | PRJEB64798_P_NODE_162940_length_182_cov_2.571429_g161174_i0 | PRJEB64798 | 162940 | 182 | 2.571429 | 4.68000078 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 134 | 1.33e-34 | NR | XP_067951479.1 | 2589382 | g161174 | i0 | 96.6 | 3.82417582417582 | 58 | 2 | 95.6 | 0 | 7 | 180 | 1609 | 1666 | XP_067951479.1 uncharacterized protein [Watersipora subatra] | diamond | 696 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 26653561 | 26653561 | PRJEB64798_P_NODE_158661_length_184_cov_2.948148_g156895_i0 | PRJEB64798 | 158661 | 184 | 2.948148 | 5.42459232 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 66.6 | 6.42e-11 | NR | XP_067947675.1 | 2589382 | g156895 | i0 | 60.7 | 1.875 | 56 | 21 | 89.7 | 1 | 165 | 1 | 671 | 726 | XP_067947675.1 carboxypeptidase A2-like [Watersipora subatra] | diamond | 345 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27350171 | 27350171 | PRJEB64798_P_NODE_45583_length_291_cov_4.545455_g43818_i0 | PRJEB64798 | 45583 | 291 | 4.545455 | 13.22727405 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 72.4 | 1.8e-13 | NR | KAF6033577.1 | 10212 | g43818 | i0 | 53.7 | 0.556701030927835 | 54 | 25 | 55.7 | 0 | 286 | 125 | 103 | 156 | KAF6033577.1 hypothetical protein EB796_008116 [Bugula neritina] | diamond | 162 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 27665827 | 27665827 | PRJEB64798_P_NODE_221864_length_162_cov_0.920354_g220098_i0 | PRJEB64798 | 221864 | 162 | 0.920354 | 1.49097348 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 81.3 | 2.53e-16 | NR | XP_067934354.1 | 2589382 | g220098 | i0 | 73.1 | 0.962962962962963 | 52 | 14 | 96.3 | 0 | 156 | 1 | 183 | 234 | XP_067934354.1 lysosomal aspartic protease-like isoform X2 [Watersipora subatra] | diamond | 156 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27981429 | 27981429 | PRJEB64798_P_NODE_219925_length_162_cov_2.805310_g218159_i0 | PRJEB64798 | 219925 | 162 | 2.80531 | 4.5446022 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 68.2 | 1.37e-11 | NR | XP_067928374.1 | 2589382 | g218159 | i0 | 64.6 | 1.77777777777778 | 48 | 17 | 88.9 | 0 | 144 | 1 | 328 | 375 | XP_067928374.1 WASH complex subunit 5-like [Watersipora subatra] | diamond | 288 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28195283 | 28195283 | PRJEB64798_P_NODE_163206_length_182_cov_1.842105_g161440_i0 | PRJEB64798 | 163206 | 182 | 1.842105 | 3.3526311 | root | 1 | Root_unresolved | Root_unresolved | 85.1 | 2.2e-18 | NR | KAF6038783.1 | 10212 | g161440 | i0 | 72.4 | 4.78021978021978 | 58 | 16 | 95.6 | 0 | 7 | 180 | 146 | 203 | KAF6038783.1 CTH [Bugula neritina] | diamond | 870 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28644610 | 28644610 | PRJEB64798_P_NODE_246267_length_153_cov_3.480769_g244501_i0 | PRJEB64798 | 246267 | 153 | 3.480769 | 5.32557657 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 98.6 | 1.09e-24 | NR | XP_067931213.1 | 2589382 | g244501 | i0 | 91.8 | 334.352941176471 | 49 | 4 | 96.1 | 0 | 6 | 152 | 57 | 105 | XP_067931213.1 ubiquitin-conjugating enzyme E2 2-like [Watersipora subatra] | diamond | 51156 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 28676093 | 28676093 | PRJEB64798_P_NODE_179227_length_174_cov_19.384000_g177461_i0 | PRJEB64798 | 179227 | 174 | 19.384 | 33.72816 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 58.2 | 5.3e-8 | NR | XP_067945460.1 | 2589382 | g177461 | i0 | 50 | 0.96551724137931 | 56 | 27 | 96.6 | 1 | 173 | 6 | 861 | 915 | XP_067945460.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like [Watersipora subatra] | diamond | 168 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29016724 | 29016724 | PRJEB64798_P_NODE_150968_length_188_cov_2.258993_g149202_i0 | PRJEB64798 | 150968 | 188 | 2.258993 | 4.24690684 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 84.3 | 3.92e-17 | NR | KAF6022888.1 | 10212 | g149202 | i0 | 61.3 | 2.92021276595745 | 62 | 24 | 98.9 | 0 | 188 | 3 | 330 | 391 | KAF6022888.1 MYRF [Bugula neritina] | diamond | 549 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 30096717 | 30096717 | PRJEB64798_P_NODE_100052_length_212_cov_3.085890_g98286_i0 | PRJEB64798 | 100052 | 212 | 3.08589 | 6.5420868 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 66.6 | 9.31e-11 | NR | KAF6017116.1 | 10212 | g98286 | i0 | 68 | 0.707547169811321 | 50 | 15 | 70.8 | 1 | 150 | 1 | 65 | 113 | KAF6017116.1 CCT5 [Bugula neritina] | diamond | 150 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31835220 | 31835220 | PRJEB64798_P_NODE_204897_length_166_cov_2.162393_g203131_i0 | PRJEB64798 | 204897 | 166 | 2.162393 | 3.58957238 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 41.2 | 0.0482 | NR | XP_067934548.1 | 2589382 | g203131 | i0 | 45.1 | 0.921686746987952 | 51 | 28 | 92.2 | 0 | 157 | 5 | 2697 | 2747 | XP_067934548.1 dynein axonemal heavy chain 3-like [Watersipora subatra] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 32310291 | 32310291 | PRJEB64798_P_NODE_181879_length_173_cov_9.588710_g180113_i0 | PRJEB64798 | 181879 | 173 | 9.58871 | 16.5884683 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 78.6 | 3.32e-15 | NR | KAF6024956.1 | 10212 | g180113 | i0 | 60.7 | 1.99421965317919 | 56 | 22 | 97.1 | 0 | 6 | 173 | 364 | 419 | KAF6024956.1 hypothetical protein EB796_016729 [Bugula neritina] | diamond | 345 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 32626011 | 32626011 | PRJEB64798_P_NODE_236020_length_156_cov_9.299065_g234254_i0 | PRJEB64798 | 236020 | 156 | 9.299065 | 14.5065414 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 47 | 3.73e-4 | NR | XP_067931210.1 | 2589382 | g234254 | i0 | 38.3 | 0.903846153846154 | 47 | 29 | 90.4 | 0 | 7 | 147 | 241 | 287 | XP_067931210.1 E3 ubiquitin-protein ligase TRIM56-like isoform X2 [Watersipora subatra] | diamond | 141 | 47 | 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);;