contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA951388" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18786497 | 18786497 | PRJNA951388_S_NODE_5695_length_355_cov_2.457447_g5568_i0 | PRJNA951388 | 5695 | 355 | 2.457447 | 8.72393685 | Agaricomycetes | 155619 | Fungi | Fungi | 149 | 1.3999999999999996e-41 | NR | KAF4596184.1 | 28995 | g5568 | i0 | 88.5 | 3.27887323943662 | 78 | 9 | 65.9 | 0 | 355 | 122 | 218 | 295 | KAF4596184.1 iso-1-cytochrome c [Pleurotus pulmonarius] | diamond | 1164 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus pulmonarius | |
| 27531131 | 27531131 | PRJNA951388_S_NODE_8643_length_286_cov_2.389671_g8516_i0 | PRJNA951388 | 8643 | 286 | 2.389671 | 6.83445906 | Ustilago hordei | 120017 | Fungi | Fungi | 68.2 | 8.22e-12 | NR | XP_041416199.1 | 120017 | g8516 | i0 | 50.5 | 0.954545454545455 | 91 | 45 | 95.5 | 0 | 278 | 6 | 64 | 154 | XP_041416199.1 uncharacterized protein UHO2_05450 [Ustilago hordei] | diamond | 273 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago hordei | |
| 27752360 | 27752360 | PRJNA951388_S_NODE_10844_length_249_cov_2.448864_g10717_i0 | PRJNA951388 | 10844 | 249 | 2.448864 | 6.09767136 | Tilletiaria anomala UBC 951 | 1037660 | Fungi | Fungi | 84.3 | 8.95e-17 | NR | XP_013241818.1 | 1037660 | g10717 | i0 | 46.1 | 1.07228915662651 | 89 | 35 | 91.6 | 1 | 17 | 244 | 538 | 626 | XP_013241818.1 putative RSA4-WD-repeat protein [Tilletiaria anomala UBC 951] | diamond | 267 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Tilletiariaceae | Tilletiaria | Tilletiaria anomala | |
| 27973217 | 27973217 | PRJNA951388_S_NODE_3025_length_450_cov_4.687003_g2898_i0 | PRJNA951388 | 3025 | 450 | 4.687003 | 21.0915135 | Coprinopsis marcescibilis | 230819 | Fungi | Fungi | 91.7 | 8.84e-20 | NR | TFK30504.1 | 230819 | g2898 | i0 | 36.6 | 0.966666666666667 | 145 | 86 | 92.7 | 2 | 3 | 419 | 49 | 193 | TFK30504.1 acyl-CoA N-acyltransferase [Coprinopsis marcescibilis] | diamond | 435 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis marcescibilis | |
| 28004992 | 28004992 | PRJNA951388_S_NODE_11665_length_237_cov_2.128049_g11538_i0 | PRJNA951388 | 11665 | 237 | 2.128049 | 5.04347613 | Ceratobasidium sp. AG-I | 305860 | Fungi | Fungi | 99.8 | 1.73e-22 | NR | KAF8609027.1 | 305860 | g11538 | i0 | 88.7 | 0.670886075949367 | 53 | 6 | 67.1 | 0 | 235 | 77 | 391 | 443 | KAF8609027.1 DNA glycosylase [Ceratobasidium sp. AG-I] | diamond | 159 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-I | |
| 28225526 | 28225526 | PRJNA951388_S_NODE_7866_length_301_cov_6.486842_g7739_i0 | PRJNA951388 | 7866 | 301 | 6.486842 | 19.52539442 | Cryptococcus sp. DSM 1 | 2770025 | Fungi | Fungi | 58.5 | 2.09e-7 | NR | WVQ84312.1 | 2770025 | g7739 | i0 | 51.8 | 1.00664451827243 | 56 | 27 | 55.8 | 0 | 270 | 103 | 124 | 179 | WVQ84312.1 hypothetical protein IAT38_006464 [Cryptococcus sp. DSM 104549] | diamond | 303 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus sp. DSM 104549 | |
| 29394099 | 29394099 | PRJNA951388_S_NODE_1529_length_558_cov_42.224742_g1408_i0 | PRJNA951388 | 1529 | 558 | 42.224742 | 235.61406036 | Phakopsora pachyrhizi | 170000 | Fungi | Fungi | 184 | 2.18e-56 | NR | KAI8455471.1 | 170000 | g1408 | i0 | 67.8 | 0.768817204301075 | 143 | 45 | 76.9 | 1 | 481 | 53 | 3 | 144 | KAI8455471.1 dUTP diphosphatase [Phakopsora pachyrhizi] | diamond | 429 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 29709343 | 29709343 | PRJNA951388_S_NODE_8110_length_297_cov_1.375000_g7983_i0 | PRJNA951388 | 8110 | 297 | 1.375 | 4.08375 | Leucosporidium creatinivorum | 106004 | Fungi | Fungi | 41.6 | 0.0488 | NR | ORY89134.1 | 106004 | g7983 | i0 | 30.3 | 0.767676767676768 | 76 | 50 | 76.8 | 1 | 296 | 69 | 35 | 107 | ORY89134.1 hypothetical protein BCR35DRAFT_262791, partial [Leucosporidium creatinivorum] | diamond | 228 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium creatinivorum | |
| 29810911 | 29810911 | PRJNA951388_S_NODE_2691_length_466_cov_25.071247_g2564_i0 | PRJNA951388 | 2691 | 466 | 25.071247 | 116.83201102 | Fungi | 4751 | Fungi | Fungi | 112 | 3.8999999999999995e-28 | NR | KAI5121314.1 | 135589 | g2564 | i0 | 45.5 | 10.3197424892704 | 112 | 60 | 72.1 | 1 | 61 | 396 | 47 | 157 | KAI5121314.1 hypothetical protein M0805_003781 [Coniferiporia weirii] | diamond | 4809 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Coniferiporia | Coniferiporia weirii | |
| 30057055 | 30057055 | PRJNA951388_S_NODE_6231_length_340_cov_2.479401_g6104_i0 | PRJNA951388 | 6231 | 340 | 2.479401 | 8.4299634 | Tremellales sp. Tagirdzhanova- | 1920939 | Fungi | Fungi | 101 | 2.08e-22 | NR | CAD6576720.1 | 2778382 | g6104 | i0 | 51.5 | 1.76470588235294 | 99 | 47 | 87.4 | 1 | 3 | 299 | 68 | 165 | CAD6576720.1 MAG: hypothetical protein TREMPRED_001751 [Tremellales sp. Tagirdzhanova-0007] | diamond | 600 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Tagirdzhanova-0007 | |||
| 30183546 | 30183546 | PRJNA951388_S_NODE_1832_length_527_cov_18.645374_g1709_i0 | PRJNA951388 | 1832 | 527 | 18.645374 | 98.26112098 | Violaceomyces palustris | 1673888 | Fungi | Fungi | 148 | 3.6e-42 | NR | PWN52911.1 | 1673888 | g1709 | i0 | 58 | 1.31499051233397 | 119 | 50 | 67.7 | 0 | 12 | 368 | 13 | 131 | PWN52911.1 hypothetical protein IE53DRAFT_384625 [Violaceomyces palustris] | diamond | 693 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Violaceomycetales | Violaceomycetaceae | Violaceomyces | Violaceomyces palustris | |
| 30625731 | 30625731 | PRJNA951388_S_NODE_8693_length_285_cov_2.948113_g8566_i0 | PRJNA951388 | 8693 | 285 | 2.948113 | 8.40212205 | Dentipellis sp. KUC8613 | 1883078 | Fungi | Fungi | 43.1 | 0.0451 | NR | KAA1473330.1 | 1883078 | g8566 | i0 | 46.3 | 0.431578947368421 | 41 | 22 | 43.2 | 0 | 232 | 110 | 103 | 143 | KAA1473330.1 hypothetical protein DENSPDRAFT_872739 [Dentipellis sp. KUC8613] | diamond | 123 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Dentipellis | Dentipellis sp. KUC8613 | |
| 31574318 | 31574318 | PRJNA951388_S_NODE_8996_length_279_cov_3.053398_g8869_i0 | PRJNA951388 | 8996 | 279 | 3.053398 | 8.51898042 | Rhizoctonia solani | 456999 | Fungi | Fungi | 47 | 0.00183 | NR | XP_043182239.1 | 456999 | g8869 | i0 | 37 | 1.93548387096774 | 46 | 29 | 49.5 | 0 | 4 | 141 | 408 | 453 | XP_043182239.1 Transposable element Tcb2 transposase [Rhizoctonia solani] | diamond | 540 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 31738689 | 31738689 | PRJNA951388_S_NODE_7937_length_300_cov_2.321586_g7810_i0 | PRJNA951388 | 7937 | 300 | 2.321586 | 6.964758 | Fungi | 4751 | Fungi | Fungi | 97.8 | 3.4300000000000004e-21 | NR | KNZ56008.1 | 27349 | g7810 | i0 | 72.2 | 3.22 | 54 | 15 | 54 | 0 | 4 | 165 | 180 | 233 | KNZ56008.1 hypothetical protein VP01_2520g2 [Puccinia sorghi] | diamond | 966 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 31833589 | 31833589 | PRJNA951388_S_NODE_9237_length_275_cov_1.143564_g9110_i0 | PRJNA951388 | 9237 | 275 | 1.143564 | 3.144801 | Fungi | 4751 | Fungi | Fungi | 128 | 8.589999999999998e-35 | NR | KLO19263.1 | 27342 | g9110 | i0 | 67 | 87.2072727272727 | 91 | 30 | 99.3 | 0 | 275 | 3 | 33 | 123 | KLO19263.1 ras-domain-containing protein [Schizopora paradoxa] | diamond | 23982 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 32523570 | 32523570 | PRJNA951388_S_NODE_2319_length_488_cov_7.378313_g2193_i0 | PRJNA951388 | 2319 | 488 | 7.378313 | 36.00616744 | Kwoniella newhampshirensis | 1651941 | Fungi | Fungi | 58.2 | 1.83e-6 | NR | XP_066803647.1 | 1651941 | g2193 | i0 | 31.5 | 0.915983606557377 | 149 | 99 | 89.8 | 2 | 7 | 444 | 351 | 499 | XP_066803647.1 hypothetical protein IAR55_003036 [Kwoniella newhampshirensis] | diamond | 447 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella newhampshirensis |
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);;