contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14635628 | 14635628 | PRJNA635874_P_NODE_12332_length_426_cov_1.589235_g12185_i0 | PRJNA635874 | 12332 | 426 | 1.589235 | 6.7701411 | Puccinia sorghi | 27349 | Fungi | Fungi | 158 | 1.46e-44 | NR | KNZ45269.1 | 27349 | g12185 | i0 | 54.6 | 13.6619718309859 | 141 | 63 | 98.6 | 1 | 424 | 5 | 38 | 178 | KNZ45269.1 ribosomal protein S5 [Puccinia sorghi] | diamond | 5820 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 27270581 | 27270581 | PRJNA635874_P_NODE_73023_length_241_cov_0.916667_g72876_i0 | PRJNA635874 | 73023 | 241 | 0.916667 | 2.20916747 | Peniophora sp. CBMAI 1 | 1756134 | Fungi | Fungi | 79 | 1.74e-15 | NR | VDB92526.1 | 718367 | g72876 | i0 | 65.6 | 4.91701244813278 | 64 | 19 | 78.4 | 2 | 189 | 1 | 18 | 79 | VDB92526.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 1185 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 27599157 | 27599157 | PRJNA635874_P_NODE_21024_length_346_cov_1.128205_g20877_i0 | PRJNA635874 | 21024 | 346 | 1.128205 | 3.9035893 | Fungi | 4751 | Fungi | Fungi | 166 | 6.81e-46 | NR | KZV74259.1 | 1314672 | g20877 | i0 | 66.4 | 16.6387283236994 | 113 | 38 | 98 | 0 | 346 | 8 | 298 | 410 | KZV74259.1 fumarate reductase [Peniophora sp. CONT] | diamond | 5757 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CONT | |
| 27870555 | 27870555 | PRJNA635874_P_NODE_51825_length_249_cov_0.875000_g51678_i0 | PRJNA635874 | 51825 | 249 | 0.875 | 2.17875 | Tilletia horrida | 155126 | Fungi | Fungi | 73.2 | 7.87e-13 | NR | KAK0550592.1 | 155126 | g51678 | i0 | 58.6 | 1.31325301204819 | 58 | 24 | 69.9 | 0 | 73 | 246 | 1 | 58 | KAK0550592.1 hypothetical protein OC846_003607 [Tilletia horrida] | diamond | 327 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida | |
| 28155036 | 28155036 | PRJNA635874_P_NODE_64005_length_244_cov_0.900585_g63858_i0 | PRJNA635874 | 64005 | 244 | 0.900585 | 2.1974274 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 144 | 4.92e-39 | NR | XP_066824737.1 | 1397322 | g63858 | i0 | 81.5 | 0.995901639344262 | 81 | 15 | 99.6 | 0 | 244 | 2 | 163 | 243 | XP_066824737.1 carbamoyl-phosphate synthase [Cystobasidium minutum MCA 4210] | diamond | 243 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 28691799 | 28691799 | PRJNA635874_P_NODE_23227_length_333_cov_2.665385_g23080_i0 | PRJNA635874 | 23227 | 333 | 2.665385 | 8.87573205 | Blastosporella zonata | 530045 | Fungi | Fungi | 103 | 5.47e-25 | NR | KAG6849087.1 | 530045 | g23080 | i0 | 44.8 | 0.945945945945946 | 105 | 51 | 88.3 | 1 | 3 | 296 | 94 | 198 | KAG6849087.1 hypothetical protein C0991_012153, partial [Blastosporella zonata] | diamond | 315 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Blastosporella | Blastosporella zonata | |
| 28944486 | 28944486 | PRJNA635874_P_NODE_6748_length_546_cov_1.021142_g6603_i0 | PRJNA635874 | 6748 | 546 | 1.021142 | 5.57543532 | Naematelia encephala | 71784 | Fungi | Fungi | 183 | 3.29e-53 | NR | ORY30542.1 | 71784 | g6603 | i0 | 53.2 | 1.92857142857143 | 173 | 80 | 95.1 | 1 | 544 | 26 | 112 | 283 | ORY30542.1 zinc-type alcohol dehydrogenase [Naematelia encephala] | diamond | 1053 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 29102134 | 29102134 | PRJNA635874_P_NODE_63928_length_244_cov_0.900585_g63781_i0 | PRJNA635874 | 63928 | 244 | 0.900585 | 2.1974274 | Serendipita vermifera MAFF 3 | 109899 | Fungi | Fungi | 99.8 | 7.44e-24 | NR | KIM24181.1 | 933852 | g63781 | i0 | 63.9 | 0.885245901639344 | 72 | 26 | 88.5 | 0 | 27 | 242 | 12 | 83 | KIM24181.1 hypothetical protein M408DRAFT_331933 [Serendipita vermifera MAFF 305830] | diamond | 216 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 29638412 | 29638412 | PRJNA635874_P_NODE_28850_length_307_cov_1.316239_g28703_i0 | PRJNA635874 | 28850 | 307 | 1.316239 | 4.04085373 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 102 | 1.94e-25 | NR | KAG8920536.1 | 2600225 | g28703 | i0 | 52 | 2.93159609120521 | 100 | 48 | 97.7 | 0 | 4 | 303 | 8 | 107 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 900 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 | |
| 29777483 | 29777483 | PRJNA635874_P_NODE_52831_length_249_cov_0.875000_g52684_i0 | PRJNA635874 | 52831 | 249 | 0.875 | 2.17875 | Basidiomycota | 5204 | Fungi | Fungi | 68.2 | 4.36e-11 | NR | KNZ50850.1 | 27349 | g52684 | i0 | 93.9 | 8.59036144578313 | 33 | 2 | 39.8 | 0 | 147 | 245 | 544 | 576 | KNZ50850.1 dihydroxy-acid dehydratase [Puccinia sorghi] | diamond | 2139 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 30238945 | 30238945 | PRJNA635874_P_NODE_47112_length_251_cov_0.865169_g46965_i0 | PRJNA635874 | 47112 | 251 | 0.865169 | 2.17157419 | Hypholoma sublateritium FD-334 SS-4 | 945553 | Fungi | Fungi | 148 | 4.2399999999999996e-42 | NR | KJA24058.1 | 945553 | g46965 | i0 | 93.9 | 0.9800796812749 | 82 | 5 | 98 | 0 | 246 | 1 | 157 | 238 | KJA24058.1 hypothetical protein HYPSUDRAFT_39191 [Hypholoma sublateritium FD-334 SS-4] | diamond | 246 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Hypholoma | Hypholoma sublateritium | |
| 30270821 | 30270821 | PRJNA635874_P_NODE_71272_length_242_cov_0.911243_g71125_i0 | PRJNA635874 | 71272 | 242 | 0.911243 | 2.20520806 | Cryptococcus neoformans var. neoformans JEC21 | 5207 | Fungi | Fungi | 88.2 | 1.13e-18 | NR | XP_024513401.1 | 214684 | g71125 | i0 | 59.2 | 1.7603305785124 | 71 | 29 | 88 | 0 | 215 | 3 | 3 | 73 | XP_024513401.1 hypothetical protein CNH03320 [Cryptococcus neoformans var. neoformans JEC21] | diamond | 426 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus deneoformans | |
| 30397417 | 30397417 | PRJNA635874_P_NODE_60473_length_246_cov_0.890173_g60326_i0 | PRJNA635874 | 60473 | 246 | 0.890173 | 2.18982558 | Tephrocybe rancida | 117070 | Fungi | Fungi | 98.2 | 1.1200000000000002e-21 | NR | KAG6907077.1 | 117070 | g60326 | i0 | 68.7 | 1.63414634146341 | 67 | 21 | 81.7 | 0 | 41 | 241 | 48 | 114 | KAG6907077.1 hypothetical protein DXG01_010649 [Tephrocybe rancida] | diamond | 402 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Tephrocybe | Tephrocybe rancida | |
| 30491774 | 30491774 | PRJNA635874_P_NODE_31173_length_298_cov_1.191111_g31026_i0 | PRJNA635874 | 31173 | 298 | 1.191111 | 3.54951078 | Rhodotorula toruloides NP11 | 1130832 | Fungi | Fungi | 75.1 | 7.27e-15 | NR | XP_016274852.1 | 1130832 | g31026 | i0 | 50.5 | 1.97315436241611 | 97 | 31 | 97.7 | 1 | 291 | 1 | 30 | 109 | XP_016274852.1 60S ribosomal protein l35 [Rhodotorula toruloides NP11] | diamond | 588 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 31281595 | 31281595 | PRJNA635874_P_NODE_60655_length_246_cov_0.890173_g60508_i0 | PRJNA635874 | 60655 | 246 | 0.890173 | 2.18982558 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 60.5 | 2.19e-8 | NR | KLT39384.1 | 879819 | g60508 | i0 | 63.4 | 0.5 | 41 | 15 | 50 | 0 | 114 | 236 | 171 | 211 | KLT39384.1 hypothetical protein CC85DRAFT_288569 [Cutaneotrichosporon oleaginosum] | diamond | 123 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 31471623 | 31471623 | PRJNA635874_P_NODE_32376_length_293_cov_1.400000_g32229_i0 | PRJNA635874 | 32376 | 293 | 1.4 | 4.102 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 95.5 | 1.99e-20 | NR | KAJ3504887.1 | 752674 | g32229 | i0 | 47.3 | 0.95221843003413 | 93 | 49 | 95.2 | 0 | 13 | 291 | 358 | 450 | KAJ3504887.1 hypothetical protein NMY22_g17771 [Coprinellus aureogranulatus] | diamond | 279 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus | |
| 31787555 | 31787555 | PRJNA635874_P_NODE_37277_length_277_cov_1.509804_g37130_i0 | PRJNA635874 | 37277 | 277 | 1.509804 | 4.18215708 | Naematelia encephala | 71784 | Fungi | Fungi | 92.4 | 1.73e-22 | NR | ORY35885.1 | 71784 | g37130 | i0 | 71.2 | 2.18772563176895 | 66 | 19 | 71.5 | 0 | 252 | 55 | 1 | 66 | ORY35885.1 40S ribosomal protein S30 [Naematelia encephala] | diamond | 606 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 32547348 | 32547348 | PRJNA635874_P_NODE_66379_length_243_cov_0.905882_g66232_i0 | PRJNA635874 | 66379 | 243 | 0.905882 | 2.20129326 | Marasmius sp. AFHP31 | 3065222 | Fungi | Fungi | 43.1 | 0.0101 | NR | KAK1233361.1 | 3065222 | g66232 | i0 | 50 | 0.493827160493827 | 40 | 19 | 49.4 | 1 | 34 | 153 | 38 | 76 | KAK1233361.1 hypothetical protein PQX77_003470 [Marasmius sp. AFHP31] | diamond | 120 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius sp. AFHP31 | |
| 32862060 | 32862060 | PRJNA635874_P_NODE_56760_length_247_cov_0.885057_g56613_i0 | PRJNA635874 | 56760 | 247 | 0.885057 | 2.18609079 | Dacryopinax primogenitus | 1858805 | Fungi | Fungi | 52.4 | 6.99e-6 | NR | XP_040624592.1 | 1858805 | g56613 | i0 | 68.6 | 0.425101214574899 | 35 | 11 | 42.5 | 0 | 142 | 246 | 1 | 35 | XP_040624592.1 ARF/SAR [Dacryopinax primogenitus] | diamond | 105 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Dacryopinax | Dacryopinax primogenitus |
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);;