contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4257903 | 4257903 | PRJNA436017_P_NODE_28064_length_154_cov_1.333333_g27766_i0 | PRJNA436017 | 28064 | 154 | 1.333333 | 2.05333282 | Eukaryota | 2759 | Fungi | Fungi | 96.3 | 1.54e-21 | NR | XP_046040532.1 | 5210 | g27766 | i0 | 86.3 | 87.4285714285714 | 51 | 7 | 99.4 | 0 | 2 | 154 | 117 | 167 | XP_046040532.1 FAD binding domain-containing protein [Filobasidium floriforme] | diamond | 13464 | 96.7 | 0.995863495346432 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 20215310 | 20215310 | PRJNA436017_P_NODE_3216_length_521_cov_3.043388_g2940_i0 | PRJNA436017 | 3216 | 521 | 3.043388 | 15.85605148 | Fungi | 4751 | Fungi | Fungi | 128 | 6.59e-35 | NR | XP_046036820.1 | 5210 | g2940 | i0 | 61 | 13.7735124760077 | 100 | 39 | 57.6 | 0 | 61 | 360 | 12 | 111 | XP_046036820.1 putative 60S ribosomal protein l30-1 [Filobasidium floriforme] | diamond | 7176 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 26617448 | 26617448 | PRJNA436017_P_NODE_10581_length_264_cov_2.718062_g10283_i0 | PRJNA436017 | 10581 | 264 | 2.718062 | 7.17568368 | Fungi | 4751 | Fungi | Fungi | 115 | 1.12e-29 | NR | XP_021874725.1 | 4999 | g10283 | i0 | 66.7 | 8.89772727272727 | 87 | 29 | 98.9 | 0 | 4 | 264 | 87 | 173 | XP_021874725.1 putative 60s ribosomal protein l7 [Kockovaella imperatae] | diamond | 2349 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 28907201 | 28907201 | PRJNA436017_P_NODE_10268_length_269_cov_1.344828_g9970_i0 | PRJNA436017 | 10268 | 269 | 1.344828 | 3.61758732 | Tetrapyrgos nigripes | 182062 | Fungi | Fungi | 69.3 | 2.2e-11 | NR | KAF5344150.1 | 182062 | g9970 | i0 | 42.2 | 1.00371747211896 | 90 | 51 | 99.3 | 1 | 2 | 268 | 265 | 354 | KAF5344150.1 hypothetical protein D9758_008908 [Tetrapyrgos nigripes] | diamond | 270 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Tetrapyrgos | Tetrapyrgos nigripes | |
| 29728123 | 29728123 | PRJNA436017_P_NODE_2190_length_640_cov_2.907131_g1947_i0 | PRJNA436017 | 2190 | 640 | 2.907131 | 18.6056384 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 197 | 1.31e-59 | NR | XP_025600826.1 | 58919 | g1947 | i0 | 53.2 | 6.2390625 | 190 | 86 | 88.1 | 2 | 1 | 564 | 46 | 234 | XP_025600826.1 putative ribosomal protein S3aE [Tilletiopsis washingtonensis] | diamond | 3993 | 197 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 29776278 | 29776278 | PRJNA436017_P_NODE_6731_length_344_cov_1.771987_g6434_i0 | PRJNA436017 | 6731 | 344 | 1.771987 | 6.09563528 | Opisthokonta | 33154 | Fungi | Fungi | 48.5 | 2.25e-4 | NR | XP_052942290.1 | 4972 | g6434 | i0 | 52.5 | 3.41860465116279 | 40 | 19 | 34.9 | 0 | 2 | 121 | 79 | 118 | XP_052942290.1 putative ribosomal protein S20 [Dioszegia hungarica] | diamond | 1176 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 29807862 | 29807862 | PRJNA436017_P_NODE_26991_length_157_cov_1.300000_g26693_i0 | PRJNA436017 | 26991 | 157 | 1.3 | 2.041 | Fungi | 4751 | Fungi | Fungi | 45.8 | 9.63e-4 | NR | TDL18204.1 | 50990 | g26693 | i0 | 62.9 | 4.5859872611465 | 35 | 13 | 66.9 | 0 | 106 | 2 | 816 | 850 | TDL18204.1 DNA mismatch repair protein MutL [Rickenella mellea] | diamond | 720 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Rickenellaceae | Rickenella | Rickenella mellea | |
| 31514637 | 31514637 | PRJNA436017_P_NODE_26996_length_157_cov_1.300000_g26698_i0 | PRJNA436017 | 26996 | 157 | 1.3 | 2.041 | Filobasidiaceae | 5408 | Fungi | Fungi | 60.8 | 7.23e-10 | NR | XP_046032920.1 | 5210 | g26698 | i0 | 66.7 | 1.60509554140127 | 42 | 14 | 80.3 | 0 | 30 | 155 | 1 | 42 | XP_046032920.1 nucleoside diphosphate kinase [Filobasidium floriforme] | diamond | 252 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 32035707 | 32035707 | PRJNA436017_P_NODE_26298_length_159_cov_1.262295_g26000_i0 | PRJNA436017 | 26298 | 159 | 1.262295 | 2.00704905 | Calocera viscosa TUFC12733 | 1330018 | Fungi | Fungi | 48.1 | 1.52e-4 | NR | KZO93738.1 | 1330018 | g26000 | i0 | 46.2 | 0.981132075471698 | 52 | 28 | 98.1 | 0 | 159 | 4 | 119 | 170 | KZO93738.1 WD40 repeat-like protein [Calocera viscosa TUFC12733] | diamond | 156 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Calocera | Calocera viscosa |
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);;