contig_metadata
19 rows where bioproject = "PRJNA508758", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6214146 | 6214146 | PRJNA508758_P_NODE_46325_length_310_cov_1.299578_g45277_i0 | PRJNA508758 | 46325 | 310 | 1.299578 | 4.0286918 | Tulasnella | 5240 | Fungi | Fungi | 573 | 4.999999999999998e-159 | NTclustered | gi|92090858|gb|DQ457637.1| | 154754 | g45277 | i0 | 100 | 90.4612903225807 | 310 | 0 | 100 | 0 | 1 | 310 | 836 | 1145 | Tulasnella pruinosa isolate AFTOL-ID 610 18S small subunit ribosomal RNA gene, partial sequence | blastn | 28043 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella pruinosa | |
| 6214167 | 6214167 | PRJNA508758_P_NODE_72885_length_252_cov_2.458101_g71837_i0 | PRJNA508758 | 72885 | 252 | 2.458101 | 6.19441452 | Ganoderma | 5314 | Fungi | Fungi | 427 | 3.2499999999999993e-115 | NTclustered | gi|2724480650|gb|PP467489.1| | 5315 | g71837 | i0 | 97.222 | 106.805555555556 | 252 | 7 | 100 | 0 | 1 | 252 | 6675 | 6424 | Ganoderma lucidum strain Red Reishi No.6 intergenic spacer 2, partial sequence; 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, intergenic spacer 2, 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence; and 18S small subunit ribosomal RNA gene, partial sequence | blastn | 26915 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 6862295 | 6862295 | PRJNA508758_P_NODE_28366_length_380_cov_1.429967_g27318_i0 | PRJNA508758 | 28366 | 380 | 1.429967 | 5.4338746 | Malassezia restricta | 76775 | Fungi | Fungi | 662 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g27318 | i0 | 98.158 | 99.1842105263158 | 380 | 6 | 100 | 1 | 1 | 380 | 1923 | 1545 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 37690 | 662 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8137397 | 8137397 | PRJNA508758_P_NODE_11247_length_633_cov_1.371429_g10258_i0 | PRJNA508758 | 11247 | 633 | 1.371429 | 8.68114557 | Suillus subalutaceus | 48586 | Fungi | Fungi | 65.8 | 8.07e-6 | NTclustered | gi|2033592548|ref|XM_041388622.1| | 48586 | g10258 | i0 | 90.385 | 0.173775671406003 | 52 | 1 | 8 | 3 | 347 | 397 | 317 | 269 | Suillus subalutaceus uncharacterized protein (DFJ58DRAFT_763550), mRNA | blastn | 110 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus subalutaceus | |
| 9412814 | 9412814 | PRJNA508758_P_NODE_52288_length_294_cov_1.669683_g51240_i0 | PRJNA508758 | 52288 | 294 | 1.669683 | 4.90886802 | Tilletiaria anomala | 5281 | Fungi | Fungi | 86.1 | 2.69e-12 | NTclustered | gi|914977262|ref|XM_013389568.1| | 1037660 | g51240 | i0 | 90.625 | 15.9149659863946 | 64 | 6 | 22 | 0 | 231 | 294 | 1345 | 1282 | Tilletiaria anomala UBC 951 translation elongation factor 1a (K437DRAFT_254562), mRNA | blastn | 4679 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Tilletiariaceae | Tilletiaria | Tilletiaria anomala | |
| 9412917 | 9412917 | PRJNA508758_P_NODE_6488_length_926_cov_21.490035_g5676_i0 | PRJNA508758 | 6488 | 926 | 21.490035 | 198.9977241 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 394 | 1.35e-104 | NTclustered | gi|1423587035|ref|XM_025743209.1| | 58919 | g5676 | i0 | 80 | 18.2105831533477 | 540 | 102 | 58 | 6 | 105 | 641 | 55 | 591 | Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA | blastn | 16863 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 11963249 | 11963249 | PRJNA508758_P_NODE_29530_length_373_cov_1.770000_g28482_i0 | PRJNA508758 | 29530 | 373 | 1.77 | 6.6021 | Lactarius trivialis | 217427 | Fungi | Fungi | 54.7 | 0.01 | NTclustered | gi|2091527986|ref|NC_057510.1| | 217427 | g28482 | i0 | 96.97 | 0.388739946380697 | 33 | 0 | 9 | 1 | 100 | 132 | 40307 | 40338 | Lactarius trivialis mitochondrion, complete genome | blastn | 145 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius trivialis | |
| 11963386 | 11963386 | PRJNA508758_P_NODE_47530_length_306_cov_2.296137_g46482_i0 | PRJNA508758 | 47530 | 306 | 2.296137 | 7.02617922 | Malassezia restricta | 76775 | Fungi | Fungi | 555 | 1.7799999999999996e-153 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g46482 | i0 | 99.346 | 76.3725490196078 | 306 | 2 | 100 | 0 | 1 | 306 | 2982 | 3287 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23370 | 555 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12589613 | 12589613 | PRJNA508758_P_NODE_50450_length_299_cov_1.358407_g49402_i0 | PRJNA508758 | 50450 | 299 | 1.358407 | 4.06163693 | Opisthokonta | 33154 | Fungi | Fungi | 551 | 2.2499999999999998e-152 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g49402 | i0 | 100 | 99.561872909699 | 298 | 0 | 99 | 0 | 2 | 299 | 528 | 231 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 29769 | 551 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15787498 | 15787498 | PRJNA508758_P_NODE_64633_length_268_cov_1.887179_g63585_i0 | PRJNA508758 | 64633 | 268 | 1.887179 | 5.05763972 | Kwoniella bestiolae | 324769 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|1102542229|ref|XM_019193768.1| | 1296100 | g63585 | i0 | 100 | 0.108208955223881 | 29 | 0 | 11 | 0 | 77 | 105 | 944 | 972 | Kwoniella bestiolae CBS 10118 uncharacterized protein (I302_108460), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella bestiolae | |
| 16413357 | 16413357 | PRJNA508758_P_NODE_61513_length_274_cov_3.064677_g60465_i0 | PRJNA508758 | 61513 | 274 | 3.064677 | 8.39721498 | root | 1 | Root_unresolved | Root_unresolved | 507 | 4.47e-139 | NTclustered | gi|2500415392|gb|OQ926588.1| | 5358 | g60465 | i0 | 100 | 100 | 274 | 0 | 100 | 0 | 1 | 274 | 5 | 278 | Lentinus crinitus isolate SP001 small subunit ribosomal RNA gene, partial sequence | blastn | 27400 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus crinitus | |
| 18336346 | 18336346 | PRJNA508758_P_NODE_50655_length_298_cov_1.968889_g49607_i0 | PRJNA508758 | 50655 | 298 | 1.968889 | 5.86728922 | Tulasnella pruinosa | 154754 | Fungi | Fungi | 523 | 4.879999999999998e-144 | NTclustered | gi|92090858|gb|DQ457637.1| | 154754 | g49607 | i0 | 98.322 | 45.6577181208054 | 298 | 5 | 100 | 0 | 1 | 298 | 410 | 113 | Tulasnella pruinosa isolate AFTOL-ID 610 18S small subunit ribosomal RNA gene, partial sequence | blastn | 13606 | 523 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella pruinosa | |
| 18336520 | 18336520 | PRJNA508758_P_NODE_73955_length_251_cov_0.865169_g72907_i0 | PRJNA508758 | 73955 | 251 | 0.865169 | 2.17157419 | Schizophyllum commune | 5334 | Fungi | Fungi | 462 | 8.869999999999999e-126 | NTclustered | gi|148358040|gb|DQ071725.2| | 5334 | g72907 | i0 | 100 | 102.828685258964 | 250 | 0 | 99 | 0 | 2 | 251 | 2062 | 1813 | Schizophyllum commune voucher TUB 012156 28S large subunit ribosomal RNA gene, partial sequence | blastn | 25810 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 18336646 | 18336646 | PRJNA508758_P_NODE_88515_length_241_cov_0.916667_g87467_i0 | PRJNA508758 | 88515 | 241 | 0.916667 | 2.20916747 | Malassezia restricta | 76775 | Fungi | Fungi | 440 | 3.959999999999999e-119 | NTclustered | gi|1546638137|ref|XM_027630710.1| | 76775 | g87467 | i0 | 99.585 | 1 | 241 | 1 | 100 | 0 | 1 | 241 | 1042 | 1282 | Malassezia restricta Sec14 cytosolic factor (MRET_4083), partial mRNA | blastn | 241 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 26887515 | 26887515 | PRJNA508758_P_NODE_55241_length_288_cov_0.883721_g54193_i0 | PRJNA508758 | 55241 | 288 | 0.883721 | 2.54511648 | Obba rivulosa | 1052685 | Fungi | Fungi | 42.7 | 0.0262 | NR | OCH86648.1 | 1052685 | g54193 | i0 | 36.9 | 0.677083333333333 | 65 | 34 | 60.4 | 2 | 49 | 222 | 70 | 134 | OCH86648.1 hypothetical protein OBBRIDRAFT_797019 [Obba rivulosa] | diamond | 195 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Gelatoporiaceae | Obba | Obba rivulosa | |
| 27487980 | 27487980 | PRJNA508758_P_NODE_45823_length_311_cov_1.936975_g44775_i0 | PRJNA508758 | 45823 | 311 | 1.936975 | 6.02399225 | Mycena leptocephala | 230808 | Fungi | Fungi | 48.1 | 0.00105 | NR | KAJ7938234.1 | 230808 | g44775 | i0 | 48.6 | 1.77491961414791 | 37 | 19 | 35.7 | 0 | 139 | 29 | 224 | 260 | KAJ7938234.1 DNA cross-link repair protein pso2/snm1 [Mycena leptocephala] | diamond | 552 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena leptocephala | |
| 28119354 | 28119354 | PRJNA508758_P_NODE_80185_length_247_cov_0.885057_g79137_i0 | PRJNA508758 | 80185 | 247 | 0.885057 | 2.18609079 | Lentinula detonsa | 2804962 | Fungi | Fungi | 99 | 6.64e-22 | NR | KAJ3744977.1 | 2804962 | g79137 | i0 | 60.8 | 5.96356275303644 | 74 | 28 | 89.9 | 1 | 5 | 226 | 716 | 788 | KAJ3744977.1 P-loop containing nucleoside triphosphate hydrolase protein [Lentinula detonsa] | diamond | 1473 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula detonsa | |
| 29887728 | 29887728 | PRJNA508758_P_NODE_79551_length_247_cov_0.885057_g78503_i0 | PRJNA508758 | 79551 | 247 | 0.885057 | 2.18609079 | Filobasidium floriforme | 5210 | Fungi | Fungi | 159 | 4.39e-46 | NR | XP_046039532.1 | 5210 | g78503 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 1 | 246 | 4 | 85 | XP_046039532.1 putative ribose-phosphate diphosphokinase [Filobasidium floriforme] | diamond | 246 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 30487911 | 30487911 | PRJNA508758_P_NODE_75493_length_250_cov_0.870056_g74445_i0 | PRJNA508758 | 75493 | 250 | 0.870056 | 2.17514 | Rhodotorula graminis WP1 | 578459 | Fungi | Fungi | 59.7 | 4.13e-8 | NR | XP_018269030.1 | 578459 | g74445 | i0 | 46.8 | 0.564 | 47 | 25 | 56.4 | 0 | 100 | 240 | 23 | 69 | XP_018269030.1 uncharacterized protein RHOBADRAFT_55228 [Rhodotorula graminis WP1] | diamond | 141 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis |
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);;