contig_metadata
7 rows where bioproject = "PRJNA1242190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6728652 | 6728652 | PRJNA1242190_S_NODE_12206_length_251_cov_0.876404_g12199_i0 | PRJNA1242190 | 12206 | 251 | 0.876404 | 2.19977404 | Schizopora paradoxa | 27342 | Fungi | Fungi | 150 | 7.84e-32 | NTclustered | gi|1747251884|ref|NC_044679.1| | 27342 | g12199 | i0 | 82.184 | 57.9561752988048 | 174 | 31 | 69 | 0 | 23 | 196 | 44136 | 44309 | Schizopora paradoxa strain KUC8140 mitochondrion, complete genome | blastn | 14547 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 19477028 | 19477028 | PRJNA1242190_S_NODE_6136_length_336_cov_2.159696_g6129_i0 | PRJNA1242190 | 6136 | 336 | 2.159696 | 7.25657856 | Tremella mesenterica | 5217 | Fungi | Fungi | 135 | 3.06e-27 | NTclustered | gi|589277595|ref|XM_007004466.1| | 578456 | g6129 | i0 | 91.753 | 25.3839285714286 | 97 | 8 | 29 | 0 | 1 | 97 | 474 | 570 | Tremella mesenterica DSM 1558 uncharacterized protein (TREMEDRAFT_44037), mRNA | blastn | 8529 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 23303304 | 23303304 | PRJNA1242190_S_NODE_4119_length_396_cov_2.839009_g4112_i0 | PRJNA1242190 | 4119 | 396 | 2.839009 | 11.24247564 | Eukaryota | 2759 | Fungi | Fungi | 125 | 9.03e-34 | NR | CEQ40310.1 | 5005 | g4112 | i0 | 81.2 | 17.75 | 69 | 13 | 52.3 | 0 | 394 | 188 | 78 | 146 | CEQ40310.1 SPOSA6832_01923 [Sporobolomyces salmonicolor] | diamond | 7029 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 26883902 | 26883902 | PRJNA1242190_S_NODE_10461_length_267_cov_1.840206_g10454_i0 | PRJNA1242190 | 10461 | 267 | 1.840206 | 4.91335002 | Malassezia brasiliensis | 1821822 | Fungi | Fungi | 47 | 0.00163 | NR | WFC95400.1 | 1821822 | g10454 | i0 | 37.3 | 0.662921348314607 | 59 | 36 | 65.2 | 1 | 2 | 175 | 1406 | 1464 | WFC95400.1 phosphoinositide 5-phosphatase [Malassezia brasiliensis] | diamond | 177 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia brasiliensis | |
| 27547510 | 27547510 | PRJNA1242190_S_NODE_7764_length_305_cov_2.887931_g7757_i0 | PRJNA1242190 | 7764 | 305 | 2.887931 | 8.80818955 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 44.7 | 0.0151 | NR | XP_025595858.1 | 58919 | g7757 | i0 | 49.2 | 0.580327868852459 | 59 | 27 | 55.1 | 2 | 301 | 134 | 306 | 364 | XP_025595858.1 hypothetical protein FA09DRAFT_335231 [Tilletiopsis washingtonensis] | diamond | 177 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 29189534 | 29189534 | PRJNA1242190_S_NODE_3249_length_434_cov_5.603878_g3242_i0 | PRJNA1242190 | 3249 | 434 | 5.603878 | 24.32083052 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 123 | 4.25e-33 | NR | KAG8920536.1 | 2600225 | g3242 | i0 | 50.8 | 0.898617511520737 | 130 | 60 | 87.1 | 1 | 5 | 382 | 6 | 135 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 390 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 | |
| 32350040 | 32350040 | PRJNA1242190_S_NODE_2359_length_481_cov_3.995098_g2352_i0 | PRJNA1242190 | 2359 | 481 | 3.995098 | 19.21642138 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 110 | 1e-27 | NR | KAG8920536.1 | 2600225 | g2352 | i0 | 47.5 | 2.20790020790021 | 122 | 64 | 76.1 | 0 | 476 | 111 | 6 | 127 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 1062 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 |
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);;