contig_metadata
12 rows where bioproject = "PRJNA1005695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153702 | 153702 | PRJNA1005695_P_NODE_9101_length_517_cov_2.245495_g8253_i0 | PRJNA1005695 | 9101 | 517 | 2.245495 | 11.60920915 | Kickxellaceae | 4862 | Fungi | Fungi | 237 | 1.96e-69 | NR | KAJ1963985.1 | 4866 | g8253 | i0 | 66.9 | 19.9671179883946 | 172 | 57 | 99.8 | 0 | 2 | 517 | 233 | 404 | KAJ1963985.1 ornithine aminotransferase [Dipsacomyces acuminosporus] | diamond | 10323 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Dipsacomyces | Dipsacomyces acuminosporus | |
| 3979994 | 3979994 | PRJNA1005695_P_NODE_34624_length_253_cov_0.866667_g33772_i0 | PRJNA1005695 | 34624 | 253 | 0.866667 | 2.19266751 | Syncephalis plumigaleata | 1851185 | Fungi | Fungi | 99.8 | 3.65e-22 | NR | KAI8054260.1 | 1851185 | g33772 | i0 | 56.1 | 3.65217391304348 | 82 | 35 | 97.2 | 1 | 2 | 247 | 134 | 214 | KAI8054260.1 hypothetical protein BDF22DRAFT_678085 [Syncephalis plumigaleata] | diamond | 924 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata | |
| 3980085 | 3980085 | PRJNA1005695_P_NODE_5644_length_667_cov_2.826599_g4826_i0 | PRJNA1005695 | 5644 | 667 | 2.826599 | 18.85341533 | Tieghemiomyces parasiticus | 78921 | Fungi | Fungi | 175 | 4.489999999999999e-52 | NR | KAJ1923955.1 | 78921 | g4826 | i0 | 72.1 | 2.73913043478261 | 129 | 35 | 58 | 1 | 31 | 417 | 1 | 128 | KAJ1923955.1 40S ribosomal protein S17.e.B [Tieghemiomyces parasiticus] | diamond | 1827 | 175 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Tieghemiomyces | Tieghemiomyces parasiticus | |
| 9929109 | 9929109 | PRJNA1005695_P_NODE_28008_length_282_cov_3.023923_g27156_i0 | PRJNA1005695 | 28008 | 282 | 3.023923 | 8.52746286 | Linderina | 4867 | Fungi | Fungi | 119 | 2.5300000000000003e-22 | NTclustered | gi|1740134233|ref|NG_066247.1| | 4868 | g27156 | i0 | 95.89 | 25.3723404255319 | 73 | 3 | 26 | 0 | 3 | 75 | 893 | 821 | Linderina macrospora CBS 375.66 28S rRNA gene, partial sequence; from TYPE material | blastn | 7155 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina macrospora | |
| 11632053 | 11632053 | PRJNA1005695_P_NODE_24130_length_306_cov_1.313305_g23278_i0 | PRJNA1005695 | 24130 | 306 | 1.313305 | 4.0187133 | Fungi | 4751 | Fungi | Fungi | 141 | 1.62e-38 | NR | PVU95327.1 | 133385 | g23278 | i0 | 63.7 | 50.8529411764706 | 102 | 36 | 100 | 1 | 306 | 1 | 161 | 261 | PVU95327.1 hypothetical protein BB561_001901 [Smittium simulii] | diamond | 15561 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii | |
| 15028871 | 15028871 | PRJNA1005695_P_NODE_2452_length_1016_cov_3.577943_g1906_i0 | PRJNA1005695 | 2452 | 1016 | 3.577943 | 36.35190088 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 366 | 1.8000000000000002e-123 | NR | ORX66398.1 | 1314790 | g1906 | i0 | 66 | 1.68897637795276 | 288 | 95 | 84.2 | 1 | 905 | 51 | 1 | 288 | ORX66398.1 60S ribosomal protein L5 [Basidiobolus meristosporus CBS 931.73] | diamond | 1716 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 15456032 | 15456032 | PRJNA1005695_P_NODE_11033_length_467_cov_2.659898_g10181_i0 | PRJNA1005695 | 11033 | 467 | 2.659898 | 12.42172366 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 209 | 2.54e-49 | NTclustered | gi|82398540|gb|DQ273807.1| | 34480 | g10181 | i0 | 76.963 | 42.0149892933619 | 382 | 78 | 81 | 10 | 61 | 439 | 2132 | 1758 | Basidiobolus ranarum isolate AFTOL-ID 301 28S ribosomal RNA gene, partial sequence | blastn | 19621 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 24379723 | 24379723 | PRJNA1005695_P_NODE_8780_length_527_cov_1.733480_g7933_i0 | PRJNA1005695 | 8780 | 527 | 1.73348 | 9.1354396 | Dispira parvispora | 1520584 | Fungi | Fungi | 258 | 3.04e-84 | NR | KAJ1970205.1 | 1520584 | g7933 | i0 | 71.8 | 2.70967741935484 | 156 | 44 | 88.8 | 0 | 58 | 525 | 1 | 156 | KAJ1970205.1 60S ribosomal protein L2 [Dispira parvispora] | diamond | 1428 | 258 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora | |
| 26932127 | 26932127 | PRJNA1005695_P_NODE_40422_length_240_cov_2.035928_g39570_i0 | PRJNA1005695 | 40422 | 240 | 2.035928 | 4.8862272 | Eukaryota | 2759 | Fungi | Fungi | 66.2 | 1.04e-11 | NR | KXN73393.1 | 796925 | g39570 | i0 | 46.8 | 4.9625 | 79 | 40 | 98.8 | 2 | 239 | 3 | 7 | 83 | KXN73393.1 profilin-2 [Conidiobolus coronatus NRRL 28638] | diamond | 1191 | 66.6 | 0.993993993993994 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 27319096 | 27319096 | PRJNA1005695_P_NODE_22463_length_317_cov_1.151639_g21611_i0 | PRJNA1005695 | 22463 | 317 | 1.151639 | 3.65069563 | Mycoemilia scoparia | 417184 | Fungi | Fungi | 57.8 | 4.53e-7 | NR | KAJ1913708.1 | 417184 | g21611 | i0 | 43.3 | 0.56782334384858 | 60 | 34 | 56.8 | 0 | 1 | 180 | 425 | 484 | KAJ1913708.1 proteasome regulatory particle subunit [Mycoemilia scoparia] | diamond | 180 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia | |
| 30722010 | 30722010 | PRJNA1005695_P_NODE_41214_length_232_cov_6.427673_g40362_i0 | PRJNA1005695 | 41214 | 232 | 6.427673 | 14.91220136 | Zoopagomycota | 1913638 | Fungi | Fungi | 70.9 | 2.71e-12 | NR | KXN69953.1 | 796925 | g40362 | i0 | 52.6 | 1.43534482758621 | 57 | 27 | 73.7 | 0 | 171 | 1 | 1 | 57 | KXN69953.1 GDP-keto-6-deoxymannnose 3,5-epimerase/4-reductase [Conidiobolus coronatus NRRL 28638] | diamond | 333 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 32311016 | 32311016 | PRJNA1005695_P_NODE_16979_length_367_cov_1.537415_g16127_i0 | PRJNA1005695 | 16979 | 367 | 1.537415 | 5.64231305 | Syncephalis pseudoplumigaleata | 1712513 | Fungi | Fungi | 77.4 | 7.68e-14 | NR | RKP22867.1 | 1712513 | g16127 | i0 | 37.5 | 4.09536784741144 | 128 | 68 | 97.3 | 3 | 357 | 1 | 173 | 297 | RKP22867.1 Rho GTPase activation protein, partial [Syncephalis pseudoplumigaleata] | diamond | 1503 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis pseudoplumigaleata |
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);;