contig_metadata
16 rows where bioproject = "PRJNA690124" and tax_phylum = "Brachiopoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1945124 | 1945124 | PRJNA690124_P_NODE_24942_length_329_cov_1.039062_g24576_i0 | PRJNA690124 | 24942 | 329 | 1.039062 | 3.41851398 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 187 | 3.94e-58 | NR | XP_013399282.1 | 7574 | g24576 | i0 | 78 | 8.91793313069909 | 109 | 24 | 99.4 | 0 | 2 | 328 | 33 | 141 | XP_013399282.1 60S ribosomal protein L13a isoform X1 [Lingula anatina] | diamond | 2934 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 7047539 | 7047539 | PRJNA690124_P_NODE_18266_length_379_cov_1.019608_g17900_i0 | PRJNA690124 | 18266 | 379 | 1.019608 | 3.86431432 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 192 | 2.1599999999999997e-56 | NR | XP_013381162.1 | 7574 | g17900 | i0 | 73.8 | 2.98416886543536 | 126 | 33 | 99.7 | 0 | 378 | 1 | 344 | 469 | XP_013381162.1 serine hydroxymethyltransferase, cytosolic-like [Lingula anatina] | diamond | 1131 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 9598037 | 9598037 | PRJNA690124_P_NODE_44688_length_252_cov_0.871508_g44322_i0 | PRJNA690124 | 44688 | 252 | 0.871508 | 2.19620016 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 127 | 9.459999999999999e-32 | NR | XP_013416027.1 | 7574 | g44322 | i0 | 63.4 | 165.952380952381 | 82 | 30 | 97.6 | 0 | 247 | 2 | 75 | 156 | XP_013416027.1 pre-mRNA 3' end processing protein WDR33 [Lingula anatina] | diamond | 41820 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 13422738 | 13422738 | PRJNA690124_P_NODE_13371_length_440_cov_1.416894_g13006_i0 | PRJNA690124 | 13371 | 440 | 1.416894 | 6.2343336 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 231 | 5.85e-75 | NR | XP_013399327.1 | 7574 | g13006 | i0 | 81.5 | 5.93181818181818 | 146 | 27 | 99.5 | 0 | 440 | 3 | 9 | 154 | XP_013399327.1 40S ribosomal protein S7 [Lingula anatina] | diamond | 2610 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 21071570 | 21071570 | PRJNA690124_P_NODE_27817_length_313_cov_1.083333_g27451_i0 | PRJNA690124 | 27817 | 313 | 1.083333 | 3.39083229 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 177 | 1.77e-53 | NR | XP_013395677.1 | 7574 | g27451 | i0 | 82.7 | 5.98083067092652 | 104 | 18 | 99.7 | 0 | 312 | 1 | 133 | 236 | XP_013395677.1 60S ribosomal protein L7a [Lingula anatina] | diamond | 1872 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 26987323 | 26987323 | PRJNA690124_P_NODE_29122_length_306_cov_1.759657_g28756_i0 | PRJNA690124 | 29122 | 306 | 1.759657 | 5.38455042 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 150 | 1.86e-40 | NR | XP_013385149.1 | 7574 | g28756 | i0 | 70.3 | 1.98039215686275 | 101 | 30 | 99 | 0 | 305 | 3 | 128 | 228 | XP_013385149.1 beta-hexosaminidase subunit alpha-like isoform X3 [Lingula anatina] | diamond | 606 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27820513 | 27820513 | PRJNA690124_P_NODE_29224_length_306_cov_1.150215_g28858_i0 | PRJNA690124 | 29224 | 306 | 1.150215 | 3.5196579 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 81.6 | 4.02e-17 | NR | XP_013417324.1 | 7574 | g28858 | i0 | 72.1 | 3.56862745098039 | 61 | 17 | 59.8 | 0 | 124 | 306 | 4 | 64 | XP_013417324.1 endothelial differentiation-related factor 1 [Lingula anatina] | diamond | 1092 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27946661 | 27946661 | PRJNA690124_P_NODE_32805_length_290_cov_0.894009_g32439_i0 | PRJNA690124 | 32805 | 290 | 0.894009 | 2.5926261 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 120 | 2.09e-29 | NR | XP_013409543.1 | 7574 | g32439 | i0 | 62.8 | 9.65172413793104 | 94 | 35 | 97.2 | 0 | 7 | 288 | 49 | 142 | XP_013409543.1 UDP-N-acetylhexosamine pyrophosphorylase isoform X6 [Lingula anatina] | diamond | 2799 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27978209 | 27978209 | PRJNA690124_P_NODE_43485_length_253_cov_0.866667_g43119_i0 | PRJNA690124 | 43485 | 253 | 0.866667 | 2.19266751 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 87 | 2.76e-19 | NR | XP_013397869.1 | 7574 | g43119 | i0 | 47.7 | 4.06719367588933 | 86 | 43 | 99.6 | 1 | 253 | 2 | 80 | 165 | XP_013397869.1 placenta-specific gene 8 protein [Lingula anatina] | diamond | 1029 | 87.8 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28282305 | 28282305 | PRJNA690124_P_NODE_54826_length_243_cov_0.917647_g54460_i0 | PRJNA690124 | 54826 | 243 | 0.917647 | 2.22988221 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 78.2 | 1.25e-14 | NR | XP_023933258.1 | 7574 | g54460 | i0 | 47.5 | 3.95061728395062 | 80 | 41 | 98.8 | 1 | 2 | 241 | 5063 | 5141 | XP_023933258.1 titin isoform X1 [Lingula anatina] | diamond | 960 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28314154 | 28314154 | PRJNA690124_P_NODE_41566_length_257_cov_2.119565_g41200_i0 | PRJNA690124 | 41566 | 257 | 2.119565 | 5.44728205 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 84 | 1.41e-16 | NR | XP_013389170.1 | 7574 | g41200 | i0 | 49.3 | 1.75097276264591 | 75 | 37 | 87.5 | 1 | 6 | 230 | 1067 | 1140 | XP_013389170.1 von Willebrand factor D and EGF domain-containing protein [Lingula anatina] | diamond | 450 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28850607 | 28850607 | PRJNA690124_P_NODE_16868_length_394_cov_1.233645_g16502_i0 | PRJNA690124 | 16868 | 394 | 1.233645 | 4.8605613 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 216 | 1.3799999999999999e-67 | NR | XP_013399374.1 | 7574 | g16502 | i0 | 75.9 | 2.01776649746193 | 133 | 29 | 99 | 1 | 391 | 2 | 146 | 278 | XP_013399374.1 regucalcin [Lingula anatina] | diamond | 795 | 216 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 30473111 | 30473111 | PRJNA690124_P_NODE_31193_length_296_cov_2.098655_g30827_i0 | PRJNA690124 | 31193 | 296 | 2.098655 | 6.2120188 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.5 | 2.05e-6 | NR | XP_013396966.1 | 7574 | g30827 | i0 | 39.7 | 3.47635135135135 | 73 | 44 | 74 | 0 | 287 | 69 | 202 | 274 | XP_013396966.1 60S acidic ribosomal protein P0-like [Lingula anatina] | diamond | 1029 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 30840715 | 30840715 | PRJNA690124_P_NODE_45874_length_251_cov_0.876404_g45508_i0 | PRJNA690124 | 45874 | 251 | 0.876404 | 2.19977404 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 84.3 | 9.56e-17 | NR | XP_023932230.1 | 7574 | g45508 | i0 | 51.9 | 0.920318725099602 | 77 | 37 | 92 | 0 | 245 | 15 | 762 | 838 | XP_023932230.1 poly [ADP-ribose] polymerase 14-like isoform X1 [Lingula anatina] | diamond | 231 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32465217 | 32465217 | PRJNA690124_P_NODE_17859_length_383_cov_1.629032_g17493_i0 | PRJNA690124 | 17859 | 383 | 1.629032 | 6.23919256 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 70.1 | 2.08e-11 | NR | XP_013409579.1 | 7574 | g17493 | i0 | 50.9 | 0.947780678851175 | 55 | 27 | 43.1 | 0 | 381 | 217 | 128 | 182 | XP_013409579.1 selenoprotein Pb-like [Lingula anatina] | diamond | 363 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32528561 | 32528561 | PRJNA690124_P_NODE_25059_length_328_cov_1.219608_g24693_i0 | PRJNA690124 | 25059 | 328 | 1.219608 | 4.00031424 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 166 | 1.61e-46 | NR | XP_013394465.1 | 7574 | g24693 | i0 | 68.5 | 1.97560975609756 | 108 | 34 | 98.8 | 0 | 3 | 326 | 374 | 481 | XP_013394465.1 lysosomal Pro-X carboxypeptidase-like [Lingula anatina] | diamond | 648 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina |
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);;