contig_metadata
11 rows where bioproject = "PRJNA896554", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16174979 | 16174979 | PRJNA896554_P_NODE_78533_length_407_cov_1.152695_g70993_i0 | PRJNA896554 | 78533 | 407 | 1.152695 | 4.69146865 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 6.72e-26 | NR | ETO11964.1 | 46433 | g70993 | i0 | 86.7 | 5.74938574938575 | 60 | 8 | 44.2 | 0 | 3 | 182 | 134 | 193 | ETO11964.1 glycoprotein FP21 precursor [Reticulomyxa filosa] | diamond | 2340 | 106 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26612314 | 26612314 | PRJNA896554_P_NODE_143781_length_258_cov_1.248649_g136241_i0 | PRJNA896554 | 143781 | 258 | 1.248649 | 3.22151442 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 1.44e-13 | NR | ETO36936.1 | 46433 | g136241 | i0 | 45.5 | 1.02325581395349 | 88 | 41 | 95.3 | 4 | 247 | 2 | 133 | 219 | ETO36936.1 hypothetical protein RFI_00126 [Reticulomyxa filosa] | diamond | 264 | 74.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27023970 | 27023970 | PRJNA896554_P_NODE_150262_length_251_cov_0.865169_g142722_i0 | PRJNA896554 | 150262 | 251 | 0.865169 | 2.17157419 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 6.91e-16 | NR | ETO07964.1 | 46433 | g142722 | i0 | 51.9 | 0.944223107569721 | 79 | 38 | 94.4 | 0 | 239 | 3 | 194 | 272 | ETO07964.1 periplasmic solute binding protein [Reticulomyxa filosa] | diamond | 237 | 81.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27252954 | 27252954 | PRJNA896554_P_NODE_63943_length_502_cov_1.107226_g56409_i0 | PRJNA896554 | 63943 | 502 | 1.107226 | 5.55827452 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.35e-34 | NR | ETO31381.1 | 46433 | g56409 | i0 | 45.8 | 2.98804780876494 | 166 | 51 | 99.2 | 2 | 5 | 502 | 505 | 631 | ETO31381.1 hypothetical protein RFI_05740, partial [Reticulomyxa filosa] | diamond | 1500 | 138 | 0.992753623188406 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27876897 | 27876897 | PRJNA896554_P_NODE_154445_length_249_cov_1.312500_g146905_i0 | PRJNA896554 | 154445 | 249 | 1.3125 | 3.268125 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 1.81e-10 | NR | ETO07820.1 | 46433 | g146905 | i0 | 51.6 | 0.746987951807229 | 62 | 30 | 74.7 | 0 | 201 | 16 | 3 | 64 | ETO07820.1 phospholipid-hydroperoxide glutathione peroxidase [Reticulomyxa filosa] | diamond | 186 | 65.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28571476 | 28571476 | PRJNA896554_P_NODE_140947_length_261_cov_2.398936_g133407_i0 | PRJNA896554 | 140947 | 261 | 2.398936 | 6.26122296 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 7.73e-36 | NR | ETO28442.1 | 46433 | g133407 | i0 | 77.4 | 1.95402298850575 | 84 | 19 | 96.6 | 0 | 3 | 254 | 591 | 674 | ETO28442.1 hypothetical protein RFI_08694, partial [Reticulomyxa filosa] | diamond | 510 | 138 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28666414 | 28666414 | PRJNA896554_P_NODE_80807_length_396_cov_1.907121_g73267_i0 | PRJNA896554 | 80807 | 396 | 1.907121 | 7.55219916 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 3.43e-10 | NR | ETO27626.1 | 46433 | g73267 | i0 | 60 | 1.91666666666667 | 50 | 20 | 37.9 | 0 | 7 | 156 | 289 | 338 | ETO27626.1 hypothetical protein RFI_09505 [Reticulomyxa filosa] | diamond | 759 | 67.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29707763 | 29707763 | PRJNA896554_P_NODE_111050_length_307_cov_1.735043_g103510_i0 | PRJNA896554 | 111050 | 307 | 1.735043 | 5.32658201 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 5.5e-37 | NR | ETO08551.1 | 46433 | g103510 | i0 | 70.1 | 1.70032573289902 | 87 | 26 | 85 | 0 | 1 | 261 | 3 | 89 | ETO08551.1 ABC(ATP-binding) family transporter [Reticulomyxa filosa] | diamond | 522 | 132 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30845612 | 30845612 | PRJNA896554_P_NODE_83794_length_384_cov_0.974277_g76254_i0 | PRJNA896554 | 83794 | 384 | 0.974277 | 3.74122368 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 4.77e-20 | NR | ETO28047.1 | 46433 | g76254 | i0 | 46 | 0.8828125 | 113 | 61 | 88.3 | 0 | 45 | 383 | 28 | 140 | ETO28047.1 exonuclease II, partial [Reticulomyxa filosa] | diamond | 339 | 93.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32679137 | 32679137 | PRJNA896554_P_NODE_166380_length_244_cov_1.596491_g158840_i0 | PRJNA896554 | 166380 | 244 | 1.596491 | 3.89543804 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 7.77e-13 | NR | ETO06942.1 | 46433 | g158840 | i0 | 52.9 | 0.860655737704918 | 70 | 30 | 82.4 | 1 | 203 | 3 | 137 | 206 | ETO06942.1 6-phosphofructokinase [Reticulomyxa filosa] | diamond | 210 | 72.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32805306 | 32805306 | PRJNA896554_P_NODE_160440_length_247_cov_0.885057_g152900_i0 | PRJNA896554 | 160440 | 247 | 0.885057 | 2.18609079 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.83e-26 | NR | ETO26652.1 | 46433 | g152900 | i0 | 66.2 | 1.87044534412955 | 77 | 26 | 93.5 | 0 | 232 | 2 | 235 | 311 | ETO26652.1 dynein beta chain, flagellar outer arm [Reticulomyxa filosa] | diamond | 462 | 107 | 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);;