contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3110837 | 3110837 | PRJNA575566_P_NODE_13923_length_282_cov_1.158371_g13726_i0 | PRJNA575566 | 13923 | 282 | 1.158371 | 3.26660622 | Tremellomycetes | 155616 | Fungi | Fungi | 152 | 1.8199999999999999e-40 | NR | GHJ87648.1 | 104408 | g13726 | i0 | 70.7 | 15.6276595744681 | 92 | 27 | 97.9 | 0 | 280 | 5 | 16 | 107 | GHJ87648.1 hypothetical protein NliqN6_4050 [Naganishia liquefaciens] | diamond | 4407 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 8213023 | 8213023 | PRJNA575566_P_NODE_14307_length_278_cov_1.364055_g14110_i0 | PRJNA575566 | 14307 | 278 | 1.364055 | 3.7920729 | Basidiomycota | 5204 | Fungi | Fungi | 121 | 6.93e-33 | NR | KAJ8293786.1 | 5286 | g14110 | i0 | 59.3 | 8.8705035971223 | 91 | 37 | 98.2 | 0 | 277 | 5 | 65 | 155 | KAJ8293786.1 Ubiquitin-40S ribosomal protein S27a [Rhodotorula toruloides] | diamond | 2466 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 26618266 | 26618266 | PRJNA575566_P_NODE_14781_length_274_cov_1.201878_g14584_i0 | PRJNA575566 | 14781 | 274 | 1.201878 | 3.29314572 | Opisthokonta | 33154 | Fungi | Fungi | 78.6 | 1.3e-14 | NR | CEQ39742.1 | 5005 | g14584 | i0 | 80.4 | 13.6970802919708 | 46 | 9 | 50.4 | 0 | 135 | 272 | 164 | 209 | CEQ39742.1 SPOSA6832_01284 [Sporobolomyces salmonicolor] | diamond | 3753 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 27725306 | 27725306 | PRJNA575566_P_NODE_30384_length_191_cov_2.100000_g30187_i0 | PRJNA575566 | 30384 | 191 | 2.1 | 4.011 | Fungi | 4751 | Fungi | Fungi | 91.3 | 1.5e-19 | NR | CDZ96739.1 | 264483 | g30187 | i0 | 67.8 | 11.1832460732984 | 59 | 18 | 92.7 | 1 | 2 | 178 | 408 | 465 | CDZ96739.1 eukaryotic translation elongation factor 2 [Phaffia rhodozyma] | diamond | 2136 | 92 | 0.992391304347826 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Phaffia | Phaffia rhodozyma | |
| 28293153 | 28293153 | PRJNA575566_P_NODE_21706_length_224_cov_1.092025_g21509_i0 | PRJNA575566 | 21706 | 224 | 1.092025 | 2.446136 | Eukaryota | 2759 | Fungi | Fungi | 79.3 | 1.75e-16 | NR | ORY92463.1 | 106004 | g21509 | i0 | 56.8 | 2.97321428571429 | 74 | 32 | 99.1 | 0 | 3 | 224 | 12 | 85 | ORY92463.1 PCI domain-domain-containing protein [Leucosporidium creatinivorum] | diamond | 666 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium creatinivorum | |
| 30977920 | 30977920 | PRJNA575566_P_NODE_9174_length_345_cov_1.200704_g8977_i0 | PRJNA575566 | 9174 | 345 | 1.200704 | 4.1424288 | Fungi | 4751 | Fungi | Fungi | 112 | 1.46e-28 | NR | KAH9983893.1 | 40490 | g8977 | i0 | 55 | 20.2608695652174 | 111 | 43 | 94.8 | 2 | 328 | 2 | 49 | 154 | KAH9983893.1 ribosomal protein S19-domain-containing protein [Russula compacta] | diamond | 6990 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula compacta | |
| 32116419 | 32116419 | PRJNA575566_P_NODE_8758_length_354_cov_1.218430_g8561_i0 | PRJNA575566 | 8758 | 354 | 1.21843 | 4.3132422 | Fungi | 4751 | Fungi | Fungi | 73.6 | 4.29e-14 | NR | ORY28810.1 | 71784 | g8561 | i0 | 64.9 | 2.80508474576271 | 57 | 20 | 48.3 | 0 | 4 | 174 | 16 | 72 | ORY28810.1 60s acidic ribosomal protein-domain-containing protein [Naematelia encephala] | diamond | 993 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 32527870 | 32527870 | PRJNA575566_P_NODE_3199_length_579_cov_1.606178_g3004_i0 | PRJNA575566 | 3199 | 579 | 1.606178 | 9.29977062 | Eukaryota | 2759 | Fungi | Fungi | 180 | 1.89e-52 | NR | XP_021872123.1 | 4999 | g3004 | i0 | 50.6 | 31.4559585492228 | 168 | 83 | 87 | 0 | 578 | 75 | 107 | 274 | XP_021872123.1 putative 60S acidic ribosomal protein [Kockovaella imperatae] | diamond | 18213 | 181 | 0.994475138121547 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae |
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);;