contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA980587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2231016 | 2231016 | PRJNA980587_P_NODE_4542_length_1363_cov_3.868992_g4121_i0 | PRJNA980587 | 4542 | 1363 | 3.868992 | 52.73436096 | Reticulomyxidae | 188961 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 5.59e-186 | NR | ETN98485.1 | 46433 | g4121 | i0 | 67.2 | 9.43800440205429 | 393 | 123 | 86.5 | 2 | 1331 | 153 | 119 | 505 | ETN98485.1 hypothetical protein RFI_39013 [Reticulomyxa filosa] | diamond | 12864 | 543 | 0.990791896869245 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27285170 | 27285170 | PRJNA980587_P_NODE_62283_length_287_cov_2.102804_g61490_i0 | PRJNA980587 | 62283 | 287 | 2.102804 | 6.03504748 | root | 1 | Root_unresolved | Root_unresolved | 102 | 9.36e-25 | NR | ETO18786.1 | 46433 | g61490 | i0 | 53.1 | 1.97560975609756 | 96 | 43 | 98.3 | 1 | 285 | 4 | 41 | 136 | ETO18786.1 hypothetical protein RFI_18461, partial [Reticulomyxa filosa] | diamond | 567 | 102 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27626656 | 27626656 | PRJNA980587_P_NODE_63004_length_286_cov_1.084507_g62211_i0 | PRJNA980587 | 63004 | 286 | 1.084507 | 3.10169002 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 8.02e-7 | NR | ETO20406.1 | 46433 | g62211 | i0 | 52.7 | 0.576923076923077 | 55 | 26 | 57.7 | 0 | 262 | 98 | 274 | 328 | ETO20406.1 hypothetical protein RFI_16810 [Reticulomyxa filosa] | diamond | 165 | 56.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28131850 | 28131850 | PRJNA980587_P_NODE_9805_length_890_cov_4.023256_g9145_i0 | PRJNA980587 | 9805 | 890 | 4.023256 | 35.8069784 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 5.78e-36 | NR | ETO07820.1 | 46433 | g9145 | i0 | 44 | 0.559550561797753 | 166 | 89 | 54.9 | 4 | 812 | 324 | 24 | 188 | ETO07820.1 phospholipid-hydroperoxide glutathione peroxidase [Reticulomyxa filosa] | diamond | 498 | 139 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28573628 | 28573628 | PRJNA980587_P_NODE_57647_length_300_cov_3.295154_g56854_i0 | PRJNA980587 | 57647 | 300 | 3.295154 | 9.885462 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 1.37e-6 | NR | ETO36728.1 | 46433 | g56854 | i0 | 35.4 | 0.79 | 79 | 50 | 79 | 1 | 63 | 299 | 40 | 117 | ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa] | diamond | 237 | 54.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29710013 | 29710013 | PRJNA980587_P_NODE_66050_length_279_cov_0.912621_g65257_i0 | PRJNA980587 | 66050 | 279 | 0.912621 | 2.54621259 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 4.5e-9 | NR | ETO23124.1 | 46433 | g65257 | i0 | 39 | 0.881720430107527 | 82 | 50 | 88.2 | 0 | 276 | 31 | 177 | 258 | ETO23124.1 hypothetical protein RFI_14061, partial [Reticulomyxa filosa] | diamond | 246 | 62.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29773399 | 29773399 | PRJNA980587_P_NODE_88211_length_245_cov_0.895349_g87418_i0 | PRJNA980587 | 88211 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 4.18e-11 | NR | ETO12035.1 | 46433 | g87418 | i0 | 53.7 | 1.32244897959184 | 54 | 25 | 66.1 | 0 | 3 | 164 | 604 | 657 | ETO12035.1 hypothetical protein RFI_25340 [Reticulomyxa filosa] | diamond | 324 | 68.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30126845 | 30126845 | PRJNA980587_P_NODE_19212_length_584_cov_1.563601_g18427_i0 | PRJNA980587 | 19212 | 584 | 1.563601 | 9.13142984 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 2.87e-25 | NR | ETO25477.1 | 46433 | g18427 | i0 | 39.6 | 2.48116438356164 | 182 | 87 | 88.4 | 4 | 66 | 581 | 172 | 340 | ETO25477.1 RhoGAP domain-containing protein, partial [Reticulomyxa filosa] | diamond | 1449 | 113 | 0.991150442477876 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30126847 | 30126847 | PRJNA980587_P_NODE_41392_length_361_cov_1.968750_g40599_i0 | PRJNA980587 | 41392 | 361 | 1.96875 | 7.1071875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.6e-35 | NR | ETO10631.1 | 46433 | g40599 | i0 | 52.9 | 3.01662049861496 | 121 | 55 | 98.9 | 2 | 359 | 3 | 27 | 147 | ETO10631.1 acid ceramidase-like protein [Reticulomyxa filosa] | diamond | 1089 | 130 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30405773 | 30405773 | PRJNA980587_P_NODE_25273_length_492_cov_2.171838_g24481_i0 | PRJNA980587 | 25273 | 492 | 2.171838 | 10.68544296 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 6.57e-20 | NR | ETO14295.1 | 46433 | g24481 | i0 | 37.8 | 1.53658536585366 | 127 | 76 | 75.6 | 2 | 15 | 386 | 1158 | 1284 | ETO14295.1 Rab GTPase binding protein, partial [Reticulomyxa filosa] | diamond | 756 | 97.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30563020 | 30563020 | PRJNA980587_P_NODE_83093_length_248_cov_0.880000_g82300_i0 | PRJNA980587 | 83093 | 248 | 0.88 | 2.1824 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 5.98e-19 | NR | ETO23642.1 | 46433 | g82300 | i0 | 57.7 | 0.943548387096774 | 78 | 28 | 88.3 | 1 | 247 | 29 | 367 | 444 | ETO23642.1 hypothetical protein RFI_13537 [Reticulomyxa filosa] | diamond | 234 | 90.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30689599 | 30689599 | PRJNA980587_P_NODE_82913_length_248_cov_1.331429_g82120_i0 | PRJNA980587 | 82913 | 248 | 1.331429 | 3.30194392 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.31e-7 | NR | ETO34045.1 | 46433 | g82120 | i0 | 60 | 2.34677419354839 | 40 | 16 | 48.4 | 0 | 2 | 121 | 290 | 329 | ETO34045.1 hypothetical protein RFI_03046 [Reticulomyxa filosa] | diamond | 582 | 58.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31511731 | 31511731 | PRJNA980587_P_NODE_88516_length_245_cov_0.895349_g87723_i0 | PRJNA980587 | 88516 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.44e-5 | NR | ETO23124.1 | 46433 | g87723 | i0 | 32.1 | 0.991836734693878 | 81 | 54 | 98 | 1 | 4 | 243 | 235 | 315 | ETO23124.1 hypothetical protein RFI_14061, partial [Reticulomyxa filosa] | diamond | 243 | 52.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31891067 | 31891067 | PRJNA980587_P_NODE_72677_length_263_cov_6.878947_g71884_i0 | PRJNA980587 | 72677 | 263 | 6.878947 | 18.09163061 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 1.82e-16 | NR | ETO25247.1 | 46433 | g71884 | i0 | 51.4 | 0.798479087452472 | 70 | 34 | 79.8 | 0 | 223 | 14 | 28 | 97 | ETO25247.1 hypothetical protein RFI_11891 [Reticulomyxa filosa] | diamond | 210 | 80.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32112665 | 32112665 | PRJNA980587_P_NODE_71718_length_266_cov_1.196891_g70925_i0 | PRJNA980587 | 71718 | 266 | 1.196891 | 3.18373006 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.9e-20 | NR | ETO15300.1 | 46433 | g70925 | i0 | 53.5 | 0.969924812030075 | 86 | 40 | 97 | 0 | 265 | 8 | 672 | 757 | ETO15300.1 hypothetical protein RFI_22066 [Reticulomyxa filosa] | diamond | 258 | 95.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32176088 | 32176088 | PRJNA980587_P_NODE_68258_length_273_cov_2.310000_g67465_i0 | PRJNA980587 | 68258 | 273 | 2.31 | 6.3063 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 2.05e-6 | NR | ETO22186.1 | 46433 | g67465 | i0 | 49 | 0.56043956043956 | 51 | 26 | 56 | 0 | 158 | 6 | 43 | 93 | ETO22186.1 hypothetical protein RFI_15017 [Reticulomyxa filosa] | diamond | 153 | 54.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32397498 | 32397498 | PRJNA980587_P_NODE_85559_length_247_cov_0.885057_g84766_i0 | PRJNA980587 | 85559 | 247 | 0.885057 | 2.18609079 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 9.12e-23 | NR | ETO05237.1 | 46433 | g84766 | i0 | 57.5 | 0.97165991902834 | 80 | 34 | 97.2 | 0 | 241 | 2 | 123 | 202 | ETO05237.1 hypothetical protein RFI_32159, partial [Reticulomyxa filosa] | diamond | 240 | 100 | 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);;