contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB55250" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23073817 | 23073817 | PRJEB55250_P_NODE_16999_length_233_cov_2.406250_g16875_i0 | PRJEB55250 | 16999 | 233 | 2.40625 | 5.6065625 | root | 1 | Root_unresolved | Root_unresolved | 112 | 3.41e-29 | NR | XP_062791719.1 | 564305 | g16875 | i0 | 74.6 | 9.07725321888412 | 71 | 18 | 91.4 | 0 | 233 | 21 | 104 | 174 | XP_062791719.1 peptidyl-prolyl cis-trans isomerase [Kwoniella shivajii] | diamond | 2115 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 26812095 | 26812095 | PRJEB55250_P_NODE_12981_length_248_cov_0.880000_g12857_i0 | PRJEB55250 | 12981 | 248 | 0.88 | 2.1824 | Kwoniella newhampshirensis | 1651941 | Fungi | Fungi | 159 | 8.88e-44 | NR | XP_066805429.1 | 1651941 | g12857 | i0 | 93.3 | 5.41935483870968 | 75 | 5 | 90.7 | 0 | 248 | 24 | 477 | 551 | XP_066805429.1 hypothetical protein IAR55_001099 [Kwoniella newhampshirensis] | diamond | 1344 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella newhampshirensis | |
| 26963343 | 26963343 | PRJEB55250_P_NODE_9602_length_264_cov_1.612565_g9478_i0 | PRJEB55250 | 9602 | 264 | 1.612565 | 4.2571716 | Tremellales | 5234 | Fungi | Fungi | 144 | 1.28e-37 | NR | RXK37468.1 | 5217 | g9478 | i0 | 76.1 | 17 | 88 | 21 | 100 | 0 | 264 | 1 | 184 | 271 | RXK37468.1 hypothetical protein M231_05291 [Tremella mesenterica] | diamond | 4488 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 27563685 | 27563685 | PRJEB55250_P_NODE_3144_length_376_cov_1.508251_g3020_i0 | PRJEB55250 | 3144 | 376 | 1.508251 | 5.67102376 | Fungi | 4751 | Fungi | Fungi | 111 | 4.73e-26 | NR | PPQ69557.1 | 231916 | g3020 | i0 | 53 | 17.4015957446809 | 115 | 54 | 91.8 | 0 | 1 | 345 | 119 | 233 | PPQ69557.1 hypothetical protein CVT26_001559 [Gymnopilus dilepis] | diamond | 6543 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Gymnopilus | Gymnopilus dilepis | |
| 28353263 | 28353263 | PRJEB55250_P_NODE_12866_length_248_cov_1.760000_g12742_i0 | PRJEB55250 | 12866 | 248 | 1.76 | 4.3648 | Tremellales | 5234 | Fungi | Fungi | 106 | 2.56e-26 | NR | KAK1923741.1 | 5418 | g12742 | i0 | 83.1 | 4.23387096774194 | 59 | 8 | 71.4 | 1 | 70 | 246 | 1 | 57 | KAK1923741.1 hypothetical protein DB88DRAFT_492272 [Papiliotrema laurentii] | diamond | 1050 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 29654220 | 29654220 | PRJEB55250_P_NODE_7810_length_278_cov_1.068293_g7686_i0 | PRJEB55250 | 7810 | 278 | 1.068293 | 2.96985454 | Mycena venus | 2733690 | Fungi | Fungi | 63.2 | 3.43e-9 | NR | KAF7350438.1 | 2733690 | g7686 | i0 | 43.8 | 1.69424460431655 | 64 | 35 | 68 | 1 | 2 | 190 | 277 | 340 | KAF7350438.1 Cytochrome P450 [Mycena venus] | diamond | 471 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena venus | |
| 30374823 | 30374823 | PRJEB55250_P_NODE_15812_length_242_cov_1.822485_g15688_i0 | PRJEB55250 | 15812 | 242 | 1.822485 | 4.4104137 | Agaricomycetes | 155619 | Fungi | Fungi | 103 | 4.3999999999999995e-25 | NR | XP_012183197.1 | 599839 | g15688 | i0 | 92.6 | 6.79338842975207 | 54 | 4 | 66.9 | 0 | 1 | 162 | 191 | 244 | XP_012183197.1 uncharacterized protein FIBRA_06065 [Fibroporia radiculosa] | diamond | 1644 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fibroporiaceae | Fibroporia | Fibroporia radiculosa | |
| 31392571 | 31392571 | PRJEB55250_P_NODE_12016_length_250_cov_0.870056_g11892_i0 | PRJEB55250 | 12016 | 250 | 0.870056 | 2.17514 | Kwoniella shivajii | 564305 | Fungi | Fungi | 118 | 1.22e-28 | NR | XP_062788833.1 | 564305 | g11892 | i0 | 78.5 | 2.34 | 65 | 14 | 78 | 0 | 198 | 4 | 778 | 842 | XP_062788833.1 uncharacterized protein IL334_001022 [Kwoniella shivajii] | diamond | 585 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 31455733 | 31455733 | PRJEB55250_P_NODE_2576_length_410_cov_1.827893_g2453_i0 | PRJEB55250 | 2576 | 410 | 1.827893 | 7.4943613 | Rhodotorula graminis WP1 | 578459 | Fungi | Fungi | 120 | 3.4799999999999993e-31 | NR | XP_018272859.1 | 578459 | g2453 | i0 | 54.8 | 3.82682926829268 | 104 | 47 | 76.1 | 0 | 321 | 10 | 64 | 167 | XP_018272859.1 uncharacterized protein RHOBADRAFT_12232 [Rhodotorula graminis WP1] | diamond | 1569 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 32056644 | 32056644 | PRJEB55250_P_NODE_14378_length_245_cov_1.447674_g14254_i0 | PRJEB55250 | 14378 | 245 | 1.447674 | 3.5468013 | Suillus ampliporus | 1912932 | Fungi | Fungi | 43.9 | 0.0144 | NR | KAG0699371.1 | 1912932 | g14254 | i0 | 36.1 | 0.881632653061225 | 72 | 42 | 84.5 | 3 | 30 | 236 | 172 | 242 | KAG0699371.1 acid protease [Suillus ampliporus] | diamond | 216 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus ampliporus | |
| 32120091 | 32120091 | PRJEB55250_P_NODE_12578_length_249_cov_0.875000_g12454_i0 | PRJEB55250 | 12578 | 249 | 0.875 | 2.17875 | Malassezia nana | 180528 | Fungi | Fungi | 130 | 2.8999999999999993e-33 | NR | WFD25918.1 | 180528 | g12454 | i0 | 70.7 | 3.95180722891566 | 82 | 24 | 98.8 | 0 | 2 | 247 | 118 | 199 | WFD25918.1 hypothetical protein MNAN1_000888 [Malassezia nana] | diamond | 984 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana |
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);;