contig_metadata
15 rows where bioproject = "PRJNA1010780", tax_clade = "Sar" and tax_phylum = "Foraminifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26654515 | 26654515 | PRJNA1010780_S_NODE_62261_length_152_cov_1.145299_g60972_i0 | PRJNA1010780 | 62261 | 152 | 1.145299 | 1.74085448 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0202 | NR | ETN99392.1 | 46433 | g60972 | i0 | 53.8 | 0.769736842105263 | 39 | 16 | 77 | 1 | 149 | 33 | 102 | 138 | ETN99392.1 hypothetical protein RFI_38089, partial [Reticulomyxa filosa] | diamond | 117 | 42 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28132664 | 28132664 | PRJNA1010780_S_NODE_53785_length_166_cov_2.503817_g52496_i0 | PRJNA1010780 | 53785 | 166 | 2.503817 | 4.15633622 | root | 1 | Root_unresolved | Root_unresolved | 59.3 | 1.47e-8 | NR | ETO00348.1 | 46433 | g52496 | i0 | 50 | 5.09638554216868 | 48 | 24 | 86.7 | 0 | 166 | 23 | 109 | 156 | ETO00348.1 TLDc domain-containing protein [Reticulomyxa filosa] | diamond | 846 | 59.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28961307 | 28961307 | PRJNA1010780_S_NODE_61088_length_153_cov_2.127119_g59799_i0 | PRJNA1010780 | 61088 | 153 | 2.127119 | 3.25449207 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 6.77e-7 | NR | ETO09591.1 | 46433 | g59799 | i0 | 46 | 5.80392156862745 | 50 | 27 | 98 | 0 | 4 | 153 | 390 | 439 | ETO09591.1 hypothetical protein RFI_27788, partial [Reticulomyxa filosa] | diamond | 888 | 54.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29055823 | 29055823 | PRJNA1010780_S_NODE_25108_length_316_cov_2.032028_g23819_i0 | PRJNA1010780 | 25108 | 316 | 2.032028 | 6.42120848 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 6.12e-6 | NR | ETO00348.1 | 46433 | g23819 | i0 | 43.4 | 6.39873417721519 | 53 | 30 | 50.3 | 0 | 159 | 1 | 97 | 149 | ETO00348.1 TLDc domain-containing protein [Reticulomyxa filosa] | diamond | 2022 | 54.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29111451 | 29111451 | PRJNA1010780_S_NODE_34868_length_231_cov_2.326531_g33579_i0 | PRJNA1010780 | 34868 | 231 | 2.326531 | 5.37428661 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 5.38e-18 | NR | AAX19664.1 | 45993 | g33579 | i0 | 59.3 | 1.53246753246753 | 59 | 24 | 76.6 | 0 | 178 | 2 | 217 | 275 | AAX19664.1 actin deviating protein, partial [Haynesina germanica] | diamond | 354 | 87 | 0.991954022988506 | Eukaryota | Sar | Foraminifera | Rotaliida | Nonionidae | Haynesina | Haynesina germanica | |||
| 29143144 | 29143144 | PRJNA1010780_S_NODE_51849_length_171_cov_0.941176_g50560_i0 | PRJNA1010780 | 51849 | 171 | 0.941176 | 1.60941096 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.05e-12 | NR | ETO14800.1 | 46433 | g50560 | i0 | 49.1 | 4.87719298245614 | 57 | 29 | 100 | 0 | 171 | 1 | 35 | 91 | ETO14800.1 hypothetical protein RFI_22571 [Reticulomyxa filosa] | diamond | 834 | 69.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29497776 | 29497776 | PRJNA1010780_S_NODE_52030_length_170_cov_1.881481_g50741_i0 | PRJNA1010780 | 52030 | 170 | 1.881481 | 3.1985177 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0165 | NR | ETO23243.1 | 46433 | g50741 | i0 | 39 | 1.04117647058824 | 59 | 32 | 97.1 | 1 | 2 | 166 | 148 | 206 | ETO23243.1 hypothetical protein RFI_13942, partial [Reticulomyxa filosa] | diamond | 177 | 42.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29647668 | 29647668 | PRJNA1010780_S_NODE_15790_length_515_cov_3.585417_g14559_i0 | PRJNA1010780 | 15790 | 515 | 3.585417 | 18.46489755 | root | 1 | Root_unresolved | Root_unresolved | 115 | 8.149999999999998e-30 | NR | ETO14761.1 | 46433 | g14559 | i0 | 49.6 | 1.3631067961165 | 121 | 55 | 68.2 | 3 | 447 | 97 | 2 | 120 | ETO14761.1 hypothetical protein RFI_22607 [Reticulomyxa filosa] | diamond | 702 | 115 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29781934 | 29781934 | PRJNA1010780_S_NODE_48691_length_178_cov_2.405594_g47402_i0 | PRJNA1010780 | 48691 | 178 | 2.405594 | 4.28195732 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 2.53e-4 | NR | ETO25064.1 | 46433 | g47402 | i0 | 52.5 | 1.17977528089888 | 40 | 19 | 67.4 | 0 | 21 | 140 | 80 | 119 | ETO25064.1 hypothetical protein RFI_12080, partial [Reticulomyxa filosa] | diamond | 210 | 47.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30761342 | 30761342 | PRJNA1010780_S_NODE_12694_length_632_cov_4.522613_g11588_i0 | PRJNA1010780 | 12694 | 632 | 4.522613 | 28.58291416 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 1.14e-4 | NR | ETO35000.1 | 46433 | g11588 | i0 | 37.3 | 1.31012658227848 | 59 | 37 | 28 | 0 | 632 | 456 | 40 | 98 | ETO35000.1 hypothetical protein RFI_02075 [Reticulomyxa filosa] | diamond | 828 | 53.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31101139 | 31101139 | PRJNA1010780_S_NODE_19935_length_404_cov_2.216802_g18646_i0 | PRJNA1010780 | 19935 | 404 | 2.216802 | 8.95588008 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 3.82e-10 | NR | ETO29533.1 | 46433 | g18646 | i0 | 28 | 1.96039603960396 | 132 | 90 | 94.3 | 1 | 404 | 24 | 73 | 204 | ETO29533.1 hypothetical protein RFI_07589 [Reticulomyxa filosa] | diamond | 792 | 66.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31330147 | 31330147 | PRJNA1010780_S_NODE_49636_length_176_cov_1.546099_g48347_i0 | PRJNA1010780 | 49636 | 176 | 1.546099 | 2.72113424 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 1.14e-17 | NR | ETO21588.1 | 46433 | g48347 | i0 | 70.7 | 2.94886363636364 | 58 | 15 | 98.9 | 1 | 176 | 3 | 355 | 410 | ETO21588.1 prolyl-tRNA synthetase, partial [Reticulomyxa filosa] | diamond | 519 | 85.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32184337 | 32184337 | PRJNA1010780_S_NODE_19238_length_419_cov_3.494792_g17957_i0 | PRJNA1010780 | 19238 | 419 | 3.494792 | 14.64317848 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 5.49e-12 | NR | ETN99392.1 | 46433 | g17957 | i0 | 53.1 | 0.458233890214797 | 64 | 29 | 45.8 | 1 | 282 | 91 | 391 | 453 | ETN99392.1 hypothetical protein RFI_38089, partial [Reticulomyxa filosa] | diamond | 192 | 73.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32405801 | 32405801 | PRJNA1010780_S_NODE_10159_length_761_cov_5.271350_g9204_i0 | PRJNA1010780 | 10159 | 761 | 5.27135 | 40.1149735 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 4.73e-49 | NR | ETN99392.1 | 46433 | g9204 | i0 | 42 | 0.965834428383706 | 245 | 135 | 95.8 | 4 | 2 | 730 | 102 | 341 | ETN99392.1 hypothetical protein RFI_38089, partial [Reticulomyxa filosa] | diamond | 735 | 178 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32847307 | 32847307 | PRJNA1010780_S_NODE_32920_length_243_cov_2.620192_g31631_i0 | PRJNA1010780 | 32920 | 243 | 2.620192 | 6.36706656 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.11e-16 | NR | ETO17306.1 | 46433 | g31631 | i0 | 50 | 1.97530864197531 | 80 | 40 | 98.8 | 0 | 242 | 3 | 355 | 434 | ETO17306.1 hypothetical protein RFI_20020 [Reticulomyxa filosa] | diamond | 480 | 83.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa |
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);;