contig_metadata
17 rows where bioproject = "PRJEB4632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1335891 | 1335891 | PRJEB4632_P_NODE_322_length_408_cov_11.167164_g284_i0 | PRJEB4632 | 322 | 408 | 11.167164 | 45.56202912 | Malassezia restricta | 76775 | Fungi | Fungi | 741 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g284 | i0 | 99.51 | 106.433823529412 | 408 | 1 | 100 | 1 | 1 | 408 | 1507 | 1913 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 43425 | 741 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6093187 | 6093187 | PRJEB4632_P_NODE_325_length_405_cov_8.879518_g287_i0 | PRJEB4632 | 325 | 405 | 8.879518 | 35.9620479 | Phlebiopsis | 82309 | Fungi | Fungi | 749 | 0 | NTclustered | gi|391883721|gb|JQ768392.1| | 82310 | g287 | i0 | 100 | 107.767901234568 | 405 | 0 | 100 | 0 | 1 | 405 | 1383 | 1787 | Phlebiopsis gigantea isolate 11 large subunit ribosomal RNA gene, partial sequence | blastn | 43646 | 749 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis gigantea | |
| 9918216 | 9918216 | PRJEB4632_P_NODE_1068_length_213_cov_7.064286_g1030_i0 | PRJEB4632 | 1068 | 213 | 7.064286 | 15.04692918 | Fungi | 4751 | Fungi | Fungi | 394 | 2.7e-105 | NTclustered | gi|1829462362|gb|MT312780.1| | 5319 | g1030 | i0 | 100 | 100 | 213 | 0 | 100 | 0 | 1 | 213 | 312 | 100 | Irpex lacteus strain BAFC 1171 small subunit ribosomal RNA gene, partial sequence | blastn | 21300 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Irpex | Irpex lacteus | |
| 11193414 | 11193414 | PRJEB4632_P_NODE_449_length_326_cov_2.015810_g411_i0 | PRJEB4632 | 449 | 326 | 2.01581 | 6.5715406 | Microbotryomycetes | 162481 | Fungi | Fungi | 544 | 4.15e-150 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g411 | i0 | 96.914 | 98 | 324 | 10 | 99 | 0 | 1 | 324 | 4237 | 3914 | Leucosporidium scottii 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 | 31948 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 12815020 | 12815020 | PRJEB4632_P_NODE_1071_length_212_cov_16.575540_g1033_i0 | PRJEB4632 | 1071 | 212 | 16.57554 | 35.1401448 | Phlebiopsis crassa | 1647769 | Fungi | Fungi | 392 | 9.67e-105 | NTclustered | gi|528533069|dbj|AB809163.1| | 1647769 | g1033 | i0 | 100 | 105.051886792453 | 212 | 0 | 100 | 0 | 1 | 212 | 5839 | 5628 | Porostereum crassum genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, IGS1, 5S rRNA, partial and complete sequence, strain: MAFF 420737 | blastn | 22271 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis crassa | |
| 13743511 | 13743511 | PRJEB4632_P_NODE_451_length_326_cov_1.438735_g413_i0 | PRJEB4632 | 451 | 326 | 1.438735 | 4.6902761 | Malassezia | 55193 | Fungi | Fungi | 590 | 5.2499999999999984e-164 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g413 | i0 | 99.387 | 43.0122699386503 | 326 | 0 | 100 | 1 | 1 | 326 | 32416 | 32739 | Malassezia restricta mitochondrion, complete genome | blastn | 14022 | 590 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17567863 | 17567863 | PRJEB4632_P_NODE_194_length_551_cov_7.755230_g156_i0 | PRJEB4632 | 194 | 551 | 7.75523 | 42.7313173 | Agaricomycetes | 155619 | Fungi | Fungi | 675 | 0 | NTclustered | gi|817033502|gb|KP135272.1| | 82310 | g156 | i0 | 92.421 | 86.5553539019964 | 475 | 32 | 85 | 3 | 1 | 471 | 582 | 108 | Phlebiopsis gigantea strain FP-70857-Sp 28S ribosomal RNA gene, partial sequence | blastn | 47692 | 675 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis gigantea | |
| 17913097 | 17913097 | PRJEB4632_P_NODE_735_length_253_cov_4.172222_g697_i0 | PRJEB4632 | 735 | 253 | 4.172222 | 10.55572166 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 449 | 6.970000000000001e-122 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g697 | i0 | 98.814 | 75.8379446640316 | 253 | 2 | 100 | 1 | 1 | 253 | 3942 | 3691 | Rhodotorula glutinis strain ATCC 16726 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 | 19187 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 19187096 | 19187096 | PRJEB4632_P_NODE_476_length_320_cov_6.546559_g438_i0 | PRJEB4632 | 476 | 320 | 6.546559 | 20.9489888 | Malassezia restricta | 76775 | Fungi | Fungi | 429 | 1.19e-115 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g438 | i0 | 91.589 | 84.3 | 321 | 12 | 100 | 11 | 1 | 320 | 3304 | 2998 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 26976 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19187099 | 19187099 | PRJEB4632_P_NODE_556_length_300_cov_1.325991_g518_i0 | PRJEB4632 | 556 | 300 | 1.325991 | 3.977973 | Cystofilobasidium capitatum | 5412 | Fungi | Fungi | 370 | 6.78e-98 | NTclustered | gi|501438057|gb|FJ644524.2| | 5412 | g518 | i0 | 89.655 | 141.66 | 290 | 30 | 97 | 0 | 11 | 300 | 1744 | 1455 | Cystofilobasidium capitatum voucher 01/04 28S ribosomal RNA gene, partial sequence | blastn | 42498 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Cystofilobasidiaceae | Cystofilobasidium | Cystofilobasidium capitatum | |
| 19187100 | 19187100 | PRJEB4632_P_NODE_616_length_280_cov_10.371981_g578_i0 | PRJEB4632 | 616 | 280 | 10.371981 | 29.0415468 | Phlebiopsis crassa | 1647769 | Fungi | Fungi | 496 | 9.92e-136 | NTclustered | gi|528533069|dbj|AB809163.1| | 1647769 | g578 | i0 | 98.571 | 104.489285714286 | 280 | 4 | 100 | 0 | 1 | 280 | 6249 | 6528 | Porostereum crassum genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, IGS1, 5S rRNA, partial and complete sequence, strain: MAFF 420737 | blastn | 29257 | 496 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis crassa | |
| 20116584 | 20116584 | PRJEB4632_P_NODE_236_length_493_cov_3.538095_g198_i0 | PRJEB4632 | 236 | 493 | 3.538095 | 17.44280835 | Ustilaginaceae | 5268 | Fungi | Fungi | 911 | 0 | NTclustered | gi|501438078|gb|FJ644528.2| | 5270 | g198 | i0 | 100 | 89.9290060851927 | 493 | 0 | 100 | 0 | 1 | 493 | 1727 | 1235 | Ustilago maydis voucher TUB 019110 28S ribosomal RNA gene, partial sequence | blastn | 44335 | 911 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 20116590 | 20116590 | PRJEB4632_P_NODE_496_length_314_cov_12.672199_g458_i0 | PRJEB4632 | 496 | 314 | 12.672199 | 39.79070486 | Agaricomycetes | 155619 | Fungi | Fungi | 580 | 3.0299999999999992e-161 | NTclustered | gi|13377979|gb|AF334933.1| | 40462 | g458 | i0 | 100 | 100.977707006369 | 314 | 0 | 100 | 0 | 1 | 314 | 898 | 585 | Pulcherricium caeruleum small subunit ribosomal RNA gene, partial sequence | blastn | 31707 | 580 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Terana | Terana coerulea | |
| 23013543 | 23013543 | PRJEB4632_P_NODE_799_length_250_cov_0.870056_g761_i0 | PRJEB4632 | 799 | 250 | 0.870056 | 2.17514 | Phlebiopsis gigantea 11 | 82310 | Fungi | Fungi | 176 | 8e-51 | NR | KIP12906.1 | 745531 | g761 | i0 | 98.8 | 0.984 | 82 | 1 | 98.4 | 0 | 248 | 3 | 84 | 165 | KIP12906.1 glycosyltransferase family 32 protein [Phlebiopsis gigantea 11061_1 CR5-6] | diamond | 246 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis gigantea | |
| 23942359 | 23942359 | PRJEB4632_P_NODE_339_length_392_cov_9.228840_g301_i0 | PRJEB4632 | 339 | 392 | 9.22884 | 36.1770528 | Eukaryota | 2759 | Fungi | Fungi | 725 | 0 | NTclustered | gi|8096250|dbj|AB021695.1| | 5004 | g301 | i0 | 100 | 99.9770408163265 | 392 | 0 | 100 | 0 | 1 | 392 | 763 | 1154 | Sporidiobolus ruineniae gene for 18S ribosomal RNA, partial sequence | blastn | 39191 | 725 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodosporidiobolus | Rhodosporidiobolus ruineniae | |
| 24287392 | 24287392 | PRJEB4632_P_NODE_700_length_261_cov_17.648936_g662_i0 | PRJEB4632 | 700 | 261 | 17.648936 | 46.06372296 | Phlebiopsis gigantea | 82310 | Fungi | Fungi | 483 | 7.12e-132 | NTclustered | gi|391883721|gb|JQ768392.1| | 82310 | g662 | i0 | 100 | 104.51724137931 | 261 | 0 | 100 | 0 | 1 | 261 | 2047 | 1787 | Phlebiopsis gigantea isolate 11 large subunit ribosomal RNA gene, partial sequence | blastn | 27279 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phlebiopsis | Phlebiopsis gigantea | |
| 30469419 | 30469419 | PRJEB4632_P_NODE_953_length_243_cov_0.905882_g915_i0 | PRJEB4632 | 953 | 243 | 0.905882 | 2.20129326 | Polyporales | 5303 | Fungi | Fungi | 120 | 1.27e-29 | NR | KAJ3542228.1 | 194682 | g915 | i0 | 76.7 | 5.37037037037037 | 73 | 17 | 90.1 | 0 | 1 | 219 | 366 | 438 | KAJ3542228.1 hypothetical protein NM688_g5996 [Phlebia brevispora] | diamond | 1305 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meruliaceae | Phlebia | Phlebia brevispora |
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);;