contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2270633 | 2270633 | PRJEB73599_P_NODE_8462_length_181_cov_5.835526_g8175_i0 | PRJEB73599 | 8462 | 181 | 5.835526 | 10.56230206 | Tremellomycetes | 155616 | Fungi | Fungi | 333 | 4.9000000000000015e-87 | NTclustered | gi|1897356421|ref|NG_070546.1| | 143232 | g8175 | i0 | 100 | 115.364640883978 | 180 | 0 | 99 | 0 | 2 | 181 | 766 | 587 | Vanrija pseudolonga CBS 8297 28S rRNA gene, partial sequence; from TYPE material | blastn | 20881 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 2270635 | 2270635 | PRJEB73599_P_NODE_9922_length_154_cov_5.472000_g9635_i0 | PRJEB73599 | 9922 | 154 | 5.472 | 8.42688 | Malassezia | 55193 | Fungi | Fungi | 257 | 2.5e-64 | NTclustered | gi|2301912368|gb|OP432766.1| | 76775 | g9635 | i0 | 97.368 | 98.7662337662338 | 152 | 3 | 99 | 1 | 1 | 152 | 265 | 415 | Malassezia restricta voucher Morchella importuna culture strains AT63 large subunit ribosomal RNA gene, partial sequence | blastn | 15210 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9062459 | 9062459 | PRJEB73599_P_NODE_5968_length_252_cov_3.811659_g5681_i0 | PRJEB73599 | 5968 | 252 | 3.811659 | 9.60538068 | uncultured Basidiomycota | 175244 | Fungi | Fungi | 327 | 3.39e-85 | NTclustered | gi|375267970|dbj|AB663495.1| | 175244 | g5681 | i0 | 99.444 | 72.2142857142857 | 180 | 1 | 71 | 0 | 1 | 180 | 232 | 411 | Uncultured Basidiomycota gene for 26S rRNA, partial sequence, clone: 070 | blastn | 18198 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | uncultured Basidiomycota | |||||
| 9923540 | 9923540 | PRJEB73599_P_NODE_2068_length_515_cov_2.333333_g1812_i0 | PRJEB73599 | 2068 | 515 | 2.333333 | 12.01666495 | Malassezia | 55193 | Fungi | Fungi | 833 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g1812 | i0 | 95.56 | 70.1553398058252 | 518 | 14 | 100 | 7 | 1 | 515 | 898 | 387 | Malassezia restricta mitochondrion, complete genome | blastn | 36130 | 833 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11613712 | 11613712 | PRJEB73599_P_NODE_7710_length_198_cov_2.810651_g7423_i0 | PRJEB73599 | 7710 | 198 | 2.810651 | 5.56508898 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 355 | 1.17e-93 | NTclustered | gi|2692937071|ref|NC_086476.1| | 1514897 | g7423 | i0 | 98.99 | 49.1767676767677 | 198 | 2 | 100 | 0 | 1 | 198 | 1370 | 1173 | Malassezia arunalokei culture CBS:13387 strain CBS13387 mitochondrion, complete genome | blastn | 9737 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 12888746 | 12888746 | PRJEB73599_P_NODE_5831_length_257_cov_2.614035_g5544_i0 | PRJEB73599 | 5831 | 257 | 2.614035 | 6.71806995 | Malassezia restricta | 76775 | Fungi | Fungi | 464 | 2.5299999999999998e-126 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5544 | i0 | 99.222 | 88.1556420233463 | 257 | 2 | 100 | 0 | 1 | 257 | 3069 | 3325 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 22656 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14163580 | 14163580 | PRJEB73599_P_NODE_4472_length_318_cov_42.456747_g4185_i0 | PRJEB73599 | 4472 | 318 | 42.456747 | 135.01245546 | Papiliotrema terrestris | 425109 | Fungi | Fungi | 433 | 9.11e-117 | NTclustered | gi|1758753257|emb|LR697097.1| | 425109 | g4185 | i0 | 91.25 | 144.751572327044 | 320 | 24 | 100 | 4 | 1 | 318 | 2510 | 2193 | Papiliotrema terrestris partial 28S rRNA gene | blastn | 46031 | 433 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema terrestris | |
| 15023416 | 15023416 | PRJEB73599_P_NODE_5552_length_268_cov_2.924686_g5265_i0 | PRJEB73599 | 5552 | 268 | 2.924686 | 7.83815848 | Malassezia | 55193 | Fungi | Fungi | 496 | 9.429999999999999e-136 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g5265 | i0 | 100 | 92.7798507462687 | 268 | 0 | 100 | 0 | 1 | 268 | 1750 | 2017 | Malassezia restricta mitochondrion, complete genome | blastn | 24865 | 496 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15023423 | 15023423 | PRJEB73599_P_NODE_8332_length_184_cov_2.296774_g8045_i0 | PRJEB73599 | 8332 | 184 | 2.296774 | 4.22606416 | Eukaryota | 2759 | Fungi | Fungi | 326 | 8.37e-85 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g8045 | i0 | 99.441 | 92.6902173913043 | 179 | 1 | 97 | 0 | 6 | 184 | 1684 | 1506 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 17055 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17573406 | 17573406 | PRJEB73599_P_NODE_1114_length_714_cov_23.353285_g927_i0 | PRJEB73599 | 1114 | 714 | 23.353285 | 166.7424549 | Fungi | 4751 | Fungi | Fungi | 394 | 1.0299999999999999e-104 | NTclustered | gi|1859735555|gb|MT644873.1| | 5217 | g927 | i0 | 99.087 | 30.9775910364146 | 219 | 2 | 31 | 0 | 496 | 714 | 4804 | 5022 | Tremella mesenterica isolate DM1159 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22118 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 18847198 | 18847198 | PRJEB73599_P_NODE_1635_length_580_cov_7.246824_g1412_i0 | PRJEB73599 | 1635 | 580 | 7.246824 | 42.0315792 | Tremellomycetes | 155616 | Fungi | Fungi | 702 | 0 | NTclustered | gi|819940622|gb|KP294523.1| | 5417 | g1412 | i0 | 96.262 | 71.1 | 428 | 16 | 74 | 0 | 1 | 428 | 658 | 231 | Vanrija humicola strain DUCC4007 large subunit ribosomal RNA gene, partial sequence | blastn | 41238 | 702 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 20122038 | 20122038 | PRJEB73599_P_NODE_6616_length_230_cov_3.681592_g6329_i0 | PRJEB73599 | 6616 | 230 | 3.681592 | 8.4676616 | Opisthokonta | 33154 | Fungi | Fungi | 374 | 3.859999999999998e-99 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g6329 | i0 | 94.421 | 101.304347826087 | 233 | 10 | 100 | 1 | 1 | 230 | 465 | 233 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 23300 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20536057 | 20536057 | PRJEB73599_P_NODE_1437_length_624_cov_7.403361_g1227_i0 | PRJEB73599 | 1437 | 624 | 7.403361 | 46.19697264 | Vanrija longa | 181171 | Fungi | Fungi | 1086 | 0 | NTclustered | gi|1897356420|ref|NG_070545.1| | 181171 | g1227 | i0 | 98.077 | 95.2275641025641 | 624 | 12 | 100 | 0 | 1 | 624 | 643 | 20 | Vanrija longa CBS 5920 28S rRNA gene, partial sequence; from TYPE material | blastn | 59422 | 1086 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija longa | |
| 21811974 | 21811974 | PRJEB73599_P_NODE_8298_length_185_cov_2.243590_g8011_i0 | PRJEB73599 | 8298 | 185 | 2.24359 | 4.1506415 | Malassezia globosa | 76773 | Fungi | Fungi | 326 | 8.430000000000001e-85 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g8011 | i0 | 98.378 | 81.6594594594595 | 185 | 3 | 100 | 0 | 1 | 185 | 2554 | 2738 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 15107 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 22672396 | 22672396 | PRJEB73599_P_NODE_5018_length_290_cov_7.314176_g4731_i0 | PRJEB73599 | 5018 | 290 | 7.314176 | 21.2111104 | Cryptococcus | 5206 | Fungi | Fungi | 368 | 2.35e-97 | NTclustered | gi|1916816077|gb|MT712037.1| | 37769 | g4731 | i0 | 89.965 | 145 | 289 | 24 | 99 | 5 | 1 | 287 | 718 | 433 | Cryptococcus gattii strain NIH34 28S ribosomal RNA gene, partial sequence; intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence; and 18S ribosomal RNA gene, partial sequence | blastn | 42050 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus gattii | |
| 23948026 | 23948026 | PRJEB73599_P_NODE_8159_length_188_cov_3.150943_g7872_i0 | PRJEB73599 | 8159 | 188 | 3.150943 | 5.92377284 | Fungi | 4751 | Fungi | Fungi | 348 | 1.84e-91 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g7872 | i0 | 100 | 100 | 188 | 0 | 100 | 0 | 1 | 188 | 38 | 225 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 18800 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25221660 | 25221660 | PRJEB73599_P_NODE_9180_length_168_cov_1.791367_g8893_i0 | PRJEB73599 | 9180 | 168 | 1.791367 | 3.00949656 | Malassezia | 55193 | Fungi | Fungi | 305 | 9.81e-79 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g8893 | i0 | 99.405 | 66.1547619047619 | 168 | 1 | 100 | 0 | 1 | 168 | 32783 | 32616 | Malassezia restricta mitochondrion, complete genome | blastn | 11114 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;