contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1241156" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5453092 | 5453092 | PRJNA1241156_S_NODE_17325_length_377_cov_1.455090_g16865_i0 | PRJNA1241156 | 17325 | 377 | 1.45509 | 5.4856893 | Microbotryomycetes sp. JL221 | 2987685 | Fungi | Fungi | 108 | 4.67e-25 | NR | KAK4057830.1 | 2987685 | g16865 | i0 | 73.8 | 1.05039787798408 | 65 | 17 | 51.7 | 0 | 3 | 197 | 386 | 450 | KAK4057830.1 Rab GDP dissociation inhibitor alpha [Microbotryomycetes sp. JL221] | diamond | 396 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryomycetes sp. JL221 | ||||
| 27407985 | 27407985 | PRJNA1241156_S_NODE_54883_length_264_cov_5.285068_g54423_i0 | PRJNA1241156 | 54883 | 264 | 5.285068 | 13.95257952 | Microbotryomycetes | 162481 | Fungi | Fungi | 51.2 | 4.94e-5 | NR | GAA5868794.1 | 86832 | g54423 | i0 | 88.5 | 2.65909090909091 | 26 | 3 | 29.5 | 0 | 3 | 80 | 794 | 819 | GAA5868794.1 hypothetical protein JCM3774_003897 [Rhodotorula dairenensis] | diamond | 702 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula dairenensis | |
| 27515943 | 27515943 | PRJNA1241156_S_NODE_66583_length_240_cov_3.172589_g66123_i0 | PRJNA1241156 | 66583 | 240 | 3.172589 | 7.6142136 | Kwoniella shivajii | 564305 | Fungi | Fungi | 42.4 | 0.0469 | NR | XP_062791250.1 | 564305 | g66123 | i0 | 50 | 0.575 | 46 | 18 | 51.3 | 1 | 21 | 143 | 165 | 210 | XP_062791250.1 pyridoxal kinase [Kwoniella shivajii] | diamond | 138 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 27642446 | 27642446 | PRJNA1241156_S_NODE_70204_length_229_cov_2.096774_g69744_i0 | PRJNA1241156 | 70204 | 229 | 2.096774 | 4.80161246 | Rhodotorula pacifica | 1495444 | Fungi | Fungi | 147 | 7.19e-44 | NR | GAA5987337.1 | 1495444 | g69744 | i0 | 86.7 | 0.982532751091703 | 75 | 10 | 98.3 | 0 | 227 | 3 | 32 | 106 | GAA5987337.1 hypothetical protein JCM10908_001914 [Rhodotorula pacifica] | diamond | 225 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula pacifica | |
| 27989635 | 27989635 | PRJNA1241156_S_NODE_61365_length_251_cov_1.028846_g60905_i0 | PRJNA1241156 | 61365 | 251 | 1.028846 | 2.58240346 | Rhodotorula taiwanensis | 741276 | Fungi | Fungi | 75.5 | 1.2e-13 | NR | POY73559.1 | 741276 | g60905 | i0 | 58.2 | 2.61752988047809 | 79 | 30 | 90.8 | 2 | 250 | 23 | 375 | 453 | POY73559.1 hypothetical protein BMF94_3497 [Rhodotorula taiwanensis] | diamond | 657 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula taiwanensis | |
| 28084182 | 28084182 | PRJNA1241156_S_NODE_32125_length_324_cov_3.355872_g31665_i0 | PRJNA1241156 | 32125 | 324 | 3.355872 | 10.87302528 | Malassezia japonica | 223818 | Fungi | Fungi | 45.4 | 0.00986 | NR | XP_060123056.1 | 223818 | g31665 | i0 | 41.2 | 0.472222222222222 | 51 | 30 | 47.2 | 0 | 300 | 148 | 38 | 88 | XP_060123056.1 uncharacterized protein MJAP1_003145 [Malassezia japonica] | diamond | 153 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 28178744 | 28178744 | PRJNA1241156_S_NODE_54746_length_265_cov_1.018018_g54286_i0 | PRJNA1241156 | 54746 | 265 | 1.018018 | 2.6977477 | Cryptococcus sp. DSM 1 | 2770025 | Fungi | Fungi | 43.5 | 0.0273 | NR | WVQ81446.1 | 2770025 | g54286 | i0 | 40 | 0.849056603773585 | 75 | 40 | 83.8 | 3 | 252 | 31 | 574 | 644 | WVQ81446.1 hypothetical protein IAT38_003570 [Cryptococcus sp. DSM 104549] | diamond | 225 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus sp. DSM 104549 | |
| 28354900 | 28354900 | PRJNA1241156_S_NODE_57906_length_258_cov_1.846512_g57446_i0 | PRJNA1241156 | 57906 | 258 | 1.846512 | 4.76400096 | Eukaryota | 2759 | Fungi | Fungi | 58.5 | 2.87e-9 | NR | KZO95808.1 | 1330018 | g57446 | i0 | 75.7 | 2.12790697674419 | 37 | 9 | 43 | 0 | 256 | 146 | 18 | 54 | KZO95808.1 hypothetical protein CALVIDRAFT_537790 [Calocera viscosa TUFC12733] | diamond | 549 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Calocera | Calocera viscosa | |
| 29126490 | 29126490 | PRJNA1241156_S_NODE_66929_length_239_cov_2.428571_g66469_i0 | PRJNA1241156 | 66929 | 239 | 2.428571 | 5.80428469 | Phanerochaete carnosa HHB-1 | 231932 | Fungi | Fungi | 44.3 | 0.0102 | NR | XP_007393530.1 | 650164 | g66469 | i0 | 37.8 | 0.564853556485356 | 45 | 26 | 56.5 | 1 | 137 | 3 | 677 | 719 | XP_007393530.1 uncharacterized protein PHACADRAFT_139912 [Phanerochaete carnosa HHB-10118-sp] | diamond | 135 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete carnosa | |
| 29997036 | 29997036 | PRJNA1241156_S_NODE_9831_length_425_cov_2.560209_g9375_i0 | PRJNA1241156 | 9831 | 425 | 2.560209 | 10.88088825 | Rhodotorula | 5533 | Fungi | Fungi | 49.7 | 0.00102 | NR | KAJ8294915.1 | 5286 | g9375 | i0 | 50.9 | 0.974117647058824 | 57 | 25 | 39.5 | 2 | 173 | 340 | 1022 | 1076 | KAJ8294915.1 hypothetical protein OF846_001984 [Rhodotorula toruloides] | diamond | 414 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 30863384 | 30863384 | PRJNA1241156_S_NODE_27314_length_339_cov_2.462838_g26854_i0 | PRJNA1241156 | 27314 | 339 | 2.462838 | 8.34902082 | Sporobolomyces phaffii | 183961 | Fungi | Fungi | 98.2 | 3.5400000000000006e-21 | NR | GAA6009477.1 | 183961 | g26854 | i0 | 88.7 | 0.469026548672566 | 53 | 6 | 46.9 | 0 | 1 | 159 | 477 | 529 | GAA6009477.1 hypothetical protein JCM11491_003572 [Sporobolomyces phaffii] | diamond | 159 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii | |
| 30989993 | 30989993 | PRJNA1241156_S_NODE_63294_length_247_cov_1.166667_g62834_i0 | PRJNA1241156 | 63294 | 247 | 1.166667 | 2.88166749 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 112 | 2.4699999999999997e-30 | NR | KAJ3535736.1 | 752674 | g62834 | i0 | 85.7 | 1.53036437246964 | 63 | 9 | 76.5 | 0 | 203 | 15 | 1 | 63 | KAJ3535736.1 hypothetical protein NMY22_g6353 [Coprinellus aureogranulatus] | diamond | 378 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus |
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);;