contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2412382 | 2412382 | PRJNA576995_P_NODE_30902_length_273_cov_1.540000_g30310_i0 | PRJNA576995 | 30902 | 273 | 1.54 | 4.2042 | Conidiobolus coronatus NRRL 28638 | 796925 | Fungi | Fungi | 119 | 2.7799999999999996e-32 | NR | KXN66162.1 | 796925 | g30310 | i0 | 61.7 | 4.13186813186813 | 94 | 33 | 100 | 1 | 1 | 273 | 3 | 96 | KXN66162.1 calmodulin [Conidiobolus coronatus NRRL 28638] | diamond | 1128 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 3688340 | 3688340 | PRJNA576995_P_NODE_29563_length_280_cov_2.231884_g28971_i0 | PRJNA576995 | 29563 | 280 | 2.231884 | 6.2492752 | Eukaryota | 2759 | Fungi | Fungi | 119 | 7e-32 | NR | KAJ1987619.1 | 215637 | g28971 | i0 | 73.3 | 6.42857142857143 | 86 | 20 | 92.1 | 2 | 23 | 280 | 3 | 85 | KAJ1987619.1 40S ribosomal protein S11-B [Dimargaris cristalligena] | diamond | 1800 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 9489130 | 9489130 | PRJNA576995_P_NODE_31848_length_268_cov_1.548718_g31256_i0 | PRJNA576995 | 31848 | 268 | 1.548718 | 4.15056424 | Coemansia sp. 'formosensis' | 327750 | Fungi | Fungi | 111 | 2.3199999999999993e-28 | NR | KAJ2823424.1 | 327750 | g31256 | i0 | 55.1 | 0.996268656716418 | 89 | 40 | 99.6 | 0 | 2 | 268 | 9 | 97 | KAJ2823424.1 mRNA binding protein puf3, partial [Coemansia sp. 'formosensis'] | diamond | 267 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. 'formosensis' | |
| 11340260 | 11340260 | PRJNA576995_P_NODE_40829_length_244_cov_0.900585_g40237_i0 | PRJNA576995 | 40829 | 244 | 0.900585 | 2.1974274 | Zancudomyces culisetae | 1213189 | Fungi | Fungi | 95.1 | 1e-20 | NR | OMH81178.1 | 1213189 | g40237 | i0 | 60 | 4.91803278688525 | 80 | 32 | 98.4 | 0 | 240 | 1 | 168 | 247 | OMH81178.1 Antizyme inhibitor 2 [Zancudomyces culisetae] | diamond | 1200 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Zancudomyces | Zancudomyces culisetae | |
| 16439669 | 16439669 | PRJNA576995_P_NODE_5813_length_669_cov_1.604027_g5241_i0 | PRJNA576995 | 5813 | 669 | 1.604027 | 10.73094063 | Massospora cicadina | 348617 | Fungi | Fungi | 60.5 | 1.4e-7 | NR | KAI0219199.1 | 348617 | g5241 | i0 | 45.8 | 0.37219730941704 | 83 | 44 | 37.2 | 1 | 503 | 255 | 7 | 88 | KAI0219199.1 Histone H1.1 [Massospora cicadina] | diamond | 249 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Massospora | Massospora cicadina | |
| 22237923 | 22237923 | PRJNA576995_P_NODE_39918_length_245_cov_0.895349_g39326_i0 | PRJNA576995 | 39918 | 245 | 0.895349 | 2.19360505 | Coemansia | 4863 | Fungi | Fungi | 68.6 | 9.5e-12 | NR | KAJ2831493.1 | 327750 | g39326 | i0 | 47.8 | 4.92244897959184 | 67 | 35 | 82 | 0 | 3 | 203 | 77 | 143 | KAJ2831493.1 ribosome-binding protein, partial [Coemansia sp. 'formosensis'] | diamond | 1206 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. 'formosensis' | |
| 26744593 | 26744593 | PRJNA576995_P_NODE_34641_length_251_cov_0.865169_g34049_i0 | PRJNA576995 | 34641 | 251 | 0.865169 | 2.17157419 | Zoopagomycota | 1913638 | Fungi | Fungi | 96.7 | 4.4300000000000005e-21 | NR | KAI8320069.1 | 61414 | g34049 | i0 | 53 | 4.9601593625498 | 83 | 39 | 99.2 | 0 | 250 | 2 | 313 | 395 | KAI8320069.1 ARM repeat-containing protein [Martensiomyces pterosporus] | diamond | 1245 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 26952879 | 26952879 | PRJNA576995_P_NODE_38962_length_246_cov_1.734104_g38370_i0 | PRJNA576995 | 38962 | 246 | 1.734104 | 4.26589584 | Tieghemiomyces parasiticus | 78921 | Fungi | Fungi | 107 | 4.79e-25 | NR | KAJ1918564.1 | 78921 | g38370 | i0 | 66.2 | 1.79268292682927 | 74 | 25 | 90.2 | 0 | 222 | 1 | 327 | 400 | KAJ1918564.1 carboxy methyl transferase for protein phosphatase 2A [Tieghemiomyces parasiticus] | diamond | 441 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Tieghemiomyces | Tieghemiomyces parasiticus | |
| 27427467 | 27427467 | PRJNA576995_P_NODE_39543_length_246_cov_0.890173_g38951_i0 | PRJNA576995 | 39543 | 246 | 0.890173 | 2.18982558 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 60.5 | 2.98e-9 | NR | ORX93039.1 | 1314790 | g38951 | i0 | 55.9 | 0.829268292682927 | 68 | 26 | 78 | 2 | 54 | 245 | 1 | 68 | ORX93039.1 protein transporter [Basidiobolus meristosporus CBS 931.73] | diamond | 204 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 29195524 | 29195524 | PRJNA576995_P_NODE_40909_length_244_cov_0.900585_g40317_i0 | PRJNA576995 | 40909 | 244 | 0.900585 | 2.1974274 | Coemansia biformis | 1286918 | Fungi | Fungi | 60.8 | 1.52e-8 | NR | KAJ1728587.1 | 1286918 | g40317 | i0 | 41.1 | 0.897540983606557 | 73 | 42 | 89.8 | 1 | 224 | 6 | 200 | 271 | KAJ1728587.1 hypothetical protein LPJ61_003956 [Coemansia biformis] | diamond | 219 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia biformis | |
| 29637029 | 29637029 | PRJNA576995_P_NODE_31270_length_271_cov_1.545455_g30678_i0 | PRJNA576995 | 31270 | 271 | 1.545455 | 4.18818305 | Conidiobolus coronatus NRRL 28638 | 796925 | Fungi | Fungi | 43.5 | 0.0275 | NR | KXN67635.1 | 796925 | g30678 | i0 | 40 | 0.498154981549816 | 45 | 25 | 49.8 | 1 | 243 | 109 | 417 | 459 | KXN67635.1 hypothetical protein CONCODRAFT_42634, partial [Conidiobolus coronatus NRRL 28638] | diamond | 135 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 30427573 | 30427573 | PRJNA576995_P_NODE_42353_length_242_cov_0.911243_g41761_i0 | PRJNA576995 | 42353 | 242 | 0.911243 | 2.20520806 | Coemansia sp. RSA 1721 | 2663876 | Fungi | Fungi | 55.8 | 8.45e-7 | NR | KAJ2598261.1 | 2663876 | g41761 | i0 | 62.2 | 2.29338842975207 | 37 | 14 | 45.9 | 0 | 1 | 111 | 282 | 318 | KAJ2598261.1 nuclear localization sequence binding protein [Coemansia sp. RSA 1721] | diamond | 555 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 1721 | |
| 30490387 | 30490387 | PRJNA576995_P_NODE_33353_length_259_cov_1.241935_g32761_i0 | PRJNA576995 | 33353 | 259 | 1.241935 | 3.21661165 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 66.2 | 3.2e-11 | NR | PVU86898.1 | 61424 | g32761 | i0 | 36.6 | 1.81853281853282 | 82 | 51 | 93.8 | 1 | 252 | 10 | 4 | 85 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 471 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 31420320 | 31420320 | PRJNA576995_P_NODE_21456_length_327_cov_1.153543_g20864_i0 | PRJNA576995 | 21456 | 327 | 1.153543 | 3.77208561 | Fungi | 4751 | Fungi | Fungi | 70.9 | 1.45e-11 | NR | KAJ1680004.1 | 68401 | g20864 | i0 | 36.4 | 2.96330275229358 | 110 | 66 | 100 | 2 | 1 | 327 | 2379 | 2485 | KAJ1680004.1 Pre-mRNA-processing-splicing factor 8, partial [Spiromyces aspiralis] | diamond | 969 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 31596842 | 31596842 | PRJNA576995_P_NODE_40816_length_244_cov_0.900585_g40224_i0 | PRJNA576995 | 40816 | 244 | 0.900585 | 2.1974274 | Coemansia asiatica | 1052880 | Fungi | Fungi | 46.6 | 0.00148 | NR | KAJ2853555.1 | 1052880 | g40224 | i0 | 31.6 | 0.971311475409836 | 79 | 46 | 93.4 | 3 | 242 | 15 | 207 | 280 | KAJ2853555.1 E1 ubiquitin-activating protein [Coemansia asiatica] | diamond | 237 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia asiatica | |
| 31628174 | 31628174 | PRJNA576995_P_NODE_32156_length_266_cov_1.595855_g31564_i0 | PRJNA576995 | 32156 | 266 | 1.595855 | 4.2449743 | Dispira simplex | 2789359 | Fungi | Fungi | 132 | 2.07e-37 | NR | KAJ1644608.1 | 2789359 | g31564 | i0 | 77.9 | 2.61654135338346 | 77 | 17 | 86.8 | 0 | 233 | 3 | 21 | 97 | KAJ1644608.1 60S ribosomal protein L23A [Dispira simplex] | diamond | 696 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira simplex | |
| 31768212 | 31768212 | PRJNA576995_P_NODE_23097_length_317_cov_1.090164_g22505_i0 | PRJNA576995 | 23097 | 317 | 1.090164 | 3.45581988 | Fungi | 4751 | Fungi | Fungi | 131 | 8.65e-37 | NR | RKP11106.1 | 78915 | g22505 | i0 | 56.2 | 14.6971608832808 | 105 | 46 | 99.4 | 0 | 317 | 3 | 20 | 124 | RKP11106.1 60S ribosomal protein L32 [Thamnocephalis sphaerospora] | diamond | 4659 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 32640021 | 32640021 | PRJNA576995_P_NODE_9060_length_519_cov_1.553812_g8471_i0 | PRJNA576995 | 9060 | 519 | 1.553812 | 8.06428428 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 197 | 5.95e-60 | NR | RKP13945.1 | 1907219 | g8471 | i0 | 66.9 | 1.78034682080925 | 148 | 49 | 85.5 | 0 | 519 | 76 | 90 | 237 | RKP13945.1 putative S-phase-specific ribosomal protein cyc07 [Piptocephalis cylindrospora] | diamond | 924 | 197 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora |
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);;