contig_metadata
15 rows where bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27193799 | 27193799 | PRJNA1078753_P_NODE_7322_length_400_cov_1.412844_g7126_i0 | PRJNA1078753 | 7322 | 400 | 1.412844 | 5.651376 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.37e-36 | NR | ETO10631.1 | 46433 | g7126 | i0 | 45.5 | 2.9775 | 132 | 72 | 99 | 0 | 1 | 396 | 18 | 149 | ETO10631.1 acid ceramidase-like protein [Reticulomyxa filosa] | diamond | 1191 | 132 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27415385 | 27415385 | PRJNA1078753_P_NODE_16283_length_297_cov_1.031250_g16087_i0 | PRJNA1078753 | 16283 | 297 | 1.03125 | 3.0628125 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 1.12e-15 | NR | ETO12503.1 | 46433 | g16087 | i0 | 50.5 | 0.95959595959596 | 95 | 40 | 90.9 | 3 | 11 | 280 | 887 | 979 | ETO12503.1 hypothetical protein RFI_24873, partial [Reticulomyxa filosa] | diamond | 285 | 82 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27564205 | 27564205 | PRJNA1078753_P_NODE_14804_length_308_cov_1.638298_g14608_i0 | PRJNA1078753 | 14804 | 308 | 1.638298 | 5.04595784 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.2699999999999995e-23 | NR | ETO25294.1 | 46433 | g14608 | i0 | 50 | 6.91558441558442 | 102 | 51 | 99.4 | 0 | 306 | 1 | 44 | 145 | ETO25294.1 hypothetical protein RFI_11843 [Reticulomyxa filosa] | diamond | 2130 | 102 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27857079 | 27857079 | PRJNA1078753_P_NODE_29065_length_250_cov_0.870056_g28869_i0 | PRJNA1078753 | 29065 | 250 | 0.870056 | 2.17514 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 1.28e-16 | NR | ETO25151.1 | 46433 | g28869 | i0 | 50.6 | 0.948 | 79 | 37 | 94.8 | 1 | 250 | 14 | 327 | 403 | ETO25151.1 hypothetical protein RFI_11994 [Reticulomyxa filosa] | diamond | 237 | 84 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28227239 | 28227239 | PRJNA1078753_P_NODE_20966_length_274_cov_1.532338_g20770_i0 | PRJNA1078753 | 20966 | 274 | 1.532338 | 4.19860612 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 5.73e-22 | NR | ETO10631.1 | 46433 | g20770 | i0 | 50 | 1.93795620437956 | 90 | 44 | 97.4 | 1 | 3 | 269 | 89 | 178 | ETO10631.1 acid ceramidase-like protein [Reticulomyxa filosa] | diamond | 531 | 94.7 | 0.996832101372756 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29025716 | 29025716 | PRJNA1078753_P_NODE_17488_length_289_cov_1.407407_g17292_i0 | PRJNA1078753 | 17488 | 289 | 1.407407 | 4.06740623 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 9.94e-8 | NR | ETO27131.1 | 46433 | g17292 | i0 | 40 | 1.57785467128028 | 65 | 32 | 60.2 | 1 | 190 | 17 | 805 | 869 | ETO27131.1 hypothetical protein RFI_09999 [Reticulomyxa filosa] | diamond | 456 | 59.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29530640 | 29530640 | PRJNA1078753_P_NODE_22230_length_269_cov_1.571429_g22034_i0 | PRJNA1078753 | 22230 | 269 | 1.571429 | 4.22714401 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 7.19e-15 | NR | ETN99193.1 | 46433 | g22034 | i0 | 42.7 | 0.992565055762082 | 89 | 47 | 94.8 | 1 | 269 | 15 | 99 | 187 | ETN99193.1 hypothetical protein RFI_38290, partial [Reticulomyxa filosa] | diamond | 267 | 76.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29972657 | 29972657 | PRJNA1078753_P_NODE_14271_length_312_cov_1.610879_g14075_i0 | PRJNA1078753 | 14271 | 312 | 1.610879 | 5.02594248 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.8199999999999998e-40 | NR | ETO35383.1 | 46433 | g14075 | i0 | 78.3 | 0.798076923076923 | 83 | 18 | 79.8 | 0 | 9 | 257 | 97 | 179 | ETO35383.1 hypothetical protein RFI_01679, partial [Reticulomyxa filosa] | diamond | 249 | 145 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30130303 | 30130303 | PRJNA1078753_P_NODE_27012_length_251_cov_0.865169_g26816_i0 | PRJNA1078753 | 27012 | 251 | 0.865169 | 2.17157419 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.3e-8 | NR | ETO05878.1 | 46433 | g26816 | i0 | 60 | 1.2191235059761 | 40 | 16 | 47.8 | 0 | 68 | 187 | 315 | 354 | ETO05878.1 ubiquitin activating enzyme 2 [Reticulomyxa filosa] | diamond | 306 | 60.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30636002 | 30636002 | PRJNA1078753_P_NODE_40813_length_242_cov_1.520710_g40617_i0 | PRJNA1078753 | 40813 | 242 | 1.52071 | 3.6801182 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 5.67e-26 | NR | ETO05243.1 | 46433 | g40617 | i0 | 53 | 2.05785123966942 | 83 | 36 | 99.2 | 1 | 242 | 3 | 149 | 231 | ETO05243.1 NADPH oxidase [Reticulomyxa filosa] | diamond | 498 | 106 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31268190 | 31268190 | PRJNA1078753_P_NODE_25335_length_257_cov_1.391304_g25139_i0 | PRJNA1078753 | 25335 | 257 | 1.391304 | 3.57565128 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.41e-26 | NR | ETO00116.1 | 46433 | g25139 | i0 | 64.6 | 0.957198443579767 | 82 | 29 | 95.7 | 0 | 250 | 5 | 1680 | 1761 | ETO00116.1 hypothetical protein RFI_37343, partial [Reticulomyxa filosa] | diamond | 246 | 112 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31331338 | 31331338 | PRJNA1078753_P_NODE_12396_length_329_cov_1.636719_g12200_i0 | PRJNA1078753 | 12396 | 329 | 1.636719 | 5.38480551 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 2.89e-6 | NR | ETO34506.1 | 46433 | g12200 | i0 | 38.8 | 0.775075987841945 | 85 | 43 | 77.5 | 3 | 60 | 314 | 68 | 143 | ETO34506.1 hypothetical protein RFI_02589 [Reticulomyxa filosa] | diamond | 255 | 55.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31363212 | 31363212 | PRJNA1078753_P_NODE_5116_length_465_cov_1.920918_g4920_i0 | PRJNA1078753 | 5116 | 465 | 1.920918 | 8.9322687 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 2.16e-18 | NR | ETO13143.1 | 46433 | g4920 | i0 | 50.6 | 0.496774193548387 | 77 | 36 | 48.4 | 1 | 460 | 236 | 39 | 115 | ETO13143.1 hypothetical protein RFI_24232 [Reticulomyxa filosa] | diamond | 231 | 85.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32027367 | 32027367 | PRJNA1078753_P_NODE_24758_length_259_cov_1.655914_g24562_i0 | PRJNA1078753 | 24758 | 259 | 1.655914 | 4.28881726 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.29e-10 | NR | ETO16911.1 | 46433 | g24562 | i0 | 37.1 | 1.5984555984556 | 70 | 44 | 81.1 | 0 | 212 | 3 | 34 | 103 | ETO16911.1 hypothetical protein RFI_20426, partial [Reticulomyxa filosa] | diamond | 414 | 63.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32208651 | 32208651 | PRJNA1078753_P_NODE_31698_length_248_cov_0.880000_g31502_i0 | PRJNA1078753 | 31698 | 248 | 0.88 | 2.1824 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 1.48e-22 | NR | ETO10631.1 | 46433 | g31502 | i0 | 54.2 | 3.99193548387097 | 83 | 37 | 99.2 | 1 | 1 | 246 | 89 | 171 | ETO10631.1 acid ceramidase-like protein [Reticulomyxa filosa] | diamond | 990 | 95.5 | 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);;