contig_metadata
21 rows where bioproject = "PRJNA849822", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838545 | 838545 | PRJNA849822_P_NODE_20061_length_323_cov_1.684000_g19887_i0 | PRJNA849822 | 20061 | 323 | 1.684 | 5.43932 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 7.32e-44 | NR | ETO14766.1 | 46433 | g19887 | i0 | 66.4 | 36.6222910216718 | 107 | 36 | 99.4 | 0 | 323 | 3 | 53 | 159 | ETO14766.1 hypothetical protein RFI_22603 [Reticulomyxa filosa] | diamond | 11829 | 150 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 8491321 | 8491321 | PRJNA849822_P_NODE_11227_length_442_cov_2.138211_g11054_i0 | PRJNA849822 | 11227 | 442 | 2.138211 | 9.45089262 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 1.34e-37 | NR | ETO10415.1 | 46433 | g11054 | i0 | 77.7 | 7.1131221719457 | 103 | 22 | 69.9 | 1 | 442 | 134 | 676 | 777 | ETO10415.1 inorganic pyrophosphatase [Reticulomyxa filosa] | diamond | 3144 | 146 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 9766551 | 9766551 | PRJNA849822_P_NODE_12348_length_419_cov_1.736994_g12174_i0 | PRJNA849822 | 12348 | 419 | 1.736994 | 7.27800486 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 2.93e-20 | NR | ETO13143.1 | 46433 | g12174 | i0 | 50.6 | 0.551312649164678 | 77 | 36 | 53.7 | 1 | 6 | 230 | 39 | 115 | ETO13143.1 hypothetical protein RFI_24232 [Reticulomyxa filosa] | diamond | 231 | 90.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 9766715 | 9766715 | PRJNA849822_P_NODE_31228_length_261_cov_2.393617_g31054_i0 | PRJNA849822 | 31228 | 261 | 2.393617 | 6.24734037 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.01e-30 | NR | ETO26653.1 | 46433 | g31054 | i0 | 73.1 | 1.75862068965517 | 78 | 21 | 89.7 | 0 | 1 | 234 | 1996 | 2073 | ETO26653.1 hypothetical protein RFI_10483 [Reticulomyxa filosa] | diamond | 459 | 124 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 23791028 | 23791028 | PRJNA849822_P_NODE_8179_length_531_cov_1.537118_g8007_i0 | PRJNA849822 | 8179 | 531 | 1.537118 | 8.16209658 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 236 | 5.29e-70 | NR | ETO10415.1 | 46433 | g8007 | i0 | 74.4 | 91.8757062146893 | 176 | 40 | 99.4 | 1 | 2 | 529 | 586 | 756 | ETO10415.1 inorganic pyrophosphatase [Reticulomyxa filosa] | diamond | 48786 | 236 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26873677 | 26873677 | PRJNA849822_P_NODE_42721_length_242_cov_1.621302_g42547_i0 | PRJNA849822 | 42721 | 242 | 1.621302 | 3.92355084 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 1.05e-7 | NR | ETO03649.1 | 46433 | g42547 | i0 | 48.2 | 2.21900826446281 | 56 | 29 | 69.4 | 0 | 72 | 239 | 47 | 102 | ETO03649.1 tRNA synthetases class II [Reticulomyxa filosa] | diamond | 537 | 56.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26896908 | 26896908 | PRJNA849822_P_NODE_21261_length_314_cov_1.659751_g21087_i0 | PRJNA849822 | 21261 | 314 | 1.659751 | 5.21161814 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 8.07e-11 | NR | ETO08614.1 | 46433 | g21087 | i0 | 39.8 | 0.792993630573248 | 83 | 47 | 76.4 | 1 | 72 | 311 | 16 | 98 | ETO08614.1 hypothetical protein RFI_28774 [Reticulomyxa filosa] | diamond | 249 | 65.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27117917 | 27117917 | PRJNA849822_P_NODE_24782_length_291_cov_1.431193_g24608_i0 | PRJNA849822 | 24782 | 291 | 1.431193 | 4.16477163 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00638 | NR | ETO14607.1 | 46433 | g24608 | i0 | 38 | 0.731958762886598 | 71 | 43 | 72.2 | 1 | 288 | 79 | 181 | 251 | ETO14607.1 steroid isomerase [Reticulomyxa filosa] | diamond | 213 | 45.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27347870 | 27347870 | PRJNA849822_P_NODE_36063_length_250_cov_0.881356_g35889_i0 | PRJNA849822 | 36063 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 1.27e-4 | NR | ETO14166.1 | 46433 | g35889 | i0 | 49.1 | 1.98 | 53 | 26 | 63.6 | 1 | 234 | 76 | 58 | 109 | ETO14166.1 hypothetical protein RFI_23205, partial [Reticulomyxa filosa] | diamond | 495 | 48.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27402685 | 27402685 | PRJNA849822_P_NODE_26103_length_285_cov_1.103774_g25929_i0 | PRJNA849822 | 26103 | 285 | 1.103774 | 3.1457559 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.23e-25 | NR | ETO30689.1 | 46433 | g25929 | i0 | 53.5 | 24.2210526315789 | 86 | 39 | 90.5 | 1 | 285 | 28 | 75 | 159 | ETO30689.1 ubiquitin-like domain-containing CTD phosphatase 1 [Reticulomyxa filosa] | diamond | 6903 | 102 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27813275 | 27813275 | PRJNA849822_P_NODE_18644_length_335_cov_1.374046_g18470_i0 | PRJNA849822 | 18644 | 335 | 1.374046 | 4.6030541 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 1.8e-8 | NR | ETO36728.1 | 46433 | g18470 | i0 | 38.7 | 1.30746268656716 | 75 | 46 | 67.2 | 0 | 105 | 329 | 38 | 112 | ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa] | diamond | 438 | 60.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28318196 | 28318196 | PRJNA849822_P_NODE_18046_length_341_cov_1.164179_g17872_i0 | PRJNA849822 | 18046 | 341 | 1.164179 | 3.96985039 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 9.47e-27 | NR | ETO26653.1 | 46433 | g17872 | i0 | 53.1 | 0.994134897360704 | 113 | 53 | 99.4 | 0 | 2 | 340 | 3375 | 3487 | ETO26653.1 hypothetical protein RFI_10483 [Reticulomyxa filosa] | diamond | 339 | 114 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28516027 | 28516027 | PRJNA849822_P_NODE_20707_length_318_cov_1.608163_g20533_i0 | PRJNA849822 | 20707 | 318 | 1.608163 | 5.11395834 | root | 1 | Root_unresolved | Root_unresolved | 78.2 | 1.27e-14 | NR | ETO17249.1 | 46433 | g20533 | i0 | 42.9 | 2.81132075471698 | 105 | 48 | 97.2 | 2 | 317 | 9 | 91 | 185 | ETO17249.1 hypothetical protein RFI_20080 [Reticulomyxa filosa] | diamond | 894 | 78.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29423139 | 29423139 | PRJNA849822_P_NODE_35369_length_251_cov_0.876404_g35195_i0 | PRJNA849822 | 35369 | 251 | 0.876404 | 2.19977404 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.88e-20 | NR | ETO32154.1 | 46433 | g35195 | i0 | 58.6 | 0.836653386454183 | 70 | 29 | 83.7 | 0 | 5 | 214 | 288 | 357 | ETO32154.1 tubulin tyrosine ligase-like protein [Reticulomyxa filosa] | diamond | 210 | 94 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29928715 | 29928715 | PRJNA849822_P_NODE_12351_length_419_cov_1.632948_g12177_i0 | PRJNA849822 | 12351 | 419 | 1.632948 | 6.84205212 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.4599999999999998e-43 | NR | ETO28518.1 | 46433 | g12177 | i0 | 57.2 | 0.988066825775656 | 138 | 52 | 98.1 | 2 | 412 | 2 | 417 | 548 | ETO28518.1 axonemal dynein gamma heavy chain [Reticulomyxa filosa] | diamond | 414 | 163 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30181227 | 30181227 | PRJNA849822_P_NODE_20592_length_319_cov_1.536585_g20418_i0 | PRJNA849822 | 20592 | 319 | 1.536585 | 4.90170615 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 9.92e-18 | NR | ETO27167.1 | 46433 | g20418 | i0 | 45.6 | 0.968652037617555 | 103 | 56 | 96.9 | 0 | 317 | 9 | 203 | 305 | ETO27167.1 ATP-binding cassette superfamily [Reticulomyxa filosa] | diamond | 309 | 87.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30221069 | 30221069 | PRJNA849822_P_NODE_40992_length_244_cov_1.368421_g40818_i0 | PRJNA849822 | 40992 | 244 | 1.368421 | 3.33894724 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 9.58e-10 | NR | ETO34884.1 | 46433 | g40818 | i0 | 50.9 | 7.46311475409836 | 55 | 27 | 67.6 | 0 | 80 | 244 | 243 | 297 | ETO34884.1 hypothetical protein RFI_02203, partial [Reticulomyxa filosa] | diamond | 1821 | 64.7 | 0.993817619783617 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30379539 | 30379539 | PRJNA849822_P_NODE_40432_length_245_cov_0.906977_g40258_i0 | PRJNA849822 | 40432 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00433 | NR | ETO35233.1 | 46433 | g40258 | i0 | 52.5 | 1.46938775510204 | 40 | 19 | 49 | 0 | 243 | 124 | 846 | 885 | ETO35233.1 TPR repeat-containing protein, partial [Reticulomyxa filosa] | diamond | 360 | 45.8 | 0.991266375545852 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30528793 | 30528793 | PRJNA849822_P_NODE_29973_length_267_cov_1.206186_g29799_i0 | PRJNA849822 | 29973 | 267 | 1.206186 | 3.22051662 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 6.59e-30 | NR | ETO26723.1 | 46433 | g29799 | i0 | 57.5 | 0.97752808988764 | 87 | 36 | 97.8 | 1 | 263 | 3 | 211 | 296 | ETO26723.1 protein of unknown function DUF1929 [Reticulomyxa filosa] | diamond | 261 | 122 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30844892 | 30844892 | PRJNA849822_P_NODE_23014_length_302_cov_1.069869_g22840_i0 | PRJNA849822 | 23014 | 302 | 1.069869 | 3.23100438 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.2999999999999998e-38 | NR | ETO35216.1 | 46433 | g22840 | i0 | 65.7 | 1.01324503311258 | 102 | 33 | 99.3 | 1 | 301 | 2 | 208 | 309 | ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] | diamond | 306 | 145 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31382226 | 31382226 | PRJNA849822_P_NODE_13016_length_407_cov_1.401198_g12842_i0 | PRJNA849822 | 13016 | 407 | 1.401198 | 5.70287586 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 4.11e-23 | NR | ETO29016.1 | 46433 | g12842 | i0 | 43.3 | 1.95331695331695 | 134 | 74 | 97.3 | 1 | 4 | 399 | 154 | 287 | ETO29016.1 ATP-binding cassette transporter, subfamily G, member 2, group WBC protein PpABCG2 [Reticulomyxa filosa] | diamond | 795 | 103 | 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);;