contig_metadata
21 rows where bioproject = "PRJNA493827", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1748148 | 1748148 | PRJNA493827_P_NODE_53162_length_487_cov_1.908213_g50971_i0 | PRJNA493827 | 53162 | 487 | 1.908213 | 9.29299731 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.389999999999999e-47 | NR | ETO03324.1 | 46433 | g50971 | i0 | 58.3 | 0.856262833675565 | 139 | 55 | 83.8 | 2 | 20 | 427 | 33 | 171 | ETO03324.1 40S ribosomal protein S15 [Reticulomyxa filosa] | diamond | 417 | 161 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 5577875 | 5577875 | PRJNA493827_P_NODE_96145_length_349_cov_3.481884_g93947_i0 | PRJNA493827 | 96145 | 349 | 3.481884 | 12.15177516 | Allogromia sp. | 39594 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.39e-70 | NTclustered | gi|4837605|emb|AJ132371.1| | 39594 | g93947 | i0 | 81.503 | 13.9856733524355 | 346 | 58 | 98 | 6 | 1 | 343 | 641 | 983 | Allogromia sp. mRNA for actin 2 | blastn | 4881 | 279 | 1 | Eukaryota | Sar | Foraminifera | Allogromia | Allogromia sp. | |||||
| 8125619 | 8125619 | PRJNA493827_P_NODE_27647_length_718_cov_2.204651_g25657_i0 | PRJNA493827 | 27647 | 718 | 2.204651 | 15.82939418 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 1.9599999999999999e-54 | NR | ETO03070.1 | 46433 | g25657 | i0 | 80.7 | 1.36629526462396 | 109 | 21 | 45.5 | 0 | 716 | 390 | 78 | 186 | ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] | diamond | 981 | 183 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 8127254 | 8127254 | PRJNA493827_P_NODE_90507_length_361_cov_1.069444_g88309_i0 | PRJNA493827 | 90507 | 361 | 1.069444 | 3.86069284 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 6.319999999999999e-47 | NR | ETO03070.1 | 46433 | g88309 | i0 | 80.6 | 1.62049861495845 | 98 | 19 | 81.4 | 0 | 1 | 294 | 90 | 187 | ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] | diamond | 585 | 159 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 11950679 | 11950679 | PRJNA493827_P_NODE_216610_length_244_cov_1.204678_g214412_i0 | PRJNA493827 | 216610 | 244 | 1.204678 | 2.93941432 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 1.28e-20 | NR | ETO28954.1 | 46433 | g214412 | i0 | 55.1 | 5.92622950819672 | 78 | 34 | 94.7 | 1 | 243 | 13 | 59 | 136 | ETO28954.1 hypothetical protein RFI_08171 [Reticulomyxa filosa] | diamond | 1446 | 90.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 19598813 | 19598813 | PRJNA493827_P_NODE_39596_length_580_cov_4.715976_g37418_i0 | PRJNA493827 | 39596 | 580 | 4.715976 | 27.3526608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 177 | 3.71e-50 | NR | ETO09453.1 | 46433 | g37418 | i0 | 66.4 | 1.42758620689655 | 137 | 43 | 70.9 | 2 | 5 | 415 | 189 | 322 | ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa] | diamond | 828 | 177 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 24057256 | 24057256 | PRJNA493827_P_NODE_218079_length_244_cov_0.900585_g215881_i0 | PRJNA493827 | 218079 | 244 | 0.900585 | 2.1974274 | Foraminifera sp. chocolate silver saccamminid | 1415197 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 7.28e-48 | NR | AJD73542.1 | 1415197 | g215881 | i0 | 97.5 | 0.995901639344262 | 81 | 2 | 99.6 | 0 | 1 | 243 | 67 | 147 | AJD73542.1 actin, partial [Foraminifera sp. chocolate silver saccamminid] | diamond | 243 | 162 | 1 | Eukaryota | Sar | Foraminifera | Foraminifera sp. chocolate silver saccamminid | ||||||
| 24695397 | 24695397 | PRJNA493827_P_NODE_100060_length_342_cov_2.104089_g97862_i0 | PRJNA493827 | 100060 | 342 | 2.104089 | 7.19598438 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 1.83e-63 | NR | ETO03070.1 | 46433 | g97862 | i0 | 84.1 | 2.97368421052632 | 113 | 18 | 99.1 | 0 | 341 | 3 | 71 | 183 | ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] | diamond | 1017 | 201 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26696863 | 26696863 | PRJNA493827_P_NODE_226501_length_242_cov_1.260355_g224303_i0 | PRJNA493827 | 226501 | 242 | 1.260355 | 3.0500591 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.18e-29 | NR | ETO34191.1 | 46433 | g224303 | i0 | 67.5 | 8.78925619834711 | 77 | 25 | 95.5 | 0 | 241 | 11 | 281 | 357 | ETO34191.1 hypothetical protein RFI_02902 [Reticulomyxa filosa] | diamond | 2127 | 119 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27298087 | 27298087 | PRJNA493827_P_NODE_215683_length_244_cov_2.286550_g213485_i0 | PRJNA493827 | 215683 | 244 | 2.28655 | 5.579182 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00572 | NR | ETO01289.1 | 46433 | g213485 | i0 | 36.5 | 0.774590163934426 | 63 | 38 | 77.5 | 1 | 2 | 190 | 275 | 335 | ETO01289.1 hypothetical protein RFI_36155 [Reticulomyxa filosa] | diamond | 189 | 45.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27329877 | 27329877 | PRJNA493827_P_NODE_61483_length_448_cov_1.341333_g59286_i0 | PRJNA493827 | 61483 | 448 | 1.341333 | 6.00917184 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 2.55e-16 | NR | ETO03605.1 | 46433 | g59286 | i0 | 36.8 | 1.78125 | 133 | 81 | 87.1 | 1 | 53 | 442 | 30 | 162 | ETO03605.1 hypothetical protein RFI_33797, partial [Reticulomyxa filosa] | diamond | 798 | 84.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28118909 | 28118909 | PRJNA493827_P_NODE_116585_length_316_cov_2.312757_g114387_i0 | PRJNA493827 | 116585 | 316 | 2.312757 | 7.30831212 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 3.1499999999999993e-34 | NR | ETO11964.1 | 46433 | g114387 | i0 | 92.6 | 2.58227848101266 | 68 | 5 | 64.6 | 0 | 315 | 112 | 126 | 193 | ETO11964.1 glycoprotein FP21 precursor [Reticulomyxa filosa] | diamond | 816 | 126 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28781992 | 28781992 | PRJNA493827_P_NODE_43307_length_550_cov_3.262055_g41121_i0 | PRJNA493827 | 43307 | 550 | 3.262055 | 17.9413025 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 7.22e-23 | NR | ETO08110.1 | 46433 | g41121 | i0 | 40.1 | 1.70181818181818 | 157 | 81 | 80.2 | 4 | 542 | 102 | 458 | 611 | ETO08110.1 hypothetical protein RFI_29276 [Reticulomyxa filosa] | diamond | 936 | 106 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29050564 | 29050564 | PRJNA493827_P_NODE_98988_length_344_cov_2.011070_g96790_i0 | PRJNA493827 | 98988 | 344 | 2.01107 | 6.9180808 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 4.03e-5 | NR | ETO26716.1 | 46433 | g96790 | i0 | 33.7 | 1.88372093023256 | 101 | 59 | 81.1 | 3 | 294 | 16 | 82 | 182 | ETO26716.1 hypothetical protein RFI_10417 [Reticulomyxa filosa] | diamond | 648 | 52 | 0.992307692307692 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29224456 | 29224456 | PRJNA493827_P_NODE_213169_length_245_cov_0.895349_g210971_i0 | PRJNA493827 | 213169 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 5.91e-20 | NR | ETO36577.1 | 46433 | g210971 | i0 | 47.4 | 1.86122448979592 | 76 | 40 | 93.1 | 0 | 230 | 3 | 69 | 144 | ETO36577.1 NADPH oxidase [Reticulomyxa filosa] | diamond | 456 | 90.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29287182 | 29287182 | PRJNA493827_P_NODE_157649_length_273_cov_1.170000_g155451_i0 | PRJNA493827 | 157649 | 273 | 1.17 | 3.1941 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 6.86e-7 | NR | ETO35694.1 | 46433 | g155451 | i0 | 37.3 | 0.912087912087912 | 83 | 51 | 90.1 | 1 | 272 | 27 | 281 | 363 | ETO35694.1 dynein cytoplasmic 1 intermediate chain 2-like protein [Reticulomyxa filosa] | diamond | 249 | 56.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30202936 | 30202936 | PRJNA493827_P_NODE_212912_length_245_cov_0.895349_g210714_i0 | PRJNA493827 | 212912 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.13e-26 | NR | ETO11361.1 | 46433 | g210714 | i0 | 62.2 | 1.00408163265306 | 82 | 30 | 99.2 | 1 | 1 | 243 | 42 | 123 | ETO11361.1 trans-2,3-enoyl-CoA reductase [Reticulomyxa filosa] | diamond | 246 | 106 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31530721 | 31530721 | PRJNA493827_P_NODE_156696_length_274_cov_1.034826_g154498_i0 | PRJNA493827 | 156696 | 274 | 1.034826 | 2.83542324 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 1.28e-4 | NR | ETO31674.1 | 46433 | g154498 | i0 | 37.5 | 4.63138686131387 | 88 | 48 | 94.2 | 3 | 13 | 270 | 29 | 111 | ETO31674.1 kinesin-ii motor protein [Reticulomyxa filosa] | diamond | 1269 | 48.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32005106 | 32005106 | PRJNA493827_P_NODE_217658_length_244_cov_0.900585_g215460_i0 | PRJNA493827 | 217658 | 244 | 0.900585 | 2.1974274 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 3.44e-14 | NR | ETO06363.1 | 46433 | g215460 | i0 | 42.1 | 0.934426229508197 | 76 | 44 | 93.4 | 0 | 15 | 242 | 150 | 225 | ETO06363.1 hypothetical protein RFI_31032 [Reticulomyxa filosa] | diamond | 228 | 76.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32511651 | 32511651 | PRJNA493827_P_NODE_58019_length_463_cov_1.569231_g55823_i0 | PRJNA493827 | 58019 | 463 | 1.569231 | 7.26553953 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 194 | 2.7099999999999992e-55 | NR | ETO26066.1 | 46433 | g55823 | i0 | 62.7 | 0.991360691144708 | 153 | 56 | 98.5 | 1 | 457 | 2 | 273 | 425 | ETO26066.1 SET domain containing protein [Reticulomyxa filosa] | diamond | 459 | 194 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32652797 | 32652797 | PRJNA493827_P_NODE_103780_length_336_cov_1.372624_g101582_i0 | PRJNA493827 | 103780 | 336 | 1.372624 | 4.61201664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0408 | NR | ETO36149.1 | 46433 | g101582 | i0 | 32.3 | 1.00892857142857 | 65 | 40 | 58 | 1 | 271 | 77 | 524 | 584 | ETO36149.1 hypothetical protein RFI_00914, partial [Reticulomyxa filosa] | diamond | 339 | 44.3 | 0.99097065462754 | 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);;