contig_metadata
5 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24604161 | 24604161 | PRJNA312615_P_NODE_28460_length_229_cov_1.894444_g28309_i0 | PRJNA312615 | 28460 | 229 | 1.894444 | 4.33827676 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.86e-36 | NR | ETO30355.1 | 46433 | g28309 | i0 | 78.7 | 1.95196506550218 | 75 | 16 | 98.3 | 0 | 3 | 227 | 192 | 266 | ETO30355.1 hypothetical protein RFI_06765, partial [Reticulomyxa filosa] | diamond | 447 | 137 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 24604211 | 24604211 | PRJNA312615_P_NODE_3080_length_656_cov_1.835255_g2946_i0 | PRJNA312615 | 3080 | 656 | 1.835255 | 12.039272800000001 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 2.8e-76 | NR | ETO10415.1 | 46433 | g2946 | i0 | 72.1 | 1.73323170731707 | 190 | 47 | 86.9 | 2 | 2 | 571 | 592 | 775 | ETO10415.1 inorganic pyrophosphatase [Reticulomyxa filosa] | diamond | 1137 | 254 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27958664 | 27958664 | PRJNA312615_P_NODE_26785_length_236_cov_1.631016_g26634_i0 | PRJNA312615 | 26785 | 236 | 1.631016 | 3.84919776 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.67e-12 | NR | ETO22614.1 | 46433 | g26634 | i0 | 44.6 | 1.90677966101695 | 74 | 41 | 94.1 | 0 | 235 | 14 | 1038 | 1111 | ETO22614.1 hypothetical protein RFI_14580 [Reticulomyxa filosa] | diamond | 450 | 72 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28274309 | 28274309 | PRJNA312615_P_NODE_54306_length_165_cov_0.879310_g54155_i0 | PRJNA312615 | 54306 | 165 | 0.87931 | 1.4508615 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.013 | NR | ETO16240.1 | 46433 | g54155 | i0 | 43.9 | 2.43636363636364 | 41 | 23 | 74.5 | 0 | 146 | 24 | 1052 | 1092 | ETO16240.1 ubiquitin domain-containing protein, partial [Reticulomyxa filosa] | diamond | 402 | 42.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29617725 | 29617725 | PRJNA312615_P_NODE_26610_length_237_cov_1.085106_g26459_i0 | PRJNA312615 | 26610 | 237 | 1.085106 | 2.57170122 | root | 1 | Root_unresolved | Root_unresolved | 94 | 8.97e-21 | NR | ETO32667.1 | 46433 | g26459 | i0 | 57.7 | 4.9746835443038 | 78 | 33 | 98.7 | 0 | 3 | 236 | 148 | 225 | ETO32667.1 hypothetical protein RFI_04449 [Reticulomyxa filosa] | diamond | 1179 | 94 | 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);;