contig_metadata
17 rows where bioproject = "PRJNA752278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17305277 | 17305277 | PRJNA752278_P_NODE_26374_length_321_cov_1.685484_g26171_i0 | PRJNA752278 | 26374 | 321 | 1.685484 | 5.41040364 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 4.31e-21 | NR | ETO21536.1 | 46433 | g26171 | i0 | 50.5 | 0.88785046728972 | 95 | 43 | 87.9 | 2 | 1 | 282 | 53 | 144 | ETO21536.1 hypothetical protein RFI_15669 [Reticulomyxa filosa] | diamond | 285 | 93.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 17305383 | 17305383 | PRJNA752278_P_NODE_30734_length_308_cov_1.617021_g30531_i0 | PRJNA752278 | 30734 | 308 | 1.617021 | 4.98042468 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.98e-41 | NR | ETN98485.1 | 46433 | g30531 | i0 | 71.6 | 4.96753246753247 | 102 | 29 | 99.4 | 0 | 1 | 306 | 217 | 318 | ETN98485.1 hypothetical protein RFI_39013 [Reticulomyxa filosa] | diamond | 1530 | 153 | 0.993464052287582 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26957701 | 26957701 | PRJNA752278_P_NODE_15542_length_388_cov_1.657143_g15339_i0 | PRJNA752278 | 15542 | 388 | 1.657143 | 6.42971484 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 2.29e-10 | NR | ETO12487.1 | 46433 | g15339 | i0 | 33.1 | 6.78865979381443 | 124 | 81 | 95.9 | 2 | 377 | 6 | 483 | 604 | ETO12487.1 hypothetical protein RFI_24883, partial [Reticulomyxa filosa] | diamond | 2634 | 68.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27653220 | 27653220 | PRJNA752278_P_NODE_27164_length_317_cov_2.311475_g26961_i0 | PRJNA752278 | 27164 | 317 | 2.311475 | 7.32737575 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 3.27e-16 | NR | ETO31202.1 | 46433 | g26961 | i0 | 58.7 | 0.709779179810726 | 75 | 31 | 71 | 0 | 4 | 228 | 113 | 187 | ETO31202.1 Band 7 protein [Reticulomyxa filosa] | diamond | 225 | 81.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28221209 | 28221209 | PRJNA752278_P_NODE_13546_length_407_cov_2.176647_g13343_i0 | PRJNA752278 | 13546 | 407 | 2.176647 | 8.85895329 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 5.77e-23 | NR | ETO33553.1 | 46433 | g13343 | i0 | 56 | 0.619164619164619 | 84 | 33 | 59 | 1 | 3 | 242 | 89 | 172 | ETO33553.1 2-oxoglutarate dehydrogenase, E1 component [Reticulomyxa filosa] | diamond | 252 | 98.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28947869 | 28947869 | PRJNA752278_P_NODE_58308_length_269_cov_1.862245_g58105_i0 | PRJNA752278 | 58308 | 269 | 1.862245 | 5.00943905 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 2.54e-7 | NR | ETO10408.1 | 46433 | g58105 | i0 | 39.2 | 0.825278810408922 | 74 | 36 | 82.5 | 2 | 222 | 1 | 387 | 451 | ETO10408.1 hypothetical protein RFI_26965 [Reticulomyxa filosa] | diamond | 222 | 57.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29768410 | 29768410 | PRJNA752278_P_NODE_41191_length_286_cov_0.859155_g40988_i0 | PRJNA752278 | 41191 | 286 | 0.859155 | 2.4571833 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 8.19e-7 | NR | ETO20273.1 | 46433 | g40988 | i0 | 51.8 | 0.587412587412587 | 56 | 27 | 58.7 | 0 | 281 | 114 | 418 | 473 | ETO20273.1 hypothetical protein RFI_16943 [Reticulomyxa filosa] | diamond | 168 | 56.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30031206 | 30031206 | PRJNA752278_P_NODE_92251_length_246_cov_0.872832_g92048_i0 | PRJNA752278 | 92251 | 246 | 0.872832 | 2.14716672 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 3.3499999999999996e-31 | NR | ETO27916.1 | 46433 | g92048 | i0 | 68.3 | 2 | 82 | 26 | 100 | 0 | 246 | 1 | 411 | 492 | ETO27916.1 alpha-1,2-mannosidase, partial [Reticulomyxa filosa] | diamond | 492 | 125 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30115885 | 30115885 | PRJNA752278_P_NODE_2292_length_777_cov_10.376420_g2109_i0 | PRJNA752278 | 2292 | 777 | 10.37642 | 80.6247834 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 5.34e-4 | NR | ETO26716.1 | 46433 | g2109 | i0 | 33.7 | 0.833976833976834 | 101 | 59 | 35.9 | 3 | 483 | 761 | 82 | 182 | ETO26716.1 hypothetical protein RFI_10417 [Reticulomyxa filosa] | diamond | 648 | 51.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30652962 | 30652962 | PRJNA752278_P_NODE_70893_length_257_cov_1.972826_g70690_i0 | PRJNA752278 | 70893 | 257 | 1.972826 | 5.07016282 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00174 | NR | ETO29412.1 | 46433 | g70690 | i0 | 37.9 | 0.770428015564202 | 66 | 40 | 77 | 1 | 257 | 60 | 96 | 160 | ETO29412.1 epsilon subunit of coatomer protein complex-like protein [Reticulomyxa filosa] | diamond | 198 | 45.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30694614 | 30694614 | PRJNA752278_P_NODE_44213_length_283_cov_1.100000_g44010_i0 | PRJNA752278 | 44213 | 283 | 1.1 | 3.113 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00911 | NR | ETO33967.1 | 46433 | g44010 | i0 | 32.3 | 3.69964664310954 | 65 | 44 | 68.9 | 0 | 282 | 88 | 174 | 238 | ETO33967.1 hypothetical protein RFI_03130 [Reticulomyxa filosa] | diamond | 1047 | 45.4 | 0.993392070484582 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30779504 | 30779504 | PRJNA752278_P_NODE_105994_length_239_cov_3.054217_g105791_i0 | PRJNA752278 | 105994 | 239 | 3.054217 | 7.29957863 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00743 | NR | ETO14801.1 | 46433 | g105791 | i0 | 46.9 | 0.615062761506276 | 49 | 22 | 61.5 | 1 | 66 | 212 | 17 | 61 | ETO14801.1 hypothetical protein RFI_22567 [Reticulomyxa filosa] | diamond | 147 | 44.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30874255 | 30874255 | PRJNA752278_P_NODE_31194_length_306_cov_1.841202_g30991_i0 | PRJNA752278 | 31194 | 306 | 1.841202 | 5.63407812 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00573 | NR | ETO05799.1 | 46433 | g30991 | i0 | 32.9 | 1.49019607843137 | 76 | 51 | 74.5 | 0 | 78 | 305 | 47 | 122 | ETO05799.1 hypothetical protein RFI_31598 [Reticulomyxa filosa] | diamond | 456 | 45.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32202549 | 32202549 | PRJNA752278_P_NODE_42718_length_284_cov_1.459716_g42515_i0 | PRJNA752278 | 42718 | 284 | 1.459716 | 4.14559344 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 1.36e-8 | NR | ETO34903.1 | 46433 | g42515 | i0 | 36.9 | 0.887323943661972 | 84 | 53 | 88.7 | 0 | 28 | 279 | 232 | 315 | ETO34903.1 hypothetical protein RFI_02186 [Reticulomyxa filosa] | diamond | 252 | 61.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32329439 | 32329439 | PRJNA752278_P_NODE_76139_length_252_cov_1.720670_g75936_i0 | PRJNA752278 | 76139 | 252 | 1.72067 | 4.3360884 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.72e-9 | NR | ETO26066.1 | 46433 | g75936 | i0 | 50 | 0.833333333333333 | 70 | 31 | 78.6 | 1 | 198 | 1 | 623 | 692 | ETO26066.1 SET domain containing protein [Reticulomyxa filosa] | diamond | 210 | 63.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32843795 | 32843795 | PRJNA752278_P_NODE_5000_length_584_cov_1.659491_g4799_i0 | PRJNA752278 | 5000 | 584 | 1.659491 | 9.69142744 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 1.13e-61 | NR | ETO00580.1 | 46433 | g4799 | i0 | 53.5 | 1.88527397260274 | 185 | 77 | 92.5 | 3 | 548 | 9 | 33 | 213 | ETO00580.1 hypothetical protein RFI_36860 [Reticulomyxa filosa] | diamond | 1101 | 201 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32865470 | 32865470 | PRJNA752278_P_NODE_42820_length_284_cov_1.402844_g42617_i0 | PRJNA752278 | 42820 | 284 | 1.402844 | 3.98407696 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 9.15e-54 | NR | ETO03070.1 | 46433 | g42617 | i0 | 89.4 | 1.98591549295775 | 94 | 10 | 99.3 | 0 | 1 | 282 | 52 | 145 | ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] | diamond | 564 | 175 | 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);;