contig_metadata
20 rows where bioproject = "PRJNA229468", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 367290 | 367290 | PRJNA229468_S_NODE_841_length_182_cov_0.992481_g828_i0 | PRJNA229468 | 841 | 182 | 0.992481 | 1.80631542 | Sporobolomyces sp. | 1928706 | Fungi | Fungi | 276 | 8.440000000000001e-70 | NTclustered | gi|1976519903|gb|MT663151.1| | 1928706 | g828 | i0 | 93.956 | 39.5879120879121 | 182 | 11 | 100 | 0 | 1 | 182 | 12588 | 12769 | Sporobolomyces sp. mitochondrion, complete genome | blastn | 7205 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces sp. | |
| 1056630 | 1056630 | PRJNA229468_S_NODE_1321_length_152_cov_2.970874_g1308_i0 | PRJNA229468 | 1321 | 152 | 2.970874 | 4.51572848 | Basidiomycota | 5204 | Fungi | Fungi | 281 | 1.46e-71 | NTclustered | gi|1675392|gb|U77062.1|MVU77062 | 5272 | g1308 | i0 | 100 | 100.013157894737 | 152 | 0 | 100 | 0 | 1 | 152 | 913 | 1064 | Microbotryum violaceum 18S ribosomal RNA gene, complete sequence | blastn | 15202 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryales | Microbotryaceae | Microbotryum | Microbotryum violaceum | |
| 1642064 | 1642064 | PRJNA229468_S_NODE_1142_length_164_cov_2.321739_g1129_i0 | PRJNA229468 | 1142 | 164 | 2.321739 | 3.80765196 | Curvibasidium nothofagi | 114767 | Fungi | Fungi | 279 | 5.77e-71 | NTclustered | gi|1858897335|ref|NG_069005.1| | 114767 | g1129 | i0 | 100 | 102.170731707317 | 151 | 0 | 92 | 0 | 1 | 151 | 1259 | 1409 | Curvibasidium nothofagi CBS 8166 28S rRNA gene, partial sequence; from TYPE material | blastn | 16756 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Curvibasidium | Curvibasidium nothofagi | |||
| 2917903 | 2917903 | PRJNA229468_S_NODE_623_length_205_cov_1.519231_g610_i0 | PRJNA229468 | 623 | 205 | 1.519231 | 3.11442355 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 351 | 1.58e-92 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g610 | i0 | 97.561 | 105.336585365854 | 205 | 5 | 100 | 0 | 1 | 205 | 4836 | 5040 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 21594 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 6159317 | 6159317 | PRJNA229468_S_NODE_845_length_181_cov_2.106061_g832_i0 | PRJNA229468 | 845 | 181 | 2.106061 | 3.81197041 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 335 | 1.36e-87 | NTclustered | gi|671394780|gb|KJ806312.1| | 5288 | g832 | i0 | 100 | 100 | 181 | 0 | 100 | 0 | 1 | 181 | 1374 | 1554 | Rhodosporidium diobovatum isolate H-5 18S ribosomal RNA gene, partial sequence | blastn | 18100 | 335 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 7434487 | 7434487 | PRJNA229468_S_NODE_786_length_187_cov_1.108696_g773_i0 | PRJNA229468 | 786 | 187 | 1.108696 | 2.07326152 | Opisthokonta | 33154 | Fungi | Fungi | 346 | 6.56e-91 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g773 | i0 | 100 | 100 | 187 | 0 | 100 | 0 | 1 | 187 | 245 | 431 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 18700 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8020692 | 8020692 | PRJNA229468_S_NODE_727_length_192_cov_4.846154_g714_i0 | PRJNA229468 | 727 | 192 | 4.846154 | 9.30461568 | Geastrum schmidelii | 566083 | Fungi | Fungi | 344 | 2.44e-90 | NTclustered | gi|1859735544|gb|MT644862.1| | 566083 | g714 | i0 | 98.958 | 100.005208333333 | 192 | 2 | 100 | 0 | 1 | 192 | 4850 | 5041 | Geastrum schmidelii isolate DM1180 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 | 19201 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Geastraceae | Geastrum | Geastrum schmidelii | |
| 8709273 | 8709273 | PRJNA229468_S_NODE_907_length_177_cov_1.546875_g894_i0 | PRJNA229468 | 907 | 177 | 1.546875 | 2.73796875 | Curvibasidium | 256806 | Fungi | Fungi | 316 | 4.799999999999999e-82 | NTclustered | gi|2235263546|gb|ON428531.1| | 106008 | g894 | i0 | 98.876 | 100.564971751412 | 178 | 1 | 100 | 1 | 1 | 177 | 479 | 302 | Curvibasidium cygneicollum isolate UASWS2879 NBB-B02 large subunit ribosomal RNA gene, partial sequence | blastn | 17800 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Curvibasidium | Curvibasidium cygneicollum | |||
| 12535173 | 12535173 | PRJNA229468_S_NODE_870_length_180_cov_0.969466_g857_i0 | PRJNA229468 | 870 | 180 | 0.969466 | 1.7450388 | Microbotryomycetes | 162481 | Fungi | Fungi | 333 | 4.87e-87 | NTclustered | gi|52631069|gb|AY745718.1| | 5002 | g857 | i0 | 100 | 96.2333333333333 | 180 | 0 | 100 | 0 | 1 | 180 | 1052 | 873 | Sporobolomyces johnsonii strain CBS5470 25S large subunit ribosomal RNA gene, partial sequence | blastn | 17322 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces johnsonii | |
| 15670094 | 15670094 | PRJNA229468_S_NODE_733_length_191_cov_1.366197_g720_i0 | PRJNA229468 | 733 | 191 | 1.366197 | 2.60943627 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 243 | 9.08e-60 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g720 | i0 | 89.744 | 61.979057591623 | 195 | 12 | 100 | 5 | 1 | 191 | 5538 | 5728 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 11838 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 18218949 | 18218949 | PRJNA229468_S_NODE_1175_length_163_cov_1.342105_g1162_i0 | PRJNA229468 | 1175 | 163 | 1.342105 | 2.18763115 | Melanopsichium pennsylvanicum | 63383 | Fungi | Fungi | 121 | 3.669999999999999e-23 | NTclustered | gi|673528225|emb|HG529616.1| | 1398559 | g1162 | i0 | 80.247 | 2.39263803680982 | 162 | 30 | 99 | 2 | 3 | 163 | 84093 | 84253 | Melanopsichium pennsylvanicum 4 genomic scaffold, scaffold SCAFFOLD63 | blastn | 390 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 19493245 | 19493245 | PRJNA229468_S_NODE_196_length_346_cov_2.754209_g183_i0 | PRJNA229468 | 196 | 346 | 2.754209 | 9.52956314 | Leucosporidium scottii | 5278 | Fungi | Fungi | 568 | 2.6299999999999995e-157 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g183 | i0 | 96.243 | 108.401734104046 | 346 | 13 | 100 | 0 | 1 | 346 | 4230 | 3885 | 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 | 37507 | 568 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 19493249 | 19493249 | PRJNA229468_S_NODE_956_length_173_cov_1.798387_g943_i0 | PRJNA229468 | 956 | 173 | 1.798387 | 3.11120951 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 320 | 3.61e-83 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g943 | i0 | 100 | 81.4682080924856 | 173 | 0 | 100 | 0 | 1 | 173 | 2840 | 2668 | 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 | 14094 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 20182614 | 20182614 | PRJNA229468_S_NODE_296_length_289_cov_1.912500_g283_i0 | PRJNA229468 | 296 | 289 | 1.9125 | 5.527125 | Microbotryomycetes | 162481 | Fungi | Fungi | 529 | 1.01e-145 | NTclustered | gi|2065978375|gb|MZ557051.1| | 5445 | g283 | i0 | 99.654 | 100 | 289 | 1 | 100 | 0 | 1 | 289 | 48 | 336 | Hamamotoa singularis isolate UFMGCB L82 large subunit ribosomal RNA gene, partial sequence | blastn | 28900 | 529 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Chrysozymaceae | Hamamotoa | Hamamotoa singularis | ||
| 22043868 | 22043868 | PRJNA229468_S_NODE_1278_length_158_cov_3.715596_g1265_i0 | PRJNA229468 | 1278 | 158 | 3.715596 | 5.87064168 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 278 | 1.98e-70 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g1265 | i0 | 98.718 | 104.930379746835 | 156 | 2 | 99 | 0 | 1 | 156 | 5566 | 5411 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 16579 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 27042401 | 27042401 | PRJNA229468_S_NODE_282_length_296_cov_1.238866_g269_i0 | PRJNA229468 | 282 | 296 | 1.238866 | 3.66704336 | Sistotremastrum suecicum HHB1 | 467971 | Fungi | Fungi | 127 | 4.48e-33 | NR | KZT36194.1 | 1314776 | g269 | i0 | 59.4 | 0.972972972972973 | 96 | 37 | 97.3 | 1 | 290 | 3 | 29 | 122 | KZT36194.1 GroES-like protein [Sistotremastrum suecicum HHB10207 ss-3] | diamond | 288 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sistotremastrales | Sistotremastraceae | Sistotremastrum | Sistotremastrum suecicum | |
| 27154543 | 27154543 | PRJNA229468_S_NODE_762_length_189_cov_1.092857_g749_i0 | PRJNA229468 | 762 | 189 | 1.092857 | 2.06549973 | Agaricomycetes | 155619 | Fungi | Fungi | 45.1 | 0.00227 | NR | KIY50769.1 | 1128425 | g749 | i0 | 56.8 | 2.19047619047619 | 44 | 19 | 69.8 | 0 | 56 | 187 | 14 | 57 | KIY50769.1 Lumazine synthase [Fistulina hepatica ATCC 64428] | diamond | 414 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Fistulinaceae | Fistulina | Fistulina hepatica | |
| 30060010 | 30060010 | PRJNA229468_S_NODE_1051_length_167_cov_1.296610_g1038_i0 | PRJNA229468 | 1051 | 167 | 1.29661 | 2.1653387 | Basidiomycota | 5204 | Fungi | Fungi | 45.8 | 0.00107 | NR | KNZ45269.1 | 27349 | g1038 | i0 | 44.6 | 4.92215568862275 | 56 | 30 | 98.8 | 1 | 167 | 3 | 60 | 115 | KNZ45269.1 ribosomal protein S5 [Puccinia sorghi] | diamond | 822 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 32603224 | 32603224 | PRJNA229468_S_NODE_800_length_185_cov_1.500000_g787_i0 | PRJNA229468 | 800 | 185 | 1.5 | 2.775 | Mycena floridula | 1033242 | Fungi | Fungi | 43.1 | 0.0126 | NR | KAJ7597478.1 | 1033242 | g787 | i0 | 44.4 | 0.72972972972973 | 45 | 25 | 73 | 0 | 156 | 22 | 127 | 171 | KAJ7597478.1 hypothetical protein C8J56DRAFT_1108633 [Mycena floridula] | diamond | 135 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena floridula | |
| 32666112 | 32666112 | PRJNA229468_S_NODE_1260_length_161_cov_0.901786_g1247_i0 | PRJNA229468 | 1260 | 161 | 0.901786 | 1.45187546 | Meira miltonrushii | 1280837 | Fungi | Fungi | 89 | 6.29e-19 | NR | XP_025355750.1 | 1280837 | g1247 | i0 | 75 | 3.85714285714286 | 52 | 13 | 96.9 | 0 | 160 | 5 | 305 | 356 | XP_025355750.1 putative OSM1-fumarate reductase [Meira miltonrushii] | diamond | 621 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii |
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);;