contig_metadata
18 rows where bioproject = "PRJNA520845", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19614261 | 19614261 | PRJNA520845_P_NODE_139296_length_317_cov_0.913934_g137797_i0 | PRJNA520845 | 139296 | 317 | 0.913934 | 2.89717078 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 3.12e-49 | NR | ETN98485.1 | 46433 | g137797 | i0 | 77.1 | 9.87066246056782 | 105 | 24 | 99.4 | 0 | 1 | 315 | 284 | 388 | ETN98485.1 hypothetical protein RFI_39013 [Reticulomyxa filosa] | diamond | 3129 | 174 | 0.994252873563218 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 22169821 | 22169821 | PRJNA520845_P_NODE_82238_length_409_cov_2.238095_g80739_i0 | PRJNA520845 | 82238 | 409 | 2.238095 | 9.15380855 | Sorites sp. isolate X-1646 | 313723 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 2.0699999999999998e-94 | NTclustered | gi|59859699|gb|AY764018.1| | 313723 | g80739 | i0 | 83.594 | 56.4303178484108 | 384 | 61 | 94 | 2 | 27 | 409 | 712 | 330 | Sorites sp. isolate X-1646 clone SoA618_4 actin type 1 gene, partial cds | blastn | 23080 | 359 | 1 | Eukaryota | Sar | Foraminifera | Miliolida | Soritidae | Sorites sp. isolate X-1646 | ||||
| 24718326 | 24718326 | PRJNA520845_P_NODE_50040_length_529_cov_1.510965_g48548_i0 | PRJNA520845 | 50040 | 529 | 1.510965 | 7.99300485 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 9.2e-44 | NR | ETO09453.1 | 46433 | g48548 | i0 | 67.8 | 0.686200378071834 | 121 | 36 | 68.6 | 2 | 528 | 166 | 205 | 322 | ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa] | diamond | 363 | 160 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27362003 | 27362003 | PRJNA520845_P_NODE_237543_length_247_cov_0.885057_g236044_i0 | PRJNA520845 | 237543 | 247 | 0.885057 | 2.18609079 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.71e-24 | NR | ETO35383.1 | 46433 | g236044 | i0 | 63.4 | 0.995951417004049 | 82 | 25 | 93.5 | 1 | 6 | 236 | 141 | 222 | ETO35383.1 hypothetical protein RFI_01679, partial [Reticulomyxa filosa] | diamond | 246 | 102 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28024935 | 28024935 | PRJNA520845_P_NODE_267325_length_241_cov_0.916667_g265826_i0 | PRJNA520845 | 267325 | 241 | 0.916667 | 2.20916747 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 3.81e-8 | NR | ETO04854.1 | 46433 | g265826 | i0 | 37.1 | 1.54356846473029 | 62 | 39 | 77.2 | 0 | 18 | 203 | 1178 | 1239 | ETO04854.1 ubiquitin domain-containing protein, partial [Reticulomyxa filosa] | diamond | 372 | 59.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28656419 | 28656419 | PRJNA520845_P_NODE_223827_length_249_cov_0.875000_g222328_i0 | PRJNA520845 | 223827 | 249 | 0.875 | 2.17875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.81e-4 | NR | ETO33757.1 | 46433 | g222328 | i0 | 28.2 | 5.26506024096386 | 71 | 43 | 75.9 | 1 | 247 | 59 | 97 | 167 | ETO33757.1 hypothetical protein RFI_03347 [Reticulomyxa filosa] | diamond | 1311 | 49.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29397814 | 29397814 | PRJNA520845_P_NODE_230289_length_248_cov_0.880000_g228790_i0 | PRJNA520845 | 230289 | 248 | 0.88 | 2.1824 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 5.19e-25 | NR | ETO30743.1 | 46433 | g228790 | i0 | 60.7 | 2.06854838709677 | 84 | 30 | 98 | 1 | 244 | 2 | 110 | 193 | ETO30743.1 hypothetical protein RFI_06375 [Reticulomyxa filosa] | diamond | 513 | 103 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29603195 | 29603195 | PRJNA520845_P_NODE_230710_length_248_cov_0.880000_g229211_i0 | PRJNA520845 | 230710 | 248 | 0.88 | 2.1824 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 1.54e-14 | NR | ETO18936.1 | 46433 | g229211 | i0 | 49.3 | 3.82258064516129 | 75 | 35 | 87.1 | 1 | 217 | 2 | 79 | 153 | ETO18936.1 hypothetical protein RFI_18307, partial [Reticulomyxa filosa] | diamond | 948 | 75.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29713175 | 29713175 | PRJNA520845_P_NODE_251430_length_244_cov_0.900585_g249931_i0 | PRJNA520845 | 251430 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 9.62e-10 | NR | ETO20981.1 | 46433 | g249931 | i0 | 41.3 | 1.81967213114754 | 75 | 43 | 91 | 1 | 223 | 2 | 301 | 375 | ETO20981.1 hypothetical protein RFI_16226 [Reticulomyxa filosa] | diamond | 444 | 64.7 | 0.993817619783617 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29919395 | 29919395 | PRJNA520845_P_NODE_105451_length_362_cov_1.861592_g103952_i0 | PRJNA520845 | 105451 | 362 | 1.861592 | 6.73896304 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 4.45e-13 | NR | ETO16720.1 | 46433 | g103952 | i0 | 47.8 | 0.57182320441989 | 69 | 35 | 56.4 | 1 | 69 | 272 | 157 | 225 | ETO16720.1 hypothetical protein RFI_20618 [Reticulomyxa filosa] | diamond | 207 | 74.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30298871 | 30298871 | PRJNA520845_P_NODE_163832_length_290_cov_2.548387_g162333_i0 | PRJNA520845 | 163832 | 290 | 2.548387 | 7.3903223 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.7e-16 | NR | ETO33147.1 | 46433 | g162333 | i0 | 48 | 1.58275862068966 | 75 | 38 | 77.6 | 1 | 66 | 290 | 201 | 274 | ETO33147.1 hypothetical protein RFI_03961 [Reticulomyxa filosa] | diamond | 459 | 83.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30597995 | 30597995 | PRJNA520845_P_NODE_37513_length_618_cov_1.482569_g36047_i0 | PRJNA520845 | 37513 | 618 | 1.482569 | 9.16227642 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 2.04e-29 | NR | ETO16281.1 | 46433 | g36047 | i0 | 55.1 | 24.5145631067961 | 107 | 44 | 51.5 | 2 | 4 | 321 | 36 | 139 | ETO16281.1 hypothetical protein RFI_21073 [Reticulomyxa filosa] | diamond | 15150 | 121 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30772545 | 30772545 | PRJNA520845_P_NODE_225534_length_249_cov_0.875000_g224035_i0 | PRJNA520845 | 225534 | 249 | 0.875 | 2.17875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 6.31e-6 | NR | ETO16135.1 | 46433 | g224035 | i0 | 28.4 | 0.891566265060241 | 74 | 53 | 89.2 | 0 | 222 | 1 | 197 | 270 | ETO16135.1 hypothetical protein RFI_21222 [Reticulomyxa filosa] | diamond | 222 | 53.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31057028 | 31057028 | PRJNA520845_P_NODE_129895_length_328_cov_0.905882_g128396_i0 | PRJNA520845 | 129895 | 328 | 0.905882 | 2.97129296 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.0153 | NR | ETO21200.1 | 46433 | g128396 | i0 | 30.7 | 1.89329268292683 | 101 | 63 | 89.6 | 3 | 11 | 304 | 299 | 395 | ETO21200.1 myosin heavy chain kinase [Reticulomyxa filosa] | diamond | 621 | 45.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31293211 | 31293211 | PRJNA520845_P_NODE_101095_length_370_cov_1.037037_g99596_i0 | PRJNA520845 | 101095 | 370 | 1.037037 | 3.8370369 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.26e-4 | NR | ETO08820.1 | 46433 | g99596 | i0 | 27.5 | 4.24864864864865 | 131 | 75 | 99.7 | 5 | 370 | 2 | 839 | 957 | ETO08820.1 CorA family magnesium ion transporter [Reticulomyxa filosa] | diamond | 1572 | 52 | 0.992307692307692 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31594563 | 31594563 | PRJNA520845_P_NODE_96196_length_379_cov_1.013072_g94697_i0 | PRJNA520845 | 96196 | 379 | 1.013072 | 3.83954288 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 2.6200000000000003e-21 | NR | ETO13704.1 | 46433 | g94697 | i0 | 52.2 | 0.712401055408971 | 90 | 43 | 71.2 | 0 | 1 | 270 | 120 | 209 | ETO13704.1 hypothetical protein RFI_23664 [Reticulomyxa filosa] | diamond | 270 | 95.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31672769 | 31672769 | PRJNA520845_P_NODE_148417_length_306_cov_2.914163_g146918_i0 | PRJNA520845 | 148417 | 306 | 2.914163 | 8.91733878 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.12e-18 | NR | ETO25247.1 | 46433 | g146918 | i0 | 51.3 | 2.54901960784314 | 76 | 37 | 74.5 | 0 | 303 | 76 | 31 | 106 | ETO25247.1 hypothetical protein RFI_11891 [Reticulomyxa filosa] | diamond | 780 | 85.5 | 0.990643274853801 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31973790 | 31973790 | PRJNA520845_P_NODE_105418_length_362_cov_2.000000_g103919_i0 | PRJNA520845 | 105418 | 362 | 2 | 7.24 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 8.92e-13 | NR | ETO36728.1 | 46433 | g103919 | i0 | 38.4 | 0.820441988950276 | 99 | 60 | 82 | 1 | 297 | 1 | 43 | 140 | ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa] | diamond | 297 | 71.6 | 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);;