contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1074407" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5291690 | 5291690 | PRJNA1074407_P_NODE_147045_length_239_cov_1.216867_g143207_i0 | PRJNA1074407 | 147045 | 239 | 1.216867 | 2.90831213 | Meira miltonrushii | 1280837 | Fungi | Fungi | 298 | 2.5e-76 | NTclustered | gi|1418875176|ref|XM_025502832.1| | 1280837 | g143207 | i0 | 89.121 | 1.33891213389121 | 239 | 26 | 100 | 0 | 1 | 239 | 164 | 402 | Meira miltonrushii putative glutathione-dependent formaldehyde dehydrogenase (FA14DRAFT_75567), mRNA | blastn | 320 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 11219780 | 11219780 | PRJNA1074407_P_NODE_129489_length_262_cov_4.021164_g125651_i0 | PRJNA1074407 | 129489 | 262 | 4.021164 | 10.53544968 | Tremellales | 5234 | Fungi | Fungi | 479 | 9.249999999999999e-131 | NTclustered | gi|12744205|gb|AF314232.1|AF314232 | 4972 | g125651 | i0 | 99.618 | 100.003816793893 | 262 | 1 | 100 | 0 | 1 | 262 | 87 | 348 | Cryptococcus hungaricus strain CBS 5124 18S ribosomal RNA gene, partial sequence | blastn | 26201 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 11668022 | 11668022 | PRJNA1074407_P_NODE_29670_length_1058_cov_1.535025_g26629_i0 | PRJNA1074407 | 29670 | 1058 | 1.535025 | 16.2405645 | Puccinia striiformis | 27350 | Fungi | Fungi | 58.4 | 0.002 | NTclustered | gi|2234878939|ref|XM_047940579.1| | 168172 | g26629 | i0 | 100 | 0.0293005671077505 | 31 | 0 | 3 | 0 | 331 | 361 | 27 | 57 | Puccinia striiformis f. sp. tritici uncharacterized protein (Pst134EA_000935), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 12942499 | 12942499 | PRJNA1074407_P_NODE_139511_length_246_cov_0.878613_g135673_i0 | PRJNA1074407 | 139511 | 246 | 0.878613 | 2.16138798 | Meira miltonrushii | 1280837 | Fungi | Fungi | 315 | 2.57e-81 | NTclustered | gi|1418861865|ref|XM_025498056.1| | 1280837 | g135673 | i0 | 89.796 | 1.46747967479675 | 245 | 25 | 99 | 0 | 2 | 246 | 762 | 518 | Meira miltonrushii putative ZWF1-glucose-6-phosphate dehydrogenase (FA14DRAFT_159112), mRNA | blastn | 361 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 12942649 | 12942649 | PRJNA1074407_P_NODE_147931_length_236_cov_3.085890_g144093_i0 | PRJNA1074407 | 147931 | 236 | 3.08589 | 7.2827004 | Dioszegia hungarica | 4972 | Fungi | Fungi | 348 | 2.41e-91 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g144093 | i0 | 93.22 | 145.432203389831 | 236 | 16 | 100 | 0 | 1 | 236 | 3317 | 3082 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 34322 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 16765470 | 16765470 | PRJNA1074407_P_NODE_124494_length_275_cov_1.876238_g120656_i0 | PRJNA1074407 | 124494 | 275 | 1.876238 | 5.1596545 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 405 | 1.68e-108 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g120656 | i0 | 93.727 | 93.1963636363636 | 271 | 16 | 98 | 1 | 1 | 270 | 3842 | 4112 | Cystobasidium laryngis 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 | 25629 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 16765497 | 16765497 | PRJNA1074407_P_NODE_125954_length_272_cov_0.763819_g122116_i0 | PRJNA1074407 | 125954 | 272 | 0.763819 | 2.07758768 | Gloeophyllum sepiarium | 40444 | Fungi | Fungi | 313 | 1.04e-80 | NTclustered | gi|34915795|emb|AJ583432.1| | 40444 | g122116 | i0 | 87.546 | 97.0330882352941 | 273 | 30 | 100 | 4 | 1 | 272 | 3241 | 2972 | Gloeophyllum sepiarium 28S rRNA gene, isolate P198 | blastn | 26393 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Gloeophyllum | Gloeophyllum sepiarium | |
| 18040237 | 18040237 | PRJNA1074407_P_NODE_127895_length_266_cov_1.958549_g124057_i0 | PRJNA1074407 | 127895 | 266 | 1.958549 | 5.20974034 | Hannaella oryzae | 4979 | Fungi | Fungi | 492 | 1.2099999999999999e-134 | NTclustered | gi|388597922|gb|JQ754052.1| | 4979 | g124057 | i0 | 100 | 99.1578947368421 | 266 | 0 | 100 | 0 | 1 | 266 | 334 | 599 | Hannaella oryzae strain CMON6 large subunit ribosomal RNA gene, partial sequence | blastn | 26376 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Hannaella | Hannaella oryzae | |
| 18040321 | 18040321 | PRJNA1074407_P_NODE_131675_length_257_cov_1.239130_g127837_i0 | PRJNA1074407 | 131675 | 257 | 1.23913 | 3.1845641 | Dioszegia hungarica | 4972 | Fungi | Fungi | 392 | 1.21e-104 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g127837 | i0 | 94.163 | 148.08560311284 | 257 | 15 | 100 | 0 | 1 | 257 | 1855 | 1599 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 38058 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 20589830 | 20589830 | PRJNA1074407_P_NODE_141177_length_244_cov_0.888889_g137339_i0 | PRJNA1074407 | 141177 | 244 | 0.888889 | 2.16888916 | Meira miltonrushii | 1280837 | Fungi | Fungi | 204 | 5.74e-48 | NTclustered | gi|1418868823|ref|XM_025496996.1| | 1280837 | g137339 | i0 | 82.329 | 1.31967213114754 | 249 | 30 | 98 | 12 | 7 | 244 | 3388 | 3143 | Meira miltonrushii putative YEF3-translation elongation factor eEF3 (FA14DRAFT_135086), mRNA | blastn | 322 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 21865089 | 21865089 | PRJNA1074407_P_NODE_113978_length_304_cov_0.987013_g110140_i0 | PRJNA1074407 | 113978 | 304 | 0.987013 | 3.00051952 | Dioszegia changbaiensis | 234950 | Fungi | Fungi | 479 | 1.1e-130 | NTclustered | gi|1894457363|gb|MT755637.1| | 234950 | g110140 | i0 | 95.066 | 96.3815789473684 | 304 | 15 | 100 | 0 | 1 | 304 | 2868 | 2565 | Dioszegia changbaiensis mitochondrion, complete genome | blastn | 29300 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia changbaiensis | |
| 23140549 | 23140549 | PRJNA1074407_P_NODE_113679_length_305_cov_0.956897_g109841_i0 | PRJNA1074407 | 113679 | 305 | 0.956897 | 2.91853585 | Meira miltonrushii | 1280837 | Fungi | Fungi | 270 | 7.2099999999999995e-68 | NTclustered | gi|1418870733|ref|XM_025496601.1| | 1280837 | g109841 | i0 | 82.781 | 0.99016393442623 | 302 | 52 | 99 | 0 | 1 | 302 | 17 | 318 | Meira miltonrushii uncharacterized protein (FA14DRAFT_123773), partial mRNA | blastn | 302 | 270 | 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);;