contig_metadata
10 rows where bioproject = "PRJEB6055" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1400011 | 1400011 | PRJEB6055_S_NODE_1502_length_239_cov_7.156863_g1478_i0 | PRJEB6055 | 1502 | 239 | 7.156863 | 17.10490257 | Pucciniomycotina sp. | 2011928 | Fungi | Fungi | 409 | 1.11e-109 | NTclustered | gi|2648564344|gb|PP130148.1| | 2011928 | g1478 | i0 | 97.49 | 100.196652719665 | 239 | 6 | 100 | 0 | 1 | 239 | 59 | 297 | Pucciniomycotina sp. strain FB2-PD4 large subunit ribosomal RNA gene, partial sequence | blastn | 23947 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycotina sp. | |||||
| 2267491 | 2267491 | PRJEB6055_S_NODE_1482_length_240_cov_17.204878_g1458_i0 | PRJEB6055 | 1482 | 240 | 17.204878 | 41.2917072 | Agaricomycetes | 155619 | Fungi | Fungi | 117 | 7.55e-22 | NTclustered | gi|2723225103|dbj|LC813565.1| | 5353 | g1458 | i0 | 83.333 | 53.2083333333333 | 126 | 21 | 53 | 0 | 33 | 158 | 634 | 759 | Lentinula edodes BCRC:MU30948 DNA, clone Type1 | blastn | 12770 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 7369760 | 7369760 | PRJEB6055_S_NODE_4786_length_163_cov_2.414062_g4762_i0 | PRJEB6055 | 4786 | 163 | 2.414062 | 3.93492106 | Agaricomycetes | 155619 | Fungi | Fungi | 92.4 | 2.02e-22 | NR | VWO94102.1 | 34458 | g4762 | i0 | 80.9 | 4.10429447852761 | 47 | 9 | 86.5 | 0 | 2 | 142 | 67 | 113 | VWO94102.1 2-cysteine peroxiredoxin, partial [Ganoderma boninense] | diamond | 669 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 10328582 | 10328582 | PRJEB6055_S_NODE_3009_length_191_cov_2.730769_g2985_i0 | PRJEB6055 | 3009 | 191 | 2.730769 | 5.21576879 | Malassezia restricta | 76775 | Fungi | Fungi | 348 | 1.87e-91 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2985 | i0 | 99.476 | 54.6544502617801 | 191 | 1 | 100 | 0 | 1 | 191 | 3170 | 3360 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 10439 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12471244 | 12471244 | PRJEB6055_S_NODE_5850_length_151_cov_1.974138_g5826_i0 | PRJEB6055 | 5850 | 151 | 1.974138 | 2.98094838 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 274 | 2.42e-69 | NTclustered | gi|386776365|gb|JQ581047.1| | 33191 | g5826 | i0 | 99.338 | 99.9867549668874 | 151 | 1 | 100 | 0 | 1 | 151 | 214 | 64 | Rhodosporidium lusitaniae strain HAI-Y-58 26S ribosomal RNA gene, partial sequence | blastn | 15098 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodosporidiobolus | Rhodosporidiobolus lusitaniae | |
| 17977129 | 17977129 | PRJEB6055_S_NODE_3875_length_176_cov_1.588652_g3851_i0 | PRJEB6055 | 3875 | 176 | 1.588652 | 2.79602752 | Kondoa malvinella | 36055 | Fungi | Fungi | 313 | 6.1699999999999985e-81 | NTclustered | gi|6273180|gb|AF189903.1| | 36055 | g3851 | i0 | 98.864 | 99.3920454545455 | 176 | 1 | 100 | 1 | 1 | 176 | 232 | 58 | Kondoa malvinella culture CBS:6082 26S ribosomal RNA gene, partial sequence | blastn | 17493 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricostilbomycetes | Agaricostilbales | Kondoaceae | Kondoa | Kondoa malvinella | |
| 20526480 | 20526480 | PRJEB6055_S_NODE_1877_length_223_cov_8.143617_g1853_i0 | PRJEB6055 | 1877 | 223 | 8.143617 | 18.16026591 | Moesziomyces rugulosus | 84752 | Fungi | Fungi | 407 | 3.67e-109 | NTclustered | gi|3901107|emb|AJ235300.1| | 84752 | g1853 | i0 | 99.552 | 101.219730941704 | 223 | 1 | 100 | 0 | 1 | 223 | 275 | 53 | Pseudozyma rugulosa (strain CBS 170.88) 26S rRNA gene, partial | blastn | 22572 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces rugulosus | |
| 23077554 | 23077554 | PRJEB6055_S_NODE_2219_length_211_cov_5.704545_g2195_i0 | PRJEB6055 | 2219 | 211 | 5.704545 | 12.03658995 | Marasmius sp. 5 GMB-2014 | 1588974 | Fungi | Fungi | 363 | 7.539999999999999e-96 | NTclustered | gi|757958620|gb|KP013035.1| | 1588974 | g2195 | i0 | 97.63 | 101.943127962085 | 211 | 5 | 100 | 0 | 1 | 211 | 914 | 704 | Marasmius sp. 5 GMB-2014 voucher MEL:2382672 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21510 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius sp. 5 GMB-2014 | |
| 23077567 | 23077567 | PRJEB6055_S_NODE_4359_length_169_cov_1.492537_g4335_i0 | PRJEB6055 | 4359 | 169 | 1.492537 | 2.52238753 | Ceraceosorus guamensis | 1522189 | Fungi | Fungi | 87.8 | 2.51e-19 | NR | XP_025368547.1 | 1522189 | g4335 | i0 | 75 | 0.994082840236686 | 56 | 14 | 99.4 | 0 | 2 | 169 | 166 | 221 | XP_025368547.1 ribosomal protein S3Ae [Ceraceosorus guamensis] | diamond | 168 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Ceraceosorales | Ceraceosoraceae | Ceraceosorus | Ceraceosorus guamensis | |
| 25218357 | 25218357 | PRJEB6055_S_NODE_880_length_287_cov_16.674603_g856_i0 | PRJEB6055 | 880 | 287 | 16.674603 | 47.85611061 | Malassezia | 55193 | Fungi | Fungi | 531 | 2.799999999999999e-146 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g856 | i0 | 100 | 98.9686411149826 | 287 | 0 | 100 | 0 | 1 | 287 | 21 | 307 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 28404 | 531 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;