contig_metadata
7 rows where bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27500496 | 27500496 | PRJNA986481_P_NODE_13703_length_443_cov_1.710660_g13179_i0 | PRJNA986481 | 13703 | 443 | 1.71066 | 7.5782238 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 5.28e-22 | NR | ETN98481.1 | 46433 | g13179 | i0 | 43.5 | 1.98419864559819 | 147 | 75 | 99.5 | 5 | 441 | 1 | 60 | 198 | ETN98481.1 hypothetical protein RFI_39015, partial [Reticulomyxa filosa] | diamond | 879 | 97.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27500536 | 27500536 | PRJNA986481_P_NODE_41063_length_262_cov_1.746479_g40538_i0 | PRJNA986481 | 41063 | 262 | 1.746479 | 4.57577498 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 1.35e-8 | NR | ETO13918.1 | 46433 | g40538 | i0 | 45.3 | 0.606870229007634 | 53 | 29 | 60.7 | 0 | 196 | 38 | 117 | 169 | ETO13918.1 hypothetical protein RFI_23451, partial [Reticulomyxa filosa] | diamond | 159 | 61.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27721849 | 27721849 | PRJNA986481_P_NODE_22324_length_347_cov_1.916107_g21799_i0 | PRJNA986481 | 22324 | 347 | 1.916107 | 6.64889129 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 1.47e-18 | NR | ETO27167.1 | 46433 | g21799 | i0 | 44.9 | 2.93948126801153 | 118 | 61 | 99.4 | 3 | 347 | 3 | 167 | 283 | ETO27167.1 ATP-binding cassette superfamily [Reticulomyxa filosa] | diamond | 1020 | 90.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29300111 | 29300111 | PRJNA986481_P_NODE_3209_length_842_cov_1.677175_g2846_i0 | PRJNA986481 | 3209 | 842 | 1.677175 | 14.1218135 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 6.67e-28 | NR | ETO23731.1 | 46433 | g2846 | i0 | 35.1 | 0.80166270783848 | 225 | 130 | 78.7 | 6 | 828 | 166 | 17 | 229 | ETO23731.1 hypothetical protein RFI_13446, partial [Reticulomyxa filosa] | diamond | 675 | 118 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30405968 | 30405968 | PRJNA986481_P_NODE_30353_length_297_cov_1.221774_g29828_i0 | PRJNA986481 | 30353 | 297 | 1.221774 | 3.62866878 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 2e-13 | NR | ETO32916.1 | 46433 | g29828 | i0 | 60.8 | 0.515151515151515 | 51 | 18 | 51.5 | 1 | 252 | 100 | 85 | 133 | ETO32916.1 hypothetical protein RFI_04200 [Reticulomyxa filosa] | diamond | 153 | 74.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30443222 | 30443222 | PRJNA986481_P_NODE_38953_length_265_cov_0.935185_g38428_i0 | PRJNA986481 | 38953 | 265 | 0.935185 | 2.47824025 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 6.24e-7 | NR | ETO00109.1 | 46433 | g38428 | i0 | 38.7 | 4.94716981132075 | 75 | 40 | 81.5 | 2 | 46 | 261 | 269 | 340 | ETO00109.1 hypothetical protein RFI_37350, partial [Reticulomyxa filosa] | diamond | 1311 | 57 | 0.992982456140351 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30531829 | 30531829 | PRJNA986481_P_NODE_1873_length_1044_cov_2.681407_g1596_i0 | PRJNA986481 | 1873 | 1044 | 2.681407 | 27.99388908 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 1.66e-46 | NR | ETO32845.1 | 46433 | g1596 | i0 | 36.7 | 0.885057471264368 | 308 | 177 | 86.8 | 10 | 3 | 908 | 80 | 375 | ETO32845.1 hypothetical protein RFI_04271 [Reticulomyxa filosa] | diamond | 924 | 174 | 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);;