contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA815356" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 819065 | 819065 | PRJNA815356_P_NODE_11521_length_224_cov_6.735099_g11358_i0 | PRJNA815356 | 11521 | 224 | 6.735099 | 15.08662176 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 409 | 1.03e-109 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g11358 | i0 | 99.554 | 113.959821428571 | 224 | 1 | 100 | 0 | 1 | 224 | 3050 | 3273 | 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 | 25527 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 1227872 | 1227872 | PRJNA815356_P_NODE_6461_length_287_cov_2.705607_g6298_i0 | PRJNA815356 | 6461 | 287 | 2.705607 | 7.76509209 | Marasmius | 34448 | Fungi | Fungi | 464 | 2.8799999999999993e-126 | NTclustered | gi|2320860992|gb|CP097441.1| | 181124 | g6298 | i0 | 95.819 | 102.052264808362 | 287 | 12 | 100 | 0 | 1 | 287 | 10487 | 10773 | Marasmius oreades strain 43B chromosome 7 | blastn | 29289 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius oreades | |
| 2094695 | 2094695 | PRJNA815356_P_NODE_4882_length_321_cov_1.927419_g4719_i0 | PRJNA815356 | 4882 | 321 | 1.927419 | 6.18701499 | Malassezia globosa | 76773 | Fungi | Fungi | 534 | 2.4499999999999995e-147 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g4719 | i0 | 96.605 | 72.4641744548287 | 324 | 8 | 100 | 2 | 1 | 321 | 2527 | 2850 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 23261 | 534 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 2503420 | 2503420 | PRJNA815356_P_NODE_7202_length_274_cov_2.706468_g7039_i0 | PRJNA815356 | 7202 | 274 | 2.706468 | 7.41572232 | Cystofilobasidium | 5410 | Fungi | Fungi | 507 | 4.47e-139 | NTclustered | gi|460422684|gb|JX967528.1| | 5412 | g7039 | i0 | 100 | 99.551094890511 | 274 | 0 | 100 | 0 | 1 | 274 | 291 | 564 | Cystofilobasidium capitatum strain S11-Y1 26S ribosomal RNA gene, partial sequence | blastn | 27277 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Cystofilobasidiaceae | Cystofilobasidium | Cystofilobasidium capitatum | |
| 3369994 | 3369994 | PRJNA815356_P_NODE_8923_length_252_cov_1.737430_g8760_i0 | PRJNA815356 | 8923 | 252 | 1.73743 | 4.3783236 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 460 | 3.2e-125 | NTclustered | gi|2635632557|gb|CP137882.1| | 5537 | g8760 | i0 | 99.603 | 4.07142857142857 | 252 | 1 | 100 | 0 | 1 | 252 | 31198 | 30947 | Rhodotorula mucilaginosa strain GDMCC2.30 mitochondrion, complete genome | blastn | 1026 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 3779778 | 3779778 | PRJNA815356_P_NODE_2983_length_393_cov_1.956250_g2820_i0 | PRJNA815356 | 2983 | 393 | 1.95625 | 7.6880625 | Malassezia | 55193 | Fungi | Fungi | 726 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g2820 | i0 | 100 | 73.2442748091603 | 393 | 0 | 100 | 0 | 1 | 393 | 32419 | 32811 | Malassezia restricta mitochondrion, complete genome | blastn | 28785 | 726 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3779779 | 3779779 | PRJNA815356_P_NODE_3463_length_369_cov_2.263514_g3300_i0 | PRJNA815356 | 3463 | 369 | 2.263514 | 8.35236666 | Malassezia | 55193 | Fungi | Fungi | 604 | 2.149999999999999e-168 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g3300 | i0 | 100 | 59.4037940379404 | 327 | 0 | 89 | 0 | 43 | 369 | 33284 | 33610 | Malassezia restricta mitochondrion, complete genome | blastn | 21920 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3779785 | 3779785 | PRJNA815356_P_NODE_5343_length_310_cov_8.485232_g5180_i0 | PRJNA815356 | 5343 | 310 | 8.485232 | 26.3042192 | Opisthokonta | 33154 | Fungi | Fungi | 568 | 2.3299999999999995e-157 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5180 | i0 | 99.677 | 93.1741935483871 | 310 | 1 | 100 | 0 | 1 | 310 | 389 | 698 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 28884 | 568 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5922337 | 5922337 | PRJNA815356_P_NODE_6185_length_292_cov_2.091324_g6022_i0 | PRJNA815356 | 6185 | 292 | 2.091324 | 6.10666608 | Vishniacozyma sp. | 1902918 | Fungi | Fungi | 540 | 4.74e-149 | NTclustered | gi|2077662260|gb|MZ728069.1| | 1902918 | g6022 | i0 | 100 | 99.5171232876712 | 292 | 0 | 100 | 0 | 1 | 292 | 312 | 21 | Vishniacozyma sp. isolate 3C large subunit ribosomal RNA gene, partial sequence | blastn | 29059 | 540 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Vishniacozyma | Vishniacozyma sp. | |
| 7197324 | 7197324 | PRJNA815356_P_NODE_8006_length_263_cov_1.384211_g7843_i0 | PRJNA815356 | 8006 | 263 | 1.384211 | 3.64047493 | Malassezia globosa | 76773 | Fungi | Fungi | 464 | 2.5999999999999993e-126 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g7843 | i0 | 98.846 | 32.8326996197719 | 260 | 3 | 99 | 0 | 1 | 260 | 1465 | 1724 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 8635 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7605912 | 7605912 | PRJNA815356_P_NODE_3706_length_359_cov_5.688811_g3543_i0 | PRJNA815356 | 3706 | 359 | 5.688811 | 20.42283149 | Eukaryota | 2759 | Fungi | Fungi | 647 | 0 | NTclustered | gi|8096250|dbj|AB021695.1| | 5004 | g3543 | i0 | 99.164 | 100.00835654596101 | 359 | 3 | 100 | 0 | 1 | 359 | 769 | 1127 | Sporidiobolus ruineniae gene for 18S ribosomal RNA, partial sequence | blastn | 35903 | 652 | 0.992331288343558 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodosporidiobolus | Rhodosporidiobolus ruineniae | |
| 7605922 | 7605922 | PRJNA815356_P_NODE_8286_length_259_cov_2.279570_g8123_i0 | PRJNA815356 | 8286 | 259 | 2.27957 | 5.9040863 | Malassezia | 55193 | Fungi | Fungi | 479 | 9.13e-131 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g8123 | i0 | 100 | 47.2355212355212 | 259 | 0 | 100 | 0 | 1 | 259 | 33196 | 32938 | Malassezia restricta mitochondrion, complete genome | blastn | 12234 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10156422 | 10156422 | PRJNA815356_P_NODE_7188_length_274_cov_4.606965_g7025_i0 | PRJNA815356 | 7188 | 274 | 4.606965 | 12.6230841 | Rhodotorula | 5533 | Fungi | Fungi | 507 | 4.47e-139 | NTclustered | gi|1102645447|gb|KY109017.1| | 5288 | g7025 | i0 | 100 | 100 | 274 | 0 | 100 | 0 | 1 | 274 | 548 | 275 | Rhodotorula diobovata culture CBS:11079 large subunit ribosomal RNA gene, partial sequence | blastn | 27400 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 11022946 | 11022946 | PRJNA815356_P_NODE_8209_length_260_cov_2.267380_g8046_i0 | PRJNA815356 | 8209 | 260 | 2.26738 | 5.895188 | uncultured Filobasidiella | 1503101 | Fungi | Fungi | 412 | 9.43e-111 | NTclustered | gi|387156411|emb|HE806144.1| | 1503101 | g8046 | i0 | 95.703 | 140.469230769231 | 256 | 11 | 98 | 0 | 3 | 258 | 1721 | 1466 | Uncultured Filobasidiella partial 26S rRNA gene, clone Ao0Yyyy6 | blastn | 36522 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | uncultured Filobasidiella | ||
| 12707447 | 12707447 | PRJNA815356_P_NODE_11850_length_197_cov_9.685484_g11687_i0 | PRJNA815356 | 11850 | 197 | 9.685484 | 19.08040348 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 364 | 1.929999999999999e-96 | NTclustered | gi|671394780|gb|KJ806312.1| | 5288 | g11687 | i0 | 100 | 100 | 197 | 0 | 100 | 0 | 1 | 197 | 1577 | 1381 | Rhodosporidium diobovatum isolate H-5 18S ribosomal RNA gene, partial sequence | blastn | 19700 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 13572663 | 13572663 | PRJNA815356_P_NODE_1611_length_510_cov_17.970252_g1449_i0 | PRJNA815356 | 1611 | 510 | 17.970252 | 91.6482852 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 872 | 0 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g1449 | i0 | 97.826 | 106.23137254902 | 506 | 9 | 99 | 2 | 1 | 505 | 2566 | 2062 | 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 | 54178 | 872 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 13981738 | 13981738 | PRJNA815356_P_NODE_8111_length_262_cov_0.825397_g7948_i0 | PRJNA815356 | 8111 | 262 | 0.825397 | 2.16254014 | Malassezia | 55193 | Fungi | Fungi | 436 | 5.649999999999999e-118 | NTclustered | gi|1321659599|gb|KY911093.1| | 76775 | g7948 | i0 | 96.947 | 9.51526717557252 | 262 | 5 | 99 | 3 | 2 | 262 | 552 | 293 | Malassezia restricta mitochondrion, complete genome | blastn | 2493 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14847254 | 14847254 | PRJNA815356_P_NODE_7912_length_264_cov_1.633508_g7749_i0 | PRJNA815356 | 7912 | 264 | 1.633508 | 4.31246112 | Malassezia restricta | 76775 | Fungi | Fungi | 213 | 1.05e-50 | NTclustered | gi|1546632684|ref|XM_027628002.1| | 76775 | g7749 | i0 | 93.103 | 0.549242424242424 | 145 | 10 | 55 | 0 | 1 | 145 | 1062 | 1206 | Malassezia restricta translation initiation factor 4E (MRET_1375), partial mRNA | blastn | 145 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16121704 | 16121704 | PRJNA815356_P_NODE_1093_length_610_cov_2.527002_g933_i0 | PRJNA815356 | 1093 | 610 | 2.527002 | 15.4147122 | Malassezia globosa | 76773 | Fungi | Fungi | 1127 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g933 | i0 | 100 | 62.3262295081967 | 610 | 0 | 100 | 0 | 1 | 610 | 1036 | 427 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 38019 | 1127 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 21629890 | 21629890 | PRJNA815356_P_NODE_3017_length_391_cov_2.893082_g2854_i0 | PRJNA815356 | 3017 | 391 | 2.893082 | 11.31195062 | root | 1 | Root_unresolved | Root_unresolved | 662 | 0 | NTclustered | gi|1476588018|gb|MH915574.1| | 5358 | g2854 | i0 | 97.187 | 100 | 391 | 11 | 100 | 0 | 1 | 391 | 987 | 597 | Lentinus crinitus strain DPUA1693 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 | 39100 | 662 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus crinitus | |
| 25045471 | 25045471 | PRJNA815356_P_NODE_7280_length_273_cov_2.090000_g7117_i0 | PRJNA815356 | 7280 | 273 | 2.09 | 5.7057 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 505 | 1.6e-138 | NTclustered | gi|2635632557|gb|CP137882.1| | 5537 | g7117 | i0 | 100 | 3.56043956043956 | 273 | 0 | 100 | 0 | 1 | 273 | 28583 | 28855 | Rhodotorula mucilaginosa strain GDMCC2.30 mitochondrion, complete genome | blastn | 972 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa |
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);;