contig_metadata
16 rows where bioproject = "PRJNA692200", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13426348 | 13426348 | PRJNA692200_S_NODE_1311_length_418_cov_9.785908_g1260_i0 | PRJNA692200 | 1311 | 418 | 9.785908 | 40.90509544 | Thamnocephalis sphaerospora | 78915 | Fungi | Fungi | 97.1 | 9.46e-23 | NR | RKP11106.1 | 78915 | g1260 | i0 | 76.6 | 0.45933014354067 | 64 | 15 | 45.9 | 0 | 414 | 223 | 69 | 132 | RKP11106.1 60S ribosomal protein L32 [Thamnocephalis sphaerospora] | diamond | 192 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 13426681 | 13426681 | PRJNA692200_S_NODE_5431_length_281_cov_3.306034_g5374_i0 | PRJNA692200 | 5431 | 281 | 3.306034 | 9.28995554 | Ancylistaceae | 34486 | Fungi | Fungi | 130 | 3.5699999999999995e-35 | NR | KXN73301.1 | 796925 | g5374 | i0 | 67.4 | 30.3309608540925 | 92 | 30 | 98.2 | 0 | 5 | 280 | 162 | 253 | KXN73301.1 40S ribosomal protein S2 [Conidiobolus coronatus NRRL 28638] | diamond | 8523 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 13933268 | 13933268 | PRJNA692200_S_NODE_6451_length_264_cov_2299.660465_g6394_i0 | PRJNA692200 | 6451 | 264 | 2299.660465 | 6071.1036276 | Fungi | 4751 | Fungi | Fungi | 99 | 3.05e-16 | NTclustered | gi|3786360|gb|AF031070.1|AF031070 | 61418 | g6394 | i0 | 90.541 | 28.0378787878788 | 74 | 7 | 28 | 0 | 145 | 218 | 240 | 313 | Spiromyces minutus 28S ribosomal RNA gene, partial sequence | blastn | 7402 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces minutus | |
| 22350330 | 22350330 | PRJNA692200_S_NODE_798_length_463_cov_808.908213_g758_i0 | PRJNA692200 | 798 | 463 | 808.908213 | 3745.24502619 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 98.6 | 2.8000000000000003e-23 | NR | KAI8872700.1 | 304332 | g758 | i0 | 41 | 0.758099352051836 | 117 | 61 | 75.8 | 1 | 445 | 95 | 13 | 121 | KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus] | diamond | 351 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 27441797 | 27441797 | PRJNA692200_S_NODE_16183_length_182_cov_1.902256_g16126_i0 | PRJNA692200 | 16183 | 182 | 1.902256 | 3.46210592 | Eukaryota | 2759 | Fungi | Fungi | 44.7 | 0.00286 | NR | KAI9477015.1 | 4864 | g16126 | i0 | 44.4 | 5.37362637362637 | 45 | 25 | 74.2 | 0 | 180 | 46 | 172 | 216 | KAI9477015.1 ribosome biogenesis protein SLX9-domain-containing protein [Coemansia mojavensis] | diamond | 978 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia mojavensis | |
| 27809301 | 27809301 | PRJNA692200_S_NODE_13524_length_196_cov_3.333333_g13467_i0 | PRJNA692200 | 13524 | 196 | 3.333333 | 6.53333268 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 52.8 | 5.78e-6 | NR | RKP12660.1 | 1907219 | g13467 | i0 | 62.8 | 0.658163265306122 | 43 | 16 | 65.8 | 0 | 196 | 68 | 187 | 229 | RKP12660.1 hypothetical protein BJ684DRAFT_20814 [Piptocephalis cylindrospora] | diamond | 129 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 28061627 | 28061627 | PRJNA692200_S_NODE_5685_length_276_cov_7.550661_g5628_i0 | PRJNA692200 | 5685 | 276 | 7.550661 | 20.83982436 | Entomophthora muscae | 34485 | Fungi | Fungi | 47 | 0.00168 | NR | KAJ9049438.1 | 34485 | g5628 | i0 | 41.3 | 2.05434782608696 | 63 | 37 | 68.5 | 0 | 2 | 190 | 321 | 383 | KAJ9049438.1 hypothetical protein DSO57_1024446 [Entomophthora muscae] | diamond | 567 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28787698 | 28787698 | PRJNA692200_S_NODE_17187_length_177_cov_2.195312_g17130_i0 | PRJNA692200 | 17187 | 177 | 2.195312 | 3.88570224 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 41.6 | 0.0413 | NR | KAI8872536.1 | 304332 | g17130 | i0 | 59.4 | 0.542372881355932 | 32 | 13 | 54.2 | 0 | 174 | 79 | 840 | 871 | KAI8872536.1 transmembrane protein, partial [Ramicandelaber brevisporus] | diamond | 96 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 29083486 | 29083486 | PRJNA692200_S_NODE_5868_length_273_cov_3.397321_g5811_i0 | PRJNA692200 | 5868 | 273 | 3.397321 | 9.27468633 | Opisthokonta | 33154 | Fungi | Fungi | 42.4 | 0.0356 | NR | KAI9472616.1 | 4864 | g5811 | i0 | 51.5 | 1.13186813186813 | 33 | 16 | 36.3 | 0 | 34 | 132 | 45 | 77 | KAI9472616.1 calmodulin [Coemansia mojavensis] | diamond | 309 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia mojavensis | |
| 29619717 | 29619717 | PRJNA692200_S_NODE_4190_length_307_cov_2.174419_g4133_i0 | PRJNA692200 | 4190 | 307 | 2.174419 | 6.67546633 | Coemansia | 4863 | Fungi | Fungi | 70.9 | 3.54e-12 | NR | PIA15603.1 | 763665 | g4133 | i0 | 43.6 | 2.29641693811075 | 78 | 44 | 76.2 | 0 | 304 | 71 | 155 | 232 | PIA15603.1 N-terminal nucleophile aminohydrolase [Coemansia reversa NRRL 1564] | diamond | 705 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia reversa | |
| 30145453 | 30145453 | PRJNA692200_S_NODE_5312_length_283_cov_4.098291_g5255_i0 | PRJNA692200 | 5312 | 283 | 4.098291 | 11.59816353 | Coemansia sp. RSA 2399 | 2849852 | Fungi | Fungi | 61.2 | 4.76e-9 | NR | KAJ1799834.1 | 2849852 | g5255 | i0 | 79.4 | 1.46289752650177 | 34 | 7 | 36 | 0 | 278 | 177 | 153 | 186 | KAJ1799834.1 60S ribosomal protein L18 [Coemansia sp. RSA 2399] | diamond | 414 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 2399 | |
| 30619613 | 30619613 | PRJNA692200_S_NODE_14253_length_192_cov_1.426573_g14196_i0 | PRJNA692200 | 14253 | 192 | 1.426573 | 2.73902016 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 48.9 | 1.21e-4 | NR | RKP12561.1 | 1907219 | g14196 | i0 | 63.9 | 1.09375 | 36 | 13 | 56.3 | 0 | 161 | 54 | 295 | 330 | RKP12561.1 kinase-like domain-containing protein, partial [Piptocephalis cylindrospora] | diamond | 210 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 31979085 | 31979085 | PRJNA692200_S_NODE_538_length_498_cov_24.429844_g505_i0 | PRJNA692200 | 538 | 498 | 24.429844 | 121.66062312 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 117 | 6.0599999999999994e-30 | NR | PVU86898.1 | 61424 | g505 | i0 | 41.8 | 0.807228915662651 | 134 | 78 | 80.7 | 0 | 7 | 408 | 31 | 164 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 402 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 32748977 | 32748977 | PRJNA692200_S_NODE_1240_length_423_cov_17.066845_g1192_i0 | PRJNA692200 | 1240 | 423 | 17.066845 | 72.19275435 | Fungi | 4751 | Fungi | Fungi | 70.1 | 5.84e-11 | NR | KAJ1917657.1 | 78921 | g1192 | i0 | 53 | 3.98581560283688 | 83 | 37 | 58.2 | 2 | 4 | 249 | 270 | 351 | KAJ1917657.1 60S ribosomal protein L4B [Tieghemiomyces parasiticus] | diamond | 1686 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Tieghemiomyces | Tieghemiomyces parasiticus | |
| 32843340 | 32843340 | PRJNA692200_S_NODE_18120_length_173_cov_1.645161_g18063_i0 | PRJNA692200 | 18120 | 173 | 1.645161 | 2.84612853 | Coemansia | 4863 | Fungi | Fungi | 62.8 | 1.23e-9 | NR | KAJ2467332.1 | 2663905 | g18063 | i0 | 54.4 | 3.95375722543353 | 57 | 26 | 98.8 | 0 | 1 | 171 | 434 | 490 | KAJ2467332.1 ubiquitin C-terminal hydrolase Ubp14, partial [Coemansia sp. RSA 2322] | diamond | 684 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 2322 | |
| 32843342 | 32843342 | PRJNA692200_S_NODE_300_length_553_cov_6.125000_g269_i0 | PRJNA692200 | 300 | 553 | 6.125 | 33.87125 | Harpellales | 61421 | Fungi | Fungi | 93.6 | 4.25e-21 | NR | PVU85474.1 | 61424 | g269 | i0 | 66.7 | 1.66546112115732 | 63 | 21 | 34.2 | 0 | 553 | 365 | 45 | 107 | PVU85474.1 hypothetical protein BB559_007000 [Furculomyces boomerangus] | diamond | 921 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus |
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);;