contig_metadata
20 rows where bioproject = "PRJNA631119", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10080316 | 10080316 | PRJNA631119_P_NODE_25748_length_270_cov_1.563452_g25630_i0 | PRJNA631119 | 25748 | 270 | 1.563452 | 4.2213204 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.7099999999999996e-34 | NR | ETO10515.1 | 46433 | g25630 | i0 | 73.8 | 0.933333333333333 | 84 | 22 | 93.3 | 0 | 1 | 252 | 511 | 594 | ETO10515.1 hypothetical protein RFI_26859 [Reticulomyxa filosa] | diamond | 252 | 135 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26985875 | 26985875 | PRJNA631119_P_NODE_33042_length_248_cov_1.760000_g32924_i0 | PRJNA631119 | 33042 | 248 | 1.76 | 4.3648 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.67e-5 | NR | ETO26409.1 | 46433 | g32924 | i0 | 41 | 0.737903225806452 | 61 | 35 | 72.6 | 1 | 180 | 1 | 419 | 479 | ETO26409.1 ubiquitin protein ligase, partial [Reticulomyxa filosa] | diamond | 183 | 50.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27365658 | 27365658 | PRJNA631119_P_NODE_20783_length_293_cov_1.050000_g20665_i0 | PRJNA631119 | 20783 | 293 | 1.05 | 3.0765 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1.39e-12 | NR | ETO28350.1 | 46433 | g20665 | i0 | 57.1 | 11.1399317406143 | 63 | 27 | 64.5 | 0 | 1 | 189 | 777 | 839 | ETO28350.1 hypothetical protein RFI_08783 [Reticulomyxa filosa] | diamond | 3264 | 73.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27460275 | 27460275 | PRJNA631119_P_NODE_35663_length_245_cov_0.895349_g35545_i0 | PRJNA631119 | 35663 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 2.1e-5 | NR | ETO25743.1 | 46433 | g35545 | i0 | 35.6 | 0.722448979591837 | 59 | 35 | 72.2 | 1 | 178 | 2 | 67 | 122 | ETO25743.1 hypothetical protein RFI_11394, partial [Reticulomyxa filosa] | diamond | 177 | 51.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27681428 | 27681428 | PRJNA631119_P_NODE_11024_length_369_cov_1.581081_g10906_i0 | PRJNA631119 | 11024 | 369 | 1.581081 | 5.83418889 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.65e-24 | NR | ETO26409.1 | 46433 | g10906 | i0 | 62.2 | 0.666666666666667 | 82 | 29 | 66.7 | 2 | 1 | 246 | 1184 | 1263 | ETO26409.1 ubiquitin protein ligase, partial [Reticulomyxa filosa] | diamond | 246 | 107 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27965218 | 27965218 | PRJNA631119_P_NODE_34065_length_247_cov_0.885057_g33947_i0 | PRJNA631119 | 34065 | 247 | 0.885057 | 2.18609079 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.14e-11 | NR | ETO10181.1 | 46433 | g33947 | i0 | 47.9 | 0.88663967611336 | 73 | 35 | 88.7 | 2 | 24 | 242 | 3 | 72 | ETO10181.1 hypothetical protein RFI_27195 [Reticulomyxa filosa] | diamond | 219 | 68.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28249268 | 28249268 | PRJNA631119_P_NODE_28926_length_257_cov_2.086957_g28808_i0 | PRJNA631119 | 28926 | 257 | 2.086957 | 5.36347949 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 3.32e-18 | NR | ETO16568.1 | 46433 | g28808 | i0 | 64 | 0.875486381322957 | 75 | 25 | 85.2 | 2 | 2 | 220 | 67 | 141 | ETO16568.1 14-3-3-like protein [Reticulomyxa filosa] | diamond | 225 | 85.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28470623 | 28470623 | PRJNA631119_P_NODE_9386_length_392_cov_2.576803_g9268_i0 | PRJNA631119 | 9386 | 392 | 2.576803 | 10.10106776 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 3.1599999999999996e-47 | NR | ETO26409.1 | 46433 | g9268 | i0 | 61.5 | 3.97959183673469 | 130 | 49 | 98.7 | 1 | 1 | 387 | 1122 | 1251 | ETO26409.1 ubiquitin protein ligase, partial [Reticulomyxa filosa] | diamond | 1560 | 173 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28880810 | 28880810 | PRJNA631119_P_NODE_11168_length_367_cov_2.027211_g11050_i0 | PRJNA631119 | 11168 | 367 | 2.027211 | 7.43986437 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 3.2999999999999994e-56 | NR | ETO18757.1 | 46433 | g11050 | i0 | 72.4 | 1.00544959128065 | 123 | 33 | 99.7 | 1 | 2 | 367 | 172 | 294 | ETO18757.1 hypothetical protein RFI_18498, partial [Reticulomyxa filosa] | diamond | 369 | 187 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29165361 | 29165361 | PRJNA631119_P_NODE_34409_length_247_cov_0.885057_g34291_i0 | PRJNA631119 | 34409 | 247 | 0.885057 | 2.18609079 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.32e-9 | NR | ETO05471.1 | 46433 | g34291 | i0 | 41.3 | 0.910931174089069 | 75 | 42 | 91.1 | 1 | 2 | 226 | 337 | 409 | ETO05471.1 2OG-Fe(II) oxygenase family protein [Reticulomyxa filosa] | diamond | 225 | 63.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29449011 | 29449011 | PRJNA631119_P_NODE_12650_length_351_cov_0.949640_g12532_i0 | PRJNA631119 | 12650 | 351 | 0.94964 | 3.3332364 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 1.08e-9 | NR | ETO07871.1 | 46433 | g12532 | i0 | 35.2 | 0.923076923076923 | 108 | 63 | 88.9 | 2 | 39 | 350 | 23 | 127 | ETO07871.1 hypothetical protein RFI_29519 [Reticulomyxa filosa] | diamond | 324 | 64.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29967119 | 29967119 | PRJNA631119_P_NODE_16131_length_321_cov_1.701613_g16013_i0 | PRJNA631119 | 16131 | 321 | 1.701613 | 5.46217773 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.28e-5 | NR | ETO30254.1 | 46433 | g16013 | i0 | 27.5 | 1.76635514018692 | 91 | 66 | 85 | 0 | 281 | 9 | 70 | 160 | ETO30254.1 hypothetical protein RFI_06871, partial [Reticulomyxa filosa] | diamond | 567 | 53.1 | 0.994350282485876 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30820184 | 30820184 | PRJNA631119_P_NODE_23774_length_279_cov_1.203883_g23656_i0 | PRJNA631119 | 23774 | 279 | 1.203883 | 3.35883357 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00416 | NR | ETO00348.1 | 46433 | g23656 | i0 | 41 | 1.63440860215054 | 61 | 33 | 62.4 | 1 | 277 | 104 | 211 | 271 | ETO00348.1 TLDc domain-containing protein [Reticulomyxa filosa] | diamond | 456 | 45.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30965732 | 30965732 | PRJNA631119_P_NODE_19434_length_300_cov_1.396476_g19316_i0 | PRJNA631119 | 19434 | 300 | 1.396476 | 4.189428 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 3.4499999999999995e-32 | NR | ETO26066.1 | 46433 | g19316 | i0 | 56.7 | 1.95 | 97 | 42 | 97 | 0 | 7 | 297 | 398 | 494 | ETO26066.1 SET domain containing protein [Reticulomyxa filosa] | diamond | 585 | 129 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31313193 | 31313193 | PRJNA631119_P_NODE_25255_length_272_cov_1.547739_g25137_i0 | PRJNA631119 | 25255 | 272 | 1.547739 | 4.20985008 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 9.76e-44 | NR | ETO15627.1 | 46433 | g25137 | i0 | 83.9 | 1.94117647058824 | 87 | 14 | 96 | 0 | 1 | 261 | 7 | 93 | ETO15627.1 hypothetical protein RFI_21738 [Reticulomyxa filosa] | diamond | 528 | 152 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31515832 | 31515832 | PRJNA631119_P_NODE_33536_length_248_cov_0.880000_g33418_i0 | PRJNA631119 | 33536 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 4.02e-16 | NR | ETO21917.1 | 46433 | g33418 | i0 | 51.4 | 10.3064516129032 | 70 | 34 | 84.7 | 0 | 236 | 27 | 114 | 183 | ETO21917.1 hypothetical protein RFI_15287 [Reticulomyxa filosa] | diamond | 2556 | 81.6 | 0.996323529411765 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31515833 | 31515833 | PRJNA631119_P_NODE_34316_length_247_cov_0.885057_g34198_i0 | PRJNA631119 | 34316 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 1.04e-7 | NR | ETO33170.1 | 46433 | g34198 | i0 | 39.2 | 1.90688259109312 | 79 | 47 | 94.7 | 1 | 12 | 245 | 172 | 250 | ETO33170.1 hypothetical protein RFI_03936 [Reticulomyxa filosa] | diamond | 471 | 58.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31692717 | 31692717 | PRJNA631119_P_NODE_19397_length_300_cov_1.942731_g19279_i0 | PRJNA631119 | 19397 | 300 | 1.942731 | 5.828193 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 4.58e-16 | NR | ETO21849.1 | 46433 | g19279 | i0 | 43.5 | 0.85 | 85 | 46 | 83 | 1 | 6 | 254 | 85 | 169 | ETO21849.1 hypothetical protein RFI_15354 [Reticulomyxa filosa] | diamond | 255 | 80.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31768543 | 31768543 | PRJNA631119_P_NODE_2317_length_704_cov_2.285261_g2210_i0 | PRJNA631119 | 2317 | 704 | 2.285261 | 16.08823744 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 8.17e-9 | NR | ETO18542.1 | 46433 | g2210 | i0 | 49.2 | 0.524147727272727 | 63 | 31 | 26.4 | 1 | 703 | 518 | 115 | 177 | ETO18542.1 hypothetical protein RFI_18721 [Reticulomyxa filosa] | diamond | 369 | 65.1 | 0.993855606758833 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32830535 | 32830535 | PRJNA631119_P_NODE_18740_length_304_cov_1.333333_g18622_i0 | PRJNA631119 | 18740 | 304 | 1.333333 | 4.05333232 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0213 | NR | ETO01090.1 | 46433 | g18622 | i0 | 33.3 | 1.18421052631579 | 60 | 37 | 56.3 | 1 | 1 | 171 | 21 | 80 | ETO01090.1 hypothetical protein RFI_36350 [Reticulomyxa filosa] | diamond | 360 | 42.7 | 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);;