contig_metadata
13 rows where bioproject = "PRJNA1011844" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1430793 | 1430793 | PRJNA1011844_P_NODE_13042_length_1583_cov_41.674834_g9433_i0 | PRJNA1011844 | 13042 | 1583 | 41.674834 | 659.71262222 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.49e-164 | NR | ETO22220.1 | 46433 | g9433 | i0 | 61.4 | 9.27289955780164 | 370 | 137 | 69.2 | 2 | 1392 | 298 | 8 | 376 | ETO22220.1 actin [Reticulomyxa filosa] | diamond | 14679 | 485 | 0.991752577319588 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 3984142 | 3984142 | PRJNA1011844_P_NODE_7224_length_2057_cov_7.783770_g5045_i0 | PRJNA1011844 | 7224 | 2057 | 7.78377 | 160.1121489 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 6.18e-104 | NR | ETO11489.1 | 46433 | g5045 | i0 | 35 | 1.54010695187166 | 506 | 288 | 72 | 9 | 1616 | 135 | 110 | 586 | ETO11489.1 hypothetical protein RFI_25888 [Reticulomyxa filosa] | diamond | 3168 | 339 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 10359184 | 10359184 | PRJNA1011844_P_NODE_13029_length_1584_cov_11.992058_g9426_i0 | PRJNA1011844 | 13029 | 1584 | 11.992058 | 189.95419872 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 6.8e-51 | NR | ETO13238.1 | 46433 | g9426 | i0 | 33.8 | 0.700757575757576 | 370 | 213 | 66.3 | 9 | 89 | 1138 | 17 | 374 | ETO13238.1 hypothetical protein RFI_24138 [Reticulomyxa filosa] | diamond | 1110 | 189 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 11634600 | 11634600 | PRJNA1011844_P_NODE_13030_length_1584_cov_11.696228_g9426_i1 | PRJNA1011844 | 13030 | 1584 | 11.696228 | 185.26825152 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 6.8e-51 | NR | ETO13238.1 | 46433 | g9426 | i1 | 33.8 | 0.700757575757576 | 370 | 213 | 66.3 | 9 | 1496 | 447 | 17 | 374 | ETO13238.1 hypothetical protein RFI_24138 [Reticulomyxa filosa] | diamond | 1110 | 189 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 11636199 | 11636199 | PRJNA1011844_P_NODE_73470_length_433_cov_4.152778_g64980_i0 | PRJNA1011844 | 73470 | 433 | 4.152778 | 17.98152874 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 6.4e-51 | NR | ETO22759.1 | 46433 | g64980 | i0 | 65.2 | 5.82678983833718 | 141 | 48 | 97 | 1 | 1 | 420 | 466 | 606 | ETO22759.1 MutS like protein [Reticulomyxa filosa] | diamond | 2523 | 182 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27287671 | 27287671 | PRJNA1011844_P_NODE_67383_length_470_cov_5.962217_g58942_i0 | PRJNA1011844 | 67383 | 470 | 5.962217 | 28.0224199 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 0.00308 | NR | ETO04236.1 | 46433 | g58942 | i0 | 29.9 | 0.982978723404255 | 154 | 82 | 86.8 | 7 | 2 | 409 | 104 | 249 | ETO04236.1 hypothetical protein RFI_33164, partial [Reticulomyxa filosa] | diamond | 462 | 48.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28803025 | 28803025 | PRJNA1011844_P_NODE_24748_length_1097_cov_5.468750_g18851_i0 | PRJNA1011844 | 24748 | 1097 | 5.46875 | 59.9921875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 2.17e-56 | NR | ETO32845.1 | 46433 | g18851 | i0 | 34.8 | 1.99908842297174 | 362 | 215 | 96 | 10 | 1070 | 18 | 2 | 353 | ETO32845.1 hypothetical protein RFI_04271 [Reticulomyxa filosa] | diamond | 2193 | 201 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29119314 | 29119314 | PRJNA1011844_P_NODE_49269_length_635_cov_6.387900_g41040_i0 | PRJNA1011844 | 49269 | 635 | 6.3879 | 40.563165 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.6499999999999995e-23 | NR | ETO09666.1 | 46433 | g41040 | i0 | 40.4 | 1.24251968503937 | 166 | 80 | 77 | 7 | 552 | 64 | 44 | 193 | ETO09666.1 hypothetical protein RFI_27710 [Reticulomyxa filosa] | diamond | 789 | 103 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29245315 | 29245315 | PRJNA1011844_P_NODE_119789_length_284_cov_1.317536_g111212_i0 | PRJNA1011844 | 119789 | 284 | 1.317536 | 3.74180224 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.69e-7 | NR | ETO28957.1 | 46433 | g111212 | i0 | 39 | 0.623239436619718 | 59 | 35 | 62.3 | 1 | 35 | 211 | 529 | 586 | ETO28957.1 hypothetical protein RFI_08169, partial [Reticulomyxa filosa] | diamond | 177 | 58.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31132630 | 31132630 | PRJNA1011844_P_NODE_19055_length_1291_cov_9.452381_g14158_i0 | PRJNA1011844 | 19055 | 1291 | 9.452381 | 122.03023871 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 4.55e-4 | NR | ETO07200.1 | 46433 | g14158 | i0 | 44.9 | 0.618125484120837 | 69 | 38 | 16 | 0 | 812 | 606 | 115 | 183 | ETO07200.1 hypothetical protein RFI_30194 [Reticulomyxa filosa] | diamond | 798 | 55.1 | 0.992740471869329 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31891947 | 31891947 | PRJNA1011844_P_NODE_134517_length_264_cov_1.329843_g125939_i0 | PRJNA1011844 | 134517 | 264 | 1.329843 | 3.51078552 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 2.96e-16 | NR | ETO18786.1 | 46433 | g125939 | i0 | 47.4 | 2.67045454545455 | 78 | 40 | 88.6 | 1 | 20 | 253 | 1 | 77 | ETO18786.1 hypothetical protein RFI_18461, partial [Reticulomyxa filosa] | diamond | 705 | 80.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32121324 | 32121324 | PRJNA1011844_P_NODE_158258_length_243_cov_0.905882_g149678_i0 | PRJNA1011844 | 158258 | 243 | 0.905882 | 2.20129326 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 3.83e-11 | NR | ETO36256.1 | 46433 | g149678 | i0 | 42.3 | 0.962962962962963 | 78 | 42 | 92.6 | 1 | 231 | 7 | 156 | 233 | ETO36256.1 u5 small nuclear ribonucleoprotein 40 kDa protein isoform 1 [Reticulomyxa filosa] | diamond | 234 | 68.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32871342 | 32871342 | PRJNA1011844_P_NODE_72240_length_440_cov_3.564033_g63759_i0 | PRJNA1011844 | 72240 | 440 | 3.564033 | 15.6817452 | Eustigmatales | 425074 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 3.39e-13 | NR | ETO25790.1 | 46433 | g63759 | i0 | 50.7 | 1.33636363636364 | 67 | 33 | 45.7 | 0 | 235 | 435 | 70 | 136 | ETO25790.1 P450 (cytochrome) oxidoreductase [Reticulomyxa filosa] | diamond | 588 | 77 | 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);;