contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4696653 | 4696653 | PRJNA893346_P_NODE_27464_length_287_cov_1.803738_g26974_i0 | PRJNA893346 | 27464 | 287 | 1.803738 | 5.17672806 | Kockovaella imperatae | 4999 | Fungi | Fungi | 320 | 6.59e-83 | NTclustered | gi|1227120895|ref|XM_022013926.1| | 4999 | g26974 | i0 | 86.851 | 98.2857142857143 | 289 | 34 | 100 | 4 | 1 | 287 | 947 | 661 | Kockovaella imperatae translation elongation factor 2 (BD324DRAFT_601102), mRNA | blastn | 28208 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 4697087 | 4697087 | PRJNA893346_P_NODE_8324_length_550_cov_1.964361_g7843_i0 | PRJNA893346 | 8324 | 550 | 1.964361 | 10.8039855 | Serendipita herbamans | 1505950 | Fungi | Fungi | 137 | 1.4500000000000002e-27 | NTclustered | gi|514995898|gb|KF061285.1| | 1505950 | g7843 | i0 | 73.822 | 23.7690909090909 | 382 | 84 | 68 | 11 | 151 | 525 | 2584 | 2212 | Serendipita herbamans strain S1 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 | 13073 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita herbamans | |
| 6347261 | 6347261 | PRJNA893346_P_NODE_12725_length_438_cov_1.712329_g12239_i0 | PRJNA893346 | 12725 | 438 | 1.712329 | 7.50000102 | Cutaneotrichosporon | 1838142 | Fungi | Fungi | 231 | 5.07e-56 | NTclustered | gi|2612494432|ref|XM_060600709.1| | 279322 | g12239 | i0 | 78.226 | 67.1301369863014 | 372 | 73 | 84 | 8 | 52 | 419 | 398 | 31 | Cutaneotrichosporon cavernicola uncharacterized protein (RPL10), partial mRNA | blastn | 29403 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cavernicola | |
| 11071930 | 11071930 | PRJNA893346_P_NODE_33429_length_251_cov_0.865169_g32939_i0 | PRJNA893346 | 33429 | 251 | 0.865169 | 2.17157419 | Suillus clintonianus | 1904413 | Fungi | Fungi | 60.2 | 1.36e-4 | NTclustered | gi|2033522291|ref|XM_041355278.1| | 1904413 | g32939 | i0 | 100 | 0.127490039840637 | 32 | 0 | 13 | 0 | 76 | 107 | 479 | 510 | Suillus clintonianus Haloacid dehalogenase-like hydrolase-domain-containing protein (DEU56DRAFT_857252), mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus clintonianus | |
| 14895754 | 14895754 | PRJNA893346_P_NODE_10012_length_498_cov_1.811765_g9528_i0 | PRJNA893346 | 10012 | 498 | 1.811765 | 9.0225897 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 409 | 2.5099999999999996e-109 | NTclustered | gi|955488054|ref|XM_014800230.1| | 84753 | g9528 | i0 | 82.729 | 88.3453815261044 | 469 | 72 | 94 | 6 | 4 | 469 | 470 | 8 | Moesziomyces antarcticus adenosylhomocysteinase (PAN0_011d4260), partial mRNA | blastn | 43996 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 14896111 | 14896111 | PRJNA893346_P_NODE_23332_length_317_cov_1.081967_g22842_i0 | PRJNA893346 | 23332 | 317 | 1.081967 | 3.42983539 | Kwoniella dendrophila | 4975 | Fungi | Fungi | 187 | 7.8e-43 | NTclustered | gi|2752980948|ref|XM_066217037.1| | 1295534 | g22842 | i0 | 80.8 | 15.8706624605678 | 250 | 38 | 77 | 9 | 30 | 274 | 1016 | 772 | Kwoniella dendrophila CBS 6074 uncharacterized protein (L201_001247), partial mRNA | blastn | 5031 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dendrophila | |
| 19994510 | 19994510 | PRJNA893346_P_NODE_14376_length_411_cov_1.366864_g13888_i0 | PRJNA893346 | 14376 | 411 | 1.366864 | 5.61781104 | Pseudomicrostroma glucosiphilum | 1684307 | Fungi | Fungi | 52.8 | 0.039 | NTclustered | gi|1418630799|ref|XM_025489364.1| | 1684307 | g13888 | i0 | 100 | 0.0681265206812652 | 28 | 0 | 7 | 0 | 269 | 296 | 337 | 364 | Pseudomicrostroma glucosiphilum hypothetical protein (BCV69DRAFT_153071), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Pseudomicrostroma | Pseudomicrostroma glucosiphilum | ||
| 21270293 | 21270293 | PRJNA893346_P_NODE_35857_length_247_cov_0.885057_g35367_i0 | PRJNA893346 | 35857 | 247 | 0.885057 | 2.18609079 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 211 | 3.48e-50 | NTclustered | gi|2669770239|ref|XM_062775797.1| | 143232 | g35367 | i0 | 89.286 | 36.5303643724696 | 168 | 18 | 68 | 0 | 69 | 236 | 1288 | 1121 | Vanrija pseudolonga Enolase (ENO), mRNA | blastn | 9023 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 23819988 | 23819988 | PRJNA893346_P_NODE_11899_length_454_cov_2.125984_g11414_i0 | PRJNA893346 | 11899 | 454 | 2.125984 | 9.65196736 | Cutaneotrichosporon cavernicola | 279322 | Fungi | Fungi | 252 | 4.04e-62 | NTclustered | gi|2612493282|ref|XM_060600410.1| | 279322 | g11414 | i0 | 77.857 | 40.2180616740088 | 420 | 75 | 91 | 12 | 3 | 417 | 420 | 14 | Cutaneotrichosporon cavernicola uncharacterized protein (GPD), partial mRNA | blastn | 18259 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cavernicola | |
| 23820210 | 23820210 | PRJNA893346_P_NODE_20119_length_343_cov_3.311111_g19630_i0 | PRJNA893346 | 20119 | 343 | 3.311111 | 11.35711073 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 115 | 4.08e-21 | NTclustered | gi|599384953|ref|XM_007409345.1| | 747676 | g19630 | i0 | 78.307 | 1.87755102040816 | 189 | 33 | 55 | 6 | 155 | 342 | 220 | 401 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_71681), mRNA | blastn | 644 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 25094111 | 25094111 | PRJNA893346_P_NODE_22480_length_324_cov_0.848606_g21991_i0 | PRJNA893346 | 22480 | 324 | 0.848606 | 2.74948344 | Puccinia striiformis | 27350 | Fungi | Fungi | 191 | 6.18e-44 | NTclustered | gi|2234896941|ref|XM_047949413.1| | 168172 | g21991 | i0 | 80.62 | 35.0246913580247 | 258 | 41 | 79 | 8 | 1 | 255 | 398 | 649 | Puccinia striiformis f. sp. tritici uncharacterized protein (Pst134EA_018985), mRNA | blastn | 11348 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis |
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);;