contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1085664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193572 | 193572 | PRJNA1085664_S_NODE_33241_length_155_cov_1.258929_g32822_i0 | PRJNA1085664 | 33241 | 155 | 1.258929 | 1.95133995 | Malassezia restricta | 76775 | Fungi | Fungi | 270 | 3.23e-68 | NTclustered | gi|1546632162|ref|XM_027627741.1| | 76775 | g32822 | i0 | 98.065 | 1 | 155 | 3 | 100 | 0 | 1 | 155 | 2105 | 2259 | Malassezia restricta heat shock 70kDa protein 4 (MRET_1114), partial mRNA | blastn | 155 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 2744243 | 2744243 | PRJNA1085664_S_NODE_24423_length_178_cov_1.555556_g24004_i0 | PRJNA1085664 | 24423 | 178 | 1.555556 | 2.76888968 | Suillus luteus | 5384 | Fungi | Fungi | 52.8 | 0.015 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g24004 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 151 | 178 | 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 | |
| 4020139 | 4020139 | PRJNA1085664_S_NODE_30984_length_160_cov_1.153846_g30565_i0 | PRJNA1085664 | 30984 | 160 | 1.153846 | 1.8461536 | Malassezia restricta | 76775 | Fungi | Fungi | 285 | 1.2e-72 | NTclustered | gi|1546635837|ref|XM_027629561.1| | 76775 | g30565 | i0 | 98.75 | 1 | 160 | 2 | 100 | 0 | 1 | 160 | 1299 | 1140 | Malassezia restricta tyrosyl-tRNA synthetase (MRET_2934), partial mRNA | blastn | 160 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6571427 | 6571427 | PRJNA1085664_S_NODE_21166_length_190_cov_1.918367_g20747_i0 | PRJNA1085664 | 21166 | 190 | 1.918367 | 3.6448973 | Psilocybe cubensis | 181762 | Fungi | Fungi | 145 | 2.6199999999999997e-30 | NTclustered | gi|2234837769|ref|XM_047887730.1| | 181762 | g20747 | i0 | 87.805 | 8.63157894736842 | 123 | 15 | 65 | 0 | 1 | 123 | 469 | 591 | Psilocybe cubensis uncharacterized protein (JR316_0001932), partial mRNA | blastn | 1640 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cubensis | |
| 10396823 | 10396823 | PRJNA1085664_S_NODE_13289_length_238_cov_2.548718_g12870_i0 | PRJNA1085664 | 13289 | 238 | 2.548718 | 6.06594884 | Hericium alpestre | 135208 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2489641794|ref|NC_073556.1| | 135208 | g12870 | i0 | 96.97 | 0.714285714285714 | 33 | 1 | 14 | 0 | 31 | 63 | 27974 | 27942 | Hericium alpestre mitochondrion, complete genome | blastn | 170 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre | |
| 16770501 | 16770501 | PRJNA1085664_S_NODE_26594_length_171_cov_2.601562_g26175_i0 | PRJNA1085664 | 26594 | 171 | 2.601562 | 4.44867102 | Rhizopogon vinicolor | 80600 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1693287358|ref|NC_042699.1| | 80600 | g26175 | i0 | 87.5 | 0.280701754385965 | 48 | 4 | 28 | 2 | 92 | 139 | 75156 | 75201 | Rhizopogon vinicolor mitochondrion, complete genome | blastn | 48 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Rhizopogonaceae | Rhizopogon | Rhizopogon vinicolor | |
| 17595119 | 17595119 | PRJNA1085664_S_NODE_19634_length_197_cov_1.220779_g19215_i0 | PRJNA1085664 | 19634 | 197 | 1.220779 | 2.40493463 | Agaricomycetes | 155619 | Fungi | Fungi | 198 | 2.07e-46 | NTclustered | gi|636627976|ref|XM_008046932.1| | 717944 | g19215 | i0 | 84.772 | 52.5380710659898 | 197 | 30 | 100 | 0 | 1 | 197 | 385 | 581 | Trametes versicolor FP-101664 SS1 manganese superoxide dismutase (TRAVEDRAFT_175708), partial mRNA | blastn | 10350 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor |
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);;