contig_metadata
5 rows where bioproject = "PRJNA951412", tax_clade = "Opisthokonta" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934791 | 934791 | PRJNA951412_P_NODE_1061_length_437_cov_1.983516_g976_i0 | PRJNA951412 | 1061 | 437 | 1.983516 | 8.66796492 | Zancudomyces culisetae | 1213189 | Fungi | Fungi | 130 | 8.94e-32 | NR | OMH79184.1 | 1213189 | g976 | i0 | 78.4 | 2.03203661327231 | 74 | 16 | 50.8 | 0 | 6 | 227 | 768 | 841 | OMH79184.1 Elongation factor 2 [Zancudomyces culisetae] | diamond | 888 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Zancudomyces | Zancudomyces culisetae | |
| 20061438 | 20061438 | PRJNA951412_P_NODE_1916_length_333_cov_2.084615_g1831_i0 | PRJNA951412 | 1916 | 333 | 2.084615 | 6.94176795 | Coemansia | 4863 | Fungi | Fungi | 141 | 1.46e-39 | NR | KAJ2406249.1 | 2663878 | g1831 | i0 | 61.8 | 3.96396396396396 | 110 | 42 | 99.1 | 0 | 2 | 331 | 34 | 143 | KAJ2406249.1 ribosomal protein P0 (A0) (L10E) [Coemansia sp. RSA 2531] | diamond | 1320 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 2531 | |
| 23887109 | 23887109 | PRJNA951412_P_NODE_1259_length_399_cov_1.656442_g1174_i0 | PRJNA951412 | 1259 | 399 | 1.656442 | 6.60920358 | Fungi | 4751 | Fungi | Fungi | 166 | 5.4399999999999985e-47 | NR | KAJ1678898.1 | 68401 | g1174 | i0 | 71.4 | 8.95488721804511 | 112 | 31 | 84.2 | 1 | 63 | 398 | 1 | 111 | KAJ1678898.1 Obg-like ATPase [Spiromyces aspiralis] | diamond | 3573 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 27632481 | 27632481 | PRJNA951412_P_NODE_7364_length_243_cov_0.917647_g7279_i0 | PRJNA951412 | 7364 | 243 | 0.917647 | 2.22988221 | Coemansia | 4863 | Fungi | Fungi | 83.6 | 5.65e-18 | NR | KAJ2847486.1 | 147472 | g7279 | i0 | 53.8 | 6.79012345679012 | 78 | 34 | 96.3 | 2 | 7 | 240 | 8 | 83 | KAJ2847486.1 NEDD8 activating enzyme, partial [Coemansia erecta] | diamond | 1650 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia erecta | |
| 29614720 | 29614720 | PRJNA951412_P_NODE_2190_length_316_cov_1.880658_g2105_i0 | PRJNA951412 | 2190 | 316 | 1.880658 | 5.94287928 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 149 | 2.09e-39 | NR | KAI8873074.1 | 304332 | g2105 | i0 | 65.4 | 5.92405063291139 | 104 | 36 | 98.7 | 0 | 3 | 314 | 433 | 536 | KAI8873074.1 glycoside hydrolase [Ramicandelaber brevisporus] | diamond | 1872 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus |
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);;