contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1073712" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19313354 | 19313354 | PRJNA1073712_P_NODE_8336_length_279_cov_1.121359_g8253_i0 | PRJNA1073712 | 8336 | 279 | 1.121359 | 3.12859161 | Pluteus cervinus | 181527 | Fungi | Fungi | 110 | 3.2499999999999998e-28 | NR | TFK71644.1 | 181527 | g8253 | i0 | 65.2 | 30.6989247311828 | 89 | 29 | 93.5 | 1 | 16 | 276 | 36 | 124 | TFK71644.1 40S ribosomal protein S15 [Pluteus cervinus] | diamond | 8565 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Pluteus | Pluteus cervinus | |
| 23139960 | 23139960 | PRJNA1073712_P_NODE_6639_length_301_cov_1.315789_g6556_i0 | PRJNA1073712 | 6639 | 301 | 1.315789 | 3.96052489 | Eukaryota | 2759 | Fungi | Fungi | 190 | 1.0799999999999999e-54 | NR | KAJ3755836.1 | 153919 | g6556 | i0 | 86 | 50.8305647840532 | 100 | 14 | 99.7 | 0 | 1 | 300 | 268 | 367 | KAJ3755836.1 heat-shock protein 90 [Lentinula raphanica] | diamond | 15300 | 191 | 0.994764397905759 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula raphanica | |
| 26647195 | 26647195 | PRJNA1073712_P_NODE_16201_length_242_cov_0.911243_g16118_i0 | PRJNA1073712 | 16201 | 242 | 0.911243 | 2.20520806 | Physalacriaceae | 862241 | Fungi | Fungi | 105 | 1.35e-24 | NR | KAF8913697.1 | 139077 | g16118 | i0 | 83.3 | 1.78512396694215 | 72 | 10 | 89.3 | 1 | 241 | 26 | 355 | 424 | KAF8913697.1 magnesium transporter NIPA-domain-containing protein, partial [Mucidula mucida] | diamond | 432 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Mucidula | Mucidula mucida | |
| 27825620 | 27825620 | PRJNA1073712_P_NODE_16744_length_241_cov_0.916667_g16661_i0 | PRJNA1073712 | 16744 | 241 | 0.916667 | 2.20916747 | Trametes meyenii | 526243 | Fungi | Fungi | 68.9 | 2.21e-11 | NR | KAI0652399.1 | 526243 | g16661 | i0 | 43.1 | 2.60165975103734 | 72 | 39 | 89.6 | 1 | 16 | 231 | 805 | 874 | KAI0652399.1 hypothetical protein C8Q79DRAFT_1081591 [Trametes meyenii] | diamond | 627 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes meyenii | |
| 29964210 | 29964210 | PRJNA1073712_P_NODE_211_length_1128_cov_2.126066_g163_i0 | PRJNA1073712 | 211 | 1128 | 2.126066 | 23.98202448 | Agaricomycetes | 155619 | Fungi | Fungi | 121 | 5.440000000000001e-26 | NR | KAF8589545.1 | 113071 | g163 | i0 | 42.3 | 0.970744680851064 | 111 | 60 | 28.5 | 1 | 901 | 581 | 707 | 817 | KAF8589545.1 cysteine proteinase [Ramaria rubella] | diamond | 1095 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Ramaria | Ramaria rubella | |
| 29972599 | 29972599 | PRJNA1073712_P_NODE_10971_length_252_cov_1.564246_g10888_i0 | PRJNA1073712 | 10971 | 252 | 1.564246 | 3.94189992 | Mycena chlorophos | 658473 | Fungi | Fungi | 68.9 | 2.39e-11 | NR | KAF7316955.1 | 658473 | g10888 | i0 | 51.7 | 2.73809523809524 | 58 | 28 | 69 | 0 | 75 | 248 | 404 | 461 | KAF7316955.1 Nuclear transport factor 2 [Mycena chlorophos] | diamond | 690 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena chlorophos | |
| 30288971 | 30288971 | PRJNA1073712_P_NODE_16132_length_242_cov_0.911243_g16049_i0 | PRJNA1073712 | 16132 | 242 | 0.911243 | 2.20520806 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 139 | 3.77e-40 | NR | AYO43347.1 | 425264 | g16049 | i0 | 87.3 | 0.979338842975207 | 79 | 10 | 97.9 | 0 | 5 | 241 | 5 | 83 | AYO43347.1 Signal recognition particle 14kD protein [Malassezia restricta CBS 7877] | diamond | 237 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30320700 | 30320700 | PRJNA1073712_P_NODE_14452_length_245_cov_0.895349_g14369_i0 | PRJNA1073712 | 14452 | 245 | 0.895349 | 2.19360505 | Papiliotrema laurentii | 5418 | Fungi | Fungi | 91.3 | 5.17e-20 | NR | KAK1922354.1 | 5418 | g14369 | i0 | 58.9 | 0.893877551020408 | 73 | 29 | 88.2 | 1 | 25 | 240 | 3 | 75 | KAK1922354.1 hypothetical protein DB88DRAFT_347512 [Papiliotrema laurentii] | diamond | 219 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 30730892 | 30730892 | PRJNA1073712_P_NODE_2074_length_447_cov_0.754011_g1991_i0 | PRJNA1073712 | 2074 | 447 | 0.754011 | 3.37042917 | Phlebiopsis gigantea 11 | 82310 | Fungi | Fungi | 116 | 1.63e-29 | NR | KIP01532.1 | 745531 | g1991 | i0 | 47.7 | 1.02684563758389 | 153 | 67 | 94 | 4 | 424 | 5 | 15 | 167 | KIP01532.1 hypothetical protein PHLGIDRAFT_349127 [Phlebiopsis gigantea 11061_1 CR5-6] | diamond | 459 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis gigantea | |
| 31299682 | 31299682 | PRJNA1073712_P_NODE_11135_length_251_cov_0.865169_g11052_i0 | PRJNA1073712 | 11135 | 251 | 0.865169 | 2.17157419 | Peniophora sp. CONT | 1314672 | Fungi | Fungi | 120 | 3.47e-30 | NR | KZV67503.1 | 1314672 | g11052 | i0 | 90.8 | 0.776892430278884 | 65 | 6 | 77.7 | 0 | 11 | 205 | 335 | 399 | KZV67503.1 hypothetical protein PENSPDRAFT_754849 [Peniophora sp. CONT] | diamond | 195 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CONT | |
| 31489739 | 31489739 | PRJNA1073712_P_NODE_7476_length_288_cov_1.790698_g7393_i0 | PRJNA1073712 | 7476 | 288 | 1.790698 | 5.15721024 | Arthromyces matolae | 530044 | Fungi | Fungi | 82.4 | 7.23e-16 | NR | KAG6837438.1 | 530044 | g7393 | i0 | 47 | 3.0625 | 100 | 48 | 99 | 2 | 287 | 3 | 2 | 101 | KAG6837438.1 hypothetical protein H0H93_009532 [Arthromyces matolae] | diamond | 882 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Arthromyces | Arthromyces matolae | |
| 32090566 | 32090566 | PRJNA1073712_P_NODE_14638_length_245_cov_0.895349_g14555_i0 | PRJNA1073712 | 14638 | 245 | 0.895349 | 2.19360505 | Serendipita sp. 4 | 1965286 | Fungi | Fungi | 47.8 | 4.64e-4 | NR | KAG8823971.1 | 2600213 | g14555 | i0 | 48.4 | 1.59183673469388 | 64 | 29 | 78.4 | 1 | 240 | 49 | 26 | 85 | KAG8823971.1 hypothetical protein FRC18_010608 [Serendipita sp. 400] | diamond | 390 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita sp. 400 | |
| 32438852 | 32438852 | PRJNA1073712_P_NODE_7839_length_284_cov_1.407583_g7756_i0 | PRJNA1073712 | 7839 | 284 | 1.407583 | 3.99753572 | Jaminaea rosea | 1569628 | Fungi | Fungi | 73.6 | 9.02e-13 | NR | XP_025362052.1 | 1569628 | g7756 | i0 | 42.9 | 1.98591549295775 | 98 | 48 | 98.2 | 2 | 279 | 1 | 78 | 172 | XP_025362052.1 hypothetical protein BDZ90DRAFT_220310 [Jaminaea rosea] | diamond | 564 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Jaminaea | Jaminaea rosea |
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);;