contig_metadata
9 rows where bioproject = "PRJEB81171", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139313 | 139313 | PRJEB81171_P_NODE_2321_length_436_cov_1.162534_g2195_i0 | PRJEB81171 | 2321 | 436 | 1.162534 | 5.06864824 | Dispira simplex | 2789359 | Fungi | Fungi | 207 | 3.8099999999999994e-61 | NR | KAJ1651291.1 | 2789359 | g2195 | i0 | 70.1 | 21.4816513761468 | 144 | 43 | 99.1 | 0 | 433 | 2 | 31 | 174 | KAJ1651291.1 hypothetical protein IWQ61_008108 [Dispira simplex] | diamond | 9366 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira simplex | |
| 6517684 | 6517684 | PRJEB81171_P_NODE_9486_length_244_cov_1.157895_g9359_i0 | PRJEB81171 | 9486 | 244 | 1.157895 | 2.8252638 | Smittium mucronatum | 133383 | Fungi | Fungi | 108 | 5.78e-27 | NR | OLY79801.1 | 133383 | g9359 | i0 | 72.5 | 0.848360655737705 | 69 | 19 | 84.8 | 0 | 37 | 243 | 3 | 71 | OLY79801.1 Ribulose-phosphate 3-epimerase, cytoplasmic isoform [Smittium mucronatum] | diamond | 207 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 20540281 | 20540281 | PRJEB81171_P_NODE_2257_length_442_cov_1.224932_g2132_i0 | PRJEB81171 | 2257 | 442 | 1.224932 | 5.41419944 | Fungi | 4751 | Fungi | Fungi | 205 | 1.7399999999999998e-61 | NR | KAK9680078.1 | 34480 | g2132 | i0 | 66.2 | 19.0452488687783 | 148 | 49 | 99.8 | 1 | 2 | 442 | 106 | 253 | KAK9680078.1 Nucleolar protein 58, partial [Basidiobolus ranarum] | diamond | 8418 | 207 | 0.990338164251208 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 27343296 | 27343296 | PRJEB81171_P_NODE_5543_length_286_cov_1.483568_g5416_i0 | PRJEB81171 | 5543 | 286 | 1.483568 | 4.24300448 | root | 1 | Root_unresolved | Root_unresolved | 77 | 5.23e-14 | NR | PVU90513.1 | 133385 | g5416 | i0 | 53.7 | 4.95104895104895 | 67 | 31 | 70.3 | 0 | 3 | 203 | 464 | 530 | PVU90513.1 hypothetical protein BB561_004855 [Smittium simulii] | diamond | 1416 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii | |
| 28953593 | 28953593 | PRJEB81171_P_NODE_4708_length_307_cov_1.000000_g4581_i0 | PRJEB81171 | 4708 | 307 | 1 | 3.07 | Fungi | 4751 | Fungi | Fungi | 47.4 | 6.28e-4 | NR | KAI9294075.1 | 1314799 | g4581 | i0 | 44.2 | 3.63517915309446 | 52 | 25 | 50.8 | 1 | 302 | 147 | 96 | 143 | KAI9294075.1 hypothetical protein K502DRAFT_274434, partial [Neoconidiobolus thromboides FSU 785] | diamond | 1116 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 31449115 | 31449115 | PRJEB81171_P_NODE_3956_length_333_cov_1.500000_g3829_i0 | PRJEB81171 | 3956 | 333 | 1.5 | 4.995 | Coemansia | 4863 | Fungi | Fungi | 91.7 | 6.7e-21 | NR | KAJ2258985.1 | 2663904 | g3829 | i0 | 54.8 | 7.14414414414414 | 84 | 37 | 75.7 | 1 | 332 | 81 | 59 | 141 | KAJ2258985.1 Phosphatidyl-N-methylethanolamine N-methyltransferase [Coemansia sp. RSA 376] | diamond | 2379 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 376 | |
| 31835686 | 31835686 | PRJEB81171_P_NODE_4297_length_320_cov_4.910931_g4170_i0 | PRJEB81171 | 4297 | 320 | 4.910931 | 15.7149792 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 131 | 9.64e-37 | NR | KAJ1675135.1 | 68401 | g4170 | i0 | 57.7 | 10.003125 | 97 | 41 | 90.9 | 0 | 292 | 2 | 6 | 102 | KAJ1675135.1 Protein component of the small (40S) ribosomal subunit [Spiromyces aspiralis] | diamond | 3201 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 32113453 | 32113453 | PRJEB81171_P_NODE_9598_length_244_cov_0.912281_g9471_i0 | PRJEB81171 | 9598 | 244 | 0.912281 | 2.22596564 | Coemansia | 4863 | Fungi | Fungi | 50.1 | 9.94e-5 | NR | KAJ2561916.1 | 2663887 | g9471 | i0 | 35.9 | 6.13524590163934 | 64 | 38 | 75 | 1 | 10 | 192 | 516 | 579 | KAJ2561916.1 multisubstrate pseudouridine synthase 7 [Coemansia sp. RSA 1822] | diamond | 1497 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 1822 | |
| 32626487 | 32626487 | PRJEB81171_P_NODE_6180_length_276_cov_1.428571_g6053_i0 | PRJEB81171 | 6180 | 276 | 1.428571 | 3.94285596 | Coemansia sp. RSA 552 | 2663883 | Fungi | Fungi | 100 | 2.49e-25 | NR | KAJ2162350.1 | 2663883 | g6053 | i0 | 53.5 | 0.934782608695652 | 86 | 36 | 89.1 | 1 | 25 | 270 | 6 | 91 | KAJ2162350.1 60S ribosomal protein L33 [Coemansia sp. RSA 552] | diamond | 258 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 552 |
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);;