contig_metadata
13 rows where bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15110750 | 15110750 | PRJNA414036_P_NODE_82112_length_159_cov_51.846774_g80373_i0 | PRJNA414036 | 82112 | 159 | 51.846774 | 82.43637066 | Fungi | 4751 | Fungi | Fungi | 222 | 9.479999999999999e-54 | NTclustered | gi|82398545|gb|DQ273809.1| | 61424 | g80373 | i0 | 93.333 | 99.3333333333333 | 150 | 10 | 94 | 0 | 10 | 159 | 2410 | 2261 | Furculomyces boomerangus isolate AFTOL-ID 303 28S ribosomal RNA gene, partial sequence | blastn | 15794 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 28292190 | 28292190 | PRJNA414036_P_NODE_78166_length_166_cov_2.091603_g76427_i0 | PRJNA414036 | 78166 | 166 | 2.091603 | 3.47206098 | Opisthokonta | 33154 | Fungi | Fungi | 42.4 | 0.0183 | NR | KAJ1933559.1 | 4868 | g76427 | i0 | 45.5 | 15.9036144578313 | 55 | 30 | 99.4 | 0 | 2 | 166 | 95 | 149 | KAJ1933559.1 cystathionine beta-synthase, partial [Linderina macrospora] | diamond | 2640 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina macrospora | |
| 28545156 | 28545156 | PRJNA414036_P_NODE_22247_length_321_cov_3.286713_g20517_i0 | PRJNA414036 | 22247 | 321 | 3.286713 | 10.55034873 | Eukaryota | 2759 | Fungi | Fungi | 104 | 2.9200000000000003e-26 | NR | KAJ9068162.1 | 34485 | g20517 | i0 | 88.9 | 1033.44859813084 | 63 | 7 | 58.9 | 0 | 127 | 315 | 4 | 66 | KAJ9068162.1 histone H3.1, partial [Entomophthora muscae] | diamond | 331737 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 29285928 | 29285928 | PRJNA414036_P_NODE_80909_length_161_cov_6.658730_g79170_i0 | PRJNA414036 | 80909 | 161 | 6.65873 | 10.7205553 | Dimargaris verticillata | 2761393 | Fungi | Fungi | 41.6 | 0.0263 | NR | KAJ1971059.1 | 2761393 | g79170 | i0 | 66 | 0.987577639751553 | 53 | 18 | 98.8 | 0 | 159 | 1 | 126 | 178 | KAJ1971059.1 ribosomal protein S5, partial [Dimargaris verticillata] | diamond | 159 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris verticillata | |
| 29302682 | 29302682 | PRJNA414036_P_NODE_35729_length_248_cov_2.967136_g33993_i0 | PRJNA414036 | 35729 | 248 | 2.967136 | 7.35849728 | Eukaryota | 2759 | Fungi | Fungi | 55.1 | 1.81e-6 | NR | KAK9766604.1 | 34480 | g33993 | i0 | 49.2 | 38.3709677419355 | 61 | 31 | 73.8 | 0 | 245 | 63 | 765 | 825 | KAK9766604.1 ATP-dependent RNA helicase [Basidiobolus ranarum] | diamond | 9516 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 29412241 | 29412241 | PRJNA414036_P_NODE_17849_length_355_cov_4.443750_g16138_i0 | PRJNA414036 | 17849 | 355 | 4.44375 | 15.7753125 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 64.7 | 2.52e-9 | NR | KAK9728628.1 | 34480 | g16138 | i0 | 60.5 | 1.89295774647887 | 76 | 30 | 64.2 | 0 | 339 | 112 | 330 | 405 | KAK9728628.1 26S proteasome regulatory subunit 6A [Basidiobolus ranarum] | diamond | 672 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 29902754 | 29902754 | PRJNA414036_P_NODE_24211_length_308_cov_3.417582_g22479_i0 | PRJNA414036 | 24211 | 308 | 3.417582 | 10.52615256 | Eukaryota | 2759 | Fungi | Fungi | 106 | 2.96e-27 | NR | KAJ9068162.1 | 34485 | g22479 | i0 | 89.1 | 231.525974025974 | 64 | 7 | 62.3 | 0 | 111 | 302 | 3 | 66 | KAJ9068162.1 histone H3.1, partial [Entomophthora muscae] | diamond | 71310 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 30565793 | 30565793 | PRJNA414036_P_NODE_11493_length_417_cov_9.193717_g9913_i0 | PRJNA414036 | 11493 | 417 | 9.193717 | 38.33779989 | Opisthokonta | 33154 | Fungi | Fungi | 44.7 | 0.0187 | NR | XP_051392237.1 | 61397 | g9913 | i0 | 44.8 | 5.00719424460432 | 87 | 48 | 62.6 | 0 | 417 | 157 | 61 | 147 | XP_051392237.1 uncharacterized protein BX661DRAFT_101570 [Kickxella alabastrina] | diamond | 2088 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 31419363 | 31419363 | PRJNA414036_P_NODE_63716_length_202_cov_7.760479_g61977_i0 | PRJNA414036 | 63716 | 202 | 7.760479 | 15.67616758 | Ancylistaceae | 34486 | Fungi | Fungi | 50.8 | 8.4e-6 | NR | KXN67890.1 | 796925 | g61977 | i0 | 56.7 | 2.98514851485149 | 67 | 29 | 99.5 | 0 | 202 | 2 | 53 | 119 | KXN67890.1 60S ribosomal protein L23 [Conidiobolus coronatus NRRL 28638] | diamond | 603 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 31609242 | 31609242 | PRJNA414036_P_NODE_1356_length_686_cov_3.115207_g1086_i0 | PRJNA414036 | 1356 | 686 | 3.115207 | 21.37032002 | Coemansia | 4863 | Fungi | Fungi | 89.7 | 1.73e-18 | NR | PIA14767.1 | 763665 | g1086 | i0 | 72.1 | 53.0860058309038 | 61 | 17 | 26.7 | 0 | 604 | 422 | 69 | 129 | PIA14767.1 ubiquitin-conjugating enzyme [Coemansia reversa NRRL 1564] | diamond | 36417 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia reversa | |
| 31798775 | 31798775 | PRJNA414036_P_NODE_75717_length_170_cov_4.496296_g73978_i0 | PRJNA414036 | 75717 | 170 | 4.496296 | 7.6437032 | Opisthokonta | 33154 | Fungi | Fungi | 42.7 | 0.00976 | NR | KAJ1882755.1 | 61397 | g73978 | i0 | 50 | 7.72941176470588 | 46 | 23 | 81.2 | 0 | 140 | 3 | 61 | 106 | KAJ1882755.1 Casein kinase II subunit alpha [Kickxella alabastrina] | diamond | 1314 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 31893853 | 31893853 | PRJNA414036_P_NODE_69997_length_183_cov_3.844595_g68258_i0 | PRJNA414036 | 69997 | 183 | 3.844595 | 7.03560885 | Opisthokonta | 33154 | Fungi | Fungi | 62.4 | 1.61e-9 | NR | KAK9701865.1 | 34480 | g68258 | i0 | 63.6 | 69.0327868852459 | 55 | 20 | 90.2 | 0 | 16 | 180 | 100 | 154 | KAK9701865.1 Serine/threonine-protein phosphatase PP2A catalytic subunit [Basidiobolus ranarum] | diamond | 12633 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 32193714 | 32193714 | PRJNA414036_P_NODE_13458_length_396_cov_3.155125_g11816_i0 | PRJNA414036 | 13458 | 396 | 3.155125 | 12.494295 | Zancudomyces culisetae | 1213189 | Fungi | Fungi | 54.7 | 8.16e-6 | NR | OMH78392.1 | 1213189 | g11816 | i0 | 47.8 | 0.522727272727273 | 69 | 35 | 52.3 | 1 | 10 | 216 | 175 | 242 | OMH78392.1 hypothetical protein AX774_g8222 [Zancudomyces culisetae] | diamond | 207 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Zancudomyces | Zancudomyces culisetae |
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);;