contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA339266" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1666008 | 1666008 | PRJNA339266_P_NODE_8242_length_153_cov_4.000000_g8212_i0 | PRJNA339266 | 8242 | 153 | 4 | 6.12 | Malassezia globosa | 76773 | Fungi | Fungi | 147 | 5.589999999999999e-31 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g8212 | i0 | 100 | 10.1503267973856 | 79 | 0 | 87 | 0 | 1 | 79 | 2781 | 2859 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 1553 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 1666239 | 1666239 | PRJNA339266_S_NODE_4682_length_218_cov_2.447514_g4671_i0 | PRJNA339266 | 4682 | 218 | 2.447514 | 5.33558052 | Malassezia restricta | 76775 | Fungi | Fungi | 231 | 2.3099999999999997e-56 | NTclustered | gi|1546635923|ref|XM_027629604.1| | 76775 | g4671 | i0 | 98.473 | 1.04587155963303 | 131 | 2 | 94 | 0 | 14 | 144 | 1 | 131 | Malassezia restricta parafibromin (MRET_2977), partial mRNA | blastn | 228 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8722428 | 8722428 | PRJNA339266_P_NODE_6527_length_172_cov_1.614815_g6497_i0 | PRJNA339266 | 6527 | 172 | 1.614815 | 2.7774818 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 318 | 1.2899999999999999e-82 | NTclustered | gi|671394780|gb|KJ806312.1| | 5288 | g6497 | i0 | 100 | 99.9767441860465 | 172 | 0 | 100 | 0 | 1 | 172 | 736 | 907 | Rhodosporidium diobovatum isolate H-5 18S ribosomal RNA gene, partial sequence | blastn | 17196 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 13823321 | 13823321 | PRJNA339266_S_NODE_4211_length_223_cov_7.876344_g4200_i0 | PRJNA339266 | 4211 | 223 | 7.876344 | 17.56424712 | Agaricales | 5338 | Fungi | Fungi | 363 | 8.049999999999997e-96 | NTclustered | gi|358679416|gb|JQ045879.1| | 5350 | g4200 | i0 | 95.982 | 100.273542600897 | 224 | 7 | 100 | 2 | 1 | 223 | 270 | 48 | Coprinopsis radiata strain SZMC-NL-1269 28S ribosomal RNA (LSU) gene, partial sequence | blastn | 22361 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis radiata | |
| 16968684 | 16968684 | PRJNA339266_P_NODE_4394_length_189_cov_4.309211_g4364_i0 | PRJNA339266 | 4394 | 189 | 4.309211 | 8.14440879 | Trametes versicolor | 5325 | Fungi | Fungi | 121 | 4.38e-23 | NTclustered | gi|636622788|ref|XM_008044338.1| | 717944 | g4364 | i0 | 93.75 | 0.423280423280423 | 80 | 5 | 42 | 0 | 2 | 81 | 325 | 404 | Trametes versicolor FP-101664 SS1 uncharacterized protein (TRAVEDRAFT_23145), partial mRNA | blastn | 80 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor | |
| 23343500 | 23343500 | PRJNA339266_S_NODE_3259_length_238_cov_4.960199_g3248_i0 | PRJNA339266 | 3259 | 238 | 4.960199 | 11.80527362 | Coprinellus micaceus | 71717 | Fungi | Fungi | 385 | 1.86e-102 | NTclustered | gi|2088246494|ref|NC_057083.1| | 71717 | g3248 | i0 | 95.798 | 104.411764705882 | 238 | 10 | 100 | 0 | 1 | 238 | 18990 | 18753 | Coprinellus micaceus mitochondrion, complete genome | blastn | 24850 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus micaceus | |
| 24021633 | 24021633 | PRJNA339266_S_NODE_5779_length_206_cov_4.248521_g5768_i0 | PRJNA339266 | 5779 | 206 | 4.248521 | 8.75195326 | Basidiomycota | 5204 | Fungi | Fungi | 375 | 9.41e-100 | NTclustered | gi|1256909|dbj|D38239.1|BENJCM2896 | 4996 | g5768 | i0 | 99.515 | 100 | 206 | 1 | 100 | 0 | 1 | 206 | 762 | 967 | Bensingtonia yamatoana (strain JCM 2896) gene for 18S rRNA | blastn | 20600 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Chrysozymaceae | Bannozyma | Bannozyma yamatoana |
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);;