contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1108009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2763790 | 2763790 | PRJNA1108009_P_NODE_26503_length_249_cov_0.875000_g26185_i0 | PRJNA1108009 | 26503 | 249 | 0.875 | 2.17875 | Dichomitus squalens | 114155 | Fungi | Fungi | 226 | 1.2499999999999999e-54 | NTclustered | gi|597971206|ref|XM_007360823.1| | 732165 | g26185 | i0 | 85.321 | 0.875502008032129 | 218 | 32 | 88 | 0 | 26 | 243 | 1 | 218 | Dichomitus squalens LYAD-421 SS1 uncharacterized protein (DICSQDRAFT_164378), partial mRNA | blastn | 218 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Dichomitus | Dichomitus squalens | |
| 2763847 | 2763847 | PRJNA1108009_P_NODE_28803_length_245_cov_0.895349_g28485_i0 | PRJNA1108009 | 28803 | 245 | 0.895349 | 2.19360505 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 220 | 5.73e-53 | NTclustered | gi|2669759143|ref|XM_062773891.1| | 143232 | g28485 | i0 | 82.927 | 21.3020408163265 | 246 | 40 | 100 | 2 | 1 | 245 | 1007 | 763 | Vanrija pseudolonga Serine/threonine-protein phosphatase PP2A catalytic subunit (pph-1), mRNA | blastn | 5219 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 4039812 | 4039812 | PRJNA1108009_P_NODE_23924_length_256_cov_1.262295_g23606_i0 | PRJNA1108009 | 23924 | 256 | 1.262295 | 3.2314752 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 76.8 | 1.38e-9 | NTclustered | gi|1423586809|ref|XM_025743193.1| | 58919 | g23606 | i0 | 92.453 | 0.42578125 | 53 | 4 | 21 | 0 | 83 | 135 | 238 | 186 | Tilletiopsis washingtonensis putative 40S ribosomal protein S12 (FA09DRAFT_331821), mRNA | blastn | 109 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 12966579 | 12966579 | PRJNA1108009_P_NODE_13211_length_365_cov_1.287671_g12893_i0 | PRJNA1108009 | 13211 | 365 | 1.287671 | 4.69999915 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 219 | 3.2299999999999998e-52 | NTclustered | gi|1423589748|ref|XM_025743508.1| | 58919 | g12893 | i0 | 80.339 | 49.1342465753425 | 295 | 52 | 80 | 6 | 67 | 358 | 70 | 361 | Tilletiopsis washingtonensis putative 40S ribosomal protein S15 (FA09DRAFT_332566), mRNA | blastn | 17934 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 16790262 | 16790262 | PRJNA1108009_P_NODE_28474_length_246_cov_0.890173_g28156_i0 | PRJNA1108009 | 28474 | 246 | 0.890173 | 2.18982558 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 126 | 1.29e-24 | NTclustered | gi|1071047953|ref|XM_018424849.1| | 879819 | g28156 | i0 | 85.366 | 45.3577235772358 | 123 | 16 | 50 | 2 | 1 | 122 | 588 | 709 | Cutaneotrichosporon oleaginosum uncharacterized protein (COLE_02321), partial mRNA | blastn | 11158 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 18064304 | 18064304 | PRJNA1108009_P_NODE_10235_length_422_cov_1.593123_g9917_i0 | PRJNA1108009 | 10235 | 422 | 1.593123 | 6.72297906 | Peniophora piceae | 55352 | Fungi | Fungi | 741 | 0 | NTclustered | gi|480326996|gb|JX507719.1| | 55352 | g9917 | i0 | 98.345 | 106.64691943128 | 423 | 6 | 100 | 1 | 1 | 422 | 1835 | 1413 | Peniophora piceae isolate 209 large subunit ribosomal RNA gene, partial sequence | blastn | 45005 | 741 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora piceae | |
| 18064349 | 18064349 | PRJNA1108009_P_NODE_11955_length_386_cov_2.137380_g11637_i0 | PRJNA1108009 | 11955 | 386 | 2.13738 | 8.2502868 | Macalpinomyces eriachnes | 307738 | Fungi | Fungi | 211 | 5.75e-50 | NTclustered | gi|979839622|gb|KP323142.1| | 307738 | g11637 | i0 | 76.845 | 70.5129533678757 | 393 | 80 | 100 | 10 | 1 | 386 | 924 | 536 | Macalpinomyces eriachnes strain CBS 131454 translation elongation factor 1-alpha (tef1) gene, partial cds | blastn | 27218 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Macalpinomyces | Macalpinomyces eriachnes | |
| 19338597 | 19338597 | PRJNA1108009_P_NODE_14256_length_350_cov_0.823105_g13938_i0 | PRJNA1108009 | 14256 | 350 | 0.823105 | 2.8808675 | Kwoniella mangrovensis | 463800 | Fungi | Fungi | 52.8 | 0.033 | NTclustered | gi|1101809552|ref|XM_019145575.1| | 1296122 | g13938 | i0 | 100 | 0.08 | 28 | 0 | 8 | 0 | 103 | 130 | 1144 | 1117 | Kwoniella mangroviensis CBS 8507 uncharacterized protein (I203_107494), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella mangrovensis | |
| 19338787 | 19338787 | PRJNA1108009_P_NODE_20476_length_284_cov_1.094787_g20158_i0 | PRJNA1108009 | 20476 | 284 | 1.094787 | 3.10919508 | Coniophora puteana | 80637 | Fungi | Fungi | 195 | 4.12e-45 | NTclustered | gi|628844737|ref|XM_007773228.1| | 741705 | g20158 | i0 | 80.385 | 29.2183098591549 | 260 | 47 | 91 | 4 | 6 | 263 | 387 | 130 | Coniophora puteana RWD-64-598 SS2 uncharacterized protein (CONPUDRAFT_108225), mRNA | blastn | 8298 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Coniophoraceae | Coniophora | Coniophora puteana | |
| 20146827 | 20146827 | PRJNA1108009_P_NODE_13236_length_364_cov_2.601375_g12918_i0 | PRJNA1108009 | 13236 | 364 | 2.601375 | 9.469005 | Fungi | 4751 | Fungi | Fungi | 211 | 5.38e-50 | NTclustered | gi|1069920474|ref|XM_018418514.1| | 578459 | g12918 | i0 | 82.143 | 67.9010989010989 | 252 | 39 | 69 | 4 | 1 | 251 | 371 | 125 | Rhodotorula graminis WP1 40S ribosomal protein S2 (RHOBADRAFT_64558), partial mRNA | blastn | 24716 | 213 | 0.990610328638498 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 23972782 | 23972782 | PRJNA1108009_P_NODE_15179_length_338_cov_1.162264_g14861_i0 | PRJNA1108009 | 15179 | 338 | 1.162264 | 3.92845232 | Agaricomycetes | 155619 | Fungi | Fungi | 215 | 3.85e-51 | NTclustered | gi|170095953|ref|XM_001879162.1| | 486041 | g14861 | i0 | 80.205 | 29.1538461538462 | 293 | 53 | 86 | 5 | 47 | 338 | 511 | 223 | Laccaria bicolor S238N-H82 60S ribosomal protein L4 (LACBIDRAFT_178618), partial mRNA | blastn | 9854 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hydnangiaceae | Laccaria | Laccaria bicolor | |
| 25246855 | 25246855 | PRJNA1108009_P_NODE_20640_length_282_cov_1.961722_g20322_i0 | PRJNA1108009 | 20640 | 282 | 1.961722 | 5.53205604 | Hohenbuehelia | 71886 | Fungi | Fungi | 516 | 7.67e-142 | NTclustered | gi|148923689|gb|EF409757.1| | 47250 | g20322 | i0 | 99.645 | 100.003546099291 | 282 | 1 | 100 | 0 | 1 | 282 | 987 | 706 | Hohenbuehelia robusta strain 03-RGTSN-519 18S small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence | blastn | 28201 | 516 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Hohenbuehelia | Hohenbuehelia robusta |
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);;