contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1582459 | 1582459 | PRJNA1159911_P_NODE_43042_length_382_cov_14.009709_g42500_i0 | PRJNA1159911 | 43042 | 382 | 14.009709 | 53.51708838 | Austropuccinia psidii | 181123 | Fungi | Fungi | 157 | 3.259999999999999e-47 | NR | MBW0489473.1 | 1389203 | g42500 | i0 | 85.7 | 2.73298429319372 | 84 | 12 | 66 | 0 | 353 | 102 | 1 | 84 | MBW0489473.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 1044 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 10512063 | 10512063 | PRJNA1159911_P_NODE_69929_length_284_cov_1.165877_g69387_i0 | PRJNA1159911 | 69929 | 284 | 1.165877 | 3.31109068 | Sphaerobolus stellatus SS14 | 990650 | Fungi | Fungi | 91.3 | 1.51e-19 | NR | KIJ38911.1 | 990650 | g69387 | i0 | 45.2 | 1.09859154929577 | 104 | 39 | 90.8 | 2 | 19 | 276 | 68 | 171 | KIJ38911.1 hypothetical protein M422DRAFT_32976 [Sphaerobolus stellatus SS14] | diamond | 312 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Sphaerobolaceae | Sphaerobolus | Sphaerobolus stellatus | |
| 11786856 | 11786856 | PRJNA1159911_P_NODE_64150_length_298_cov_1.715556_g63608_i0 | PRJNA1159911 | 64150 | 298 | 1.715556 | 5.11235688 | Agaricomycetes | 155619 | Fungi | Fungi | 114 | 4.9600000000000006e-27 | NR | TFK42018.1 | 68775 | g63608 | i0 | 68.6 | 17.1946308724832 | 86 | 27 | 86.6 | 0 | 260 | 3 | 61 | 146 | TFK42018.1 carbamoyl-phosphate synthase L chain, ATP binding domain-containing protein [Crucibulum laeve] | diamond | 5124 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Crucibulum | Crucibulum laeve | |
| 24534492 | 24534492 | PRJNA1159911_P_NODE_7780_length_1216_cov_21.427822_g7430_i0 | PRJNA1159911 | 7780 | 1216 | 21.427822 | 260.56231552 | Opisthokonta | 33154 | Fungi | Fungi | 362 | 5.64e-120 | NR | CED82942.1 | 264483 | g7430 | i0 | 65.6 | 22.4013157894737 | 311 | 105 | 76.7 | 1 | 37 | 969 | 29 | 337 | CED82942.1 G protein beta subunit-like protein [Phaffia rhodozyma] | diamond | 27240 | 364 | 0.994505494505495 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Phaffia | Phaffia rhodozyma | |
| 26775009 | 26775009 | PRJNA1159911_P_NODE_104881_length_204_cov_4.442748_g104339_i0 | PRJNA1159911 | 104881 | 204 | 4.442748 | 9.06320592 | Opisthokonta | 33154 | Fungi | Fungi | 138 | 4.15e-38 | NR | KAF9487340.1 | 5323 | g104339 | i0 | 97.1 | 345.970588235294 | 68 | 2 | 100 | 0 | 1 | 204 | 86 | 153 | KAF9487340.1 AAA-domain-containing protein [Pleurotus eryngii] | diamond | 70578 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus eryngii | |
| 27988033 | 27988033 | PRJNA1159911_P_NODE_83185_length_257_cov_1.614130_g82643_i0 | PRJNA1159911 | 83185 | 257 | 1.61413 | 4.1483141 | Laccaria amethystina LaAM- | 89243 | Fungi | Fungi | 53.5 | 5.2e-7 | NR | KIJ97987.1 | 1095629 | g82643 | i0 | 50 | 1.19066147859922 | 66 | 32 | 75.9 | 1 | 11 | 205 | 10 | 75 | KIJ97987.1 hypothetical protein K443DRAFT_681124, partial [Laccaria amethystina LaAM-08-1] | diamond | 306 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hydnangiaceae | Laccaria | Laccaria amethystina | |
| 28808568 | 28808568 | PRJNA1159911_P_NODE_99828_length_242_cov_0.911243_g99286_i0 | PRJNA1159911 | 99828 | 242 | 0.911243 | 2.20520806 | Serpula lacrymans var. lacrymans S7.9 | 578457 | Fungi | Fungi | 65.9 | 2.63e-10 | NR | XP_007317510.1 | 578457 | g99286 | i0 | 85.7 | 1.30165289256198 | 35 | 5 | 43.4 | 0 | 1 | 105 | 335 | 369 | XP_007317510.1 uncharacterized protein SERLADRAFT_348456 [Serpula lacrymans var. lacrymans S7.9] | diamond | 315 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Serpulaceae | Serpula | Serpula lacrymans | |
| 28828059 | 28828059 | PRJNA1159911_P_NODE_93728_length_246_cov_0.890173_g93186_i0 | PRJNA1159911 | 93728 | 246 | 0.890173 | 2.18982558 | Suillus | 5379 | Fungi | Fungi | 64.3 | 3.28e-10 | NR | XP_041245179.1 | 48586 | g93186 | i0 | 43.1 | 8.20731707317073 | 72 | 34 | 79.3 | 2 | 197 | 3 | 85 | 156 | XP_041245179.1 uncharacterized protein DFJ58DRAFT_876203 [Suillus subalutaceus] | diamond | 2019 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus subalutaceus | |
| 29093219 | 29093219 | PRJNA1159911_P_NODE_85368_length_253_cov_1.744444_g84826_i0 | PRJNA1159911 | 85368 | 253 | 1.744444 | 4.41344332 | Jaapia argillacea MUCL 336 | 202697 | Fungi | Fungi | 43.5 | 0.00568 | NR | KDQ55826.1 | 933084 | g84826 | i0 | 35 | 0.711462450592885 | 60 | 39 | 71.1 | 0 | 242 | 63 | 8 | 67 | KDQ55826.1 hypothetical protein JAAARDRAFT_330681 [Jaapia argillacea MUCL 33604] | diamond | 180 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Jaapiales | Jaapiaceae | Jaapia | Jaapia argillacea | |
| 29617205 | 29617205 | PRJNA1159911_P_NODE_35050_length_441_cov_2.918478_g34508_i0 | PRJNA1159911 | 35050 | 441 | 2.918478 | 12.87048798 | Agaricales | 5338 | Fungi | Fungi | 50.1 | 6.36e-4 | NR | KAF8803922.1 | 171480 | g34508 | i0 | 37.9 | 1.46938775510204 | 58 | 36 | 39.5 | 0 | 315 | 142 | 95 | 152 | KAF8803922.1 HMG-box [Phlegmacium glaucopus] | diamond | 648 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Cortinariaceae | Phlegmacium | Phlegmacium glaucopus | |
| 30419871 | 30419871 | PRJNA1159911_P_NODE_50333_length_346_cov_0.992674_g49791_i0 | PRJNA1159911 | 50333 | 346 | 0.992674 | 3.43465204 | Malassezia sp. CBS 17886 | 3031751 | Fungi | Fungi | 61.2 | 3.95e-8 | NR | WFD29787.1 | 3031751 | g49791 | i0 | 42 | 0.763005780346821 | 88 | 51 | 76.3 | 0 | 73 | 336 | 309 | 396 | WFD29787.1 hypothetical protein MSPP1_000800 [Malassezia sp. CBS 17886] | diamond | 264 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sp. CBS 17886 | |
| 32019570 | 32019570 | PRJNA1159911_P_NODE_77518_length_267_cov_2.618557_g76976_i0 | PRJNA1159911 | 77518 | 267 | 2.618557 | 6.99154719 | Agaricales | 5338 | Fungi | Fungi | 69.3 | 3.03e-13 | NR | KAF9073185.1 | 206335 | g76976 | i0 | 54.9 | 2.8988764044943802 | 51 | 23 | 57.3 | 0 | 6 | 158 | 1 | 51 | KAF9073185.1 hypothetical protein BDP27DRAFT_1319019 [Rhodocollybia butyracea] | diamond | 774 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Rhodocollybia | Rhodocollybia butyracea | |
| 32190136 | 32190136 | PRJNA1159911_P_NODE_93618_length_246_cov_1.254335_g93076_i0 | PRJNA1159911 | 93618 | 246 | 1.254335 | 3.0856641 | Sphagnurus paluster | 117069 | Fungi | Fungi | 95.9 | 2.01e-21 | NR | KAG5634805.1 | 117069 | g93076 | i0 | 73.7 | 1.40243902439024 | 57 | 15 | 69.5 | 0 | 5 | 175 | 285 | 341 | KAG5634805.1 hypothetical protein H0H81_000716 [Sphagnurus paluster] | diamond | 345 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Sphagnurus | Sphagnurus paluster | |
| 32380017 | 32380017 | PRJNA1159911_P_NODE_75119_length_272_cov_1.924623_g74577_i0 | PRJNA1159911 | 75119 | 272 | 1.924623 | 5.23497456 | Dendrothele bispora CBS 962.96 | 1314807 | Fungi | Fungi | 43.1 | 0.0385 | NR | THU93876.1 | 1314807 | g74577 | i0 | 38.1 | 0.694852941176471 | 63 | 36 | 69.5 | 2 | 191 | 3 | 222 | 281 | THU93876.1 kinase-like protein [Dendrothele bispora CBS 962.96] | diamond | 189 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Dendrothele | Dendrothele bispora | ||
| 32758651 | 32758651 | PRJNA1159911_P_NODE_76240_length_270_cov_1.553299_g75698_i0 | PRJNA1159911 | 76240 | 270 | 1.553299 | 4.1939073 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 43.1 | 0.0369 | NR | KAJ3545387.1 | 752674 | g75698 | i0 | 56.4 | 0.433333333333333 | 39 | 17 | 43.3 | 0 | 1 | 117 | 348 | 386 | KAJ3545387.1 hypothetical protein NMY22_g2464 [Coprinellus aureogranulatus] | diamond | 117 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus | |
| 32777776 | 32777776 | PRJNA1159911_P_NODE_72060_length_279_cov_1.165049_g71518_i0 | PRJNA1159911 | 72060 | 279 | 1.165049 | 3.25048671 | Fungi | 4751 | Fungi | Fungi | 104 | 9.49e-27 | NR | XP_017991365.1 | 77020 | g71518 | i0 | 60.3 | 3.9247311827957 | 73 | 29 | 78.5 | 0 | 220 | 2 | 15 | 87 | XP_017991365.1 60s ribosomal protein l33-a-like protein [Malassezia pachydermatis] | diamond | 1095 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis |
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);;