contig_metadata
17 rows where bioproject = "PRJEB7614", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2271532 | 2271532 | PRJEB7614_P_NODE_1222_length_306_cov_10.519856_g1157_i0 | PRJEB7614 | 1222 | 306 | 10.519856 | 32.19075936 | Microbotryomycetes | 162481 | Fungi | Fungi | 481 | 3.069999999999999e-131 | NTclustered | gi|2065978375|gb|MZ557051.1| | 5445 | g1157 | i0 | 95.033 | 98.6928104575163 | 302 | 9 | 98 | 2 | 6 | 306 | 378 | 82 | Hamamotoa singularis isolate UFMGCB L82 large subunit ribosomal RNA gene, partial sequence | blastn | 30200 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Chrysozymaceae | Hamamotoa | Hamamotoa singularis | ||
| 2271533 | 2271533 | PRJEB7614_P_NODE_1262_length_303_cov_22.357664_g1196_i0 | PRJEB7614 | 1262 | 303 | 22.357664 | 67.74372192 | Piskurozyma | 1851566 | Fungi | Fungi | 451 | 2.38e-122 | NTclustered | gi|356458416|gb|JN637174.1| | 5211 | g1196 | i0 | 97.015 | 88.5709570957096 | 268 | 8 | 88 | 0 | 36 | 303 | 310 | 43 | Filobasidium capsuligenum strain B-30 26S ribosomal RNA gene, partial sequence | blastn | 26837 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Piskurozymaceae | Piskurozyma | Piskurozyma capsuligena | |
| 11199665 | 11199665 | PRJEB7614_P_NODE_1289_length_302_cov_4.512821_g1223_i0 | PRJEB7614 | 1289 | 302 | 4.512821 | 13.62871942 | Malassezia | 55193 | Fungi | Fungi | 503 | 6.459999999999998e-138 | NTclustered | gi|724086716|gb|KM269140.1| | 76773 | g1223 | i0 | 98.258 | 94.3245033112583 | 287 | 5 | 95 | 0 | 1 | 287 | 888 | 1174 | Malassezia globosa strain 123.1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 28486 | 508 | 0.990157480314961 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 25525698 | 25525698 | PRJEB7614e_S_NODE_441_length_304_cov_28.669145_g433_i0 | PRJEB7614 | 441 | 304 | 28.669145 | 87.1542008 | Hexagonia papyracea | 196106 | Fungi | Fungi | 481 | 3.05e-131 | NTclustered | gi|38017250|gb|AY351941.1| | 196106 | g433 | i0 | 97.183 | 93.6217105263158 | 284 | 8 | 93 | 0 | 1 | 284 | 310 | 27 | Hexagonia papyracea strain L-13144-R 28S ribosomal RNA gene, partial sequence | blastn | 28461 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Hexagonia | Hexagonia papyracea | |
| 25616388 | 25616388 | PRJEB7614e_S_NODE_513_length_291_cov_30.796875_g505_i0 | PRJEB7614 | 513 | 291 | 30.796875 | 89.61890625 | Eukaryota | 2759 | Fungi | Fungi | 494 | 3.7299999999999996e-135 | NTclustered | gi|635414833|gb|KF826524.1| | 106008 | g505 | i0 | 99.27 | 94.1443298969072 | 274 | 1 | 94 | 1 | 18 | 291 | 155 | 427 | Curvibasidium cygneicollum isolate CRUB 2013 internal transcribed spacer 2 and 26S ribosomal RNA gene, partial sequence | blastn | 27396 | 494 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Curvibasidium | Curvibasidium cygneicollum | |||
| 25661682 | 25661682 | PRJEB7614e_S_NODE_810_length_256_cov_14.348416_g802_i0 | PRJEB7614 | 810 | 256 | 14.348416 | 36.73194496 | Sporobolomyces carnicolor | 183959 | Fungi | Fungi | 366 | 7.3199999999999995e-97 | NTclustered | gi|506949050|dbj|AB727219.1| | 183959 | g802 | i0 | 92.578 | 99.8046875 | 256 | 17 | 100 | 2 | 1 | 256 | 3 | 256 | Sporobolomyces carnicolor gene for large subunit ribosomal RNA, partial sequence, strain: RS050 | blastn | 25550 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces carnicolor | |
| 25752679 | 25752679 | PRJEB7614e_S_NODE_746_length_263_cov_13.241228_g738_i0 | PRJEB7614 | 746 | 263 | 13.241228 | 34.82442964 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 481 | 2.58e-131 | NTclustered | gi|386776365|gb|JQ581047.1| | 33191 | g738 | i0 | 99.62 | 99.9733840304182 | 263 | 1 | 100 | 0 | 1 | 263 | 36 | 298 | Rhodosporidium lusitaniae strain HAI-Y-58 26S ribosomal RNA gene, partial sequence | blastn | 26293 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodosporidiobolus | Rhodosporidiobolus lusitaniae | |
| 25888362 | 25888362 | PRJEB7614b_S_NODE_7411_length_155_cov_1.058333_g7409_i0 | PRJEB7614 | 7411 | 155 | 1.058333 | 1.64041615 | Radulomyces | 139127 | Fungi | Fungi | 287 | 3.21e-73 | NTclustered | gi|1532344780|gb|MK278542.1| | 139128 | g7409 | i0 | 100 | 100 | 155 | 0 | 100 | 0 | 1 | 155 | 1 | 155 | Radulomyces molaris strain G1144 large subunit ribosomal RNA gene, partial sequence | blastn | 15500 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Radulomycetaceae | Radulomyces | Radulomyces molaris | |
| 25888368 | 25888368 | PRJEB7614d_S_NODE_355_length_312_cov_7.638989_g317_i0 | PRJEB7614 | 355 | 312 | 7.638989 | 23.83364568 | Malassezia | 55193 | Fungi | Fungi | 536 | 6.61e-148 | NTclustered | gi|724086716|gb|KM269140.1| | 76773 | g317 | i0 | 100 | 92.5 | 290 | 0 | 93 | 0 | 1 | 290 | 909 | 1198 | Malassezia globosa strain 123.1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 28860 | 536 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 25888374 | 25888374 | PRJEB7614e_S_NODE_1395_length_219_cov_4.755435_g1387_i0 | PRJEB7614 | 1395 | 219 | 4.755435 | 10.41440265 | Tremellales | 5234 | Fungi | Fungi | 405 | 1.29e-108 | NTclustered | gi|18698555|gb|AF459680.1| | 184554 | g1387 | i0 | 100 | 100 | 219 | 0 | 100 | 0 | 1 | 219 | 37 | 255 | Cryptococcus sp. KCTC 17064 26S ribosomal RNA gene, partial sequence | blastn | 21900 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus sp. KCTC 17064 | |
| 25933971 | 25933971 | PRJEB7614e_S_NODE_20340_length_165_cov_1.815385_g20332_i0 | PRJEB7614 | 20340 | 165 | 1.815385 | 2.99538525 | Tausonia pamirica | 415705 | Fungi | Fungi | 265 | 1.6299999999999998e-66 | NTclustered | gi|558519201|gb|KF036692.1| | 415705 | g20332 | i0 | 98.026 | 91.9757575757576 | 152 | 3 | 92 | 0 | 14 | 165 | 51 | 202 | Tausonia pamirica strain CBS8428 18S ribosomal RNA gene, partial sequence | blastn | 15176 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Tausonia | Tausonia pamirica | |
| 26296585 | 26296585 | PRJEB7614a_S_NODE_137342_length_152_cov_0.846154_g136138_i0 | PRJEB7614 | 137342 | 152 | 0.846154 | 1.28615408 | Hydnaceae | 68758 | Fungi | Fungi | 97.1 | 5.66e-16 | NTclustered | gi|118429492|gb|DQ915476.1| | 411564 | g136138 | i0 | 91.549 | 53.8092105263158 | 71 | 4 | 70 | 2 | 39 | 108 | 2175 | 2106 | Minimedusa polyspora strain ATCC 24041 25S large subunit ribosomal RNA gene, partial sequence | blastn | 8179 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Minimedusa | Minimedusa polyspora | |
| 26296619 | 26296619 | PRJEB7614e_S_NODE_4294_length_187_cov_3.730263_g4286_i0 | PRJEB7614 | 4294 | 187 | 3.730263 | 6.97559181 | Fungi | 4751 | Fungi | Fungi | 346 | 6.56e-91 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g4286 | i0 | 100 | 100 | 187 | 0 | 100 | 0 | 1 | 187 | 22 | 208 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 18700 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 26432607 | 26432607 | PRJEB7614a_S_NODE_132111_length_156_cov_2.181818_g130907_i0 | PRJEB7614 | 132111 | 156 | 2.181818 | 3.40363608 | Trichosporonaceae | 1759442 | Fungi | Fungi | 289 | 9e-74 | NTclustered | gi|161085674|dbj|AB305103.1| | 5554 | g130907 | i0 | 100 | 100 | 156 | 0 | 100 | 0 | 1 | 156 | 473 | 628 | Trichosporon cutaneum genes for 18S rRNA, ITS1, 5.8S rRNA,ITS2, 28S rRNA | blastn | 15600 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cutaneum | |
| 26432633 | 26432633 | PRJEB7614d_S_NODE_399_length_301_cov_6.687970_g361_i0 | PRJEB7614 | 399 | 301 | 6.68797 | 20.1307897 | Trichosporonaceae | 1759442 | Fungi | Fungi | 551 | 2.2699999999999992e-152 | NTclustered | gi|1102643771|gb|KY107341.1| | 82522 | g361 | i0 | 99.668 | 99.671096345515 | 301 | 1 | 100 | 0 | 1 | 301 | 321 | 21 | Cutaneotrichosporon mucoides culture CBS:8667 large subunit ribosomal RNA gene, partial sequence | blastn | 30001 | 551 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon mucoides | |
| 26432652 | 26432652 | PRJEB7614e_S_NODE_639_length_274_cov_3179.920502_g631_i0 | PRJEB7614 | 639 | 274 | 3179.920502 | 8712.98217548 | Cystofilobasidium | 5410 | Fungi | Fungi | 411 | 3.6e-110 | NTclustered | gi|2806730461|gb|PQ350713.1| | 89913 | g631 | i0 | 97.119 | 88.6861313868613 | 243 | 7 | 89 | 0 | 32 | 274 | 130 | 372 | Cystofilobasidium infirmominiatum strain Y104 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24300 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Cystofilobasidiaceae | Cystofilobasidium | Cystofilobasidium infirmominiatum | |
| 26568649 | 26568649 | PRJEB7614e_S_NODE_624_length_276_cov_27.514523_g616_i0 | PRJEB7614 | 624 | 276 | 27.514523 | 75.94008348 | Mrakiaceae | 1851551 | Fungi | Fungi | 422 | 1.68e-113 | NTclustered | gi|530538420|gb|KC991038.1| | 29902 | g616 | i0 | 98.739 | 86.231884057971 | 238 | 2 | 86 | 1 | 39 | 276 | 706 | 942 | Mrakia frigida strain Nwsc-2 18S ribosomal RNA gene, partial sequence | blastn | 23800 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Mrakia | Mrakia frigida |
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);;