contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 839741 | 839741 | PRJNA853194_S_NODE_12801_length_537_cov_4.387931_g6459_i1 | PRJNA853194 | 12801 | 537 | 4.387931 | 23.56318947 | Melanopsichium pennsylvanicum | 63383 | Fungi | Fungi | 54.7 | 0.015 | NTclustered | gi|673530026|emb|HG529683.1| | 1398559 | g6459 | i1 | 96.875 | 0.0595903165735568 | 32 | 1 | 6 | 0 | 431 | 462 | 200790 | 200821 | Melanopsichium pennsylvanicum 4 genomic scaffold, scaffold SCAFFOLD3 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 840252 | 840252 | PRJNA853194_S_NODE_36301_length_352_cov_8.293907_g35210_i0 | PRJNA853194 | 36301 | 352 | 8.293907 | 29.19455264 | Melanopsichium pennsylvanicum | 63383 | Fungi | Fungi | 54.7 | 0.009 | NTclustered | gi|673530026|emb|HG529683.1| | 1398559 | g35210 | i0 | 96.875 | 0.409090909090909 | 32 | 1 | 9 | 0 | 250 | 281 | 200821 | 200790 | Melanopsichium pennsylvanicum 4 genomic scaffold, scaffold SCAFFOLD3 | blastn | 144 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 5943580 | 5943580 | PRJNA853194_S_NODE_40785_length_336_cov_1.475285_g39694_i0 | PRJNA853194 | 40785 | 336 | 1.475285 | 4.9569576 | Wallemia ichthyophaga | 245174 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|685940490|ref|XM_009267438.1| | 1299270 | g39694 | i0 | 100 | 0.172619047619048 | 30 | 0 | 9 | 0 | 20 | 49 | 379 | 408 | Wallemia ichthyophaga EXF-994 Calcium/calmodulin-dependent protein kinase type I (J056_000040), partial mRNA | blastn | 58 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia ichthyophaga | |
| 7218748 | 7218748 | PRJNA853194_S_NODE_53146_length_299_cov_1.212389_g52055_i0 | PRJNA853194 | 53146 | 299 | 1.212389 | 3.62504311 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.028 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g52055 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 0 | 272 | 299 | 30 | 3 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 9767954 | 9767954 | PRJNA853194_S_NODE_19628_length_451_cov_1.351852_g18538_i0 | PRJNA853194 | 19628 | 451 | 1.351852 | 6.09685252 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.044 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g18538 | i0 | 100 | 0.0620842572062084 | 28 | 0 | 6 | 0 | 1 | 28 | 5 | 32 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 11044791 | 11044791 | PRJNA853194_S_NODE_81349_length_246_cov_0.861272_g80258_i0 | PRJNA853194 | 81349 | 246 | 0.861272 | 2.11872912 | Suillus luteus | 5384 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g80258 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 218 | 246 | 31 | 3 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 14868547 | 14868547 | PRJNA853194_S_NODE_50972_length_305_cov_0.987069_g49881_i0 | PRJNA853194 | 50972 | 305 | 0.987069 | 3.01056045 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.028 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g49881 | i0 | 100 | 0.0918032786885246 | 28 | 0 | 9 | 0 | 1 | 28 | 3 | 30 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 19966761 | 19966761 | PRJNA853194_S_NODE_34716_length_359_cov_2.353147_g33625_i0 | PRJNA853194 | 34716 | 359 | 2.353147 | 8.44779773 | Vanrija albida | 181172 | Fungi | Fungi | 52.8 | 0.034 | NTclustered | gi|2837747246|ref|XM_069356722.1| | 181172 | g33625 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 9 | 36 | 41 | 14 | Vanrija albida C-4 sterol methyl oxidase (ERG25_2), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija albida | |
| 22516757 | 22516757 | PRJNA853194_S_NODE_25138_length_409_cov_2.452381_g24047_i0 | PRJNA853194 | 25138 | 409 | 2.452381 | 10.03023829 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.039 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g24047 | i0 | 100 | 0.0684596577017115 | 28 | 0 | 7 | 0 | 1 | 28 | 3 | 30 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 23793268 | 23793268 | PRJNA853194_S_NODE_75619_length_252_cov_2.128492_g74528_i0 | PRJNA853194 | 75619 | 252 | 2.128492 | 5.36379984 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 228 | 3.5399999999999984e-55 | NTclustered | gi|1022860564|ref|XM_016417716.1| | 1130832 | g74528 | i0 | 83.004 | 3.8968253968254 | 253 | 41 | 100 | 2 | 1 | 252 | 128 | 379 | Rhodotorula toruloides NP11 60S ribosomal protein l24 (RHTO_04048), partial mRNA | blastn | 982 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 23793485 | 23793485 | PRJNA853194_S_NODE_87879_length_226_cov_2.823529_g86788_i0 | PRJNA853194 | 87879 | 226 | 2.823529 | 6.38117554 | Malassezia globosa | 76773 | Fungi | Fungi | 412 | 8.01e-111 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g86788 | i0 | 99.558 | 43.5884955752212 | 226 | 1 | 100 | 0 | 1 | 226 | 30054 | 29829 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 9851 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa |
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);;