contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1013345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27287708 | 27287708 | PRJNA1013345_P_NODE_29723_length_159_cov_0.910714_g29593_i0 | PRJNA1013345 | 29723 | 159 | 0.910714 | 1.44803526 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 57 | 1.13e-7 | NR | GHJ87676.1 | 104408 | g29593 | i0 | 58.5 | 1 | 53 | 22 | 100 | 0 | 1 | 159 | 474 | 526 | GHJ87676.1 hypothetical protein NliqN6_4078 [Naganishia liquefaciens] | diamond | 159 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 27319470 | 27319470 | PRJNA1013345_P_NODE_27843_length_161_cov_0.894737_g27713_i0 | PRJNA1013345 | 27843 | 161 | 0.894737 | 1.44052657 | Mycena crocata | 220801 | Fungi | Fungi | 41.2 | 0.0437 | NR | KAJ7147483.1 | 220801 | g27713 | i0 | 39.6 | 0.894409937888199 | 48 | 28 | 87.6 | 1 | 10 | 150 | 180 | 227 | KAJ7147483.1 kinase-like domain-containing protein [Mycena crocata] | diamond | 144 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena crocata | |
| 28077082 | 28077082 | PRJNA1013345_P_NODE_27805_length_161_cov_0.894737_g27675_i0 | PRJNA1013345 | 27805 | 161 | 0.894737 | 1.44052657 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 67.4 | 2.43e-11 | NR | KAG0666643.1 | 5537 | g27675 | i0 | 98.1 | 0.987577639751553 | 53 | 1 | 98.8 | 0 | 1 | 159 | 230 | 282 | KAG0666643.1 hypothetical protein C6P46_004309 [Rhodotorula mucilaginosa] | diamond | 159 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 28487762 | 28487762 | PRJNA1013345_P_NODE_26787_length_162_cov_0.886957_g26657_i0 | PRJNA1013345 | 26787 | 162 | 0.886957 | 1.43687034 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 77.8 | 3.11e-15 | NR | XP_017991439.1 | 77020 | g26657 | i0 | 67.9 | 0.981481481481482 | 53 | 17 | 98.1 | 0 | 160 | 2 | 57 | 109 | XP_017991439.1 hypothetical protein Malapachy_1947 [Malassezia pachydermatis] | diamond | 159 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 28803112 | 28803112 | PRJNA1013345_P_NODE_25668_length_163_cov_0.879310_g25538_i0 | PRJNA1013345 | 25668 | 163 | 0.87931 | 1.4332753 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 100 | 4.2299999999999997e-23 | NR | KAG0666381.1 | 5537 | g25538 | i0 | 100 | 0.993865030674847 | 54 | 0 | 99.4 | 0 | 163 | 2 | 1125 | 1178 | KAG0666381.1 NADPH-dependent diflavin oxidoreductase 1 [Rhodotorula mucilaginosa] | diamond | 162 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 28826975 | 28826975 | PRJNA1013345_P_NODE_18628_length_174_cov_2.362205_g18498_i0 | PRJNA1013345 | 18628 | 174 | 2.362205 | 4.1102367 | Rhodotorula | 5533 | Fungi | Fungi | 101 | 2.5899999999999994e-23 | NR | KAG0666913.1 | 5537 | g18498 | i0 | 100 | 1.96551724137931 | 57 | 0 | 98.3 | 0 | 173 | 3 | 1102 | 1158 | KAG0666913.1 hypothetical protein C6P46_003623 [Rhodotorula mucilaginosa] | diamond | 342 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 29332385 | 29332385 | PRJNA1013345_P_NODE_16549_length_179_cov_1.522727_g16419_i0 | PRJNA1013345 | 16549 | 179 | 1.522727 | 2.72568133 | Rhodotorula | 5533 | Fungi | Fungi | 68.6 | 1.19e-11 | NR | KAG0657603.1 | 5537 | g16419 | i0 | 100 | 1.07262569832402 | 31 | 0 | 52 | 0 | 17 | 109 | 386 | 416 | KAG0657603.1 hypothetical protein C6P46_006330 [Rhodotorula mucilaginosa] | diamond | 192 | 68.9 | 0.995645863570392 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 30256388 | 30256388 | PRJNA1013345_P_NODE_28392_length_160_cov_1.592920_g28262_i0 | PRJNA1013345 | 28392 | 160 | 1.59292 | 2.548672 | Papiliotrema laurentii | 5418 | Fungi | Fungi | 53.5 | 1.88e-6 | NR | KAK1925948.1 | 5418 | g28262 | i0 | 100 | 0.43125 | 23 | 0 | 43.1 | 0 | 69 | 1 | 233 | 255 | KAK1925948.1 SAC3/GANP/Nin1/mts3/eIF-3 p25 family-domain-containing protein [Papiliotrema laurentii] | diamond | 69 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 30414300 | 30414300 | PRJNA1013345_P_NODE_13773_length_185_cov_1.992754_g13643_i0 | PRJNA1013345 | 13773 | 185 | 1.992754 | 3.6865949 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 124 | 4.489999999999999e-31 | NR | KAG0654291.1 | 5537 | g13643 | i0 | 100 | 0.989189189189189 | 61 | 0 | 98.9 | 0 | 1 | 183 | 677 | 737 | KAG0654291.1 hypothetical protein C6P46_001811 [Rhodotorula mucilaginosa] | diamond | 183 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 31140303 | 31140303 | PRJNA1013345_P_NODE_21115_length_169_cov_1.647541_g20985_i0 | PRJNA1013345 | 21115 | 169 | 1.647541 | 2.78434429 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 95.5 | 3.46e-21 | NR | KWU43599.1 | 1305733 | g20985 | i0 | 89.1 | 0.976331360946746 | 55 | 6 | 97.6 | 0 | 3 | 167 | 863 | 917 | KWU43599.1 hypothetical protein RHOSPDRAFT_34915 [Rhodotorula sp. JG-1b] | diamond | 165 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 31298741 | 31298741 | PRJNA1013345_P_NODE_33975_length_151_cov_2.557692_g33845_i0 | PRJNA1013345 | 33975 | 151 | 2.557692 | 3.86211492 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 61.2 | 3.17e-9 | NR | KWU41590.1 | 1305733 | g33845 | i0 | 72 | 0.993377483443709 | 50 | 14 | 99.3 | 0 | 150 | 1 | 991 | 1040 | KWU41590.1 hypothetical protein RHOSPDRAFT_36847 [Rhodotorula sp. JG-1b] | diamond | 150 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 32311417 | 32311417 | PRJNA1013345_P_NODE_21979_length_167_cov_1.908333_g21849_i0 | PRJNA1013345 | 21979 | 167 | 1.908333 | 3.18691611 | Mycena galericulata | 71905 | Fungi | Fungi | 42 | 0.0252 | NR | KAJ7448471.1 | 71905 | g21849 | i0 | 50 | 0.754491017964072 | 42 | 20 | 75.4 | 1 | 21 | 146 | 457 | 497 | KAJ7448471.1 hypothetical protein B0H11DRAFT_1929133 [Mycena galericulata] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galericulata | |
| 32374534 | 32374534 | PRJNA1013345_P_NODE_18859_length_174_cov_1.385827_g18729_i0 | PRJNA1013345 | 18859 | 174 | 1.385827 | 2.41133898 | Rhodotorula sp. CCFEE 5 | 1853554 | Fungi | Fungi | 114 | 2.54e-28 | NR | TKA56820.1 | 1965284 | g18729 | i0 | 100 | 1.93103448275862 | 56 | 0 | 96.6 | 0 | 172 | 5 | 330 | 385 | TKA56820.1 hypothetical protein B0A53_01221 [Rhodotorula sp. CCFEE 5036] | diamond | 336 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. CCFEE 5036 | |
| 32595838 | 32595838 | PRJNA1013345_P_NODE_13480_length_186_cov_1.417266_g13350_i0 | PRJNA1013345 | 13480 | 186 | 1.417266 | 2.63611476 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 87 | 4.23e-18 | NR | KWU43572.1 | 1305733 | g13350 | i0 | 98.4 | 1.96774193548387 | 61 | 1 | 98.4 | 0 | 184 | 2 | 471 | 531 | KWU43572.1 alpha/beta-hydrolase [Rhodotorula sp. JG-1b] | diamond | 366 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 32816092 | 32816092 | PRJNA1013345_P_NODE_32200_length_157_cov_0.927273_g32070_i0 | PRJNA1013345 | 32200 | 157 | 0.927273 | 1.45581861 | Rhodotorula sp. CCFEE 5 | 1853554 | Fungi | Fungi | 97.1 | 3.35e-23 | NR | TKA53736.1 | 1965284 | g32070 | i0 | 98.1 | 0.993630573248408 | 52 | 1 | 99.4 | 0 | 156 | 1 | 141 | 192 | TKA53736.1 hypothetical protein B0A53_03778 [Rhodotorula sp. CCFEE 5036] | diamond | 156 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. CCFEE 5036 |
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);;